Summary

• More than 7yearsof experience with design, architecture, development, implementation and maintenance of databases and software systems involving high availability transaction processing systems.
• Sound knowledge of SQL Server architecture, Stored Procedures, Cursors, Triggers, T-SQL Scripts and Views.
• Expert knowledge of MS SQL Server 2000, 2005, 2008 and ORACLE 10g.
• Experience as a MS SQL Server Database Administrator.
• Experience in Data Modeling using ERwin 7.3.
• Experience in creating and maintaining DTS / SSIS packages.
• Expert Knowledge of Data Warehousing Concepts, modeling data warehouse and knowledge in Informatica 7.1.
• Rich experience in troubleshooting database related issues involving performance using SQL Profiler, Execution Plan and Statistics.
• Experience in migration of data from Excel, XML, and Flat file to MS SQL Server by using SSIS, DTS and BCP.
• Direct and participate in the conceptual database design and specifications.
• Develop, document, and enforce the standards, security procedures, and controls for access to ensure the integrity of the database system.
• Establish, maintain and control the project data model and data dictionary.
• Responsible for Monitoring Production Server Health.
• Monitored various production jobs like Full Backup, Differential Backup and Daily Health Check jobs.
• Migrated data into multiple databases using SQL loader and Oracle Import/Export Utility.
• Indexing large tables with optimal indexing mechanism like function based index, Bitmap index.
• More than 1 yearof experience in Teradata 6.0.
• Expert knowledge of Teradata MLOAD and FASTLOAD Tools.
• Experience in Java, J2EE and UNIX shell scripting.
• Experience in SQL Server Reporting Serviceand generated reports from a wide range of data source.
• Participate and contribute in process improvement activities at the project and corporate level.
• Highly motivated team player with good inter-personal skills and possesses good communication skills.
• Efficient in the execution of all assignments, eager to take on new challenges.

Expertise

Databases: MS SQL Server 7.0/2000/2005/2008, Oracle 10g, Teradata 6.0, Sybase Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Enterprise Manager, Profiler, Query Analyzer, SQL Developer, Teradata SQL Assistant 12.0, MLoad, Fastload ERP: Ramco Virtual Works (RVW) 1.4.3 / 2.0 Application Servers: Sun Application Server Programming Language : Java , J2EE Data warehouse Tools: Informatica 7.1, Cognos 7.3 Operating System: Windows 98/2000/XP, Windows NT 4.0, UNIX Version Control Tools: SVN 1.6, VSS 6.0, Clear Case 5.0, CVS DB Design Tools: Erwin 7.3, Visio 2000

Certification

• Microsoft Certified Professional asDesigning and Implementing Database with Microsoft SQL Server 2000 Enterprise Edition.
• Microsoft Certified as Implementing and Maintaining Databases with Microsoft SQL Server 2005.
• Brainbench Certified Professional in RDBMS Concepts.

Educational Qualification Master of Science (Software Engineering)

Professional Experience

Employer: Confidential Aug 10 - Till Date Database Design Engineer Confidential Data Warehousing It's a corporate repository tool for Executive Management, Program Managers and Project Manager which helps to understand the Project hierarchy, Contract hierarchy, Project Cost and Employee utilization. Following are the various reports available

• Cost & Hours by Contract
• Employee Utilization
• Program Hierarchy
• Charge Code by Program
• Resources by Program

Confidential also captures Measurement and Analysis Metrics like Cost Variance, Schedule Variance, Risk, Pre and Post Production Bugs and Non Conformances and produce Quad-chart Report.

Responsibilities:

• Analyze and define the logical and physical database structure based on the project requirements.
• Created SSIS package to load the data from the various source like MS Excel, GCS Premier and Deltek Time & Expense.
• Responsible for creatingstored procedures, view, T-SQL scripts to implement the business.
• Perform database administration activities like configuration, backup and maintenance of the databases in multiple environments.
• Involved in gathering requirement and creating requirement document.
• Establish, maintain and control the project data model and data dictionary.
• Involved in optimizations and fine-tuning of stored procedures and T-SQL scripts.
• Coordinate with report developers.
• Responsible for code integration and code review.
• Involved in Unit and Integration Testing.

