Summary

• 10 plus years of experience in IT industry, as Database Developer.
• Experienced in Database Design, Development, Maintenance and Administration on SQL Server 2000/2005/2008 R2/2012.
• Experienced in Installation, Upgrade and Configuration of Microsoft SQL Server 2000/ 2005.
• Expert level skills in Data Modeling, Data Mapping, and Database Normalization using RDBMS Concepts and Constructs.
• Very good understanding of Business Processes and Data warehouse concepts.
• Expert level skills in creating Tables, Views, Indexes, Stored Procedures, Cursors, CTE, Triggers.
• Proficient in Tuning, Maintenance and Optimization of Database using various SQL Server tools SQL Server Profiler, Index Tuning Wizard .
• Experienced in data Extraction, Transformation and Loading ETL between Homogenous/Heterogeneous System using SQL tools SSIS/DTS , Import/Export Wizard .
• Experienced in creating Report Models, generating Ad hoc Reports, Scheduled Reports for business analysis and management purposes using SQL Server Reporting Services SSRS .
• Creating and publishing Reports on Share Point 2007/2010.
• Excellent knowledge of all the phases of Software Development Life Cycle SDLC .
• Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.
• A Well-Organized, Goal Oriented, Highly-Motivated Effective team player with excellent Analytical, Troubleshooting, and Problem Solving Skills.

TECHNICAL SKILLS

• RDBMS/DBMS: MS-SQL Server 2000/2005/2008 R2/ 2012, Oracle 7.x/8.x/9i, MS Access, DB2.
• Database Technologies/Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Server Management Studio SSMS , SQL Profiler, SQL Configuration Tools, SQL Server Business Intelligence Studio BIDS , Visual Studio 2005/2008, Red Gate.
• Analysis Services: Data Transformation Services DTS , SQL Server Integration Service SSIS . Reporting Services: SQL Server Reporting Service SSRS .
• Operating Systems: Windows 7, Vista, XP, 2000, NT, 98 SE, MS DOS, UNIX.
• Servers: Windows 2000, 2003, NT, SharePoint Server 2007.
• Application Servers: IIS, PWS.
• Programming Languages: T-SQL, Java, VB.Net, C, C , PL / SQL, XML.
• Web Technologies: VBScript, Java Script, HTML, Microsoft FrontPage.
• Data Modeling Tools: MS Visio, ER-Win.
• Version Control Tools: PVCS, Serena Dimensions

PROFESSIONAL EXPERIENCE

Confidential

Database Engineer

Centre for Health Care Financing CHCF is a division of University of Massachusetts Medical School.

• Analyze data, Claims Files 837, 835 .
• Create Conceptual, Logical and Physical Model to persist Claims data.
• Create Stored Procedures, Functions to support the Claim Search feature of the CBE Consolidated Billing Environment.
• Designed/Re-Factored data model to accommodate different Programs.
• Gathered requirements to Reconcile Claims for various Programs.
• Created Stored Procedures, User Defined Functions, Views to accommodate different reconciliation methods per different programs
• Involved in Production Support by analyzing the issues using SQL PROFILER and fixing the bugs.
• Designed and maintained Security for the application, driven by the Database.
• Create Users give appropriate access and permissions as per different Programs in CBE.
• Back-up and Restore database to different environments.
• Promote code to different environments using TFS Team Foundation Server .
• Designed, Developed and Created Reports and Scheduled to be uploaded to SharePoint.
• Created SSIS Package to trigger SSRS Report thru Web Reference, connect to SharePoint thru Web Reference in C and upload the report extract on to SharePoint.

Environment: SQL Server 2012, SQL Server Data Tools 2010 SSDT , Windows 7, T-SQL, C , Team Foundation Server TFS .

Confidential

Database Developer

• OneBeacon Professional Insurance is specialty insurance, operating subsidiary of OneBeacon Insurance Group Ltd. They specialize in Health Care, Management Liability, Professional Liability, Design Professional Liability, Technology Professional, etc.
• Interacted with the business users to gather requirements.
• Designed, developed and debugged Stored Procedures, User Defined Functions, and Views.
• Upgrade SSIS 2005 package to SSIS 2008 R2.
• Enhanced/Upgraded SSRS 2005 reports to SSRS 2008 R2.
• Analyzed, designed, created, tested and deployed Reports as per user requirements using SSRS.

