Thursday, November 17, 2011

Resume for 3 years


Narayan
Email: nagella4@gmail.com                                        Mobile: 9016051445
                                                            
Professional Summary:
Having 3+ years of professional software development experience in the areas of Microsoft Business Intelligence (MSBI) and Having Knowledge in Data Warehousing (DW) applications primarily using Microsoft SQL Server 2005/2008 stack.
  • Equal competence Integration Services, Reporting Services and Analysis Services.
  • Hands on experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).
  • Hands on experience in SQL Server Reporting Service (SSRS).
  • Hands on experience in scheduling and deploying reports on report manger.
  • Having knowledge in Dimensional Data Modeling ,Cube development and manipulations  in SQL Server Analysis Services (SSAS).
  • Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.
  • Highly motivated, quick learner and extremely versatile. Accepts responsibilities and job duties eagerly with minimal supervision required.
  • Implementing and maintaining existing systems. Fixing some of legacy bugs which are client specific (CR’s).
  • Expertised in writing Unit test cases and rendering Unit test results.
  • Good knowledge on Subqueries,Joins,set operations and stored procedures.
  • Hands of experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages.
Professional Experience:

·         Working as a Software Developer for CIBER India Pvt Ltd.from Nov-2009 to till date on MSBI Tools.

·         Working as a Software Developer for RAM INFORMATICS from Nov-2007 to Sept-2009 on MSBI Tools.



Educational Qualification:

Bachelor of Science in Electronics from Sri Krishnadevaraya University.

Core Competencies:

Operating System          : Windows Family,
ETL Tool                        : SQL Server Integration Services (SSIS),
Reporting Tool               : SQL Server Reporting Service (SSRS),

Project 1: 
Project Title                : Man Power Mgt System,
Client                           : CIBER,
Role                                       : Team Member,
Duration                      : Nov 09 to till date,

Business Objectives:

 CIBER Data Warehouse acquires data from the various data sources of the company and insert or update data into Data warehouse. This data warehouse allows the Management for effective decision-making and to transform product centric approach to customer centric approach to gain competitive advantage by combining data from different sources. The company has heterogeneous data stores and operational systems supporting its operational infrastructure. The data is being loading from various source systems like People Soft, Pipeline, Recruitment, etc. Then transformed into the data warehouse and is used to generate valuable and intelligent reports. This process will be done by using SQL Server Data warehouse.

Role & Responsibilities:

  • Responsible for getting, understanding the business specs, preparing technical Specs, DTS Packages.
·         Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.
·         Creating jobs for scheduling the SSIS packages.
  • Getting data from different data sources.
  • Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, etc.
  • Loading these data into data warehouse like sql server.
  • By using these data warehouse, based on client requirement we generate the multilingual reports in SSRS.
  • Identifying of performance bottlenecks, Performance tuning of packages.

Environment : Data Transformation Services (DTS), SQL Server integration Services (SSIS), SQL Reporting Services (SSRS), SQL Server 2005, Windows Server 2000/2003.

Project 2: 
Project Title                : ICICI Prudential Application Mgt System,
Client                           : ICICI Prudential,
Role                                       : Team Member,
Duration                      : Feb 09 to Sept 09,

Business Objectives:

 ICICI Prudential is a joint venture between ICICI Bank and Prudential plc engaged in the business of life insurance in India , Prudential is a leading international financial services group head quartered in the UK... ICICI prudential Data Warehouse acquires data from the various data sources of the company and insert or update data into Data warehouse. The company has heterogeneous data store and operational systems supporting its operational infrastructure. The data is being loading from various source systems like Life Asia (LA), Gold Mine (GM), Agency Management System (AMS), Training Management System (TMS), Pay+, WEGA etc and vice versa. Data is extracted from these sources, transformed and fed into the data warehouse and is used to generate valuable and intelligent reports. Using SSIS to do data extraction, transformation and loading in to the SQL Server Data warehouse.


Role & Responsibilities:

·         Analyzing the requirements and design documents and understanding the functionality of both source and target systems.
·         Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.
·         Created systems for capturing error data in flat file using flat file destination, sending the error data in flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data.
  • Created Jobs and implemented it, Reconciliation across various source systems.
·         Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.
  • Identifying the bottlenecks (in sources, targets, and packages) and tuning it. 
  • Created simple reports for the end user delivery purpose.

Environment: SQL Server Integration Services (SSIS), Windows Server 2000/2003, SQL Server 2005/2008, SQL Server Reporting Services (SSRS).

Project 3:
  Project Title                 : RAJiv Internet Village (E-seva),
  Client                           : Times NGO,                                                 
  Role                             : Team Member,
  Duration                       : Nov 07 to Jan 09,

Business Objectives:

Govt. of AP aims to make its services affordable, transparent and accessible to the rural population through the rural initiative, launched as the: RAJiv Internet Village Programmed. This is an e-commerce project. Through RIV centers rural people can access all G2C, G2B & B2C services in an integrated manner in order to create better means of livelihood and improve the quality of life. The idea working behind this project is to make some services reasonable, translucent and easy to get to the rural residents. It deals with Electricity Bill Payments, Land Revenue Payments, and Water Taxes, Tax Payments, and BSNL Telephone bill Payments and Many More services.

Role & Responsibilities:

·         Importing Source/Target tables from the respective databases by using Execute Package Task& using Control Tasks in SQL Server 2005 Integration services.
·         Development of packages according to the ETL specifications for the staging area & Warehouse data loading using SQL Server Integration Services & SQL Server 2005.
·         Used transformations like Derive Column, Conditional Split, Aggregate, Row Count, and sort and execute SQL Task to load data into Data Warehouse.
  • Created Event Handlers to Handling Errors and Debugging for the Packages.
  • Created Jobs and implemented it for scheduling the SSIS packages on a daily basis.
  • Implemented unit testing.

Environment: Windows Server 2003, SQL Server Integration Services (SSIS), SQL Server 2005, SQL Server Reporting Services (SSRS).

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.