SUMMARY:

Business Analyst with over fifteen years’ experience with Administration of Manufacturing, Supply Chain, Financial Applications, ERP, and Service on Databases.

TECHNICAL SKILLS:

APPS: Oracle Applications 9x/ 10x/ 11x/ 3i/ 11i, SAP ERP, ECM, SaaS, Siebel 7 CRMMicrosoft Dynamics - Great Plains 8.0 Accounting, Radio Beacon WMS 3.5, SOA Lotus Notes, Microsoft Office - Project - Word - Excel - PowerPoint - Visio -FrontPage - Access - SharePoint 2007, Project Server 2007, Paradox 2/ 3.5, DBASE II/ III, Q&A 4.0

Platforms: Windows Client version 3.x /95 /98 /NT /2000 /XP /Vista/7, MSDOS, NECWindows 2000/ 2003/2012 Server, MOSS, Open UNIX, Sun Solaris, VMS, HP, FujitsuHitachi Data Systems, IBM AIX, IBM OS/2 Warp, Red Hat LINUX 6/7/8, Apple Finder

RDBMS: Microsoft SQL Server 2008 / 2010, Enterprise Manager, Query Analyzer, 2010 Profiler, Query Editor, SQL Server 2010 Visual Team Studio Team, 2005 SQL Profiler, Visual Studio 2005, SQL Reportwriter, ETL, DTS, MSSMS, Microsoft Business Intelligence, XLCubed, Cognos, Big Machines SAS, Oracle Database Server 6/7/8i/9/10g/11g, SQL Performance Tuning

Programming: SQL, SQLPLUS, PLSQL, T-SQL, HTML, XHTML, Javascript, XMLWMI, Oracle Designer 2000 Forms & Reports, Crystal Reports 9/ 10, Pronto 4glASP, SANDISK, RAID, Visual Basic .NET Framework 2.0, FORTRAN, C/C++ Oracle Designer 2000 Forms & Reports, Crystal Reports 9/10

WORK EXPERIENCE:

Confidential, Reno, NV

Business Analyst

Responsibilities:

• Collected user requirements, business case, analyzed business requirements - designed logical structure for software configuration.
• Configured Coupa AP, PO, INV, E-Procurement, Documentationand Cash Management Reports for SaaS Cloud Start-up.
• Utilized multiple skill sets in troubleshooting cloud tickets, manage solution queue, and perform system admin.
• Reviewed transaction database tables for B2B process issues.
• Setup Coupa user roles, profiles, approval structure, & features. Combed through log files for inconsistencies.
• Performed smoke, sanity, system, and regression tests for beta, test, production on agile development
• Coupa / Amazon.com Cloud environments with PHP / MySQL, Dell BOOMI, Git, New Relic, Jira& Ubuntu.
• Executed SQL API integration tests with on premise Oracle / SAP / JD Edwards ERP too.
• 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. Deliverables for Coupa Spend Management E-Procurement Stakeholders:
• Performed erp db administration to validate / receive their documents Supplier Questionnaires, Order Guide Catalog, Purchase Order Acknowledgement, Advance Ship Notice, Invoices.
• Enabled integration, translation and exchange of electronic documents in EDI.
• Provided portal access to suppliers through Coupa interface and to receive or reject or accept POs electronically from our customers.

Confidential, Reno, NV

Business Analyst

Responsibilities:

• Supported ongoing production, smoke, sanity, user acceptance, and performance testing issues with AOC - EOC OEM Support Centers for Shift Handover.
• Collected requirements from Microsoft SAP AR/ SCM Users, OEM Manufacturers, MS StakeholdersSubject Matter Experts, Developers, and delivered channel revenue SaaS solutions to Cross Functional
• Teams to Support MS IT Worldwide Data Center Operations in Dublin/India/China.
• Subject Matter Expert in knowledge of MSLI SOA backend support (SQL) as well as front end resolution using Microsoft .Net, SOAP, REST, & IIS.
• Utilized MS SQL Server 2008/2012 Profiler, Query Editor, SSIS / DTS, Event Viewer, System Monitor, SQL Server 2010 Beta Visual Team Studio Team, and Primus ECM.
• Addressed and solved message report B2B breakfix production issues for schedule maintained process jobs.
• Performed troubleshooting steps requiring knowledge of multiple contributing factors such as browsers, application code, database configuration, network performance, data integration, and linked servers.
• Reviewed business 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.
• Utilized Microsoft SharePoint, Business Intelligence, SSRS, Microsoft Meeting, Microsoft 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.
• Demonstrated an analytical and problem solving approach to projects to help assist in team success by duplication of steps, troubleshooting, identifying root cause, and problem management. Performed incident - bug issue review for code release issue reviews for production war room.
• Reviewed, escalated problem ticket cases and SAP COE Priority 1 Tickets for solutions in Issue Bridge Calls.
• OEM Partner Product Service Request Escalation Desk, Duty Manager for Global Support Center and SOA Queue Coordinator.
• Resolved incident tickets within Benchmark SLA Time to resolve 85% across OEM Support Line 1, Line 2, Line 3.

Confidential, Las Vegas, NV

