SUMMARY

• 9 + Years of experience with MS SQL Server 2000/2005/2008/2012 as a database developer in insurance, financial, healthcare and tax domains.
• Expertise in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Replication and Documentation.
• Expertise in performing various types of testing, such as System integration testing, End to End functional testing, performance testing, regression and comparison testing
• Expertise in designing tables, SQL queries, creating Indexes, triggers, Views, Complex Stored Procedures and User defined functions.
• Experience in Query optimization, performance tuning of Stored Procedures and deadlock resolution.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Experience in MS SQL Server administration and maintenance including Backup/Restore, Scheduling and monitoring jobs, Performance Tuning, and SQL Mail Agent.
• Creation of Roles, Logins and managing user permissions.
• Experience in developing, testing and deploying of SSIS packages.
• Experience in ETL (Extract - Transform - Load) using SQL Server Integration Services 2012/2008/2005 (SSIS), DTS, Bulk Insert.
• Good knowledge in developing and designing reports through SSRS and Excel.
• Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.
• Involved in Migration from heterogeneous sources including Oracle, Sybase etc to MS SQL Server.
• Experience in creating and maintaining Test Plan which includes description of the item being tested and its scope, user requirements, environmental needs, risk assessment, approach and methodology
• Performed deployment and customization of Analysis cubes.
• Involved in User acceptance test (UAT) and Integration testing with QA team.
• Involved in defect creation, defect tracking, defect reporting for assigned defects
• Good organization with excellent Oral and written communication skills.
• Excellent team player with problem solving and trouble-shooting capabilities

TECHNICAL SKILLS

DBMS: MS SQL Server 2000/2005/2008/2012, MS- Access2000/2003

Programming Languages: T-SQL, SQL, PL/SQL, C, C++, C#.NET, VBA

Operating Systems: Windows Server 2003/2008, Windows XP, DOS,Unix

Web Technologies: ASP.NET, HTML, XML

Scripting languages: VB Script, Java Script

Application Servers: IIS 5.1

Automation Testing Tools: Quick Test Pro, Quality Center, Test Director 8.0

IDE/Tools: DTS, SSIS, SSRS, BCP, MS Visual studio.NET, MS VSS (Source safe)

Applications: MS Dynamics Great Plains 9/10, E-Connect, MS Office suite

PROFESSIONAL EXPERIENCE

Confidential, Richfield, MN

Technical Lead - Data Management

Responsibilities:

• Involved in gathering business rules and business requirements to validate data.
• Data Profiling and Cleansing by developing complex stored procedures and T SQL Scripts
• Analyze different business requirements and provide time estimate for all SDLC phases like Analysis, Design, Coding, implementation, SIT, UAT and Production Move.
• Designed and developed End-to-End ETL framework using SSIS to populate Data Warehouse and data marts.
• Data Extraction, Transforming and Loading (ETL) using various tools such asSQLServer Integration Services (SSIS/SSDT), DTS, Bulk Insert and BCP.
• Design and Review of logical and physical data models.
• Create various complex stored procedures and views for implementation of Business logic.
• Load flat files data into database using SSIS after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Design and develop tabular model with SQL Server Analysis Services
• Create reports using Microsoft Reporting Services (SSRS). Extensively usedSQL Reporting Services to generate custom reports.
• Perform tuning of SQL queries and stored procedures.
• Problem identification, troubleshooting, bug fixing and tuning of databases.
• Involved in defect creation, defect tracking, defect reporting for assigned defects.
• Provided documentation for the complete process along with SSIS and SSRS design architecture and implementation.

Environment: Windows Server 2008, SQL Server 2012, SQL Server Parallel Data warehouse (PDW), SSIS/SSDT, SSAS, SSRS, Visual Studio 2012, Team Foundation Server, SAP Sybase PowerDesigner 16.5, Microsoft Project 2013, MS Visio 2013, Master Data Services, Powerpivot, Teradata SQL Assistant, QlikView.

Confidential, Chesterbrook

Lead SQL Server Developer

Responsibilities:

• Serve as a member of a specialized team interacting with developers and business users to analyze and configure database systems.
• Create databases in development, testing and staging environments
• Gather, identify and document business requirements.
• Analyze different business requirements and provide time estimate for all SDLC phases like Analysis, Design, Coding, implementation, SIT, UAT and Production Move.
• Generate SQL scripts to create or drop database objects including tables, indexes, Stored Procedures, Views and Triggers
• Create various complex stored procedures and views for implementation of Business logic.
• Create reports using Microsoft Reporting Services (SSRS). Extensively usedSQL Reporting Services and Report Builder to generate custom reports.
• Defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2012.
• Lead development effort for data migration.
• Create store procedures and SSIS packages to migrate tables from the legacy database to MicrosoftSQL Server 2012.
• Data Extraction, Transforming and Loading (ETL) using various tools such asSQLServer Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Load flat files data into database using SSIS after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Redesigned SSIS packages after applying necessary transformations.
• Perform tuning of SQL queries and stored procedures.
• Create Alerts for successful or unsuccessful completion of scheduled Jobs
• Performed various types of testing, such as System integration testing, End to End functional testing, performance testing, regression and comparison testing
• Automating testing components to increase the efficiency of testing process.
• Problem identification, troubleshooting, bug fixing and tuning of databases.
• Involved in defect creation, defect tracking, defect reporting for assigned defects.

Environment: Windows Server 2008, SQL Server 2012/2008/2005, SSMS, SQL Profiler, SSRS,SSIS, MS Office, Visual Studio, Test Director 8.0

Confidential, Alexandria

Associate

Responsibilities:

