Business Analyst

Kellie Dambroso

***** * **** ** *, Broken Arrow OK 74014 * 918-***-**** * *********@*******.***

PROFILE

Detailed Business Analyst with a history of working in the oil and gas, information technology, and services industries. Technically-adept with advanced knowledge of MS Office Suite and experience creating Excel databases, macros, HTML, CSS, PostgreSQL, and JavaScript.

SKILLS

·SAP

·Microsoft Excel

·VBScript/Macros

·SQL

·MongoDB

·HTML5

·Javascript

·React

·CSS

·Detailed and Organized

·Microsoft Office Suite

·Problem Solving

·Six Sigma Yellow Belt

·IBM Agile Training

PROFESSIONAL EXPERIENCE

HOLLYFRONTIER, Tulsa, OK

Distribution Coordinator, Jun 2019 – Aug 2020

Developed and continuously improved reporting of inventory, billing, and rail car fleets/trucking schedules utilizing Excel. Assisted with handling crisis management situations involving conflicts arising out of short-term or long-term refinery/logistical problems causing product outages, customer complaints, human error etc., escalating as needed. Maintained good working relationships with transportation carriers, pipeline customers, exchange partners, suppliers and/or third party pipeline personnel and worked with blenders, traders and schedulers to maximize product movements and values for HollyFrontier.

-Automated coversheet creation and loaded data directly into SAP, reducing a daily process from 3 hours down to 5 minutes.

-Created Forecast Sales report unitizing macros and pivot table.

-Implemented daily process to ensure proper use and rotation of railcars by creating a monitoring report with excel and SAP.

HILTI VIA MANPOWER, Tulsa, OK

Support Analyst, Dec 2018 – Feb 2019

3 month Project. Created/maintained automation, provided input process improvements, and assisted the operation team in the Credit And Collection Department. Project included working with SAP, Macros, and Microsoft Access.

-Created Scheduler calendar for management use to ensure proper coverage at all times.

-Created macro to open all collection agent phone logs and summarize necessary data for management. Cut time spent in process from two hours to two minutes.

IBM, Tulsa, OK

Business Analyst, May 2012 – Aug 2018

Worked on Marathon Oil Company account handling escalated or complex client issues. Coordinated with field personnel/purchasers/marketers to receive the necessary data to complete allocations including review of run tickets, well tests, downtime, injection and meter statements, maximizing accuracy.

- Created excel files and formulas for processing, formatting, and uploading data that streamlined processes and increased efficiency by 50%. Included working with macros and xml.

-Developed processes to reduce the A/R, and more effectively reconcile purchaser statements dramatically streamlining the process for my department.

-Created the desk documentation and training materials for department.

JCPENNEY, Tulsa, OK

Office Specialist, October 2007 – May 2012

Oversaw office functions of both Woodland Hills Mall and the Home Store JCP, including counting down vaults and cash tills, and preparing daily bank deposits. Helped store managers in any capacity needed. Trained new hire office associates for regional area.

- Utilized PeopleSoft and jTime for creating, updating, and maintaining employee records, supporting over 200 employees with speed and accuracy.

- Compiled, reconciled, and prepared payroll information and reports, ensuring all employees and managers were paid appropriately and on time.

- Guided employees through retirement process and answered benefits questions.

EDUCATION

NORTHEASTERN STATE UNIVERSITY, Broken Arrow, OK

Bachelor of Business Administration (BBA) in Accounting and Information Systems, Dec 2011

·Dean’s Honor Roll

·Delta Mu Delta

GENERAL ASSEMBLY, Remote

Web Development Immersive, Aug 2018

Full Stack Web Development immersive program certification

Contact this candidate