SUMMARY:

• A “Developer” with an experience of 1 years in IT Industry that comprise 2 months as .Net Application Developerand 10 months as Business Intelligence Developer in Development, Staging and Production Environments.
• Strong working experience on SQL Server Integration Services (SSIS) in designing and developing the packages (ETL) from different sources as per business rules.
• Good Experience on various Control Flow tasks such as For each loop Containers, Data Flow task, File System etc. and Data transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, Multicast, Conditional split, Derived column etc.
• Having extensive working experience especially on SQL Server Reporting Services (SSRS) and Report Manager.
• Created different kinds of reports like Table, Matrix, Chart, Cascaded reports as per business rules and having good experience with Report builder.
• Good Experience in using SQL Server 2005/2008 databases
• Excellent SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, query optimization.
• Experience in Managing Jobs, Alerts, SQL Server Agent and Scheduled SSIS Packages.
• Supported team in resolving SQL Reporting services and ETL related issues.
• Involved in performance tuning at different levels (Package, Source, Destination and Transformation).
• Good knowledge on SQL Server Analysis Services, Modeling schemas and Mdx Queries and DQS.
• Excellent communication and inter - personal skills.
• Capable of performing under minimal supervision, multi-tasking, meet deadlines as an individual contributor and a committed team player.

FUNCTIONAL SKILLS:

• Research, define and deploy BI improvement opportunities and streamline the business intelligence processes.
• Creating complex SSIS packages for ETL processes using proper control and data flow elements.
• Create detail design, work on development and perform code reviews.
• Analysis & implementation of better performance strategies.
• Designing and Implementing Reports and preparing technical documentation.

TECHNICAL SKILLS:

BI Data Warehouse Tools: SSIS, SSRS, SSAS (Integration, Reporting and Analysis) Tools.

RDBMS: SQL Server 2005/2008, MS-Access.

Languages: SQL.

Platforms/OS: Windows.

Versioning Tools: SVN

Project Management: MS-Project, MS-Office 2003/2007/2010

Others: Visual Studio 2008/2010.

ORGANISATIONAL SCAN:

Confidential

MSBI Developer

Environment: SSIS, SSRS and SSAS, SQL Server 2008.

Responsibilities:

• Creating the packages and usage in SSIS with slowly changing Dimensions.
• Creating complex SSIS packages using proper control and data flow elements.
• Importing Source/Target tables from the respective databases by using Execute SQL Task using Control Tasks in SQL Server 2008 Integration services.
• Worked on various Control Flow tasks such as For each loop Containers, Data Flow task, File System etc. and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, Multicast, Conditional split, Derived column etc.
• Importing Source/Target tables from the respective databases by using Execute SQL Task using Control Tasks in SQL Server 2008 Integration services.
• Implemented SCDs while history maintenance in tables.
• Worked on creating Event Handlers for the Packages Using Event Handler Tab.
• Processed data in dimensions and facts, actions on cube.
• Understand Report Specification document and designing different kinds of reports based on Report Specification document which meets the client requirements.
• Deploying the generated reports on production server.
• Indexes, views, stored procedures and triggers are used using the SQL Server.
• Involved in the maintenance and support operations.
• Coordinating with onsite folks and monitoring the offshore team.
• Unit tested the packages.