PROFESSIONAL SUMMARY:

• Analyze, and document business requirements for Joint Application Design project proposals including, but not limited to Business Process Re - engineering, data interfaces, security, and requirements.
• Translate customer needs BRM into FSD GUI/UX functional and TSD Technical Design process requirements.
• Responsible for business-to-systems analysis, technical support and problem-solving analysis of complex management project reporting and public sector business issues.
• Able to work at a high functional, analytical technical level and guide other analysts on all phases of systems analysis.

PROFESSIONAL EXPERIENCE:

Business Systems Analyst

Confidential, San Francisco, CA

Responsibilities:

• Performing business system analysis, requirements gathering. current data and proposed business process flows.
• Utilized Microsoft Office 2007, 2010 or 365 Word, PowerPoint, Excel and SharePoint for Business Analysis Documentation.
• Translate customer needs into functional requirements. Elicit, analyze, and document business requirements for project proposals including, but not limited to, process and data flows, user interfaces, security, and report requirements.
• Responsible for business-to-systems analysis and problem-solving analysis of complex management reporting and business issues. Able to work at a high functional and technical level and guide other analysts on all phases of systems analysis.
• Responsible for the impact analysis and project requirements definition phase of the development lifecycle for bank data customers.

Confidential, San Francisco Bay Area, CA

Snr. Business Analyst, Data Warehouse Support

Responsibilities:

• Collected Business Requirements for As - IS Current State. Performed scripted operations development, quality testing, . 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 iHub Oracle Data Warehouse from Bank, Finance
• (Tradeworks), Treasury, Deposits for Credit IL, CL Stakeholders and Partners using SQL Scripts that checked data typelength, precision, scale, PK, FK, SK, blank, and null 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 SDLC, planning and implementation of data refresh, frequency and system releases using Jira for
• Teradata, SQL Server, Oracle Data Warehouse Maintenance and Finance Operations team.
• Deliverables for San Francisco Financial Stakeholders:
• Performed proof of concept, risk, operations, support of 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.
• Created test plans including E2E, Regression, RTM Requirement Traceability Matrix, Proof of Concept Tests.
• Promoted stakeholder success in project team round table management meetings for Jira, Project, Profit, Cost View,and

Confidential, CA

Business Analyst, Business Operations Support

Responsibilities:

• Documented Cash Management Peoplesoft Implementation One - On-One, JAD, BRM, TSD, Session
• General Services, Treasury. Provided Current State -New Solutions in Microsoft Office, Excel Pivot ChartsSharePoint and Visio for Fi$Cal Complex Project.
• 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 state insurance organization. Conducted testing of defect fixes, system enhancements, upgrades, including
• Deliverables for California State Stakeholders:
• 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, and staging environment administration.
• Worked with client staff and new system vendor to complete root cause analysis for the Infor AR Billing.
• Administered Medi-Cal 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, Salt Lake City, UT

Business Analyst, Human Resources Operations Support

Responsibilities:

• Collaborated with eBay WorkDay Implementation Team to define SAP My HR 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 HR 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 teamsas contracted, centers of expertise, and critical programs.
• Utilized SAP ECC Datasets, BW, Salesforce.com, SharePoint Dashboards and Excel tools to deliver improved Workday, Payroll Benefits, Pension Reporting, HCM BI SaaS, Business Intelligence, HCM Reports to executive management.
• Deliverables for Sunrise Systems and eBay Stakeholders:
• Authored and edited SOW, BRM, DRD, FSD, TSD, and test plans for Complex Projects during SDLC
• Tested setup of Oracle ERP 10g data integration, work flows from Large Data SAP End-to-end Data Warehouse
• Technology for HR Benefits Activities. Validated 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 consolidation and data use cases.

Confidential, Reno, NV

E-Procurement Business Analyst

Responsibilities:

• Supported Coupa SDLC 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, UAT and performed Cloud system administration. Reviewed transaction database tables for B2B process issues. Coupa AP user resource / subject expert 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.
• Deliverables for Coupa Spend Management E-Procurement Stakeholders:
• Performed Confidential Technical Writing for User Manuals, Technical Support Site, Chat, Blog and Online Help.
• 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 data processing using EDI.

Confidential, Reno, NV

Business Analyst

Responsibilities:

• Collected financial reporting requirements from Microsoft SAP AR, Supply Chain Management Users, OEM Manufacturers for
• Windows 8 Surface, MSIT Stakeholders, Developers, and delivered channel revenue use cases. 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 data processing tools, Event Viewer, System Monitor, SQL Server 2010 Beta Visual Team Studio Team and Business Intelligence (SSRS, BI, SharePoint).
• Deliverables for Teksystems 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 SaaS SOA Data Integration A

Confidential, Las Vegas, NV

Business Analyst - Planning Administrator

Responsibilities:

• Performed Application Administration, Project Management, Change Control, Cost of HR Benefit - AnalysisGAP, Financial Analysis. Directed Cost Initiatives, Business Process Improvement, Risk Assessment, and Performance
• Audits for HQ Compliance, KPMG, Deloitte, Nevada State Gaming Board.
• Performed JAD, Quality Assurance on User Test Cases for HR, Front Office, Systems Service, International Sales OrdersSupply Chain, Purchase Orders, Assets, Service Repairs, and Contracts - Projects ADP Payroll Data Processing Tools
• Cognos Report Writer. Created custom KPI reports for HQ, Operations, KPMG and Deloitte Audits.
• Deliverables for Konami BPI Initiatives, Sarbanes Oxley, and Stakeholders:
• Administered Pronto Client & System Level Re-Engineering 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

Business Analyst

Responsibilities:

• Teamed up with Microsoft Retail, Volume Licensing, SAP Super users, Tier I Technical 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 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 purchase order, 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 2003, 2007.

Confidential, Reno, Nevada

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, confer