SUMMARY:

Self - driven individual looking to help a company with my passion for turning data into knowledge. Strong experience and knowledge with SSAS Tabular, Power BI, Microstrategy, and PowerPivot.

RELEVANT IT SKILLS:

• SSAS Tabular Microstrategy Reporting Services
• SQL Table Normalization
• Data Modeling Dax Formulas Power Pivot, Power Query, Power view Microsoft Power BI SAP (Certified by SAP Business Suite) Proficient in Peachtree Accounting Access, PowerPoint, Word Extremely Strong Excel Skills

WORK EXPERIENCE:

Business Analyst - Strategic Analytics

Confidential

Responsibilities:

• Created a self-service business intelligence solution that greatly enhanced our company’s analytical capabilities around employees’ fringe benefits.
• Automated the ETL (extract, transform, load) of over 40 unique data sources into a single tabular data model
• Used Power BI Pro service to create self-service reporting in:
• Excel
• Web-based Power BI dashboards
• Power BI Mobile App reports
• Greatly reduced the ad hoc report development time of our team, allowing us to ramp up requests without taking on additional employees
• Ad hoc report development time dropped from 2-4 hours to 5 minutes in order to produce a report output.
• Database dramatically increased the visibility into our numbers, which led to changes in how we calculate our fringe costs and improved our accuracy.
• Lead the development of the Fringe Incentive Program
• Led the creation of an incentive program that distributes excess corporate profit to sectors when they contract fringe rates with clients higher than their true costs.
• The incentive program uses newly created KPI’s to measure a sectors performance and determines how much incentive money they have earned from corporate.
• Created web-based dashboard reporting on these KPI’s and distributed directly to sector CFO’s and their direct reports to help steer their behavior towards positive decision making.

Business Intelligence Developer

Confidential

Responsibilities:

• Developed on SSAS Tabular and Microstrategy Reporting Services
• Promoted 4 hay grade levels in one promotion for contributions at Confidential
• Helped ease the transition to SSAS by training my coworkers on Tabular Data modeling, Dynamic Security, Table Normalizing, DAX formulas and others.
• Built our companies very first enterprise level tabular cube that provided analytics on transactions through our point of sales systems using power bi as the front end.
• Used the cube I created to find a major data outlier that helped us catch employees committing fraud and fixing the loophole in our system.

Purchasing Analyst

Confidential

Responsibilities:

• Hand picked by senior management to join the “Money Driver” team in order to better utilize my skillset for the company.
• Trained analysts across the company on the Power BI toolset and in Excel.
• Consistently exceeded expectations to levels management previously did not believe were possible.
• Often uncovered major value by data mining with my improved tools. Multiple instances of finding mistakes or opportunities leading to

Category Development Specialist

Confidential

Responsibilities:

• Completed on my own time a BI project that greatly influenced the company’s data strategy
• The project automated roughly half my role so I could pick up other tasks
• Managed the monthly pricing process for all meat and commodity items.
• Completed most of the teams ad hoc reporting and analysis, managed the price benchmarking tool, and led key projects.
• Opportunity analysis for the CEO’s 10% Rebate initiative, and presented the results to the Category Development VP’s.
• Created reports and visuals that the CEO and VP’s presented to important clients.
• Developed an interactive visual of the Income by Supplier report, which was used across the department
• Opportunity Buy process improvement- streamlined a very time sensitive item matching and financial process, cutting the process from 2-3 days to 1 day by using power query, power pivot and excel formulas
• Revolutionized the way Confidential does reporting by introducing self-service BI.
• Pitched the use of tools such as Excel online, Power pivot, Power Query, Power view, and Microsoft Power BI.
• Despite my proposal being rejected, worked on learning the skillset required to use these tools post work hours and developed an advanced skillset with each of them.
• After developing and testing over 20 prototypes with varying data models, built a fully functional Business Intelligence Solution using just excel, Power Query and Powerpivot.
• This solution contained 3 years of all the company’s data in a star schema in powerpivot, rolled up monthly and containing over 200 million rows.
• The reports sliced in seconds, and the data integrity was spot on.
• Took smaller pilots all the way to a cloud solution and created a dashboard on a mobile app.
• Presented the prototypes to the VP’s and Director of finance and now the toolset is being used across the company and influenced the IT department of Confidential Group to add SSAS to their reporting tools.
• Company data went from taking hours to access to seconds.
• Greatly reduced the time to create a custom report, taking the time from several hours to 3-15 minutes.
• Allowed analyst to exceed the excel constraint of a million rows, permitting big Data analysis and eliminating the need to annualize our numbers.
• Made hardware and software recommendations that significantly reduced the company wide problem of slow excel files
• Brought greatly improved visibility into our numbers and provided a tool that will allow for data mining capabilities not feasible beforehand.