PROFESSIONAL SUMMARY

• Over 7+ years of IT experience wif specialization in Microsoft Business Intelligence framework (SSIS, SSAS, SSRS, SQL Server).
• Extensive experience in SQL Server 2012/2008/2005 in writing complex stored procedures, Triggers, Schema design, Index, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS) and Crystal Report
• Expert experience wif the concept, design and developmeswent of Logical & Physical Data Marts, Data Warehouse using Star Schema and Snowflake Schema in implementing DSS.
• Expert knowledge and extensive experience using SQL Server Integration Services (SSIS) to perform ETL and data integration processes.
• Experience in building SSIS packages involving ETL process, extracting data from various heterogeneous sources like flat files, Excel files, legacy systems and loading into SQL server.
• Extensive experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Performance Tuning of SSIS packages by non - blocking, partially blocking and row transformations
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Expert experience in developing SSIS package framework (storage, deployment and management) for solutions across the projects using design best practices
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Extensively used Report Wizard, Report Builder for developing and deploying reports in SSRS
• Experience in generating Drill down reports, crystal Reports, Parameterized reports, Linked reports, sub reports, matrix dynamics and filters, charts, gauges and Maps in SSRS.
• Excellent working knowledge in Creating SSAS OLAP CUBES and migrating DTS Packages from 2000 to 2005.
• ExtensiveSQL Server database experience and expert knowledge in scripting stored procedures, triggers and user-defined functions in T-SQL.
• Expertise in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Extensive Experience on troubleshooting production issues
• Domain Knowledge on banking, Insurance, finance etc.
• Excellent communication and interpersonal skills and strong ability and experience in seeking solutions TEMPeffectively in challenging environment.
• Excellent understanding of project issues, Ability to work independently and in teams.

TECHNICA SKILLS

Microsoft BI Tools: SSI SSIS, DTS, SSAS, SSRS, BIDS, SSMS, Microsoft Office SharePoint Server, Excel, Report Designer, Report Builder, PowerPivot

Languages: SQL, T-SQL, PL/SQL, MDX, C, C++, HTML, XML, Java,.Net

Web Servers: Microsoft IIS 7.0, IIS 6.0

RDBMS/Data Bases: SQL Server 2012/2008/2005 R2, Oracle 9i & 10g.

IDE Tools: Visual Studio 2012/2010, SSDT, BIDS

Source Control Tools: TFS 2012/2010, Source Depot

Job Scheduling Tools: Autosys, Tivoli and SQL Server Agent

Operating System: Windows Server 2012/2008 R2, Windows 8/7/Vista/XPO

ther Tools: Query Analyzer, SQL Profiler, Toad, MS Visio, Crystal Reports 2008 /XI/X

PROFESSIONAL EXPERIENCE

Confidential, San Francisco,CA

Sr. MSBI Developer

Responsibilities:

• Involved in interacting wif business analyst for gathering requirements and developed T-SQL code and SSIS Packages accordingly.
• Translated functional requirements into Technical specifications and Developed Stored Procedures and Complex SQL Queries.
• Created ETL packages using Heterogeneous data sources like SQL Server, Flat Files, CSV Files, Excel source files, Access Files, XML files and then loaded the data into ODS/Staging areas by performing different kinds of transformations using SSIS Control Flow and Data Flow transformations.
• Developed SSIS Packages using fuzzy lookup transformation, file system task, and Foreach loop container.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, and Derived column, etc.
• Developed Dashboard reports using Power view and Power Pivot.
• Used Fuzzy Lookup and Fuzzy Grouping transformations to achieve higher degree of control over the data cleansing process such as standardizing data, correcting data, and providing missing values.
• Working knowledge on relational databases like SQL Server 2012/2008 R2/2005, T-SQL.
• Stabilization - diagnostics and troubleshooting, bug fixing for the developed code.
• Responsible for timely communication of production issues wif the respective stake holders.

Environment: SQL Server Data Tools 2012, SQL SERVER 2012, SQL Server Integration Services (SSIS), SQL SERVER Reporting Services (SSRS), Power Pivot in MS Office Excel, TFS 2012.

Confidential, Jackson, MI

MSBI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Used Query Analyzer to optimize SQL Queries.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Created Dimensions wif the cube wizard and also individually.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Created reports wif Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created Reports from Web Services and used MDX on Cubes in SSAS to create reports in SSRS.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP wif the halp of SSIS.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Designed SSRS reports wif sub reports, dynamic sorting, defining data source and subtotals for the report.

Environment: SQL Server 2008, SSAS, MDX, OLAP, SSIS, T-SQL, SSRS, Windows Server 2003Performance Point Server 2007, MS Access, Visual Studio 2005, .NET 3.5

Confidential

BI Developer

Responsibilities:

• Developed and OptimizedStored Procedures,Views, andUser-Defined Functionsfor the Application.
• UsedSSISto create DynamicETL Packagesto validate, extract, transform and load data from online transaction Processing (OLTP)databases to data warehouse databases and involved in Data cleansing in the data transfer.
• MigratedDTS packagesfrom SQL Server 2008 to SQL Server 2008R2 asSSIS Packages.
• Involved in creatingSSIS jobsto automate the reports generation and cube refresh packages.
• Configured Server for sending automatic mails to respective people when a SSIS process failure or success.
• DeployedSSISpackage into production environment and used package configuration to export various package properties to make package environment independent and scheduledJobsusingSQL Server Agent.
• Developed various operationalDrill-throughandDrill-downreports usingSSRS.
• Developed different kinds of reports such asSub ReportsandCharts,Matrixreports.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema wif Fact and Dimension tables.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema wif Fact and Dimension tables.

Environment: SQL SERVER 2005, Integration Services, SSRS & Office Excel Reports, TFS 2005SQL SERVER Management Studio, Visual Studio 2005

Confidential

Programmer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end wif the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Created documentation as required.

Environment: MS SQL Server 2000, T-SQL, DTS