PROFESSIONAL SUMMARY:

• Over 10 years of supply chain management experience Oracle, Intuit Enterprise Solutions /iProcurement /INV
• Addressed break fix ERP SCM production issues, solved message report, B2B, and schedule maintained process jobs.
• Performed troubleshooting steps requiring knowledge of multiple contributing factors or root cause such as application code, database configuration, network performance, data integration, and linked servers.
• Reviewed supply chain requirement documents, technical specifications and code for systemic correctness and feasibility

TECHNICAL SKILLS:

• Microsoft SQL Server 2005/2008
• MVS Reporting
• Crystal Reports Office
• Power Point Microsoft
• Windows Server
• Project Server
• SharePoint
• Outlook Exchange Server

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco Bay Area, CA

Business Analyst/ERP Support

Responsibilities:

• Collected Business Requirements for As IS Current State. Performed scripted operations development, quality testing,, and BRD, FSD, TSD Project documentation for data end to end processing.
• Reviewed SOR and Modeled Data / Dashboard Metric Solutions on Oracle Data Warehouse GL from Finance Services, Treasury, Deposits for Credit IL/CL Stakeholders and Partners using SQL
• Scripts that checked data type, length, precision, scale, PK/FK/SK, null and conditions.
• Maintained, Managed, & Controlled development, quality testing,, and staging environments for data warehouse refresh from Billing, Payments, Lockbox Deposits, and Feedstore. Reviewed technical solutions provide by the IT System vendor for root cause, defect fixes and approved CRs
• Supported planning and implementation of data refresh, frequency and system releases for
• Teradata / SQL Server / Oracle Data Warehouse Maintenance and Finance Operations team.
• Deliverables for San Francisco Financial Stakeholders:
• Performed proof of concept, risk, operations, technical Oracle SQL*Plus/ Object Data Dictionary for integration implementation, ETL tasks Staging / Delta with Bank Global IT.
• Verified entity / columns were mapped correctly from SOR to Informatica Mapping Tool to Integration Layer.
• Wrote data analysis conformance queries to business logic using filters for Consumption Layer user cases.
• Promoted stakeholder success in project team round table management meetings for Stakeholder / Project/
• ROI /Cost View /Credit Loan data use cases.

Confidential, State Hospitals Bay Area, CA

ERP Business Analyst, Business Operations Support

Responsibilities:

• Elicited, Analyzed, and Modeled Business Requirements for As IS Current State Analysis.
• Documented solicitation, bidding, contracts financial transactions and approval processes.
• Reviewed data mapping and updated workflows for AP, FA, PO & Cash Management Peoplesoft Implementation for State Controller / Treasury. Provided Current State - New Solutions in Microsoft Office, Excel Pivot Charts,
• SharePoint and Visio.
• Analyzed Oracle Fusion 12i GL ERP Issues, SaaS Solutions, SOW and recommended software / ETL process changes.
• Prepared data for ERP AP PO P2P conversion activities, analyzed and recommended new data configurations with Oracle
• SQL interfaces between legacy and new systems.
• Served as a technical specialist for the Infor Medical Billing Revenue Management System for implementation f state insurance organization. Conducted testing of defect fixes, system enhancements, upgrades, including drafting of Oracle PL/SQL E2E test scripts and scenarios for generation of insurance claim AR data.
• Deliverables for California State Stakeholders:
• Provided claim activity reports with financial check totals, dashboard, KPIs and executive summary with gauges.
• Supported planning and implementation of system releases with the Infor AR Maintenance and Operations team.
• Reviewed the functionality - database design of the AR System. Mitigated and troubleshoot AR System issues.
• Provided product development, UAT testing, client, and staging environment administration.
• Worked with client staff and new system vendor to complete root cause analysis for the Infor AR Billing.
• Administered Legacy, ERP, SQL Server 2008r2, Windows Server 2008 and SaaS end to end processing of claims, deposits and payments management.

Confidential, Utilities Walnut Creek, CA

ERP Business Analyst, Database Operations Support

Responsibilities:

• Supported the ERP system including maintenance, upgrades, testing, user cases, data integration, and implementing new Vision ERP CRM features.
• Applied change control principles for managing SQL .NET, SSRS, Business Intelligence, Deltek Reports/ Vision Dashboards/ Data Grids, ERP Business Improvement related project resources and tasks.
• Worked with the IT Management to manage and document applications, database changes, and user role security for engineers in PG&E Energy Projects. Created Excel Task Subtask Level Completion KPIs
• Deliverables for GTS Stakeholders:
• Collected Use Cases for Deltek HR, GL, Sales, Service, Project using Deltek Kona Data System Administration Discussions in Chat, Kona SharePoint, Microsoft Office Outlook, and Excel.
• Performed Review of ETLTransaction XML/SQL Data Flow to Vision Reports, and Dashboards. Modify or Build Project, Contract, Resource Management form.

