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.
• 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.
• 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.

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.

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.

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.

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.

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.

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