Wind Energy Ge

Sr. Oracle Techno Functional Consultant

Swapna Thumma - adm0bl@r.postjobfree.com

Contact No: 832-***-****

EXPERIENCE SUMMARY:

EBS Oracle Applications Techno Functional consultant with over 15 years of experience in implementation, maintenance and production support.

Strong experience in Oracle Applications R12/11i (/11.5.9/11.5.10), SQL, PL/SQL, Oracle11g/10g/9i/8/12C.

Extensively worked on OTC (Oder to Cash), PTP (Procure to Pay) cycles and certified.

Expertise in Developing, Customizing and Implementation of Oracle Modules: Account Payables (AP), Account Receivables (AR), General Ledger (GL), Service Contracts (OKS), Install Base (CSI), Order Management (OM), Human Capital Management (HCM),Inventory (INV) Purchasing (PO), Bill of Material (BOM), Warehouse Management (WMS),HRMS(Human Resource management System), Project Accounting (PA), EAM (Enterprise asset management), Application Object Library (AOL) and Oracle System Administrator.

Good exposure to Oracle EBS SCM Discrete Manufacturing, process manufacturing (OPM), supply chain and planning processes.

Expertise in design and delivery of Oracle EBS technical objects like RICEW, Oracle Alerts, Triggers, Oracle BI Publisher, XML Publisher, Oracle Forms & Reports,OIC Integrations, Endeca Customizations, OAF personalization’s and exposure in extension of OAF pages .Six full lifecycle implementations experience (R12/11i) of PTP (Procure to Pay) and OTC (Order to Cash), Project Costing, Project Billing, OPS cycles going through Development (DEV), User Acceptance Test (UAT) and Production, User Training, go-live and post go-live Support in complex Multi-Org Environment.

Expertise in PaaS skills like OIC, VBCS,JCS, Web Service (Rest, Soap) and BI Publisher Reports.

Strong Programming Experience in writing Packages, Procedures, Functions and Triggers.

Good experience in Unix Shell Scripting.

Good understanding and exposure to Oracle Apps Data Model, Application Object library components (KFF, DFF, Value Sets etc.).

Excellent experience in Discoverer Administrator and to create workbooks using Discoverer Desktop and Discoverer Plus.

Experience in registration of concurrent programs, creation of Users, responsibilities, forms, functions, menu, values sets, request sets, request-groups in Oracle Applications.

Developed Technical documents for the customizations done on forms and reports.

Good Experience in Performance Tuning. Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.

Ability to learn and adapt to new technologies, good team player in dynamic work group environments.

Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment.

Strong interpersonal skills with ability to interact with people across all levels with capabilities

Education: Bachelor's Electronics and Communications - 2005

Technical Skills:

ERP: - Oracle apps R12, 11i and 10.7(OM, INV, PO, AR, AP, GL, BOM, WIP, OPM, HR, TCA, EAM, P2P, O2C and OPS cycles).

Front End tools: Oracle JDeveloper (11g, 10g), Forms6i/9i/10g, Workflow Builder2.6.3.5.

Reporting Tools: Oracle XML Publisher, Oracle Reports6i/10g, Oracle BI Publisher

Middleware: -Oracle SOA 10g, 11g

Tools: SQL* Plus, SQL* Loader, Toad, SQL Developer.

Languages: - SQL, PL/SQL, Java, UNIX Shell Scripting, XML, XSLT

RDMS: - Oracle 12C,11g/10g/9i/8i.

Operating systems: - UNIX, Windows

Education: B. Tech Electronics & Communication Engineering from JNTU – 2005.

Techno Functional Skills:

Operating Systems

UNIX, MS-DOS, Windows XP/NT/98/95.

Tools and Utilities

SQL Loader, TOAD, SQL Developer, Kintana, PVCS, HP Quality Center, Filezilla, WinScp, SSH Tectia Client, Alliance Remedy Tool, Data Loader, Visual Interdev, Loftware, RightFax, XML Gateway

ERP

Purchasing, Inventory, WMS, BOM, Inventory, WIP, Order Management, Accounts Receivables, Accounts Payable, General ledger, AOL and System Administrator

