SUMMARY

• 7+ years of strong experience in the IT industry as a SQL Server Developer/BI Developer in Financial and Health domains.
• Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expert in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Extensive experience in MS SQL Server 2012/2008/2005 , Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008/2005.
• Proficient in designing high level ETL architecture for overall data transfer from the OLTP-Online Transaction Processing to OLAP with the help of SSIS.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Good skills in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Hands on experience in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experience in designing and developing large number of reports in SSRS/Business Objects using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Strong experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2008/2005.
• Expertise in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Proficient in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2012/2008/2005 .
• Experience in developing and modifying cubes using SSAS and transform into pivot table.
• Skilled in implementing Key Performance Indicator (KPI) Objects in SSAS 2005.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.

TECHNICAL SKILLS

• MS SQL Server 2012/2008/2005
• DTS
• SSIS 2008/2005
• SSRS 2008/2005
• SSAS 2008/2005
• MS Visual Studio 2012/2008/2005
• Erwin Data Modeler r8 r7 4.2
• MS Access 2007/2003
• Index Tuning Wizard
• MS SQL Profiler
• Crystal Reports 11/10/9/8.5
• SharePoint 2007
• Microsoft Visio 10.0/11.0
• T-SQL
• PL/SQL
• JavaScript
• Oracle 10g/9i
• Visual source safe 2005
• MS office 2013/2007
• Windows 2008/2003 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE

Confidential, Addison, TX

MS SQL Developer/BI developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Extracted data from OLTP System which was DB2 to two different DB named HISTORICAL DB and CDC (Change Data Capture) DB.
• 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.
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Actively Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• 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 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Confidential, Union, NJ

MS SQL Developer/BI 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.
• Created and developed SSIS packages to move data from staging environment to EDW environments within the organization.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Created high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP 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.
• Established backup and recovery of SQL server 2008.

Confidential, Boston, MA

MS SQL Developer/BI Developer

Responsibilities:

• Updated functional specification and technical design documents.
• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements
• Improved query performance by cube partitioning.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2005.
• Generated daily, weekly and monthly reports using SSRS 2005.
• Developed measures and dimension members using Multi Dimensional Expression (MDX) to meet additional needs that were calculated from existing measures.
• Involved in the development of MDX expressions for cube calculations and KPIs.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Designed Static Reports using MDX queries and creating MDX Base Report Definition.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created business critical KPIs usingSQL ServerAnalysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Implemented the calculations to aggregate physical measures using management studio.
• Identified and defined the scoped assignments using script commands.
• Defined Referenced relationships with the measure groups and fact tables.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Established a sound backup and recovery policies and procedures.

Confidential, Philadelphia, PA

MS SQL Server Developer

Responsibilities:

• Involved in planning, defining and designing data and provided documentation.
• Upgraded MS SQL Server 2000 databases to 2005, using detach/attach, backup and recovery and by replication.
• Incorporated the DTS packages into SSIS 2005 by using package migration wizard and executed DTS 2000 Package task.
• Involved in SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Used various SSIS tasks such as conditional split, derived column e, which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.
• Used ETL to implement the slowly changing transformation, to maintain historical data in data warehouse.
• Created error and performance reports on SSIS packages, Jobs, stored procedures and triggers.
• Created Views to reduce database complexities for the end users.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS.
• Generated ad hoc reports using MS Reporting services and crystal reports.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2005.
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers.
• Involved in documentation for all kinds of reports, DTS and SSIS packages.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating Indexes.
• Used the HTML code to make the report manager more functional and customizable.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Confidential, Newark, NJ

MS SQL Server Developer

Responsibilities:

• Designed SSIS packages to transfer data between servers, load data into database, archive data file from different DBMS’s using SSMS on SQL Server 2005 environment, and deploy the data; Scheduled the jobs to do these tasks periodically;
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Made sure that standards and best practices in database development were followed and maintained.
• Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Provided technical support to internal developers and external clients.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Confidential

MS SQL Server /ETL Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Enhanced PMS data model to in corporate new reporting on wealth management system requirements.
• Build mapping document to map all the data elements from wealth management system to PMS.
• 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.
• Build packages for data reconciliation between wealth management system and PMS and logging them for auditing purposes.
• 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.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.