SUMMARY:

• Confidential is exceptionally strong in and Business Intelligence tools like Informatica and Business Objects, Data Warehousing and Statistical analysis techniques, making him perfect for architecting Business Intelligence framework, writing reports and proposing streamlined and optimized methods for Data Mining.
• He is very knowledgeable of many categories of financial, survey and healthcare data.
• Extensive experience in working on different platforms, UNIX and Windows, using Oracle 9i and SQL Server databases.
• Confidential ’s expertise includes Project Management, performing wide - ranging analysis and generating detailed management reports from large complex data warehouses.
• Confidential is experienced in programming in C++, JAVA and the software development life cycle (SDLC). He developed an embedded Perl shell using C++ and RUP to extract, transform and load and analyze sales data at Confidential corporation.
• His work at Lucent and Confidential involved development of automatic code generators and parsers in JAVA that were distributed to customers.
• He worked in both Linux and Solaris environments.
• At Confidential developed flat file parsers in C++ on a HP-Unix platform.
• He also developed HEDIS reports.
• Confidential ’s work at Trizetto Group Inc, involves developing a data warehouse based on the FACETS data model.
• He has managed multiple teams and has always been involved in hands on technical work on almost all his projects.
• He performed business analysis for two clients PHPSS and Pacific Source and enhanced the baseline data model.
• He also architected the ETL environment for the above mentioned clients.
• Work at Confidential included managing an effort for developing data models for an enterprise data warehouse to report clinical, utilization and financial metrics.
• He managed, architected and optimized Data model and ETL processes for loading into a 2 Terabyte enterprise data warehouse.
• Confidential architected a CRM data mart, using Informatica and Business Objects, and integrated it into enterprise data warehouse. He performed analysis on how customer satisfaction and risk of customer affect premium costs using SAS.
• He is familiar with statistical analysis techniques like multivariate regression, decision trees, neural nets etc.

PROFESSIONAL EXPERIENCE:

BI Architect

Confidential

Responsibilities:

• Define over all technical architecture, selection of technology, best practices for development and post production sustainment architecture for various database related projects/applications.
• Provide hands on logical and physical data modeling and database design responsibilities.
• Responsible for writing complex Transact SQL code to support various database applications serving as online transaction processing or DW/BI applications serving as online analytical processing.
• Own and maintain complete database management systems and associated tasks during the course of development and testing, until handed over to production support.
• Lead ETL/acquisition/distribution design and development initiatives involving multiple complex source and target systems.
• Design and develop complex multi-dimensional cubes for analytics.
• Design and develop data mining platform for predictive analysis, to support client*s requirements like marketing analytics, fraud detection/prevention and customer profiling.
• Set up, configure and optimize performance of Cognos BI software.
• Continually tune databases for optimal performance. Conduct both proactive and reactive performance tuning activities. Maintain historical performance metrics for regression testing of new releases.
• Review project requirements to select suitable technology (Database, ETL Tools, BI Tools, etc.) and estimate time, cost and resources to accomplish project requirements.

Environment: INFORMATICA 7.x/8.x (Power Center / POWER MART), SQL, SQL Server, SSIS, SSRS, SSAS 2008 R2, COGNOS.

Data Warehouse/Data Integration Architect

Confidential

Responsibilities:

• I provided turnkey Data warehousing solutions .
• As the BI Architect, worked intimately with internal and external stakeholders of business intelligence reporting to develop and maintain optimal reporting for client outcomes and internal business processes.
• I supported the modeling of processes and outcomes associated with the client(s) integrated health and productivity management interventions, and customized empirical research for quality assurance, sales, marketing, and publications efforts.

Tools: McKesson CCMS, Informatica 8.x, Java, SSAS, SSRS, SSIS, SQL SERVER 2008, ERWIN, XPF, FACETS 4.51, MMS, etc.

Confidential

ETL Architect

Responsibilities:

