PROFESSIONAL SUMMARY:

• +10 years of Business Operation Support projects for Oracle eBusiness Suite SAP Coupa Peoplesoft, Microsoft Solutions & SaaS.
• ERP, SQL Analysis, CRM, Inventory, Shipping, SCM, WorkDay, Coupa, AWS Cloud, Business Intelligence, Dashboards.
• Involved in all phases of AP PO GL FA development using Microsoft, CA State, Konami, and Coupa from root cause analysis, database administration, maintenance and technical support with timely delivery against aggressive deadlines.
• Addressed data warehouse break fix support production issues, solved message report, E2E, and schedule maintained process jobs.
• Performed application support by troubleshooting steps requiring knowledge of multiple contributing factors or root cause such as application code, database configuration, network performance, data integration, and linked servers.

WORK EXPERIENCE:

Confidential, San Francisco Bay Area, CA

Business Analyst, Data Warehouse Support

Responsibilities:

• Collected Business Requirements for Confidential Current State. Performed scripted operations development, quality testing, training. Documented Use Cases, and BRD, FSD, TSD Jira Project documentation for data end to end processing.
• Reviewed SOR and Modeled Data, Dashboard Metric Solutions on Confidential Oracle Data Warehouse from Bank, Finance (Tradeworks), Treasury, Deposits for Credit IL, CL Stakeholders and Partners using SQL
• Scripts that checked data type, length, precision, scale, PK, FK, SK, blank, and null conditions.
• Maintained, Managed, & Controlled development, quality testing, training, 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 using Jira for
• Teradata, SQL Server, Oracle Data Warehouse Maintenance and Finance Operations team.

Confidential

Stakeholders

Responsibilities:

• Performed proof of concept, risk, operations, technical Oracle SQL*Plus, Object Data, STTM, Dictionary for integration implementation, ETL tasks Staging, Delta with Bank Global IT.
• Verified entity, columns were mapped from SOR (Source) using Informatica Mapping Tool to (Target) Integration Layer.
• Wrote data analysis conformance queries to business logic using filters for Consumption Layer (Repository) user cases.
• Promoted stakeholder success in project team round table management meetings for Jira, Project, Profit, Cost ViewLoan IQ data use cases.

Confidential, Bay Area, CA

ERP Business Analyst

Responsibilities:

• Elicited, Analyzed, and Modeled Business Requirements for Confidential Current State Analysis. Documented solicitationbidding, contracts financial transactions and approval processes. Reviewed data mapping and workflows for AP, FA, PO.
• Documented Cash Management Peoplesoft Implementation One - On-One, JAD, Training Session
• General Services, Treasury. Provided Current State -New Solutions in Microsoft Office, Excel Pivot ChartsSharePoint and Visio.
• Analyzed Oracle 12i GL ERP Issues, SaaS Solutions, SOW and recommended software, ETL process changes.
• Prepared data for 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 of 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.
• Provided claim activity reports with financial check totals, dashboard, KPIs and executive summary with gauges.
• Reviewed Use Case for AR Collections, 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 training, 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 claimsdeposits and payments management.
• Reviewed supply chain requirement documents, technical specifications and code for systemic correctness and feasibility prior to placement into environments.
• Provided coordination and implementation of new code and quarterly release code to include hot-fix execution as required.

Confidential, Walnut Creek, CA

ERP Business Analyst, Database Operations Support

Responsibilities:

• Collected Use Cases for Deltek Confidential, 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.
• 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.

Confidential, Salt Lake City, UT

ERP Report Analyst IV, Human Resources Operations Support

Responsibilities:

• Collaborated with Confidential WorkDay Implementation Team to define My Confidential Form use cases requirements, develop solution alternatives, provide system estimates, and project manage the changes from the Prototype to testing phase.
• Reviewed Business Requirements, Data Flows from SAP Confidential system to WorkDay on the Cloud. 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 Confidential Datasets, BW, Salesforce.com, SharePoint Dashboards and Excel tools to deliver improved Workday Confidential BI SaaS, Business Intelligence, Confidential Reports to executive management.
• Tested setup of Oracle ERP 10g data integration, work flows from SAP End-to-end Data Warehouse
• Technology for Confidential Activity Pipeline to Workday for Transformation.
• Provided Balance Sheet, Income Statement, Adhoc Sales, BI Reports for Confidential 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 Procure to Pay Cloud Application Use Cases. Mapped Atmosphere to and from virtually any system using the Coupa connector, retrieved procure to pay data from tables and sent data via ETL to the Coupa application for Cash Management.
• Utilized multiple skill sets in troubleshooting cloud tickets, manage solution queue, and performed system administration. Reviewed transaction database tables for B2B process issues. Coupa AP user resource for setting up roles, profiles, approval structure, & features. Combed through log files for inconsistencies.
• 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

Responsibilities:

• Collected financial reporting requirements from Microsoft SAP AR, Supply Chain Management Users, Confidential Manufacturers for
• Windows 8 Surface, MSIT Stakeholders ( Confidential, Confidential, Confidential ), Developers, and delivered channel revenue use cases. SaaS resource to Cross Functional Teams to Support of Partners Confidential, Confidential, & Confidential 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).
• 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 SaaS SOA Data Integration API production war room.

Confidential, Las Vegas, NV

Business Analyst

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 AnalysisGAP, Financial Analysis. Directed Cost Initiatives, Business Process Improvement, Risk Assessment, and Performance
• Audits for Confidential Compliance, KPMG, Confidential, 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 - Confidential - Cognos Report Writer. Created custom KPI reports for Confidential, Operations, KPMG, Confidential Audits.
• 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 Confidential 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 Confidential - MSLI websites. Assisted financial users with business processes, adhoc vendor reports and SQL queries on purchase order - 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 Reporting RDBMS.
• Performed backup, restore, data drops, & hot patch updates on User Acceptance Testing Databases. Configured ODBC
• RDBMS for source and destination databases. Ran DTS SPROCs to load and validate processes from factory to repositories. Utilized SQL.NET to validate purchaseorder, contract, agreement transactions at header, line, and detail level.
• 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.
• 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 2003, 2007.