Databases

Oracle 8i/9i/10g/11g/12C, MS Access

Languages

SQL, PL/SQL, C, C++, Java

Web Related

HTML, ASP 3.0, Servlets.

GUI

Oracle Forms Builder, Report Builder, Oracle Discoverer, VB 6.0, Workflow builder

PROJECT EXPERIENCE

Middle River Aircraft Systems (MRAS) Sep ’19 –Till Date

The IT Department of Middle River Aircraft Systems (MRAS) is looking to separate the data pertaining to their business from the unified on-premise systems of GE Aviation and establish their own footprint in an Oracle Cloud Infrastructure. The activities will include, and are not limited to following:Separation of applications and data from GE Aviation Systems environment to include MRAS specific content and functionality.The carved out MRAS only instance of Oracle EBS will be migrated from on-premise to the Oracle Cloud Infrastructure.

Environment: Oracle Applications R12

Role: Sr. Technical developer

Created MD70 Technical Documents and developed many inbound/outbound integrations, extensions, workflows, XML reports, RDF reports, WEBADIs, OAF extensions and forms and oaf personalization’s.

Working on multiple interfaces like Purchase Orders, Purchase Order Receipts, AP invoices, Kronos Punch Timings, Employee Creation/updation/Termination/Rehire Interface, MyTime Interface etc.

Developed BI Publisher reports like PO PDF Report, AP Invoice Report, AP Ageing Report, FA Asset Report and many custom xml reports as per the business need.

Modified complex Requisition, Purchase Order, Change Order, Auto Create Purchase Order Workflows as per business need.

Created Requisition Import Webadi.

Auto Created Purchase order receipts once po is approved.

Developed complex custom extension to normalize the MES labour hours.

Developed lost time extension as per the business need.

Created Oracle SRs for oracle related issues and developed solutions as suggested.

Fixed all the issues/changes with quality within very less time.

Archrock, Houston TX May ’19 –Sep’ 19

Environment: Oracle Applications R12/Cloud

Role: Sr. Technical developer

Conducted design workshop, fit-gap analysis, solution design, configuration, different testing cycles and user training.

Created CF250 Functional and MD200 Technical and TE50 Test script documents.

Working on multiple interfaces like Item, Assets(EAM), Preventive maintenance Tasks(EAM), Customers, Sub inventories, Locators, Sales Orders, Purchase Orders, Projects, Project Tasks, Expenditure Orgs, Expenditure Types, AR Invoices, AP Invoices etc between IFS to EBS and EBS to cloud.

Developed integrations in OIC to take the files from FTP server and call the integration in oracle Cloud IFS to load the data into cloud.

Developed BI Publisher reports in cloud and EBS.

Developed Key reports like AR Invoice Report, Sales Order Acknowledgement, and Project Expenditure Summary Report etc.

Developed business analytics reports in oracle ebs and cloud

Developed web service development and architecture of (SOAP/REST) interfaces.

Created Oracle SRs for oracle related issues and developed solutions as suggested.

Fixed all the issues/changes within very less time.

GE Digital, Cincinnati OH Nov ‘17 – Dec’18

Environment: Oracle Applications R12, 12C

Role: Sr. Techno Functional Lead Consultant

Support and enhance the complete supply chain and finance track Technically and Functionally.

Lead technical and functional consultants of offshore team, understanding the complex requirements, designing solutions & setups, explaining the requirements to the Technical team and getting the work delivered by them.

Worked directly with client throughout project on various solution, presentations and discussions.

Conducted design workshop, fit-gap analysis, solution design, configuration, different testing cycles and user training.

Worked on many custom interfaces for 3rd party systems.

Worked on Projects, tasks, Expenditure Types, Expenditure Orgs Data conversion and interfaces.

Worked on HR Employee Creation/update conversions and interfaces.

Implemented proxy grants for user to switch between multiple accounts.

Create BP80, BR100, and MD50’s related to design.

Develop documentation and trained users for newly developed processes.

Was responsible for the entire technical project delivery.

Support and enhance the complete supply chain and finance track.

