We provide IT Staff Augmentation Services!

System Architect Resume

San Diego, CaliforniA

SUMMARY:

  • 9+ years of experience as Techno Functional in Oracle EBS Application Releases R11.5.10.2, R12.0.6, R12.1.3 and R12.2.4 Practice with proven experience.
  • Extensive experience in Implementation, Customization, Upgrade, Production Support of Oracle EBS.
  • Extensive experience in all phases (SDLC) of Oracle EBS Implementation with major focus in Procure to Pay (P2P), Order to Cash Modules (O2C).
  • Experience in functionality of Purchasing(PO), Payables(AP), Approvals Management(AME), AdvancedPricing, Order Management(OM), Accounts Receivables (AR) , Supplier connectivity modules, Service Contracts (OKS), Install Base(IB), Service Request(CS), Inventory (INV)and Oracle Application Object Library (AOL).
  • Experience in creating Documentation using AIM methodology. Familiar with all the Standard Documents like BRD1 00, MD.50, MD.70 and TE.20
  • Good Expertise in TCA (Trading Community Architecture).
  • Experience working with large multisite enterprise resource planning (ERP) systems and cross functional teams.
  • Experience in developing self service applications using Oracle Application Framework (OA Framework) using Oracle Jdeveloper 9.0.3/10g.
  • Extensive experience in Reports, Interfaces, Conversions and Extensions (RICE) and Configuration, Extensions and Integration
  • Extensive experience in conversion of legacy data into Oracle Applications developing Interfaces/Conversion Programs using SQL, PL/SQL, SQL*Loader, APIs.
  • Competent in Tuning the SQL and PL/SQL Procedures by enforcing HINTS and OPTIMISER and by using SQL Trace, Explain Plan and TKPROF Tools.
  • Extensive experience in developing custom forms using forms 6i/10G.
  • Extensive experience in customizing the forms functionality using Form Personalization, Logical apps rules and Custom.pll
  • Extensive experience in developing custom reports and customizing standard reports using reports 6i /10G.
  • Expertise in System Administrator functions like Registering Concurrent Programs, Forms, Form Functions, Menus, Request Groups, Value Sets, and Responsibilities etc.
  • Expertise in Oracle XML Publisher and Discoverer reports.
  • Knowledge on UNIX Shell Scripting and OBIEE Reports.
  • Knowledge on Oracle XML Gateway and EDI.
  • Good Expertise in developing applications using SQL, PL/SQL, Database Triggers, Stored Procedures, Oracle 11g/10g/9i/.
  • 2 R12 upgrade experience
  • Familiar with application development tools like PL/SQL Developer, SQL*Plus and TOAD
  • Experience in customizing Workflows using Workflow Builder 2.6.3
  • Involved in production support, development and migration activities.
  • Experience in working with ITG Kintana/ HP PPM change management and PVCS migration tool.
  • Good functional and development expertise on Open Interfaces (Includes both inbound and outbound interface) in Oracle P2P and O2C modules.
  • Worked in teams, involved in various responsibilities like Requirement gathering, development, Unit testing and UAT
  • Experience in understanding the business requirement and coordinating with development team in implementing the same.
  • Excellent analytical, problem solving and communication skills, detail oriented with ability to be an effective team player and work under severe time constraints
  • Exposure to data support on Multiple Environments like UAT, SIT, DIT, Training, and Production Environments on an Enterprise Level. Responsible for data consistency and integrity across the board
  • Received many appreciations, certificates, prizes from client for identifying and fixing the production issues.

TECHNICAL SKILLS:

ERP: Oracle Applications R12, 11i

Modules: GL, AP, AR,, I - Procurement,, Sub Ledger Accounting, e-Business Tax, Fixed Assets, Purchasing, OM, INV, Oracle Advanced Pricing, Service Contracts, Service Requests, Install Base, Oracle XML Gateway, Oracle EDI., Inventory

Databases: Oracle 9i/10g/11g

