PROFESSIONAL SUMMARY:

• Documented Requirements including FSD, TSD, DRD, solicitation, bidding, contracts financial transactions and approval processes.
• Involved in all phase Oracle WorkDay Cloud SaaS design, development, SQL testing, implementation and documentation against aggressive deadlines.
• Elicited, Analyzed, and Mapped Business Requirements for Use Cases, As Is Current State & GAP Analysis.
• I performed support team incident - project issue review for code release issue for Supply Chain, SAP Center of Excellence Business Intelligence, SOA, Data Warehouse and production war room.

TECHNICAL SKILLS:

Technology and Tools: E - Business Suite 11i GL, AP, FA, INV, AR, PO, OM, BOM, WIP, MRP, CRM, Project Accounting, Cash Management, Oracle 9i/10g PL/SQL, SQL*PLUS, Oracle Reports / Forms, Discoverer, SQLDBA University of Nevada, Reno, NV Extended Studies, PMI Project Management New Horizons Learning Center, Reno, NV Confidential SQL Server 2005/2008 MVS Reporting - Crystal Reports Office, PowerPoint, Confidential Windows Server - Project Server SharePoint, Outlook Exchange Server

WORK EXPERIENCE:

Confidential, San Francisco Bay Area, CA

Business Analyst, Data Warehouse Support

Responsibilities:

• Collected Business Requirements for As - IS Current State. Performed scripted operations development, quality testing,, and documentation for data end to end processing.
• Reviewed SOR and Modeled Data / Dashboard Metric Solutions on iHub 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, 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 / Confidential with Confidential .
• 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 Jira / Project/
• Profit /Cost View /Loan IQ data use cases.

Confidential, 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 Confidential 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 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 SQL E2E test scripts and scenarios for generation of insurance claim test data.
• 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 claimsdeposits and payments management.

Confidential, Walnut Creek, CA

ERP Business Analyst, Database Operations Support

Responsibilities:

• Supported the ERP system including maintenance, upgrades, testing, use cases, data integration, and implementing new features. Worked with the IT Management to manage and document applications, database changes, and user security for Confidential &E Energy Projects.
• Acted as the internal subject matter expert for the front end and back end of Confidential Vision ERP system using
• Confidential SQL Server Database, Confidential .NET and Business Intelligence.
• Reviewed Database Current State - Standard Operating Procedures through observation and discovery.
• Configure, Monitor, Control, & Optimize MS SQL Server components to ensure the proper operations of billing system including Confidential Windows Server, Report Server, Visual Studio .NET & IIS.
• Verified use cases and tested workflows in Confidential SQL Server 2008r2, Test Environment For .NET TSQL Scripts in Visual Studio MVS SQL2012/2014.
• Collected Use Cases for Confidential HR, GL, Sales, Service and Project using Confidential Kona - Data System
• Administration Discussions in Chat, Kona SharePoint, Confidential Office Outlook, 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, Confidential 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 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.
• Collected HRMS user cases through testing including change control. Reviewed the BI data processes feeding the recruitment, onboarding, management review, and approvals. I noted user stepsbusiness case, and analyzed reporting data requirements in stakeholder meetings.
• Reviewed Workday documentation, My SAP HR operations, Data Requirements, and Project Status DRD
• Meetings. Assisted Sunrise stakeholders with screening and on-boarding employee functions.
• Deliverables for Confidential and Confidential 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:

