SUMMARY

• 8 years of strong experience in the IT industry as a SQL Server Developer/BI Developer in Financial, Pharmaceutical and Healthcare domains.
• Expert in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly experienced in Logical and Physical Database design & development, Normalization and Data modeling using Erwin, Visio and Management Studio.
• Well Versed in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008 R 2/2008/2005/2000 .
• Adept 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 2005/2008/2008 R2 Packages for transferring data manually from multiple data sources to SQL server.
• Expert in Creating and Deploying SSRS 2005/2008 Reports on the portal for user accessibility.
• Highly experienced developing reports in SSRS/Business Objects using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Highly experienced in writing Parameterized Queries for generating Canned, 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.
• Experienced in developing and modifying cubes using SSAS 2005/2008 and transform into pivot table.
• Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS 2005/2008.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, indexes, views, user profiles, relational database models and data integrity, SQL joins and query writing.
• Highly experienced in maintaining database by checking execution plans, DMVs and DMFs.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries or SPs.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.

TECHNICAL SKILLS

• MS SQL Server 2008 R 2/2008/2005/2000
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• MS SQL Server Analysis Services (SSAS)
• Microsoft Access
• Erwin 7.2/4.2/4.1/4.0
• Microsoft Visio 10.0/11.0
• T-SQL
• PL/SQL
• ASP.NET
• C#
• VB.Net
• DHTML
• HTML
• XML
• XSL
• JavaScript
• SharePoint
• Report Builder 3.0
• Oracle 11i/10g/9i
• Crystal Reports 11/10/9/8.5
• Visual source safe 2005
• MS office 2007/2003
• Windows 2007/XP/2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• TeamTrack
• Quest Software - Toad for Oracle
• Toad for DB2
• ECM
• DQL
• Repoint

PROFESSIONAL EXPERIENCE

Confidential, Horsham, PA

SQL Server DBA/Data Warehouse Support Analyst

Responsibilities:

• Created and Modifies packages to derive data from Insurance Solution Data Warehouse to DM Also involved in extracting data from another platform to new ISDW.
• Analyzed the current source and system and generated documents for Master crosswalk.
• Gathered source and target information including different transformation by column backmapping and analysis service.
• Worked on metadata to extract system information using T-SQL queries and Procedures.
• Involved with Enterprise Architect Team to establish Standards and Glossary for the Data Warehouse.
• Created Scripts to provide Meta-Data information using Joins and Defined IT terminologies for the Glossary.
• Experienced with Team-Track SERENA workflow for incidents, service update, and enhancements with respect to the System Development life cycle (SDLC) policies.
• Assisted in replatforming of Oracle Project by updating SQL Server SSIS connection string and testing Manual ETL runs and Selects in Test and Stage.
• Generating Scripts for all the Tables, Views, Store Procedures, User-Defined Functions, and Schemas and also re-mapped the Users & the Database Roles for new environment setup.
• Replicated whole Dev environment to another server.
• Generated scripts for objects from running QA and set up the new QA environment on another DB server.
• Tested DB objects along with ETL packages using Manual Test as well Automation process.
• Worked with PL-SQL queries in Oracle 11i to extract source COMPAS information and track it to final destination of ISDW.
• Documented every phase like Technical specifications, source to target mappings, data models, tests cases and results, and release notes.
• Performed daily and monthly load process by scheduling the jobs as well manually running the batches.
• Provided production support to existing load premium process.
• Provided ECM support by creating roles, assigning rights, approving items using user interface tool and Document query Language(DQL)

Environment: MS SQL Server 2008 R2, SSIS, SSRS, SSAS, Oracle11i, Visual Studio 2008, VSS, Erwin 7.2, Windows 7,Microsoft .NET framework 3.5, C#, JavaScript, ASP.NET, XML, Team-Track, Quest Software - Toad for Oracle, Toad for DB2,VSS, SharePoint, ECM, DQL, Repoint

Confidential, Richmond, VA

MS SQL Developer/BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Dealt with DMVs to check database status and server state to diagnose problems and tune performance.
• Detected and resolved blocking and deadlocks using Profiler, DBCC utilities and DMV’s.
• Troubleshot performance issues and fine-tuning queries, stored procedures and indexes.
• Involved in migration of ING Direct data from SQL Server 2005 to SQL Server 2008.
• Extensively used SSIS packages in migration process to migrate data into Confidential database.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP 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 in 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.
• Designed, Developed and Deployed static as well as dynamic reports, ad hoc reports, Sub-Reports, Drill down reports, Drill through reports and Parameterized reports in MS SQL Server environment using SSRS-2008.
• Involved in the design/development of web forms for the application using ASP.Net, DHTML, XML/XSLT, and CSS (Cascade Style Sheets).
• Developed web pages with ASP.Net AJAX control as per CSS with C# as back-end coding language.
• Used ADO .NET objects such as datareader, dataadapter and dataset to fetch and handle user data with store procedures from SQL Server 2008.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Used “SQLProfilerTSQL Duration” template for tracking execution time of TSQL Statements.
• 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.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, Oracle10g, Visual Studio 2008, VSS, Erwin 7.2, Windows 7,Microsoft .NET framework 3.5, C#, JavaScript, ASP.NET, XML, Report Builder 3.0

