SUMMARY

• Over 10 years of in Development (Planning Analysis Design Implementation Phases), Quality Assurance, Support and Implementation of Web Deployed Global ERP SCM CRM HR Apps.
• SQL Data analysis - Business Intelligence - Financial Data Warehouse Systems.
• Involved in all phases of the SDLC from requirements, ERP design, .NET development, testing, implementation and maintenance with timely delivery of SQL datasets, workflows, SQL validation queries and PLSQL procedure scripts against aggressive deadlines.
• Lead elicitation - collection - analysis of use cases by gathering current data - proposed business system and process flow changes for Oracle eBusiness Suite 11i/12i use cases.
• Responsible for Microsoft SOA SaaS 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 development phases of Deltek Infor SAP IBM Coupa WorkDay .NET Data Integration with XML Microsoft .NET, MS SQL Server 2008r2/2012 & Enterprise Solutions.
• Responsible for the impact analysis and project requirements definition phase of the development lifecycle for Microsoft customers.

PROFESSIONAL EXPERIENCE

Confidential,San Francisco, CA

Oracle Data Analyst, iHub Data Warehouse Support

Responsibilities:

• Collected Business Requirements for As - Is Current State for iHub Data Warehouse.
• Performed Oracle scripted task workflow development, quality testing, training, and documentation for end to end processing.
• Mentored junior associates with business uses cases and scripts for Industry-leading analytical methods. Integration of risk, performance management, customer insight, and financial compliance WBDS test cases.
• Performed proof of concept, risk, operations, technical Oracle 11g SQL Developer, SQL*Plus/ Object Data documentations of OFSA, Informatica Source To Target Mapping for Data Warehouse. Dictionary for integration implementation, ETL tasks Staging / Delta with Teradata Wells Fargo IT.
• Provided Cohort Team Support for data lineage, worked backwards through E2E processes to provide solutions and maintained vision of upstream and downstream relationships.
• Verified metadata, balances and transaction data against reference tables for single source of truth.
• Reviewed SOR and Modeled Data / Dashboard Metric Solutions on iHub Oracle Data Warehouse from Bank, Finance, Cash Management, Treasury, Deposits for Loan IQ /Credit IL/CL Stakeholders and Partners.
• Tested user case using SQL Scripts that validated data type, length, precision, scale, PK/FK, null and conditions.
• Promoted stakeholder success in project team round table management meetings for root cause of data use cases.
• Performed planning and implementation of data refresh, frequency and system releases for ETL, DW Maintenance and Finance Operations team.

Confidential, CA

Oracle Data Analyst, Business Operations Support

Responsibilities:

• Elicited, Analyzed, and Modeled Business Requirements for As - IS Current State Analysis for
• Fi$Cal Meetings with Oracle Sub Ledger accounting (SLA) is accounting hub in Oracle Application Release 12i Documented how to derive legacy attributes required to account a transaction in Oracle General Ledger.
• Tested accounting attributes like entered amount, accounted amount, Date, Currency code and the attributes like Ledger, Code Combination ID, Period.
• Documented PO solicitation, bidding, contracts financial transactions and approval process use cases.
• Reviewed data mapping and updated workflows for AP, PO & Cash Management Peoplesoft Implementation.
• Analyzed Impact of Issues, Solutions, SOW and recommended business 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 Medi-Cal Infor Medical Billing Revenue Management System for implementation of state insurance organization.
• Conducted testing of EDI defect fixes, system enhancements, upgrades, including drafting of test Oracle SQL scripts, ODI ELT and scenarios for generation of insurance claim test data.
• Maintained, Managed, & Controlled development, quality testing, training, and staging environments for Data Integration, with Billing, Payments, Lockbox Deposits, and reporting.
• Reviewed technical solutions provide by the AR System vendor for defect fixes and approved CRs.
• Provided claim activity reports with financial check totals, dashboard, KPIs and executive summary.
• 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 claims, deposits and payments management.

