SUMMARY:

• Ten years experience Business Analysis with Accounting, Supply Chain, Sales, Operations,
• Manufacturing, Development, and Service Applications on Oracle Databases.
• Over Ten years of Planning - Monitoring - Control Execution, Revenue Recognition,
• Business Workflows , UAT Testing, SDLC, Data Integration, and Business Intelligence.

WORK EXPERIENCE:

Confidential

Report Analyst IV,

• Collected HRMS Reporting user cases including functional requirements, business case and analyzed requirements in stakeholder meetings. Performed project planning, monitoring, control execution for eBay / Sunrise Systems Organizational and business process improvement initiatives.
• Utilized SAP ECC, BW, Salesforce.com, Workday BI, SharePoint Dashboards and Excel tools to deploy web reports. Reviewed Workday Implementation documentation, SAP operations, and Project Status DRD Meetings.
• Provided data analysis of key metrics - trends in a timely manner, recommend steps to improve efficiency, and effectiveness of global teams, as contracted, centers of expertise, and critical programs. Assisted Sunrise stakeholders with screening and on-boarding functions.

Deliverables for Sunrise Systems and eBayStakeholders:

• Performed GAP Analysis, project review of concept, risk, operations, technical SQL / Object Data
• Dictionary for Workday implementation tasks with eBay Global IT.
• Tested setup of Oracle 10g SQL Plus data integration / work flows from SAP HR Activity Pipeline
• to Workday
• Promoted stakeholder success in global project team round table management meetings.

Confidential

Customer Servic

• Supported ERP Partners- Administrators- DBAs - Consultants with user features, concept testing,
• and implementing Purchasing, Payables, Inventory, Spending Reports and Budgets at Customized
• Coupa Software Sites. Validated configuration changes for successful business implementations.
• Provided system administration for Supply Chain, E-Procurement, Accounts Payable, Inventory
• And SaaS applications on hosted servers using PHP / MySQL, Ruby, New Relic, Ubuntu, Git,
• Database, Windows, BOOMI, and Linux utilities. Created custom analytical reports for process
• execution and spend management. Assisted support manager with managing ticket queues, evaluating business cases and triaging
• escalated tickets. Provided partner management using Microsoft Office, Excel, Google Mail,
• Power Point, Zendesk, and Salesforce.com Tools.
• Participated in Cloud Change Management discussions including system administration,
• planning upgrades, hot patch deployments, network availability, managing test instances,
• and break fix solutions. Reviewed Oracle, SAP, JD Edwards ERP integrations in Databases. Utilized multiple skill sets in troubleshooting customer tickets, managing solution queue, and
• assist with client escalations. Reviewed transaction database tables for process issues. Setup
• Coupa user roles, profiles, approval structure, supplier features. Combed through log files
• for inconsistencies.

Confidential

• Worked with consultants to validate / receive their documents Supplier Questionnaires,
• Order Guide Catalog, Purchase Order Acknowledgement, Advance Ship Notice, Invoices.
• Enabled translation and exchange of electronic documents in cXML or EDI.
• Provided user portal access to suppliers through Coupa interface and to receive or reject or
• accept POs electronically from our customers.

Confidential

Tier III OEM Application Support Analyst