• Physician registration management system I have overseen conversion/merging of the legacy data into a newly designed application.
• I interacted with SMEs along with the business analyst in my team to identify data mapping and transformation rules.
• I designed a nightly update process to keep the legacy system’s data in sync with the new application.
• I also developed ETL specification documents as a part of this process.
• I supervised the development and maintenance of Enterprise Wide Clinical Quality Status Reports.
• The Quality reports were delivered to 500 clinics across the nation on a monthly cycle.
• I supervised the development of two data marts.
• The first data mart enables the client to project the revenue recognition and cash reserves that need to be maintained for a fiscal year
• The second data mart enabled the client to price their contracts with CMS and the medical service providers based on actual claims and services rendered in the past year. This enabled the client efficiencies in contract negotiations .

Environment: : Informatica, Oracle 10g, SAS, Business Objects Data Integrator(BODI).

Confidential, Melbourne FL

Responsibilities:

• Worked with Trizetto conversion teams to analyze the legacy data in QNXT system.
• I worked on developing business rules for Membership and Provider subject areas
• Developed data transformation specifications, intermediate data structures and processes for data conversion.
• Used Facets DataModel to develop report specifications.
• Utilized Facets Extensions, Data Publishing Manager, to publish incremental changes to the Facets database. The incremental were used to implement the change data capture strategy in the datamarts.
• Maintained EDI gateways for ANSI 835 837 transactions.

Environment: : HPXR, C#, DPM, Facets Extensions, QCSI QNXT, FACETS 4.31, ERWIN, SSIS, SSAS, SQL SERVER 2005.

ETL Architect/Data Modeler/Project Manager

Confidential, Champaign, IL

Responsibilities:

• Developed detailed functional specifications (including mapping and transformation rules) for Provider, Membership and Claims areas.
• As a project manager, lead a team of 2 developers, business analyst, database administrator and a member of the QA group. Obtained client approval of functional specifications.
• Worked with integration team to research and resolve questions related to functional specifications.
• Approved detailed technical specifications

Environment: QCSI QNXT, MC400, SQL Server 2005, Informatica.

Confidential, Louisville, KY

Project Manager

Responsibilities:

• Conducted business analysis and triages of existing reports in RUBI to identify gaps.
• Designed staging, Operational data storage and data warehouse models.
• Developed ETL Architecture and environment. Installed Informatica 8.0, migrated code between repositories, setup users and connection string permissions, setup naming convention standards, troubleshooted Informatica production problems and maintained the disk space issues.
• Utilized Facets Extensions to implement HIPAA security.
• Architected the data model and DTS scripts for financial data mart. The subject areas included billing and accounting.
• Developed ETL code for membership and claims area.
• Developed rules for data integrity.
• One of the original architects of HPXR.

Environment: HPXR, C#, .NET Framework, Facets 4.11, RUBI, Business Objects 6.5, SAS IntrNet, Erwin, SQL Server 2005, Oracle, Unix and Informatica 8.0

Confidential, Nashville, TN

Project Manager

Responsibilities:

• As a Project Manager I managed the work of 3 developers, Business analyst, a Data Architect and 2 QA resources to deliver the clinical outcomes data warehouse.
• Developed project plan, conducted JAD sessions for business requirement gathering and provided status updates to senior management.
• I developed the data model and ETL mappings for the enterprise data warehouse to report the HEDIS/ John Hopkins Clinical measures. The data model was a hybrid star-snow schema, optimized for MicroStrategy reporting objects and SQL Queries.
• Developed business rules, data transformation logic and metadata.
• Performed source system/data analysis to suggest alternate strategies and risks.
• Developed physical and logical data models using ErWin.
• Sourced Facets Eligibility, Claims, Plan/Product and Group membership into the Datawarehouse.
• Supervised the migration of the Informatica ETL server 5.1 consisting of 500 mappings to Informatica 7.1. Re-architected some of the mappings to optimize for speed, recovery and parallelism.
• Implemented optimization techniques to improve data load speeds for approximately 250 million rows. Performed SQL optimization, session partitions, persistent named lookup caches, bulk load options, source and target partitioning etc, were used. Utilized Grid Computing/Load Distribution feature in Informatica 7.1 to schedule large loads.
• Used new features like source control on Informatica 7.1 to implement version control on the mappings.
• Supervised the QA effort to validate clinical facts for BCBSMN (120 million claim records and 4 million Eligibility records), HMSA, Empire and Oxford.

