Page *

JENNIFER GALOVSKA

ad3cpa@r.postjobfree.com

586-***-****

SUMMARY

A highly motivated Six Sigma trained professional with over 10+ years of experience working with large & complex data sets relating to dynamic workflow structures, designing custom performance reporting dashboards, using Key Performance Indicators (KPI’s), data provisioning TDP in Teamcenter & SLICwave Technologies. Strategically aligned with program leadership in departments such as Configuration Management, Supply Chain Management, Finance, & Business Operations. Implemented Continuous Improvement Processes reducing manual processing time requiring extensive and strategic data analysis methods and concepts supporting industries in Government, Automotive, Staffing, Health Care, Commercial and Market Research Analysis. Highly knoweldegable working with large data sets pertaining to business processes & operations, Engineering Change related information, Bill of Materials (BOM files) & Indentured Parts Lists (IPL), and financial information for billing related purposes, market research analysis, and cost saving methods. Extensive experience working with system report developers in both UAT and production environments, performing testing on data outputs in real-time environments. Advanced experience performing critical on-the-fly analysis pertaining to business performance, operational pricing, and profit analysis to meet customer & leadership demands. HIGHLIGHTS/SKILLS

• MS Excel: pivot tables and data slicing, query & MACRO development, VBA scripting, formulas for statistical analysis, dynamic & interactive charting/ dashboards, trend reporting, performance monitoring, forecasting, goal seeking, and what-if analysis.

• Database Management Software: Teamcenter, Teamcenter Reporting Analytics (TcRA), CMstat/PDMplus, SharePoint, MS SQL Server, MS Access, SmartSheet, and various custom in-house built management systems.

• Web Intelligence Reporting & Visualization Tools: Teamcenter Reporting Analytics (TcRA), Business Objects, Crystal reports, JAVA, Oracle, XML, SAS, Smart Sheet, Tableau Software & Server Application, MS SQL, and Hadoop.

• Strong ability to analyze large & complex data sets pertaining to business operations, dynamic workflow structures in Engineering supporting departments in Supply Chain Management, Configuration Management, and other technical department at various levels required to meet leadership demands.

• In-depth knowledge gathering requirements, performing gap analysis, defining project scope, and performing system testing in UAT environment in Teamcenter, B2b Buyer, Business Objects, and MS SQl Servers.

• Advanced experience in Data Modeling, Data Cleansing & Migration processes, and System Integration Testing.

• Data Analysis & Modeling Software: TCrA, Tableau, SmartSheet, Visio Studio, MS PowerPoint, Erwin. WORK EXPERIENCE

Dec 2018 – Aug 2023 GENERAL DYNAMICS LAND SYSTEMS, STERLING HEIGHTS, MI PROVISIONING: LOGISTICS: GRAPHICS ENGINEER ANALYST: REPAIR PARTS & SPECIAL TOOLS ASSISTING US ARMY

-Collaborated in assistance with suppliers & logistics CRMs to ensure required parts were provisioned in compliance to government specifications utilizing WEBFLIS…CAD CARD ISSUED.

-Provided required data for provisioning conferences to ensure drawings / artifacts were approved as required per IPL.

-Worked Closely with ME Engineering & Teamcenter developers in development for vehicle parts specification in SLICwave & Teamcenter technologies.

- Assisted in ensuring all required parts were validated with correct NSN compliance.

- RPSTL graphics designer in Teamcenter once parts were provisioned & suppliers in compliance. Page 2

-Designed custom Vehicle Maintenance Support Graphics utilizing provisioned Bill of Materials reports & Vehicle Maintenance Support Procedures using EMS & Temcenter

-Responsible for verifying & implementing Vehicle Graphics from external departments & ensuring graphics requests were properly configured

-Strategically implemented vehicle graphics methods for linking Teamcenter real-time data at various vehicle design phases

-Determined Vehicle Failure Rates & established modification to parts information

-Modified & Designed back-end artifacts using Failure Rate Reports established while working with various Vendors & internal departments.

-Responsible for reporting & designing critical updates required for Vehicle Maintenance & Operation

-Worked alongside US Army Soldiers & Vehicle Design Engineers during testing phases to ensure maintenance Graphics were aligned with critical updates made to back-end graphics prior to vehicle production phase.

Mar 2017 – Dec 2018 GENERAL DYNAMICS LAND SYSTEMS, STERLING HEIGHTS, MI CONFIGURATION CONTROL CHANGE PROCESS ANALYST:

-Designed custom reports and interactive dashboards supporting the Engineering Product Lifecycle Management Process (EPLM) utilizing data output from Teamcenter, BOM, IPL, and other change related databases.

-Provided custom repots to program leadership related to change information such as timing, Model impact analysis, rejection rates and sign-off performance quickly, and comprehensively supporting various stages in the change process

-Implemented strategic reporting methods for linking Teamcenter real-time data at various EPLM phases to real-time data output from the USG Windchill system to ensure timely processing of change requirements at various EPLM phases.

-Played key role in various six-sigma related projects providing supporting data for savings approval reducing manual processing time by 80%.

-Implemented Continuous Improvement Processes to help meet department goals

-Interfaced & collaborated closely with Engineering Project Managers, Supply Chain Managers, Buyers, Designs Services and other technical GDLS departments on large scale projects requiring detailed & custom analytics.

-Performed additional technical research and investigations as required in GDLS systems using CMStat/PDMplus, Teamcenter, Problem Change Management System, and Oracle platforms supporting BOM files, configured drawing specifications and other technical artifacts

-Collaborated closely with Teamcenter report developers and project leads during development of new/dynamic system generated reports in both UAT and Production environments.

-Compiled and implemented prototype data produced throughout the EPLM lifecycle using current custom report layouts for potential transfer to the TCrA reporting tool (Teamcenter Reporting & Analytics)

