SUMMARY

• Over 7+ years of strong IT experience as MS SQL Server 2012/ 2008 R2/2005/2000 Database Developer with Data warehouse projects in ETL and reporting using SSIS/SSRS and SSAS in Windows Environment.
• Highly proficient in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transform Services (DTS), Bulk Insert and BCP.
• Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SQL Server Integration Services.
• Extensive experience of working with Transact - SQL and PL/SQL (DDL and DML).
• Strong knowledge of Enterprise Data Warehousing and Data Mart in OLTP/OLAP environment.
• Expert in Tuning SQL queries and improving the query performance.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing by the use of triggers and SQL Scripts
• Excellent in creating various Reports and dashboard using Performance Point Server.
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase,Excel and MS Access.
• Strong experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Highly proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experienced in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Strong in optimizing MOLAP cubes by partitioning them, designing aggregations and implementing hierarchies.
• Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
• Excellent experience in implementing Key Performance Indicator (KPI) objects in SSAS and creating calculate members in MOLAP cube using MDX in SSAS.
• Expert in creating and deploying SSRS reports on the portal for user
• Proficient in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Experienced in using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• In-depth experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled DTS and SSIS Packages.
• Expert in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports, SSAS (SQL Server Analytical Services) objects and OLAP including Interfaces with BIDS (Business Intelligence Development Studio).
• Strong understanding of designing Database Models using MS Visio and ER-win.
• Experience of Working in Agile, Scrum and Rational Process (waterfall) model..
• Excellent communication skills, analytical skills, understand business requirements in various domains.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

• MS SQL Server 2012/2008 R2/2005/2000
• DTS
• SSIS 2012/2008/2005
• SSAS 2012/2008/2005
• SSRS 2012/2008/2005
• Windows Server 2008 R2/2005
• Performance Point Server 2007
• Report Builder 3.0
• T-SQL
• PL/SQL
• MS Visual Studio 2010/2008/2005
• Microsoft Project 2003
• MS Visio 2007
• MS SQL Profiler
• SQL Query Analyzer
• Erwin 8.0 Data modeler
• Crystal Reports11/10/9/8.5
• M.S. Access java java script
• Jquery
• VB.net.

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Sr. MS SQL Data Warehouse Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin 8.0 on business requirement and provided documentation.
• Created SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server.
• Developed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to DW systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column Using SSIS.
• Wrote T-SQL queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: Microsoft SQL Server 2012, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visio 2007, Microsoft Project 2003

Confidential, Chicago IL

Sr.MS SQL Data Warehouse Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Designed and developed SSIS packages to move data from staging environment to EDW environments within the organization.
• Developed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to DW with the help of SSIS.
• Extensively used SSIS for transferring data by utilizing various control flow and data flow elements.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Managed the Metadata associated with the ETL (SSIS) processes used to populate the Data Warehouse.

Environment: Microsoft SQL Server 2008R2 Enterprise Edition, Windows Server 2008, Visual Studio Team System 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Report Builder 3.0,Performance point server 2007,Microsoft SharePoint 2010, Visual Source Safe 2005, SQL Profiler

Confidential, New York, NY

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2008 R2 and SQL 2005).
• Extracted data from OLTP System which was DB2 to two different DB named HISTORICAL DB and CDC (Change Data Capture) DB.
• Transformed data into Staging Server named as P-Staging Server for historical data and T-Staging Server for load increment.
• Performed historical or full load and incremental load data into Enterprise Data Warehouse.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes, if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.
• Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Created counter logs and trace logs using windows server 2008 for advanced performance analysis and data logging over a period of time.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS. Developed yearly and quarterly company expense reports.
• Was responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Used Visual Source Safe tool for Version Control.
• Tuned SQL query for better performance using SQL Profiler.
• Actively supported business users for change requests.
• Documented all work, so that user can easily understand the flow of process.

Environment: Microsoft SQL Server 2008 R2 Enterprise Edition, Windows Server 2008 R2, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio(BIDS), Microsoft Visual Studio 2008, Visual Source Safe 2005, SQL Profiler.

Confidential, Atlanta, GA

SQL/SSIS/SSAS/SSRS Developer

Responsibilities:

• Designed Data Warehouse and Database for the system using Star Schema which includes Tables, Stored Procedure and Indexes in SQL Server Management Studio.
• Implemented SSIS Package (ETL) to Extract and Transform data from Oracle RDBMS, Flat File or CSV, SQL Server 2005 instances and to Load into Staging Database. The main purpose to load data into staging database is to use key tat populated in fact table. And then to Data Warehouse for further Data Analysis by using multiple transformations provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
• Scheduled and maintained every mid-night and weekly load data by creating corresponding job task by SQL Server Agent in SSMS.
• Used Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Created and updated complex Stored Procedures, Triggers and User Defined Functions for logical T-SQL implementation.
• Developed Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Involved in Designing and deploying cubes in SSAS environment using Star.
• Designed cubes with around 45 dimensions, about 25 Measures and 20 calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Created Reports using MDX queries and creating MDX Base Report Definition.
• Created and run Sub-reports, Drill-down reports, Matrix or Crosstab reports and Summary reports in SSRS.
• Designed subscriptions to generate reports on daily and weekly basis via FTP.
• Managed Report Security by using SSMS. Connect to Reporting Server and set different roles and different security level to different users.
• Involved in Creating Scorecard Reports using Performance Point Server for the managers.
• Used SQL Server Profiler for tuning report queries and improve performance in SQL Server.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the development work.

Environment: Microsoft SQL Server 2005 Enterprise Edition, Windows Server 2003, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS),Performance Point Server 2007, Business Intelligence Development Studio(BIDS), Oracle 10g, Microsoft Visual Studio 2005, IIS.

Confidential, New York, NY

MS SQL Server /ETL Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Involved in ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Designed database, tables and views structure for the new data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2000 using DTS Packages.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Performed unit testing and SQL performance tuning.
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Tuned SQL statements Using Indexes and stored procedures.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Involved in implementation and maintenance of disaster recovery solutions such asreplicationand log shipping.
• Was responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Environment: MS SQL Server 2005/2000 Enterprise Edition, MS Access 2000, Erwin, T-SQL, MS-Excel, MS-Access, SQL Query Analyzer

Confidential

SQL Server Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development and user training.
• Participated in the installation of SQL Server and Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Migrated Access objects to SQL Server 2000.
• Created Tables, Indexes and Constraints.
• Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
• Configured and Monitored database application.
• Designed and implemented several complex Reports and Administration modules.
• Defined Stored Procedures for module integrity and application.
• Wrote database Triggers in T-SQL to check the referential integrity of the database.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Involved in Performance tuning of the database and T-SQL queries.
• Developed reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
• Preparation of test plans for assembly testing & System Integration testing.
• Troubleshooting and solving complex problems working with SQL Server support.
• Participate in review meetings with Sr. Business Analyst and Manager.
• Prepared Project Documentation.

Environment: SQL Server 2000 Enterprise Manager, Windows 2000, DTS, T-SQL, Visual Basic, Crystal Reports 8.0