• Collected requirements from Microsoft Business Stakeholders, Subject Matter Experts, Cross Functional Teams. Assisted Developers and MSIT to test and deploy Service Oriented Architecture for Product Activation Fulfillment Orders and Web Service Applications.
• Performed Administration of Microsoft SQL Servers, Middle Tier, OEM and Client Applications User Onboarding. Performed product lifecycle planning activities. Addressed and solved message report production issues and schedule maintained process jobs.
• Subject Matter Expert in knowledge of MSLI SOA backend support SQL as well as front end resolution
• using Microsoft .Net, SOAP, REST, IIS. Updated and maintained Microsoft SQL 2008 Standard /
• Enterprise Database Reporting with Window Server, Configuration Manager, Active Directory, Microsoft
• Management Console, Event Manager, Azure, SQL Server Agent and SSMS / SSIS / SSRS / BIDS.
• Weekend Support: Performed backup, restore, data drops, hot patch updates on User Acceptance
• Testing Databases. Utilized Microsoft SQL Server 2008/2010 Profiler, T-SQL, Query Editor, Access,
• Query Designer, Created / Modified Procedures, SQL Server 2010 Visual Team Studio Team.
• Hosted incident shift handover meeting for ticket triage review twice a day. Mitigated problem management process and ticket review. Performed incident - bug issue review for code release issue reviews for production war room. Reviewed, escalated problem ticket cases and Priority 1 Tickets for Issue Bridge Calls.
• Proactively responded to issues using BAM Business Activity Monitor, Production Scorecard
• with Microsoft SQL Server Report Services. Mitigated issues for Microsoft Silverlight, BizTalk Message Bus Technology including OEM Activation Message Monitoring.
• Performed troubleshooting steps requiring knowledge of multiple contributing factors such as browsers, application code, database configuration, network performance, and linked servers.
• Resolved incident tickets within Benchmark SLA Time to resolve 85 across OEM Support Line 1,
• Line 2, Line 3. Ensured that issues are identified, tracked, reported on and resolved in a timely
• manner. Reviewed SLA Details - Contributing Factors in Shift Production Scorecard.
• Assisted MSIT Business Intelligence Support with meeting SLA Agreements, SQL BI Reporting, SQL Agent Monitoring, SSIS/DTS Process Validation, IIS, XML Parser, Log File Analysis, Company/User Provisioning. Documented project statuses, business improvement, and major incidences using Microsoft Office and SharePoint.
• Demonstrated an analytical and problem solving approach to projects to help assist in team success by duplication of steps, troubleshooting, identifying route cause, and problem management.

Confidential

Delivered business based reports and operational solutions to Microsoft Internal and Partners in Ireland, Reno, NV and Redmond, WA. OEM Partner Product Service Request Escalation Desk, Duty Manager for Global Support Center and Queue Coordinator. Supported ongoing production, user acceptance testing, and performance testing issues with AOC - EOC OEM Support Centers for Shift Handover.

Confidential

Business Analyst - ERP Administrator

• Collected business requirements, reviewed business processes, and submitted business solutions
• to Konami Gaming Planning, Manufacturing, Finance, Operations, Partners, and Corporate HQ.
• Configured new systems to international business requirements. Documented software changes and
• user access changes for System Administration Best Practices and Sox Reporting. Created Financial
• Reports for Deloitte/HQ/KPMG Audits.
• Resolved Sales Order Transaction problems from Pronto Client to Oracle Database with SQL Plus.
• Configured Inventory, Manufacturing, MRP and Forecasting Modules. Setup Sales Orders,
• Purchase Orders, ASN, Service Calls, Rental Contracts, Install Bases for Games - Systems Customers.
• Assisted users with IT with Pronto System, RDBMS, AIX, Client Support, Feature
• Support adhoc reports. Created Gaming Industry Specific Reports, Pronto SQL queries on
• KPI, sales orders, customer, and inventory movements. Reviewed XLCubed, IBM Cognos.

Deliverables

• Upgraded Oracle 10g to 11g, Pronto ERP from Phase 4 to 5 Financials, Inventory, and Slot
• Game Manufacturing.
• Performed Quality Assurance Test Cases for Systems Service, International Sales Orders,
• Supply Chain, Purchase Orders, Assets, and Financial - Projects SAS - Report Writer.
• Administered Pronto Client System Level Changes on Oracle 11g / AIX Servers. Audited user
• and system activities.

Confidential

LIR Tier II Application Support Analyst

