Candidates About

 

Rajasekhara Reddy Puduru

Oracle Apps Techno Functional Consultant

 

Summary:

·         Expertise is Oracle E-Business Suite (EBS) around 11+ Years as a Techno Functional Consultant on various stages of the project implementations, upgrade & Support.

·         Well versed with Financial Modules (AP, AR, GL, FA and CM), SCM (PO, INV, WIP and BOM), HRMS and Other concepts like PA, TCA, QP, WSH, GL, CE and AOL.

·         Extensively worked on CEMLI (Configurations/Customization, Extension, Modification, Localization and Integration) components.

·         Experience in various process flows like P2P,O2C,R2R

·         Thorough insight in Designing and Developing Data conversions, Interfaces using Oracle Open Interfaces and Oracle Public API’s.

·         Excellent analytical skills in Analysis and business requirement gathering(BRDs) from end users and experience in design using functional requirement documents(FRDs) MD50 and CV40, technical requirements documents (TRDs) MD70 and CV60 documents using Application Implementation Methodology (AIM).

·         Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

Tools: 

SQL*Loader, SQL*Plus, PL/SQL, OAF, Oracle Developer Suite 6i/10g,Oracle Workflow, TOAD, Data Loader, UNIX,                JDeveloper, BI Publisher, Harvest workbench, WinSCP, Putty and Reflection FTP.

 

 

Professional Experience:

State Street Corporation, USA                                                                              Aug 15 to Till Date 

Boston, MA

Position: Oracle Apps Techno Functional Consultant (R12.1.3 Implementation)

Description:

State Street Corporation is an American financial services holding company having operations across globe. State Street is implementation Oracle R12 with all financial modules in various phases includes various custom components and Integration with various legacy systems.

 

Responsibilities:

·         Preparation of migration components list and loading them using the FNDLOAD.

·         Integrating DRM and Oracle R12 for Segment value hierarchies through the Interface.

·         Implementing Beeline (legacy) to Oracle EBS R12 Interface.

·         Developing the Code to get various extracts form systems like Oracle, Agility Systems.

·         Understand business requirement and preparation of MD.070’s for enhancements, Interface &extensions 

·         Configuring the Functional setups required for testing the Interfaces and reports 

·         Creation of personalization’s to meet the requirements and developing the AOL objects where ever required.

Environment: 

Oracle Applications 11.5.10.2/R12 (GL, AP, AOL and System Administrator), 

Reports 6i, XML Publisher Reports, JDeveloper, Oracle 10g, TOAD, SQL*Plus, PL/SQL, Oracle Workflow, Win SCP, Putty, UNIX and SQL*Loader.

 

Nature’s Sunshine Products, USA                                                                         Feb 14 to Jul 15 

Salt Lake City, UT

Position: Oracle Apps Techno Functional Consultant (R12.1.3 Implementation)

Description:

Nature’s Sunshine Products New Apollo Project implementation going in all financial modules, Order management, Purchasing, WMS and Inventory modules.  In this project I am working on Oracle Account Payable, Order Management, Oracle Payments, General Ledger, Inventory and Oracle Purchasing modules.

 

Responsibilities:

·         Responsible for Creation/registration of AOL objects for Profiles, Value sets, Concurrent programs, etc. 

·         Involved in the feasibility analysis of the migration of the SBC legacy system into the Oracle Applications R12 system and documented the AS-IS Business Process and framed the solution for the TO-BE process system.

·         Modify Order Line Workflow to use government generated invoice number as an AR invoice number and developed the Workflow for HTML notifications and Adhoc users/roles for sending notifications to external email lists.

·         Designed and Developed interfaces for various Third Party Logistics (3PL’s) clients based out in Europe, South America and South-East Asia in Order Management, payment and on-hand interfaces for the Stockiest system for the Indonesia market.

·         Developed & customized report like Daily Sales Report, Member Final Transaction Report & Print Purchase Order Report’ to XML Publisher Report. Customization PO Approval Workflow to BPA Quantity Agreed Validation.

·         Designed and Developed vendor payment files for various countries (Colombia, Panama, Ecuador, Mexico, Guatemala, Dominican Republic and Poland) and Wells Fargo Bank Statements to EBS (USA).

