Systems Analyst Business

*

Patrick Oliver

925-***-**** • *******.******@*****.*** • LinkedIn Profile A hands-on professional with demonstrated success in Business Systems Analyst, Project Management and Data Architecture roles for IT software implementation projects for over 15+ years. Full Software Development Life cycle (SDLC) experience including analysis, functional design, testing, implementation, and support. Effectively delivered enterprise solutions working with cross-functional teams of stakeholders, project managers, subject matter experts, architects, and developers. Accomplishments / Skills

• Saved company $200M on Merger Integration Management projects.

• Generated cost savings for company by converting data warehouse from Snowflake to BiqQuery

• A visionary and negotiator with excellent interpersonal and communication skills and leadership qualities.

• Steadily promoted from Business Analyst I up through to Business Analyst V.

• Experience in gathering User Requirements, Business Scenario Development, Testing and Technical documentation.

• Hired and trained five new Business Analysts in data warehousing and standard messaging modeling tools.

• Consistently deliver project tasks on time and in budget utilizing Agile and Waterfall methodologies.

• Quickly master new software and apply range of capabilities.

• An analytical problem solver with business acumen and customer service focused.

• Proficient in technical organizational data solutions such as Azure, Snowflake, GCP, BigQuery, Teradata, and DB2. Experience

Albertson Companies – Enterprise Data Management, Pleasanton, CA Staff Technical Analyst (2021 – 2025)

• Documented user requirements for Enterprise Data Management e-commerce solutions and designed warehouse data models and pipelines, driving a 28% increase in online sales.

• Developed interface specifications for Snowflake secure data sharing, enabling seamless integration with third-party platforms such as DoorDash, Instacart, and Uber, resulting in a 16% increase in Average Order Value.

• Integrated Marketplace data exchange into an e-commerce platform by capturing functional specifications, process flows and Entity Relationship Diagrams (ERDs), enhancing digital customer engagement.

• Designed a system solution for wine vendor integration with Lucidchart process flows, Erwin analytical models, GCP storage buckets, and Cloud Composer scheduling, achieving a 15% increase in online wine sales revenue.

• Executed a Snowflake-to-BigQuery Digital Catalog project plan, achieving 99.9% data accuracy and reduced costs through by creating test plans, data validation, rigorous testing, and on-schedule deployment.

• Led the customer analytical platform team to establish key KPI metrics and ensure compliance reporting. Senior Data Modeler (2018 – 2021)

• Implemented a centralized Enterprise Data Integration Service by conducting system analyses across multiple business processes, streamlining integration points, improving data reusability, and reducing points of failure by 30%.

• Collaborated with business unit stakeholders to centralize disparate data into an Oracle Persistent Data Store and developed key data requirements utilizing CRUD SQL rules to enhance data accuracy and streamline operations.

• Developed Canonical Message models to publish data in XML, JSON, and Avro, supporting B2B, B2C, and A2A integrations, achieving a 20% reduction in development time.

• Defined functional/non-functional requirements for a data web portal, ensuring data governance compliance.

• Aided in adoption of warehouse data management framework, reducing the Software Development Life Cycle (SDLC) by 15%.

• Created 250 business requirement documents, capturing data lineage, advanced SQL queries, sensitivity classifications, and Kafka streaming details, accelerating the integration of new projects by 50%. 2

Patrick Oliver

925-***-**** • *******.******@*****.*** • LinkedIn Profile Safeway, Inc – IT Supply Chain, Pleasanton, CA

Senior Business Systems Analyst (2015 – 2018)

• Conducted detailed gap analysis for Safeway and Albertsons merger, and created system solutions for converting item and sales data into an in-house IBM ERP system to achieve $250M in annual cost savings.

• Captured data from 20 Albertsons banners by developing source-to-target mappings, use cases, and interface specifications while defining updated business processes for marketing systems integration.

• Built data relationships in IBM tools, automated reporting for ETL database updates, and performed extensive data validation in Oracle SQL Developer for over 10,000 converted products.

