Summary:

• Over 8 years of IT experience as SQL Developer in Microsoft Business Intelligence framework SQL Server, SSIS, SSRS, SSAS .
• Experience in OLTP, OLAP, Slowly Changing Dimensions, Data Cleansing and Data Migration.
• Expert knowledge and extensive experience using SQL Server Integration Services SSIS to perform ETL and data integration processes.
• Experience in migrating data from heterogeneous data sources like Excel, flat file, MS Access, Oracle, DB2, online, to MS SQL Server by using SSIS.
• Good at SQL Server SSIS package design, constructing, and deployment.
• Expert experience in Data Mart/Data Warehouse design, development, testing, deployment and production support in various business domains.
• Extensive experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Extensively used Report Wizard, Report Builder for developing and deploying reports in SSRS.
• Experience in developing different types of reports such as Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services SSRS .
• Experience in Deploying reports in various sources like Web browser in XML and PDF formats.
• Excellent working knowledge in designing and deploying multi-dimensional databases for business intelligence analysis using SSAS.
• Experience in designing aggregations and pre-calculating the same in SSAS, in creating groups and measures, KPIs, and understanding of database design, relational integrity constraints OLAP, OLTP, Cubes and normalizations.
• Extensive SQL Server database experience and expert knowledge in scripting Stored Procedures, Triggers and User-defined Functions in T-SQL.
• Expertise in MS SQL Server installation, configuration, query optimization, performance tuning, backup/recovery. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Experienced in all phases of project life cycle starting from business requirement gathering, analysis, design, implementation, testing, and production.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.

Skillset:

MS SQL Server 2005/2008/R2/2012, MS Visual Studio 2005/2008/2010, SSIS, SSRS, SSAS, ETL, DTS, MS-Office, MS-Access 2007/2003, Microsoft Project2007/2010, Oracle 8i/9i, MySQL, C/C , C , JAVA, J2SE, J2EE, Eclipse, SQL, Transact-SQL, HTML, ASP, ASP.NET, VB, VB.NET, XML, Crystal Reports, SQL Profiler, SQL Server Management Studio SSMS , ERWIN, MS Visio 2008/2010, SharePoint 2010, Business intelligence development studio BIDS /SQL Server Data Tools, Performance Point Server PPS .

Projects Summary:

Confidential

MS SQL/SSIS/SSRS/SSAS Developer/Data Modeler

Confidential is global financial services provider, engaged in retail and commercial banking, credit cards, investment banking, wealth management and investment management services all over the world. The aim of this project is monitoring customer spending habits and predicting delinquencies. Scope of the project was to design and develop Data Warehouse and migrate the data from different sources into data warehouse using SSIS, develop reports for business analysis.

Responsibilities:

• Create new logical and physical design of Data Warehouse to fit new business requirement and implemented new design into SQL server 2012.
• Identified the dimension, fact tables and designed the data warehouse using star schema/snowflake schema
• Involved in creating Data Mart specifically for Sales and Marketing department. This involved integrating data from various database systems like SAP, MS Access, Excel, flat file, etc.
• Used various transformations in SSIS like Lookup, Fuzzy grouping and Row Count Transformations
• Played role in design of scalable, reusable, and low maintenance ETL templates
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 Slowly Changing Dimensions SCD
• Modeled SSIS packages and used Analysis Services processing task to update the cube with current data
• Developed Ad-hoc Reports, Tabular, drill down, parameterized, cascaded and sub-reports by using SQL Server Reporting Services SSRS
• Deployed reports in various sources like Web browser in XML and PDF formats.
• Created Analytic Grid Report using data source SSAS in Performance Point Server PPS and integrated with SharePoint.
• Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint.
• Fine-tuned SSAS cube
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the dimensions and Cubes in Analysis Services
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions
• Constructed Cubes based on data volumes mostly adhering to Star Schema
• Created Perspectives of the cube to simplify the process of browsing for the end users
• Used Multi-dimensional Expressions MDX to create calculated members in the cube
• Used to support the data processing engine in database intensive operations like query
• Performance tuning, parallel query algorithm, data mining by writing Stored Procedures.
• Implemented Complex Stored Procedures and automated them using SQL Server Agent
• Programmed Triggers Instead Of and After for Auditing Purpose
• Working with Different methods of taking Database Backup and Recovery procedures.

Environment: MS SQL Server 2012, T-SQL, SharePoint 2010, MS Excel 2007/2003, Windows Server 2008R2, VB.NET, Microsoft SQL Server Integration Services SSIS , Microsoft SQL Server Reporting Services SSRS , Microsoft SQL Server Analysis Services SSAS , SQL Server Business Intelligence Development Studio, ERWIN 8.0/MS Visio 2010, Performance Point Server PPS .

