6fddf189-dc37-415e-8ea3-3784f926429c

Andrew 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
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

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








bi analyst

  • Contributed significantly to the Value Stream analysis on the entire product manufacturing process. 
  • Coordinated implementation of Lean methodology in the manufacturing department. 
  • Prepared detailed workflow charts and diagrams of existing and suggested operations to forecast output and results. 
  • Prepared business process flow before and after any major process change. 
  • Trained team members on quality control methodologies such as DMAIC (Define Measure Analyze Improve Control), Fish Bone Analysis, etc.
  • Regularly consulted with managerial, engineering, and technical personnel to clarify project intent, identify problems, and suggest changes.
  • Performed revision, repair, or expansion of existing programs to increase operating efficiency or adapt to new requirements.

bi analyst

  • Developing BI solutions
  • Gathering requirements
  • Data Mart modeling
  • KPI and measure specification
  • Developing and documenting ETL process
  • Helping and supporting executives to analyze information
  • Supervising and training JR Analysts 

bi analyst / software developer

  • Developed software to handle specific jobs such as tracking inventory, order management, data capturing, controlling equipment such as bio-metric systems, bar code readers. 
  • Developed in house software depending on business requirements using C, C#,VB.net, Java, SQL database. 
  • Helped reduce Cost of delivery by 5% by implementing robust data capturing tools.
  • Reduced Man hours by 15% by automating Bill of Material calculation.
  • Automated repetitive organizational tasks using MS Excel and MS Access VBA. 
  • Used the analyzed data to visualize KPIs, Forecasts, Opportunities, Cost of Delivery, Return of Investment(ROI), etc using Power BI, Tableau, MS Access, MS Excel, Power Pivot,  Power query, and SSRS.
  • Studied and Analyzed the effects and impacts of Lean management. 

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

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.

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. 

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. 

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.