TECHNICAL SUMMARY:

• Over 14 years of experience in the full systems lifecycle including analysis, design, project management, programming, testing, deployment and maintenance.
• Over 7 years of hands on experience with SQL design, development, data modeling & data base administration in SQL Server 2005/2008.
• Strong expertise in various database design, data warehousing technologies and methodologies, BI/ETL tools, OLAP, business intelligence reporting & SharePoint technologies.
• Strong business knowledge in health insurance, retail and insurance applications.

TECHNICAL  SKILLS: 

• Languages: C, Visual C# Operating Systems: Windows NT, Windows 2000, Windows 2003, UNIX
• Databases: Microsoft SQL Server 2000 / 2005 / 2008, DB2
• IDEs: Visual Studio .NET 2005
• ETL: SQL Server 2008/ 2005 Integration Services (SSIS) & SQL Server 2000 data transformation services (DTS)
• BI/Reporting: SQLServer 2008/ 2005 Analysis Services (SSAS) , Reporting Services (SSRS), ProClarity, Performance Point Services 2010 & Netezza.
• Portals: Microsoft Office Sharepoint Server (MOSS) 2010 /2007 & Infopath 2010/2007.
• Tools: Microsoft Visual Source Safe, CA Harvest & Erwin, Red Gate, LiteSpeed, Dameware, DBArtisan & Embarcadero

EXPERIENCE:

1/07 – Present Confidential, Boston, MA
Data Architect - NHP Business Intelligence

Currently working as Lead BI Architect on BI Strategy projects at Neighborhood Health Plan (NHP), a non-profit health care organization. Responsible for design and development of BI dashboards, data warehouse, data mart and cubes.

Technical Environment: SQL server database services 2005 / 2008, SSIS, SSAS, SSRS, MOSS 2007, Performance Point server 2007 and SourceSafe.

The main objective of NHP Reporting project is to reconcile data between reports that are crucial to managing the business. Many reports across the organization, from Finance to Clinical, Provider to CMA, reference key metrics and rollups that are relevant to all of NHP. Operational reports are developed from new QNXT (OLTP database) or from data warehouse (DW) database. Analytical reports are developed from OLAP cube data.

• Lead team of BI developers on BI strategy initiative projects.
• Lead strategy, development and implementation of enterprise wide data dictionary.
• Lead design and development effort Business intelligence dashboards, score cards and KPIs.
• Design dashboard prototype (Excel services), provide time-line estimate and work with developers to complete development of dashboards (Performance point services & MOSS 2010).
• Architected the IT hardware infrastructure and lead effort on deployment of SharePoint farms & servers for BI strategy projects.
• Perform design, develop and prepare time-line estimate for database schemas, tables, views, functions, stored procedure, SSIS packages (ETL) and SQL jobs for data warehouse project.
• Collaborate with business users to ensure that data warehouse, data mart and analytical cubes meets business needs for operational and analytical reporting.
• Designed and created physical and logical (dimensional) data models for data mart project based on business requirements.
• Lead effort on data mart and OLAP cube analysis & design process.
• Design and develop BI self service report models and report templates using Report builder 3.0.
• Troubleshoot and work on performance tuning in database and reporting.
• Lead effort on log shipping, replication, horizontal table partitioning and data base mirroring.
• Lead effort in the maintenance (backup & recovery), and performance monitoring of database and server processes.

9/02 – 1/07 Confidential., Framingham, MA
Auto-attach Instruction Manager (AIM)
Sr. Programmer Analyst 
Technical Environment: SQL Server 2005 Integration services, Source safe, Harvest & Erwin

Auto-attach Instruction Manager (AIM), system that will auto-attach shipping instructions (removing the need for an analyst to manually attach) to headers based on criteria set by the Allocation Analysts. The allocation analysts will develop a guide in the form of a decision tree to describe which set of instructions should be used when distributing a header. Once decision tree is completed and approved it will be promoted into the rules engine in BizTalk for the Auto-Attach Instructions process to reference.

• Perform analysis and prepare time-line estimate for all enterprise data such as databases, tables, schema & etc.
• Produced functional and design specification documents.
• Developed ETL (SSIS) packages to load data from mainframe into AIM databases. Create databases, triggers and tables.
• Developed stored procedures and SQL server jobs.

Confidential., Framingham, MA
Operational Data Store (ODS) & Merchandise Data Repository (MDR)
Sr. Programmer Analyst
Technical Environment: SQL Server 2005 Integration services, Netezza, Source safe, Harvest & Erwin

Objective of this project was to implement source data consolidation from the legacy mainframe systems into an Operational Data Store (ODS) and to build a data warehouse called as Merchandise Data Repository (MDR) for analysis and reporting. ETL (SSIS) is used to load daily and weekly data into ODS and to stage data from ODS into conformed dimensional data warehouse (MDR).

• Designed storage definitions for all enterprise data such as databases, tables, schema & etc.
• Prepared design document, technical design and flow diagrams.
• Developed stored procedures for efficient access and manipulation of data.
• Developed ETL (SSIS) packages to transform data from legacy systems into ODS and to stage ODS data into MDR.
• Created several SQL Server Agent job scripts to execute SSIS packages.

12/99- 9/02 Confidential, Columbus, OH
Auto Insurance Current Product Engineering (CPE) Support:
Programmer Analyst
Technical Environment: MVS/ESA, COBOL II, IMS DB, DB2, JCL, FILE-AID, CHANGEMAN, XPEDITER, DOCUMERGE & IBM Fault Analyzer
Confidential is one of the top leading Insurance company in U.S. Our primary focus was to provide continued systems support for Auto current product engineering. This includes development and on-going support to AOA (Agency Online Application) and related systems for changes related to rate, regulatory/compliance, strategic/enhancement or maintenance.
AOA, a front end system helps an Auto Agent to write a new business, make policy changes, add vehicle/coverage, accept premium payments, quote prices or performs other functions, the appropriate data is captured for subsequent release to the NAPS (Nationwide Auto Processing System) system.

• Designed, developed and tested new online programs and provide on-going support to existing legacy system.

4/98 – 11/99 Confidential, Jacksonville, FL
Programmer Analyst - Locomotive Management System for CSXT
Technical Environment: MVS/ESA, COBOL II, CICS, IMS, DB2, JCL, FILE-AID, CHANGEMAN & XPEDITER
Confidential is a transport corporation in railroads. The project was to develop a process for receiving and updating the locomotive location and status information into Confidential’s locomotive management system in order to increase the utilization and reduce overall network fuel costs using the Global Positioning Satellite (GPS) technology. The process will receive messages that originate from ConfidentialT locomotives equipped with GPS related hardware and the information is sent to GE Harris Railway Electronics. The information from GE Harris is received by CSXT information Center into their system.

• Design, develop and test new online programs. Also involved in maintenance work for the existing legacy system.

10/97 – 4/98 Confidential, Fort Wayne, IN
Distribution Management System

Technical Environment: COBOL, CICS, and DB2
The main objective of this project is automation of the Stock Supply Procurement process to help buying supplies from Various Vendors. Systems were developed to maintain the on-line information about the entire sales operation and reduce inventory holding along with speeding up the producing of invoices.

• Involved in designed file layout, tables and relations, designing the SQL Query to access the database in the programs, coding and testing the program specification for the On-line system and analysis of the system.

Bachelor of Engineering in Computer Science

CERTIFICATIONS:

• MCITP (2007) - Microsoft Certified IT Professional: Database Administrator, SQL Server 2005
• MCTS (2008) - Microsoft Certified Technology specialist - Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
• MCTS (2007) - Microsoft Certified Technology Specialist: SharePoint (MOSS) Administration.