SUMMARY:

• Over 18 years experience in full SDLC of database applications (Analysis, Design, Programming, Testing and Deployment)
• 10 years extensive experience as Senior database developer utilizing MS SQL Server, Microsoft BI, Data Warehouse, Data Marts, and Reporting solutions in various industries including education, eCommerce, and insurance

TECHNICAL SKILLS:

SQL Server Tools: Microsoft BI (SSIS, SSRS, SSAS), SQL Server Management Studio, BIDS/SQL Server Data Tools, Configuration Manager, Enterprise Manager, Query Analyzer, SQL Profiler, DTS, Database Tuning Advisor, DTS, BCP, ODBC,SQL OLEDB, DBCC, ADO, ADO.NET.

Business Intelligence Tools: SSRS, Cognos, Crystal Reports, QlickView

RDBMS: Microsoft SQL Server 2008/2012/2014/2016 , MS Access, Oracle 9i/11g .NET Framework 2.0 - 4.5, C#, VB.Net, Asp.net, Entity Framework, MVC :

Version control: TFS, CVS, SVN, VFS

Operating Systems: Windows / 2000/2003/2008 R2, IIS 5/6/7/7.5

Java: JavaScript, HTML, DHTML, XML, CSS, Json.

EXPERIENCE:

Lead Database Developer

Confidential

• Work with Finance and HR to provide business intelligence solution with SSAS/SSIS/SSRS, maintain existing Cognos reports, create dashboard with QlickView
• Create the package of BI solution: OLAP star schema logical design and physical implementation, ETL with SSIS, multidimensional SSAS data cube model and sample reporting with SSRS.
• Create SSIS Sequence container to load dimension and fact table for data warehouse.
• Set up control flow tasks (FTP task, Bulk Insert task, Execute Package task, etc) for SSIS packages. 
• Maintain SSIS package for loading data from multiple databases to data warehouse dim tables and fact tables.
• Deploy SSIS packages and scheduled job in SQL Server Agent to run the packages automatically.
• Create Star schema cubes using SSAS. 
• Create and maintained SSRS report using OLTP data, OLAP multidimensional data, and SSAS Cubes.
• Build various types of SSRS reports: parameterized report, dynamic column report, looked up value field report, dashboard report, etc.
• Generated Sub-Reports, Cross-tab, Conditional, Drilldown reports, Drillthrough reports and Parameterized reports using SSRS 2012.
• Created Cubes with Dimensions and Facts and calculating measures and dimension members using Multidimensional expression (MDX). 
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL. 
• Work closely with product team to develop backend solution based on business needs: database development, database performance tuning, data modeling and schema design, SSIS package design and maintenance
• Design data architecture, data model and Mapping Process to load data based on business requirement and provided documentation.
• Create and optimize SQL queries, stored procedures, user defined functions, Indexes, views and triggers to achieve maximum efficiency and scalability. 
• Develop T-SQL and PL/SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Review and enhance over 100 stored procedures for performance tuning
• Implement a unit testing project for over 100 stored procedures to improved project integrity.

Confidential

Database Consulting

• Developed hospital operation scheduling dashboard system with SQL Server 2008 for Medical Horizons Consulting Group
• Developed and managed full life cycle of online capacity planning and management system with .NET 3.5 and SQL Server 2008 for Mitsui China
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases. 
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS. 
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, Execute package task, Send mail task, Transfer database task, for loop & foreach loop containers. 
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports using SQL Server Reporting Services 2008 R2
• Strong backend skills in creating SQL objects like Tables, Stored Procedures, Functions, User Defined Data-Types, Rules, And Defaults. 
• Responsible for SQL Server 2000 database development, database modeling, database program, database administrator 
• Performed DBA tasks through Enterprise Manager, Query Analyzer, English Query, Import Export wizard

Lead Applications Developer

Confidential

• Managed travel insurance claim process and help desk system with .NET 2.0 and SQL Server 2005, for one of largest travel assistance company

Senior Database Developer

Confidential

• Lead developer of medical insurance benefits administration application that facilitates claim payment, issuing certificate, collecting premium
• Worked with SQL and PL/SQL to create Tables, Views, and triggers and stored Procedures. 
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules 
• Responsible for tuning T-SQL procedures, triggers and other database objects. 
• Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them 
• Designed and developed DTS packages for transferring data from flat files and Access files

Programmer Analyst

Confidential

• Lead developer in maintaining or rewriting 508 compliant “Healthy Media” web application, a customized healthcare program that maintains a productive and healthy workforce through innovative programs that combine physical and mental healthcare.
• It was built on .NET 2.0 (C#) and SQL Server 2003/2005

Technical Lead

Confidential

• Lead developer in full life cycle development of CIS’ flagship product “IMADxp”, a procurement and business performance management application including Purchase Order, Reverse Auction, Schedule Management, Workflow Management, and Report Engine
• Designed, developed and deployed 3 tier “IMADxp” application with .NET platform (C# /ASP.NET/ADO.NET/Visual Studio.NET Beta/1.0/2.0), SQL Server
• Led the full life cycle implementation of the U.S. Navy’s Asset Management System for Individual Protective Equipment (IPE) using “IMADxp”(C# /ASP.NET/ADO.NET/Visual Studio.NET 1.0, SQL Server). It helped Navy improve visibility and congressional reporting of assets to protect service men and women against various chemical, biological, and radiological attacks
• Improved “IMADxp” with asset report features in Navy project
• Led the full life cycle implementation of an electronic procurement system for the Federal Aviation Administration’s (FAA) Results Contracting Vehicle using “IMADxp”(C# /ASP.NET/ADO.NET/Visual Studio.NET Beta/1.0, SQL Server, XML). It processed over $200 million in small and large business procurement.
• Enhanced “IMADxp” with workflow features in FAA project
• Conduct 4 reverse auctions for NIH procurement achieving average saving of 27%.
• Lead adoption of best practices in Test-Driven Development, Agile Development and Persistence coding with NHibernate