MSBI Developer. Resume,

SUMMARY

A “Developer” wif 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 teh 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 wif 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 noledge 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.

TECHNICAL SKILLS

Research, define and deploy BI improvement opportunities and streamline teh 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.
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.

PROFESSIONAL EXPERIENCE

MSBI Developer.

Confidential,

Responsibilities:

Creating teh packages and usage in SSIS wif slowly changing Dimensions.
Creating complex SSIS packages using proper control and data flow elements.
Importing Source/Target tables from teh 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 teh 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 teh 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 teh client requirements.
Deploying teh generated reports on production server.
Indexes, views, stored procedures and triggers are used using teh SQL Server.
Involved in teh maintenance and support operations.
Coordinating wif onsite folks and monitoring teh offshore team.
Unit tested teh packages.
PERSONAL DOSSIER
Date of Birth: 26/01/1990
Address: Bangalore.
Languages Known: English, Telugu and Hindi.
Hobbies: Playing Chess.

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

We provide IT Staff Augmentation Services!

,

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship