Business Skills/ Technical Skills:

MS-SQL Server 2012/2008R2/2008/2005/2000, SQL Server Enterprise Manager, Query Analyzer, MS SQL Server Reporting Services SSRS , MS SQL Server Analysis Services SSAS , MS SQL Server Integration Services SSIS , Data Transformation Services DTS , SQL Server Management studio SSMS , Business Intelligence Development Studio BIDS , MS Access, MS Visual Studio, Bulk Copy Program BCP , Microsoft Office, MS Visio 2003/2007/2010, C, HTML, ASP.NET, Crystal Report, Erwin 7.3/4.1/4.0, Performance Point Server, Visual SourceSafe VSS , Team Foundation Server TFS .

Project Summary:

Confidential

MS SQL Server BI/ETL developer

Responsibilities:

• Create data mappings and data dictionaries by understanding business data relationships, Implement Logical and Physical Data model using ErWin to prepare the database structure.
• Create database structure having the data validity check utilizing various constraints and table relationships.
• Writing complex SQL stored procedures, views, functions, triggers, cursors, joins and ad-hoc queries in an effort to enhance the testing automation framework.
• Apply the upgrades in the SQL store procedure, implement with alternative SQL Scripting practices to efficiently execute from cross platform application and improve the performance.
• Performance tuning of Queries and Stored Procedures using graphical execution plan analyzer, monitor performance using SQL Server Profiler and Database Engine Tuning Advisor.
• Created different ETL packages .dtsx files to validate, extract, transform and load data from SQL server 2005/2008 to SQL Server 2008 R2 to effectively handle the database upgrade and data migration.
• Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Experience in developing dynamic SSIS packages using Expression, Variable and automating execution of those by adding Event Handler, Error Handling, logging and checkpoint techniques.
• Involved in Deploying, Scheduling and Monitoring SSIS packages and successfully created dynamic configuration packages in SSIS.
• Develop and document processes to handle data migration between Oracle, DB2, MS Access, MS Excel, flat files, Test data input tools into SQL server tables to support the X12 data generation.
• Experience in creating several Master-Child report drill-down, matrix, tabular, linked, sub-report model for Monthly/Quarterly for client reporting system on SSRS 2008 R2/2008/2005/Crystal reports.
• Expert in writing parameterized queries, using global variables, expressions, functions, implementing grouping and sorting of data, displaying total, subtotals, running total in SSRS reports.
• Create a various ad-hoc reports to analyze the ICD-10 test case execution results to identify the needed changes into the test data to avoid failure and prepare the SQL scripts to apply the needed fixes in test data.
• Used common table expression CTE , Derived Tables, Temporary table, Table variable to hold the intermediate result set and perform summary calculations inside the stored procedures.
• Experience in configuration of Report Server, Report Manager, Report scheduling and assign permissions to different level of users in SSRS 2008 R2/2008/2005.
• Providing immediate defect resolution and resolve performance issues for the test data preparation tools.
• Providing documentation having requirements, design consideration, assumptions, functional and technical description, data model, flow diagrams using ER-Win, Visio 2007 for successful implementation of HIPPA X12 generation framework.
• Involved in using Team Foundation Server TFS and Dimensions for versioning control.

Tools Technologies:

MS SQL Server 2008/2008 R2/2012, SSIS 2008/2008 R2/2012, SSRS 2008/2008 R2/2012, MS SQL Server Profiler, Query Analyzer, SQL Server Index Tuning Wizard, Database Engine Tuning Advisor, Visual Studio 2005/2008, , MS Access 2003/2007, Excel VBA, Erwin v4.1, Windows XP, MS Office 2003/2007.

Confidential

Application DBA/SQL-BI Developer

• MS SQL server database configuration for development, testing UAT environment.
• Define groups, roles, users, Logins and assigning appropriate roles privileges to them.
• Responsible to discuss the requirement with business users for requirement gathering, design and development of the database model.
• Responsible to Create and enhance the complex T-SQL objects like store procedure, function, trigger, view, Index and Table to meet the business requirements and implementation.
• Implement the user define data types, constraints, defaults, and triggers to maintain the database referential integrity.
• Created data models using Microsoft Visio per requirements after discussing with frontend development team and application user, also reverse engineer them to apply normalization to it.
• Created the various types of indexes like Cluster, Non-Cluster, Included to improve query performance.
• Created the Audit trail for key business values using the Trigger to capture the data modification history.
• Used graphical query execution plan analyzer to monitor performance, used SQL Server Profiler and Database Engine Tuning Advisor to optimize the Database performance.
• Developed SSIS package with data validation check to load the data from mainframe system to MS SQL server databases.
• Created SSIS package to Extract, Transform and load the data from CSV, TXT Files to SQL Server database by using various data flow transformations.
• Created data Error Record Retrieval process using the Error Handling redirect row at individual data flow task level, to store the error data with message for fixes and reload from the application screen.
• Implemented the Business rules and Data validation in the SSIS package using the lookup, data conversation, conditional split, SQL queries and store procedure execution.
• Created Auditing for ETL load at package level and at task level to log number of records processed by each package and task using SSIS.
• Responsible for Package Configuration file, Deploying, Scheduling and Maintaining SSIS packages.
• Develop the SQL store procedures to pull the database reports from OLTP environment and make them executable from application.
• Implemented Indexes and partition on tables to enhance the Report performance in OLTP environment.
• Responsible for the Performance tuning of the SQL Queries and the troubleshooting of the technical problems with ORM mapping for .Net application.
• Design backup strategy and recovery plans of SQL server using Maintenance plans and SQL Server Agent Jobs for periodic Backups.
• Enable and utilize the Database mail facility to notify the status of database maintenance plan execution.
• Responsible to design release plans, set up the production server for the UAT, parallel testing efforts.

Tools Technologies:

MS SQL Server 2008, T-SQL, SSIS 2008, MS SQL Profiler, Database Engine Tuning Advisor, Visual Studio 2008, MS Visio 2007, MS Office 2007, Team foundation server 2007, RedGate SQL Compare.

Confidential

MS SQL Server/BI Developer

Responsibilities:

• Created Logical and Physical data model design for Development of the DSR Data Staging Repository for the AMS Asset Management Reporting System using Erwin.
• Implemented constraints based upon Business Rule in the actual data model.
• Worked with data modeling product support team on tool features, functionality and maintenance.
• Designed and developed SSIS ETL packages for loading data from OLTP system, DSR Staging Database to AMS.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Wrote standard complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Used Visual Source Safe VSS for version control.

Tools Technologies:

MS SQL Server 2008, SSIS 2008, SSRS 2008, MS SQL Server Profiler, Query Analyzer, SQL Server Index Tuning Wizard, Database Engine Tuning Advisor, Visual Studio 2008, Erwin v4.1, Windows XP, MS Office 2003/2007, MS Access 2003/2007.

Confidential

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 structure.
• Enhanced PMS data model to incorporate new reporting on wealth management system requirements.
• Build mapping document to map all the data elements from wealth management system to PMS.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2000 using SSIS 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.
• 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.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Tools Technologies:

MS SQL Server 2000/2005, SSIS 2005, SSRS 2005, MS SQL Server Profiler, Query Analyzer, SQL Server Index Tuning Wizard, Database Engine Tuning Advisor, Visual Studio 2005, Erwin v4.1, Windows XP, MS Office 2003, MS Access 2003.