Oracle Techno functional Consultant

Ramya Thadisina

Oracle Applications Techno-Functional Consultant

Phone: 224-***-****

****************@*****.***

Summary of my Professional Experience:

Analytical, passion driven Software professional who is experienced in variety of Oracle EBS suite of applications ranging from SCM, versions ranging from 11.0 to R12, technologies ranging from Oracle. Total IT experience of 8.5 years with 8.2 years of experience in Oracle apps.

8+ years as Oracle EBS Senior Developer in Oracle E-Business Suite Application (Release 12/11i) providing Solutions of Implementation, Upgrade, Maintenance, Testing and Production Support.

Extensive experience in Oracle Apps such as Order Management (OM), Inventory (INV), Purchasing (PO), Account Receivables (AR), Warehouse Management (WMS), Work in Process (WIP),Bill Of Materials(BOM),Shipping Execution.

RICE component development experience and Extensive hand-on experience with Configuration on OM, INV, AR, WMS,PO, BOM,WIP modules.

Extensive knowledge in all phases of Software Development Life Cycle (SDLC)

Expertise in Client Interaction, Requirement Gathering, Process walk through, Mapping, GAP Analysis and Technical Design documentation and Full lifecycle implementations, Upgrades.

Experience in Requirements analysis, Design and Testing Enterprise level Applications

Experience in the preparation of Functional Design, System Design (MD 50) and Technical Design documents.

Extensive knowledge and work experience in design and development of database applications in Client/Server environment using Oracle Developer tools Forms (6i & 9i), Reports (6i & 9i), PL/SQL Developer, Workflow Builder and TOAD.

Experience working on end-to-end Order to Cash (OTC) and knowledge of Procure to Pay (P2P)

Proficient in SQL and PL/SQL and Advanced PL/SQL

Experience in Creating Stored Procedures, Functions, Packages, Triggers, Views and Indexes and also in tuning the sql queries for improving the performance

Experience of developing conversion programs and Interfaces (Inbound & Outbound)

Good knowledge in using performance-tuning utilities like EXPLAIN PLAN, SQL Trace and TKPROF

Extensive experience in registering Concurrent Programs, Form, Functions, Menus, Tables, developing Key and Descriptive Flex-fields in Custom Applications and defining Profile values by using Application Object Library (AOL) and System Administration in Oracle Applications

Experience in developing in Reports and XML Publisher/ BI Publisher, Form Personalization and custom workflows using oracle Workflow Builder

Efficient in UNIX shell scripting

Experienced in ITIL processes for carrying out IT Operations with accountability. ITIL processes include, incident management, change management, problem management and configuration management.

Experience in using tools like TOAD, PLSQL Developer, SQL Developer, SQL *Loader, Data Loader, FND LOAD

Working Experience at Different Locations Offshore& Onsite (India, USA)

Exceptionally well organized with Strong Communication, Inter-personnel, Analyzing Skills and a desire to learn new technologies and tools

Good problem solving and trouble shooting skills, highly motivated and ability to work as an individual or as a dynamic member in a team.

Certifications:

Oracle SQL Certified.

Oracle10g PL/SQL Developer Certified Associate (OCP)

Oracle E-Business Suite R12: Purchasing Essentials certified

Oracle E-Business Suite R12: Oracle Inventory Essentials certified

Oracle E-Business Suite R12: Order Management Essentials certified

Education:

Bachelor of Technology – Computer Science Engineering, Jawaharlal Technological University (JNTU University), India

Skill Set

Oracle Functional (8+ years)

Primary: P2P cycle, O2C Cycle OM, INV, AR, PO, BOM,WMS

Secondary:IB,Oracle Service Contracts, AOL, Alerts, Workflows, FND

Oracle Technical (8 + years)

SQL, PL/SQL, SOAP UI, Workflow Builder, AME, Reports Builder, Forms Builder, XML Publisher, UNIX

OTM and GTM (1+ Years)

Supported OTM and GTM Cloud Applications.

Version Control

Clear Case,Kintana,SVN

ITIL Process tool

Service-Now, BMC

Database tool

