SUMMARY:

• 12+ years of experience in Financial, Distribution and CRM Projects involving Development, Conversion, Interfaces, Customizations, Migrations, Enhancements, Implementations, Upgrades and Production Support using Oracle E - Business Suite R12.1.3, R12.0.4, 11i
• 1½ years of experience in architecting, designing, upgrading and integrating Oracle Fusion Middleware (FMW);
• 1½ years of experience in architecting, designing, building ETLs and integrating Oracle EBS, PeopleSoft, Kronos and Performance Budgeting Applications using Oracle Business Intelligence (OBI), IBM Ascential Datastage and Cognos.
• Technical (Lead, Consultant, Analyst, Developer) activities: preparation of conceptual and technical design documents, develop and design applications, interfacing with business and users, programming, managing developers, scheduling, test script generation, devising test strategies and providing overall support to the project.
• Functional (Consultant, Analyst) activities: business requirements gathering, translating business to IT requirements, functional analysis, application design, configuration, and module setup, writing training guides, and training end users.
• Have solid experience working at all levels with large Oracle Integrators.

SOLID EXPERIENCE WORKING AT ALL LEVELS IN THE AREAS OF:

• Business Requirement Gathering
• Functional Specifications
• Process Analysis
• Functional Configurations
• Conversions
• Integrations
• Project Lead/Management
• Code Review
• Testing
• Operations and Production Support
• Process Design and Flows
• Technical Configurations
• Interfaces
• Deployments
• Technical Lead/Development
• Performance Tuning
• Implementations and Upgrades
• Grants Management (GMS)
• Project Accounting (PA)
• Accounts Receivable (AR/TCA)
• Accounts Payable (AP), Payments (IBY)
• Internet Expenses (iExpense)
• Fixed Assets (FA)
• Oracle HRMS
• General Ledger (GL/SLA)
• Purchasing (PO)
• Inventory (INV)
• Order Management (OM)
• Oracle Telesales (AST) / Oracle Marketing (AMS)
• Application Object Library (AOL )
• Customizations (RICEW)
• Form Customizations/Personalization’s

SKILLS SUMMARY:

Operating Systems: Windows, Sun Solaris 10/11, IBM AIX

RDBMS: Oracle 7.x to 11gR2, SQL Server, MS-Access

ERP: Oracle EBS R12 (12.1.3/12.0.4 ), 11i/11.0.3, Kronos & PeopleSoft HRMS/Payroll

FMW: WLS, ADF 11g, SOA 11g

DW: BI EE 10G/11G, DAC, OBI Apps 7.9.6.x,Cognos

ETL Tools: Informatica, IBM Ascential Datastage 7.5

Application Modules:

GUI: Oracle Forms 4.5 to 11g, Oracle Reports 2.5 to 10g, BI Publisher, Visual Basic

Programming Languages: SQL 8.x to 11g, PLSQL 8.x to 11g, ‘C’, Pro*C, Visual Basic, Java, JSP, JavaScript, HTML, XML, Unix Shell Scripting, Cron Jobs and Awk programming

Utilities: Oracle Discoverer 10g,11g (User/Admin/Plus/Viewer), SQL*Loader, Oracle IMPORTS & EXPORTS

Query Optimization: Explain plan, TkProf, Analyze command

Methodologies: Oracle OUM, AIM, Six-Sigma Quality Process, SOX Compliance

Other Tools: Toad, Data Loader, AUTOSYS - Batch job scheduler

PMP Tools: Microsoft (Project, PowerPoint, Word, Excel & Visio)

Version Control: Serena Version Manager, Subversion(SVN), PVCS, WinCVS1.3

PROJECT EXPERIENCE:

Confidential, San Diego, CA

Software Development Lead

Responsibilities:

• Management of Application Operations & Support
• Problem/Resolution management such as Root Cause Analysis, break-fix and resolution
• Application Release and Change Support such as Code/Build distribution, Patching and deployment
• Application Architecture and platform management for delivery of Projects;
• Oversees the design, development, and modification of more complex application programs for specified projects.
• Serve as the application lead point of contact for IT staff and systems users, developers for resolution of technical issues, solution build, code enhancements escalations and feedbacks; Manage/Support Oracle EBS, Fusion Middleware and Oracle Business Intelligence;
• Responsible for all aspects of technical/functional development within Oracle E-Business Suite Custom modules such as requirements, analysis, design, development and delivery of RICEW applications; wrote requirements for application extensions(AS-IS, TO-BE) and prepared detailed documentation as needed including; Updates to Functional Specification, Technical designs, Test Scripts, and Process Flow Charts; Provide Technical and Functional Support to Oracle EBS R12.1.3 on GMS/PA/AR/AP/GL and Custom modules; Researched, Created and Tested Service requests on issues related to EBS modules;
• Integrated FMW with Oracle EBS R12.13 using SOA/ADF/BAM and upgraded FMW to its latest patch set version of 11g; Led OBIEE Upgrade from 10g to 11g;
• Develop detailed task plan inputs for technical streams of activities in the various phases of project delivery such as Design, Build, various types of Testing, Data Conversions/migrations, Integrations, Implementation and Release. This includes obtaining estimates from various technology areas as necessary; Execute based on agreed upon deliverables and milestones;
• Develop and maintain detailed technical designs and artifacts for solution components such as Data integrations, Custom Applications, Forms, Reports, Workflows and Configurations; Provide inputs on technical requirements for various application environments for installation, testing or performance testing
• Collaborate with business subject matter experts, business analysts, IT staff, Outsourcing partners during project cycle (requirements gathering, design, development, testing, deployment) and problem resolutions during support;
• Track status of technical tasks, Participate in regular project status meetings and provide status updates for technical tasks; Assist with management of Application instances/environments and configuration management for continuous development or production support
• Coordinate technical activities, Technical impact analysis, Perform work assignments and direction for technical resources; Perform QA reviews on technical deliverables including code reviews;
• Ensure compliance to enterprise standards, practices and procedures for technical work products as well as contribute to improving existing standards by sharing industry best practices
• Provided status and issue reports to the Chief ERP Manager and CTO on a regular basis.

