Business Analyst Data Analytics

Resume

Joseph Garcia

Email: jfgarcia.co@gmail Phone: 720-***-****

Linkedin: https://www.linkedin.com/in/joseph-garcia

Results-oriented Sr. Business Analyst with a proven track record in optimizing business processes. Increased forecasting model accuracy by 30% through advanced data analytics, enhancing decision-making for resource allocation. Streamlined reporting processes by automating data collection, reducing reporting time by 40%. Expertise in gathering and analyzing business requirements, driving operational efficiency, and facilitating stakeholder engagement to align project goals with organizational strategy, adding significant value to potential employers. Successfully managed multiple concurrent projects, demonstrating strong organizational abilities and a hands-on approach. Ability to engage, facilitate, educate, and lead diverse teams, both locally and globally, has been instrumental in delivering projects on time and within budget.

Deliverables

●Led cross-functional teams to gather and analyze business requirements, ensuring alignment of project goals with organizational strategy and stakeholder expectations.

●Increased the accuracy of forecasting models by 30% by implementing advanced data analytics techniques, resulting in more informed decision-making for resource allocation.

●Streamlined reporting processes by automating data collection and visualization, reducing reporting time by 40%, which allowed for more timely insights into business performance.

●Facilitated stakeholder workshops to identify critical pain points, resulting in the successful implementation of three key initiatives that improved operational efficiency by 25%.

Documentation

●Business Case, Charter, Project Plan, High Level/Detail Requirements (BRD/FRD), High Level Design (FSD) High Level Architecture, (SOW), (WBS), (RACI), (RTM), (Use Case), Scrum Ceremonies, Development Plan, Test Plan-Scripts-UAT, Training Plan, Change Control Plan, Implementation Plan, Post Implementation Plan, Project Documentation Archive Plan.

Professional Skills

●Methodologies (RUP/AGILE/Hybrid/Lean Sigma/Mapps/PMUWS/SUPPLY CHAIN/e_COMMERCE/WMS)

●Data Analytics

●Forecasting Models

●Automation of Data Collection

●Data Visualization

●Business Process Improvement (Lean Sigma)

●Tableau, Power Bi, JIRA, Azure, Primavera, Project, SharePoint, MicroSoft Apps.

●Presentation - Guest Speaker at APICS, American Software, Public Service Phoenix, General Electric, GTE, And Electronic Industry Data Exchange Organization. Was On The Board Of Directors For EIDX, The Electronics Industry Data Exchange EDI Group.

●ERP Systems: Sterling, MICS, Oracle, Clarify, ROI, BPCS, ASI, PeopleSoft, SAP (Various Hosted ASPs Peregrine, E-Plus, GHX, AMEX @Recon, etc.) Unix. eRoom, IBM 3090, MVS Operating System, Yardi.

Strengths

PM/BA/Scrum

Organizational Skills

Effective Communication

Problem-Solving

Documentation

Collaboration

Adaptability

Education

1.University – Mountain States 1990: Certifications: Professional Mgt., Procurement Management, MRP1.1, Corporate Instruction

2.IBM 1992-Certification – Lean Sigma, VSM

3.University – San Diego State 1985 – Certification Configuration Management

4.PMI 1990 – PM/BA Certification

5.ANSI x.1 – EDI/EDIFACT/XML

Experience: Recent Projects Detail

Flagstar Bank June 2023 - August 2024 - (Remote)

Spearheaded the merger of two separate bank's document management systems into a cohesive solution, ensuring efficient processes for document creation, storage, retrieval, collaboration, and compliance.

●Successful integration of two banks' document management systems to ensure efficient document-related processes.

●Merged two separate bank's document management systems into a cohesive solution to ensure efficient processes for document creation, storage, retrieval, collaboration, and compliance.

●Identified scope of project and source to target directives.

●Created Flows, Use Cases, Stories for JIRA tracking.

Technology

Microsoft Suite, OpenText, PRF, JIRA, SharePoint, Clarizen, Methodologies: Waterfall/Agile

PNC Bank August 2022- May 2023- (Remote)

Managed the transition from a Waterfall to an Agile/Scrum methodology, overseeing data migration reporting and the delivery of two phases of migration projects.

●Successful data migration and reporting projects, transitioning from Waterfall to Agile methodologies.

●Worked as a Scrum Master, defining the processes and tasks involved in the transition from a Waterfall to an Agile environment. Documented and executed project ceremonies, and ensured traceability between business requirements and corresponding design and testing.

●Identified scope of project and source to target directives.

●Created Flows, Use Cases, Stories for JIRA tracking.

●Managed project progress and SCRUM Ceremonies.

Technology

Microsoft Suite, OpenText, PRF, JIRA, SharePoint, Clarizen, Methodologies: Waterfall/Agile

Cargill September 2021 - June 2022

Spearheaded data migration projects, integrating source systems with target systems and BI/reporting solutions for sales, commodities, profits, and financial reporting, both domestically and internationally.

●Data Migration Source to Target to BI to Dashboard/Reporting.