TOAD, PL/SQL Developer, Putty, WinSCP

Work History:

Client: Zebra Technologies, Lincolnshire, IL

Role: Oracle Apps Techno Functional Consultant

Project Name: Oracle EBS integration with Oracle Transportation Management (OTM Cloud) Project

Duration: May 2019 – Till Date

Project Description:

Zebra is embarking on a journey to implement Oracle Transportation Management that will serve as a platform for all transportation activities through-out the supply chain.

OTM will minimize the transportation costs and optimize service levels by planning and consolidating the shipments and selecting the optimal ship methods and carriers. As part of this project, Delivery Detail lines information from Oracle EBS will be send to OTM for planning through business events to OIC. Once OTM planned and sends back to EBS, delivery and trip will create in EBS

Responsibilities:

Analyzing system requirement mappings for business requirements, evaluate the gaps.

Perform proof of concepts for technical feasibility and impact analysis

Implementing project using Oracle Application Implementation Methodology (AIM)

Involved in requirement review meetings with Business Analyst on MD.050 documents

Worked on Order Managment Outbound interfaces and xml publisher reports to develop custom pack slip and trip related reports

Created annotated files for plsql packages that needs to be integrated with OIC. Generated ILDT files for these files and uploaded files in Integrated SOA gateway (ISG). These files can be access by OIC.

Worked on Business Events to send data from Oracle EBS to Oracle Transportation Management Cloud (OTM) through Oracle Intergarated Cloud (OIC)

Worked on form personalizatin on Shipping Transactions form to handle business requirement

Prepared MD.70 documents with technical details of respective components

Prepared MD.120 documents for migrating components from one instance to other.

Prepared Test Data for SIT and UAT Test scenario

Provided support during SIT testing and fixed the code issues on prioirity basis

Provided support for UAT testing

Client: Zebra Technologies, Lincolnshire, IL

Role: Oracle Apps Techno Functional Consultant

Project Name: Oracle EBS Upgrade(12.1.1 to 12.1.3)

Duration: May 2018 – April 2019

Project Description:

Oracle ERP upgrade from 12.1.1 to 12.1.3 has been upgraded in Zebra Technologies.We have identified all technical and functional objects to be modified which will be value add to zebra as few new functionalities will be added with the new releases which will reduce maintenance cost, improved performance, retire customizations,New features and operational efficiency.

Responsibilities:

Gathering and documenting business requirements for systems enhancements, performing fit/gap analysis, and Preparing Functional design documents

Configuration of new functionalities and developing new Reports, Interfaces, Customization and Extensions, using tools like SQL, PL/SQL,XML, Workflow Builder, AME, Reports Builder, Forms Builder, XML Publisher, UNIX.

Preparing Project Documentation based on OUM like MD050, MD070, MD120, BR100, TE010 and CV010

Trouble shooting and issue resolution of application related issue

Extended support during Outages, Upgrades, Releases and Training to users and Team members.

Closely work with application development and offshore support team and guide offshore team on functional / technical issues resolution.

Environment: Oracle Applications 11i (INV, OM,PO,WMS,WIP,AOL, SYSADMIN) and Oracle Applications R12, Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP

Client: Zebra Technologies, Lincolnshire, IL

Role: Oracle Apps Techno Functional Consultant

Project Name: Oracle EBS Enchancements and Support Project

Duration: May 2017 – April 2018

Project Description:

Application Managed services/developing and support of the structured Enterprise Resource Planning which is an integration of ORACLE APPLICATIONS ERP which seems to be helping the business operated on a single ERP technology which is maintained in multiple technologies prior. Zebra Technologies as a global company maintained multiple ERP (Business systems) technologies in order to sustain the requirements which could be overcome by AMS project as the whole business track technically could be maintained under a single technology source. The project is to handle the Development, Implementation and Enhancement activities for Zebra Technologies ERP Modules and with Third party applications(3PL),E2open,Bluejay,Infoship(CLS). The specific activities involved are Implementation of development and enhancement requests, performance tuning, development of interfaces and resolving production issues in Order Management, Inventory and Procure to pay, Pricing modules. Zebra decides the progress of its business. Service now tool is used to log the production system and application related issues.