• 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
• MS License Information Reporting websites. Assisted financial users with adhoc vendor reports and
• T-SQL queries on purchase order - order entry receivables billing and service databases to meet
• business deadlines.
• Maintained Windows Server 2000/2003 Active Directory, Users and Group Accounts, WINS, TCP/IP,
• DNS settings, Enterprise Manager, and custom security operational solutions for Microsoft MSIT LIR.
• Administered User Databases and Servers in Reno / Redmond. Monitored processes services, log
• shipping, and events
• Reviewed business requirement documents, technical specifications and code for systemic
• Correctness in DTS Designer, 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.
• Built User Acceptance Testing - Performance Environments on SQL 2005 Enterprise Edition linked
• servers with failover clusters. Updated and maintained Microsoft SQL 2005 Enterprise Reporting with
• SSMS / SSIS / SSRS / BIDS/ASP. 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. Completed May Quarter
• Reporting Tasks for End to End Processing, Smoke Test, Regression Test, Stress Test, Failover,
• RAID, and System Test for UAT I, UAT II Instances on time and in scope.
• Utilized Siebel 7 CRM Application to assign - update -monitor -distributed tasks / service
• requests to LIR - EP Microsoft Team Members across global team in Confidential
• Contributed LIR - MSL - SQL solutions in Global Support Team Virtual Meetings.
• Utilized Microsoft Project, VISIO, Microsoft Meeting, Microsoft Office 2007, to
• communicate supply chain project goals - objectives - statuses - completion to
• Headquarters. Generated matrixes for upper management used for system
• performance improvements.

Confidential

• Created Project Scope, Work Breakdown Structure, Deliverables, Activity Lists,
• Milestones, Deadlines, and Status Reports.
• Documented flowcharts for SAP data transformation processes to SQL Server
• target databases.
• Created procedure guides for end to end processing of licenses, agreement, and contracts.
• Distributed data flow transaction diagrams for open orders, purchase orders, and licenses.
• Created entity relationship diagrams for MSLI databases on linked servers.

Confidential

Business Systems Analyst, Corporate Headquarters

• Collected user requirements, business case, analyzed business requirements designed logical
• structure for software configuration - program development. Conducted project meetings to
• document milestones, and to provide status reports to stakeholders on weekly basis.
• Drafted approval criteria with sponsor, stakeholders, subject matter experts.
• Created new business procedures based on user requirements. Coordinated user
• acceptance testing with accounting super users and vendors.
• Implemented Microsoft Dynamics - Great Plains GL /AP /PO /AR /INV, Financial Reporting,
• Credit Card Advantage, Supply Chain Management, Freight Management, and Radio Beacon
• Warehouse Manufacturing Systems feature changes on Microsoft SQL Server 2000.
• Configured GL for Journal Entry, Batch Posting, and Quick Reporting. Performed setups for 1099
• Tax Suppliers, Procedures, and Reporting Entities. Configured PO module for Container
• Receiving, AP Invoice matching, items, and pricing.
• Tested and implemented new freight source charge management module for Great Plains. Reviewed
• and quality tested customizations with Visual C , Dexterity, Visual Basic, and Crystal Reports. Audited
• purchase orders, receiving transactions, container shipments, inventory adjustments from Great
• Plains API to Radio Beacon Database.
• Worked with IT Director - Accounting Manager - Purchasing Distribution Manager - multiple
• software vendors - DBA to deliver critical hardline watch - softline purse orders on time,
• in scope, and under budget to customers.
• Setup help desk software procedures, fielded production issues, and trained super users. Negotiated
• solutions with software vendors and consultants.
• Tracked down problem orders from form - API interface table on T-SQL level. Reconciled credit -
• debit memos, chargebacks, and AR invoice adjustments to AR Aged Trial Balance Detail Report.
• Created or modified existing business service invoice forms and financial reports using
• Crystal Reports and Microsoft SQL Reportwriter. Performed backups - restores, data updates,
• and patches to client computers, conference room pilot - development - training instances.

Deliverables for Skagen Designs:

• Improved Supply Chain B2B processing of orders from 5,000 to 10,000 a day through warehouse.
• Improved Container Shipping to Reno, Denmark, Canada, from Hong Kong by implementing new Purchase Order Inventory operations Matrix Collections software changes.
• Configured Great Plains Receivables Customer setting for Majors - Independent - Corporate - B2B - Web Sales Channels.

Oracle Corporation, Senior Solutions Analyst