Confidential, CA

ERP Data Analyst, Business Operations Support

Responsibilities:

• Supported the ERP system including maintenance, upgrades, testing, user cases, data integration, and implementing new features.
• Worked with the IT Management to manage and document applications, database changes, and user security for PG&E Gas Transmission Projects.
• Reviewed Database Current State - Standard Operating Procedures through elicitation and discovery.
• Monitor, Control, & MS SQL 2008r2 / 2012 Server components to ensure the proper operations of billing system including Microsoft Windows Server, Report Server, Visual Studio .NET & IIS.
• Performed Review of Transaction XML/SQL Data Flow to Vision CRM Reports, Dashboards.
• Modify or Build Project, Contract, Resource Management form workflows using Procedures SSMS/ TSQL Query Editor./ Joins /CTE/ Case/ Data Parameters.
• Build Business Reports, Alerts, Scripts with MVS .NET, SQL Server 2008r2 / 2012 Data Tools ETL /BIDS/SSRS /T-SQL Deltek ERP /CRM /HR /Project Workflows, Grids, & Forms
• Apply project management 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

SQL Consultant for Sunrise Systems

Responsibilities:

• Managed the data processes feeding the recruitment, onboarding, management review, and approval channels.
• Reviewed Project Scope, BRD Requirements, and DRD Data Requirement Documents.
• Delivered timely data analysis and metric reporting.
• Set up and tested On Premise Oracle 10g data integration / work flows to Workday Cloud.
• Performed review of concept, risk, operations, technical SQL*Plus/ Object Data Dictionary for Workday implementation tasks with eBay Global IT.

Coupa Software, Reno, NV

Cloud Operations - Support Analyst

Responsibilities:

• Reviewed, monitored, and controlled SDLC Agile Development. Supported Coupa / Amazon.com Cloud environments with PHP / MySQL, Dell Boomi Connector - Atmosphere
• Testing Tools: Ruby On Rails, Git Hub, New Relic, HipChat, Jira, Salesforce.com & Ubuntu.
• Setup Coupa ERP to validate / receive their billing invoices, purchase orders, supplier options, order guide catalog, PO acknowledgement, and Advanced Shipping Notices for regression tests.
• Netsuite for tracking sales event spending using Procure to Pay, Requisitions, Travel & Expense.
• Delivered key integrations between on-premise Oracle 11i/ 11g SQL*Plus / SAP / JD Edwards
• Developed AP and PO approval workflow solutions for partner use cases.
• Enabled integration, translation and exchange of electronic documents in EDI formats.
• Configured AP, PO, INV, Travel/Expense modules and E-Procurement on Coupa Cloud.
• Developed tested and implemented Cash Management Reports for SaaS Cloud Solutions.

Confidential, Reno, NV

Production SQL Consultant for TEKsystems

Responsibilities:

• Subject Matter Expert in knowledge of SOA backend support (SQL) as well as front end resolution using .Net, XML, SOAP, REST, & IIS. Utilized MS SQL Server 2008r2 /2012 Profiler, T-SQL, Query Editor, E2E, ETL/ SSIS / DTS, Event Viewer, System Monitor
• Microsoft SQL Server 2010 Beta Visual with MS 2012 Team Studio, and Business Intelligence (SSRS, BI, MS SharePoint / Primus).
• Implementation and maintenance of MSIT Production Data Warehouses on Clustered Windows Servers, and MS SQL 2008/2012 servers on SANS drives/networks.
• Effectively made use of Microsoft Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Utilized Microsoft SharePoint, Business Intelligence, SSRS, Microsoft Meeting, Microsoft Office 2013, BizTalk Server 2013, SQL Team Foundation Server.
• Supported ongoing production operations with AOC - EOC OEM Support Centers.
• Managed Windows Server, Active Directory, User / Group Security. Performed SQL DBA functions and maintained SOX records of server security access.
• Delivered business invoice, order processing, service, product fulfillment, computer build reports, and inventory express solutions to Microsoft Internal and Partners in SLA per agreements.