ERP Report Analyst

Responsibilities:

• Collaborated with eBay WorkDay Implementation Team to define My HR Form requirements, develop solution alternatives provide system estimates, and project manage the changes from the Prototype to testing phase.
• Provided data analysis of human resource key metrics - trends in a timely manner, recommend steps to for efficiency, effectiveness of global teams, as contracted, centers of expertise, and critical programs.
• Utilized SAP ECC Datasets, BW, Salesforce.com, SharePoint Dashboards and Excel tools to deliver improved Workday HCM BI SaaS, Business Intelligence, HCM Reports to executive management.
• Deliverables for Sunrise Systems and eBay Stakeholders:
• Tested setup of Oracle ERP 10g data integration / work flows from SAP End-to-end Data Warehouse
• Technology for HR Activity Pipeline to Workday for Transformation.
• Provided Balance Sheet, Income Statement, Adhoc Sales / BI Reports for HR Analytics Management.
• Promoted stakeholder success in global project team round table management meetings for data use cases

Confidential, Reno, NV

E-Procurement Operations Analyst

Responsibilities:

• Supported Coupa Spend Management Partners, AWS Cloud and Supplier Network. Mapped Atmosphere to and from virtually any system using the Coupa connector, retrieved AP Invoices and Purchase Order data from source tables and sent data to the Coupa application integration tables for automated transactions and Spend Reports.
• Utilized multiple skill sets in troubleshooting cloud tickets, managing solution queue, tested features and performed system administration. Reviewed transaction database tables for B2B process issues. Coupa AP UI/UX administration resource for setting up roles, profiles, approval structure, & features. Combed through log files for inconsistencies and errors.
• Deliverables for Coupa Spend Management E - Procurement Stakeholders:
• Created spend management / business intelligence drill down reports using % metrics and business drivers.
• Performed retail support for store inventory, cycle count, and set re-order points for improved supply chain.
• Executed SQL API integration tests with on premise Oracle 11g SQL*Plus / SAP / NetSuite/JD Edwards ERP too.
• Performed Work Flow Implementation tasks within SLA and in scope for Customer Success.
• Enabled integration, translation and exchange of electronic documents in EDI.

Confidential, Reno, NV

Business Intelligence Analyst for OEM Applications

Responsibilities:

• Collected financial reporting requirements from Microsoft SAP AR/ Supply Chain Management Users, OEM Manufacturers for
• Windows 8 Surface, MSIT Stakeholders (HP, Nokia, Dell), Developers, and delivered channel revenue. SaaS resource to Cross Functional Teams to Support of Partners Accenture, Deloitte, & Amazon for purchasing, order acknowledgement, fulfillment, and computer build report use cases.
• Application administrator for SAP ERP COE, MSLI SOA SQL Server 2008r2, 2010 & 2012. Performed backend support (SQL) as well as front end resolution using Microsoft .Net, XML, SOAP, REST, & IIS. Utilized MS SQL Server 2008/2012 ProfilerT - SQL, Query Editor, ETL SSIS / DTS, Event Viewer, System Monitor, SQL Server 2010 Beta Visual Team Studio Team and Business Intelligence (SSRS, BI, SharePoint).
• Deliverables for Confidential MSLI projects, OEM Partners, & Sarbanes Oxley:
• Delivered revenue recognition, business invoice, order processing, service, product fulfillment, computer build reportsand inventory express solutions to Microsoft Internal and Partners in Ireland, Reno, NV and Redmond, WA.
• Involved in all phases of the MSIT DW SDLC (Software Development Life Cycle) from analysis, design, developmenttesting, implementation and maintenance with timely delivery against aggressive deadlines.
• I performed change control issue review for code release issue reviews for production war room.

Confidential, Las Vegas, NV

Business Analyst - Planning Administrator

Responsibilities:

• Configured new ERP systems to international sales order, service, contract, and asset user cases - business requirements.
• Tested and documented software changes and user access changes for Corporate, Stakeholder Compliance and Sarbanes
• Oxley with Financial Reporting.
• Performed Application Administration, Project Management, Change Control, Cost Benefit Analysis, Risk AnalysisGAP / Financial Analysis. Directed Cost Initiatives, Business Process Improvement, Risk Assessment, and Performance
• Audits for HQ Compliance /KPMG / Deloitte/Nevada State Gaming Board.
• Performed Quality Assurance on User Test Cases for Front Office, Systems Service, International Sales OrdersSupply Chain, Purchase Orders, Assets, Service Repairs, and Contracts - Projects ADP Cognos Report Writer.
• Created custom KPI reports for HQ/ Operations /KPMG / Deloitte Audits.
• Deliverables for Konami BPI Initiatives, Sarbanes Oxley, and Stakeholders:
• Administered Pronto Client & System Level Changes on Oracle 11 / IBM AIX Servers to SOX, .
• Performed Data Integrations with Oracle SQL*Plus, Pronto SQL, Flat file, CSV, and Excel File Exchange.
• Contributed business & data process solutions for Konami Sales, Marketing & Service Partners / Customers.