• Involved all phases of software testing life cycle ensuring Test plans, Test Strategies and Test cases are completed to meet business requirements.
• Evaluate technical requirements, lead development effort for migration including development, testing.
• Coordinated with the business analysts, SMEs and developers and discussed issues in interpreting the requirements
• Generate SQL scripts to create or drop database objects including tables, indexes, Stored Procedures, Views and Triggers
• Generate complex T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constraints and triggers to preserve data integrity.
• Designed SSIS packages to handle heterogeneous data from various external sources.
• Develop ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures.
• Created SSIS Packages using Derived Columns, Condition Split, Execute SQL Task, Data Flow Task, and Execute Package Task etc. in SQL Server Integration Services.
• Create performance reports using SSRS using perfmon counters for SQL performance.
• Create parameterized, drill down, chart, matrix, sub reports using data from a multiple sources.
• Extensively worked on performance testing of the new consolidated server environment which included creating performance counter logs and SQL server trace logs
• Determined the scalability of the Production server configuration and benchmarked the server’s performance under load.
• Create various support documents like Business Requirement Documents
• Automating testing components to increase the efficiency of testing process.
• Involved in defect creation, defect tracking, defect reporting for assigned defects.
• Introduced documentation process for test scripts and created detailed documents explaining in detail the process and procedure for each test script created.

Environment: Windows Server 2008, SQL Server 2008/2005, SQL Profiler, SSIS 2008, SSRS, MS Office, Visual Studio 6, Test Director 8.0

Confidential

SQL Server Developer

Responsibilities:

• Created databases in production, development, testing and staging environments
• Generate SQL scripts to create or drop database objects including tables, indexes, Stored Procedures, Views and Triggers
• Created various stored procedures for implementation of Business logic.
• Perform tuning of SQL queries and stored procedures in production servers using Index Tuning Wizard.
• Involved in QA testing process including generation of test scripts.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Developed various SSIS packages to import data from multiple data sources.
• Importing and Exporting data from XML documents using FOR XML commands.
• Performed Ad-Hoc report generation using SSRS.
• Performed database backup/restoration, attach/detach activities.
• Problem identification, troubleshooting, resolution, and index tuning databases.

Environment: SQL Server 2005/2008, SSIS, SSRS, Visual Studio.NET, Windows server 2003, VB Script, MS Office

Confidential, St.Louis

Microsoft Dynamics Support Engineer, Analyst and Programmer

Responsibilities:

• Installed, upgraded SQL Server 2005/2008 for various clients.
• Migration of data from various sources in to SQL Server 2005/2008.
• Creating database objects like stored procedures, Triggers, Tables, Views and functions in the process of customizing Microsoft Dynamics GP and CRM products.
• Responsible for all Production SQL servers' maintenance and troubleshooting database problems.
• Importing and exporting data using DTS and SSIS.
• SQL maintenance job creation and scheduling.
• Performed database backup/restoration, attach/detach activities.
• Developed various SSIS packages to import data from multiple excel document sources into SQL Server database tables to use in SSRS reports.
• MDX queries to query Analysis services 2005 databases.
• MS Dynamics great plains component installation, utilities and migration tools.
• Custom data migrations, mapping, data conversion and testing.
• MS Dynamics GP customization using Visual studio.NET and VBA.

Environment: Windows Server 2003/2008, SQL Server 2008/2005/2000, Unix,SQL Profiler, SSIS, SSRS, MS Dynamics Great Plains 10/9, MS Office, Visual Studio 6, Visual Source Safe, VB Script

Confidential

SQL Server Developer

Responsibilities:

• Involved in various stages like development, system analysis, design and database administration.
• Written various stored procedures for Application Developers and some user defined functions.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Regularly monitored the system for bottlenecks and suggest/implement solutions..
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created Jobs to extract data from different sources using SSIS packages.
• Stored Procedures called the SSIS package that would aggregate the data and load them in globally temporary table, having the same architecture as the table for which the import is done.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Used SSIS packages to roll our data to Live Tables.
• Used SQL Server Reporting Services to generate different types of Ad-hoc Reports.
• Configured SQL Mail agent for sending Automatic emails when a SSIS Process is Failed or Succeed.
• Uploading and downloading files using FTP.
• Provided support in fixing stored procedure issues on production servers.

Environment: SQL Server 2005/2000, SSIS, DTS, BCP, Windows Server 2003, java Script

Confidential, Chicago

Programmer Analyst

Responsibilities:

• Involved in entire life cycle including Database design, Development, Testing, Optimizing and Deployment.
• Creating database objects stored procedures, Triggers, Tables, Views and functions.
• Migrating packages from DTS 2000 to SSIS.
• Worked Extensively with Data Transformation Services (DTS) to import, export and transform the data between the linked servers..
• Importing and exporting rates tables data using BCP
• Tuning of complex queries and stored procedures.
• Setup the backup and restore strategy for production and test environments. Performed database attach and detach activities.
• Report generation using SQL Server Reporting Services and MS excel.
• Provided production support for rating incidents

Environment: Windows NT, TAP, Policy Center, QTP, Quality Center, DB2, VB Script, SQL Server 2005/2000, SSIS, DTS, BCP, QMF, SPUFI, OS390

Confidential

QA Analyst

Responsibilities:

• Worked with Application Development and Business analyst team to understand the application and requirement for the application testing..
• Involved in Analyzing business and functional requirement to design and execute SIT and UAT Test Cases.
• Prepared and executed SQL queries for Database verifications
• Documented and communicated test results.
• Documenting the project report including Test planning, execution, defect reporting and results.
• Used Visual Source Safe for version control.
• Performed user testing on new versions and new modules before user acceptance test.

Environment: Windows NT, Winrunner, HTML, Server 2000, Visual Basic, VSS