PROFESSIONAL SUMMARY:

• SQL Server Development DBA with over fifteen years of database (VLDB) application design and development experience on mission - critical applications.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support with exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Highly skilled with code reviews of junior DBAs and Developers, index tuning and design, optimizing tables, schemas, stored procedures and views.
• Hands on experience with a database upgrade project to SQL Server 2016.
• Extensive experience in BI suite using integration services (SSIS) for ETL (Extraction, Transformation & Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes

TECHNICAL SKILLS:

• SQL Server (2016
• 2014
• 2010
• 2008 R2)
• SQL Server SSIS (ETL)
• SSAS & Report (SSRS)
• Azure
• VB/JavaScript
• C#
• MS TFS
• Oracle 9i
• 10g & TOAD
• Crystal Report
• MS Access
• Informix
• SharePoint
• ASP.Net
• VB.Net
• Windows NT
• VMWare
• Vault
• XML
• ASP
• Perl
• DHTML
• HTML
• InterDev
• Power Designer
• Unix

PROFESSIONAL EXPERIENCE:

Confidential, Bedford, MA

Principal Database Administrator \BI Developer

• Managed SQL Server 2008(R2)\2014\2016 Data Warehouse in production\development environments
• Totally redesigned new data warehouse with multiple cubes, implementation including add aggregations, partitions, various dimensions, prospects, calculations
• Served as database architecture for data warehouse and data mart, database design, update, prototype, and implementation using SQL server. Performed all activities related to maintaining databases in development, testing and production environments, including installation and upgrades, backup, restore, performance tuning, stored procedure design, SSIS packages and SSAS\Cube
• Worked independently and as team lead to accomplish critical business objectives and to make decisions under pressure
• Created ETL metadata reports using SSIS, reports include like execution times for the SSIS packages, Failure reports with error description. Rewrote large quantity queries to replace existing long running ones
• Upgraded SQL Servers and all associated applications multiple times - from SQL Server R
• Managed multiple Cloud servers for hosting the company’s data warehouse
• Worked closely with end users for building, publishing customized interactive reports and dashboards, report scheduling utilizes Power BI, Tableau and Excel, Etc.

Confidential, Medford, MA

Sr. Database Administrator\Developer

• Managed SQL Server 2008(R2)\2005 in Development/Production environments including installation, migration, configuration, backup, upgrades
• Responsible for designing and maintaining SSIS packages, stored procedures, functions, views, indexes

Confidential

Database Administrator\Developer (Consultant)

• Build a comprehensive disaster recovery planning for SQL Servers. Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability; Profiled and tuned servers on a monthly\weekly basis to ensure fast queries and reports.
• Wrote T-SQL queries to diagnose data problems and fix scripts to correct the data problems. Fix scripts included update, delete, insert; responsible for designing and maintaining SSIS packages, stored procedures, functions, views, indexes and make changes to the code if necessary.
• Optimized database performance by analyzing objects, generating statistics, creating indexes and views.
• Rewrote numerals reports for company’s web-based application by using Crystal Report.

Confidential, Burlington, MA

Data Warehouse Developer \SQL Server Lead DBA

• Worked as team lead for data warehouse\BI project for Confidential,
• Responsible for data modeling\structures, end-to-end ETL processing and database servers’ architecture.
• Developed processes to extract the source data from ERP system and load it into data warehouse after cleansing, transforms and integrating.

Confidential, Framingham, MA

Database Administrator/Developer

• Built an ETL Framework for departmental databases by using SQL Server 2008 & SSIS. ETL Framework implements core capabilities and provide a solid base for the current version of all SQL Server database as well as future versions. In addition, this ETL Framework also provides a foundation for other “data centric” integration needs. An ETL Framework was developed in support of reducing integration TCO (Total Cost of Ownership). This includes the development of a fully automated process, as well as a fully configurable process. It provides templates and best practices to ensure consistent, repeatable integration solutions. It also provides logging and reporting that offer complete transparency into the end-to-end integration process.
• Designed reports with drill down, drill through, drop down menu option, Parameterized, sub-reports and Linked reports using SSRS; Deployed reports to generate all daily, weekly, monthly and quarterly Reports including current status.

Confidential

Database Engineer\Developer

• Responsible for developing and supporting ETL part of the
• Used SQL Server Integration Services (SSIS) to build for AutoDialog ETL packages.
• The packages handle high volume data from AutoDialog (phone calling system) and process\distribute data between OLTP and data warehouse.
• Designed and developed a database schema comparison as supplement ETL tools (Schema Comparison) for IT department.
• Unlike most commercial database compare tools, the Schema Comparison can compare all different type databases, such as SQL vs. Oracle or vies versa. It provides an efficient tool to all kind database developers, DBA and other technical personals in developing, QA and production support teams.
• Participated in company’s upgrading to SQL 2008 in parts of ETL and SSRS.
• Acted as the prima3ry technical liaison to the business segment, through facilitating communication between application development, QA, technical operations and project business managers on new product releases. Developed and maintained best of breed product support tools including run books, monitoring, and knowledge bases to aid in the product support process.

Confidential

Database Developer\DBA

• Used Microsoft SQL Server 2005 Integration Services (ETL) to design, test and implement numerous ETL solutions.
• ETL packages used in Operation, Finance, Accounting & Tax Servers, and IT departments.
• Project lead to migration from SQL Server . Converted legacy DTS (ETL) packages, stored procedures, queries, embedded SQL codes, triggers etc to newer model.
• Operated very large databases (SQL Server 2005 and Oracle 9i & 10g) for finance department.
• Responsible for all finance department (and others) database applications, inquires.
• By using my strong analytic problem solving skills to handle daily ad hoc /odd jobs. Worked as backup SQL server DBA whenever needed.
• Made significant contributions to, carrier dispute negotiations, bad debt recovery, profit margin analysis and resale audit activities through complex analysis to data warehouse.

Confidential Danvers, MA

Database Application Developer

• Served as database architecture for database system, data warehouse and data mart, including database design, update, prototype, and implementation using SQL server. Performed all activities related to maintaining databases in development, testing and production environments, including installation and upgrades, backup, restore, and performance tuning, stored procedure design, DTS packages, implementation and testing with T-SQL, PL/SQL Support database.
• Responsible for full software development life cycle including requirements gathering, domain analysis, business model development, and multi-tier software design with object oriented methodology, implementation, testing-debugging and bug fixing. Performed web based application design, implementation and testing using SQL server and ASP.net
• Produced the first company-wide business application Project Planning/TimeTracker. The application automated time tracking and payroll processing, eliminated payroll and billing imprecision, and attendance in tracking and visibility. It also greatly reduced timecard administrative overhead. The application included configurable time and attendance in compliance with employment regulations, work time, overtime and approval management features. It provided real-time reports with collaboration to improve project tracking.

Confidential

Database DBA/Developer

• Developed three major business applications for MassPro’s medical review system - Health Employment Data Information Set (HEDIS), Center for MassHealth Evaluation and Research (CMER) and Study of Clinically Relevant Indicators for Pharmacological Therapy (SCRIPT).
• The projects covered full system development methodology. HEDIS, CMER and SCRIPT required performing complex detailed analysis for all resources such as health care providers, physicians, and patients along with multi-level case tracking, case reviewing and report generations.
• The SCRIPT Project was considered to be a model for collaboration among the more than 50 organizations comprising the coalition and the first standardized performance measures for medication management. The SCRIPT was used in eight (8) U.S. states to collect data, and final statistical reports were conducted in Massachusetts. The results were presented to the national conference in Baltimore, Maryland in September, 2001.

Confidential

Database Engineer/Developer

• Developed and maintained HP Enterprise Products Discontinuing Database (PC Advisor).
• This client/server application used Informix and ran on a Unix server with front end users interface built on Visual Basic and Access.
• Added numerous major enhancements that strengthened PC Advisor capability and functionality.
• Evaluated current and emerging technologies and tools in order to determine the best ways to utilize application effectively.
• As a result, the PC Advisor ported from Windows/Unix platform to Microsoft SQL Server /Windows NT.
• The project included requirements analysis, design, development, integration, and implementation.