• Mapped Atmosphere to and from virtually any system using the Coupa connector, retrieved procure to pay data from ERP AP - PO tables and sent data 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.
• Configured Coupa AP, PO, INV, Finance, Cash Management and E-Procurement. Provided Proof of Concept for
• User Acceptance Testing. Documented Cash Management Reports for CRM, HR, & ERP. Setup Coupa ERP to validate / receive their billing invoices, supplier options, order guide catalog, PO Acknowledgement and Advanced
• Participated in the change control- team discussions of program logic, data processing, and error resolution.
• Reviewed, monitored, and controlled SDLC Agile Development. Supported Coupa / Confidential .com AWS Cloud
• 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 Confidential SAP AR/ Supply Chain Management Users, OEM Manufacturers for Windows 8 Surface, Confidential, Confidential, Confidential ), Developers, and delivered channel revenue. SaaS resource to
• Cross Functional Teams to Support of Partners Confidential, Confidential, & Confidential for purchasing, order acknowledgement, fulfillmentand 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 Confidential .Net, XML, SOAP, REST, & IIS. BizTalk for data pipeline from SAP to SQL Server and SQL to XML. Utilized MS SQL Server 2008/2012 Profiler, T-SQL, Query Editor, ETL SSIS / DTS, Event Viewer, System Monitor, SQL Server 2010 Beta Visual Studio, Team Foundation Server and Business Intelligence (SSRS, BI, SharePoint).
• Utilized Confidential SharePoint, Business Intelligence, SSRS, Confidential Meeting, Confidential Office 2013SQL Team Foundation Server, to communicate Supply chain project goals - objectives - statuses - completion. Ensured that issues are identified, tracked, reported on and resolved in a timely manner.
• Reviewed SLA Details - Contributing Factors in Shift Production Scorecard.
• Completed May Quarter Confidential IT Reporting Tasks for End to End Processing, Smoke Test, Regression
• Test, Stress Test, and System Test for UAT I, UAT II Instances on time and in scope.
• 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 Confidential Internal and Partners
• 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 AnalysisGAP / Financial Analysis. Directed Cost Initiatives, Business Process Improvement, Risk Assessment, and Performance
• Audits for HQ Compliance / 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 - ADP - Cognos Report Writer. Created custom KPI reports for HQ/ Operations / Confidential Audits.
• Deliverables for Konami BPI Initiatives, Sarbanes Oxley, and Stakeholders:
• Administered Pronto Client & System Level Changes on Oracle 11 / IBM AIX Servers to SOXNevada State Gaming Compliance. Audited user roles and system activities to HQ Specs.
• Upgraded Pronto ERP / Oracle SCM from Phase 4 to 5 Financials, Inventory, and Slot Game
• 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 Confidential 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 Confidential 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 Editionlinked servers with failover clusters. Updated and maintained Confidential 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 purchase rder/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.
• 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 .
• Demonstrated working knowledge of Windows Server NT, 2000, 2003 networking to include:
• TCP/IP and core services such as DNS, DHCP, WINS, Group Policy, and Active Directory.

Confidential, Reno, Nevada

Business Analyst

Responsibilities:

• Implemented Confidential 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 Confidential 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 DB .
• Performed Project Planning, Monitoring, Control, & Execution of Skagen Designs Initiatives.
• Worked with IT Director - Accounting Manager - Purchasing Distribution Manager - multiple software vendors - DBA to deliver critical hardline watch - soft line purse orders on time. Database change control.
• 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 Confidential SQL Reportwriter. Performed backups - restores, data updatesand patches to client computers, conference room pilot - development - instances.

Confidential, 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.
• Signed-off feature changes solutions with consultants, super user, database administrator and IT
• Management. Addressed Oracle RDBMS 8i/9i/10g, SQL*Plus / PLSQL, workflow, data integrity, performance and upgrade issues.

Confidential, East Palo Alto, CA

Quicken Product Leader

Responsibilities:

• 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.
• Project Solutions for Intuit Management and Product Teams
• Tested new product features in Quicken, QuickBooks Small Business, Retail, HR QuickPay
• Payroll, Confidential, Confidential Online, Confidential, Confidential, and Intellicharge Credit Card SaaS.
• Archived User Cases consisting of payment - financials feature changes in Lotus Notes ECM.
• Flowcharts for reports, transaction registers, and check writing code logic.
• Data flow diagrams for standard transaction, memorized transactions, investment transactions