SUMMARY

• Worked directly with executive team members to understand and define the an enterprise analytics KPI strategy that would provide the leadership team members with key performance indicators related to their business area
• Responsible for building the governance framework to manage and support the enterprise KPI solution and its processes
• Responsible for designing the end to end KPI solution and framework to support the strategy
• Led the effort to get different business departments to agree on a common definition of a business term from an enterprise perspective to allow for more accurate analytics and understanding of data
• Defined and built practices and processes to be used for data governance to ensure data quality is measured and reported accurately
• Lead architect on global vendor management project, responsible for designing and implementing a framework using service oriented architecture to integrate partner data collected online with back office different applications and systems for Nintendo Corporate, Nintendo of Europe and Nintendo of America.This solution enabled Nintendo to improve the relationship with developers and publishers and enabled all three Nintendo organizations to deal with partners from a global rather than regional perspective
• Responsible for designing and implementing the solution and framework that allows retailers to purchase digital game codes directly from Nintendo of America using rest services, which significantly cuts inventory costs for retailers and significantly reduces processing and billing costs from a Nintendo perspective
• Lead services architect on Phase 2 of the systems modernization project, responsible for designing eCommerce and back office services required to support all business operations and support the volume of transactions during peak business season
• Worked directly with the finance team to define and build a strategy to modernize the online global payment processing platform to enable future growth and reduction of costs and secured funding for this project after presenting to the executive team.
• Lead architect, acting technical lead and acting project manager on the implementation of the payment processing modernization project
• Closely worked and built relationships with team members across all the different organizations within Nintendo of America and contributed to improving the perception of IT from business department leads by focusing on communication, relationship building and customer service
• Led road shows for department and organization leaders to present new initiatives and solutions as well as the impact they would have on their departments and processes
• Key role and involvement in almost every key initiative defined by the executive management team during my time at Nintendo of America
• Worked across the isles within the IT department to discuss, review and validate new solutions as well as discuss time and resource impacts and commitments from each team
• Participated in several steering committees, governance boards and strategy building meetings
• Presenter and speaker at Oracle Open World conference representing Nintendo of America(NOA) and the implementation and use of Oracle Fusion Middleware at NOA

Operating Systems:  UNIX Sun Solaris, HP - UX, LINUX, AIX, Windows and iOS

Database Tools:  Oracle Warehouse Builder, Toad, SQL Navigator, Developer 2000, SQL Plus

Oracle Applications Business Knowledge:  General Ledger, Payables, Fixed Assets, Purchasing, Inventory, Order Management (Financials), Receivables, Install Base, Service Contracts, Human Resource Capital Management, System Administration and Workflow, Channel Revenue Management, Business Revenue Management, Intellectual Property Management, Oracle e-Commerce

Oracle Applications:  Oracle e-Business Suite 11i and R12, Oracle BRM, Oracle IPM, Oracle Fusion Middleware, Oracle CRM (Seibel UCM), Product Hub

Oracle Database and tools:  8i/9i/10g,11g, 12c, SQL/PLUS, PL/SQL, SQLNet, Oracle Workflow, ADI, RMAN and Data Guard, Golden Gate

Oracle Application Server:  Oracle SOA Suite 10g and 11g, Oracle B2B, Oracle Application Server 10g  

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Senior Architect/Technical Lead

• Architect, technical lead and manager for phase 1 of multi phase, 30 million dollar, systems modernization project focused on replacing legacy applications with Oracle eBusiness Suite and Oracle SOA Suite at a global entertainment and gaming company.
• Built and implemented a governance framework, processes and Middleware team generally focused on Service Oriented Architecture and specifically focused on Oracle Fusion Middleware
• Led, mentored and managed the project development team consisting of 30+ members that were located both on site and off shore.
• Responsible for mentoring and coaching client team members in regards to development standards, SDLC, deployments and Oracle Applications and troubleshooting.
• Responsible for designing solutions to meet business requirements and resolve business process issues.
• Worked closely with both the technical team and business users throughout the development life cycle to ensure on time delivery of over 70 items including conversions, extensions, interfaces and workflows.
• Worked closely with the DBA and System Administration teams to ensure availability of instances.
• Led and managed the team responsible for designing and building the cutover plan as well as the successful execution of the cutover plan resulting in a successful go live on time
• Responsible for workflow design and development as well as deployment strategy.
• Led design sessions to come up with solutions for complex extensions or interfaces.
• Responsible for code and document reviews.
• Conducted road shows to introduce and inform client team members in regards to Service Oriented Architecture, its benefits and its challenges in comparison to the traditional point to point legacy methodology

Technical Lead