Confidential, Las Vegas, NV

Business Analyst - SQL Administrator

Responsibilities:

• Configured new ERP systems to international user cases / business requirements.
• Performed Data Integrations with Oracle SQL*Plus, Pronto SQL, Flat file, CSV, and Excel Files.
• Tested and documented software changes and user access changes for System Administration.and Best Practice.
• Maintained Central Data Repository Microsoft Office 2010, SharePoint for Sarbanes Oxley Reporting.
• Created Custom Forms and SQL transaction custom reports. Integrated AR data using Oracle SQL SQL*Plus 11 and IBM SQL 4GL.
• 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.
• Upgraded Pronto ERP to Oracle SCM from Phase 4 to 5 Financials, Inventory & Slot Game Mfg.

Confidential, Reno, NV

MSIT, SQL Server Data Warehouse Reporting Tier

Responsibilities:

• Delivered Ad-Hoc reporting / SQL queries for financial users.
• Built data warehouse database environments on linked servers with failover clusters and maintained Microsoft SQL Server 2005 Enterprise Edition.
• Performed backup, restore, data drops, & hot patch updates on User Acceptance Testing Databases.
• Configured ODBC - RDBMS for source data and destination databases.
• Ran SQL Server DTS scripts, procedures, parameters, variables, & functions in SPROCs to load validate processes from factory to repositories.
• Managed Windows Server, Active Directory, User / Group Security. Performed SQL Admin functions and maintained SOX records of server security access.
• Supported the implementation and maintenance of Data Warehouses on Clustered Servers and SANS drives/networks.
• Effectively made use of Microsoft table functions, indexes, table partitioning, data collections, analytical functions, materialized views, query re-write and transportable table spaces.
• Experience with data flow diagrams, data dictionary, database normalization theory techniques,

Confidential

Business Analyst

Responsibilities:

• Implemented Microsoft Dynamics - Great Plains GL /AP /PO /AR /INV, Financial Reporting, Credit Card Advantage, DRP, Supply Chain Management, Freight Management, and Radio Beacon Warehouse Manufacturing Systems.
• Performed data transformation using SQL Server 7.0/2000 DTS, Enterprise Manager, & Server Tools.
• 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 Interface to Radio Beacon WMS DB.
• Debugged ecommerce problem from 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 SQL - Crystal Reports.
• Performed backups - restores, data updates, and patches to client computers, conference room pilot - development - training instances.

Confidential, CA

Business Solution Analyst

Responsibilities:

• Collected user requirements, use case, performed GAP Analysis against business requirements.
• Reviewed Current System State for Business Process Improvement through software configuration.
• CRM Program development for Oracle eBusiness ERP, Cash Management and CRM Applications 10/11/3i/11i Product implementations.
• SDLC, Proof of Concept, prototype development, QA & UAT Testing, Change - Cost Control, Risk Assessments
• Upgrades for Hi-Tech Manufacturing, Automobile SCM, Finance, Software, Internal, Hosted & DOD/DOE Government clients.
• Performed Oracle 11.5.8i/11/10.7 change control throughout SDLC for Financials, Supply Chain, CRM, Manufacturing, Human Resources, Self Service Applications, ECM, SOA & SaaS.
• Addressed Oracle RDBMS 8i/9i/10g, SQL*Plus / PLSQL, workflow, data integrity, performance and upgrade issues.
• AMAT Help Desk: Addressed setup and technical performance problems for data center, consultants and international super users.
• Involved in all phases of the Oracle AP/GL/FA SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against go-live and production deadlines.
• Developed Complex Oracle database objects like Stored Procedures, Functions, Packages, Reports, Forms, and Triggers using SQL, SQL*Plus, Oracle Developer and PL/SQL 8/9i/10g.
• Client-Server Foundation Application Administration SQL*LOADER, SQLDBA, & Oracle Developer.