·         Created of MD 50’s for some of functional requirements that are discussed with clients.

·         Involved in functional configuration and creating Test cases for UAT.

·         Configuration of Payables and Receivables systems.

Environment: Oracle Applications 11.5.10.2/R12 (GL, AP, AR, PO, OM, AOL and System Administrator), Reports 6i, XML Publisher Reports, JDeveloper, Oracle 10g, TOAD, SQL*Plus, PL/SQL, Oracle Workflow, Win SCP, Putty, UNIX and SQL*Loader.

 

Gates Corporation                                                                                                              Apr 11 to Jan 14

Denver, CO

Position: Oracle Apps Techno Functional Consultant (R12 Upgrade)

Description:

Gates is currently using Oracle Applications 11.5.9 version to meet their business requirements and they are in the process of upgrading to R12.1.3.Gates implemented all financial modules, Order management, Purchasing, WMS and HRMS modules.  In this project I have worked on Oracle Account Payable, WIP, Oracle Purchasing, Inventory, Order Management and WMS.

 

Responsibilities:

·         Proactively work with business organizations to identify technology initiatives to drive productivity opportunities, operational efficiencies, or increases in customer satisfaction.

·         Perform systems analysis of submitted business requirements to define optimal technical solutions.

·         Development of various Interfaces for Inventory and WIP like Material Variance, updating Item attributes, printing the labels Carton and Small packages, BOM Explodes up to 5 levels.

·         Assigning of tickets to resources based on the precedence.

·         Providing work level estimates for projects to establish work plan’s, Lead the design and develop of enhancements and provide the effort estimate to the Corporate Applications platforms. 

·         Ensure release communication (scope, requirements, and release schedules) are maintained and delivered to the appropriate business owners. Actively manage any changes to releases including broad communication of any changes.

·         Work closely with the IT management team, Vendors, and QA staff throughout the development lifecycle to resolve any release scope changes using a formal change management process.

·         Development of Test scripts and Coordination with users and IT team for successful completion of UAT.

·         Maintain Executive Dashboard and Metrics reporting for Corporate Applications.

• Involved in Production support activities. Analyzing the root cause on the issues and fixing the issues.

Environment: Oracle Applications 11.5.10.2/R12 (GL, AP, AR, PO, OM, AOL, WIP, BOM, INV and System Administrator), Reports 6i, XML Publisher Reports, JDeveloper, Oracle 10g, TOAD, SQL*Plus, PL/SQL, OAF, Win SCP, Putty, UNIX and SQL*Loader.

Amazon                                                                                                                               Aug 10 to Mar 11

Seattle, WA

Position: Oracle Apps Techno Functional Consultant

Description:

Amazon implemented all financial modules, Order management, Purchasing, iProcurement, iExpenses, iPayments and HRMS modules. In this project I have worked mostly on finance modules enhancements and implementations for countries Japan, Slovakia, Spain, South Africa, India, Canada and Australia.

Responsibilities:

·         Developed Electronic payment file generation program for Deutsche Bank (Japan, Slovakia, Canada and France).

·         Developed electronic payment file generation program for HSBC bank (South Africa and Australia) in payables module.

·         Developed Program serves as a wrapper to launch generate programs for Wells Fargo, Deutsche Bank and HSBC electronic payment batches.

·         Developed and Customized various Interfaces, reports like update payment priority for unpaid invoices, Shell scripts to download files from Wells Fargo secure client, Sales Order Acknowledgement Report, customizing AP Bank Descriptive Flexfield to add Sender ID and SEPA Payments segments..

·         Sales order conversion program in Order Management module.

·         Mailer program for emailing of account statements to customers

·         Created technical documents MD 70 and installation documents.

·         Involved in Unit testing and creating Test cases.

·         Created AOL objects for all development work.

 

Environment: Oracle Applications 11.5.10.2 (GL, AP, AR, PO, OM, AOL and System Administrator), Reports 6i, Oracle 10g, TOAD, SQL*Plus, PL/SQL, Win SCP, Putty and SQL*Loader.

 