Environment:SQL Server 2008, SSRS, Office Writer 7.0, Windows XP, ERwin, SVN.

Client: Confidential Aug 09 - July 10 Sr. Database Developer Confidential It's a web-based application developed to achieve a flexible, scalable Supply Chain System that can handle multiple partners, sales channels, products and services with a highly automated and configurable platform. Specific initiatives that system should be able to support include:

• Re-Branding
• Re-Marketing
• Policy Management

Responsibilities:

• Played a key role in requirements gathering from the client and created systems requirements document after analysis.
• Created stored procedures, table and T-SQL scripts to implement the business.
• Involved in optimizations and fine-tuning of stored procedures and T-SQL scripts.
• Responsible for project release for QA and Production system.
• Responsible for code integration and code review.
• Managed the offshore team for successful delivery of releases.
• Involved in Unit and Integration Testing.

Environment: ORACLE 10g, SQL Server 2000, Sun Application server , UNIX, J2EE, Windows 2000, Windows XP, Visio 200, CVS, SVN.

Client: Confidential, Arlington - VA Sep 08 - Aug 09 Sr. SQL Server Developer / Teradata Developer Revenue Assurance The objective is to identify and evaluate Confidential Provisioning and Billing systems to detect and correct anomalies to bring lost revenue back to the company. The application is limited to evaluate Business and Residential customers. The Application gets the provisioned feeds and compares it with billing feeds and then checks for the potential anomaly if exists using various business rules acquired from product level managers.

Modules:

• Vertical Feature
• Subscriber Line Charge
• Billing Outliers
• Zero Bill Suppression
• VZBAT Automation
• Permanent No Treatment

Responsibilities:

• Created stored procedures, functions, table, views and T-SQL scripts to implement the business.
• Coordinated with the product level managers to acquire the business rules associated for each product to identify the anomalies.
• Extensively involved in creating MLoad and Fastload scripts to load data from flat file into Teradata.
• Involved in optimizations and fine-tuning of stored procedures and T-SQL scripts.
• Involved in creating SSIS packages to load data from Flat file and XML to MS SQL Server.
• Migrated DTS packages to SSIS packages.
• Automated the recursive data request made by the marketing team by using dynamic quires in the stored procedures.
• Involved in Unit and Integration Testing.

Environment: Teradata 6, SQL Server 2000/2005, MLoad, Fastload, SQL Profiler, SSIS, DTS, SQL Server Business Intelligence Development Studio, Windows 2000, Windows XP, Visio 200, Clear Case 5.0.

Client: Confidential, NJ Apr 08 - Aug 08 Sr. SQL Server Developer Confidential It's a web-based application used for the processing and maintaining insurance policies. The Lead Management System (LMS) module of the application is used to keep track of the identified lead with their complete information. The lead identified depending on predefined rules escalates to the next level of sales. Administrator of the system can define the workflow definitions and rules so that the system automatically identifies the next level / CSR to handle the lead. Reports can be generated to analyze the lead generation and resolution pattern.

Responsibilities:

• Created and managed complex stored procedures involving application Logic.
• Generated reports from a wide range of data source and designed report layouts using crystal reports.
• Extensively involved in optimizations and performance tuning of stored procedures, adding/deleting indexes and re-indexing.
• Built and maintained database servers on development environments and testing environments.
• Involved in Unit and Integration Testing.

Environment: SQL Server 2000/2005, SQL Profiler, SSIS, DTS, SQL Server Business Intelligence Development Studio, Crystal Reports, Windows 2000, Windows XP.

Client: Confidential Aug 07 - Feb 08 Employer: Verizon Data Services India Sr. SQL Server Developer / DBA Confidential As a SQL Server Developer/DBA I was involved in developing and maintaining database for a web-based application, used to get order from customers and provides interface to track of status of the orders placed on Verizon portal.

Responsibilities:

• Extensively worked on the Order Fulfillment (OF) and Order Placement (OP) Servers.
• Created stored procedures, functions, views and T-SQL scripts to implement the business for the application like eCORS, VGI, ROCS and SPOT.
• Involved in creating DTS / SSIS packages togenerate reports for VGI, eCORS applications.
• Carried out numerous optimizations and fine-tuning of stored procedures.
• Involved in fine-tuning issues on the Database Server by re-indexing, index de-fragmentation and updating the statistics.
• Migrated DTS to SSIS packages.
• Day-to-day database upgraded according to the developer requests such as adding new column, stored procedure, tables, indexes etc.
• Involved in Unit and Integration Testing.
• Responsible for Code reviews of the developer written SQL code.

