SUMMARY:

• Over Twelve years of experience primarily in designing and developing Microsoft SQL Server databases with Data Warehousing Development/Production Support and testing Database, Client/Server and Web based applications.
• A Microsoft Certified Professional with over 12 years of proven IT experience in Design, Development, Implementation and Support of SQL Server 2005/2008/2012 /2014 with a strong understanding of data & analytics and also expertise in testing Database, Client/Server and Web based applications.
• Demonstrated experience in BI/ETL architectural analysis and designing databases using logical and physical data models, providing data flow diagrams, transformation logic, source to target data mapping spreadsheets, data dictionary etc.
• Experience in designing and developing different RDBMS systems and BI interfaces to perform ETL operations on wide variety of data sources.
• Experience in performing large volume data conversion, data analysis, data cleansing and production report generation for a number of Data Marts and Operational Data Stores in achieving the scalability on various EDW applications.
• Hands on experience in source to target data mapping, Slowly Changing Mapping Creation, Star/Snowflake Schema Mapping Creation and Meta data management.
• Expert in developing database schemas and objects using simple to complex T - SQL queries involving Joins, Stored Procedures, Views, Indexes, Indexed Views, User Defined functions, Triggers, Table Partitioning, Change Tracking, Change Data Capture, MERGE statement, Exceptional Handling, Transactions etc.
• Experience in Query and Index tuning using Execution plans, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Expert in using SQL Server Import/Export wizards, Bulk Insert and BCP utilities.
• Experience with database source and version controls like DB Control, Team Foundation Server.
• Employing best practices and standards while developing complex SQL Server objects to maintain optimal performance.
• Expertise in SSIS development and Support of complex data warehouse systems and various segments of Software Development Life Cycle (SDLC) using MS SQL Server 2005/2008/2012 /2014 and SQL Server Integration Services.
• Well-versed in different testing methodologies including Unit testing, System Integration testing, UI, Functional, Regression and End-to-End on various test environments such as DEV, SIT, UAT and IR.
• Hands on building Test Scenarios based on Traceability Matrix methodology, preparing Test cases and executing Test Suites.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies
• Quick learner with ability to master new concepts and applications.

TECHNICAL SKILLS:

RDBMS/DBMS: SQL Server 2014/2012/2008/2005 and Teradata

Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Profiler, Database Tuning Advisor, Bulk Copy Program (BCP) utilities

Version Control System: DB Control, Team Foundation Server

Defect Management Tracking tools: Clearquest, Bugzilla.

Ticketing System: Tivoli Service Request Manager (TSRM)

Programming Languages: TSQL, UNIX, C, HTML, VB script

Operating System/Servers: Windows 9x/Windows 2000/Windows NT/Windows Server 2003/Windows XP

PROFESSIONAL EXPERIENCE:

Confidential - CT

Sr. DW/ BI Engineer

Responsibilities:

• Involved in Business Requirement Analysis and ETL Development for extracting and loading client data.
• Designed a programmable SSIS Package using several transformations to load from heterogeneous sources such as flat file, Excel and SQL Server 2012/2014 using SSIS, BCP and Bulk Insert and produce a variety of client extracts.
• Performed BI/ETL architectural analysis and designed databases using logical and physical data models, provided data flow diagrams, transformation logic, source to target data mapping spreadsheets, data dictionary etc.
• Helped in developing and monitoring History/Incremental/Daily Loads for different subject areas like Members, Providers and Claims (Medical, Facility, Rx, etc.) and supported all scheduled ETL jobs for batch processing.
• Designed and developed different RDBMS systems and BI interfaces to perform ETL operations on wide variety of data sources.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Created sequences, Triggers, index's, constraints and views as part of physical data modeling using Erwin and provided model change Erwin scripts.
• Designed ETL Structures using SSIS; Tabular & Multidimensional databases using SSAS; and Data warehouses using SQL Server 2012/2014.
• Migrated SSIS 2005/2008 packages to 2012 and implemented project deployment model.
• Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.

Confidential

SQL Server Developer

Responsibilities:

• Studied existing Data Modeling, Requirement Analysis and provided gap analysis.
• Involved in understanding and reviewing the technical requirements and existing data models.
• Developed and optimized database objects like tables, views, functions, stored procedures, and triggers for validation and loading processes.
• Designed and developed the Staging Databases and load data from source to staging and from staging to the destination tables.
• Extracted data from various sources like SQL Server 2005/2008/2012, CSV, Excel and Text file from Client servers and through FTP
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using SQL Server Profiler and Database Engine Tuning Advisor.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Scheduled and maintained routine SQL Server Agent jobs, tasks, and alerts for different load frequencies.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Supported code migrations from lower to higher environments using version and source controls like TFS and DB Control.
• Responsible for Unit testing and supported code migrations to higher environments.
• Implemented Slowly Changing Dimension using SSIS to maintain historical data retention in Data Warehouse
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, and other project stakeholders.
• Provided On-Call support to Mission critical Environments.

Environment: MS SQL Server 2005/2008 Enterprise Edition, Teradata SQL Assistant, SSIS, SSRS, DB Control, MS Visual Studio 2005, ASP.NET, Team Foundation Server, ClearQuest, Windows 7

Confidential

Software Engineer - SQL Server Programmer

Responsibilities:

• Involved in studying existing OLTP Data structure, Requirement Analysis, ETL Design and Development for extracting and loading data.
• Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server 2005/2008.
• Involved in creating database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, and Triggers.
• Involved in writing scripts to check for duplicate records, delete/modify and insert new records depending on the business rules.
• Created traces using SQL server profiler to find long running queries and tuned the queries as part of Performance Tuning operations.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Involved in preparing and maintaining scripts, indexes and complex queries for data analysis and extraction. Used various types of joins and subqueries involving multiple tables. Developed Tables, CTEs, temporary tables, function as per business requirements.
• Identified SQL objects having high fragmentation levels and tuned the queries by rebuilding indexes and achieved better performance.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Scheduled and maintained routine SQL Server Jobs, tasks, and alerts to automate the execution process.
• Also used SSIS Import/Export Wizard for performing the ETL operations.
• Loading data in Dimension Tables in SQL Server using SSIS Packages.
• Involved in Unit testing and Integration testing for various modules.

Environment: Windows 2000/NT/XP, SSIS, SSRS, SSAS, T-SQL, OLAP, OLTP, MDX, ADO.Net, Query Analyzer, MS Office 2003.

Confidential

Software Test Engineer - SQL Server Developer

Responsibilities:

• Responsible for analyzing and understanding Business and Technical requirements.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Involved in preparing and reviewing several test artefacts as per the requirements.
• Involved in preparing test scenarios, test cases and documenting test results.
• Handled responsibilities of conducting smoke testing as well as reviewing results.
• Responsible for test data management as well as test scripts as per product requirements.
• Involved in monitoring and completing test execution phase and reporting test status to the teams.
• Involved in analyzing the test results and reporting suggestions and defects in triage meetings.
• Involved in reporting defects into Bugzilla defect tracking system.
• Interfaced with developers to resolve technical issues and suggested possible application improvements.

Environment: Microsoft Business Intelligence Studio, SQL Server 2000/2005, SSRS, VB.net, Windows Advanced Server, MS Excel, MS PowerPoint