Jan 2016 – Dec 2016 FORD MOTOR COMPANY, DEARBORN MI DATA ANALYST

Responsible for developing and processing advanced performance reports for the US automotive market measuring share performance, evaluating buyer-behavior activity and incentive spending performance supporting senior management.

• Frequently completed ad-hoc requests requiring comparative analysis in buyer behavior activity relating market share performance vs. vehicle pricing & cost management. Page 3

• Performed advanced statistical analysis in MS Excel using pivot tables, executive dashboards and dynamic / interactive charts for trend reporting, performance monitoring, forecasting, and what-if analysis.

• Performed data retrieval connections from MS SQL Server, MS Access, ODBC data sources, and company Mainframe Systems (IBM HOD) for analysis in MS Excel.

• Collaborated closely with IT and Data Development teams during mission-critical data mitigating initiatives to ensure new data sources were properly cleansed as required for system integration.

• Transitioned data stored on Mainframe Systems (IBM HOD) to MS SQL Server for centralized storage and processing.

• Designed, processed and distributed standard daily, weekly, and monthly reports.

• Supported month-end sales reporting, mid-month sales updates and facilitated Special Attention Reviews as requested by senior management & brand teams.

• Key business contact for the U.S Sales Reporting & Executive Dashboard online systems. Jan 2015 – Jul 2015 CITY OF DETROIT, DETROIT MI

INFORMATION & STRATEGY REPORTING MANAGER

Responsible for operational and financial performance analysis pertaining to city-wide based initiatives as planned by the Mayor of Detroit, supporting the Management Supervisory Services Department.

• Utilized Key Performance Indicators to establish performance goals for all city based services

• Prepared all city-based SLA’s (Service Level Agreements) aligned with budget expectations supporting departments in Parks and Recreation, Municipal & Human Services, Water and Sewage, Police, & Department of Neighborhoods.

• Developed cost management models to ensure budget expectations were met in service departments.

• Performed cost-analysis on city employees retrieving data from Applicant Timekeeping & Billing Systems

(WorkBrain / TimeClick).

• Managed the planning and development of reporting processes & procedures.

• Formally presented city-service performance results to department leaders, city council staff, citizens, and the Mayor of Detroit.

Oct 2013 – Dec 2014 MACOMB FLOORING LLC, MACOMB MI BUSINESS FINANCIAL ANALYST

Responsible for gathering and defining financial business requirements for sales performance reporting, inventory management, and employee cost. Closely collaborated with business owners and sales staff to ensure specifications for performance metrics were aligned with company objectives.

• Established performance goals for the sales staff, marketing staff, and inventory management departments.

• Performed routine profit-margin analysis and market research on business inventory to ensure prices were aligned with market demand.

• Designed, implemented, and processed inventory and sales performance metrics using MS Excel & Tableau.

• Created databases in MS Access for inventory, sales performance, and financial data,

• Created queries and macros in MS Access & Excel for custom billing, inventory analysis, sales performance, and cost analysis reporting.

• Developed & maintained Cost Management Models using MS Visio.

• Monitored performance for sales & marketing staff and facilitated weekly one-on-one performance review meetings.

• Presented weekly business performance results to sales & marketing staff & business owners in MS PowerPoint. Apr 2013 – Sep 2013 FORD MOTOR COMPANY, DEARBORN, MI SR. DATA ANALYST

Collaborated closely with the EPIC Group (Enterprise Process IT Commonality) requiring advanced data analysis and testing using a Six Sigma IT approach for information pertaining to Bill of Materials (BOM). Core responsibility Page 4

focused on analyzing, cleaning, and mapping large & complex data sets requiring transfer to Hadoop and MS SQL Server for management and processing.

• Worked closely with Data Engineers to identify & interpret data trends, perform gap-analysis, and identify disconnects during testing initiatives.

• Developed Test Cases to verify if data elements were properly cleansed and aligned with existing IT Architecture.

Jan 2005 – Mar 2013 MSX INTERNATIONAL, WARREN, MI

STRATEGY ANALYST

Responsible for overseeing the data analytics & reporting teams located in US, Canada, UK, and Germany, performing advanced analytics in program & vendor performance, cost management, and vendor compliance metrics. Assigned global point-of-contact for custom ad-hoc reporting and defining requirements for processing operational & financial performance metrics. Collaborated directly with VMS/MSP New Business Development Team and potential new clients.

• Provided key input into clients Cost Management Strategy by defining reporting processes and compliance guidelines.

• Provided training to external teams on Vendor Compliance Audit processes.

• Closely collaborated with Program Managers (CRMs) to define data requirements for operational & financial performance metrics using KPI methods to establish client objectives and define metric goals.

• Engaged in global team capacity building by developing best-practice solutions for managing complex data sets and strategy methods for performing effective analysis.

• Designed databases in MS Access, storing data retrieved from web-based Learning Management Systems

(b2bBuyer, People Fluent, Tableau, Fieldglass)

• Utilized BI reporting tools for maintenance of reports in Business Objects & Crystal Reports.

• Designed Database & Data Flow Models using Entity Relationship Diagrams, Conceptual Diagrams and Logical Diagrams in Erwin, Visio & MS PowerPoint.

• Defined data and configuration requirements for applications running JAVA, Oracle, or XML reporting platforms. EDUCATION

UNIVERSITY OF DETROIT MERCY: JAN 2003 – MAY 2004

Master of Science Computer Information Systems

UNIVERSITY OF DETROIT MERCY: JAN 1999 – AUG 2002

Bachelor of Science: Computer Information Systems

Elected Suma Cum Laude & Deans List

Topic: Information Security

SIX SIGMA GREEN BELT TRAINING, VILLANOVA UNIVERSITY, 2012

Contact this candidate