Environment: SQL Server 2000, SQL Profiler, SQL Server 2005, SSIS, DTS, SQL Server Business Intelligence Development Studio, Windows 2000, Windows XP, Clear Case 5.0.

Client: Confidential Oct 06 - Aug 07 Employer: Confidential SQL Server Developer Medical Analyzer (MA) It's a web-based application developed for IMS to provide real time answers to real time business issues/questions, increase the analysis speed for medical data and enabling rapid evidence-based decision making. The Data Load phase loads the reference data and transaction data available in the MA staging server. The analysis is done on these data based on the questions and report as shown for decision-making.

Responsibilities:

• Responsible for logical and physical design with a significant effort towards application and database tuning.
• Hands on experience in migration of Data from Flat file, XML, Excel, Oracle to MS SQL Server by using DTS packages to implement the business as to load the reference data and transaction data from the MA staging server.
• Built and maintained database servers on development environments and testing environments.
• Experience in creating partitioning on huge transactional table.
• Provided detailed plan to upgrade existing objects in SQL Server 2000 to SQL Server 2005 and implemented it.
• Visio was used for data modeling.
• Performed Unit and Integration Testing and documented the test results.
• Worked on documenting the release process.

Environment: SQL Server 2000, SQL Server 2005, DTS, SSIS, VSS 6.0, SQL Server Business Intelligence Development Studio, Windows 2000 / XP.

Client: Confidential Mar 05 - Oct 06 SQL Server Developer Developer Console As a SQL Server Developer I was involved in developing and maintaining a desktop client server application. It is used to generate platform deliverables and view platform model details. Developer Console is composed of following activities

• SP Stub Generator
• Table Script Generator
• SP Analysis
• Deliverables
• Bulk HTML Generation
• Sample Data XML Editor
• Model Explorer
• Offline Model Explorer XMLs
• Generate Deployment Script

Responsibilities:

• Created and managed complex stored procedures involving application Logic.
• Extensively involved in optimizations and performance tuning of stored procedures, adding/deleting indexes and re-indexing.
• Handled design, development and release of database related tasks.
• Resolved production issues.

Environment: SQL Server 2000, VSS 6.0, Windows 2000, Windows XP.

Client :Confidential Jan 04 - Mar 05 SQL Server Developer Blue Print and Reverse Migration

Phase I - Blue Print Blue Print is an application, which helps to achieve the requirement specification phase of the software development life cycle. Ramco Virtual Works uses Enterprise Business Process Modeling approach for gathering requirements. Requirement specification consists of the following major activities

• Process Component Modeling
• UI Modeling
• Link Modeling
• Task Modeling

Based on the requirement captured, a demonstrable prototype can be generated.

Responsibilities:

• Development of User defined screens using RVW.
• Created Stored Procedures and Views to implement the business logic.
• Performed Unit and Integration Testing.
• Prepared the test cases and documented the test results.
• Attended production issues.

Phase II - Reverse Migration Ramco Virtual Works (RVW) is a component-based enterprise application. RVW is an application framework for designing, developing, deploying and maintaining enterprise applications. Reverse Migration objective is to migrate, the components developed in RVW 1.4.3 to RVW 2.0. RVW 1.4.3 is desktop base application but RVW 2.0 is client/server-based application. User Interface screens are developed using dream weaver in 1.4.3 RVW model, but in RVW 2.0 model it is auto generated using the requirement given in Blue Print Component.

Responsibilities:

• Created T-SQL scripts, stored procedures, and functions to migrate components developed using RVW 1.4.3.
• Involved in backup and restoring databases on testing environment.
• Created Jobs for monitoring different SQL Servers to satisfy the business rules.
• Performed Unit and Integration Testing and documented the test results.
• Managed code releases to testing, staging and production server.

Environment: SQL Server 2000, RVW 1.4.3, RVW 2.0, Windows 2000, Windows XP, VSS.