Confidential, San Diego, CA

Business Analyst

Responsibilities:

• Responsible for all aspects of technical/functional development within Oracle E-Business Suite Custom modules such as requirements, analysis, design, development and delivery of RICEW applications; Wrote requirements for application extensions(AS-IS, TO-BE) and prepared detailed documentation as needed including; Updates to Functional Specification, Technical designs, Test Scripts, and Process Flow Charts;
• Provide functional and technical expertise within an assigned business area, in the analysis, design, development and implementation of business processes and applications. Translated complex business needs and problems into feasible technical solutions. Retrofitted the Custom Labor Costing Process to EBS R12;
• Modified Project Costing and Automatic Release of Revenue/Invoice Extensions to support EBS R12 Upgrade.
• Wrote requirements, designed, developed and retrofitted processes to support Oracle Grant Reporting and provided the ETL requirements for the Data Warehouse. Designed, developed and architected New Custom Applications and also upgraded the Custom modules/interface processes to EBS R12 (Custom Forms upgraded from 6i to 10g; Custom Reports from 6i to 10g; Retrofit Custom Interfaces to EBS Core Modules);
• Wrote requirements designed and developed Custom Extensions using ADF 11g, BPEL and Custom DB objects. Designed the Security Gateway integrating EBS Application, Responsibilities, and Menus with FMW; Documented and Configured the Custom Business Events, Subscriptions, BPEL Queues, and Agent Listeners in R12 for Invoice Batch Approval and Purchasing Processes; Developed and customized PLSQL packages, procedures, functions, triggers and database views to support FMW Applications; Monitored BPEL processes thru’ Enterprise Manager console;
• Developed SQL Queries to support OBIEE Reporting needs; reviewed Dashboards and Custom Reports; Built Discoverer 11g business areas and workbooks utilizing custom and complex folders, item hierarchies, and workbooks for the Standard and Custom Applications;
• Configured, designed database views, Prepared Functional and Technical requirement documents and developed various reports using Oracle Discoverer 11g (Admin, Plus and Viewer) for all the application modules;
• Established standards, performed code reviews and refinement to the code design leading to significant improvement in system response time and efficiency; fixed any defects and performance problems discovered during testing;
• Tuned Complex SQL Queries using Explain Plan statistics and TkProf Utility; Identified operational inefficiencies, conflicting business practices and integration issues, suggested alternative solutions;
• Coordinated all activities for IT/Users during design, development, testing, and deployment; Delivered presentations to Functional users and Trainings teams.
• Managed the Technical Team and worked closely with Users and Functional Team members;

Confidential, San Diego CA

Senior System Architect

Responsibilities:

• Responsible for all aspects of technical/functional development within Oracle E-Business Suite applications such as requirements, analysis, design, development and delivery of RICEW applications.
• Configured System Administrator responsibilities for users, menus, responsibilities, Key and Descriptive Flex Fields, Request Groups, Request Sets and maintaining concurrent programs. Configured, designed database views, Prepared Functional and Technical requirement documents and developed various reports using Oracle Discoverer (Admin, Plus and Viewer) for all apps modules. Designed and developed Customizations and Personalization’s of Oracle Seeded Forms based on user requirements.
• Wrote Data Conversion scripts to load data from Legacy System to Oracle and also converted SQL Server data from the old web system to Oracle Portal.
• Established standards, performed code reviews, and prepared test cases/scripts for unit, functional and System Integration testing.
• Configured and Implemented Oracle Web ADI (Application Desktop Integrator) Functionality to enable GL Budget Uploads using MS-Excel 2007.
• Developed Custom forms, database objects and Interface to process Billing Orders for San Diego Visitors Center, and this includes configurations in Order Management (OM), Inventory (INV), Accounts Receivables (AR) and General Ledger (GL).
• Performed Payables Setup, Expense Templates, defined Expense Types, Employees, Workflow notifications on iExpense module and also provided support on configuration changes related to iExpense module.
• Researched, Created and Tested Service requests on issues related to EBS modules and worked with Oracle On-Demand for applying Patches on Non-Production and Production Instances. Escalate issues with SDM when required to resolve issues in a timely manner.
• Assisted Finance users during Month-End, 1099 Forms generation and Year-End Processes.
• Developed end-user documentation and training materials using UPK. Delivered presentations and end-user trainings.
• Co-ordinate all activities for IT/Users during design development, testing, and deployment.
• Managed technical team members and worked closely with users and functional team members; ensure appropriate utilization and productivity through weekly status reports, prepared work estimates and evaluations.
• Tracked all outstanding work through reports on a weekly basis and provided status and issue reports to the Vice-President (IT Operations) on a regular basis.

