June Joan Kepner

JUNE J OAN KEPNER - •-• Egg Harbor Township, NJ BUSINESS ANALYST | D ATA ANALYST Offering strategic insights, methodologies and innovative solutions that drive streamlined operations. Well-qualified professional and bold analytical thinker in the Business Analyst sector. Career track includes contributions to high-performance work cultures with a demonstrated ability to partner throughout all levels of the organization, handling diverse issues and concerns until reconciliation, collaborating with multifaceted teams, and executing complex initiatives that produce long-term benefits for the entire organization. Proven and demonstrated knowledge of critical thinking, process improvements, and data analysis. Pricing Analyst Complex Negotiations Database / Reporting Skills Business Best Practices Retail Buying Product Merchandising Inventory Replenishment Process Improvements Process and Procedure Development Accounting Operations “June has excelled at learning the duties of the A/P administrator. She is a person we can count on to help out in all areas.” Performance Review PROFESSIONAL EXPERIENCE DATAWIZE LLC ▪ Egg Harbor Township, NJ ▪ January 2021 to Present Founder/Data Analyst Data Analysis • Helped small and medium businesses to improve its operations through data analysis. • Consolidated, cleaned, and organized data and identify problems to formulate solutions. • Transformed data into presentation using power BI, Microsoft Excel, and interactive dashboard. • Created sales report that provide concise interpretations of sales data for analysis to make a sound business decision, and for the business to see if they are on track with their target. Procurement and Logistic Management • Created Purchase Orders base on the company’s inventory, sales history, customer orders and back orders. • Monitored and communicated with factory regarding shipment of purchase orders, lead time to ensure that shipping requirements are met. • Managed e-commerce account of the clients like Wayfair, Amazon, Walmart, Target, Overstock, and other e-commerce portal, monitored orders, back orders, and match it to inventories in order to fulfill all orders. • Managed SKUs (discontinued non selling SKUs created a bundled items to help non-moving items) and created New SKUs. Accounts Payable Management • Reconciled operating accounts, bank accounts, credit cards and expenses. • Verified expense report, analyzed, and monitored expenses. • Maintained records of all vendor payments. Standard Operating Procedures (SOP) • Documented procedures and processes of a company in a simple, clear but detailed instructions that all employees can follow to complete a task. June Joan Kepner LEONARD-NEWMAN UNLIMITED ▪ Galloway, NJ ▪April 2022 to Present Contract Specialist for the FAA (Federal Aviation Administration) Support a wide variety of functions encompassing the entire spectrum of the acquisition process in accordance with the Acquisition Management System (AMS) and any other agency or office developed policies and procedures. Exercise a high degree of initiative and independent judgment in accomplishing the assigned duties. ➢ Procurement Requests • Analyzed and reviewed (PR) Procurement Requests, and (SOW) Statement of Works. • Provided information to enable the warranted (CO) Contracting Officer to determine proper contract approach. ➢ Pre-Award Document Preparation • Performed analysis of quotes, offers and proposals received. • Reviewed all received quotes, determined the lowest price offeror and provided recommendation for award to the CO. • Gathered additional pricing information, provided information on offeror responsiveness, and responsibility, and past performance. • Requested quotes from contractor via email, letter or other alternative means as dictated by policy. ➢ Proposal/Quote Review • Prepared and developed for CO’s review and signature, the solicitated documents, such as Screening Information Requests (SIR’s), requested proposals, offers and quotes. • Requested quotes from contractor via email, letter or other alternative means as dictated by policy. ➢ Award Documentation • Prepared final contract documents and all supporting documentation relating to award decision for award by a CO. • Created the contract, delivery order or purchase order folder, folder checklist, price and cost memorandums, spreadsheets and other documents required by regulation for procurement award. • Created contracts, purchase orders, and delivery order in PRISM • Completed the Federal Procurement Data System report as required. • After award by the CO, distributed all contracts and orders to the required points of contacts. ➢ Post-Award Actions • Prepared documents for all administrative contract actions • Created modifications in PRISM for CO award. • Completed all required file documentation to include memorandums for file, spreadsheets, letters, and emails in support of modifications for CO signature. ➢ Contract Administration • Assisted in Contract Administration; review invoices, retrieve invoice approval, and forward to the CO for invoice acceptance. • Monitored contract delivery delinquencies and performance discrepancies and recommended actions to implement resolution. • Documented all findings or factors causing delivery delay or unsatisfactory performance; prepare responses to all contractor inquires. ➢ Contract Closeout June Joan Kepner • Prepared contract files for closeout including reviewing files for incomplete deliveries, determined requirements for close out audit or de-obligation, initiating actions for post completion inquiries, completing Government furnished property records, completing contract closeout checklist in Prism, and other closeout requirements required by the AMS and office policy. FBK/CFO ON DEMAND ▪ Linwood, NJ ▪September 2021 to December 2021 Business Analyst / Data Analyst Consolidated data from various sources (accounting system, point of sales, ERP, EDI) to develop analytical packages. Financial models, benchmarks, and KPI’s. Created and maintained analytical packages for clients on a timely basis. Used business data to create meaningful Key Performance Indicators and transformed into presentations that helped businesses grow. • Supported business consultants to provide analytics and forecasts to business clients. • Strong analytical and critical thinking skills; with the ability to clean and organize data and identify patterns and problems to formulate solutions. • Monitored business performance by using data to create meaningful key performance indicators that will help • businesses grow. • Used business data to give businesses insight into what is going on within their company for them to make sound business decisions. TACKLE DIRECT ▪ Egg Harbor Township, NJ ▪ June 2017 to September 2021 Purchasing Associate / Accounts Payable Associate Collaborates with a talented team to drive purchasing for a wide variety of products and merchandise. Utilize proper negotiation tactics to ensure best pricing, working with suppliers to cement sale of items. Analyze pricing structure of products keeping a keen focus on changes in pricing to ensure best practices and positive revenue. Oversee all companyrelated accounts payable, receivable and statements as needed. Effectively source new items and suppliers ensuring best pricing as needed. Determine comprehensive promotions to boost sales for overstock items. Successfully calculate margin and retail pricing based on supplier costs. Oversee comprehensive inventory management through re-ordering saleable items and freezing purchase creation of unsold items. Track and monitor deliveries from the distribution warehouse to the store as needed. • Brought a detail-oriented perspective to the purchasing department through comparing invoices and ensuring most up to date pricing was being used on a regular basis. • Created and implemented a new process for the AP department to ensure streamlined operations. FANTASEA RESORTS ▪ Atlantic City, NJ ▪ December 2014 to October 2015 Accounts Payable Administrator Successfully oversaw comprehensive account payable operations for two of three owned hotels including reconciling invoices. Created high level reports for unoccupied rooms to keep communications fluid and relevant. Collaborated with the Senior Accountant to create reports for senior management to review and approve as needed. Drove printing of rush checks for high profile contractors and suppliers as needed. Ensured proper preparation of daily bank deposits and data entry for ledger reports. Managed comprehensive document management in accordance with company processes, policies, and industry standard accounting standards. June Joan Kepner  Successfully processed 1M+ checks for one supplier with approval from Assistant Controller and Controller. SM FOOD RETAIL GROUP ▪ PHILIPPINES ▪ June 2006 to October 2012 Data Analyst Utilized deft analytical skills to gather and extract SAP data, create comprehensive templates for sales, budgeting, and inventories as needed. Tracked and monitored new store openings including price proposal financial reports, and other pertinent information. Managed complex and sensitive documents including financial reports, inventory documents, and price proposals. Drove root-cause analysis utilizing SAP raw data, compiling data, and investigating when sales were down. Ensured troubleshooting of issues and concerns cementing variance reports as needed.    oversaw comprehensive store setup including merchandise layout, design, facilities, and inventories for multiple 20K+ sq. ft operations. Increased sales of categories by 50% through utilizing sales tactics and modified consignment payment terms utilized in the Philippines. Began as a Purchasing Clerk and through due diligence and strong work ethic was promoted to Assistant to Vice President of Dry Goods Stores. E D U C A T I ON 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 LICENSED ▪ Professional Teacher – Professional Regulation Commission, Philippines TECHNOLOGY PROFILE ▪ Microsoft Dynamics 365 | Quickbooks | Access Database | Power BI| R | SQL | Microsoft Suite I Asana |Slack