Jennifer Quack Email & Phone Number

Atlanta, GA, US

Mclean, Virginia, US

• Designed, implemented, and directed the Enterprise Process Management Office’s Measurement and Analysis (MA) Program. Networked with teams and all levels of leadership throughout the stages of iterative report.
• Successfully created the MA Program in under three (3) months.
• Automated monthly reports, decreasing manual reporting hours by approximately 15% per month per team.
• Established multiple reporting levels, such as individual performance statistics, project KPIs, and quarterly OKR reviews.
• Engineered reports that provided revenue opportunities and provided value to various internal and external customer groups.
• Created the frameworks for data and report governance.

Mclean, Virginia, US

• While the primary focus of this role was on Report Management, it also included significant Process Improvement responsibilities. In addition, my extensive expertise in SharePoint Online, Microsoft Teams, and As-One.
• Produced project and organizational reports and dashboards for measuring and analyzing OKRs and KPIs across and between projects in CNSI’s Midwest Region.
• Owned and enhanced projects’ monthly health check and quarterly program review reports, including organizational metrics.
• Created actionable reports using iDashboards, Power BI, and Excel, supported by various tools such as PL/SQL, MySQL, Jira, SharePoint, and Power Automate.
• Set up the instrumental groundwork for the enterprise-wide adoption of the Measurement and Analysis Program that I later implemented.As a Process Improvement Manager, I:
• Merged three Quality Management SharePoint sites into a single site accessible by all employees.

Mclean, Virginia, US

• Gathered and analyzed requirements, designed, and managed development for the initial release of myHealthButton™, CNSI's interactive mobile Medicaid consumer engagement application.
• Initiated requirements gathering, analysis, and design of myHealthPortal, CNSI’s interactive online Medicaid consumer engagement portal.
• Contributed to the transition of Excel report queries for use in HealthBeat™, CNSI’s data visualization dashboard for business and IT Operations management.
• Continued to maintain and enhance previously created Excel reports.

Mclean, Virginia, US

• Built data models and reports in Cognos to report across all Medicaid Enterprise System subsystems (Claims, Provider, Member, etc.) within CHAMPS - Michigan's Community Health Automated Medicaid Processing System.
• Continued to maintain and enhance previously created Excel reports.

Mclean, Virginia, US

Gathered requirements for updates to the Michigan Medicaid Claims Processing subsystem within CHAMPS (Community Health Automated Medicaid Processing System). Created Use Cases for the design and implementation of change requests and enhancements.

Mclean, Virginia, US

• Parallel tested Michigan's Legacy Medicaid Management Information System (MMIS) against CNSI's newly built CHAMPS (Community Health Automated Medicaid Processing System). Utilized Microsoft Access and Microsoft Excel..
• Established internal and client reports; designed, automated, and delivered almost 30 reports on interface files and data within the Oracle backend system, using Excel and VBA. Utilized PL/SQL during the report.

Dedicated time to raising my children but continued to dabble in the technology space to keep up to date and satisfy the geek in me. Participated in the school Parent-Teacher Organization (President, Vice President, Secretary). Designed web sites. Allowed myself time to improve my riding skills and commune with my equestrian community. Volunteered as a.

This role was a highlight of my time contracting through TEKSystems. Migrated broker-dealer data from WinOps, SQL Server, and Paradox into DB2 using Microsoft SQL Server's Data Transformation Services. Created an automated representative commission report using Excel and VBA.

Automated the drug recipe creation and documentation process by creating step-by-step wizards within Microsoft Word using VBA. The wizards obtained input from the user as well as pulled recurring, standard text from a Microsoft Access database. Recipes could then be printed to use on the factory floor to guide the manufacture of drugs produced by the.

Houston, Texas, US

• Lead, and then Manager, for Medicaid Long Term Care Division on EDS’ contract with State of Michigan.
• Migrated Long Term Care Cost Report from manual data entry (pencil and paper) to a 27-worksheet Excel Workbook Template that was distributed to all Long Term Care Facilities within Michigan.
• Automated data validation within the workbook.
• Automated the data extraction from the returned workbooks into SQL Server, with additional data validation included, using both Visual Basic and Visual Basic for Applications.
• The report contained over 10,000 lines of VBA code to enable all of the automation for validation and data extraction.
• Automated various other smaller reports in similar manner – validated data entry and eventual data extraction into our SQL Server database.

• Highly-rated trainer.
• Created training manuals for and taught all manner of business applications to various companies in the area such as Whirlpool Corporation, Gast Manufacturing, and the Palisades Nuclear Plant. Some of the applications.
• Developed various applications for Whirlpool Corporation such as o Financial Reporting: Extract, transform, and load over 11 million financial records from Paradox into Microsoft Excel 95, using Visual Basic for.