●Successful completion of data migration and reporting projects across sales, commodities, finance, and other domains.

●Led four data migration projects, both domestic and overseas, covering sales, commodities, profit ratios, and financial reporting.

Technology

Microsoft Suite,, OpenText, PRF, JIRA, SharePoint, Clarity, AZURE Methodologies: Waterfall Agile

Wells Fargo June 2020 - June 2021

Led the Marketing Capabilities Group-Data Migration From Source to Target utilizing existing Changed application functionality, and Development of Reports and Dashboard.

●Worked as a liaison amongst business/Marketing stakeholders and technology partners to elicit, analyze, document, and validate business requirements of user stories related to the Marketing systems and tools.

●Utilized the requirements framework to identify the most appropriate requirement methods or techniques for developing detailed requirements.

●Ensured that traceability was established between business requirements and corresponding design and test.

Technology

Microsoft Suite, Aprimo, OpenText, PRF, JIRA, SharePoint, Clarity. Methodologies: Water/Agile

Career Summary-Employment History

All Listed Projects Charter’s were completed successfully and within allotted budgets.

Title

Company Name

Location

Type

Status

From

To

Objective

Responsibilities

Sr. BSA/Delivery Mgr.

Eddie Bauer

Brea CA

Contract

Onsite

Mar-2020

Jun-2020

Implementation of New Help Desk

Team Facilitation/Requirements/Scope, optimal to be process, working with clients to implement Service Now.

Sr. BSA/Delivery Mgr.

Essex Properties

Irvine CA

Contract

Onsite

Jul-2019

Feb-2020

Implementation of New Help Desk

Team Facilitation/Requirements/Scope, optimal to be process, working with clients to implement Service Now.

Sr. BSA

Wells Fargo Bank

Minneapolis MN

Contract

Remote

Feb-2019

Jun-2019

Marketing Data Migration/Reports/Dashboards

Business Reqs., Systems and Tools User Stories, Traceability between business and Design/Test.

Sr. BSA

Wells Fargo Bank

Minneapolis MN

Contract

Remote

Sep-2018

Dec-2018

Demand Content Managing Imaging Content Managing.

Establishing Mgt. team requests/team, estimation and sizing, proposals, partner expectations/communication, change control, artifacts and deliverables.

Sr. BSA

Wells Fargo Bank

Minneapolis MN

Contract

Onsite

Sep-2017

Sep-2018

Insurance Policy Management Upgrade

Upgrade the existing Insurance Policy Management application three versions to current status per company edict.

Sr. BSA

Wells Fargo Bank

Minneapolis MN

Contract

Onsite

May-2016

Mar-2017

Move Server Farm/Applications

Evaluate the existing Farm Content/applications and create and execute a Server Farm Move from one company location to another out of state facility.

Sr. BSA

SuperValu Ind.

Minneapolis MN

Contract

Onsite

Sep-2015

Feb-2016

Web Site Client Modification/Improvement

Worked with internal and divisional clients to define requirements, negotiate (WBS), create PMO Documentation for project initiation, and defined SOW,s, and designs for multiple IT projects. Projects involved architectural infrastructure feasibly studies.

Delivered 4 Project Improvement Projects (Merchandise Operation Projects)

Sr.BSA

Polaris

Minneapolis MN

Contract

Onsite

Apr-2015

Sept2015

Web Application/Paint Automation Project

Work with internal and divisional clients to define requirements, negotiate (WBS), created PMO Documentation for Project initiation, and defined SOW’s, and designs for multiple IT projects. Projects involved Architectural Infrastructure feasibly studies.

Perform process improvement analysis. Documentation was completed for project requirement approval and design.

Delivered Three Project Improvement Projects:

* Paint Automation

* Real-time cost visibility

* WEB application automation

PM/BSA

Navajo Industries

Denver CO

Contract

Onsite

Oct-2014

Apr-2015

Provide a Gap Analysis and recommendation for a Merchandising Solution for Retail and Vertical Warehousing.

ERP evaluation keep/buy/build, Warehouse Mgt. solution, upgrade existing software applications, replacement of outsourced applications, and any additional needs.

Sr. BSA

CHS

Minneapolis MN

Contract

Onsite

Dec-2012

Sept2014

Replace Carrier onboard computer hardware wit PeopleNet for truck routing and outbound data/design and install a Vendor Invoice/Payment integrated Web Financial system

Identify requirements, engage third parties, negotiate contracts, complete Discover, build and test plans and successfully execute.

Consultant

Self Employed

Denver CO

Contract

Onsite

Feb-2011

Dec-2012

Worked with my client to define requirements,created the design and modeling for a desktop computing system.

Designed Functionality to meet client requirements, ordered equipment and coordinated the installation and software configuration of a small office setup.

Sr. BSA

IBM

Boulder CO

Contract

Onsite

Sep-2009

Jan-2011

Lead one or more application work streams in Intel/Unix and Global Delivery for re-engineering, interfacing with Internal IBM applications.