Hertz                                                                                                                                   May 08 – Jul 10

Oklahoma City, OKC                                                

Position: Senior Oracle Apps Technical Consultant (R12 Upgrade)

Description:

Hertz is the largest general use car rental brand in the world, and the number one airport car rental brand in the U.S. Hertz has locations at 69 major airports in Europe, operating both corporate and licensee locations in cities and airports in North America, Europe, Latin America, Australia and New Zealand. In addition, the Company has licensee locations in cities and airports in Africa, Asia, and the Middle East.

Responsibilities:

·         Handling of conversions for “Hertz Acquisitions” SIT and “Hertz Acquisitions” EIT in HRMS Module.

·         Developed the outbound interface for Hertz United Health Extract Program in HRMS, Oracle Advanced Benefits and Payroll Modules.

·         Developed report for Hertz Personal Fact Sheet/Confirmation Statement - (Monthly by Benefit Group) OKC Print Shop.

·         Generating Payment Reconciliation data from Oracle Payable module to OB10 System for matching all the E-Invoices. 

·         Preparing and maintaining the Data mapping between legacy and central repository.

·         Co-coordinating and managing the technical development and functional setup activities.

·         Responsible for conversion, and implementation of Oracle General Ledger, Oracle Payables, Accounts Receivables and Purchasing Modules.

• Developed outbound interface for GL Entries data file from Oracle to Black-line system.

·         Developed inbound interface load data from OB10 System into Oracle Purchasing and Payable modules.

·         Designed, implemented and analyzed Oracle application processes. Provided business flow diagrams for new enhancements. 

·         Developed Unbilled Receivables extract in Oracle Receivable module.

·         Involved into producing Functional, Technical Specification, build walkthroughs, scope change, testing, integration, migration to Production. 

·         Creating and maintaining Applications, Responsibilities, Users, Concurrent Managers, Programs, and Menus, Function, Profiles and Flex fields under Oracle System Administration role.

·         Maintain day-to-day operations of Oracle Applications and technical support.

Environment: Oracle Applications 11.5.10 and Release 12 (GL, AP, AR, PO, Oracle HR and Payroll, Oracle Advanced Benefits, AOL and System Administrator), Reports 6i, Oracle 10g, AOL, TOAD, SQL*Plus, PL/SQL, FTP, Work flow, SQL*Loader & Oracle 9i.

Marta                                                                                                                                 Apr 07 – Apr 08

Atlanta, GA

Position: Technical Consultant

Description:

Primary Involvement in ERP implementation of Oracle ERP modules at MARTA in the area of Oracle Financials and Oracle HRMS Suite End to End implementation

Responsibilities:

·         Worked as a Technical Consultant for MARTA RICE components.

·         Creating and maintaining Applications, Responsibilities, Users, Concurrent Managers, Programs, Menus, Functions, Profiles, Define Request Sets and Flex-fields under Oracle System Administration role.

• Involved in developing BEE interface using Oracle Apps standard API (pay_batch_element_entry_api) and PL/SQL.
• Developed Conversions, inbound and out bound interfaces as per client requirement.
• Responsible for Creating/ registering AOL objects like Profiles, Value sets, Concurrent programs, etc.
• Worked on several technical design documents for the interfaces and conversions from GEAC system to Oracle.
• Responsible for re-work (bug fixing) during System integration testing.

·         Developed scripts to register custom tables and table columns in APPS using AD_DD package.

• Developed outbound interface for active employee data into Maxmo tool.
• Development and Customization of Oracle Standard Reports.
• Analyzing the root cause of repetitive issues and proposes an action plan for improvement to the management with work around.

Environment: Oracle Applications 11.5.10 (GL, AP, AR, PO, AOL & System Administrator), Reports 6i, Oracle 10g, AOL, TOAD, SQL*Plus, PL/SQL, FTP, SQL*Loader & Oracle 9i.

 

 

Starent Networks                                                                                                                  Feb 06 – Mar 07

Boston, USA.  

Position: Consultant

Description:

I involved in the development of Reports and interfaces for manufacturing modules for UK and US. Developed the reports from the scratch based on the Functional specifications received from Functional team.

 