Environment: Oracle 9.0, FACETS 2.96, Erwin, Informatica 5.1, 6.2, 7.0, 7.1, Embarcadero Rapid SQL, MS Project, MicroStrategy 7.0, SQL Server, Perl DBI, Mod Perl, Perl XS .

Confidential

Project Lead

Responsibilities:

• I architected a data mart that extended the functionality the medical claims data warehouse to include CRM survey data.
• Used Informatica to extract transform and load the data feeds into Oracle Data warehouse. Resolved data transformation and mapping issues, performed implementation and testing of mappings and administered, installed and configured the Informatica environment. Troubleshooted issues relating to the Informatica tools. Managed general administrative duties including running sessions.
• Proposed methods and performed analysis of Diagnostic, Service Utilization and MDS 2.0 Client Assessment Data-Home Care and Nursing Home.
• Developed SAS MACROS for generating Risk Scores, and incorporated the same as a procedure into the ETL Processes developed in SAS/Warehouse administrator. This procedure was used in the rate setting process as a part of risk management.
• Worked on, and collaborated with informatics department on statistical modeling of encounter data to better predict future costs for the STAR+PLUS Medicaid plan. As a part of this process I developed Proc MDDB to develop cubes for analysis.
• I built Universe in BusinessObjects for generating Financial, Utilization and Clinical Reports based on the CRM Survey data.
• Developed BusinessObjects reports and presented results of analyses to internal/external entities as needed.

Environment: CDPS, ACG, DxCG, SAS 8.2, Oracle 8.1, BusinessObjects, Informatica 7.1.3, Oracle Designer.

Confidential

Processor Modeler

Responsibilities:

• Improved the performance of software simulator for Confidential ’s flagship Digital Signal Processor. Developed scripting shell that used Perl as scripting language. I embedded Perl into the existing software simulator and exposed a debugging API for the simulator to be accessed using the shell.
• Developed a translator for automatically translating assembly code between different generations of processors in Java.

Environment: Visual Studio 6.0, Clearcase, Perl embed, perlxs, perlstut, C++, C, RUP, Java, Lex, Yacc.

Confidential

Business Intelligence and ETL Developer

Responsibilities:

• Developed a VB 6.0 application to keep track of pre and post patient survey information. SAS was used to generate reports for the HEDIS studies.
• Used SAS SQL to generate adhoc utilization reports and provider profiling.
• Generated reports in COGNOS Impromptu and PowerPlay that identified top costing diseases and patients, physician practices using encounter data and pharmacy claims. Used this information to decide on capitation fees, stop loss indications and risk management for the plan.
• Developed a HIPAA compliant pharmacy claim submission system. This system accepts encrypted data for claims processing in NCPDP format, keeps track of the claims processors that viewed each record and locks out users without clearance trying to view the records. The system is deployed in pharmacies where prescriptions are filled and with the health care provider.
• Wrote tools in C++, Perl and Awk to translate/extract claims data from an ASCII representation to ECSIF format. This framework was extended to accept repricing claims from CIGNA.
• Developed websites for valleypreferred.com and preferredEAP.org.

Environment: COBOL, Informatica, MS Project, ANSI X12, HIPAA 837, 835 and NCPDP, SAS, VBA, IBM Mainframe, XML, VB6.0, Perl, Awk, Monarch, Cognos Impromptu and PowerPlay, Ingenix Data Warehouse, RIMS HealthCare Management System, RIMS QicLink 2.5, RIMS DataPiction, Rational software tool suite, Oracle 8.1 and SQL Server and JavaLucent Technologies