Professional Summary

• 7 years of strong experience in software design, development, analysis, optimization, data modeling and business intelligence tools using MS SQL Server 2008/2005/2000.
• Strong experience in MS SQL Server 2008/2005 working with business intelligence tools in SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services).
• Highly experienced with the Full Life Cycle and Methodology for implementing OLAP (Online Analytical Processing) data warehouses (star and snow flake schemas) and business intelligence reporting systems.
• Expert in defining Multi Dimensional Queries (MDX) for generating drill down and parameterized reports in SSRS 2008/2005.
• Highly proficient in cube designing in business intelligence development studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, and calculations using SSAS.
• Expert in creating, configuring and fine-tuning ETL (Extract, Transform, Load) workflows designed in DTS (Data Transformation Service) and SSIS.
• Highly proficient in high level design of ETL SSIS/DTS packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server.
• Expert at basic and advanced report creation (table, chart, matrix report, web reporting) along with excellent experience in report serving architecture.
• Excellent experience in developing complex stored procedures, efficient triggers, required functions, creating indexes, and indexed views for improving performance.
• Highly proficient in monitoring SQL Server Performance using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard and Windows Performance Monitor.
• Excellent communication skills, organizing skills, excellent listener, and capable of handling responsibilities independently as well as a proactive team member.

Education: Masters in Computer Science

Skillset:
MS SQL Server 2008/2005, Microsoft Reporting services 2008/2005, Windows 2000/2003 Advanced Server, Windows Exchange Server 2003, Windows XP, Unix, Linux, MySQL, MS-Access, Oracle 9.i, C, T-SQL, Java, HTML, DHTML, XML, Java Script, MS Visual studio 2005, ERWIN 7.1.

Project Summary:

Confidential,MN 8/2009 - Present
MS SQL Server Developer
Deluxe Corporation is the nation\'s leading check printer which has products like paper checks and electronic checks for small business and financial institutions. The project was to keep track of the entire records of the inventories and to analyze the campaign performance.
Responsibilities:

• Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Designed and created different ETL packages using SSIS and transferred data from Oracle source to MS SQL server destination.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Used config files in SSIS to ease the process of moving the packages across servers.
• Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor.
• Migrated databases from SQL 2005 to SQL 2008 in production and test Environments. Constructed the OLAP cube using SSAS and used SSIS to transform the data into OLAP.
• Configured SQL mail agent for sending automatic emails on errors.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions for data migration. Involved in the project from planning stage to pushing codes to production.
• Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agentusing SSAS.
• Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS.
• Developed several reports with consistent drill-down functionality including Drilldown report, Summary report and Master Detail reports.

Environment: MS SQL Server 2005/2008, MS SQL Server reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003/2008.

Confidential,FL 10/2007 – 8/2009 MS SQL Server/SSRS/SSIS/SSAS Developer
Haskell is one of the renowne
d construction companies of US. Haskell provides complete planning, architectural, engineering, and construction services.The project was to develop Reports for Executives wherein they can see a snapshot of key areas within the organization and analyzing the performances of the organization.
Responsibilities:

• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for new and existing applications.
• Created and rebuild multi-dimensional cubes using SSAS to support business reporting and forecasting process.
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports. Debugged and deployed reports in SSRS.
• Used conditional formatting to change the behavior of the report depending upon the requirement. Created standard report Subscriptions and Data Driven report Subscriptions.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Migrated databases from SQL 2005 to SQL 2008 in production and test Environments. Created several SSIS packages in Microsoft SQL Server 2005.
• Transferred data into various CSV file format and immediately updated managers with the automated email systems.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Used config files in SSIS to ease the process of moving the packages across servers (development to production).
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Monitored, optimized and did Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Integration Services 2005/2008, SQL Server Analysis Services 2005/2008, MS Excel, MS Windows Server 2003, Oracle 10g/9i.

Confidential, NJ 3/2006 – 10/2007
MS SQL Server Developer
Johnson & Johnson is the world’s premier consumer health care company. The project goal was to keep track of the entire records of the inventories. Each inventory transaction identifies the date, product, warehouse, vendor, transaction type, and amount representing the inventory quantity impact caused by the transaction.
Responsibilities:

• Installed, upgraded and migrated databases from Oracle database to MS SQL Server 2005.
• Generated reports using MS SQL Server Reporting Services 2005 from OLTP and OLAP data sources.
• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2005 SSRS.
• Constructed the OLAP cube using SSAS and used SSIS to transform the data into OLAP.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions for data migration.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.
• Performed system study and requirements analysis, prepared data flow diagrams, entity relationship diagrams, data diagrams, and table structures to store the data.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries.
• Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries, and created star schema in SSAS to develop ad-hoc reports for the clients as per their requirements using SSRS in MS SQL 2005.
• Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agentusing SSAS.
• Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS.
• Worked as a technical expert in the design, development, and maintenance of OLAP cubes and databases.

Environment: MS SQL Server 2005, MS SQL Server reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003.

Confidential,MA 6/2004 – 2/2006
MS SQL Server Developer Harvard Pilgrim is a not-for-profit health care organization that provides a variety of insurance plan options and self-funding arrangements. The project was to develop Member-Individualization module in the Data warehouse. The project aims was to deliver the claims processing system which can be effectively utilized throughout the company.
Responsibilities:

• Gathered Requirements from the end user and checking the structure of the schema and data with the Data Modular.
• Created Metadata Models and published package to improve the overall end user experience. Created a directory path in integration, QA and Production.
• Reviewed Cube with end user and changing the cube and documentation according to their requirements.
• Created drill-through reports using cross-tabs and sub-reports to show necessary information
• Involved in extracting the data using SSIS from OLTP to OLAP. Defined and scheduled several DTS packages to move data between servers.
• Prepared end user documentation, technical documentation, dimension map, contact list and published into the Production.
• Imported Metadata and created Presentation Layer, Business Layer, Data Source layer and Physical Layer. Created business process diagrams defining current business processes.
• Responsible for scheduling the jobs to streamline and automate cumbersome repeated tasks. Troubleshot report failures, Web page failures, document findings, and implement solutions.
• Monitored training sessions for the end user to familiarize them about how to use the Cube.
• Created various Table and Views to increase the application\'s performance. Defined aggregations required and granularity available and required in DW.

Environment: MS SQL Server 2000/2005, MS SQL Server Analysis Services 2005, MS Access, SSIS
Confidential,India 1/2003 – 5/2004
MS SQL Server Developer
Reliance Infocomm Ltd. is India\'s largest private information and communication services provider. The Project goal was to gather requirements from Business users and also involved designing, developing and maintaining the tool for making decisions depending on different scenarios.
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.
• 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 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