Environment: SQL Server 2005/2008 R2, Windows 2003, Microsoft Business Intelligence Studio, T-SQL, SSRS, SSIS, VB.NET, SharePoint Server 2007,PVCS, Red Gate.

Confidential

Report Developer

• Wholesale Technology group of the bank.
• Created/refactored reports to accommodate graphs, RTF data in SSRS 2008 R2.
• Troubleshoot Stored Procedures, UDFS, etc.
• Created Indexes to improve performance of the .Net based front end.
• Involved in Production Support.
• Used SQL PROFILER to trace and enhance the performance.
• Created Indexes and performed Index Tuning using Index Tuning Wizard for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Environment: SQL Server 2005/2008 R2, Windows 2003, Microsoft Business Intelligence Studio, T-SQL, SSRS, SharePoint Server 2007.

Confidential

Database Developer

Confidential a leading global provider of insurance, annuities, etc. It provides services across U.S.A. and over 60 countries through its subsidiaries and affiliates. Confidential purchased ALICO, a subsidiary of former AIG.

Responsibilities:

• Gathered business requirements.
• Designed and developed mapping documents to map the fields to the existing structure in MetLife.
• Created and modularized the existing Stored Procedures.
• Enhanced the performance of the existing database Objects like Stored Procedures, Functions by tuning.
• Analyzed and resolved production issues within stipulated time frame.

Environment: SQL Server 2000/2005, Windows 2003, Microsoft Business Intelligence Studio, BugZilla.

Confidential

Report Developer

Responsibilities:

• Gathered business requirements for the reports to be generated.
• Created mapping documents by comparing the Business Objects Universes with the current databases on Oracle or SQL SERVER 2008.
• Created Training Documents on Report Builder 2.0/ 3.0 for Business Users.
• Conducted Training Sessions on using Report Builder 2.0/3.0 sourcing SQL SERVER ANALYSIS SERVICES CUBES / Report Models and Excel Services.
• Replicated the Business Objects Universes in Report Model using SQL SERVER 2008.
• Generated Report Models sourcing Oracle databases.
• With Report Model as data source, created ad hoc reports using Report Builder 2.0/3.0.
• As part of different source requirements for different departments, created reports with DB2, Oracle, SQL SERVER 2008 as the data source.
• Contributed to the creation of Reporting Standard Style Guide as per the standards of CareFirst.
• Designed reports using Report Builder 3.0 by joining multiple Data Sets from multiple Data Sources Oracle, DB2, .txt Files .
• Developed and published ad hoc reports on to Share Point.

Environment: SQL Server 2008, Windows 2003, DB2, Oracle, Microsoft Business Intelligence Studio, Report Builder 2.0/3.0, SSRS 2008, Business Objects, Share Point Server 2007, Serena Dimensions, Excel Services.

Confidential

ETL/ Report Developer

• OneBeacon Professional Partners, now known as OneBeacon Professional Insurance, is specialty insurance, operating subsidiary of OneBeacon Insurance Group Ltd. They specialize in Health Care, Management Liability, Professional Liability, etc.
• NorthStarDM the database is a one stop place for all the in-house needs of business users. It is a data store for complete information about policies, pertaining to all the sources and different specialty areas.

Responsibilities:

• Interacted with the business users to gather requirements.
• Designed, developed and debugged Stored Procedures, User Defined Functions, and Views.
• Traced and enhanced the performance of Stored Procedures, User Defined Functions by using Performance Tuning Tools.
• Designed, re-factored, created, configured , scheduled SSIS Packages from different sources like Flat Files, .Dat Files, .CSV Files and Excel Files in different environments.
• Created Command Files and SSIS Configuration Files for different environments.
• Analyzed and designed the Script Components in SSIS Packages using VB.NET.
• Designed and implemented error handling at different levels using Stored Procedures, Table Valued Functions, SSIS Packages, etc to feed the down stream systems.
• Designed, created Reports using SSRS and published them on to SharePoint 2007 Server.
• Analyzed and created a process for Policy and Claims to put SOX Compliance Controls in-place for audit.
• Responsible for monitoring, supporting and troubleshooting Production issues.
• Used Red Gate Tools to maintain database consistency across environment.

Environment: SQL Server 2000 /2005/2008, Windows 2003, Microsoft Business Intelligence Studio, T-SQL, SSRS, SSIS, VB.NET, MS Access, MS Excel, SharePoint Server 2007,XML, PVCS, Red Gate.

Confidential

SQL Server Developer