Responsibilities:

• To make technical specifications on apps module.
• Developed Test Scripts (TE20 Documents) for various objects.
• Report Customization of Oracle Applications modules.
• Registration Customized objects for various modules
• Customized Print Purchase Order standard report as per client requirement.
• Analysis of Report/Interface Specifications.
• Registering Concurrent Programs using PL/SQL script file.

Environment: Oracle Applications 11i (GL, AP, PO, AOL & System Administrator), Reports 6i, AOL, TOAD, SQL*Plus, PL/SQL, FTP, SQL*Loader & Oracle 9i.

EchoStar                                                                                                                                 Jul 05 – Jan 06      

Colorado

Position: Consultant

Description:

This project involved migration of objects from 11.5.3 to 11.5.9.EchoStar Communications Corporation has been leader in the satellite TV industry for over 20 years and is the parent company of DISH Network, the fasters growing pay television provider in the nation.

EchoStar Communications Corporation is a public company with approximately 15,000 employees. The company and its subsidiaries deliver Direct Broadcast Satellite (DBS) television products and services to customers worldwide.

Responsibilities:

·         Involved in Migration of Objects (Reports, Interfaces, PL/SQL) from 11.5.3 to 11.5.9.

·         Co-ordination with on-site team.

·         Familiar with AOL and System Administrator.

·         Developed and worked with interface various modules.

·         Registration of Forms, Reports, Concurrent Programs and Tables.

·         Customization of Reports as per the business requirements.

·         Prepared test cases as per functional design to test the interface end-to-end.

Environment: Oracle Applications 11i (GL, AP, PO, AOL & System Administrator), Reports 6i, AOL, TOAD, SQL*Plus, PL/SQL, FTP, SQL*Loader & Oracle 9i.

Blacks,                                                                                                                                   Dec 03 - Jun 05

Bangalore, India

Position: System Engineer.

Description:

This project is an implementation of HR and Payroll modules for Blacks. Apart from implementing Oracle’s out of the box functionality, there are few custom objects like BEE (Batch Element Entry) Pay roll and P60 interfaces to integrate with other legacy systems. Conversion of all HR data from legacy systems to Oracle also included in the scope.

 

Responsibilities:

·         Responsible for Creating/ registering AOL objects like Profiles, Value sets, Concurrent programs, etc.

·         Prepared detailed design based on functional design and high level technical design.

·         Prepared test cases as per functional design to test the interface end-to-end.

·         Responsible for re-work (bug fixing) during System integration testing.

·         Knowledge of Multi Organization concepts.

·         Worked on Concurrent Programs like SQL*Plus, PL/SQL Stored Procedure and Oracle Reports.

·         Testing the Developed Components with Front-End Tools.

·         Worked on Production Support to fix the issues logged by the application users.

·         Prepared Technical Design Documents.

·         Worked with PVCS and Remedy to migrate the objects from one instance to other instance. Created migration documents for migration purpose.

·         Register Concurrent Program using PL/SQL script.

Environment: Oracle Applications 11i (HR, Payroll, GL, AP, AOL & System Administrator), Reports 6i, AOL, TOAD, SQL*Plus, PL/SQL, FTP, UNIX, SQL*Loader & Oracle 9i.

Telco                                                                                                                                     Jan 03 – Nov 03

Pune, India

Position: Trainee Associate

Description:

This system   maintains the daily data loading and summarizations. Through shell we are   maintaining some operations like loading data and summarizations. I have developed some   forms for entering bills and updating master tables etc. And reports like department   wise, extension wise, exchange wise etc. also developed.

Responsibilities:

• Developed Master forms and transaction forms using Visual Basic 6.0
• Involved to design the database and develop scripts for creating the master-child tables.
• Developed Data Reports using Visual Basic 6.0
• Developed shell scripts to move data files from windows system (local system) to UNIX server.
• Developed SQL*Loader scripts to load data into Oracle tables.
• Involved to convert SQR reports into Oracle Portal 9i.
• Developed SQL*Loader scripts to load data into Oracle System.
• Setting up the application at the clients place and giving training to the end users.