SUMMARY

ERP Architect and Systems Analyst with 12 years professional experience in positions of increasing responsibility ranging from business intelligence, data migration, development, support & maintenance, conversion and implementation and upgrade projects. Hands - on experience leading all stages of software development, including requirement definition, design, architecture, testing, support and documentation. International exposure as part of cross- functional global teams (Americas, Europe, Middle East), including 6.5 years in US providing consulting services in Finance modules, Supply Chain. Successfully designed a broad range of software programs participating in planning, analysis and implementation of solutions in Purchasing, Finance, Manufacturing, Inventory.

TECHNICAL SKILLS

• Oracle EBS 11i and R12, Oracle Reports 6i, OBIEE reports, Forms 6i, Oracle SQL, PL/SQL, UNIX Shell Scripting, RICEWF components, Good knowledge of Procure to Pay (P2P) and Order to Cash ( O2C) business cycle.

PROFESSIONAL EXPERIENCE

Oracle EBS System Analyst/ Independent Consultant

Confidential,San Diego, CA

• Developed SQL and PLSQL scripts to integrate Delphi5 inventory and receipt information into Oracle R12. Responsible for extraction of data from warehouse software systems and translate, load and reconciled in oracle modules.
• Built reports in Purchasing to capture the material cage movements and KPI reports at warehouse for better handling perishable raw materials and packaging materials.
• Built integration systems using SQL, TSQL, PLSQL, OBIEE reports between Oracle and inhouse third party manufacturing systems, which helped reduce 40% of daily manual transactions.
• Work closely with the warehouse Business Analysts, formulating test plans, preparing test cases, executing the tests, and fully documenting and reporting the results
• Supported SCM and manufacturing plant operations. Sole contact to gather business requirements of the business processes and develop into IT solutions.
• Personalized Oracle forms R12.1.3 in Purchasing and AP module.
• Built effective business systems based on changing CPG standards and provided end user trainings and transition on newly implemented business processes including helping user understand standard EBS business definitions in Oracle R12 and OBIEE.
• Created quarter, year-end reports(Oracle and BI reports) for internal auditing with parent company, Thai Union and external auditors PWC, KPMG.
• Created many OBIEE reports and analysis based on existing OBIEE cube in Finance and Supply Chain modules, created new OBIEE cube, facts and dimensions based on star schema.
• Managed projects with offshore team in India, with a team size of 4

Oracle System Analyst/ Project Manager

Confidential

• Migration of mainframe legacy data into Oracle Inventory, AR R12.1.3. Responsible for development, system testing, system integration testing, and user acceptance testing of forms and reports.
• User Acceptance testing, Functionality testing, Regression testing, Performance testing, End-to-End System testing on Oracle R12 applications based on the AS400 integrations.
• Developed AR invoice interfacing PLSQL scripts from mainframes systems into Oracle R12.
• Developed new Oracle forms in 6i version with similar functionality as vanilla Oracle AR Transaction form along with business customizations. All the fields from AS400 existing AR transactions forms were added into customized Oracle forms.
• Created new XML reports in oracle with the same layout as existing AS400 reports.
• Developed weekly team performance reports and actively involved in weekly status review meetings and project status meetings with users and senior NTT Data management.
• Interacted with QA group on a timely basis to be par with NTT Data software quality standards.

Oracle EBS Techno Functional Lead

Confidential

• Lead Technical Developer and Subject Matter Expert in Oracle Applications 11i Procurement and Finance for entire North America, South America and Canada Honeywell and Unisys Operations.
• Primary tasks included production support in Oracle Purchasing, Payables, GL, Time &Labor, Receivables for Unisys and Honeywell and sole contact for resolving Finance and Purchasing period close issues. Worked as business systems analyst consultant in Procure to Pay.
• Managed team of 7 technical analyst and evaluated the project requirements and allot the available resources among the individual elements of the project.
• Interacted with business users in translating their requirements into technical model. Also took part in technical presentation for new development and business process definitions to customers.
• Key member in executing technical design and sizing on proposed enhancements. Also involved in scoping and designing of the project from the scratch.
• Developed generic reusable Oracle scripts to enhance performance of existing programs. Fine-tuned several existing production programs reducing the database load and provided better error handling mechanisms that are customer friendly.
• Automated several key business processes which helped in month end activities.
• Contributed support and technical assistance for Ledger data reconciliation and auditing for Sarbanes-Oxley, SOX compliance.
• Handled critical requests raised by Global Sys Administrators (GSA) and end-users during period and year end closing activities and procedures.

Oracle EBS Technical Consultant

Confidential

• Developed scripts for data migration of items, item categories, item sub inventories assignments, AR customers, vendors, vendor sites from legacy systems in oracle 11i
• Played pivotal role in upgrade from Oracle 11.5.8 to 11.5.10 in testing and customization of all existing Oracle forms in EBS environment. Created unit and user acceptance test documents listing all the functionality testing being performed for all the forms.
• Developed new source code (includes but not restricted to Oracle Forms, Reports, Workflows, XML reports, Alerts, Triggers, PL/SQL scripts, interfaces), tested and delivered the artifacts through a well-defined process across different Oracle Applications modules (Finance, SCM, Purchasing) and domain in Oracle Applications 11i and R12 environment. Working knowledge of UNIX and Shell Scripting.
• Created critical business, process and transition related documents along with technical design document.
• Developed generic migration scripts in Inventory module which was to be used in different projects.