Senior Developer Resume

SUMMARY:

Over 6.1 Years of experience in MSBI development (T - SQL, SSIS, SSRS, SSAS, MDX).
Proficient in Creating, Configuring ETL workflows designed in MS SQL Server Integration Services (SSIS).
Writing C# Code according to the requirements.
Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports (SSRS).
Experienced in create cubes using dimensions and fact tables and generating reports using MDX Queries from Cubes (SSAS).
Experienced in SQL Server DBA.

PROFESSIONAL EXPERIENCE:

Senior Developer

Confidential

Responsibilities:

Involved in the analysis of the requirements
Created packages using different tasks and transformations to achieve the desired results.
Used different data access modes while using OLEDB source like SQL Command, SQL Command through variable and table or view mode as part of performance improvement and to make packages more dynamic
Extensively used precedence constraints to control the process of dependencies and to control the flow based on success, failure or completion of the loads.
Used expression language on different tasks to capture and populate the values dynamically.
Created SSIS Variables for dynamic execution of packages
Tested packages to ensure the business requirements are properly implemented.
Worked on package logging and configurations before deploying them
Tuning of packages at different levels like in control flow, data flow etc...
Involved in unit testing against the developed packages.

Environment: MS SQL Server 2008 R2,T-SQL,SSIS, C#.net.

Confidential

Responsibilities:

Analyzing the Existing System and Understanding the business requirement.
Developing OLAP Cubes by using SQL Server Analysis Services (SSAS).
Involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, developed reports using MDX and SQL
Involving creation of Cubes, Dimensions and Calculated Measures.
Generated various reports with drilldowns, drill through, calculated members, and dropdowns from the cubes by connecting to Analysis server and SQL Server from SSRS.
Creating different types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
Generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment: MS SQL Server 2008R2, SSRS, T-SQL,SSAS,MDX.

Confidential

Responsibilities:

Primarily involved in understanding the business requirements.
Developed various packages as per the business requirements.
Designed and developed various blocked and un-blocked transformations according to the business requirements.
Worked with heterogeneous sources such as flat files and relational sources.
Performed unit test against the packages developed.
Validated the packages and transformations.

Environment: MS SQL Server 2008R2,T-SQL,SSIS, C#.

Confidential

Responsibilities:

Extensively working in data Extraction, Transformation and Loading from source to target system usingSql Server 2008 Integration Services.
Analyzing the Existing System and Understanding the business requirement.
Created Transformations and Mappings using Data Flow Tasks.
Created Event Handlers for the Packages Using Event Handler Tab.
Extensively used Derive Column, Row Count, Data Conversion, Conditional Split, Lookup, SCD, and Aggregate.

Environment: MS SQL Server 2008, SSIS, T-SQL.

Confidential

Responsibilities:

Extensively working in data Extraction, Transformation and Loading from source to target system using Sql Server 2005 Integration Services.
Analyzing the Existing System and Understanding the business requirement.
Importing Source/Target tables from the respective databases by using Execute Package Task using Control Tasks in SQL Server 2005 Integration services.
Created Event Handlers for the Packages Using Event Handler Tab.
Extensively used Derive Column, Row Count, Data Conversion, Conditional Split and Aggregate.

Environment: MS SQL Server 2005, SSIS, T-SQL, C#,ASP.net.