SUMMARY

• Goal oriented and experienced senior technical consultant with over 20 years of enterprise IT experience.
• Worked on development, product configuration, reporting, and data testing teams as part of four Facets implementations, in addition to smaller Facets development projects.
• Deep knowledge of Facets data model.
• Lead role on 4 Facets implementations as an independent contractor to TriZetto. Roles were on development, conversion, testing, and configuration teams.
• 8 years Facets PL\SQL development
• Developed many custom Facets programs and customizations, including premium rate load program, CMU modifications, benefit data extraction (BSBS auto - populate), auto creation of product shells, and PCA/workflow merge programs for ICD-10 implementation.
• 20 years of database experience
• Data analyst and developer
• 15 years data integration\migration\ETL experience
• Senior level database developer using Oracle, DB2\UDB, SQL Server
• Deep knowledge of PL\SQL, triggers, packages, views, indexing
• 5+ years data testing experience
• 8 years as Informatica data warehouse consultant
• Experience in creation of development standards, including design specifications, source to target templates, and unit\system testing documentation, and overall test plans.
• Over 5 years scripting experience: UNIX shell, Perl, and VB.

PROFESSIONAL EXPERIENCE

Confidential

Facets Upgrade Lead

Responsibilities:

• Worked with Cognizant to test and correct accumulator upgrade scripts
• Trained technical staff on functionality and structure of new accumulator tables.
• Worked with development team on remediating custom code objects.
• Acted as liaison with testing team to identify root cause of defects and working with technical managers to have defects resolved.
• Post conversion, wrote custom scripts to identify and correct accumulator rows converted incorrectly during upgrade.

Facets Lead Developer

Confidential

Responsibilities:

• Wrote custom application to identify and correct accumulator value discrepancies.
• This was accomplished by querying product configuration tables to extract DED and OOP amounts and accumulator numbers, traversing paid claims calculating cost sharing, identifying situations where accumulators did not match calculated amount, and programmatically updating accumulators.

Senior Facets Technical Resource

Confidential

Responsibilities:

• Designed and coded program to pull benefit data from Facets configuration tables. This data was used to validate data between the actuarial systems, summary of benefits, contracts, and Facets BSBS.
• Wrote custom reports to identify and scripts to correct benefit periods on accumulator rows due to enrollment issues.
• Wrote custom program to merge Workflow and PCA data between environments to support ICD-10 implementation.
• Created audit report using Facets audit tables to identify users who updated member data and manually processed claims for the same member. This was part of an audit requirement for the segregation of users’ duties.
• Created database security profile using Oracle roles, synonyms, and views to prevent users from seeing specific member information.
• Wrote additional customizations to CMU application to remove spaces in criteria, automatically load requests, and email load audit results to requestors.
• Trained and mentored associates on CMU tool while spearheading transition from offshore team back in house.
• Worked with product configuration team to script mass config updates.

Confidential

Facets Technical Consultant

Responsibilities:

• Designed and developed custom application to interface with sales system to automatically build products as they are sold. This application would load the product indicative, business information, product components, and limited variable components. The application would also update products as necessary on renewal.
• Designed and developed custom CMU processes to move only deltas when full table move is requested.
• Designed and developed custom program to identify deltas in specific table and create new CMU requests to facilitate environment synchronization.
• Designed and developed custom application to automatically load and update the Facets benefit summary application with product information. This application would also update benefit summaries when product changed.
• Designed and developed Oracle stored procedures to facilitate conversion of product configuration data from Xcelys into Facets.

Confidential

BA/Developer/Test Manager

Responsibilities:

• Diverse role included participating in mapping session with developing mapping documents. These documents serve as a basis for development of migration code. This involves interviewing WPS personnel to determine data layout and configuration and interrogating WPS data to determine relationships, anomalies, and structure.
• Developed code (SQL Server stored procedures and Windows batch scripts) to convert legacy data into Facets.
• Coordinate with off-shore development team on interpretation of mapping documents, creating coding standards, assisting developers during development, and reviewing finished code.
• Create unit testing documents and standards, identify test cases, facilitate test case development, and managed testing cycles.
• Managed keyword files for loading into development and test areas to facilitate interface testing. The files were loaded using Facets utilities including MMS, EGI loader, BLE0, and other Facets utilities.

Confidential

Senior Facets Developer

Responsibilities:

• Designed and coded automated load application for premium rates. The application accepts base rates via Excel spreadsheets provided by pricing/actuarial team, apply appropriate multiplier for factors (age/smoker/gender), and load into Facets premium rate tables.
• Created batch jobs to support loading of premium rates
• Created reports to aggregate premium rate data and to identify issues with previous rate loads.

Confidential

Database developer

Responsibilities:

• Teamed with InPower on large ERP implementation. InPower was Integral’s first foray into client server HR/Payroll systems. My primary responsibilities were the creation of data conversion scripts, but the team’s small size allowed me to participate in most aspects of implementation.
• Helped develop load and testing strategies used for all data conversion scripts.
• Developed template for design specification and unit/system testing
• Wrote all PL/SQL and UNIX scripts used in loading of legacy data
• Created custom C interface to current general ledger and Kronos time collection system
• Created data validation reports using PL/SQL, Crystal Reports, and/or Access
• Modified UNIX and Windows based COBOL programs to represent data model changes
• Created Oracle views and synonyms for role based security.