Mervyn Singh

• Led dynamic team of 10-50 employees, contractors and onshore/offshore resources in support of FACETS platform
• Created environment of respect, professionalism, collaboration and pride across geographies and technical domains
• Provided unparalleled business and platform support specific to Claims and Customer Service domains leading to highest level of customer satisfaction in division
• Directed development, maintenance and enhancement of 400+ system interfaces, extracts, reports
• Established coding standards and best-in-class development practices across SQL, .NET, INFORMATICA and TIBCO teams
• Established quality-assurance processes to enhance productivity, reduce defects, eliminate rework and increase customer satisfaction
• Reorganized and reshaped intake process to optimize resource utilization while significantly reducing cost
• Drove design and development of sophisticated SharePoint repository for interface, project and process documentation
• Drove design and development of custom application to enhance management of 50-70 development projects annually
• Designed and built custom Podio-based solution for application inventory management
• Established environment of trust and collaboration with technical teams, testers, business analysts, system analysts, executive sponsors and senior leadership

• Technical Delivery Manager, Technical Lead, Business Analyst, Technical Analyst and Technical Analyst/Programmer across implementation projects:

.

GOVERNMENT EMPLOYEES HEALTH ASSOCIATION (Lees Summit, MO)
October 2011 – January 2012

• Technical Lead for CLAIMFACTS to FACETS 5.0 conversion
• Led 10 consultants thru triage and disposition of 3,800+ interfaces, extracts, reports, letters
• Established streamlined “factory” approach to achieve optimal resource utilization and output
• Created solution-based development standards for division
• Implemented unique “Current State” vs. “Future State” requirements gathering process based on reverse-engineering existing solutions

.

CAPITAL DISTRICT PHYSICIANS' HEALTH PLAN (Albany, NY)
February 2011 – September 2011

• Technical Analyst/Programmer, Technical Lead in data integration projects between FACETS 4.81 and CAREADVANCE 4.61
• Led team of developers thru groundbreaking “Unique Person ID” initiative that allowed client to use CAREADVANCE to manage care at “person”-level instead of “Member ID”-level
• Gathered and turned requirements into functional and technical designs that facilitated development of robust solutions with no impact on core system functionality
• Handled all SQL Server and Oracle development
• Guided .NET development effort across team

.

CARFIRST BLUECROSS BLUESHIELD (Baltimore, MD)
July 2008 – January 2011

• Technical Analyst/Programmer and Technical Lead for Interfaces and Extensions team handling design, development and delivery of interfaces and extensions in Claims, Customer Service, Provider, Care Management and Membership domains
• Migration from FACETS 4.31 to 4.5 leveraging previously unused core capabilities
• Technical Lead, Technical Delivery Manager for upgrade to FACETS 4.71
• Instrumental in generation of impact analysis reports and upgrade of existing interfaces and extensions to FACETS 4.71

.

METLIFE MEXICO (Mexico City, Mexico)
April 2008 – June 2008

• Technical Lead in assessment phase of project
• Identified all interface and extension points between FACETS and MetLife internal and external systems
• Produced gap analysis to ensure successful FACETS implementation

.

AMERIGROUP CORPORATION (Virginia Beach, VA)
April 2007 – March 2008

• Developed PL-SQL-based Provider Conversion & Synchronization interface to transform new and updated legacy provider data into FACETS data structure
• Developed PL-SQL and SQL*Loader-based XPF Log Parser application to enhance analysis and reporting ability relative to standard XPF Provider Batch Import Subsystem log files
• Developed SQL*Loader scripts to automate maintenance of Oracle-based Provider crosswalk tables sourced from Microsoft Excel worksheets

.

GREAT-WEST HEALTHCARE (Denver, CO)
January 2006 – March 2007

• Developed PL-SQL Conversion and Synchronization interface to transform new and updated legacy provider data into FACETS data structure
• Developed custom triggers to supplement FACETS’ core audit functionality
• FACETS “back-end” expert across project teams
• Governed development of PL-SQL functions and procedures

.

CAPITAL BLUE CROSS (Harrisburg, PA)
April 2002 – December 2005

• Handled Quality Assurance review and approval of code generated by team of Technical Analyst/Programmers
• Led stored procedure development to refresh Oracle data warehouse with Sybase data
• Produced daily/weekly/monthly data feeds for claims and eligibility vendors
• Created daily Sybase extracts to update legacy systems and support real-time, HIPAA-compliant Web, IVR and EDI inquiries against Sybase data
• Created SQL coding and documentation standards for enterprise
• Led code optimization effort that reduced monthly batch time by 200+ hours

• Developed “JOBTRAK” unified project tracking system to capture and relate 3 separate business processes
• Developed “Bill of Materials” solution to standardize and automate production of construction-related documents
• Optimized management reports while enhancing data integrity and consistency
• Facilitated output to pre-defined Excel worksheet and AutoCAD drawing

• Debugged, resolved 10+ functionality issues with “AMYCI Billing” solution
• Updated, enhanced GUI interface and VBA code to align with standards
• Reformatted, standardized layout of screens and reports
• Optimized “CSMART” reporting interface to significantly reduce report run-time
• Reformatted, standardized layout of “iMagic” screens and reports
• Enhanced reporting functionality through addition of data filters, sorting, grouping options

• Developed “Membership Maintenance Subsystem” solution which reduced eligibility load time into FACETS/Sybase from 3-5 days to under 1 hour
• Developed “HIPAA Certificates & Cobra Letters” solution to automatically produce “statement of coverage” letters triggered by coverage termination
• Developed “Explanation of Benefits Statements” solution to generate 6,000+ daily EOBs built upon extensive set of business rules and direct interface to Sybase
• Developed “Ad-hoc Reporting Database” to facilitate immediate distribution of new and modified reports to business units, eliminating previous 3-4 day cycle
• Rewrote 15+ Sybase stored procedures to reduce data redundancy, optimize use of indexes and employ advanced coding techniques that resulted in savings of 5+ hours per nightly batch cycle
• Fully employed GUI interfaces, ODBC/pass-through queries, security, reporting and auditing functions in every MS Access application
• Employed extensive use of VBA code to enhance application efficiency and responsiveness

• Developed “Miscellaneous Paying Teller” solution to automate and improve management of currency exchange services while eliminating 2 hours of manual reconciliation and reporting time daily
• Developed “Employee Review and Evaluation” solution which centralized Human Resources data collection, improved headcount management and prepared budget/forecast reports for all levels of management
• Developed “Project Management System” used company-wide to consistently log inter-departmental work requests, track project status, facilitate cost analysis and provide upper management with statistical reports on daily average of 200 open work requests

• Developed “Delinquent Accounts Reporting and Tracking System” solution which reduced generation of “aging” and other statistical revenue reports from 4 days to less than 1 day
• Administered rollout of “Decision Analyzer” mainframe-based ad-hoc reporting software and provided file definition, training and support
• Developed “System Change Request” solution to track changes to numerous systems on various platforms
• Developed “IVR Reporting” solution to automate statistical analysis of data from IVR system and reduced turnaround time from 2 days to 5 minutes
• Developed numerous “Project Management” and “Error Tracking” applications for various business units for purposes of quality analysis and process improvement

• Introduced unparalleled level of reporting flexibility and sophistication through use of Query Management Facility (QMF), IBM's advanced application development and reporting tool used to access and link DB2 tables on IBM mainframe
• Created QMF training program and conducted bi-monthly training sessions with key Sales & Marketing support personnel across eight offices
• Designed and implemented in-house PC support program that offered hardware and software training and support to over 1,500 employees