Rodney Gottschalk Email & Phone Number

Tulsa, Ok, Us

Tulsa, Ok, Us

Tulsa, Ok, Us

Tulsa, Ok, Us

Washington, Dc, Us

Northbrook, Il, Us

- Developed SQL queries in Teradata and Microsoft SQL Server- Created Technical documents including Analytical Data Flows (ADFs) illustrating the movement of data from source systems to the final dashboard, Data Dictionary detailing information about the data being consumed, and various walkthrough guides for troubleshooting the scheduled data pulls- Designed a Tableau Dashboard for Capacity planning that provides an early warning for short term (28days) volume (case) flow exceptions at an item-level

Northbrook, Il, Us

• Kicked-off an engagement with the HR Analytics team within a Global Energy Corporation to create a workforce planning model that will allow the business to determine labor supply and demand needs across multiple markets based on company growth strategy• Developed and implemented the Engagement Framework for Client Interactions, Project Schedule, Data Ingestion Pipeline and Data Architecture for Workforce Scenario Model• Communicated with clients to understand their needs and gather product requirements for our prototype engagement in HR Analytics• Collected internal and external data for workforce analysis

Northbrook, Il, Us

• Managed an offshore team of 10 analysts while maintaining customer relationships with clients across 6 distinct business units within Supply Chain• Established end-to-end visibility into current data processes while capturing anddocumenting business logic used in queries• Coordinated the movement of data sources for 55 KPIs from disparate sources to a centralized data lake via various ETL processes• Built a robust anomaly detection framework for each KPI - that performs bothoutlier detection & root cause analysis to deliver insight for opportunities in the supply chain for Executive Leadership

Northbrook, Il, Us

• Presented recommendations and insights to senior executives on the customer data driven merchandising analytics solutions that enable continuous measurable improvement in the business decisions• Performed both advanced qualitative and quantitative analysis of high-volume data bases to identify developing trends, patterns and correlations• Designed logical data models to confirm source data, business logic, reference tables, and destination databases

Northbrook, Il, Us

• Worked with sales and marketing teams to help Mu Sigma acquire new accounts, grow existing accounts, and understand various industry trends• Enhanced skills over problem life cycle including data engineering, cleansing, modeling, and final presentations of results• Increased working knowledge of object-oriented programming and scripting• Developed project management skills through SCRUM/AGILE methodology• Researched previous business problems to understand their solutions and the different factors involved• Completed an intensive technical training program in Bangalore, India and honed skills in R, SQL, Python, Hadoop, Statistics, and MS Excel

Oklahoma City, Oklahoma, Us

• Assisted both Accounts Receivable and Accounts Payable in standardizing both the invoicing and billing processes across U.S. locations• Assisted Quality control department in establishing API accreditation• Improved inventory monitoring accuracy by 18% by developing a real-time dashboard for visualizing inventory capacity• Designed, developed and supported new structures for business intelligence to improve decision-making across the finance, planning, operations and marketing teams

Norman, Oklahoma, Us

• Responsible for academic engagement, community building and working as a member of a collaborative network to ensure that incoming Freshman successfully integrated into the college community.• Developed, marketed, and led student centered hall programs to promote social, education, diversity, health, emotional, understanding and growth.• Assisted in the selection, evaluation, and training of incoming RA’s.• Communicated, corresponded & collaborated with on and off-campus offices such as counseling, student activities, campus security, Planned Parenthood, maintenance, etc.• Implemented and enforced all University and Housing policies.

Bentonville, Arkansas, Us

• Ensured customer satisfaction by greeting and answering their questions.• Assisted fellow associates as needed throughout the store.• Demonstrated an ability to communicate effectively with management.• Prepared and planned for upcoming events that impacted the Hardware, Home goods, Furniture, and Craft departments in the Norman store. • Maintained product inventory levels by performing stocking and zoning activities.

Master'S Degree, City/Urban, Community And Regional Planning

Bachelors Of Science, Industrial And Systems Engineering

Minor, English Writing