ETL and Report developer Resume

SUMMARY

Around 3+years of experience in IT industry as a Software Engineer in implementation of Data warehousing projects with MSBI as Developer.
In my tenure worked and working with various documents like Source Map, Source to Target, LLD, Change Request (CR), Unit Test and Defect Sheet docs according to the project. Worked on various MSBI versions 2008, 2008R2.
Created and modified many packages and reports according to the business demand with the given transformation or business logics.
Create Database Objects Such as tables
Identifying long running SQL queries, packages, reports etc..., implementing appropriate tuning methods.
Writing Complex T - SQL Statements, Stored procedures, functions.
Did data reconciliation across source system tables and files by firing various queries.
Worked with various transformations (lookup, multicast, conditional split, derived column, merges etc) control flow tasks and containers (for loop, for each loop, execute SQL, script etc...).
Implemented logging, event handling, transactions are required.
Loaded data into various tables through incremental, SCD approaches.
Created various types of simple, complex, parameterized, Action reports.
Worked with partial dash board, drill down and drill through reports.
Good knowledge on Snapshots, Caches, Subscriptions and other reporting concepts.
Written Unit Test cases and submittedUnit test resultsas per the quality process.
Good knowledge in SQL Server 2012
Generating various types of Crystal Reports.
Having good knowledge in Microsoft .NET technologies (VB.net, C#.net), .NET Framework 3.5, SQL Server 2008R2.
Writing Complex T-SQL Statements, Stored procedures, functions.
Maintained versioning inVSS, and used variousConfiguration Files..

TECHNICAL SKILLS

Operating System: Windows 2003,2000,XP

ETL Tool: SQL Server Integration Services (SSIS) 2008 R2

Reporting Tool: SQL Server Reporting Service (SSRS) 2008 R2

Database: SQL Server 2008 R2

Languages: Vb.Net

Internet Technologies: Microsoft .NET 2.0, ASP.NET, HTML

PROFESSIONAL EXPERIENCE

Confidential

Environment: SSIS, SSRS, SQL SERVER 2008

Responsibilities:

An Associate I involved in getting docs understanding, analyzing, creating and manipulating various packages and queries according to those.
In case of changes we followCR documentprocedure of the client
I prepared several types of documents (Technical, Unit test) required for the project.
Different types of Data Loading (Direct, Incremental, SCD) implemented using packages and used configuration files.
Handled errors in packages and reported errors in error tables. Identified long running packages and did tuning according to thebottlenecks.Written manyUnit test casesand Implemented Unit test results.
Worked with various Control Flow items(For Loop, For Each loop, Sequence, Execute SQL task, File System task) and Data Flow items (Flat File and oledb source and OLEDB destination, Derived column, Sort, Lookup, Conditional Split, Multicast etc...).
Getting the business documents, understanding and analyzing the documents. Preparing wireless workflow low-level logical documents. Participating internal and external meetings.
Identifying long running reports and eliminating the bottle necks by tuning the performance issues.
Writing T-SQL statements, Stored Procedure, Sub queries, Joins, Views.
Creating operational (OLTP), analytical (OLAP) reports, and various types of reports (Drill down, drill through, linked reports, sub reports cross tab reports)
According to the situation created subscriptions, snapshot and linked reports.
Worked with chart, matrix, list and table.

Confidential

Environment: SSIS, SSRS, SQL SERVER 2008

Responsibilities:

Understanding the business documents, participating the report designing.
According to the situation created subscriptions, snapshot and linked reports.
Worked with different parameterized reports.
Implemented different actions.
Created drill down drill through reports.
Worked with report builder, report server project for generating report.
Worked with chart, matrix, list and table reports

Confidential

ETL and Report developer

Environment: SQL Server 2005, SSRS, SSIS.

Responsibilities:

Extensively working on data Extraction, Transformation and Loading from source to target system using SQL Server 2005 Integration Services
Creating Packages on SSIS Transformations and Mappings using Data Flow Tasks and Control Flow Tasks.
Writing the Stored Procedures which meet the requirements.
Developing various types report features.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship