SUMMARY

• 7+ years of experience as Business Intelligence Developer in T - SQL Programming, Physical & Logical Database Design, SQL server 2005/2008/2012 suite of products SSIS, SSRS, and SSAS.
• Strong Communication & Management skills with Excellent Role-playing capabilities.
• Expert in writing T-SQL, working on SSIS, SSRS Data Cleansing, Data Scrubbing and Data Migration.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
• Database Normalization, designing and creating Indexes, stored procedures; Indexed views and triggers Develop Queries and T-SQL Scripts in MS SQL 2000/2005/2008.
• Experience in migrating from SQL Server 2000 to SQL Server 2005and from SQL Server 2005 to SQL Server 2008.
• Experience in SQL Server SSIS (Integration Service) package design, constructing, and deployment.
• Developed reports using Microsoft Reporting Services platform (SSRS), MS Excel, Pivot tables.
• Expert in extracting and transforming data (ETL) using DTS Import Export Data, DTS Packages and SSIS Packages 2005/2008, BCP Bulk copy.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Merge, Look up, data conversion, pivot, union all, merge join, aggregate and Unblock Transformations.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler and Spotlight.
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created complex stored procedures, Functions, Triggers Indexes, Tables, Views and SQL joins for applications.
• Expertise in Data Modeling and designing data warehouses (Relational) using star and snowflake schemas.
• Extensive experience in gathering, managing and documenting business, functional, and technical requirements, communicating effectively with Onsite counterpart, higher management, developers, testers & implementation team.
• Proven ability to work in both independent and team environment and having ability to meet tight deadlines and work under pressure.
• Used Team Foundation Server (TFS) for version control.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Config files and deployment wizard.
• Implemented SSIS Config files using XML, Event Log, Windows registry and secure configuration using SQL Server tables by applying Grant/Deny permissions.
• Efficiently helped in Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/2003, Windows XP/VISTA, 7,8

Domain Expertise: US Health Care, Retail and Sales Business, Financials Domains.

Languages: C, C++, C#, Java, Oracle 10g, Oracle 11g. HTML5, Big Data

RDBMS: SQL, Dynamic SQL, T-SQL, SQL SERVER 2008 R2/2005, 2012

ETL Tools: SQL SERVER Integration Services - SSIS, DTS, Informatica

Reporting Tools: SQL SERVER Reporting Tools - SSRS.

Client Tools: MS Excel 2010/2007, Power Pivot, Adobe Professional.

Development Environment: Visual Studio 2010/2008

Source Control Tools: Team Foundation Sever 2010, Visual Source Safe 2005.

PROFESSIONAL EXPERIENCE

Confidential

SSIS/ETL Developer

Responsibilities:

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to DW
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Developed and deployed data transfer packages using SSIS, also maintained the jobs running on Servers
• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Worked with SOA services to detect database table and views.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse

Confidential, Des Moines, IA

Sr. MS SQL Server (SSIS/SSRS)/ETL Developer

Responsibilities:

• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS packages.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD’s), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as per the client requirement.
• Implemented Logging and Event Handlers on SSIS packages for trouble shooting.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2012.
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for monthly Statements.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Worked with MDX and DAX for analyzing data.
• Designed and developed databases using Oracle, MS SQL server.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005 (SSAS)
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Used Service Oriented Architectural approach for developing Information Systems and later on used it for databases.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server- 2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, Oracle, C#.NET, ProClarity Analysis.

Confidential, Camp Hill, PA

SSRS developer

Responsibilities:

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to DW
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Developed and deployed data transfer packages using SSIS, also maintained the jobs running on Servers.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Generated reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQL.
• Used Control M 7 for creating a basic cyclic job flow.
• Did Design development using MSAS 2012.
• Worked on Services which was connected with SOA.
• Worked with MDX and DAX for analyzing data.
• Used to develop the reports by using SSRS and Power Pivot.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the SSRS report.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics, Tableau Reports using SSRS
• Designed and developed Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Worked with analytical languages like MDX and DAX.
• Proficiency in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes,
• Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Configured the report viewing security for various users at various levels using SSRS Report Manager.

Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services 2008/2012, MS SQL Server Reporting Services 2008 (SSRS), MDX, MSAS 2012 Visual Studio 2008, Win NT /2000/ 2003, MS Office 2003/2007, PL/SQL, Microsoft Office Share Point - 2008, C#.

Confidential, Herndon, VA

SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Designed packages using Transformations Sort, Merge, Merge Join, Union, Union ALL, Lookup, Aggregate, OLE DB Command and Derived Column.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Developed forms on share-point to show data from data-sources to Clients and enabling them to edit the data and update the data in the data-sources and allowing inserting data into the data-sources.
• Created reports on to Share-Point and Report Server and set the data-driven subscriptions for these reports.
• Deployed generated reports of each quarter onto the Report Server to access it through browser.
• Designed and developed Data Warehouses, Data marts using Multi-dimensional models such as Star Schema and Snow Flake Schema for developing cubes.
• Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star Schema structure.
• Created a cube and enable write back to write to cube using excel 2010.
• Created Write back functionality in SSAS to write the data back into the cube to make changes to the data those changes return back in to the cube.
• Worked on Design development using MSAS 2012.
• Maintained the consistency of data by performing Data Profiling and Data Cleansing.
• Involved in developing Life Cycle using Agile Methodology.
• Created the documents and packages in Team Foundation Server as a version control.

Environment: SQL Server 2008/2005, T-SQL, SSIS, SSAS, XML, MS Excel, MSAS 2012, MS Access, .Net, Visual Studio, Share-Point, C#, TFS

Confidential

MS SQL Server Developer

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects
• Designed data models using Erwin.
• Wrote user requirement documents based on functional specification.
• Worked with SOA services which allows clients to connect to the databases.
• Developed source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, Constraints and rules on database objects for optimization.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer, Oracle Hyperion EssBase.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Worked with SOA services to detect database table and views.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server, 64 bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, ERWIN.