SUMMARY

• 10+ years of experience providing Business Data quality solutions.
• Extensive experience mapping and transforming data.
• Experience in conducting client interviews in order to map client data to gain insight into data processing procedures and the location of data sources.
• Experience in developing project schedule, estimates, regular status reports, and final deliverable.
• Experience in health plan analytics and visualization reporting in Excel and Tableau.
• Extensive experience building queries in SQL and MySQL.
• Experience in gathering reporting requirements from the business users for business intelligence, data warehouse application.
• Extensive experience utilizing advanced formulas in Excel (calculations, vlookup, concatenate, sumif, countif, macros, pivot tables).
• Experienced as a Lead BA.

TECHNICAL SKILLS

• SQL
• SQL Server
• Toad for MySQL
• Workbench for MySQL
• Jacada for Java iseries
• AS/400 IBM Control Language (CL/CLP)
• Query/400
• DDS
• IBM Personal Communications
• Mocha 5250
• MKS Implementer
• Point Insurance Processing System
• ERwin
• XML
• Microsoft Excel
• Microsoft Word
• Microsoft Access
• Microsoft Power Point
• FTP
• WinSCP
• Tableau

PROFESSIONAL EXPERIENCE

Confidential, Tampa FL

Business Data Analyst Lead

Responsibilities:

• Led the execution and delivery of the claims analytics and ad hoc reporting. Performed an assessment of all aspects of health plan lab spend. Produced analytics that were used directly by the sales team to present savings opportunities for potential clients. Worked directly with VP of Analytics and CFO.
• Responsible for project schedule, estimates, status reports and final deliverable.
• Utilized the health plan claims and member data to produce detailed payer insights including member liability, member utilization, pmpm, unit costs, and trends.
• Performed detailed line level claims analysis in MySQL using Toad.
• Performed health plan analytics and visualization reporting in Excel and Tableau.
• Produced field mapping documents to transform payer data into the client’s standardized format.
• Performed data analysis and ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Responsible for managing 2 SQL developers.
• Managed the MySQL database.
• Responsible for data quality.
• Responsible for data normalization.
• Performed table indexing.
• Applied database best practices including meaningful naming conventions, manual backups, descriptive code comments, general housekeeping.
• Validated data in SQL using data profiling techniques to determine date ranges, LOB types, and field value frequency.
• Cleansed all data in SQL. Resolved and documented data quality issues.
• Coded ad hoc financial reports for CFO in SQL.

Confidential, Durham NC

Business Data Analyst Lead

Responsibilities:

• Led a performance analysis of the payer’s claim payment integrity vendors which resulted in over 8M in client administrative cost savings.
• Responsible for the project schedule, estimates, regular status reports, and final deliverable.
• Responsible for managing and mentoring a SQL developer.
• Conducted client interviews to gain insight into processing procedures and the location of data sources.
• Performed substantial data mining in SQL Server.
• Performed data analysis and ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Performed a detailed line level claims analysis. Determined the vendor’s actual savings vs. reported, hit rate accuracy, overlap, and overturned recommendations utilizing advanced formulas in Excel (calculations, vlookup, concatenate, sumif, countif, macros, pivot tables, ...)
• Coded ad hoc financial reports on SQL Server.

Confidential, Philadelphia PA

Business Data Analyst Lead

Responsibilities:

• Supported the technical build - out and process implementation for a new payment integrity infrastructure.
• Conducted client interviews in order to map client data into Confidential ’s payment integrity engine.
• Involved in gathering reporting requirements from the business users. Involved in building data warehouse application.
• Developed data extract mapping requirements based on the client’s data warehouse.
• Produced monthly claims prevention and recovery detail report in Excel.
• Developed validation processes for monthly provider retractions to ensure data quality.
• Identified and implemented data quality improvements on SQL server.
• Coded ad Hoc financial reports on SQL Server.

Confidential, Lincolnshire, IL

Data Analyst Lead

Responsibilities:

• Designed the approach to create a consolidated and centralized AS/400 system for new store locations.
• Produced data models as well as system behavior models of the multisystem infrastructure and communications of the current and future state. This included detailed relationship diagrams of tables, files, libraries, and data flows.
• Responsible for the final QA review of CL code produced by offshore resources. Reviewed and corrected formalized technical specifications of code changes for proposed design.
• Designed complex system models and data models in Power Point. Presented slides to client stakeholders.

Confidential, Lansing MI

Business Analyst Leader

Responsibilities:

• Developed and customized insurance processing software for commercial P&C insurance client.
• Conducted requirements gathering. Translated business requirements into functional and technical specifications.
• Designed the technical approach and procedures for system conversions. Produced detailed field mapping, data modeling, and transformation documents.
• Designed and coded user screens and screen flows using CL and Jacada (java based development tool).
• Designed and coded management financial reports from a complex relational database using CL and SQL.
• Produced automated financial reports to acquire dates, environment details, and perform a timed execution.
• Created custom test matrices. Executed testing to meet business requirements with a focus on functionality, using properly sized and diversified data samples.
• Performed regression testing as new code was introduced into the system.
• Developed and implemented AS/400 cycle runtime improvements.
• Provided technical troubleshooting support for system failures.
• Managed AS/400 security admin tasks including creating user profiles/accounts, granting object authority and modifying authorization lists.
• Developed an encrypted file transfer system for an AS/400 receivables system. Process included a FTP pickup of a PGP encrypted file.
• MKS Implementer production “Gate Keeper” for data integrity.
• Responsible for reinsurance contract interpretation and business implementation.

Confidential, Brooklyn NY

Business Analyst Leader

Responsibilities:

• Created financial and ad hoc reports from a complex relational AS/400 database environment.
• Provided technical troubleshooting support for system failures.
• Provided user support for the customized P&C insurance Point application.
• Produced detailed field mapping for data conversions.

Confidential, Princeton, NJ

Senior Underwriting Assistant

Responsibilities:

• Quoted, endorsed and issued multi-line commercial policies.
• Liaison between agents and underwriters.
• Trained new department employees on using the insurance processing systems.
• Developed and implemented process recommendations to improve efficiency in claims processing.