Sr. Oracle EBS Developer
Resume:
Sreeni Yenumala
******.********@*****.***
Sr Oracle EBS/PLSQL Developer
Professional Summary:
Oracle PL/SQL Certified Developer with extensive 13+ years of experience in the analysis, design and development of Oracle 9i, 11g and 12c databases using advanced PL/SQL features. Additional expertise in Oracle Applications E-Business Suite Applications 11i and R12 Financials, Supply Chain Management and Manufacturing modules and data utilities including TOAD and SQL Developer.
Expert in the analysis, design, development, customization and implementation of Oracle ERP applications (Oracle Inventory, Oracle Account Receivables, Oracle Order Management, Oracle Purchasing, Oracle Payables, Oracle General Ledger, Fixed Assets, Subledger Accounting, Cash Management, Costing, Install Base, Oracle Work in Process, Oracle Bills of Material, Oracle Service contracts, Oracle Quality and Advanced Supply chain planning).
Proficient in analyzing and translating business requirements into technical requirements and architecture.
Hands-on experience in the development/customization of RICE components of Oracle Applications E-Business Suite using SQL, PL/SQL developer.
Skilled in the Full Life Cycle Implementation and Support of Oracle Applications with proven ability to create high performing custom PL/SQL code and XML reporting.
Expert in Oracle Forms Personalization and customization.
Hands-on experience on Procure to Pay (P2P) and Order to Cash (O2C) cycles.
In-depth experience in developing and tuning Oracle database objects including Procedures, Functions, Packages and Triggers in PL/SQL.
Skilled in developing UNIX FTP and Shell scripting.
Expert in Inbound Data Migration using SQL* Loader and Outbound Interface using the UTL_FILE package.
Hands-on experience in Oracle Application Implementation Methodology (AIM 3.0).
Expert in using Oracle advanced PL/SQL features like PL/SQL tables, records, Bulk collect, Pragmas for error handling and Cursors for data processing.
Technical Skills:
Applications
Oracle Applications R12/11i, Oracle 12c
Technologies
SQL, PL/SQL, Oracle Forms, Oracle Reports, XML/BI Publisher and Workflow
Modules
PO, OM, AP, AR, INV, FA, CM, CST, BOM, WIP, SLA, IB, ASCP, QA and GL
RDBMS
Oracle 9i, 10g, 11g and 12c
Tools & Utilities
SQL Loader, SQL*Plus, TOAD, SQL Developer, PLSQL Developer, Data Loader, More 4 Apps, Discoverer, Noetix, SSH client, WinSCP and Putty
GUI
10g/12c Oracle Developer Suite, Workflow Builder
Education/Certifications:
Bachelor of Science from Sri Krishnadevaraya University, Anantapur, Andhra Pradesh, India
Exam 1Z0-144: Oracle Database 11g: Program with PL/SQL
Exam 1Z0-047: Oracle Database SQL Expert
Exam 1Z0-007: Introduction to Oracle9i: SQL
Exam 1Z0-051: Oracle Database 11g: SQL Fundamentals I
Exam 1Z0-147: Program with PL/SQL
Professional Experience:
Worthington Industries, Columbus, OH Nov-18 to till date
Sr. Oracle EBS Developer
Apps Enhancement 12.1.3 and 12.2.6
Description:
Worthington Industries is a global diversified metal manufacturing company headquartered in Columbus, Ohio. Company is a steel processor and manufacturer of pressure cylinder, such as propane, oxygen and helium tanks, hand torches, refrigerant and industrial cylinders, camping cylinders, exploration, recovery and production products for global energy markets; scuba tanks, and compressed natural gas storage cylinders; custom-engineered open and enclosed cabs and operator stations for heavy mobile equipment; framing systems for mid-rise buildings; steel pallets and racks for shipping.
Responsibilities:
Being part of the Onsite Development and support team, have taken responsibility for developing the following Technical components.
Analyzing and understanding business requirements.
Customization of RICEW components for the new enhancements
Developing design documents for each customized object.
Developing new reports in EBS based on existing Cognos reports as per user requirements.
Changing the custom business objects logic to support as per R12 Oracle application features.
Developing the custom business objects.
Understanding and writing the Performance testing scenario documents.
Smoking the environments for new builds.
Analysis and corrective action on Incidents logged in Serena.
Understanding problems and suggesting solutions online.
Wrote packages to develop conversion programs.
Data fixes for issues that include correction and pushing the transactions.
Wrote packages to develop conversion programs.
Created concurrent programs and defined value sets
Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
Prepared technical specifications including MD070 and MD0120 from functional specifications received MD050 from functional team.
Loaded data into Oracle using Data Loader and More 4 Apps tools.
Performed System testing and Integration.
Technical Activities:
Writing packages to develop conversion programs. Creating concurrent Programs, Defining Value sets and registering of concurrent programs. Developing PL/SQL code to obtain the required functionality and Unit testing of each program and developed reports using XML Publisher. Preparation of technical specifications like SDD, TDD from the functional specifications received like SRD from the functional team. Involving in System Testing and Integration.
EBS Modules: PO, OM, AP, AR, INV, CST, BOM, WIP, SLA, QA and GL
Environment: Oracle Apps R12, SQL, PL/ SQL, Oracle 12c Database and XML Publisher.
3D Systems, Rock Hill, SC Oct-17 to Oct-18
Oracle EBS Developer
Apps Upgrade 12.2.6
Description:
3D Systems, headquartered in Rock Hill, South Carolina, is a company that engineers, manufactures and sells 3D printers. The company creates product concept models, precision and functional prototypes, master patterns for tooling, as well as production parts for direct digital manufacturing. 3D Systems technologies and services are used in the design, development and production stages of many industries, including aerospace, automotive, healthcare, dental, entertainment and durable goods. The company offers a range of professional- and production-grade 3D printers as well as software and materials.
Responsibilities:
Being part of the Onsite Development and support team, have taken responsibility for developing the following Technical components.
Analyzing and understanding business requirements.
Customization of RICEW components for the new enhancements
Developing design documents for each customized object.
Working on the system integration and production issues.
Developing new reports and fixing the existing issues in Noetix reporting tool as per user requirements
Changing the custom business objects logic to support as per R12 Oracle application features.
Developing the custom business objects.
Understanding and writing the Performance testing scenario documents.
Reporting the performance results with analysis and recommendations.
Smoking the environments for new builds.
Wrote packages to develop conversion programs.
Created concurrent programs and defined value sets
Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
Loaded data into Oracle using Data Loader.
Prepared technical specifications including MD070 and MD0120 from functional specifications received MD050 from functional team.
Performed System testing and Integration.
Technical Activities:
Writing packages to develop conversion programs. Creating concurrent Programs, Defining Value sets and registering of concurrent programs. Developing PL/SQL code to obtain the required functionality and Unit testing of each program and developed reports using XML Publisher. Preparation of technical specifications like SDD, TDD from the functional specifications received like SRD from the functional team. Involving in System Testing and Integration.
EBS Modules: INV, PO, AP, OM, AR, GL, CST, BOM, WIP, SLA, IB, OKS
Environment: Oracle AppsR12, SQL, PL/ SQL, Oracle 12c Database and Noetix.
Xerox, Webster, NY Dec-2014 to Oct-17
Oracle Applications Technical Lead
Apps Implementation 12.1.3
Description:
Xerox Corporation, though virtually synonymous with photocopying, makes printers, scanners, fax machines, multifunction devices, and digital printing and publishing systems in addition to its flagship black-and-white and color copiers. The firm's related services operations encompass consulting, imaging, content management, and document outsourcing services.
Responsibilities:
Being part of the Onsite Development team, have taken responsibility for developing the following Technical components.
Technical lead and First Point of Contact at client location.
Collaborated with the functional consultants to understand the requirements and design feasible solutions accordingly.
Developed Core supply chain management and financial interfaces and processes.
Prepared Technical Documentation and development for the new enhancements.
Registered custom tables and concurrent programs which are required for the new enhancements.
Created Value Sets in various modules of the Oracle application and RICE components for the new enhancements.
Supported customization, followed up on tickets and attended weekly client meetings.
Developed conversions and Oracle client extensions to accommodate complex business requirements in Account Receivables Module
Designed and developed Interface program in Oracle Account Receivables to import Invoices from Legacy to EBS.
Developed interface program to import orders from Legacy to EBS in Order management module
Developed custom PL/SQL and XML reports in Account Receivables and Order management Modules
Wrote packages to develop conversion programs.
Created concurrent programs and defined value sets
Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
Prepared technical specifications including SDD and TDD from functional specifications received SRD from functional team.
Performed System testing and Integration.
Technical Activities:
Writing packages to develop conversion programs. Creating concurrent Programs, Defining Value sets and registering of concurrent programs. Developing PL/SQL code to obtain the required functionality and Unit testing of each program and developed reports using XML Publisher. Preparation of technical specifications like SDD, TDD from the functional specifications received like SRD from the functional team. Involving in System Testing and Integration.
EBS Modules: INV, PO, OM, AP, AR, FA, CM, CST, BOM, WIP, SLA, IB, OKS, ASCP, and GL
Environment: Oracle AppsR12, SQL, PL/ SQL, UNIX Shell Script, 11g Database and XML.
Shanghai Viasystems EMS co. Ltd, India Oct’ 2012 to Dec’ 2014
Sr. Oracle Developer
Apps Implementation 12.1.3
Description:
Viasystems is a leading global provider of complex multi-layer Printed Circuit Boards (PCBs) and Electro-Mechanical Solutions (E-MS). The current requirement for Viasystems is the ERP implementation, which is to be conducted in their Shanghai plant, which is their major EMS manufacturing site. The major products are renewable energy equipment, EV chargers, telecom equipment and medical equipment. Customers are mostly from the 500 fortunes and all products are made to order. It’s an 11i to R12 Upgrade Project along with some new development components in R12.
Responsibilities:
Being part of the offshore Support and Development team, have taken responsibility for developing the following Technical components.
Responsible for supply chain management and financial module interfaces, conversions, reports and forms.
Developed PO Sourcing Rules Interface to import sourcing Rules Information from Legacy systems.
Developed Cost Interface to copy cost details from one organization to other organization
Constructed AR Transaction interface to load data from legacy systems.
Developed Discover reports in various EBS modules.
Designed GL outbound Interface to list Journal details along with source information.
Developed AP Invoice Aging Report, AP Accrual Aging Report, PO SCM BOM Matrix Report, OM Delivery note Report and OM Open SO Report.
Created Form Personalization in GL, OM, PO, AP module forms.
Developed Standard PO Import Conversion Program, PO Sourcing Rules Conversion and AR Transaction conversion program.
Wrote packages to develop conversion programs.
Created concurrent programs and defined value sets
Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
Prepared technical specifications including MD070 and MD0120 from functional specifications received MD050 from functional team.
Performed System testing and Integration.
Technical Activities:
Writing packages to develop conversion programs. Creating concurrent Programs, Defining Value sets and registering of concurrent programs. Developing PL/SQL code to obtain the required functionality and Unit testing of each program and developed reports using XML Publisher. Preparation of technical specifications like MD070, MD0120 from the functional specifications received like MD050 from the functional team. Involving in System Testing and Integration.
EBS Modules: PO, OM, AP, AR, INV, FA, CM, CST, BOM, WIP, SLA, IB, ASCP, QA and GL
Environment: Oracle Apps11i/R12, SQL, PL/ SQL, UNIX Shell Script and Oracle 9i/11g.
GE Health Care, India Dec’ 2010 to Sep’ 2012
Oracle PL/SQL Programmer/Analyst
Apps Implementation 12.1.1
Description:
Developed new applications as per the customer requirements. Also provide support as and when required by the customer. The project comprised of maintenance and enhancement of the earlier migrated applications. Change Requests in these applications are reported to TCS and they are treated as small/medium development projects. The changes are functional as well as technical. The maintenance also covers service to Production Incidents that are received by TCS. Production Incidents (PIs) are treated based on the severity level associated with them.
Responsibilities:
Being part of the offshore Support and Development team, responsible for the following Technical components
Developed new applications per the customer requirements and provided support when required by the customer.
Developed and enhanced Oracle interface PL/SQL packages and UNIX scripts for loading the data from external files into oracle applications database.
Developed interface programs in AP, AR and GL modules
Developed oracle reports and interface programs in WIP and BOM modules.
Created custom forms, reports, XML publisher reports.
Responsible for the Analysis, Design, Coding and Testing of the application.
Wrote packages to develop conversion programs.
Created concurrent programs and defined value sets
Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
Prepared technical specifications including MD070 and MD0120 from functional specifications received MD050 from functional team.
Performed System testing and Integration.
Technical Activities:
Writing packages to develop conversion programs. Creating concurrent Programs, Defining Value sets and registering of concurrent programs. Developing PL/SQL code to obtain the required functionality and Customizations of Forms & Reports and Unit testing of each program and developed reports using XML Publisher. Preparation of technical specifications like MD070, MD0120 from the functional specifications received like MD050 from functional team. Involved in System Testing and Integration.
EBS Modules: INV, AP, AR and GL
Environment: Oracle Apps11i/R12, SQL, PL/ SQL, UNIX Shell Script and Oracle 9i/11g.
Lucidity Consulting group, India Jan’ 2009 to Nov’ 2010
Sr. Oracle PL/SQL Developer
Apps Implementation 12.1.1
Description:
Lucidity Consulting Group is a new breed of information consultancy focused on business results. Lucidity is an expert at managing the strategic asset of information. With over 100 clients, Lucidity's mission is to unite talented people and solutions to deliver measurable results to our clients. Lucidity brings a unique, unbeatable combination to your enterprise: nearly a decade of unmatched expertise, specific industry knowledge, deep project management experience and advanced technology application.
Responsibilities:
Being part of the offshore Support and Development team, responsible for the following Technical components
Developed GL interface to import the Journals data from Legacy to Oracle Applications GL base tables using the standard program ‘Journal Import’.
Developed Payment Details Outbound Interface, Supplier Outbound Interface, AR Invoice Outbound Interface, AP Invoice Aging Report, Printed Requisitions Report, Supplier Payment Report and Invoice details Report
Created Form Personalization to disable the Change Period button in the Journal Entry screen.
Performed AP, AR Invoices Conversion and Supplier Conversion.
Created oracle reports in WIP and BOM modules.
Wrote packages to develop conversion programs.
Created concurrent programs and defined value sets
Developed PL/SQL code to obtain the required functionality, performed Unite testing of each program and developed reports using XML Publisher.
Prepared technical specifications including MD070 and MD0120 from functional specifications received MD050 from functional team.
Performed System testing and Integration.
Technical Activities:
Writing packages to develop conversion programs. Creating concurrent Programs, Defining Value sets and registering of concurrent programs. Developing PL/SQL code to obtain the required functionality and Customizations of Forms & Reports and Unit testing of each program and developed reports using XML Publisher. Preparation of technical specifications like MD070, MD0120 from the functional specifications received like MD050 from functional team. Involved in System Testing and Integration.
EBS Modules: WIP, BOM, AP, AR and GL
Environment: Oracle Apps11i/R12, SQL, PL/ SQL, UNIX Shell Script, Oracle 9i /11g.
Lexar Media, India Aug’ 2006 to Dec’ 2008
Oracle PL/SQL Developer
Apps Implementation 11i
Description:
Lexar is a leading manufacturer and marketer of award-winning removable flash memory cards, USB flash drives, card readers and ATA controller technology solutions for the digital photography, consumer electronics, industrial and communications markets. The project is being developed to integrate Oracle Applications with external systems and focused extensively on the implementation and customization of Oracle Applications.
Responsibilities:
Being part of the offshore development team, responsible for the following Technical components.
Created GL Daily Rates interface and Inventory Item Outbound Interface.
Developed an Inbound Interface to Load Purchase Order Details into Purchasing Applications Base Tables from Legacy System.
Performed Item Conversion.
Developed Requisition Import to import Po requisitions data from flat files to ORACLE Applications.
Created concurrent programs and defined value sets.
Developed PL/SQL code to obtain the required functionality and customization of Forms and Reports.
Performed System testing and Integration.
Technical Activities:
Creating concurrent Programs, Defining Value sets and registering of concurrent programs. Developing PL/SQL code to obtain the required functionality and Customizations of Forms & Reports and Unit testing of each program which we have developed.
EBS Modules: INV, PO and GL
Environment: Oracle Apps11i, SQL, PL/ SQL, UNIX Shell Script and Oracle 9i.
Contact this candidate