Programming Languages: SQL, PL SQL, HTML, XML, Java 6/7Oracle Tools/ Utilities: TOAD, SQL * Loader, SQL Developer, Web ADI, WinSCP, JDeveloper OAF, Oracle Workflow Builder, Forms, Oracle Reports, Oracle Business Intelligence (OBI) and Oracle BI Publisher reports, XML Reports, Toad, Oracle XML Gateway Message Designer, Oracle Discoverer

Scripting: Unix Shell

Version Control Tools: PVCS, GIT Hub, TFS, Perforce

Operating Systems: UNIX, Windows 7/Vista/XP/98/95, Windows NT

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, California

System Architect

Environment : RICE Elements, R12.0.6, 11i, 11g, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Oracle Jdeveloper Extensions, OBIEE Reports, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:
  • Support day to day procure to pay and finance issues.
  • Manage conversion, cutover and other project related task (issues, change control, etc) for on boarding legacy systems into Oracle EBS.
  • Work on providing reports to the users by creating sql queries or guide them through report creation in OBIEE or Noetix
  • Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology .
  • Lead in Enhancements to the system in the financials area.
  • Documented BR100, MD 70, MD50, configured applications and process documents( Confidential )
  • Gathering requirements and preparing functional documents and coordinating the development activities with offshore team.
  • Developed/Customized OAF Pages.
  • Developed an Interface for Drop ship orders to automate the serialized logical receiving process.
  • Developed ad-hoc SQL queries and extracted data based on Business Requirement.
  • Working closely with Business Users in PO, AP, AR, OM, FA and GL to support, develop, and implement scalable, robust solutions.
  • Create and follow up on Service Request (SR) with Oracle support.
  • Involved with Super User Training and resolving post UAT issues.
  • Prepared test cases and tested the various reports and functionality.
  • Developed APIs to load Purchase Orders, Suppliers, Customers, Requisitions, AR and AP Invoices.
  • Developed ad hoc reports in Order Management and Account Receivables.
  • Customized Order Management Workflows.
  • AME Approval Process rules.
  • Customized Pick Slip report and Packing Slip Report.
  • Some of the changes done in this project AP invoice Duplicate report, AP Invoice on Hold Report and Loaded attachments to PO and PR using APIs
  • Prepare documentation for change management process along with impact analysis on the proposed solution.
  • Expertise in using GIT Hub, Servicenow tools for version control and migrating objects from instance to instance.

Confidential, Dallas, Texas

Sr. Programmer Analyst

Environment : RICE Elements, R12.2.4, 11i, 11g,UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g, Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:
  • Lead in preparing 11i environment to readily available for R12.2.4 upgrade by coordinating with admin team in running the readiness reports and fixing the issues raised by readiness reports.
  • New requirements gathering and proposing solutions
  • Re-implementing the personalization in OAF forms which are mandatorily changed to OAF
  • Preparing MD050,MD070 documents based on Developed
  • Developed/Retrofitted AP check printing program per R12.
  • Developed reports with Discoverer.
  • Developed inbound and outbound interfaces using PL/SQL.
  • Developed ad-hoc queries based on SQL.
  • Retrofitted objects of AP, AR and GL in accordance to 12.2.4 standards.
  • Involved in maintaining the Vertex/EB-tax system and owns it completely per business taxation process
  • Co-ordinated with offshore team in compiling the custom forms and reports in 10g which are developed in 6i.
  • Involved in arranging the sequence of objects for production migration activities.
  • Expertise in using the PVCS and Kintana tools for version control and migrating objects from instance to instance.

Confidential, San Diego, California

Sr. Programmer Analyst

Environment : RICE Elements, R11.5.10.2, 11i,, 11g/10g, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:
  • Involved in merging the new Operating unit called “XRS”.
  • Coordinating with the business users in understanding their business scenarios and working closely with the technical and functional team.
  • Coordinated with users to get the data and maintain data in the required format to use in conversions of oracle apps system.
  • Developed Purchase Orders, Invoices, Customers, Service Contracts, Subscription Contracts, Install Base, Advanced Pricing and Item Conversions.
  • Developed AR interface by making it flexible to upload the invoices/CM across all operating units.
  • Set up the Intercompany transactions.
  • Web ADI to upload the assets monthly.
  • Testing the interfaces to send the data (customers, products, Delivery) to Export on Demand.
  • Development of a custom program to migrate the responsibilities from one instance to other instance by changing the OU Name which is Value Addition for Omnitracs
  • Developed new interface to automate (From return to shipping) to fulfill the Canada GSM requirement.
  • Supporting the Production issues
  • Expertise in using the PVCS and Kintana tools for version control and migrating objects from instance to instance