• Developed system requirements for a web-based source-of-supply decision tool using the Java Vaadin framework, resulting in a 20% increase in Inventory Turnover.

• Executed SQL queries to validate back-end Db2 database tables and ensure alignment with business requirements.

• Maintained user stories in Jira and facilitated daily open defect status calls with offshore teams to convert 1200 Albertsons stores.

Project Manager – Retail Price Optimization (2013 - 2014) Implemented IBM’s Retail Price Optimization (RPO) tool into in house ERP system to support pricing business needs.

• Oversaw project to achieve adoption of RPO tool through refreshing of processes, training, communication and Establishment of improved process controls

• Created business process flows to help support changes in novel item pricing and competitive strategic pricing

• Created customized RPO training material with vendor and business pricing owners. Trained end users on the RPO tool and created communication programs to drive understanding of the tool’s capabilities

• Maintained project plan and rollout schedule for RPO application to all Safeway divisions

• Conducted daily calls with IT, IBM, and business users to oversee migration of RPO and ensure that all pre- Cutover, cutover, and post-cutover, tasks completed on time. Project Manager – Promotion Planning Contingency (2012 - 2013) Investigate and document industry retail price and promo applications to replace current Safeway systems.

• Created project charter and project plan.

• Documented best industry vendor solutions for retail/promo price applications.

• Evaluated vendor Price/Promo platforms from Revionics, Oracle, Softechnics, JDA, and SAS

• Provided upper management with weekly statistical decks for evaluating each of the vendor’s applications

• Provided application overviews to key business leads for evaluating software Business Analyst (I-IV) (2007 - 2012)

• Partnered with the Digital Media Marketing team to transition to a new email service provider, by developing Visio- based business process models leading to increased email campaign performance.

• Gathered HTML/CSS web design requirements for registration and account screens in the ‘Just for You’ customer loyalty program, enhancing user experience and increasing customer enrollment rates by 25%.

• Led an IT management project to implement a Retail Price Optimization tool capturing MS Project tasks, conducting user acceptance testing, and creating end-user training to ensure seamless integration into the ERP system.

• Implemented an MS SQL Server store end display service to generate templates for 2400 stores, enhancing store operational efficiency.

• Served as POC lead for creating turnover support documentation and managing change requests in the company CRM.

• Created test plans, test cases, and conducted acceptance testing for 50 deliverables as part of the Targeted Generated Offer Management initiative.

• Optimized project delivery by 35% through the implementation of Agile and Scrum methodologies.

• Defined business rules, metrics, and alerts for a Procurement Performance web application, resulting in a 15% improvement in promotional forecasting accuracy and a 20% reduction in excess inventory. 3

Education / Training

California State University, East Bay

B.S. Degree Computer Science

US Navy Aviation Ordnance School, Memphis, TN

Specialized training in aviation ordnance and electrical engineering Training: Azure: Azure Fundamentals (AZ-900), Snowflake Google Cloud Platform: Core Infrastructure, Load Balancing, Cloud Networking, Scaling and Automation, Cloud Security Fundamentals, Kubernetes Engine, Design and Process, Terraform, BigQuery Agile, Jira, Rally, Altova, Requirements Elicitation/Facilitation, Use Case Development, System Analysis for Business Analysts, Business Modeling, UML Technical Competencies:

Programming Languages: C, C++, Java, Pearl, Python Databases: Snowflake, BigQuery, Oracle, Mongo, MySQL, Db2/QMF, Teradata Operating Systems: Windows, UNIX, Linux, OS X

Software: Erwin, Kafka, Elation, Lucidchart, GitHub, Hackolade, Dimensions, MS Office, MS Project, MS Power BI, Visio, IBM WebSphere Business Modeler, Rally, Version One, Jira, HP Application Lifecycle Management (ALM), IBM Rational Software Architect, Micro Strategy Certification(s): Google Associate Cloud Engineer, AI for Everyone, Agile Framework

Contact this candidate