Confidential

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

• Worked on the Data Warehouse design and analyzed various approached for maintaining different dimensions and facts in the process of building a data warehouse application.
• Designed the data warehouse structure, data modeling and developed it using the Erwin tool, MS Visio.
• Modifying existing cursors into optimized stored procedures for a better performance.
• Extensively worked in extracting data from various sources such as flat files, MS Excel, Oracle etc.
• Created ETL packages with different data sources and loaded data into destination files with various kinds of transformations.
• Designed dynamic SSIS with C /VB.Net to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
• Developed highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, For Loop Sequence Container, etc.
• Involved in designing and deploying complex queries to perform various data base maintenance operations involving data profiling and data verification
• Developed Procedures to implement type 1 and type 2 Slowly Changing Dimension
• Defined the report layout and created, parameterized and drill through reports using SSRS
• Developed reports using SSRS and Crystal reports, used table control, matrix control for cross tab reports.
• Backing up, restoring system other databases as per requirements, and also scheduled those backups.
• Extensively used Teradata SQL Assistant to extract data from Data warehouse.
• Redesigned and tuned existing stored procedures, triggers, views that ultimately improved the performance of the queries using T- SQL.
• Creating stored procedures for claim matching.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
• Generated test data and tested the database to meet the functionalities deliverables in the project documentation and specifications
• Involved in installing and migrating legacy databases from MS SQL Server 2008 R2 to MS SQL Server 2012.

Environment: MS SQL Server 2008 R2/2012, Windows Server 2008, T-SQL, MS Excel 2010/2007, Microsoft SQL Server Integration Services SSIS , Microsoft SQL Server Reporting Services SSRS , Crystal reports 2010, SQL Server Business Intelligence Development Studio, Erwin 8.0, MS Visio 2010, SQL Profiler.

Confidential

MS SQL Server Developer/BI Developer/Data Modeler

Responsibilities:

• Developed System Standards, System Architecture, Scenarios, detailed Screen Specifications and documented Logical and physical Data Model.
• Built Star schema and Snow Flake schema depending on business requirements.
• Implement Type I, II changes in Slowly Changing Dimension SCD tables
• Built physical data structures like tables, views, constraints Indexes
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server 2008 R2.
• Implemented SSIS for data transformation logic process.
• Configured product meta-data tables to support client data reporting needs.
• Working with Different methods of taking Database Backup and Recovery procedures.
• Generated database SQL scripts and deployed databases including installation and configuration
• Worked on Stored Procedures and Database Triggers.
• Worked on large number of business analytical functions.
• Working with different types of Replication Models like Snapshot, Merge and Transactional.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Used Microsoft Source Safe for version control and configuration management.
• Tuning the Performance of Database, Query Optimization and Application tuning.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , T-SQL, DB2, Oracle, Microsoft Source safe, SQL Profiler, MS Visio 2008, Microsoft Source Safe, ActiveX.

Confidential

MS SQL/BI Developer/DBA

Responsibilities:

• Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.
• DDL Scripts for generating Tables, Views, Functions.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Scheduling Backups and Restore database
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Extended Data to XML and Excel Spread Sheet.
• Developed reports using SSRS 2005/2008 and Crystal reports.
• Created reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Assisted end users in user acceptance testing, by explain all the functionality of the data warehouse and its applications.
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Writing and testing stored procedures
• Responsible for upgrading database SQL Server 2005 to SQL Server 2008.

Environment: Microsoft SQL Server 2005/2008, SQL Server Management Studio, T-SQL Stored Procedures, SQL Server reporting services SSRS , SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , Crystal Reports 2008 12 , Office, MS Excel.

Confidential

MS SQL Developer/DBA

Responsibilities:

• Involved in transferring old data from various sources like flat files, MS Access, and MS Excel into MS SQL Server 2000.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Created various Table and Views to ensure the performance growth of application.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-Defined functions.
• Installed configured SQL Server 2005 successfully
• Responsible for upgrading database from SQL Server 2000 to SQL Server 2005.
• Created the structure of the model and cube in MS Analysis Services.
• Reviewed Cube with End user and changed the cube and documentation according to their Requirements.
• Prepared end user documentation, Technical documentation, dimension map, Contact list and published into the Production server. Involved in training to the end users to familiarize them about how to use the Cube.

Environment: Windows Server 2003, Visual Studio 2005, MS SQL Server 2000/2005, DTS, MS SQL Server Analysis Services 2005 SSAS , MS Access, MS SQL Server Integration Services 2005 SSIS , T-SQL, MS Excel.