Confidential, San Diego, California

Sr. Programmer Analyst

Environment : RICE Elements, R11.5.10.2, 11i,, 11g/10g, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:
  • Involved in merging the new Operating unit called “ Roadnet”.
  • Coordinating with the business users in understanding their business scenarios and working closely with the technical and functional team.
  • Developed Customers, Advanced Pricing and Item Conversions.
  • Coordinated with users to get the data and maintain data in the required format to use in conversions of oracle apps system.
  • Involved in writing few test cases for different scenarios.
  • Involved in designing the complete business process from Order management to Account receivables.
  • Involved in resolving the issues for user in Oracle vertex system
  • Expertise in using the PVCS and Kintana tools for version control and migrating objects from instance to instance

Confidential, San Diego, California

Sr. Programmer Analyst

Environment : RICE Elements, R11.5.10.2, 11i,, 11g/10g, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:
  • Identifying the technical objects which relates to that particular customization and segregate the list and working with the respective teams.
  • Involved in managing both the teams and worked closely with them by clarifying the issues.
  • Involved and worked with the functional team in setting up the new instance and worked with them in completing the initial setup for new instance.
  • Worked with the development teams to retrofit and migrate the technical objects to different instances at different times.
  • Worked with the functional team in developing the data loader scripts for data loading into Oracle application system.
  • Expertise in using the PVCS and Kintana tools for version control and migrating objects from instance to instance

Confidential, San Diego, California

Sr. Programmer Analyst

Environment : RICE Elements, R11.5.10.2, R12.1.3, 11i,, 11g/10g, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:
  • Trade Export System Outbound Interface
  • R12 Upgrade: Used panaya tool to identify the affected objects from 11i to R12. Performed code retrofit of affected objects. Analyzing and suggesting the solutions to business to fill the gap between R12 features and business process.
  • Worked on Inbound interface
  • Worked on APIs for the Customer Creation process for BPEL integration.
  • SQL queries performance tuning to improve the run time results.
  • Collection Letter Print Program
  • RMA Receipting Validation and Defaulting Rules
  • Qualcomm Service Contracts Expiration Report
  • Complete Development of Prepaid collection letter pdf program.
  • Ability to Email the Collection Letter
  • Development of PO Email Notification program for Purchase Orders.
  • Developed Oracle report and XML publisher report for Quoting Module implementation based on the Quoting Sales Manager Responsibility.
  • Major Customization in OM Module.
  • HDCP Contract. (Developed three forms, also wrote utl script for the data loading into the new created tables. Applying a hold while booking the order for which a function has been added to the workflow.)
  • Interacting with onsite for getting the requirements clarified and develop accordingly in the development environment.
  • Developed the Oracle Alerts to satisfy the business requirements.
  • Worked on Logical Apps Rules.
  • Worked on Form Personalization and custom pll.
  • Created AOL objects as per the project requirements
  • Application bug fixes, enhancements and customization Setting up the causal factors and working
  • Development, maintenance, enhancement and customization of Oracle Reports and Forms.
  • Maintenance, enhancement and customization of inbound and outbound data interface programs.
  • Unit testing and system integration testing.
  • Preparing technical specification document and test cases and test result documents.
  • Coordinating for functional testing with functional team.
  • Migration of components to TST environment by coordinating with quantum database team.
  • Review for all offshore deliverables including:
  • a. Technical specifications document review
  • b. Code Review
  • b. Unit test document review
  • c. Migration details document review
  • Preparing weekly ITG Status Update Report
  • Experience in creating Documentation using AIM Methodology.

Hire Now