PRATYUSHA P Email: ac4j3s@r.postjobfree.com

Oracle Apps Developer Phone: 415-***-****

Visa Status: H4 EAD (No Sponsorship required)

PROFESSIONAL SUMMARY:

Over 5 Years of Experience in Analysis, Design, Development, Testing and Support of Software Applications using Oracle Applications 11.5.10/R12/1/3 spread across Version upgrades, Data conversions, extended product support, Localization Product Support and Customizations.

Supervising experience with 3 resources in a team, training them on PLSQL, Reports and forms.

Expertise in Oracle EBS configuration and enhancement.

Strong knowledge of RDBMS concepts.

Extensive experience in Oracle Application Modules which include Oracle Human Resources (HRMS),General Ledger(GL), Sub-ledger Accounting (SLA), Accounts Payable(AP), Accounts Receivable(AR), Oracle Projects(PA), Inventory (INV), Order Management (OM), Cost Management (CST), Pricing (QP).

Strong knowledge of Procure to Pay Cycles and overview on Order to Cash.

Proficient in Oracle SQL/PLSQL.

Experience in Integrating Oracle Applications ERP and Importing Data from various legacy systems into Oracle Applications using PL/SQL, SQL*Loader, SQL Plus, UTL_FILE and other tools.

Proficient in Reports 6i / 10g. Having Work Experience on XML Publisher reports.

Proficient in Oracle form 10g, developed around 5 forms from scratch using almost all the triggers and modifying pll’s when required.

Knowledge on Form Personalisation.

Hands on working experience with RICE Components (Reports, Interfaces, Conversions).

Programming skills in PL/SQL and SQL.

Preparation of Technical Design Documents (MD070), installation documents (MD120), test case documents and code development and support for RICE components.

Good knowledge in Creation of value sets, defining concurrent programs, Executables, PL/SQL Method of submitting Concurrent Programs.

Programming experience in developing Packages, Procedures, Functions and Database Objects like Tables, Views and Sequences.

Experience working with the UNIX Shell scripts.

Experience working with LINUX.

Have provided QA testing and UAT support for the objects I worked on.

Experience in Application Object Library (AOL) Framework for forms based applications.

Trained on OA Framework Personalization and deploying personalization.

Experience in environments requiring direct customer interaction during specifications, documentation, design and development and implementation phases.

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

A Good Team Member, Quality conscious with good communication and quick learner, leadership skills, capable of quickly adapting to new challenges and environments.

AOL SYSADMIN Tasks:

Created Users in oracle Applications with Responsibility.

Created Concurrent Programs and Executable, add concurrent program definitions to Request Groups.

Registration of forms and reports for custom applications.

Good Knowledge in API’s like FND_PROGRAM, FND_FILE, AD_DD, UTL_FILE.

EDUCATION: Bachelor of Engineering in Electronics and communication in 2011 from JNTU University Hyderabad, India.

AREAS OF EXPERTISE:

ERP

Oracle Applications (INV, OM, BOM,WIP, PO,AP, AR,GL,PM)

Oracle Tools Used:

SQL Developer, TOAD, winscp, sql*loader, APEX, Report Builder 6i and 10g, Form Builder, XML Publisher, Putty, PSFTP, Winscp, JDeveloper, dataloader, STAT, JIRA,web service

Language

Oracle 11i, R12, HTML, CSS,XML

Front end

Developer 6i,10g, R12

Packages

Microsoft Office

Operating System

Windows 7, UNIX, LINUX, Windows XP

Professional Experience:

Trained on OAF, Web service (after getting my USA Work permit) SEPT 2017 to NOV 2017

Oracle Application Framework is the development and deployment platform developed by Oracle to develop the Oracle E-Business Suite “Self-Service” or HTML based Applications. OA Framework, is based on the industry-standard Model-View-Controller (MVC) design pattern and can be used to develop extensions to existing E-Business Suite functionality.

Learning Objects: OAF model and architecture, object oriented reuse and components.

RBC – Regal Beloit Corp(Hitachi Consulting, Hyd) AUG2015 to AUG2016

Oracle Application Developer

One of the largest electric motor manufacturers in the world founded in 1955. In the 1980s the company expanded its product line with a series of acquisitions of smaller companies, and in 1991 its headquarters were moved to downtown Beloit. Its Genteq brand brushless DC electric motors are found in almost all variable-speed residential HVAC equipment in the United States today, and its GE Commercial Motors, Leeson, and Marathon Electric Motor brands are used throughout the industrial sector.

Role/Responsibilities:

Worked as a technical developer.

Worked on PO, OM Modules.

Analysing and understanding the Specifications and Business Requirement documents.

Understanding the functionality of the objects assigned.

Extracting data from interface tables, validating in PLSQL Procedures and to load to base tables by using corresponding API’s or by using standard concurrent Programs from backend.

Functional testing of INV, OM modules.

Developed new customized reports, forms as per client requirement.

Worked on Form personalisation on the custom form.

Creating buttons and writing logics behind to perform the actions.

Registration of Concurrent Programs Executables, Request groups and Request sets.

Migrating from one instance to other instance using STAT.

Handling production issues and giving solution on spot.