Business Analyst - Planning Administrator

Responsibilities:

• Assisted users with IT with testing Pronto System, Oracle 11i RDBMS, AIX, Client Support, Newly Implemented Features & adhoc reports. Created Gaming Industry Specific Reports SQL queries on KPI, sales orders, customer, and inventory movements. Reviewed and evaluated Big Machines Configurator, XLCubed, Cognos, and Check Security software.
• Subject Matter Expert with Supply Chain, MTO, Discrete Manufacturing, MRP, and Purchasing.
• Provided technical support to ERP, CRM, SaaS and on Oracle based computer systems. Performed
• Technical Support for Las Vegas, Sydney, and Los Angeles application users. Assessed user needs, investigated hardware and provided software solutions.
• Configured new systems to international business requirements. Documented software changes and user access changes for System Administration Best Practice, Central Data Repository
• Microsoft Office 2010, SharePoint, and Sarbanes Oxley Reporting.
• Resolved Sales Order Transaction problems from SAP / Pronto Client to Oracle Database.
• Configured Inventory, Manufacturing, MRP and Forecasting Modules. Setup Sales OrdersPurchase Orders, ASN, Service Calls, Rental Contracts, Install Bases for Games and Systems Customers.
• Drafted feature sign - off approval criteria with sponsor, stakeholders, and subject matter experts.
• Created new business procedures based on user requirements. Coordinated user acceptance testing with accounting stakeholder and vendors.
• Performed Project Management, Product Lifecycle Planning, Cost Benefit Analysis ROI, Financial Analysis.
• Directed Cost Initiatives, Business Process Improvement, and Performance Audits.
• Deliverables for Konami BPI Initiatives, Sarbanes Oxley, and Stakeholders:
• Upgraded Pronto ERP from Phase 4 to 5 Financials, Inventory, and Slot Game Manufacturing
• 3 month early and tripled game shipments out of Las Vegas / Australia.
• Performed Quality Assurance on User Test Cases for Systems Service, International Sales OrdersSupply Chain, Purchase Orders, Assets, and Big Machines - Projects - ADP - Cognos Report Writer.
• Performed Data Integrations with Oracle SQL, Pronto SQL, Flat file, CSV, and Excel File Exchange.
• Administered Pronto Client & System Level Changes on Oracle 11 / AIX Servers to SOX Nevada State Gaming Compliance.
• Audited user roles and system activities to HQ Specs.
• Demonstrated ability to effectively test, diagnose and resolve end user desktop hardware, Windows, AIX, Windows Server 2003 OS and application problems.

Confidential, Reno, NV

Business Analyst

Responsibilities:

• License Information Reporting Development, and offshore DBAs to improve end to end processing of Purchase Orders - Sales Orders - Fulfillment - Licensing - 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 - repositoriesand to business intelligence reporting on MSLI websites.
• Assisted financial users with adhoc vendor reports and SQL queries on purchase order - order entry receivables billing and service databases to meet business deadlines.
• Worked with business project owners, development team and release services analysts to identify cutting edge technology and hardware which will enhance and may be leveraged into existing or new projects. Delivered business based operational solutions to Microsoft
• Built User Acceptance Testing - Performance Environments on SQL 2005 Enterprise Editionlinked 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.
• Utilized Siebel 7 CRM Application to assign - update -monitor -distributed tasks / service requests to LIR - EP Microsoft Team Members across global team in Redmond, RenoEurope, China, and India.
• 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 - E2E process completion to Headquarters.
• Generated matrixes for upper management used for system performance improvements.

Confidential

Business Analyst

Responsibilities:

• 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.
• Completed May Quarter 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.
• Created Project Scope, Work Breakdown Structure, Deliverables, Activity ListsMilestones, Deadlines, and Status Reports.
• Demonstrated working knowledge of XP/Vista Windows, PC hardware and the client operations.
• Demonstrated working knowledge of Windows Server NT, 2000, 2003 networking to include: routers, switches, firewalls, network protocols (TCP/IP) and core services such as DNS, DHCP, WINS, Group Policy, and Active Directory.

Confidential, Reno, Nevada

Business Analyst

Responsibilities:

• Implemented Microsoft Dynamics - Great Plains 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.
• 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.
• Audited purchase orders, receiving transactions, container shipments, & inventory adjustments from Great Plains API to Radio Beacon WMS DB.
• Worked with IT Director - Accounting Manager - Purchasing Distribution Manager - multiple software vendors - DBA to deliver critical hardline watch - soft line purse orders on timein scope, and under budget to customers.
• 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.
• 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 - 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 updatesand patches to client computers, conference room pilot - development - training instances.
• Improved Supply Chain B2B processing of orders from 5,000 to 10,000 a day through warehouse.
• Conducted round-table brainstorm discussions for improving IT service, implementing changes, and system confidence.
• Demonstrated working knowledge of XP/2000 Windows, PC hardware and the client operations.
• Demonstrated working knowledge of Windows Server NT, 2000, UNIX networking to include: routers, switches, firewalls, network protocols (TCP/IP) and core services such as DNS, DHCP, WINS, Group Policy, and Active Directory.