SUMMARY:

A position that will utilize my years of experience in Database Development/BI Development, Database Administration or Programming both in SQL Server and MongoDB.

SUMMARY:

Confidential

Database Engineer

Responsibilities:

• Designed Mongo data models using Erwin data modeler version 9.5.
• Responsible for database, collection design and maintenance for MongoDB databases.
• Developed java scripts for CRUD operations.
• Upgraded MongoDB database version from 3.0 to 3.2 and higher.
• Designed and setup database with Replication and Sharding.
• Provided production support for ROBO rebalancing critical trading systems which are responsible for billions under management.
• Coordinated and implemented collection archiving and sharding on MongoDB which resulted in 25% performance improvement and 20% reduction in data footprint.
• Provided best practices and database access patterns reviews for all the application teams.
• Good working knowledge of OpsManger.
• Designed data models using Erwin data modeler version 9.5.
• Responsible for database design and maintenance.
• Developed SQL scripts to create new tables and views, DML SQL scripts for inserting, updating and deleting data in the new tables.
• Worked on designing Views, Stored procedures, Functions, Triggers for the applications.
• Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance Tuning
• Worked on Complex SSIS packages for Extract Transform and Load Operations from different data SOR (System of Records) with different disparate data sources like Oracle, Teradata, Composite Data source, flat files, Csv files and Excel files
• Implemented different control flow and Data flow tasks on the extracted data to convert data into required format.
• Developed complex VB.NET Scripts for SSIS packages to in corporate dynamic flexibility
• Implemented Logging and Package Configurations for all the SSIS packages developed
• Wrote different expressions for SSIS packages to build source paths, destination paths and names dynamically
• Experience with Data migration using BCP, importing and exporting from flat files using format files to MS SQL server database.
• Implemented Log Shipping using SQL Server 2008 R2 for different production servers
• Implemented Always On using SQL Server 2012 for different production servers
• Provide production support for patching, Report validation and Database validations, SSIS daily loads
• Implemented Error handling and Troubleshooting mechanism using send mail task and log files for Auditing.
• Developed automated Power shell scripts to run ETL deployments, Database backups, evaluate policies on different production servers.
• Developed applications as part of Agile Methodology, working knowledge of all the phases of Agile Methodology
• Migrated different application databases from .
• Acted as database point of contact for resolving production issues related to Portfolio Center product.

Environment: Windows 2012, SQL Server 2012, SQL Server Data Tools, Windows XP, MS SQL Server 2005, SQL Server Integration Services 2005, SQL Refactor, BIDS Helper, SQL Data Compare, Microsoft Visual Studio 2005, Team Foundation Server 2010, And SQL Server Reporting Services 2005, C# .Net and VB .Net, MongoDB 3.0 & 3.2 & 3.4 & 3.6

Confidential

Senior SQL Server Developer / DBA

Responsibilities:

• Designed data models using Erwin data modeler version 9.5
• Responsible for database design and maintenance.
• Developed SQL scripts to create new tables and views, DML SQL scripts for inserting, updating and deleting data in the new tables
• Worked on Views, Stored procedures, table valued functions, Triggers
• Involved with application team to optimize database objects like stored procedures, Triggers, Table valued functions and Views.
• Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance Tuning
• Worked on Complex SSIS packages for Extract Transform and Load Operations from different data SOR (System of Records) with different disparate data sources like Oracle, Teradata, Composite Data source, flat files, Csv files and Excel files
• Implemented different control flow and Data flow tasks on the extracted data to convert data into required format.
• Developed complex VB.NET Scripts for SSIS packages to in corporate dynamic flexibility
• Implemented Logging and Package Configurations for all the SSIS packages developed
• Wrote different expressions for SSIS packages to build source paths, destination paths and names dynamically
• Experience with Data migration using BCP, importing and exporting from flat files using format files to MS SQL server database.
• Provide production support for CRD, MIDAS applications
• Implemented Log Shipping using SQL Server 2008 R2 for different production servers
• Implemented Always On using SQL Server 2012 for different production servers
• Provide production support for patching, Report validation and Database validations, SSIS daily loads
• Implemented Error handling and Troubleshooting mechanism using send mail task and log files for Auditing.
• Developed automated Power shell scripts to run ETL deployments, Database backups, evaluate policies on different production servers.
• Developed applications as part of Agile Methodology, working knowledge of all the phases of Agile Methodology
• Migrated different application databases from .
• Working knowledge of Service Broker Architecture as part of MIDAS application.

Environment: Windows 2012, SQL Server 2012, SQL Server Data Tools, Windows XP, MS SQL Server 2005, SQL Server Integration Services 2005, SQL Refactor, BIDS Helper, SQL Data Compare, Microsoft Visual Studio 2005, Team Foundation Server 2010, And SQL Server Reporting Services 2005, C# .Net and VB .Net.

Confidential

Senior Consultant

Responsibilities:

• Responsible for data maintenance.
• Developed SQL scripts to create new tables and views, DML SQL scripts for inserting, updating and deleting data in the new tables
• Worked on Views, Stored procedures, table valued functions, Triggers
• Involved with team to optimize database objects like stored procedures, Triggers, Table valued functions and Views.
• Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance Tuning
• Worked on Complex SSIS packages for Extract Transform and Load Operations from different data SOR (System of Records) with different disparate data sources like Oracle, Teradata, Composite Data source, flat files, Csv files and Excel files
• Implemented different control flow and Data flow tasks on the extracted data to convert data into required format.
• Developed complex VB.NET Scripts for SSIS packages to in corporate dynamic flexibility
• Implemented Logging and Package Configurations for all the SSIS packages developed
• Wrote different expressions for SSIS packages to build source paths, destination paths and names dynamically
• Developed a package to dynamically download file from SharePoint portal and convert them in to required format using metadata driven tables
• Experience with Data migration using BCP, importing and exporting from flat files using format files to MS SQL server database.
• Provide production support for the WCDIR application using AUTOSYS 4.5.1 version
• Provide production support for patching, Report validation and Database validations
• Implemented Error handling and Troubleshooting mechanism using send mail task and log files for Auditing.

Environment: Windows XP, MS SQL Server 2005, SSIS, SSRS, BIDS Helper, SQL RedGate Tools, Microsoft Visual Studio 2005, Team Foundation Server 2010, C# .Net and VB .Net.

Confidential

Programmer Analyst

Responsibilities:

• Master Benefit Grid, AutomatedOutboundMessaging, State Extracts (Pharmacy, Claims Extracts), PDE Claims Extract
• Worked as a SQL,SSIS and SSRS Developer

Confidential

MS SQL Server Developer/BI Developer

Responsibilities:

• Business Critical Reporting
• Worked as a SQL,SSIS and SSRS Developer