Confidential, San Diego, CA

Technical-Functional Lead

Responsibilities:

• Wrote business requirements for form customizations, reports, interfaces, data conversions and application extensions. Prepared detailed documentation as needed including: functional specification, technical designs, updates to existing technical documentation, test scripts, and process flow charts.
• Provided functional and technical knowledge within an assigned business area in analysis, design, development and implementation of business processes and applications.
• Translated complex business needs and problems into feasible technical solutions. Established standards, performed code reviews and prepared the test cases for unit and system integration testing. Identified operational inefficiencies, conflicting business practices and integration issues, suggested alternative solutions.
• Performed code review and refinement to the code design, leading to significant improvement in system response time and efficiency. Developed end-user documentation and training materials.
• Managed technical team members and worked closely with users and functional team members.

Confidential, Cypress, CA

Technical Lead for the Oracle E-Business Suite 11i

Responsibilities:

• Responsible for planning, developing and deploying data warehouse components in various business environments. Prepared the conceptual and technical design document specifications for ETL system conversion and interface project (Extraction, Transformation and Loading Legacy data to Oracle E-Business Suite Accounts Receivable).
• Worked closely with the business systems analyst to develop the source to target data mappings and also conduct user interviews to validate the transformation rules.
• Implemented core application logic using PL/SQL Bulk Binds, Bulk Collect, and Table-Types Arrays to boost the system performance to load high volume of data into the data warehouse on an incremental basis.
• Developed test data manipulation routines, addressed code bugs, supported implementation effort and documented support essentials. Coordinated technology related training.
• Supported cross-platform development and integration with data transformation, job scheduling, database loading tools, and source code control and release/configuration management tools;
• Worked on performance tuning of the extraction, transformation and FTP of the data from fact tables into the raw data stage area and the loading of the data into Oracle. This task was scheduled monthly and involves processing not less than 12 million records;

Confidential, Tucson, AZ

Techno-Functional Consultant

Responsibilities:

• Prepared the Technical Design document and converted them into Report program specifications.
• Developed and customized reports
• Created Discoverer Reports and resolved performance issues.
• Created New Business Areas for Ad-hoc Reporting;
• Customized FSG reports on Oracle GL Module.

Confidential, Boulder, CO

Techno-Functional Consultant

Responsibilities:

• Support and Resolve 11.5.10 Upgrade Issues; Retrofit Custom Reports and Interfaces impacted by the upgrade. Raise Service Requests with Oracle Support to resolve critical issues.
• Project Lead - Development / Conversions/ Migration
• Service Delivery
• Act as the point of contact, lead cross-functional issue resolution across teams and resources and serve as a liaison between IT and business teams. Assist in the strategy, design, development, execution, and policy/process adherence for application development.
• Studied the business requirement and converted them into Technical Design documents.
• Wrote complete detailed documentation as needed including; MD50 Functional Specification, MD70 Updates to Technical Documentation, Test Scripts, and Process Flow Charts
• Mapping of business requirements to application features and identifying the areas that needed customization.
• Developed and Customized Oracle Reports, PLSQL packages, procedures and triggers, converted all the Custom Reports to work on Oracle Applications 11i using Oracle Reports 6i.
• Developed and Customized Oracle Reports 6i for Oracle Portal Integration. Worked with Discoverer and created views to enable users to generate ad-hoc reports.
• Developed several Unix Korn shell scripts to aid the performance of some Customized programs on Oracle Applications.
• Developed Java Server Pages (JSP), JavaScript and Java program to call Oracle Stored Procedures for Asset Information Management Systems, which is a part of GE Instrumentation Business.
• Automated the equipment out of tolerance notification to users using Pro*C, UNIX shell scripts and scheduled the job using Unix Cron.
• Supported and Integrated the Business System to be fully User Authenticated via) Oracle Single Sign-On (SSO) Architecture in development and Production environments.
• Established standards, performed code reviews, coded PL/SQL interfaces, forms and reports and prepared the test cases for Unit and System Integration testing.
• Supported System upgrades and change request management for code deployment into production environments through Kintana Management Tool.
• Supported Post-Go Live activities and closed all production issues logged through Clarify.