• Technical Lead for an iProcurement and iExpense implementation at a Financial Services company
• Responsible for managing technical team, deliverables and project plan
• Responsible for creating architecture, instance management, standards, and technical design documents
• Responsible for building the cutover plan and executing cutover successfully
• Led design sessions for complex RICE components and was acting architect responsible for designing and the solution
• Coordinated discovery sessions to gather requirements from business and technical users.

Project Manager/Technical Lead

• Technical Lead and Project Manager for a SOA Proof of Concept at the nation’s largest supplier of building materials.
• Responsible for managing deliverables, project plan and designing the File Processing Services Framework which will enable the company to integrate with its existing suppliers and vendors and allow them the flexibility of future adding future partners with little or no code modification, designing their HAA SOA solution using Oracle RAC and Application clustering topologies and implementing the proposed BPEL processes.
• Installed and configured Oracle SOA Suite using Oracle’s recommended topology for High Availability Architecture
• Responsible for creating architecture, instance management, standards, and technical design documents

Technical Lead

• Technical lead and systems architect for an Oracle 11.5.10.2 Order to Cash implementation at a global software company.
• Managed the Oracle development team consisting of 20 members throughout the full life cycle of the project which lasted 18 months.
• Responsible for designing solutions to meet business requirements and resolve business process issues.
• Worked closely with both the technical team and business users throughout the development life cycle to ensure on time delivery of over 150 extensions, interfaces and reports.
• Worked closely with the DBA and System Administration teams to ensure availability of instances.
• Responsible for designing and building technical team cutover plan as well as the successful execution of the plan, which lead to a successful go live with no critical or major issues.
• Responsible for release management, and performance tuning.
• Part of team responsible for designing and implementing a fully integrated system involving Oracle ERP, Seibel, UCM, Web Portals and Digital River using Oracle’s Fusion Middleware.
• Responsible for instance management and planning, and HAA design.
• Responsible for workflow design and development as well as deployment strategy.
• Coordinated discovery sessions to gather requirements from business and technical users.
• Led design sessions to come up with solutions for complex extensions or interfaces.
• Responsible for code and document reviews.

Senior DBA/Principal Consultant/ Oracle Applications Sr. Database Administrator / Technical Architect

• Responsible for analyzing multiple clients’ 11i environments, making overall recommendations in regards to their patching, development, maintenance, performance, backup and recovery processes and implementing these changes
• Installed and configured Oracle 10g Application servers which hosted multiple scientific applications and acted as a web portal for a leading scientific institute
• Maintained over 30 production databases; duties included cloning, backup, patching and monitoring
• Installed and configured Oracle Applications on Unix, Linux and Windows
• Configured Data Guard solution to increase instance availability during maintenance windows, and to off load user queries and reporting onto another instance which helped improve overall performance
• Installed and configured Oracle 10g Enterprise Manager Grid Control to monitor over 30 databases
• Installed and configured Oracle Discoverer to be used as an ad hoc reporting tool for super users
• Upgraded multiple databases from 8i to 9i, and from 9i to 10g
• Lead DBA in People Soft upgrade project
• Responsible for diagnosing performance issues at multiple clients, recommending solutions and implementing these solutions which resulted in significant performance improvements in specific processes and overall system response
• Responsible for knowledge transfer to clients, system configuration documentation and overall system health check diagnosis
• Lead DBA and Technical Architect for an AR Implementation project, going live within a 12 week time period, responsibilities included module installation and configuration, patching, cloning, trouble shooting application issues and the design of the customer and invoice interface processes
• Responsible for recovery of 40 gigs of space from APPLSYS schema through schema rebuild and recovery of corrupted data files
• Assisted in the upgrade of Oracle E-business suite from 11.5.7 to 11.5.10

Senior DBA/ Oracle Applications Sr. Database Administrator

• Experience in oracle database and oracle applications (Financials) installation, migration, patching and upgrade; database design, creation and configuration, db sizing, capacity growth planning, monitoring, audit; backup and recovery
• Part of the team responsible for upgrading client from 11.5.7 to 11.5.9 on oracle 9.2.0.5 databases
• Kintana application administrator and responsible for migrations to QA and Production Support environments
• Part of the performance team, responsibilities included identifying problem SQL, root cause analysis and SQL/DB tuning using trace files, statspack analysis, Quest tools and monitoring of oracle tables and views
• One of the main members in the team responsible for improving and testing real-time transactions performance such as payment authorizations and order placement to achieve a goal of 40 transactions per second
• Responsible for cloning environments using rapid clone, hot backups and manual cloning
• Responsible for patching environments and maintaining a patch log and process
• Upgraded database from 9.2.0.3 to 9.2.0.5 on all development and QA instances
• Developed multiple database monitoring scripts to notify/page DBA group using a combination of shell scripting and PL/SQL
• Helped in partitioning of workflow tables using scripts, verifying functionality of the applications, and measuring performance improvements before and after partitioning
• Worked closely with functional and development team members to identify and resolve any application or user issues
• Key member of the team responsible for POC for a purge and archive solution after go live to cut down on storage costs and improve overall system performance
• Integrated Vertex for Oracle Payroll
• Supervised and trained Jr. DBA