Confidential, Reno, NV

Data Warehouse Reporting Applications Analyst

Responsibilities:

• Teamed up with Microsoft Retail, Volume Licensing, SAP Super users, Tier I Support, LIR DevelopmentChange Control and support to DBAs to improve end to end processing of Mobile Supply Chain
• PO - Sales Orders - Fulfillment License Subscription Contracts for OEM Partners Receivables
• Billing to Microsoft Websites & Sarbanes Oxley Reporting.
• Investigated business data transformation problems from SAP R/3 Business Warehouse to factory databases, to report destination data marts - repositories, and to business intelligence reporting on OEM - MSLI websites.
• Assisted financial users with business processes, adhoc vendor reports and SQL queries on purchase rder order entry receivables billing and service databases to meet business deadlines.
• Built User Acceptance Testing - Performance Environments on SQL 2005 Enterprise Edition, linked servers with failover clusters. Updated and maintained Microsoft SQL 2005 Enterprise UAT and Reporting Repositories.
• Supported the implementation and maintenance of MSIT Production SQL 2005 Data Warehouses on Clustered Windows
• Servers, and MS SQL 2005 servers, on SANS drives/networks.
• Deliverables for MSLI projects, Sarbanes Oxley, and CIT users
• Completed May Quarter Data Warehouse / Repository / Website Reporting ETL SQL Jobs for End to
• End Processing and license / service data refresh tests for UAT I, UAT II.
• Documented Volume License E2E user cases in MSE Tickets and in SharePoint .

Confidential

Business Analyst

Responsibilities:

• Implemented Microsoft Dynamics - Great Plains Retail Sales, GL /AP /PO /AR /INV, Financial ReportingCredit Card Advantage, DRP, Supply Chain Management, Freight Management, and Radio Beacon
• Warehouse Manufacturing Systems feature changes on Microsoft SQL Server 2000.
• Tested and implemented new inventory, service claims, freight source charge management module for
• Great Plains. Audited purchase orders, receiving transactions, container shipments, & inventory adjustments from Great Plains API to Radio Beacon WMS Database .
• Tracked down ecommerce problem orders from form - API interface - table - SQL level. Reconciled credit -debit memos, chargebacks, and AR invoice adjustments to AR Aged Trial Balance Detail Report.
• Created or modified existing business service repair, return, invoice forms and financial reports using
• Crystal Reports and Microsoft SQL Reportwriter. Performed backups - restores, data updatesand patches to client computers, conference room pilot - development - instances.
• Deliverables for Skagen Designs:
• Configured Great Plains Receivables Customer setting for Majors - Independent - Corporate - B2B
• Web Sales Channels.
• Drafted End User Requirements Document for Data Habitat Marketing Reports, Skagen Website HTML Changes for web orders, inventory lookups, Crystal Reports, Visual Basic form changes, and database integration.
• Conducted round-table brainstorm discussions for improving IT service, implementing changes, and system confidence.

Business Solution Analyst

Confidential, Belmont, CA

Responsibilities:

• Collected user requirements, use case, performed GAP Analysis against business requirements for BankingGovernment,, Projects, Proposals, Grants, Hi - Tech, Telecom & Software firms.
• Reviewed Current System State for Business Process Improvement through software configuration program development for GL, AP, Budgets and Bank Reconciliation. Conducted project meetings to document milestones, and to provide status reports to stakeholders on weekly basis.
• Performed Oracle 11.5.8i/11/10.7 Code control throughout instances for Financials, Supply Chain, E-ProcurementOM, INV, WIP, BOM, Manufacturing, Human Resources, Self Service Applications, ECM, SOA & SaaS .
• Coordinated Project Review Meetings with key accounts, consultants, Oracle Users, Oracle Development
• Management to review PO/INV/OM/WIP/MRP/MRO problems and issues causes.

Confidential, East Palo Alto, CA

Product Leader

Responsibilities:

• Organized beta test process with QA, Marketing, Product Development, Quicken for Windows SDLCand Support. Supervised & trained beta test representatives reporting problems to QA / DevelopmentChange control, call support, procedures,& issue tracking database usage. Online Answer Book editor and Online Help author for Quicken for Macintosh, DOS, and Windows products.
• Created business, financial, payroll, and product documents and test for outsource sites covering all personal financial products for windows platform.
• Submitted check register, write checks, transaction report feature changes to development that were implemented in next release.