Data Analyst Sales
Resume:
Peter Wojnowski
San Ramon, CA, ***** 925-***-**** ************@*****.***
Objective
A highly motivated Analyst with experience in interpreting, analyzing and reconciliation of data obtained from a variety of sources. Seeking a position within a Company where my professional experience, education and abilities would be an advantage to the growth of my employer and myself.
Work History
DATA ANALYST/PROGRAMMER - SOUTH BAY SOLUTIONS- FREMONT CA JAN 2018-MARCH 2018 (PROJECT ASSIGMENT)
Designed and built visually impactful dashboard application using Excel (VBA programming within Excel) and SQL that graphically displayed the flow of inputs and outputs out of hubs (shipping points),
Extracted, interpreted and analyzed data from very large databases to identify key metrics and transformed raw data into meaningful, actionable information.
End goal of application was to improve efficiency for tracking inventory and notify end user when supply of any specific component was low and needed to be ordered. Saved company approximately 200 man-hours annually.
DATA ANALYST/PROGRAMMER - SOUTH BAY SOLUTIONS- FREMONT CA OCT 2017- DEC 2017(PROJECT ASSIGMENT)
Developed application using Excel (VBA) that reformed the process of reporting incoming data for standard deviation reports (specifically notifying user when object being measured exceeded threshold).
Application provided a centralized hub as an alternative to individual reports that users could log into and make updates.
Retrieved historical reports and data from SAP to develop methodology for design of application.
Client reported 40% reduction in processing time.
DATA ANALYST/ PROGRAMMER PACIFIC GAS AND ELECTRIC COMPANY- SAN FRANCISCO CA JAN 2016 –APRIL 2017 (CONTRACT)
Developed applications using Visual Basic and Excel VBA to automate reporting. The new software saved Company approximately $100,000 yearly.
Used SQL queries and Excel (VBA) subroutines to retrieve utility usage and finance data sets from various sources including online database API’s, CSV files, and local/shared drive spreadsheets and SQL server databases.
Conducted data analysis using Excel (VBA) macros/subroutines which made use of complex Excel formulas and Algorithms including automated V-lookups.
Performed ad-hoc analytics for utility sustainability and finance departments which included forecasting, variance analysis.
DATA/FINANCE ANALYST PEPSICO – PLEASANTON CA JAN 2014-FEB 2015 (CONTRACT)
Analyzed daily reports, trends, and other pertinent data to address and resolve outstanding accrual issues using SQL.
Mined Data in SQL from SAP.
Worked with the sales & marketing teams by providing them with the necessary information and guidance for short & long-range forecasts for their Sales Planner.
Built SAP ERP event structures based on sales team planner databases.
BUSINESS ANALYST INTERN INMET – KIELCE, POLAND (3 SUMMER INTERNSHIPS) JUNE-AUG 2011, 12, 13
Helped carry out financial analysis at multiple levels including rate of return, depreciation, working capital, investments, budgeting, cost analysis, job analysis and financial and expense performance comparisons. Evaluated data, analyzed trends, and presented results to managers.
Maintained Salesforce reports.
Skills & Abilities
TECHNICAL SKILLSET HIGHLIGHTS
Power user of Microsoft Office Suite (Excel, Word, PowerPoint, Visio)
Data query/data management tools (Access, SQL, SAP and Business Objects)
Programing (Visual Basic, C#, Java)
• Data Modeling, Data Mining
• Excellent knowledge of how to use analytics to find conclusions based
SUPPLEMENTARY SKILLSET HIGHLIGHTS
Resourceful team player who excels at building trusting relationships with customers and colleagues
Strong leadership and interpersonal skills
Can manage multiple tasks, projects. Able to prioritize and meet tight deadlines
Education
BACHELORS DEGREE EARNED 2013 CALIFORNIA STATE UNIVERSITY CHICO
Major: Economics
Related coursework: Computer Science, International Business Law
Econ, Business, Finance and investors club leaders
Contact this candidate