June Joan Kepner

June Joan Kepner, MSc - •-• Egg Harbor Township, NJ • Linkedin URL Procurement | Data analyst Offering strategic insights and innovative solutions that drive streamlined operations. As a data analyst with a strong background in procurement, bookkeeping, and accounting, I excel at transforming raw data into actionable insights that drive strategic decision-making. With extensive experience in procurement management, I bring a unique ability to analyze supply chain and purchasing data to optimize processes and improve business performance. My passion for business intelligence allows me to leverage data effectively, helping organizations make informed decisions, enhance operational efficiency, and achieve their strategic goals. Pricing Analyst Reporting Skills Retail Buying Inventory Replenishment Data-Driven Decision Making Data Visualization Process Improvements Accounting Operations Financial Accounting/Financial Analysis Budgeting Forecasting Problem Solving/Critical Thinking Professional Experience Business Analyst / Bookkeeping with Payroll Financial Analysis: Conduct in-depth financial analysis to support decision-making processes, identify trends, and provide actionable insights to improve business performance. Bookkeeping: Maintain accurate financial records, including managing accounts payable/receivable, bank reconciliations, and financial reporting. Ensure all transactions are properly recorded and categorized. Budgeting and Forecasting: Assist in preparing budgets and financial forecasts, monitoring actual performance against projections, and providing variance analysis. Reporting: Prepare and present detailed financial reports to management, offering insights into the company's financial health and payroll expenses. Contract Specialist for the FAA (Federal Aviation Administration) Supporting a wide range of functions within the acquisition process, adhering to the Acquisition Management System (AMS) and agency policies. Procurement Requests: Conducted in-depth analysis of Procurement Requests (PR) and Statement of Works (SOW). Provided crucial data to Contracting Officers (COs) for contract decisions. Pre-Award Document Preparation: Analyzed quotes, offers, and proposals. Recommended the lowest-priced offeror and assessed offeror responsiveness, responsibility, and past performance. Proposal/Quote Review: Prepared documents for review and signature by COs. Solicited quotes from contractors through various means. Award Documentation: Compiled contract documents for CO approval, established contracts, and completed required procurement reports. Post-Award Actions: Managed administrative contract actions and modifications. Reviewed invoices and monitored contract performance. Contract Closeout: Prepared contract files for closeout, determined audit or de-obligation requirements, and addressed other closeout requirements. Business Analyst / Data Analyst Consolidated data from multiple sources to create analytical packages. Developed and maintained analytical packages for clients, demonstrating strong analytical and critical thinking skills. TACKLE DIRECT ▪ Egg Harbor Township, NJ ▪ June 2017 to September 2021 Purchasing Associate / Accounts Payable Associate Drove procurement efforts for a diverse range of products and merchandise. Conducted in-depth analysis of product pricing structures, managed accounts payable, and optimized revenue. Streamlined the Accounts Payable department. FANTASEA RESORTS ▪ Atlantic City, NJ ▪ December 2014 to October 2015 Accounts Payable Administrator Oversaw Accounts Payable operations for two owned hotels. Collaborated with the Senior Accountant to prepare reports for senior management's review. Took charge of document management and data entry processes. Data Analyst /Buyer Extracted SAP data and created templates for sales, budgeting, and inventory purposes. Tracked new store openings and conducted root-cause analysis. Achieved a 50% increase in category sales. Negotiated with suppliers and implemented favorable pricing agreements, resulting in cost savings and increased profit margins. Conducted market research and analysis to stay updated on industry trends, emerging products, and competitive pricing, allowing for more informed and strategic procurement decisions. Education Harvard Business School ▪ Business Fundamental Course – Credential of Readiness (Business Analytics, Economics for Managers and Financial Accounting) Stockton University ▪ master’s degree – Data Science & Strategic Analytics New Era University ▪ master’s degree – Secondary Education National College of Business and Arts ▪ bachelor’s degree – Business Administration / Computer Management Technology Profile ▪ Microsoft Dynamics 365 | Quickbooks Online and Desktop | Power BI| R | Microsoft Suite