Confidential

• Provided mission critical solutions for Oracle 11i/11/10.7 Financials, Supply Chain, CRM, Human
• Resources, Payroll, Project, Expense, Self Service Applications, Hosted Oracle Database SaaS
• issues. Addressed RDBMS Oracle 7/8i data integrity, performance and upgrade issues.
• Coordinated TAR Review Meetings with consultants, users, management
• to review problems and issues causes. Signed-off feature changes
• solutions with consultants, superuser, database administrator and IT Management.
• Assisted Purchasing support with issues on autosourcing, invoice, purchase order
• matching, requisition transaction, EDI, and other supply chain issues.
• Recorded client business specifications for potential feature enhancements. Performed GAP
• analysis. Presented cases for feature changes to Oracle GL/HR/AP/AR/INV/OE Development.
• Escalated bugs and critical functional issues to Oracle Development Management with go-live,
• and customer deadlines.
• Individualized procedural - configuration - patch solutions to premium support, partner, and
• customer's business case - specifications - Oracle Best Practices.
• Identified problem steps to duplicate test cases on customer and development
• instances. Documented cause and effect of issues in bugs for development.
• Pinpointed modules involved via SQL Plus, dial in, forms / reports / PL/SQL, and C source code.
• Researched root cause in documentation, bug,repository, with Accounts Payable development.
• Front Office Support: Performed setup of salesreps, sales organizations, territories for account,
• contact tracking, and assigning territory access to salesreps. Configured Oracle Sales for
• quote generation, sales lead opportunity tracking, correspondence, mail merge, and
• collateral processing.
• Oracle Telesales 3i Alpha and Beta Internal Hotline Support: Assisted consultants in setup
• of workbench, opportunity interactions, and sales contact center features for customer tracking.
• Tested SoftPhone, Telephony, and Call Center programs for Oracle Telesales integration.
• Oracle Sales Compensation 3i - Production Support - Assisted DBAs with interfacing AR Invoices
• and Order Entry transactions based table and view mapping. Defined and modified Classification
• Rules. Created and maintained Sales Hierarchies for Sales Territories. Configured Compensation
• Plans and Rate Tables for compensation calculation.

Deliverables for Oracle Clients, Internal Customers, and Product Teams

• Contributed narratives for Oracle Accounts Payables - Cash Management Payroll -
• Service - Sales for Metalink Website, Online Help Screens, and White Papers.
• Reviewed and edited API flowcharts technical reference manuals for data from Oracle
• Accounts Payables to Purchasing to Cash Management.
• Created procedure guides for Oracle Clients using Accounts Payables, and Sales.
• Reviewed data flow diagrams for Oracle General Ledger and Accounts Payables
• Edited and revised entity relationship diagrams for Oracle Sales, Field Sales Online,
• and Sales Compensation.
• Supported reference clients on Oracle software hardware configurations for Oracle Sales
• Laptop - Handheld versions.

Confidential

• Created business, financial, payroll, and product training documents and certification 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.
• Organized beta test process with QA, Marketing, Product Development,
• and Support. Supervised and trained beta test representatives
• reporting problems to QA / Development, call support, procedures,
• and issue tracking database usage. Online Answer Book editor and
• Online Help author for Quicken for Windows products.

Documentation Supplied to Intuit Management and Product Teams

• Narratives for new product features in Quicken, Quickbooks Small Business, QuickPay
• Payroll, Quickinvoice, Checkfree, TurboTax, and Intellicharge SaaS.
• Flowcharts for reports, transaction registers, and check writing code logic.
• Procedure guides for Quicken, Windows usage, finished product supplements, checks,
• supplies, and fax on demand.
• Data flow diagrams for standard transaction, memorized transactions, investment transactions.
• Entity relationship diagrams for Quicken to QuickPay and Quicken to Turbo Tax.
• Hardware configuration diagrams for Quicken for Windows Products, training center, and testing lab.
• User manuals and other technical illustrations for Quicken for Windows, Quicken Media Editions,
• and OEM Quicken Versions.