Acuity Point is a Business Web Solutions company providing Custom Application Development, E- Commerce Solutions and Database Integration and Reporting Services to the clients. The scope of this project involved complete logical and physical design of a database. Sales Automation Inventory Management involved design, development of database application, implementations, data cleansing, disaster recovery strategies, migration of databases, implementing SSRS and SSIS.

Responsibilities:

• Configured and installed SQL Server 2005 on Windows 2003 Server.
• Conducted Performance Tuning to improve the performance of slow running queries and Stored Procedures, using SQL Server Profiler to trace the slow running activities.
• Developed and debugged Stored Procedures, Views, Triggers and User Defined Functions to handle complex business rules.
• Planned, designed and managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Migrated data from legacy system text based files, Excel spreadsheets, and Access to SQL Server 2005 databases using SQL Server Integration Services SSIS .
• Set up and configured Report Server.
• Created Reports using Report Designer and set up access from ASP.NET Web Applications in Visual Studio 2005 for authorized personnel.
• Developed Report Models as per the requirements and generated Ad hoc Reports using SQL Server Reporting Services SSRS .
• Generated Drill Through, Drill Down, and Ad hoc Reports.

Environment: SQL Server 2000 /2005, Windows 2003, Microsoft Business Intelligence Studio, Java, T-SQL, SSRS, IIS, SSIS, VB.NET, Visual Studio 2005, MS Access, MS Excel.

Confidential

SQL Server Developer

Responsibilities:

• Installed and Configured SQL Server 2005.
• Created Logical Model using MS Visio.
• Configured the Window Server upgrading required Service Packs.
• Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers using SQL Server Management Studio SSMS and T-SQL statements to implement complex business logic.
• Created and implemented Constraints and Checks on the Database Objects to maintain Data Integrity.
• Designed and migrated all Data Transformation Services DTS Packages to SQL Server Integration Services SSIS and modified the packages accordingly.
• Recreated and reconfigured DTS packages in SSIS.
• Created Stored Procedures, User Defined Functions and improved efficiency by critically evaluating the code and optimized the slow running queries by using Query Optimizer.
• Increased query performance by monitoring performance, tuning and Optimizing Indexes tasks by using Performance Monitor, SQL Server Profiler and Index Tuning Wizard.

Environment: SQL Server 2000/2005, SQL Server Integration Services SSIS , Business Intelligence Development Studio BIDS , Windows XP, MS Excel, MS Access, MS Visio.

Confidential

SQL Server Developer

Responsibilities:

• Gathered business requirements by interacting with the Business Analysts.
• Installed, configured and maintained MS SQL Server 2000.
• Designed logical Data Model using ER-Win to fit business requirement.
• Created Database and implemented Normalization.
• Performed data conversion from Flat File, MS Excel and MS Access into Normalized database structure.
• Developed Database Objects such as User Defined Functions, Tables, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Converted complex business logic into SQL Stored Procedures and User Defined Functions to achieve functionality required by the UI team.
• Created Triggers to enforce Data Integrity and Referential Integrity.
• Performed data transfer import export using BCP.
• Developed Backup and Restore Scripts for SQL Server 2000.
• Used in Enterprise Manager for Job Scheduling.

Environment: SQL Server 2000, ER-Win, T-SQL, Windows NT, ASP.NET, VB Script, JavaScript, DTS, Excel, Access, Microsoft Visual Studio 2005.

Confidential

SQL Developer/DBA

Responsibilities:

• Successfully implemented Logical Data Model into Physical Data Model.
• Designed and implemented the system with Microsoft SQL Server 2000.
• Installed, configured and maintained SQL Server 2000 with regard to the requirements.
• Created Database Schema, Database Objects and Normalized database.
• Transformed complex business logic into Stored Procedures, User Defined Functions UDF , Triggers, Cursors, and Views.
• Created and modified Clustered and Non Clustered Indexes to optimize the queries using Index Tuning Wizard.
• Created DTS packages to transfer the data from the old system to the staging area.
• Successfully performed ETL process by pulling large volumes of data using DTS, BCP into the staging database from various data sources like MS Access, Excel.
• Performed the Transformation of the data using Transform Task in DTS.
• Handling database objects with Enterprise Manager and Query Analyzer.

Environment: SQL Server 2000 ,Query Analyzer, Enterprise Manager, DTS Designer, MS SQL Reporting Services, SQL Profiler, Index Tuning Wizard, Windows XP, MS Excel, MS Access.