Technical Solution Architect Resume
St, LouiS
SUMMARY
- Over 14 years of extensive experience in Analysis, Design, Development, Testing, Implementation, Supporting and upgrading Oracle Applications/EBS 11i, R12.
- Extensive knowledge on Procure to Pay and Order to Cash business flows.
- Good functional knowledge in Oracle Financials (AP, AR, CM, FA & GL), SCM/MFG (INV, PO, OM, BOM, WIP, WMS, OPM, iSupplier), Oracle HCM and HRMS R12 (HR, Payroll, OAB, Self - Service).
- Good exposure on TCA architecture.
- Extensive experience in RICE/CEMLI (Reports, Interfaces, Conversions, Extensions and Workflow) and Middleware (Oracle Applications Framework (OAF), Workflow and SOA/BPEL) components.
- Extensively worked on Oracle back-end programming and Front-end development using tools like Oracle Forms 10g/6.0, Oracle*Reports 10g/6.0, XML/BI Publisher, Discoverer, WED ADI, Business Events, Oracle Alerts, Performance Tuning, AME.
- Extensive experience in Implementations, version upgrades, data conversions, customization of Reports and Form Development and Personalization in Oracle Applications.
- Experienced in debugging, testing, and deploying the applications designed and developed interactive GUI screens and reports using oracle forms/reports, creating LDT/XDF files and creation of SR with Oracle Support, obtaining patches from oracle support, and applying patches with coordination of Apps DBA.
- Strong programming experience in creating Procedures, API, Packages, Functions, Triggers, and other database objects using SQL, PL/SQL, UTL File and UNIX etc.
- Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency by using TKPROF.
- Experience in Application Object Library (AOL) such as creating custom responsibilities, custom menus, menus exclusion, form functions, Concurrent programs, creating value sets, profile options, messages, look ups, list of values, Flex Fields. Good exposure with business user’s helpdesk ticketing system on supporting projects.
- Good understanding of MOAC Impact on custom programs development like report, forms.
- Experienced in preparing technical specs (MD070), Functional Specs (MD050), Installation Documents (MD120), User Training Documents, test procedures document preparation using SDLC/AIM methodology.
- Experience in Test Cases, Documentation and interacting with the offshore development team.
TECHNICAL SKILLS
Oracle Applications (EBS): Oracle Apps 11i, R12x
Financials: GL, AP, AR, CM, FA, PA
SCM/ MFG: PO, OM, INV, BOM, WIP, OPM, iSupplier, WMS, OPM, MSCA
HRMS/SSHRMS: HCM, OAB, Payroll, HRMS & SSHRMS CEMLI Components (OR)
RICE Components: Configuration, Extension, Modification, Localization, and Integration Reports, Interfaces, Conversions and Extensions
Oracle Fusion Middleware/Framework: SOA/BPEL, OAF, Intermediate knowledge on ADF
BI & ETL: OBIEE 10g,11g
Languages: C, C++, Java, SQL, PL/SQL, XSL and XSLT
Database: Oracle 9i, 10g, 11g and 12c
Development Tools: Oracle Workflow, WEBADI, AME, Reports 6i & 10g, XML/BI Publisher, Discoverer, Oracle Forms 6i, 10g, Oracle JDeveloper 10g/11g.
Operating Systems: Windows XX and Unix/Linux
Utilities: SQL * Loader, SQL * PLUS, TOAD, Putty, Winscp
PROFESSIONAL EXPERIENCE
Confidential, St. Louis
Technical Solution Architect
Responsibilities:
- Requirements gathering and creating data objects to meet the customer requirements.
- Developed Several RICE/CEMLI Components in SCM and Financial modules.
- Providing the production support to the business users with Service Now Ticketing system.
- Developed reports on ad-hoc requests from stack holders.
- Involved in daily on-going production issues to support business teams.
- Identifying the gaps within business process and provide possible solutions to overcome the gap.
- Expertise on working with offshore team and providing better support within the team.
- Documenting the new problems and solutions to share with end users to provide better customer experience.
- Responsible to provide trainings to end users on new functionalities.
- Loading data from external system to oracle data base.
- Developing functions, procedures, and packages for the new implementations.
- Involved in the system testing and defects.
- Providing estimations on the tasks to be completed.
- Responsible for creating LDT files for concurrent programs.
- Responsible for preparing MD70 on developed components.
- Worked on Performance Tuning and Query Tuning.
Confidential, St. Louis
Oracle Applications/EBS Technical Lead
Responsibilities:
- Project management and Creating data objects to map the business requirements.
- Developed Several RICE/CEMLI Components using pl/sql.
- Providing the production support to the business users with Ticketing system called AOTS/Kintana.
- Developed custom business event for SO HOLD and Release.
- Involved for Creating search page using OAF and other customizations for internal purpose.
- Involved in API to create suppliers/sites/banks in iSupplier.
- Developed workflow business events to report the promise date and schedule ship date changes on the orders.
- Loading data from external system to oracle data base.
- Developing functions, procedures, and packages for the new implementations.
- Involved in the system testing and defects.
- Providing estimations on the tasks to be completed.
- Responsible for creating LDT files for concurrent programs.
- Responsible for preparing MD70 on developed components.
- Worked on Performance Tuning and Query Tuning.
Confidential, Harleysville
Oracle Applications/EBS Technical Lead
Responsibilities:
- Partner with Other vendor teams, business team to identify and remedy key issues introduced by upgrade.
- Retrofitted/Re-engineered Custom CEMLI objects from 11i to R12 using pl/sql.
- Reviewed code generated by other developers
- Proactively manage changes in project technical scope, anticipate potential issues, and take responsibility for their resolution.
- Identify and resolve issues and conflicts within the technical application development team.
- Work closely with technical and business project stakeholders on an ongoing basis.
- Developing new CEMLI objects using pl/sql.
- Participate in Continuous Improvement activities.
- Providing the production support to the business users with Ticketing system called AOTS/Kintana.
- Responsible for unit testing and comparing out puts in 11i and R12 for various test cases.
- Preparing and capturing test cases for each component.
- Responsible for creating LDT files for concurrent programs.
- Responsible for preparing MD-70 for each component by using AIM.
Confidential
Oracle Applications/EBS Technical Lead
Responsibilities:
- Developed custom reports in HCM, Payroll, Self-Services, AP, INV, FA, PO, AR, OM and OPM using XML Publisher and traditional report development using pl/sql.
- Developed custom FORMS in AP, INV to meet the client requirements.
- Developed New Alerts in PO and HCM to meet client requirements.
- Responsible for handling and fixing all the issues raised by Business Users using Helpdesk ticketing system.
- Uploading employee SIT and EIT data using WED ADI and seeded API.
- Setting up HR/Payroll related Descriptive Flex Fields, Personal Analysis Flex Fields, Validation Sets, Users, Responsibilities and Menus
- Interact with users to resolve issues during the production, development, and enhancement phases.
- Involved functionally on creating ‘Supplier Merge’ OAF page in AP (SCM) and other OAF pages in iSupplier.
- Updating previously existing data onto the new database using seeded APIs.
- Worked on XML bursting for employee payroll report.
- Responsible for creating LDT files for concurrent programs.
- Developed various Discoverer Reports, OAF pages and Form Personalization as per the user requirements.
- Unit testing on each object functionally and technically.
Confidential
Sr. Oracle Applications/EBS Technical Consultant
Responsibilities:
- Designed, developed, and customized various Reports in AR, AP, GL, FA, INV, OM, PO, BOM, WIP, OPM, WMS, MSCA, HRMS & SSHRMS using Oracle Reports Builder and XML using pl/sql.
- Developed Custom forms for Project’s module and integrated to standard tables by using API’s
- Involved in Bug Fixing and technical design.
- Preparation of MD070, CV060 and TE020 Documents.
- Custom Alert Development and Business Events
- Developed data conversions/Interfaces for several modules.
- Developing different types of Value sets, Lookups and DFF for reports as per the Requirement.
Confidential
Sr. Oracle Applications/EBS Technical Consultant
Responsibilities:
- Designed, developed, and customized various Reports in AR, AP, FA, GL, INV, OM, PO, BOM, WIP, OPM, HRMS & HCM using Oracle Reports Builder and XML.
- Involved in Bug Fixing and technical design.
- Involved functionally on custom forms in SCM module to meet client requirement.
- Developed several CEMLI/RICE Components using pl/sql.
- Postproduction Support.
- Worked on Form Personalization for different requirements:
- Calling one form to other form using ZOOM functionality.
- Worked on multi logo/multi watermark reports for multiple organizations.
- Developed dynamic logo reports for multi org structure.
- Validating order quantity, which should not be greater than inventory item on-hand quantity.
- Preparation of Technical Documents like MD70 using AIM.
- Develop different types of Value sets and DFF for reports as per the Requirement.
- Conducted training session on Discoverer reporting tool to end users.
Confidential
Sr. Oracle Applications/EBS Technical Consultant
Responsibilities:
- Developed Items, Suppliers, Customers and Employee Master Data interfaces/conversions.
- Developed several CEMLI/RICE Components using pl/sql.
- Designed, developed, and customized various Reports in AR, AP, GL, INV, OM, PO, BOM, WIP, OPM, HRMS & SSHRMS using Oracle Reports Builder and XML.
- Developed various Value Sets, Lookups and DFF for reports as per the requirement.
- Prepared technical documents like MD70 using AIM.
- Worked on SQL loader for loading data from flat files.
Confidential
Oracle Applications/EBS Technical Consultant
Responsibilities:
- Developed several CEMLI/RICE Components in Finance and SCM/MFG using pl/sql.
- Designed, developed, and customized various Reports in AR, AP, GL, FA, INV, OM, PO, BOM, WIP, OPM, HRMS & SSHRMS using Oracle Reports Builder and XML.
- Developed various Value Sets, Lookups and DFF for reports as per the requirement.
- Prepared technical documents like MD70 using AIM.
- Worked on SQL loader for loading data from flat files.
- Developed ‘Sales Budget Report’ using Discoverer Reporting Tool.
Confidential
Oracle Applications Technical Consultant
Responsibilities:
- Developed several CEMLI/RICE Components using pl/sql in SCM and FIN.
- Designed, developed, and customized various Reports in AR, AP, GL, FA, INV, OM, PO, BOM, WIP, OPM, HRMS & SSHRMS using Oracle Reports Builder and XML.
- Developed various Value Sets, Lookups and DFF for reports as per the requirement.
- Prepared technical documents like MD70 using AIM.
- Worked on SQL loader for loading data from flat files.
Confidential
Oracle Applications Technical Consultant
Responsibilities:
- Developed several CEMLI/RICE Components using pl/sql.
- Designed, developed, and customized various Reports in AR, AP, GL, FA, INV, OM, PO, BOM, WIP, OPM, HRMS & SSHRMS using Oracle Reports Builder and XML.
- Developed various Value Sets, Lookups and DFF for reports as per the requirement.
- Prepared technical documents like MD70 using AIM.
- Worked on SQL loader for loading data from flat files.
Confidential
Oracle Applications Associate Consultant
Responsibilities:
- Developed several CEMLI/RICE Components using pl/sql.
- Designed, developed, and customized various Reports in AR, AP, GL, FA, INV, OM, PO, BOM, WIP, OPM, HRMS & SSHRMS using Oracle Reports Builder and XML.
- Developed various Value Sets, Lookups and DFF for reports as per the requirement.
- Prepared technical documents like MD70 using AIM.
- Worked on SQL loader for loading data from flat files.
Confidential
Associate Oracle Applications developer
Responsibilities:
- Writing custom packages and using APIs to develop the interface programs.
- Developing Custom Reports in Oracle Applications using pl/sql.
- Designing or Customizing Forms.
- Preparation of Technical Specifications Documents.
- Preparation of Installation Documents.
- Preparing test scripts.
- Deployment to other test environments.
- UAT Support, solving UAT bugs and providing solutions on time.
- Postproduction Support.
- Preparation of MD070 documents.