SUMMARY

• MS SQL Server Developer with Over 7+ years of strong experience in Banking, Insurance, Finance and Health care domains with expertise in MS SQL Server 2008/2005/2000 suite of products like SSRS, SSAS, and SSIS. Strong leadership, communication, problem - solving and multi-tasking abilities.
• Extensive experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL
• Experience with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transform Services (DTS), Bulk Insert and BCP.
• Experience in SQL Server DTS and SSIS (Integration Services) package design, development, and deployment using SQL 2008 advanced features in Control flow, data flow, Error Handling and event handling.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins
• Strong experience in designing and developing enterprise reports(SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Highly experienced in optimizing MOLAP Cubes by partitioning them, Designing Aggregations, implementing Hierarchies and Calculated Members.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS 2005 and Create Calculate member in MOLAP cube using MDX in SSAS 2005.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive 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.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000/7.0
• Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Microsoft Access 2007/2003/8.0
• Microsoft Excel
• Outlook
• MS SQL Profiler
• OLTP
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• Erwin Data Modeler 4.2/4.1/4.0
• VB6
• Microsoft Products MS Word
• MS Excel
• VSS
• MS Access
• MS Power Point
• T-SQL
• PL-SQL
• HTML
• XML
• C++
• Crystal Reports 8.5
• MS Visio 2003
• Windows 2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte,NC

MS SQL Server Developer/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, Oracle db, and SQL 2008).
• Extract and Transform data into Staging Servers named as WHSStaging Server for historical data and TStaging Server for load increment.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• 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 Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• 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, Send Mail Task, Package Execution task to achieve business needs.
• Created 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.
• 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.
• Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Used Visual Source Safe tool for Version Control.
• Tuned SQL query for better performance using SQL Profiler.
• Documented all work, so user can easily understand the flow of process.

Tools: /Technology: MS SQL Server 2005/2008, SQL server Reporting Services 2008, OLTP, SQL Server Integration Services (SSIS), VSS, Microsoft Visual Studio, SQL Server Management Studio, Pl Sql, Toad for Oracle, MS Excel, T-SQL, ERWIN, SQL Server Profiler, Database Engine Tuning Advisor.

Confidential, Greene, NY

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008.
• Installed SQL Server 2008 and Management tools using SQL Server Setup Program.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target DW using SSIS (SQL Server 2008).
• Designed SSIS Packages to transfer data from various sources like XML Files, SQL Server, Excel, and Access to SQL Server.
• Handled slowly changing dimensions to maintain the history of the data.
• Involved in Designing and deploying cubes inSSASenvironment using Snowflake Schema Designs for the operational data
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS
• Involved in Analyzing, designing, building &, testing of OLAP cubes withSSAS2005 and in adding calculations using MDX.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed, reviewed and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.

Tools: /Technology: MS SQL Server 2008/2005, SQL Server Integration Services, OLTP, SQL Server Analysis Services, MS Visual Windows 2003/2000 and T-SQL, Erwin, SQL Server Profiler.

Confidential, NY City, NY

MS SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Created Stored Procedure, User-defined Functions to take care of back end validations when transferring data to Production Server.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality Implemented backup and database maintenance plans.
• Designed and implemented ETL (Extraction, Transform and Load) for data migration and data staging from heterogeneous environment like MS Access and MS Excel using SQL Server Integration Services (SSIS).
• Tested and designed (Unit, Integration and Regression) packages to extract, transform and load data using SSIS
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Generated periodic reports based on the statistical analysis of the data using SQL Server reporting Services (SSRS), and Crystal reports.
• Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.
• Designed MDX expressions/queries for accessing cubes; involved in query structuring and performance optimization.
• Created KPIs to monitor Business performance using SSAS.
• Used profiler to find badly performing queries and deadlocks.
• Tuned SQL queries using show plans and execution plans for better performance.
• Designed user access and privileges to access the database at various levels to provide better security, created and implemented the scripts in various production and development servers.
• Optimized Indexes for better performance using Execution Plans and Database Engine Tuning wizards.
• Worked with Database Consistency Checks (DBCC) to ensure the physical consistency of the database and objects.
• Monitored the database to identify and resolve the performance issues using SQL Server Profiler.

Tools: /Technology: MS SQL Server Reporting Services, SQL Server Integration Services, MS SQL Server 2005, Windows Server 2003, Erwin 4.3, C#, VSS, MS Access, MS Excel 2005.

Confidential, Columbus, OH

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Conducted detailed analysis of each Legacy source system interface with Data warehouse (DW) including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.
• Wrote Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each legacy system interface with DW.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in MS SQL Server 2005.
• Implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional Modeling principles in SSAS.
• Designed and developed MOLAP using SSAS.
• Developed and implemented partitioning and security in cubes based on user roles.
• Implemented Member properties, virtual Dimensions, Dimension custom rollups, write back, action and drill through.
• Designed MDX expressions/queries for accessing cubes; involved in query structuring and performance optimization.
• Developed complex canned reports using SSRS 2005 from multiple data providers in Underwriting and Claims systems, User defined objects, Aggregate Aware Objects, Charts and synchronized queries.
• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor, and Execution Plan and Index Tuning wizard.
• Validated reports to ensure quality of data and conducted Meetings with business users to review reports and obtain continuous feedback.
• Coordinated the activities of subordinates in the Data warehouse Team and organized weekly status Meetings.

Tools: /Technology: MS SQL Server 2005 Enterprise Edition, MS SQL Server Integration Service, MS SQL Server Reporting Services, MS SQL Server analysis services, OLAP, BIDS, Visual Studio 2005, T-SQL,VSS, Enterprise manager, MS-Access 2007, MS Excel, Report builder, Crystal Report, ER Win R7.3 Windows XP Professional, Windows NT,VB.NET, Performance point server, SQL Profiler.

Confidential, Cincinnati, OH

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.
• Designed DTS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000 environment, and deploy the data; scheduled the jobs to do these tasks periodically.
• 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.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting;
• 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 2000 including database consistency checks and index defragmentation, set up database backup and recovery strategies.
• Maintained all records of project status and followed changes as per control procedures;
• Provided technical support to internal developers and external clients.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, PDAs and window messengers.

Tools: /Technology: MSSQL Server 2000, Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard), Windows XP, MS Access, MS Word.

Confidential

MS SQL Server Developer

Responsibilities:

• Successfully installed and configured MS SQL Server 2000.
• Upgraded the database from MS SQL Server 7.0 to MS SQL Server 2000.
• Transferred logins and users information using the DTS object transfer task.
• Successfully Transferred logins and passwords information using the DTS Package transfer logins task.
• Gathered all the data from legacy systems and loaded them into a flat file using ETL.
• Created various DTS packages to load data from the flat file into MS SQL Server 2000.
• Involved in BCP commands to transfer data in text files from MS SQL Server 7.0 to MS SQL Server 2000.
• Developed complex SQL queries using various Joins and Sub-queries, Views, Functions and Triggers.
• Created customized stored procedures and triggers for automating tasks.
• Optimized various SQL Server statements with the help of MS SQL Server Profiler.
• Performed Full Back up, recovery and restoration on MS SQL Server 2000.
• Created many complex stored procedures/functions/triggers and used them in crystal reports directly to generate reports on the fly.

Tools: /Technology: MS SQL Server 7.0, MS SQL Server 2000, DTS, Windows NT/ 2000, Erwin v4.0, MS SQL Server Profiler, Crystal Reports 8.5.