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 development. Produced interactive reports and dashboards within Power BI and Excel. Directed the team’s tasks across data gathering, profiling, modeling, validation, visualization, security, and publishing. Aside from spearheading the strategic planning and implementation of the MA Program, I also championed the team’s professional development.• 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. • Initiated Master Data Management within the organization.• Leveraged SharePoint Online and Microsoft Teams Administration experience to enhance the MA Program, via report and dashboard integration within SharePoint sites and Teams’ channels.• MA Program implementation was a crucial factor in obtaining CMMI ML3 and ML4 appraisals, as well as the ISO 9001:2015 certification. The CMMI Lead Appraiser for ML4 declared the MA program one of the most robust he’s seen.

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 (CNSI’s project management and collaboration tool), naturally placed me in the corporate administrator role for these platforms, as well.As a Report Manager, I:• 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.• Revamped the Organizational Change Request Process.• Successfully Led the Enterprise Process Group (EPG), a cross-functional team from all levels, through the Organizational Change Request process, providing daily metrics to ensure prompt completion of requests.As the SharePoint, Teams, and As-One administrator, I:• Led the enterprise-wide migration from Skype to Microsoft Teams.• Created SharePoint Online template sites for all projects, establishing standards and governance.• Migrated data from fileservers to SharePoint Online.• Managed work products, action items, risks, issues, change requests, and knowledge library items within As-One.• Directed changes and enhancements to As-One and provided User Acceptance Testing for the product.• Maintained user administration and security within each tool.• Provided extensive training on each tool for all levels of the organization.

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. Automated testing with Visual Basic for Applications (VBA). • 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 development.

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 board member (former Vice President), of GLASS-ED (Great Lakes Area Schooling Shows - Educational Dressage), where I helped to guide the growth and mission of the club. Ran and helped others run dressage shows. Migrated the club omnibus to Microsoft Word, revamped the web site, and set up automated ring scheduling in Excel to correctly schedule dressage tests for up to four rings at a time per day.

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 company.

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 taught: o Samna, ProWrite, Harvard Graphics, SuperCalc, Lotus 1-2-3, Lotus Notes, WordPerfect, WordPerfect Presentations, Microsoft Windows 3.1, Microsoft Word, Microsoft Excel, Microsoft PowerPoint.• 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 Applications and the new PivotTable feature. o Formal Management Reporting: A report used by sales representatives in the field to show to the customer (big box stores, generally) profit that could be generated by selling certain Whirlpool brands in their store. This report allowed the representative to show/hide different aspects of the products and set percentages to flow to the prices that would be seen by the customer. After a sale, the representative could then run a report to show commission that had been made. All of this was created in Excel for the Mac, using VBA.