Worked directly with onsite team members throughout project on various solution, presentations and discussions.

Did web service development and architecture of (SOAP/REST) interfaces.

Conducted design workshop, fit-gap analysis, solution design, configuration, different testing cycles and user training.

Worked on many custom interfaces for 3rd party systems.

Create BP80, BR100, and MD50’s related to design.

Develop documentation and trained users for newly developed processes.

Was responsible for the entire technical project delivery.

GE Oil & Gas (Drilling Distribution Center, Houston, TX) Apr ‘17 – Oct ‘17

Environment: Oracle Applications R12

Role: Sr. Techno Functional Lead Consultant

Implement and Go-Live Support for migration of one services org to another organization

Designed and implemented conversions like, INV, On hand, Sub inventories, Locators etc.

Worked directly with client throughout project on various solution, presentations and discussions.

Conducted design workshop, fit-gap analysis, solution design, configuration, different testing cycles and user training.

Worked on custom interface for 3rd party PLM tool called ePIMS and oracle.

Create BP80, BR100, and MD50’s related to design.

GE Oil & Gas Hydrill US & Mexico Apr ‘16 – Mar’17

Environment: Oracle Applications R12

Role: Sr. Techno Functional Lead Consultant

Designed & Implemented an end to end Quality Solution with Multi Million $ impact to solve the gaps in Quality control in manufacturing and build data books for each finished assembly.

Implemented one of a kind E-Signature solution and automation of quality documentation to an external 3rd party system.

Worked on implementing and enhancing interfaces between PLM tool named ePIMS and oracle.

Developed business flows for To-be business process by interacting with end users to understand their pain points in shop floor.

Developed creation of Project Funding Agreement and Revenue Budget using APIs.

Build XML reports for AP, AR, PA, PO, INV, WIP, OM and HR / Payroll

Developed Oracle forms to correct the errors occurred in interface tables and resubmit the concurrent programs.

Involved in requirement analysis and technical analysis and involved in gap analysis to provide gaps between the existing business & Oracle Applications.

Prepared Test scripts and involved in Application Integration Testing and System Integration Testing.

Designed custom MES screen for faster clock-in and clock-out along with collecting operation specific information based on requirements at each operation.

Developed EAM Inbound/outbound interfaces and reports.

GE NHR Impact Analysis Project, Houston TX Apr '11 – Mar '16

Environment: Oracle Applications R12

Role: Sr. Techno Functional Lead Consultant

Review and analyze the specifications (CF250), BR100 provided by the Functional Consultant for all the components like Interfaces/Reports/ etc.

Prepare/Review the Technical Design Documents (MD200), MD007 for all the components developed and deliver to the customer.

Work closely with the offshore team and help where ever the Technical and Functional expertise is required to deliver the components on time.

Apart from handling team also developed few interfaces/reports and other components at onsite:

Worked on Design/Development of critical customer facing reports.

Worked on Design/Development of OM, INV, PO WEB ADI.

Worked on Design/Development the custom solution called as “Smart Trace”.

Worked on the Design/Development of WIP Job Resource Clock-In Details

Worked on the Design/Development of Item assignment to a Category

API’s to update the planner_code, fixed_lead_time and Category_code of the Items.

PO_CHANGE_API1_S. UPDATE_PO API to update the promise_date of the Purchase Order.

Interfaces/Packages/Functions/Procedures/Reports and other Objects developed.

Developed EAM Inbound/outbound interfaces and reports.

Vetco Gray Oil & Gas Implementation Mar '10 to Apr '11

Environment: Oracle Applications R12.1.3

Role: Offshore Techno Functional Lead Consultant

Involved in requirements gathering for Purchasing and order management module for various personalization and customizations to meet the business needs

Involved in requirement gathering.

Prepared module specific Design Documents (CF250, MD200 and Te50).

Prepared Test Scripts (TE40) based on the customer defined scenarios, documented & performed all Set ups (BR100), Involved and assisted COM super user in defining the future Business Process flows (BP80), mapped with standard oracle processes, and identified gaps.

Actively participated in analyzing the defects and fixing them.

