ETL & Report Developer Resume

OBJECTIVE

Looking forward for a challenging career in an esteemed organization to prove myself by providing best services to teh organization.

SUMMARY

Having 4 years of professional software development experience in teh areas of Microsoft Business Intelligence (MSBI)
Equal competence in 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).
Creation of SSIS packages using different kinds of Sources and Destinations.
Experience in creation of Control Flow Tasks like For loop, For Each, Sequence Container, Script Task, Execute SQL Task, Execute Package Task
Proven proficiency at Data Transformations like Derived Columns, Conditional Split, Sort, Data Conversion, Union All, Merge Join, Aggregate, SCD and OLEDB Command to load data into SQL Server destination.
Experience in managing SSIS packages,execution and deploying packages to teh servers.
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).
Having good knowledge on various SQL built - in functions like Date functions, string functions, aggregate functions etc.
Thorough Knowledge on Data Modeling concepts like Star Schema, Snow Flake, Dimension and Fact Tables.
Implementing and maintaining existing systems. Fixing some of legacy bugs which are client specific (CR’s).
Having eight months experience in cube development.

TECHNICAL SKILLS

ETL Tools: SSIS2005,2008,2012

Reporting Tools: SSRS2005,2008,2012

RDBMS: SQLServer 2005/2008/2012

Web Technologies: ASP.NET,HTML

Operating Systems: Windows NT/XP, Windows 2003

Languages: C,C#.NET

PROFESSIONAL EXPERIENCE

Confidential

ETL & Report Developer

Responsibilities:

Understanding teh traditional database of teh client and understanding teh architecture of teh target Data Warehouse.
Worked wif various Control Flow items (For Each loop, For loop, Sequence containers, Execute SQL Task, File System task and Script Task) and Data Flow items (Flat File, Excel and OLEDB source and destination, Derived Column, Sort, Lookup, Conditional Split, Row Count, Merge join, OLEDB command)
Identifying teh business process requirements.
Loading data into dimension and fact tables by creating SSIS packages.
Creation of packages by using required transformations in SSIS.
Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
Managing SSIS applications Deployment.
Used Event Handlers (On Pre Execute, On Error and On Post Execute) for each package to handle package run status in a Table.
Optimized long running packages to increase teh performance.
Created Configuration file and log files for each package.
Deployed teh report into report server and export teh reports into client reqired format.
Created stored procedures to populate teh data.
Implemented different tuning techniques in teh query level and procedures level.
In teh reports created shared datasources,shared datasets which we will use in report items.
Reports are generated for Reserve Bank of India (RBI) on teh basis of various attributes from teh database.

Confidential

ETL & Report Developer

Responsibilities:

Created packages in SSIS Designer using Control Flow Tasks and Data Flow Transformations to implement Business Rules.
Transformed data from various data sources using OLE DB connection by creating various SSIS Packages.
Using Control Flow elements like Containers, Execute Sql Task, Execute Package Task, File System Task and Send Mail Task etc.
Scheduling And Monitoring teh ETL packages for Daily load in Sql Server Job Agent.
Debugging and Validating teh Data flows and Control Flows
Involved in modifying teh Batch scheduling Job files, Parameter files.

Confidential

ETL & Report Developer

Responsibilities:

Created packages in SSIS Designer using Control Flow Tasks and Data Flow Transformations to implement Business Rules.
Transformed data from various data sources using OLE DB connection by creating various SSIS Packages.
Using Control Flow elements like Containers, Execute Sql Task, Execute Package Task, File System Task and Send Mail Task etc.
Scheduling And Monitoring teh ETL packages for Daily load in Sql Server Job Agent.
Debugging and Validating teh Data flows and Control Flows
Generated teh Reports Weekly and Monthly basis as per teh Client Requirements.
As per Client Requirements, developed teh reports in teh form of Table, Matrix and Chart and Rendering teh Reports in teh form of PDF, EXCEL and CSV to teh Clients.
Involved in modifying teh Batch scheduling Job files, Parameter files.