PROFESSIONAL SUMMARY:

• Over 9 years of experience in system analysis, design, development and implementation of projects (Complete SDLC).
• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Good SQL Server Administration skills including backup recovery, database maintenance, user authorizations, database creation, table creation and index creation.
• Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Views, Triggers and dynamic sql queries.
• Excellent in Data Extraction Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experienced in other RDBMS like Oracle (PL/SQL, Forms, and Reports)
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor.
• Expert in creating various type of reports such as drill down, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS).
• Knowledge of SQL Server Analysis Services.
• Knowledge of other reporting tools such as Crystal Reports, Business Object (BO), and Data Reports.
• Used Serena Version Manager and TFS (Team Foundation Server) as configuration management tool.
• Knowledge of Erwin and Microsoft Visio.
• Extremely motivated, diligent, conceptually strong team player with an ability to take new roles and a quick learner.
• Good Analytical, Technical, Organizational skills coupled with excellent written and verbal communication skills.

• Databases: SQL Server 2000/2005/2008, Oracle 8i/9i/10g, MS Access, MY SQL
• Languages: SQL, T-SQL, PL/SQL, Visual Basic 6.0, VB.NET, C#.NET, ASP.Net, VB Script, Java Script
• Operating System: Windows, UNIX, Windows NT, Windows 2000/XP, Windows 2003 Server.
• Reports: SQL Reporting Services (SSRS), Crystal Reports, Data Reports, Business Objects
• Concepts: IIS, Migration, System Analysis and Design, Software Engineering, OOAD, Database Management Systems, Operating Systems, Client Server Technology, TCP/IP, APIs, HTML, COM/DCOM, COM+, MTS
• Web Technologies: HTML, DHTML, XML, ASP.NET

Confidential,Alexandria, VA Feb 2007 – Till Date
SQL Sever Developer/Report Designer

EMPIRE System
Empire is a blue cross blue shield health insurance Company that everyday sends Group, member eligibility, incentive, medical claims, and pharmacy claims information to LITES system. Files are received as text file and Biztalk loads it to the staging database. The scheduled jobs run every morning and load these data into the LITES database. In course, there are number of validation rules that checks for data correctness and relevance. Errors are recorded and reported to the operations team.

• ESI Migration
• Empire sends us flat file every day with group and member information and we load it into the staging database using SSIS package. We let it go through the business rules and correct data are sent as extract to ESI.
• Empire NextRx Integration
• NextRx is a pharmacy where group and member information are sent as extract everyday using biztalk.

Responsibilities:

• Successfully implemented physical database design in SQL Server 2005.
• Developed various stored procedure for loading data from staging database to LITES database for group, eligibility, incentive, medical claims and pharmacy claims file.
• Developed procedure for adjudicating the claims and calculating HRA balances for members.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created and modified tables, various clustered/non-clustered indexes, triggers, check constraints and functions.
• Created triggers to keep track of changes to the fields of tables when changes are made.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Monitored performance and optimized SQL queries for maximum efficiency using SQL Profiler and Database Engine Tuning Wizards.
• Created SSIS package for loading the fixed length flat file to staging database.
• Created functions to split the fixed length data to load it into different columns of the staging table.
• Developed SSRS reports such as Matrix, table, chart using complex SQL queries and stored procedures.
• Configure and maintain Report Manager and Reporting Services for SSRS
• Assist programmers with scripts, SSIS projects and troubleshoot complex stored procedures.
• Wrote windows batch files for copying files to different locations.
• Identified and troubleshoot databases issues.
• Actively handled production support for different services.

Environment: SQL Server 2000/2005/2008, Query Analyzer, T-SQL, Excel, DTS package, SSRS, SSIS, Business Objects, C#.NET, ASP.NET, Biztalk, and Windows 2000/XP.

Confidential,Alexandria, VA May 2006 – Jan 2007
SQL Sever Developer

The Member Account Service is a subset of the Eligibility Processing system and is responsible for the loading member information data from SMCS to LITES.
New or changed eligibility data is copied from SMCS to a staging location in LITES, where it is then analyzed and compared to the existing data in production. Validation is performed and partial or total data is migrated into LITES. Invalid or corrupt information is identified will not be considered by the business rules set forth below. The data is then classified into six logical eligibility business areas (i.e. member, relations, attributes, enrollment, accumulators and initialization).

Responsibilities:

• Participated in upgrading the existing system with the new business requirements and system specification from users.
• Worked extensively in writing and debugging complex stored procedures, triggers, views and user-defined functions.
• Developed indexed generic views to facilitate easy user interface implementation and enforce security on critical customer information.
• Maintained integrity constraint to facilitate consistent data entry into the database by creating check constraint, triggers.
• Wrote different stored procedures for loading and validating data from SMCS system to LITES system.
• Monitored and optimized SQL queries for maximum efficiency.
• Administer SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
• Tuned database objects by creating indexes to ensure efficient data retrieval.
• Created DTS packages for importing data from access and generating the excel reports.
• Created various complex stored procedures for generating SSRS reports.
• Documented technical details as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server 2000/2005, Query Analyzer, T-SQL, Excel, DTS package, SSRS, Biztalk, C#.NET, ASP.NET

Confidential,Salt Lake City, UT Jul 2005 – Apr 2006
SQL Sever Developer

This system keeps track of all the rugs imported and exported. It tracks the customer order, supplier order, and shipping information online. It has the feature of report generation and doing the queries to find the information about the particular item and particular supplier or customer. This application also handles the accounting information that is needed in terms of keeping track of the customer and supplier account.

Responsibilities:

• Actively participated in gathering business requirements and system specification from users.
• Successfully implemented physical database design in SQL Server 2005.
• Created different database objects such as tables, views, stored procedures, functions and triggers.
• Created functions for formatting the auto number for transaction table.
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
• Optimized performance of the queries by removing unnecessary joins.
• Performed job monitoring and scheduling.
• Developed various custom ad-hoc reports using crystal report like order report, sales report, return report, shipping report, and account reports.
• Scheduled DTS package for exporting data to excel files.
• Wrote technical documents.

Environment: SQL Server 2000/2005, SSRS, Query Analyzer, T-SQL, Excel, Crystal Report, VB.NET and Windows 2000/XP.

Confidential,May 2004 – Jun 2005
SQL Developer/ Report Designer

This project intends to improve online bill payment, transfers, wires product by offering their customers the most comprehensive set of online payment and transfers functionality. Bill pay module is used to pay the bills online. Wires module is used to transfer amount from one account to another account instantly. Transfer module is used to transfer amount from one account to another account by electronic or paper transfer.

Responsibilities:

• Continuously interacted with users to gather the business requirements.
• Designed and developed the web forms using ASP, HTML, Front Page, VB script and java script.
• Extensively used ADO for database connection and data manipulation.
• VB script and java script were used to perform server side validations and client side validations.
• Identified and prioritized test cases, analyzed defects, evaluated test coverage, and generated status reports
• Worked with testing team to ensure that the development issues are resolved.
• Successfully implemented physical design using SQL Server 2005
• Created stored procedures and functions for front-end developers.
• Controlled most of the business logic from the backend.
• Maintained database integrity using constraints, triggers.
• Performed database tuning by creating indexes.
• Developed reports using Crystal Report, HTML report according to the requirements.

Environments: VB, ASP, IIS, HTML, Front Page, VB Script, SQL Server 2005, SSRS, Crystal Reports, Windows 2000