Jr. Database Administrator

• Installation and configuration of Oracle Applications (Financials) - 11.5.7 on oracle 8i databases
• Daily activities included troubleshooting and resolving user issues or problems, patching, cloning, and monitoring all development and production oracle apps environments
• Responsible for developing monitoring and hot backup scripts to be used for daily clone of reporting instance
• Installed and configured ADI to be used within a CITRIX Metaframe environment
• Performance tuning and maintenance for production database
• Set up the appropriate environments for the development staff to start customizations
• Upgraded Workflow 2.5 to 2.6.1
• Developed custom packages to load data into interface tables using SQL loader and concurrent requests
• Responsible for managing TARS with oracle support and providing DBA support for open issues
• Analyzed patches and their pre-requisites to determine their affect on code customizations
• Completed knowledge transfer and documentation before rolling off project

Confidential,Irvine, CA 

Senior Consultant / Jr. Database Administrator

• Assisted in the migration of 47 gigabytes of data from relational databases to hybrid XML/relational Oracle databases
• Led requirements gathering, design, migration and mappings meetings and documentation
• Designed and developed migration plan and strategy to implement initial migration PL/SQL and Oracle tools
• Designed and developed PL/SQL packages responsible for conversions and migration for PO, SO, TO, CS, MBL and FCR
• Developed interfaces to transform relational EDI data to the companies standard transactional XML formats
• Technical responsibilities included database administration, workflow management and development, Oracle Portal development for showcasing the environment and portal capabilities
• Assigned with AOL responsibility, including security, user setup, concurrent programs, and user training
• Worked closely with end-users to analyze the requirements for the environment and how to transfer that knowledge and business processes to the Oracle 11i environment to truly represent a realistic environment

Workflow Lead

• Responsible for all workflow modifications for order management and engineering modules
• Developed ECO workflow for black ball voting and added notifications and approval processes
• Modified existing OM workflows to match the clients business processes
• Assisted with OM module configuration and setup

Functional/Technical Lead

• Key member in core team of 4 who pioneered the eHub B2B system in a 12 week rapid implementation environment
• Worked closely with Cisco users to gather system requirements and design a methodology for transaction communication throughout the supply chain process using Netfish technologies and XML for transaction definitions
• Assisted in the definition of Ciscos XML Partner Interface Processes (PIPs) using Rosetta Net standards and definitions
• Designed and developed eHub Oracle data integration and reporting tools
• Designed and developed methodology and scripts for extracting inventory, product master, sales order and invoice data from Oracle ERP databases according to Cisco’s PIPs and load data into eHub
• Designed and developed internal web applications using Java servlets using Oracle database as a back end

Functional/Technical Lead

• Module lead for purchasing module, responsible for gathering requirements from purchasing department and users, process streamlining, module configuration and setup, unit and integration tests as well as super user training
• Key person for Oracle Workflow modifications, customizations and questions
• Designed and developed GL conversion programs for all journal entries and period balances. This included developing Shell scripts, SQL Loader scripts, and PL/SQL Procedures & functions
• Responsible for methodology and scripts for extracting data from Oracle (OE, AR) into the company’s DW, using SQL Servers Data Transformation Services which reduced development time by 50%
• Created web-based customizations for Oracle Self Service Expense
• Assisted payables team with workflow creations, module setup and configuration as well as custom reports development
• Designed and Developed web-based PL/SQL Package to display daily Shipping and Invoicing transactions using Oracles Web Development Toolkit
• Gained good business & functional understanding of Order Cycles and Invoicing Processes

Functional Consultant

• Module co-lead for the purchasing team, responsible for gathering requirements, business process re-engineering, module customization, testing, employee training, knowledge transfer and support
• Oracle Workflow developer, responsible for analyzing and implementing customizations for workflows, creating new PL/SQL procedures and functions and creating and modifying notifications
• Responsible for integration testing with inventory, accounts receivables and payables.
• Developed customizations to Oracle Forms events (via Custom.pll)
• Designed and developed concurrent processes for inventory
• Developed custom automated reports for AP super users and trained on understanding and using reports
• Key person charged with training users on requisitions and purchasing (individually trained 60+ users)