Senior Analyst - Digital
Smyrna, Ga, Us
- Managed a team of programmers building/maintaining a multi-retailer web scraping program- Wrote multiple custom ETL solutions (primarily python / sql) to replace human processes of logging into multiple big box retailer web portals, exporting files, processing, then loading into a sql database.- Forecasting Client Inventory Needs - Developed a model that quantified full supply chain at B2B consumer to predict when they would place additional orders. Solution was built to be quickly switched between clients defaulting to a lag analysis driven model, but allowing inputs for customization and taking into account likely business changes.- Pre-Post net of control - Determined Control stores to provided test stores by looking at how demographics correlated to sales, then doing stratified sampling (by sales) aiming at those same demographics while attempting to stay close geographically (end user preference)- Consumer buyer study - Wrote, executed, and analyzed a consumer survey on tile (flooring, backsplashes, etc), producing an extensive report on consumer preferences, buying habits, basket data, etc.- Tying together stores geographically close together - Used lat long to determine straight line distance between retail locations, tied together stores within a max threshold distance to determine possible opportunities to make changes in stocked product lines.- Managed/Maintained a shopify webstore and Google Adwords account for one of our clients.- Optimized long running stored procedures in SQL- Implemented a greater degree of normalization in SQL Database- Made improvements to BI Middle layer to improve processing time