Jacob Fox Email & Phone Number

Providence, Ri, Us

Johnston, Rhode Island, United States

● Enhanced an existing manual MS Access process using VBA/Macro/Batch scripts, achieving a swift automation win that led to a weekly time saving of 15 hours and accelerated report deliveries by 3 days ahead of SLA● Deciphered and streamlined multiple decade-old, undocumented reporting processes. Transitioned from manual MS Access and Excel workflows to SQL jobs. This overhaul enhanced accuracy and reliability, which resulted in a weekly savings of 20 hours● Spearheaded a documentation initiative of all business processes and rules, ensuring clarity and understanding for business partners● Promoted to the liaison between my “Business Team” and the technology “Shared Services” team. Creating synergy and increased productivity of all data processing and reporting needs. Tripled the number of successfully completed data tickets compared to last year● Recognized as the primary expert on Wealth data sources within the team● Pinpointed redundancy in team members accessing similar data from an external source. Consolidated and automated the report download, ingestion, and cleanup, resulting in a centralized data lake. Ensured cross-team data consistency, accuracy, and time savings ● Conducted training sessions on MS Excel, SQL, MS Teams, and Jira, boosting departmental data proficiency

Cumberland, Rhode Island, United States

-Impacted over $300M in yearly sales through analyzing, planning, and executing the 4Ps (Product, Place, Promotion, Price) on Bayer products within Analgesics, Dermatology, Cough Cold, and Allergy categories at CVS through collaboration with CVS category managers and internal teams including field sales, ecommerce, analytics, commercial sales strategy, marketing, and supply-Streamlined and optimized standard sales reports with dynamic data, new metrics, and automation for quicker and more insightful report updates, which yielded 10 hours of weekly work saved from the previous report owner-Analyzed sales and market data using advanced Excel and Tableau to create and present data stories to management and CVS buyers for use in negotiations, resulting in 50% increased product distribution and increased incremental sales-Identified and closed eCommerce gaps through product assortment, sales channel opportunities, and updated product pages -Enlisted as the subject matter expert in CVS’s sales data with systems including Precima, ExtraCare, Unify IRI, and Numerator- Investigated weather and sales data and found a correlation of weather effects on arthritis users. Presented findings to CVS for use as CVS’s first CMX online media targeting campaign- Experimented with Tableau to create automated charting and reporting. Developed database to bypass system limitations

Greater New York City Area

- Junior Project Manager for coordination of website and mobile application development- Project Manager for a security risk upgrade project of 180 websites for completion within a very tight timeframe- Analyzed and graphically summarized website data for over 600 Consumer Health websites for a global CMS migration project- Technical and intake lead of Salesforce Marketing Cloud email marketing campaigns. HTML development and email journey setup/reporting. Management of development team and offshore vendors. Coordination with stakeholders. Improved delivery SLA by 3 weeks through training and streamlining the process- Jira Cloud and SharePoint administrator. Ran workshops with stakeholders to gather requirements and needs for a new Jira Cloud system. Documented and configured the system for use by all of Bayer - Gathered requirements and developed enhancements and support for multiple internal ASP.NET applications- Collaborated with global colleagues as the US representative to learn and map each country’s tools and processes for increased harmonization on a global team level and process improvement through gap identification

Greater Pittsburgh Area

- Headed site shutdown collection project ensuring 105 users’ data was collected in the most efficient manner possible- Consult with vendor to set-up, troubleshoot, test, and document collection software for use in Bayer environment- Supported infrastructure environment to ensure collection scripts and client facing products are operable at optimal performance- On-boarded and trained 2 new team members- Utilized Treesize, advanced Excel, and Scripts to categorize abandoned legacy data through legally defensible delete process, ultimately resulting in cleanup of 10TB of data. Documentation of process for future cleanup projects - Enhance documentation and processes of teams’ daily operating tasks

Greater Pittsburgh Area

1st Rotation – IT Legal Services, Pittsburgh, PA - Manage urgent service request tickets. Collaborate with desktop techs, outside vendors, IT teams, users, and paralegals - Consult and train paralegals with Microsoft Excel for improved and streamlined report generation - Overhauled and standardized Secure Hard Drive (SHD) formatting and inventory process - Improved meeting efficiency through use of SharePoint site creation2nd Rotation – IT Marketing & Sales, Whippany, NJ - Led research efforts on improvement of generating website screenshots. Collaborated with international colleagues to install, test, and implement a new product for website screenshots. Generated proposal of tool use compared to requirements - Developed marketing email templates for Health Care Professionals by converting Photoshop images and PDFs into HTML - Gathered requirements and developed a SharePoint collaboration site for Project Management & Digital Consultant team through an agile method - Performed and documented manual website quality assurance process before website goes live - Created C# program to automate monthly reporting process

Greater Seattle Area

- Fabricated database requirements documentation and database mapping through use of colleague interviews and SQL script- Analyzed data records with use of excel and power query to verify employee employment status- Validated company records for missing and duplicate information- Assessed and conveyed third party system accuracy through data sampling

Greensburg, Pennsylvania

-Developed an excel document compiled from multiple crystal report export files which allowed quicker auditing of invoices-Audited customer invoices to verify accuracy of price changes, quantities, and surcharges-Constructed an excel template used to easily calculate on-time shipping analysis from raw exported data, which resulted in better client satisfaction-Prepared adjusting and repeating general journal entries to be audit trailed and posted-Posted and verified purchase orders into the accounts payable system ensuring accurate shipping receipt and pricing-Worked with supervisor to complete month end closing financial reports-Recorded invoice purchase orders into the system

Greensburg, Pennsylvania

Bachelor Of Science (B.S.), Information Systems Management, Finance

Activities and Societies: Alpha Phi Delta, Rotaract, Association for Information SystemsAlpha Phi Delta: Treasurer, Valentine's Day Ball.

Master Of Business Administration - Mba