Responsibilities:

Team Lead (9 people) for development and support activities for SCM area (OM,INV,PO,AR,BOM,WMS,Shipping Execution, WIP) developed and supported O2C and P2P cycles and integrations with E2open,3PL,Bluejay,Infoship and worked on Third party integrations(3PL) integrations with multiple vendors like DHL, Agility.

Configuration of new functionalities and developing new Reports, Interfaces, Customization and Extensions, Workflows and regular support activities using tools like SQL, PL/SQL,XML, Workflow Builder, AME, Reports Builder, Forms Builder, XML Publisher, UNIX

Preparing Project Documentation based on OUM like MD050, MD070, MD120, BR100, TE010 and CV010

Worked on Developing and integrating with third-party tools like Third party logistics(3PL)Integrations,E2open,Infoship(CLS),Bluejay,OTM and GTM Cloud Applications.

Meeting with Directors and Senior manager on issues and provide solutions and recommendations

Extended support during Outages, Upgrades, Releases and Training to users and Team members

Closely work with business on key periods like Month-end, Q-end and Y-end to ensure proper closure of books.

Environment: Oracle Applications 11i (BOM, WIP, INV, OM, ASCP, AOL, SYSADMIN) and Oracle Applications R12, Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP

Client: Zebra Technologies, Lincolnshire, IL

Role: Oracle Apps Techno Functional Consultant

Project Name: Oracle EBS Implementation project (Zebra ACQUISITION of Motorola Solutions Enterprise Business)

Duration: March 2016– April 2017

Project Description:

The project is to handle the Development, Implementation and Enhancement activities for Zebra Technologies ERP Modules such as Order Management, Inventory and Procure to pay, Pricing applications. The specific activities involved are Implementation of development and enhancement requests, performance tuning, development of interfaces and resolving production issues in Order Management, Inventory and Procure to pay, Pricing modules. There are some customized modules developed by Zebra Technologies that are also included in the development and are linked with the Account Receivable modules. Since Order Management, Inventory and Procure to pay is the Application used by the Zebra Technologies for Taking Sales orders and Procuring goods. It is mandatory to have all the transactions intact and to date. Based on this information, Zebra decides the progress of its business. Remedy Request tool is used to log the production system and application related issues.

Responsibilities:

Interactions with business users to understand the business requirements and help them for preparing use cases.

Analyzing system requirement mappings for business requirements, evaluate the gaps.

Perform proof of concepts for technical feasibility and impact analyses.

Requirement review meetings with functional analyst on system requirement document (SRD).

Mapping system requirement into system design document (SDD) and completing the SDD.

Review meetings with Stakeholders (Functional analyst, Business Owners, Delivery manager).

Mapping system design document to technical design document (TDD).

Technical Design document Review and approval with stakeholders (Delivery manager).

Code/Build as per technical design and coding standards.

