Developed supplemental metrics to Revenue Cycle Management metrics for internal use by client services team. Assisted in performing contract analysis to determine underpayment/overpayment by payer to providers.Created stored procedures for analytical datamarts to be used by BI reporting team.

Served as a Subject Matter Expert for IT Business Analysts and the data warehouse ETL team in generating a set of BI analytic reports, including End-of-Month financials and A/R reporting, as well as key performance indicators.Determined BI and data warehousing solutions to meet the needs of the Client Services team.Built and automated a series of stored procedures from flat files to load new datamarts for the BI reporting team.Developed supplemental metrics to Revenue Cycle Management metrics for internal use by client services team.

Led a team of two junior QA analysts and built test plans for the data warehouse. Developed and designed ETL test cases and scripts to ensure valid and correct data was loaded for a brand-new Revenue Cycle management data warehouse from for multiple Practice Management systems (including GE’s FlowCast, GroupCast, Allscripts, and EPIC).

BI Report Building – captured business requirements, built mock-ups, validated data sources and measurements, served as Subject Matter Expert to developers in creating reports, ensured compliance with change management processes.

Created and automated analytical reports using Business Objects XI and Excel to provide metrics around the submission, aging, and resolution of IT service requests and “problem” tickets by external and internal customers, as requested.

Communicated with members of business/IT teams to gather detailed business requirements and workflow processes for cross-functional project, specifically regarding claims and clinical reporting. Collected and analyzed the project’s business requirements and transferring the same knowledge to development team.Prepared accurate and detailed functional and technical requirement specifications and documents.Documented the acquired results of analysis and workflows as well as obtaining sign-off from the appropriate business team.

Built prototype for paid claim analytics reporting providing a "film level roll-up" view of claims which retains and compiles all sub-claims (e.g. multiple riders, etc.) for a given film number and calculates aggregate dollar values and specific dimensional attributes as related to the overall submitted claim bill. This is now updated monthly and consists of 3+ years of data.Intensive SQL coding (Toad/Oracle 10g) against claims datamart(s) for ad-hoc reporting provided primarily to the Claims and Actuarial departments.Automation of ad-hoc reporting by writing stored procedures to be executed via Informatica workflows.

* Maintained and administered all pieces of the Cognos version 7.3 toolset, including security, publication of Impromptu Web Reports, PowerPlay reports/cubes, maintenance of all Impromptu catalogs, and general troubleshooting.* Stabilized the Cognos environment and nightly production build batch cube builds for 50+ clients by completely redesigning 200+ cubes, which provided revenue and A/R mgmnt analytics for doctor practices.* Automated Impromptu reports to meet client needs. Created DTS packages to automate processes and improve processes in the client SQL databases.* Served as Subject Matter Expert for Help Desk and Finance personnel in SQL Server 2000/2005 database administration tasks and troubleshooting.* Assisted IS developers and Financial analysts in troubleshooting logic in stored procedures creating the data warehouse. Built reports using SQL Server / GE Centricity ® physician practice software.

formerly JCPenney Direct Marketing Services