SUMMARY:

• A dynamic professional with 8+ years of working experience in Database programming, System Analysis, Design, Development, Maintenance & Support of MS SQL Server 2000/2005/2008/2008 R2/2012, SQL/SSIS/SSRS/DBA on various domains like Retail, Insurance, and Health.
• Expert in creating complex Stored Procedures, User Defined Functions, SQL Joins and effective Triggers to facilitate efficient data manipulation and data integrity.
• Experience in Migrating from SQL Server 2005/2008 to SQL Server 2012.
• Experience in Performance Tuning, Monitoring and Optimization of T - SQL blocks in both Development and Production environment for SQL server database.
• Strong knowledge in database design features including ER Diagrams, normalization, tables, Temporary tables, constraints, keys, data dictionaries, and data integrity.
• Worked on administration tasks such as backup & recovery, upgrades, creating databases/File groups/files/Transaction logs.
• Having good knowledge in SQL Server Analysis Service (SSAS).
• Strong in Analytical, Technical Skills coupled with Good Communication and Interpersonal Skills and Ability to work in team environment and also individually.
• Proficient in OLTP, OLAP and Data warehousing Design concepts.

TECHNICAL SKILLS:

Databases: MS SQL Server, Oracle 9i

Business intelligence: SSIS, SSRS, SSAS

Version Management: Tortoise SVN (Subversion)

Issue Tracker: JIRA

Operating System: Windows 98 / NT / 2000 / XP/7

Tools: TFS, Ignite(SQL Performance)

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL Server and BI Developer

Responsibilities:

• Worked on Database design, tables, stored procedures, views and indexes for the design specifications
• Creating jobs, scheduling jobs with SQL Server Agent, and SQL Profiler.
• Worked on migrating Teradata jobs to SQL Server using SSIS and worked on Incremental Loads and Delta loads.
• Involved in migrating databases and related objects (tables, views, stored procedures, functions, triggers...) and SQL jobs.
• Involved in migrating SSIS packages and SSRS reports which developed in 2005 version to 2012 version.
• Fine-tuned the performance of various stored procedures while migrating from lower end to higher end.
• Worked in the agile development environment and experience with using Jira story board for projects.
• Worked on Onboarding the WMS (Warehouse Management System) Oracle data and landed the data tables on our production SQL Server with process indexing and considering other constraints
• Support existing projects over the holiday season to ensure the business had all the data and reports available.

Environment: Microsoft SQL Server 2012, Windows 7, SSIS, SSRS 2005/2012 TSQL, Teradata 14.10, Microsoft Visual Studio 2010, Query Analyzer, SQL Query Manager, Query Optimizer

Sr. Database Developer

Responsibilities:

• Involved in creation of Stored Procedures to handle the business logic of the application enhancement.
• Developed SSIS Package to transfer data from DB2 to SQL server 2012
• Involved in maintaining indexes and constraints in tables.
• Involved in query optimization.

Environment: Microsoft SQL Server 2012, SSIS 2012

Solution Developer

Responsibilities:

• Involved in gathering and analyzing the requirements.
• Involved in creation of Data model using Erwin Model.
• Involved in analysis of CDC services for oracle in SSIS 2012 and migrated data from oracle to vertica.

Environment: Oracle 11g, Vertica, Microsoft SQL Server 2012, SSIS 2012

Sr. BI Developer and Database Programmer

Responsibilities:

• Involved in creation of Stored Procedures, functions to handle the business logic of the application.
• Developed SSIS Package for ETL operations, Used to transfer data from SQL to DB2, MSMQ and vice versa.
• Developed SSRS reports for business requirements.
• Performed Query Optimization and Performance Tuning.
• Performed DB Administrator activities like Installation, Backup, Restore, Maintenance (Updating Statistics, Reviewing Indexes).
• Configuring and Monitoring SQL Agent Jobs.
• Troubleshoot outstanding active or blocked transactions.
• Involved in fixing UAT and Production issue.

Environment: ASP .net, C# .net 4.0, SSIS, SSRS and SQL Server 2008

Sr.Database Programmer

Responsibilities:

• Involved in Requirements gathering, Software Requirement Specification.
• Write Unit test cases
• Creation of Stored Procedures, functions, triggers, views to handle the entire business logic of the application.
• Developed SSIS Package for ETL operations
• Assisted testing team for code reviews, bug tracking and defect solving.
• Resolve database performance issues and other distributed data issues.
• Implemented enhancements with new business logic as required by the Client.
• Involved in fixing UAT and Production issue and performance tuning.

Environment: ASP .net, C# .net 4.0, SSIS, SSRS and SQL Server 2008

Sr. Database Developer

Responsibilities:

• Involved in migration of ETL and EDG DB Objects(Tables, Stored Procedures, functions, triggers, index & Constraints)
• Assisted team for code reviews and defect solving.
• Involved in fixing production issues for GI.
• Involved in preparing final execution package.

Environment: Microsoft SQL Server 2008, Sybase 12.5, SSMA tool

Sr. Database Developer

Responsibilities:

• Involved in Requirements gathering, Software Requirement Specification.
• Creation of Stored Procedures, functions, triggers, views to handle the entire business logic of the application.
• Assisted testing team for code reviews, bug tracking and defect solving.
• Backup and restore of database.
• Resolve database performance issues and other distributed data issues.
• Implemented enhancements with new business logic as required by the Client.
• Involved in fixing UAT and Production issue and performance tuning.

Environment: ASP.net, JAVA API, Microsoft SQL Server 2005

Database Programmer

Responsibilities:

• Worked on Database design, tables and creating stored procedures, views, functions and indexes for the design specifications
• Tuned the performance of various stored procedures.

Environment: JAVA, Oracle 9i

Database Programmer

Responsibilities:

• Implemented enhancements with new business logic as required by the Client.
• Deployment of Build/Patch (as per necessary) in Pre Confidence, Testing, UAT, Quality, Preproduction and Production environments.
• Provided support after completion of project while giving suggestions on debugging bugs/defects and finding solution.

Environment: ASP.net, Microsoft SQL Server 2005.

Confidential

Database Programmer

Responsibilities:

• Designing & Creation of Tables, Views, Triggers, and Stored Procedures.
• Understanding the table structure and flow design as per SRS and implemented the logics to migrate client’s live data without affecting any flow.
• Deployment of Build/Patch (as per necessary) in Pre Confidence, Testing, UAT, Quality, Preproduction and Production environments.

Environment: ASP.net, Microsoft SQL Server 2005.