Data Analytics Lead with 20+ Years Experience

JERI M. HALE

**** ********* *** - **, *******, IL 60631* 312-***-**** * *************@*******.***

SUMMARY

High energy Business and Data analyst offering 20+ years of experience providing valuable technical solutions that meet business objectives. Analytical and detail oriented with the proven ability to communicate with both technical professionals and end users to identify and translate business requirements into technical specifications. Specialty in Data Integration and empowering the business to make data driven decisions.

SKILLS

●Data modeling, analysis, and mapping (STM)

●Technical and Business analysis

●Problem solving

●Test case scenarios

●SQL, Python, Databricks, AWS, Snowflake, Visio, Jira, Tableau

●Requirements gathering

●Agile methodology

●User stories

●Technical and Business specifications and documentation

●Liaison between Business and Technical teams

EMPLOYMENT HISTORY

Senior Data Analyst – Supply Chain Analytics, 11/2022 to 9/2025

Nike, remote

Collaborated across two agile squads to deliver end-to-end data analysis solutions, including business requirements gathering, creating technical requirements, source-to-target mappings (STM), quality assurance (QA), documentation, and stakeholder engagement. Hands on data analysis using SQL and Databricks. Work with engineers analyzing Python and Pyspark scripts for understanding and debugging.

Open Demand Data

oLed analysis of multi-grain datasets to support business understanding and usage of complex demand signals.

oConducted grain analysis to successfully integrate a new grain into the existing data product, enhancing granularity and usability.

Order Booking & Demand Fulfillment

oDeveloped a unified data product to serve as a single source of truth for global order booking and demand fulfillment metrics.

oIntegrated and harmonized data from multiple systems, including SAP 3 and SAPS/4 HANA, enabling comprehensive visibility across regions and business units.

Senior Business Systems Analyst, 12/2020 to 11/2022

AP Professionals assigned at Nike, remote

As a Sr. Business Analyst/Product Owner on the Planning Data Foundation team, the responsibilities include identifying business requirements for Sales, Pricing and Promotions data. Team player who works closely with product managers and developers to translate business requirements into technical specifications, write user stories and acceptance criteria, create STM (source to target mappings), perform data profiling, manage JIRA board, perform QA, creates data and process flow diagrams and other functional/technical documentation. Participates in/facilitates daily standups, grooming, sprint planning, retrospectives.

Product Owner, Data Analytics, 03/2019 to 02/2020

Clearcover, Chicago Il

As the Product Owner for the Data Warehouse/BI team, the responsibilities include identifying business requirements for KPIs around insurance claims (ClaimPilot), policy characteristics (OneInc), customer quotes, website clicks, loss ratios, premiums. Translate business needs into technical specifications, write user stories and acceptance criteria, manage JIRA board, perform QA, liaison between business and development teams, manage 3rd party integrations and relationships (Lexis/Nexis, Verisk, IL DMV), monitor internal requests via Spoke and support business teams for data and Tableau related assistance. Data sources include relational databases, API data (JSON, xml). Participate in daily standups, grooming, sprint planning, retrospectives.

Technical Business/Data Analyst, 10/2017 to 08/2018

Signature Consulting assigned at Bank Of America, Chicago Il

Gather business requirements, translate to technical specifications, data analysis (write queries), QA, liaison between business and development teams, functional and technical documentation (dashboards/Tableau and data integrations/Python). Work on both reporting and data integration teams within the Information Security/Identity Access Management function.

Business Systems Analyst -Business Intelligence, 08/2012 to 10/2016

Redbox, Oakbrook Terrace, Illinois

Work closely with the business to understand business process and solidify requirements by determining the problems and questions on hand; Build trust and relationships with business users to ensure open lines of communication and transparency; data analysis on multiple source systems in order to determine best design and solutions; write technical specifications, user stories and scenarios (TFS/ADO) for developers and QA; design new data warehouse structures such as fact and dimension tables, cubes, reports; create system documentation including data flow diagrams, subject matter ERDs using Erwin and Visio, source to target mappings, end user documents, data dictionaries; work closely with product and project managers to coordinate priorities and deployments; work closely with 3rd party vendors to design and coordinate data integrations (Exact Target, Vibes, Experian, APT). Projects include Marketing, Customer Service, Finance working in Agile environment. Additionally write requirements for APIs which pass data between website, 3rd party and other systems.

Lead Business Intelligence Analyst, 11/2006 to 7/2012

Broward College, Ft Lauderdale, Florida

Work closely with end users to understand business process, gather requirements, liason between business and technical personnel, coordinate meetings and UAT, maintain project plan, train users on documentation and end products. Also responsible for writing specifications, building, testing, implementing and documenting ETL processes, OLAP cubes and reports which make up Business Intelligence solutions. Support all reporting needs in and outside of the college by producing meaningful reports that answer end-user questions (both ad-hoc and periodic). Large projects include Enrollment Management, Student Applicant Tracking and Fee/Revenue Analysis.

Senior Systems Analyst, 6/2004 - 12/2005

ConAgra Foods, Schaumburg, Illinois

Responsible for technical specifications, testing and documentation of ETL system. The system is a combination of Unix scripts and Informatica mappings which transfer and translate data between various systems including Warehouse Management systems (Red Prairie), Transportation Management System (Manugistics) and Order Management system (SAP/R3).

Senior Business Analyst/Team Lead, 7/1995 – 8/2003

SPSS, Inc., Chicago, Illinois

Senior member of a team assigned to a full life cycle project to implement Oracle Applications (modules include Order Entry, Inventory, Service, AP, AR, GL) to all offices worldwide. Responsibilities include requirement analysis, translate user requirements to technical specifications, data conversion source to target system mappings, interface (between ERP & SFA) design and mappings, code review, and testing of Oracle Order Entry, Inventory and Service modules in addition to customizations and interfaces to Scopus, Oracle functional setups, writing SQL queries and updates to analyze and clean data, supporting O/E and Customer Service users on Oracle apps.

EDUCATION

Bachelor of Science: Computer Science

Northeastern Illinois University, Chicago Il

Bachelor of Science: Mathematics

Northern Illinois University, DeKalb Il

Contact this candidate