Performed all the functional setups for purchasing module like Transaction types, Line Types, purchasing Options, Financial Options, Jobs, approval limits, Locations, Lookups etc.

Performed all the functional setups for Order management module like Transaction types, Line Types, Holds, and Defaulting Rules etc.

Configured the system as per the requirements, performed solution design, gap analysis

Performed unit and system integration testing during the Business Validations (BVALs), resolved issues, trained the supper users, conducted business simulation process and monitor the supper users in user acceptance tests, executed a detailed training strategy for the end users.

Involved in solution of cross-functional set ups related to Projects and AR Setup customer accounts and accounting rules in AR for the invoice revenue recognition.

Developed CEMLIS like interfaces, extensions, Reports and conversions AR, GL, OM, PO, CSD, WIP, PA modules.

Developed oracle forms as per the business needs.

Did SYS Admin tasks to help the project team members, participated during outages to do the sanity checks.

Worked as an onsite coordinator for the delivery of technical components.

Jenbacher, Hyderabad, India Jun '08 to Mar '10

Environment: Oracle Applications 11.5.10

Role: Technical Analyst - Offshore

Involved in requirements gathering for field service module for various personalization and customizations to meet the business needs.

Involved in requirement gathering for various UWQ nodes and sub nodes.

Done Technical Documentation for the INV, OM, WIP, MSCA modules as per (AIM) methodology.

Developed complex components like Invoice Printing Report, Field service Report, loft ware Labeling components

Developed Interfaces, extensions and reports with quality and reviewed others work.

Trained the team on loft ware Labeling and submitted White Paper on it.

Played a vital role in SIT and UAT phases by resolving the issues on time.

Performed unit and system integration testing during the Business Validations (BVALs), resolved issues, trained the supper users, conducted business simulation process and monitor the supper users in user acceptance tests, executed a detailed training strategy for the end users.

Played a key role in post-production support.

Had given knowledge transfer.

Developed EAM Inbound/outbound interfaces and reports.

GE Wind energy Spain Roll Out, Hyderabad, India Jun '07 to Jun '08

Environment: Oracle Applications 11i

Role: Sr. S/W Developer

Involved in Requirement gatherings and doing as-Is and To-Be process

Modified the existing components to support the Spain Operating unit.

Impact analysis for Enhancements and Preparing Technical Specifications

Gained knowledge in loft ware labeling on own and developed new components as per customer requirement

Developed the new components like reports, interfaces, forms and extensions on time and did the unit testing. Done all the technical and test script documents as needed.

Analyzing the root cause of the issues and fixed them permanently during SIT and UAT phases.

Effectively interacted with the functional people to resolve the issues quickly.

Supported the project after Go – Live for Post Production support by resolving many cases logged by users as a part of Day-to-Day support.

Trained Satyam team members as a part of Transition. Later mentored them and enabled smooth transition to take over production cases.

GE Wind Energy – Germany Implementation, Hyderabad, India May '06 to Jun '07

Environment: Oracle Applications 11i

Role: Software Developer

Involved in Requirement gatherings and doing as-Is and To-Be process.

Prepared Module Specific Design documents (MD50) and TE50s for RICE components.

Developed the components like reports, interfaces, and extensions on time and did the unit testing for the given Technical components.

Trained the team on XML Barcoding reports and written the White Paper submitted in Genpact.

Analyzing the root cause of the issues and fixed them permanently during SIT and UAT phases.

Effectively interacted with the functional people to resolve the issues quickly.

Supported the project after Go – Live for Post Production support by resolving many cases logged by users as a part of Day-to-Day support.

Trained Satyam team members as a part of Transition. Later mentored them and enabled smooth transition to take over production cases.

Global Services, Hyderabad, India Dec '05 to May '06

Environment: Oracle Applications 11i

Role: Software Developer

Supported the project after Go – Live for Post Production support by resolving many cases logged by users as a part of Day-to-Day support.

Worked on MSCA Components and created new pages.

Trained Satyam team members as a part of Transition. Later mentored them and enabled smooth transition to take over production case.

Contact this candidate