Confidential, Peapack, 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.
• Designed user defined functions, triggers, stored procedures, views, created derived tables for optimization of join queries.
• Detected and resolved blocking and deadlocks using Profiler, DBCC utilities and DMV’s.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Migrated database from SQL server 2005 to SQL server 2008 using SSIS packages.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from OLTP to OLAP using SSIS.
• Developed and maintained a combined data store for reporting purposes.
• Generated country wise, region wise reports using Global Variables, Expressions and Functions using SSRS 2008.
• Identified the database tables to store drugs and their outcomes for defining the queries and defined datasets for report generation.
• Defined report layouts in SSRS report template by using company logo, specified color scheme.
• Defined report parameters and wrote queries and procedures for drill down and parameterized reports using SSRS 2008.
• Created canned, parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008.
• Generated daily, weekly and monthly reports tests and outcomes for the managers to view pharmacology business.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Generated cubes and used SQL server analysis service as a source in my reports.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries by putting trace files on different objects.
• Tested the reports and fixed bugs in the stored procedures.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Developed data access layer using C# classes andADO.NET .
• Established backup and recovery of SQL server 2008.
• Used Visual Source Safe (VSS) for version control.

Environment: MS SQL Server 2005/2008, SSRS 2008, SSIS 2008, SSAS 2008, T-SQL, C#, .NET 2.0, Visual studio 2008, ASP.NET, Data Analyzer, java script, MS Access, Excel, SQL Profiler, Windows XP, Erwin 4.2, VSS

Confidential, Hartford, CT

MS SQL Developer/BI Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Designed an OLAP with the help of Erwin to visualize data structure.
• Created complex Stored Procedures, DTS (Data Transformation Service) packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements using dynamically generated SQL.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2005.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Generated daily, weekly and monthly reports using SSRS 2005.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• 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.
• Developed measures and dimension members using Multi Dimensional Expression (MDX) to meet additional needs that were calculated from existing measures.
• Developed MDX expressions for cube calculations and KPIs.
• 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.
• Established a sound backup and recovery policies and procedures.

Environment: MS SQL Server 2005 Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005, T-SQL, VB Script, Windows Server 2003,Erwin 4.0.

Confidential, NYC, NY

MS SQL Developer

Responsibilities:

• Created Logical and Physical data models using Erwin data modeling tool.
• Involved in project planning, scheduling for database module with project managers.
• Developed complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Reorganized database structures as needed, automated procedures at regular intervals.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Compressed data files by removing empty database pages and updating index statistics.
• Created SSIS packages for upgrading the system.
• Migrated data from SQL server 2000 to SQL server 2005.
• Designed and implemented user log in and security.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
• Scheduled and performed data transfers using SSIS including filtering appropriate to the data mart for data analysis.
• Generated Different report using Reporting service SSRS.
• Planned the complete back-up of databases for disaster recovery scenarios.

Environment: MS SQL Server 2000/2005 Enterprise Edition, Visual Studio 2005, SSIS 2005, SSRS 2005, SQL Query Analyzer, SQL Profiler, ASP.Net, Erwin 4.0, Crystal Reports 9.0

Confidential, Portsmouth NH

MS SQL Developer

Responsibilities:

• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS (Data Transformation Service), T (Transact)-SQL, Stored Procedures and Views).
• Logical and physical database development (using ER-win, Normalization, Dimension Modeling and Enterprise Manager).
• Developed complex T-SQL code for the application.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Extensively worked on performance tuning of stored procedure or query by checking the execution plan, creating clustered, non-clustered, covering index.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP-Bulk Copy, DTS and Indexes.
• Looked at the Reports, Tables and ETL-Extract Transformation Loading process.
• Created DTS packages for different task.
• Generated Crystal Reports for analysis.
• Managed and Monitored System Utilization.
• Managed Backup and Disaster Recovery of the systems.
• Managed the security of the servers, part of administration duties.

Environment: MS SQL Server 2000, Windows Server, Windows NT, Erwin, VSS, Crystal Report, BCP, DTS