Developed PL/SQL package for 3PL Integrations, ERP to ZCM(Zebra Collabera Integrations,GTM Integrations.

To automate assigning items to new org and copying item attributes for given from organization to the To organization.

To automate the stock locator creation in new organization from given FROM organization

Developed custom Reports as per business requirements

To automate the ship method assignment in new organization

Responsible for conducting the complete cycle of testing in O2C (Order to Cash) and P2P Cycle(Procure to Cash).

Modified the existing PL/SQL packages to meet the business requirement.

Worked on the existing packages those needs to be tuned to improve the performance

Worked on Order management, shipping and Discrete manufacturing modules

Developed custom Reports as per business requirements

Prepared Test plans and use cases for interface testing.

Performed Unit testing for components developed.

Co-ordinate with offshore team members

Making sure Code goes through internal quality audit (IQA) and External quality audit (EQA).

Provided support for:

Integration Testing.

Functional Testing support.

User Acceptance Testing Support.

Attended Weekly status review meetings for deliverables with stakeholders.

Provided Burn-In support after go-live.

Environment: Oracle Applications 11i (BOM, WIP, INV, OM, ASCP, AOL, SYSADMIN) and Oracle Applications R12, Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP

Client: Zebra Technologies, Lincolnshire, IL

Role: Oracle Apps Technical Developer

Project Name: Oracle EBS Trilogy Exit Conversions and Interfaces Project

Duration: August 2015 – Feb 2016

Project Description: The purpose of this project is to convert data from source system(Motorola System) to Zebra(Target System) during Zebra acquired Motorola’s Enterprise business.

Responsibilities:

Involved in gathering business requirements.

Involved in Conversion of Item,Item Categories, Item CrossReference,Customer Cross reference,AML(Approved Manufacturer List Conversion),Sales Order Conversion.

Developed onhand Conversion program to mass create Onhand and Mass issue out Onhand.

Developed interface to pull real time data in to target system after conversions until phase 2 of the project is completed.

Customized reports and also standard Order to Cash process as per the business requirement.

Created Technical Notes and Documentation.

Developed SQL Reports and handled interfaces to meet the Business Requirements.

Involved in code migration using Kintana Tool.

Interacted with customers to understand their technical queries and provide assistance in resolving them.

Performed Unit Testing.

Involved in various SIT and UAT testing cycles of conversions.

Involved in production cycle of conversions and provided all success and fall out reports to Business.

Environment: Oracle Applications 11i (BOM, WIP, INV, OM, ASCP, AOL, SYSADMIN) and Oracle Applications R12, Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP

Client: Motorola Solutions Inc.,India

Role: Oracle Apps Technical Developer

Project Name: Motorola Solutions Trilogy Steady State project(ACT Project)

Duration: Nov 2014 –July 2015

Project Description:

ACT is an L3 support project. ACT is working based on module towers (Quote to Order, D2D, I2R, EIM, and Sysadmin) and taking care of enhancement tickets (Greater than 40 hours). The objective of the ACT team is to enable the application support Trilogy 3.2 release by performing enhancements/build activities across functional business areas (D2D, I2R, and EIM) and Core Enabling (SYSADMIN, IAM and Testing CoE)..

Responsibilities:

Provided estimation and design for Enhancement and new change request received from Motorola solutions Inc.

Developed a Trilogy AR Audit Report.

Worked on an interface which involves standard seeded package and API’s to update the AP invoice details with reference to supplier level updates. This was a value added component to customers which reduces more manual effort for mass updates.

Worked on Enhancements for AR Invoice Printing Report.

Experience in development and enhancements on Backlog Analysis report, Inventory Sync Report and Infoship Interfaces(Black Box Interface).

Acted as a primary developer for Implementing break fix /enhancement and new components/reports interfaces for Motorola solutions Inc.

Unit test specifications, Unit test cases & Unit test Results.

Creating CAT test cases & coordination of CAT test cases.

Analyzing defects and defect fixing.

Implementation support and support plan.

Involved in migration related activities to PROD Kintana creation and moving code to clear case. Created CRQ and involved in migration activities worked in end to end process in the project.

Prepared Technical Design Documents and uploading into compass for review.

Hosting review meetings for design documents/Code with client.

Coordinating with offshore team for the implementation of assigned deliverable.

Environment: Oracle Applications 11i (BOM, WIP, INV, OM, ASCP, AOL, SYSADMIN) and Oracle Applications R12, Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP

Client: Motorola Solutions Inc., India

Role: Oracle Apps Technical Developer and Regression Test Lead.

Project Name: NA11i SOI Project

Duration: May 2014–October 2014

Project Description:

NA11i SCH SOI Project is an Development and Testing project. Project is all about implement the SOI (Supplier Owned Inventory) process for Schaumburg Org same as Existing Elgin Process. Elgin Org is for SOI will interface NA11i PO details to CTDI (Third Party System) now in SCH SOI Project implementing the SOI process for Schaumburg org i.e. once we create PO in NA11i it should reach both CTDI (Third Party System)through HUB with facility_code ‘ES’ and to Informatica Through HUB with facility_code ‘AF’ also Move Order Created in NA11i for Schaumburg should reach the CTDI through HUB and CTDI will process and send back to HUB and interface to NA11i.Receipt should be created in R12 WMS for both MOI(Motorola Owned Inventory) and SOI(Supplier Owned Inventory) Process and should interface to NA11i.The Project consists of both offshore and onsite team.

Responsibilities:

Analysis, design, development and Implementation of Customized Oracle ERP Solutions for new implementations.

Development of Components/ Enhancements to the existing code for the Purchase Order Module (PO) and HUB (UNIX).

Interaction with Client technical team for issues clarification and closing.

Major contribution and involvement in this engagement is by developing the invoice interfaces

Prepared Technical Design Documents and uploading into ClearCase for review.

Hosting review meetings for design documents/Code with client.

Coordinating with onsite team for the implementation of assigned deliverable.

As test lead reviewed all the testcases prepared by the testing team and externally reviewed with the client.

Created the CAT scenarios for NA11i to CTDI (Third Party System) integration testing inbound and Outbound Testing and helped the Client in the Customer Acceptance testing.

Involved in SIT testing activities coordinated with onsite and offshore team. And provided status report to the higher management.

Environment: Oracle Applications 11i (BOM, WIP, INV, OM, ASCP, AOL, SYSADMIN) and Oracle Applications R12, Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP

Client: Cigna corporation, India

Role: Oracle Apps Technical Developer.

Project Name: Cigna_Fin_IT_RdMap_ENSOL_OFF

Duration: January 2014–April 2014

Project Description:

CIGNA is an Health Care company which is using APPS R12.Re-implementation of the R12 project has been requested by CIGNA Which involves the development of conversions, interfaces reports and workflows.

Responsibilities:

Involved in analyzing and understanding the business requirement.

Good experience in interacting with customers to understand their technical queries and provide assistance in resolution.

Worked as a Technical consultant offshore for development Reports which includes XML reports depending upon the requirements.

Developed XML reports to be fired at Pick releasing the order and Shipping the order.

Developed Many XML Reports with bursting option to email reports to business users.

Modified the existing interfaces and supporting Stored Procedures to resolve the issues raised

Created Technical documents and Unit Test Plans.

Coordinating with onsite team for the implementation of assigned deliverable. Interaction with Client technical team for issues clarification and closing.

Environment: Oracle Applications 11i (BOM, WIP, INV, OM, ASCP, AOL, SYSADMIN) and Oracle Applications R12, Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP

Client: Motorola Solutions Inc., India

Role: Oracle Apps Regression/Functional Tester.

Project Name: Trilogy DB Upgrade Project

Duration: May 2013 –December 2013

Project Description:

Trilogy 3.2.7 Technical Upgrade testing project is the phase of Database technical upgrade project, There is no changes being done in Application functionality. After database upgrade, checking the trilogy critical touch point connections (clarify, Microsiga,FMW interfaces, E2open etc.)to ensure the application functionality is not broken from Trilogy R12.and performance testing using the Load Runner Tool and Manual Performance Testing Script.

Responsibilities:

Developed Test Scripts based on the understanding of the Customer Requirements from development requirements. SCPT has the complete End to End business flow including all legacy systems flowing in to it.

Responsible for planning and execution in order to ensure the existing trilogy flow is not disturbed by upgradation.

Worked on Manual Performance Testing for the critical business scenarios (Booking and pick releasing 100orders and ship confirm 100 orders and invoicing 100orders at a time to check the performance at the peak hours of business).

Recorded the performance scripts using the Load Runners tool as a functional tester helped load runner team for the execution of performance scripts functional flow to record the scripts

Monitoring the defects in Quality Center and solving them within the given SLA

Worked on various Oracle Apps Modules as part of the Project.

Interacting with the clients to understand the Business flow

Interact with the Developers to understand the functionality and perform quality testing on the components.

Review the Test Scripts of the other Team members and post review comments.

Environment: Oracle Applications 11i (BOM, WIP, INV, OM, ASCP, AOL, SYSADMIN) and Oracle Applications R12, Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP

Client: Motorola Solutions Inc., India

Role: Oracle Apps Support Analyst

Project Name: Motorola – Rain Forest Transformation

Duration: November 2012 –April 2013

Project Description:

The former Motorola is quite busy selling parts of itself lately. Private equity firm Vector Capital has reached an agreement with Motorola Solutions to acquire their broadband wireless business unit, which includes Point-to-Point (PTP) Orthogonal and Point-to-Multipoint (PMP) Canopy wireless lines. The private equity firm intends to operate the business as stand-alone unit and has named it Cambium Networks. Implementation of Cambium Networks Project program to differentiate the Motorola and cambium in SCM and Finance areas in Oracle Applications.

Responsibilities:

Involved in gathering business requirements.

Involved in the Conversion of Vendors from legacy system into Oracle Applications.

Involved in various Setups in AR, OM modules.

Customized reports and also standard Order to Cash process as per the business requirement.

Created Technical Notes and Documentation.

Developed SQL Reports and handled interfaces to meet the Business Requirements.

Involved in code migration using Kintana tool.

Interacted with customers to understand their technical queries and provide assistance in resolving them.

Performed Unit Testing.

Involved in Production Support issues.

Environment: Oracle Applications 11i (BOM, WIP, INV, OM, ASCP, AOL, SYSADMIN) and Oracle Applications R12, Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP

Client: Motorola Solutions Inc., India

Oracle Apps Technical Developer

Project Name: Motorola – Supply Chain Transformation Project

Duration: June 2011–October 2012

Project Description:

SCPT – Supply Chain Project Transformation project is the phase of implementing /developing the conversion phases of the structured Enterprise Resource Planning which is in SAP to R12 ORACLE APPLICATIONS ERP which seems to be helping the business operated on a single ERP technology which is maintained in multiple technologies prior.

The project is to handle the Development, Implementation and Enhancement activities for Motorola Solutions ERP Modules such as Order Management, Inventory and Procure to pay, Pricing applications. The specific activities involved are Implementation of development and enhancement requests, performance tuning, development of interfaces and resolving production issues in Order Management, Inventory and Procure to pay, Pricing modules. There are some customized modules developed by Motorola Solutions that are also included in the development and are linked with the Account Receivable modules. Since Order Management, Inventory and Procure to pay is the Application used by the Motorola for Taking Sales orders and Procuring goods. It is mandatory to have all the transactions intact and to date. Based on this information, Motorola decides the progress of its business. Remedy Request tool is used to log the production system and application related issues.

Responsibilities:

Analysis, design, development and Implementation of Customized Oracle ERP Solutions for new implementations and upgrades for the clients.

Preparation of Functional design documents, Technical design documents.

Development of Components/ Reports for various modules in ERP- Oracle Apps

Preparing the migration Plan and migrating the developed code to Certain environments

Completing Unit testing and rectifying the code as per requirements in system integrating testing and Customer acceptance testing.

Handling Change requests from Clients.

Done modifications to interfaces between Oracle and legacy systems.

Supported users for Cat testing and involved in Production activities.

Trained the End users with effective training manuals and process flow presentations which are self-explanatory.

Post Production Support and involved in support phase of the project.

Environment: Oracle Applications 11i (BOM, WIP, INV, OM, ASCP, AOL, SYSADMIN) and Oracle Applications R12, Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP

Project: TCS in-house project

Client: TCS, Hyderabad, India

Role: Developer

Duration: Feb 2011- May2011 (3 months)

Part of Initial Learning Program (ILP) conducted by TCS for its associates. Training includes orienting associates to TCS work culture, improving soft skills and learning a new technology and developing a mini-project for TCS

Developed a Library management system for TCS using Java,J2EE and using Eclipse IDE.

Backend database : Oracle SQL

Accolades for Ramya Thadisina:

Award Name

Awarded year

Awarded by

Awarded for

Moment Award

October 2012

Motorola Solutions Inc.

Individual award for bringing Finance applications to a steady state after huge implementation happened on Aug-2012

Star of the Quarter

March 2016

TCS

Individual award for extraordinary performance in Production Support resolving Complex as well as critical issues in a timely manner

Star of the Team

May 2017

Zebra

Team Award for converting Items from source to Target with very minimal fallouts.

Contact this candidate