Used bulk collect and insert concepts to load bulk data on daily/weekly basis.

Monitoring 3 resources to train on PLSQL and reports.

Used JIRA for bug tracking and issue tracking.

Migrating the objects to UAT using STAT by preparing consolidated migration scripts

by giving instructions to DBA.

Technologies/Environment:

SQL, PLSQL, XMLP REPORTS, FORMS (6i, 10g), RICE COMPONENTS, UNIX, TOAD, EBS R12, JIRA, STAT

JOCOBS (Hitachi Consulting, Hyderabad) NOV2014-AUG2015

Oracle Apps Developer

One of the largest and most diverse providers of technical, professional and construction services, including all aspects of architecture, engineering and construction, operations and maintenance, as well as scientific and speciality consulting. Our 54,000 employees in 230+ locations around the world serve a broad range of companies and organizations, including industrial, commercial, and government clients across multiple markets and geographies.

Role/Responsibilities:

Worked as a developer. Developing PO Forms.

Analysing and understanding the Specifications and Business Requirement documents.

Understanding the functionality of the objects assigned.

Developed new customized forms as per client requirement.

Developed new customized 10g forms based on 6i custom form with the same logic using new architecture and new R12 tables.

Workflow to approve the Orders from the custom form.

Validating the huge data from 6i and loading into the new oracle database using db link.

Optimizing the query to have better performance. Maintain version control tool and appropriate deployment instructions.

Preparation of Technical Documents and test cases for forms and Interfaces.

Registration of form, Menu, Concurrent Programs, Executables, Request groups and Request sets.

Inbound interfaces in Pricing (QP) Module.

Extracting data by using required parameters based on the requirement.

Creation of Value sets and Request set as per business requirements.

Mentoring 3 resources to perform their activities on daily basis.

Tracking Production tickets and giving the solution.

Preparation of consolidated migration script and migrating to UAT.

Technologies/Environment:

SQL, PLSQL, Form Builder, EBS R12, SVN,STAT, SQL Developer, EBS R12

SENSATA Technologies (Apps Associates, Hyd) DEC2013 – NOV2014

Oracle Apps Developer

Sensata Technologies manufactures highly engineered devices which satisfy the world’s growing need for safety, energy efficiency, and a clean environment. These are devices that improve safety, efficiency and comfort for millions of people every day and are used in automotive, appliance, aircraft, industrial, military, heavy vehicle, heating, air conditioning, data, telecommunications, recreational vehicle and marine applications.

Roles and Responsibilities:

Understanding the functionality of the objects assigned.

Development involved BI Publisher Reports.

Worked on Requirement changes in the RDF reports.

Development of RTF by using different XML Functions and calculations in RTF.

Creating bursting XML File which splits the XML file and sends Email to the respective email Address with the respective order details.

Worked on AP, AR Modules.

Supporting the clients for changes in the reports by following the change instructions.

Development of custom data migrations.

Analysing and understanding the Specifications and Business Requirement documents.

Worked on SQL and PL/SQL which involves all the custom objects migration from 11.0.3 to R12.

PL/SQL script with mapping and validation to insert / update data from one instance to other oracle Applications base tables using DB link.

Created Tables, Indexes, Views, Synonyms, Procedures, Functions, Packages and Triggers.

Worked on HRMS API’s – hr_employee_api, hr_assignemnt_api, hr_phone_Api, hr_person_Address_api,hr_locations_api,hr_organizations_api

Preparing the MD070 Documents based on MD050 for each component.

Preparation of test cases and doing functional testing for the objects I worked.

Production support for the objects I worked on.

Working closely with DBA as a part of migration.

Technologies/Environment:

SQL, PL/SQL, BI Publisher, SQL Developer, EBS R12

American Tower Corporation (Apps Associates, Hyd) DEC 2011 to NOV 2013

Oracle Apps Developer

American Tower (NYSE: AMT) is a leading independent owner, operator and developer of wireless and broadcast communication real estate. Our global portfolio includes over 56,000 owned or managed sites and is experiencing steady growth. In addition to leasing space on towers, we provide customized colocation solutions through our in-building systems, outdoor distributed antenna systems and other right-of-way options, managed rooftops and services that speed network deployment.

Roles/Responsibilities:

Understanding the functionality of the objects assigned.

Worked as a developer. Developing RDF Reports.

Worked on Item conversions.

Worked on Report enhancements as per needs.

Worked on sales order and RMA Conversions by validating date provided in excel file.

Modifying RDF reports and their layouts as per client’s new requirement.

Modifying the calculations in RDF reports as per new OU.

Analysing and understanding the Specifications and Business Requirement documents.

Working on Receivables, General ledger, Property Manager Modules.

Worked on preparing different types of RTF’s as per the requirements

Analysing and debugging the RTF’S Calculations and correcting the wrongly printed values in the report.

Given 24/7 support on RICE Components.

Functional testing for all the objects which I worked on.

Preparing test case document and technical documents.

Migrating the objects to UAT using STAT.

Working with DBA as a part of migration.

Technologies/Environment:

SQL, PL/SQL, 10g REPORTS, EBS R12

Contact this candidate