Business Development Power Bi
Resume:
Page *
JENNIFER GALOVSKA
*********@***.***
SUMMARY
A highly motivated Six Sigma trained professional with over 10+ years of experience supporting industries within the U.S Government/DoD, Automotive, Healthcare, Commercial, and Public Sectors. My diverse experience in Data Engineering, Program Performance Management and Strategy Analytics has allowed me to successfully engage in global team capacity building by developing best-practice solutions for managing data applications and continuous improvement strategy methods for new business development and overall business performance reporting.
CAREER HIGHLIGHTS
Active National Security Clearance
Defined and implemented operational and financial reporting criteria under Balanced Scorecard STARS Methodology (KPIs). Output was delivered & presented in Power BI.
Collaborated and led cross-functional teams and IPT in Engineering Logistics, IT, Program Management, Supply Chain Management, Finance, & New Business Development.
Extensive experience in financial business operations and cost analysis and management initiatives in Contract Bid Awards, Proposal Development & Analysis (RFQ/RFB)
Defined resource and cost savings allocations for vendor management performance reporting.
Configured necessary technical system applications using API and SQL Query Requirements.
Defined engineering data work-flow requirements and data modeling structures. AREAS OF PROFICIENCY
Microsoft Office Tools: Excel, Word PowerPOint, Project, Power BI
Web Intelligence Analysis & Data Visualization Tools: Teamcenter, Performance Reporting in MS Power BI, API, Python, Data Workflow Configuration, BOM Configuration, Visibility of Product Structure in TeamCenter VisMoc. Windchill, Teamcenter Reporting Analytics (TcRA),
Data repositories and collaborative environments: SharePoint, b2bBuyer, People Fluent, Tableau, Fieldglass
Data Engineering: Data Modeling in API connectivity, Data Cleansing & Migration processes, and System Integration Testing.
WORK EXPERIENCE
Mar 2024 – Oct 2024: DATA ENGINEERING COMPLIANCE MANAGER AMERICAN RHEINMETALL VEHICLES, TROY, MI (short-term contract)
Lead New Business Development Teams in establishing workflow reporting criteria and KPI performance metrics as required in the development of contract and proposal specifications.
Worked with internal stakeholders in the review of program deliverables and contract agreements to ensure compliance.
Defined data and configuration requirements for government applications supporting Program Management.
Reviewed, submitted, and tracked final contract & proposal deliveries to the US Government
(ARCUS/WINDCHILL/Teamcenter Applications)
Compiled resource cost, schedule, and technical design in the development of final contracts and proposal negotiations.
Ensured Deliverables were in USG compliance by properly assigning classification of products using EAR & CCL, ITAR data markings (Dist D / Dist E / CUI/ EAR) Page 2
Assigned DEFAR statements to program deliverables to the USG (encryption required)
Tracked and Reported Vehicle Delivery performance for Cross Functional and IPT Teams using Data Models presented in Power BI.
Liaison with system report developers in both UAT and production environments during performance testing on data output.
POC – Data Transfers with foreign partners requiring ITAR Export Controlled Information & Deliverables (CUI and Classified)
Maintained and matured data management processes and deliverables in compliance to USG requirements (CDRLS, SDRLS, TPD, PRODUCT STRUCTURE, Data Accession List). Jan 2020 – Aug 2023: LOGISTICS DATA ENGINEER & RPSTL ANALYST GENERAL DYNAMICS LAND SYSTEMS, STERLING HEIGHTS, MI (contract)
Modified & Updated back-end artifacts/drawings and BOM Reports in Teamcenter Reporting Analytics (TcRA), & SLICWave
Developed Program MAC Charts and Vehicle LCN Product Structure Reports in SLICWave.
Acted as point-of-contact with Vendors & internal departments for Vehicle Maintenance & Operational procedures.
Designed custom Vehicle Maintenance Support Graphics supporting Bill of Materials, IPL reports & Vehicle Maintenance Support Procedures (EMS, Teamcenter, CAD Design in CREO)
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 with API data.
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.
Jan 2018 – Dec 2019: LOGISTICS PROVISIONING CONFIGURATION ANALYST GENERAL DYNAMICS LAND SYSTEMS, STERLING HEIGHTS, MI (contract)
Collaborated with suppliers & logistics CRMs to ensure required parts & technical datasets
(TPD) were provisioned in compliance to government specifications.
Responsible for performing Configuration Management activities related to the design, development, and vehicle production in Teamcenter and SLICWave databases.
Managed change requests in Teamcenter & workflow configuration.
Updated Windchill & WEBFLIS database (CAD CARD ISSUED).
Ensured Vendor Data Assertions Lists were maintained & updated across department projects.
Presented required data for provisioning performance conferences to ensure drawings / artifacts were approved as required per IPL & CDRL delivery. Analysis conducted in Power BI
Worked Closely with ME Engineers & Teamcenter developers in development for vehicle parts specification for customer deliverables (CDRLs) in SLICwave & Teamcenter technologies.
Point-of-contact for project CDRL delivery ensuring data was delivered adhering to all ITAR encryption requirements.
Assisted in ensuring all required parts were validated with correct NSN compliance.
Reviewed and configured Vendor Technical Data Packages. Page 3
Mar 2017 – Dec 2018: CONFIGURATION CONTROL CHANGE PROCESS ANALYST GENERAL DYNAMICS LAND SYSTEMS, STERLING HEIGHTS, MI (contract)
Responsible for initiating government combat vehicle change requests (SPR, CRs) in Teamcenter & government Windchill systems for tracking and reporting purposes.
Assisted in establishing & gathering data requirements for CDRL & SDRL delivery
Designed custom reports and interactive KPI 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 measures.
Implemented strategic reporting methods for linking Teamcenter real-time data at various EPLM phases to real-time data output from the USG Windchill system
Ensured 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%.
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: DATA SCIENTIST
FORD MOTOR COMPANY, DEARBORN MI (contract)
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 using Power BI.
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. Page 4
Jan 2015 – Jul 2015: INFORMATION & STRATEGY REPORTING MANAGER CITY OF DETROIT, DETROIT MI (contract)
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 Service Level Agreements and Propsals
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: BUSINESS FINANCIAL ANALYST
MACOMB FLOORING LLC, MACOMB MI (contract)
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: SR. DATA ANALYST
FORD MOTOR COMPANY, DEARBORN, MI (contract)
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 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.
Page 5
Jan 2005 – Mar 2013: BUSINESS INTELLIGENCE ANALYST (full-time) MSX INTERNATIONAL, WARREN, MI
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.
Designed and implemented Balanced Scorecard Reporting for Clients and Supplier Performance Reporting under STARS Methodology.
Collaborated directly with VMS/MSP New Business Development Team and potential new clients.
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
GPA: 3.76
UNIVERSITY OF DETROIT MERCY: JAN 1999 – AUG 2002
Bachelor of Science: Computer Information Systems
Elected Suma Cum Laude & Deans List
GPA: 3.6
Topic: Information Security
SIX SIGMA GREEN BELT TRAINING, VILLANOVA UNIVERSITY, 2012
Contact this candidate