Lead one or more application work streams in Intel/Unix and Global Delivery for conducting diagnostics, performing analysis, and helping with future state design, and working with the Application Team for changes to be implemented.

Sr. BSA

Ball AeroSpace

Broomfield CO

Contract

Onsite

Nov-2008

Sep-2009

Process improvements to the existing eCommerce projects.

On going EDI project work, maintaining links to new and existing systems such as MFG PRO, Unix, Web and JDA. Recommending additional functionality internally, and for vendor changes inclusive. Maintained 17 EDI business documents.

PM/BSA

Group Publishing

Loveland CO

Contract

Onsite

Jun-2008

Nov-2008

Upgraded Oracle 11i system. Install and Configure Oracle EDI Gateway. Engage Oracle Gateway ASP for configuration and patch installs.

Engaged ASP for EDI Web access. Work with teams to determine the business impacts of the upgrade and create project plans for the upgrade.

PM/BSA

Gander Mountain

St. Paul MN

FTE

Onsite

Jan-2008

Jun-2008

Outsourced Payroll & Human Resource to an ASP. Upgraded Oracle 11i system

Created teams to define project requirements, project plans, and ASP engagements. Directed teams of 23 subject matter experts, ie. Developers, DBAs, SMEs to document, design, construct and implement these projects. These project also involved the engagement of an outside ASP source.

Sr. BSA

Ameriprise Financial

Minneapolis MN

Contract

Onsite

May-2006

Dec-2007

Day 700 Project - American Express and Ameriprise Financial split companies, and from/to integration and installations of new applications. Provided analysis and documentation for four projects focused on transforming business processes for the Financial Advisor and corporate reduction.

Upgraded Smart Office providing planning and activity entry for financial advisors and their leaders. Responsibilities included vendor contact, negotiations, and vendor management; management of a blended project team (on and offshore) and project financials.

Performed Importation of historical mutual fund, insurance and annuity account performance history from the legacy applications to a web based portfolio management application.

Material Master Data Governance Business Analyst (Lean Sigma)

Medtronic

Blaine MN

Contract

Onsite

Dec-2005

May-2006

Controlled process to identify, approve and implement change to Material Master Data with Compliance to Data Standards. Establish material data management policies, ratify Standard Operating Procedures (SOP's), and confirm work processes.

Addressed specific complexities with SAP data changes to ensure data quality.

Designed a new Change Control Notice form excel based instead of Word based, streamlined approvals, and clarification on change impacts, designed metrics for measurement of progress of notices in various stages.

Provided a Web Based Navigational Tool for accessing process/tools/reports/queries/worksheets, Web access, as well as frequently utilized web sites, and source documentation.

Sr. BSA

Ball AeroSpace

Broomfield CO

Contract

Onsite

May-2004

Nov-2005

EDI project work; maintaining links to new and existing systems such as MFG/PRO (Unix), WEB based EDI, JD Edwards and PRAXA (DCL).

Monitoring and maintaining communication between business units and Trading Partners. Responsible for programmatic changes to internal systems to support external customer requirements. Maintained 17 EDI Document Transactions inbound and outbound to over 200 Trading Partners (Vendors, Customers, Banks, Freight).

Sr. BSA

Janus Funds

Denver CO

Contract

Onsite

Jun-2002

May-2004

The objective of this project was to design interfaces for outbound data that would be utilized to update the ASP tool with validation data tables i.e., Sign-on, authorization levels, and GL, Cost Center, Internal Order Numbers etc. The inbound information sent from the ASP would then be validated with those tables, and utilized to update SAP GL.

Purchasing P-Card, Help Desk Migration, ERP changes.

Purchasing P-Card - duties involved analysis, design, vendor selection of an outside ASP source, training, documentation and implementation.

Help Desk Migration - duties involved analysis, design, training, documentation and implementation. The Help Desk Migration project was designed to move from the Help Trak product to the Peregrine Product, both managed by Unisys.

ERP replacement project was to design a complete ERP system that would replace SAP and be Integrated into the e-Commerce and other Janus processes. All of the projects involved complete PM with both inside and outside resources.

Professional Accomplishments:

●Authored an EDI Document Tracking System.

●Received Two Technical Excellence Awards For Speaking And Instruction.

●Authored A Barcode Tracking System, And Designed/Instructed Users.

●Co-Authored A Performance Goal Setting/Appraisal System And Designed/Instructed User Classes.

●Traveled To More Than 100 Companies To Educate Suppliers On EDI, Barcoding, and Modeling Concepts.

●Guest Speaker at APICS, American Software, Public Service Phoenix, General Electric, GTE, And Electronic Industry Data Exchange Organization. Was On The Board Of Directors For EIDX, The Electronics Industry Data Exchange EDI Group.

●A Member of Professional Management Association PMA For Five Years.

●Authored A MRP User Course And Certified 2400 Managers And Users.

●Designed and implemented two Supply Chain Complete Systems including VMI (Vendor Managed Inventory), Daily Master Scheduling, MRP11, Purchasing EDI, and Warehouse Management.

Contact this candidate