Use This TemplateAndrew Smith
Professional Summary
Analytics experience: 6 Years
Domain: Ecommerce, Pharma, Retail & Automotive
Reporting skills: Tableau, Excel & QlikView
Programming skills: Advanced SQL, SAS, R, Microsoft Office & Advanced Excel
Programming skills: Advanced SQL, SAS, R, Microsoft Office & Advanced Excel
Statistical techniques: Linear Regression, Logistic Regression, Price elasticity, Market Basket Analysis, K-means cluster, time series analysis,Multi-level modeling techniques- Mixed Regression, Chaid, Customer Segmentation & Churn prevention program
Education
South Rohan University, Malcolmland, Nevada
Bachelor of Science, Bachelor of Engineering in Computer Science, Apr. 2012
The Johnston, South Juanside, Iowa
High School Diploma, Maths, Physics, Biology, Computer, Chemistry, Aug. 2008
Employment history
Senior BI Analyst (Level 5), Harber Inc. New Augustine, California
Apr. 2019 – Present
Roles & Responsibilities (In Kindle Content Team)
- Research, document, rate, or select alternatives for web architecture or technologies.
- Experience querying in advanced SQL on oracle and red shift database
- Created multiple dashboards in Tableau and Excel to track eBook metrics at different granularity
- Possess good understanding of data sets and data sources for eBooks and familiarity with data availability in red shift and oracle database.
- Experience in creating and scheduling extract, load & metric jobs on datanet, hulk & dryad
- Worked on requests from stakeholders like vendor managers, paid marketing, merchandising, product manages etc. around their data needs and provide suggestions on right metrics to look at.
- Built a consolidated Tableau report to track the performance of all deals (regular or ad hoc) on a daily, weekly and monthly basis. This dashboard helped in saving 100+ hours every month which was typically spent by the BI, Pricing, Merch and VM teams together to analyze the deal results. This dashboard is also enabling quick decision making for designing future deals.
- Built a complete one stop report to tracks all relevant metrics tracked by VMs. This has resulted in saving ~120 hours of collective VM and BI effort every month, which was spent in deep diving fluctuations in various selection and revenue metrics.
- Working on project deep thoughts, the intention of this project is to empower the IN Kindle Content team with self-consumable BI tools and resources, reduce the number of ad hoc data requests and streamline the current BI request process
- Built reporting structure to measure success of KU curation. Objective of curation was that the removed KU titles should drive an uplift in ALC while at the same time having a positive / neutral impact on key KU metric. Project required to create a reports to tracks KU health and ALC uplift over 4 phases of curation.
- Klite tracking - We carried out a series of analysis to help marketing, product and BD teams in determining the right selection, the right customer segments etc. to attract early adoption of Klite.
- Measured effectiveness of cashback offer for customers making payment through amazon pay
Senior Business Analyst, O'Connell Group. Federicoport, Minnesota
Oct. 2015 – Jul. 2016
Project 1, Client Office Depot(retail)
- A scalable solution for measuring promotional effectiveness using multi-level modeling techniques. EBW (End, Bulks & Wings) promotion play a very significant part in driving sales especially for retailers who mainly sale office and school supplies products. According to business, currently 20-25% sales in the stores are driven by EBW promotions
- The algorithm was developed using Multi level modeling techniques like Hierarchical Linear Model which captures the fixed and random effects of promotional and seasonal factors.
Project 2, Client HD Supply(retail): Price Elasticity Model for 15 SKU
- Developed a sustainable and repeatable analytical process to thoroughly understand the potential impact associated with pricing strategy changes in order to drive informed decisions
- For each SKU, Elasticity model was built with quantity sold as the dependent variable, and the following as the independent variables: Own price of the SKU, Holiday season and Macroeconomic factors
- Model Like Autoregressive model and Log-Linear Model were built for every SKU and one with best fit was later considered which identified SKUs that are most & least price elastic
Project 3, Client HD Supply (retail): Market Basket Analysis
- Market Basket Analysis for all SKU’s of ApplianceBU
- Apriori Algorithm was used to train and identify product baskets and product association rules
- Product affinity rules that satisfy both min support threshold and a min confidence were considered as strong affinities
Project 4, Client HD Supply(retail): Weather Impact Analysis
- Measuring Impact of weather on different product categories. Goal was to identify impact of weather on a customer’s likelihood to buy a particular product category.
- A mathematical algorithm was built followed by a Tableau report for marketing team to view the results for a given Season and temperature ranges which are the top selling products
Project 5, Client HD Supply(retail): Product Category Penetration
- Marketing team wanted to increase share of wallet among existing customers. One way to do this is to target emails to customers who buy “less than average” in a product category, compared with other similar customers, as defined by location and type.
- Bench mark SPU (sales per unit) for a product category was computed by considering the median of SPU among different customers. Customers who are buying less then benchmark SPU were found to be the targets
Project 6, Client Chrysler(Manufacturer): Forecasting Demand at Chrysler
- Developed a modelling framework to generate a statistical forecast for the US retail market at the BMCPOS-Business Center Level
- Different forecasting technique were applied to forecast the vehicles at BMCPOS level, Project success was measured by the reduction in forecast error and Reduction in Time/Effort to generate and maintain the forecast
Senior Business Analyst, Bernhard, Upton and Ortiz. Muellertown, Alabama
Nov. 2014 – Dec. 2014
Project 1, Sonic (Retail: Car Dealer): New car pricing Engine
- New Vehicle Pricing required scientific rigor as well as centralize pricing engine which would enable the business to make informed, accurate and consistent decisions while new vehicle pricing across the stores.
- Price Elasticity: This model accounts for the price sensitivity between ‘demand’ or ‘target number of vehicles’ to sell and the ‘price of vehicle’. The change in price with respect to variation in volume is determined based on various market factors including average market price.
Project 2, Sony (Retail: Market leader in video game industry): Game Sales forecasting
- Worked on forecasting software sales for different games launching on client’s console
- Forecasting was done for both existing games and the new games launching in the coming months
- Log linear model built for each genre and sales was considered as the dependent variable
- Forecasted results were used by the marketing team to decide on different strategies and spend for the marketing games
Business Analyst, Bergnaum, Simonis and Pacocha. North Miriam, Iowa
Oct. 2013 – Nov. 2013
[Client: Sanofi USA]:BI ETL & Reporting Tools Specialist
- Worked with one of the pharma client to provide ETL development and support activities for the enterprise data warehouse, In addition developed and supported BI reports by analyzing and understanding business user reporting needs
- ETL development and support tasks: Develop and maintained the scripts required to - extract, transform, clean, load and other necessary graphs like lookup and control tables graphs along with corresponding jobs
- BI Reporting development and support tasks: Experience in QlikView BI environment and QMC scheduling
Personal info
Phone:
(000) 000-0000
Email:
[email protected]
Address:
287 Custer Street, Hopewell, PA 00000
Skills
SAS
Advanced SQL
Tableau
Microsoft Office & Advanced Excel
Multi-level modeling techniques- Mixed Regression
R
QlikView
Linear Regression
Logistic Regression
Price Elasticity
Not in love with this template? Browse our full library of resume templates
Build your resume in 15 minutes
Use professional field-tested resume
templates that follow the exact resume rules employers look for.
Related Resumes & Cover Letters
More Job Descriptions for bi analyst Resumes
1
bi analyst
- Evaluated functional and technical business requirements. Transformed requirements into Tableau and Power BI solutions that efficiently enable expected application, reporting and analytic capabilities to support the business and strategic initiatives of the enterprise.
- Provided review and validation of existing dashboards and new solutions to ensure continuous accuracy and front-end ease-of-use. Developed report and development of Tableau and Power BI Dashboards.
- Contributed to the review of test plans, test cases to ensure all requirements are covered and documents are thorough.
- Designed documentation of the Tableau Dashboards designed.
- Designed efficient Tableau Dashboards through efficient use of Tableau and Power BI involving multiple data sets.
- Trained co-workers on Tableau and Power BI Desktops. Communicated across a diverse workforce to ensure work transitions effectively without interruption or incident.
- Involved in Customer engagement and Performance tuning of the project.
2
bi analyst (intern)
- Experience in development of extracting, transforming and loading(ETL), Maintain and support the enterprise data warehouse system and corresponding marts.
- Created SSIS Package using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2008/2008 R2.
- Conferring with data processing and project managers to obtain information on limitations and capabilities for data processing projects.
- Having Much experience in Vb.Net,MS-Access.
3
bi analyst
- Security Champion of the team which involved being up to date with ISO data security standards. Completed Cisco white belt and green belt security ninja training.
- Site Admin for 3 tableau site instances which involved tasks such as maintaining/upgrading/versioning workbooks, setting permissions, managing ownership, providing access to the users and adding them to the specific groups and scheduling instances for reports in Tableau Server.
- Demonstrated Complete Tableau Dashboards on Reader and Server for the end users.
- Interacted with business users on regular basis to know requirements and provide technical assistance regarding problems and help with the tool.
4
senior bi analyst (level 5)
- Experience querying in advanced SQL on oracle and red shift database
- Created multiple dashboards in Tableau and Excel to track eBook metrics at different granularity
- Possess good understanding of data sets and data sources for eBooks and familiarity with data availability in red shift and oracle database.
- Experience in creating and scheduling extract, load & metric jobs on datanet, hulk & dryad
- Worked on requests from stakeholders like vendor managers, paid marketing, merchandising, product manages etc. around their data needs and provide suggestions on right metrics to look at.
- Built a consolidated Tableau report to track the performance of all deals (regular or ad hoc) on a daily, weekly and monthly basis. This dashboard helped in saving 100+ hours every month which was typically spent by the BI, Pricing, Merch and VM teams together to analyze the deal results. This dashboard is also enabling quick decision making for designing future deals.
- Built a complete one stop report to tracks all relevant metrics tracked by VMs. This has resulted in saving ~120 hours of collective VM and BI effort every month, which was spent in deep diving fluctuations in various selection and revenue metrics.
5
bi analyst
- Working on project deep thoughts, the intention of this project is to empower the IN Kindle Content team with self-consumable BI tools and resources, reduce the number of ad hoc data requests and streamline the current BI request process
- Built reporting structure to measure success of KU curation. Objective of curation was that the removed KU titles should drive an uplift in ALC while at the same time having a positive / neutral impact on key KU metric. Project required to create a reports to tracks KU health and ALC uplift over 4 phases of curation.
- Klite tracking – We carried out a series of analysis to help marketing, product and BD teams in determining the right selection, the right customer segments etc. to attract early adoption of Klite.
- Measured effectiveness of cashback offer for customers making payment through amazon pay
Suggested Reading:
Related Articles
4 Ways a Career Test Can Jump-Start Your Future (and Help Your Resume)
If you’re looking for a fresh path or a new passion, a career test could help you find it. You can take these tests online, in the comfort of your...
Avoid These 3 Resume Mistakes at All Costs
Your resume is your first impression for a prospective employer. The way you present yourself in that little document can make or break you – it can clinch you an...
Resume Design Tips and Tricks
Creating a resume that stands out from the rest doesn’t have to be rocket science. With just a few tips and tricks, you can make your professional resume a shining...