SUMMARY:

Track record of success delivering complex software development projects working with teams across multiple disciplines in a geographically dispersed organization and driving all aspects of Enterprise Solution product delivery including design, development, quality assurance, and scheduling. Broad technical background drives the development of information and database systems to optimize the use of existing infrastructure, maximize individual productivity, and help the company reach their full technological potential.

EXPERTISE IN:

• System Integration
• Recruit and Hire
• Architecture
• Technical Process Improvement
• Refine Best Practices
• Project Management
• Solution Design
• Resolve Client Issues
• Software Development
• Team Leadership
• Identify Opportunities
• System Design
• Technology Evaluation
• Shares knowledge with others with presentation.

TECHNOLOGY PORTFOLIO:

Programming Languages: PL/SQL, SQL, C, Pro*C, Java, Cobol, Basic, Assembler, Unix shell scripting

Databases: Oracle 8/ 9/ 10/ 11/ 12, Progress

Operating Systems: Unix, AIX, Solaris, Linux

Tools: PL/SQL Developer, SQLDeveloper, Toad, JDeveloper, Oracle Workflow, Oracle XML Message Designer, Oracle BI Publisher, MS Office Suite, MS Project, ERWin Data Modeler, Salesforce

PROFESSIONAL EXPERIENCE:

Confidential, Davenport, FL

Responsibilities:

• Customers, Accounts Receivables.
• Designed and developed an interface to import customers accounts, contacts, addresses into EBS from external system. The interface was to be used for initial customer load and on - going maintenance.
• All new customers were placed on hold in the interface tables for business review, WebADI was used to review and update the required mappings to existing customers.
• Developed shell scripts to aid in the migration of code and application setup.
• Migration planning.

Confidential, Plano, TX

SOLUTION ARCHITECT

Responsibilities:

• Architect solutions for new and existing customers using the Oracle technology stack.
• Managing on-shore and offshore resources for technical projects.
• Liaising with customers business and technical teams to ensure that requirements as understood and that the design meets the requirements.
• Due to a company wide upgrade to the latest version of Java the customer needed to upgrade an existing Forms 10g application to the latest version of Forms 12c.
• Coordinated the migrating for an Oracle Forms 10g application to Forms 12c utilizing both on-shore and off-shore resources.
• Resolve technical issues with Forms configuration.
• Project was delivered on time and on budget.

Confidential

Responsibilities:

• Implementation of iProcurement and Vertex to be rolled out to 400+ branches.
• Rollout to all branches took longer than anticipated due to business constraints and additional requirements raised by the branches as they were implemented.
• Completed setup and testing of Vertex.
• iProcurement, Purchasing, Payables.
• Personalized and extended existing OAF pages, including new business logic for the existing Java controllers, created new pages.
• Modified PO approval to send notifications back to the original requestor.
• Setup multiple stores, approved supplier lists.
• Modified requisitions OAF page with new business logic, developed new OAF page to show PO approval history.
• Defined multiple personalization’s on the OAF pages.
• Developed a custom approval process using AME.
• Integrated payables with Vertex (eBTax and geography setup as well as Vertex configuration).
• Provided guidance on setting up Approvals Management (AME) for purchase requisitions when using a smart form from iProcurement. Based on the values from the smart form the requisition needed to have multiple FYI notifications sent and then be routed to multiple parallel approvers. All purchase requisitions need to be routed up a management chain depending upon the dollar value of the requisition.
• iProcurement, Approvals Manager
• Requisition Approval
• Designed and developed prototype procedures to be used in Approvals Manager to generate the required management chains.
• Setup smart forms to be used as Non-Catalog requisition types, information captured on the smart forms determined the approval hierarchy.
• Migration from a file based B2B integration to using EBS XML Gateway for Purchase Orders and AP Invoices to/ from external suppliers.
• Integrations were required to utilize existing FTP processes.
• Configured and extended the standard Purchase Order (Out) XML transaction conforming to OAGIS extension standards.
• Configured and extended the standard Invoice (Inbound) XML transaction.
• Designed and developed a process to import the XML file that was received on the FTP server.
• Designed and developed a process to capture the outbound PO transactions and save them as a file to be sent to the FTP server.

Confidential

Responsibilities:

• Liaison between business users and offshore development team.
• Planned and monitored report conversion.
• Coordinated OBIEE updates between on-shore and offshore teams.
• Reviewed data model changes with developers and client.

Confidential

Responsibilities:

• Consolidation of 7 Oracle databases into a single instance using the Virtual Private Database (VPD) concept to ensure data segregation and minimize the application code changes.
• Designed and developed the creating and application of the VPD context, due to existing procedure a small number of Oracle views were required to be modified to support the data segregation.
• The design required only configuration changes to the existing applications that accessed the 7 Oracle databases.
• Participated in the performance testing and tuning of the consolidated database.
• Designed and developed database objects to support high traffic e-Commerce web site.
• Collaborated with on-shore & offshore teams to support development and testing.
• POC with Apache Spark, Python and WSO2 Complex Event Processing engine to support new functionality within the e-Commerce web site.

Confidential

OBIEE Security architect

Responsibilities:

• Security need to be implemented to ensure that a customer only had access to their data and also depending on the type of customer would determine the set of dashboards & reports that were available.
• Prototyped security solution to enable AD to display member specific BI dashboards and reports.
• Implemented security solution in production.
• Developed JavaScript to enable BI Publisher reports to open on mobile devices.
• Integration between Salesforce and EBS - prototyped a solution to enable integration between Salesforce and EBS without using additional middleware for the integration. Exposed PL/SQL procedures as web services to enable Salesforce to post updates into EBS and used PL/SQL to post updates to Salesforce using the enterprise WSDL

Confidential

Solution Architect

Responsibilities:

• Accounts Receivable, Customers
• Lead discussions to identify gaps between Salesforce and EBS.
• Architected, designed and led the implementation of integrations from Salesforce to EBS for Customer and Invoice data using Cast Iron as the integration tool.

Confidential, Redwood City, CA

ORACLE SOLUTION ARCHITECT

Responsibilities:

• Responsible for formulating and leading presales technical/ functional support activity for customers.
• Focuses on large or complex sales opportunities that need creative and complex solutions.
• Develops and delivers presentations and demonstrations. Leads all aspects of the technical sales process.
• Advise internal and external clients on overall architect solutions.
• Utilized TOGAF principals and techniques to help with developing solutions for customers.

Confidential, Dallas, TX

SENIOR TECHNICAL MANAGER

Responsibilities:

• Upgrade to R12 and implementation of additional modules:
• Upgrade of standard financial modules, implementation of Order Management, Purchasing, XML Gateway
• Provide technical oversight and assistance in all areas of the upgrade and implementation.
• Architected, designed and led the implementation of integrations from 3rd party warehouse using XML messages for Purchases and Sales Orders, this involved extending existing OAGIS XML maps and creating new maps.
• Setup Oracle Applications to be access from the Internet via a DMZ and reverse proxies.
• Assisted with the design and development of implementing Order Management and Purchasing.
• Designed & developed multiple customizations to OAF pages to meet business requirements

Confidential

Technical Manager

Responsibilities:

• Liaising with the DBA team to manage the actual upgrade to 12.1.3.
• Upgrade of standard financial module (GL, AP, AR, Collections).
• Successfully completed unit testing and retrofitting all customization to R12 environment ready for testing on time, including an end-to-end system test.
• Upgrade successfully completed.
• Solution Architect of the PepsiCo PeopleSoft AR conversion and migration to an existing Oracle Financials AR system. Fully responsible for all design. Manages a team of Designer/Developer. Collaborates with business stakeholders to help define the requirements.
• Hands-on role managing the project plan, requirements gathering, solution design, program development and testing.
• Provided expert knowledge as the Technical Manager on the Pepsi Bottling Group initiative to map their processes to Oracle AR and Advanced Collections, created and managed RICEW items. Led a team of 13 Designers and Developers including Confidential consultants, client resources and contractors.
• Designed the solution, provided guidance on development standards, performance and mentoring on best practices. Utilized an offshore team in China during the development phase.
• Drove the team members to pull together to meet the design deadline.
• Successfully delivered design on time leading to winning the implementation and 3 additional contracts.
• Designed, developed Unix scripted jobs to be run via Control-M batch scheduling.
• Designed & developed OAF pages to aid in resolving errors with data that failed to load.

Confidential, Dallas, TX

Technical Architect

Responsibilities:

• Managing design & development teams on & offshore.
• Implementing design & development standards.
• Oracle SQL, PL/SQL design & development, including performance testing.
• Scripting Unix batch jobs to be run as part of the daily/ weekly/ monthly run schedules.
• Designed and developed custom Order cycles.
• OAF page design & development.

Data Architect

Confidential

Responsibilities:

• Designed data model for a new member application for AAA, using ERWIN.
• Developed Master Data Management data model for 7-Evelen to consolidate vendors across all of their systems.