SUMMARY

• Has more than 5 years of experience in IT industry as MS SQL Server Developer/DBA in supporting OLTP and OLAP environment that includes Production 24 X 7 and Development databases.
• Experience working in RDBMS Development with T-SQL, Stored Procedure, Triggers, Transaction Management, DTS, BCP techniques.
• Has worked with MS SQL Server 2005/2008/2012, T-SQL, Oracle 10g PL/SQL, SQL Loader, SQL, and TOAD.
• 2 years experience in Replication Environment for setting up and configure replication snapshot, transactional, or merge to copy, distribute, and synchronize data across multiple servers.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion, data load.
• Experience in developing PL/SQL packages, Database Triggers, Views and SQL Scripts. Have got excellent analytical, communication, programming and problem solving skills.
• Strong believer of automation. Effectively automated various data integration processes using SQL server tools to eliminate error prone manual process across applications.

TECHNICAL EXPERTISE:

• RDBMS : MS SQL 2012,2008,2005, Oracle 10g,11g
• Tools/Utilities : ERWIN/ERX, MS Access, MS SQL Enterprise Manager, SQL Profiler, BCP, Query Analyzer, SQL Server Manager, DTS Import/Export and TOAD, Red gate SQL Compare tool.SQLLiteSpeed,and SSIS
• Languages : T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential

Database Developer/ Build Database Administrator

• Extensively involved in Database development, testing and implementing various Health Insurance Applications. My DBA tasks responsibilities include
• Involved in Maintenance and new capabilities projects as a database developer to effectively support and code the data tier of complex n-tier applications.
• Involved with proactive performance tuning of database applications through following industry best practices for design and stored procedures coding.
• Work with application support and development teams to identify the best approach for the database development.
• Constantly identified process that could be automated through database integration using the SQL Server tools.
• Expertise in writing Stored Procedures/ User Defined Functions for complex business requirements.
• Extensively worked on migrating databases between various environments like Development, Integration, QA and Production.
• Extensively worked on user accounts, logins, Roles and setting up privileges on database objects/servers.
• Implemented ad-hoc requests on production environments.
• Extensively worked on DTS Packages and Command Batch files to Import/Export table's data between heterogeneous databases.
• Extensively worked on performance tuning on database objects like indexes, stored procedures, user defined functions and DTS Packages.

Confidential MS SQL Server Developer/DBA

Confidential is the nation's largest provider of pharmacy services to long-term care facilities. The National Accounts Database System NADS handles all the data related to OCR's National Accounts.

As a MS SQL Server Developer/ DBA

• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Created Stored Procedure to read the Data from MS-Excel Spreadsheet and Populate into Physical tables.
• Created Stored Procedure to Dynamically Pivot the Rows into Columns Values.
• Developed a lot of stored procedures and functions. Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Worked a lot with hierarchical queries.
• Created Database Diagrams. Defined relationship between tables and enforced the referential integrity constraints.
• Created DTS Package to transfer data from the Oracle source database. Also created packages to import data from the MS-Excel spreadsheets.
• Installed and registered the SQL Server, Edited the Server registration properties, Created Logins. Managed the object level permissions and security issues of the server.
• Involved in Unit Testing, Integrated testing and documentation.
• Created custom-tailored Database backup/restore scripts for FULL, Differential and Transactional backups and scheduled the Job.
• Created a Stored Procedure to reconfigure CCM on daily basis and maintain the Change Management for Database Objects.
• Writing code and creating jobs to automate the repetitive tasks.
• Created Triggers to maintain the referential integrity between multiple databases as SQL Server does not support cross-database referential integrity.

Confidential MS SQL Server Developer

It is a Data warehouse System that keeps track of all the research studies conducted on all Animal Species and stores its procedural study and specimen analysis over a period of 7 years. This system also keeps track of the work relation between Students, Procedures, Specimen Analysis, Cost Analysis and Test results, etc. The Delta data files from OLTP system are loaded into the Data warehouse on nightly basis for look-up purposes, like current active Projects and its completion date, Research Status, Cost details and extension required on research and development.

MS SQL Server Developer

• Created T-SQL Stored Procedures, Functions, Views and Triggers and User defined Data Types and Functions to enforce the business rules.
• Created Local DTS package to transfer flat file data from various sources using the FTP task.
• Responsible for setting up and configure replication snapshot, transactional, or merge to copy, distribute, and synchronize data across multiple servers.
• Responsible for loading flat files into stage tables by using BCP and DTS packages.
• Responsible for loading the Delta data from Stage tables into target tables by using stored procedures and user-defined functions.
• Created Triggers to maintain the log history in audit tables.
• Responsible for sending emails to the identified email users after ETL process and scheduled the task.

Confidential

ITC Hotels Limited operates one of India's finest chains under its widely recognized marketing brand ITC-Welcomgroup. . The main goal of the system is to significantly improve the overall quality of the current salary planning system and reduce the cycle time considerably to help ITC managers and compensation staff, determine up-coming salary changes.

As a MS SQL SERVER Developer

• Created Physical Primary and Secondary Files and File Groups.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, and user defined data types and functions.
• Created Database Diagrams. Defined relationship between tables and enforced the referential integrity constraints.
• Created Clustered and Non-Clustered Indexes.
• Responsible for Query Performance tuning and Optimization
• Responsible for setting up and configure replication snapshot, transactional, or merge to copy, distribute, and synchronize data across multiple servers.
• Responsible for Transaction logs management filling up, adequacy, planning for growth
• Involved in Monitoring, continuously improving the ETL processes, and Performance tuning of the loads.
• Confidential MS SQL SERVER Developer
• Created T-SQL Stored Procedures, Functions, Views and Triggers and User defined Data Types and Functions to enforce the business rules.
• Created Local DTS package to transfer flat file data from various sources using the FTP task.
• Responsible for loading flat files into stage tables by using BCP and DTS packages.
• Responsible for loading the Delta data from Stage tables into target tables by using stored procedures and user-defined functions.
• Created Triggers to maintain the log history of all tables.
• Responsible for sending emails to the identified email users after ETL process and scheduled the task.
• Responsible for writing awk and sed scripts to clean / massage the flat files.
• Created PL/SQL Packages, Stored Procedures and Functions for Oracle Database.
• Identify/debug, troubleshoot, modify, document, test and fix production issues.