Developer Oracle

V SaiAnusha V

Mail: *********@*****.***

Contact No: +1-717-***-****

PROFESSIONAL SUMMARY:

Having 7+ years of experience in the IT Industry with proficiency in Software Design, Development and Deployment of Web applications using Oracle Applications and related Technologies in Financial, Banking, Healthcare, Marketing and Telecom Domains.

Experience in ERP Oracle Apps Development, Maintenance, Implementation, Production Support and Testing.

Worked on RICE Components in Oracle ERP Applications.

Hands-on experience of working on numerous oracle tools including Oracle Forms 9i,Reports 9i, OAF,SQL DEVELOPER,PLSQL DEVELOPER, SQL * LOADER and PUTTY.

Worked on XML Publisher Reports.

Good knowledge on Work Flow and Discoverer Reports.

Worked on Data extractions and Data loads using PL/SQL scripts.

Proficient in writing Stored Procedures, Packages, Triggers, Functions, Collections, Records, PL/SQL Tables using SQL & PL/SQL.

Experience in writing Test Cases, Prepared Master Test Plans, did unit and integration testing and also performed Unit Testing for different PL/SQL packages.

Extensive experience in writing Oracle backend objects like: Database Triggers, Stores Procedures, Packages and Functions using PL/SQL.

Worked extensively on Oracle Applications 11i&R12 E-Business Suite with a focus on implementation, customization and enhancements.

Experience in Production application Services and Production Database Services.

Experience in maintenance to production support applications and databases to fix issues, performance and data growth monitoring.

Proficient in using Environments Oracle Applications 11i & R12.

Proficient in using SCM, FINANCE, ACCOUNTING, HRMS, INCENTIVE modules.

Worked on AIM Methods.

Worked on development of interfaces like Inbound and Outbound interfaces.

Extensive experience in PL/SQL Programming and Oracle Reports 9i.

Worked on Design and Development of Interfaces and Data migration using SQL Loader, Oracle open interfaces.

Creation of users, responsibilities, menus and request groups.

Experience in working with Third party tools.

Expertise with using Oracle database and writing and tuning SQL and PL/SQL queries.

Used Putty, SSH, Telnet for UNIX login to check the server logs.

Good exposure on using JDEVELOPER to develop OAF pages.

Good knowledge on OAF Forms. Worked on developing OAF Forms.

Exceptionally well organized, strong work ethics and willingness to work hard to achieve client requirements.

Ability to learn new technologies quickly.

Possess excellent analytical and leadership skills and Strong ability to multi task and prioritize work load.

Excellent verbal and communication skills with ability to work in a team and as well as individually.

EDUCATION:

Bachelor in Computer Science from JNTU India.

SOFTWARE SKILLS:

ERP Tool

Oracle Applications 11i&R12

Languages

SQL, PL/SQL, Java, C, C++, Java Script, HTML

Oracle Applications

AP,PO,INV,GL, AR,HR,PA,OIC,OFD and OM

Tools and Utilities

PLSQL DEVELOPER,SQL DEVELOPER,PUTTY,SQL*Loader, SQL*Plus, Work Flow,XML Publisher,JDEVELOPER

GUI (D2K)

Oracle Developer 2000

Operating Systems

Windows 98/2000/XP/2003 Server, UNIX/LINUX

PROFESSIONAL EXPERIENCE:

Worked on Tata Consultancy Services, India from April 22nd 2015 to June 22nd 2018.

Worked on IGATE Global Solutions, India.

Worked on Associate Consultant for RITWIK IT SERVICES, India.

PROJECT EXPERIENCE:

Client: XEROX (U.S.A.) SEP 2016 – June 22nd 2018

Role: ERP Oracle Apps Developer

Environment: Oracle Apps 11i/R12

Description: Xerox Corporation is a $15.7 billion technology and services enterprise that helps businesses deploy Smarter Document Management strategies and find better ways to work. Its intent is to constantly lead with innovative technologies, products and services that customers can depend upon to improve business results. Xerox Corporation offers an innovative array of color and black-and-white digital printers, digital presses, multifunction devices, and digital copiers, as well as a broad range of services, solutions, and software. Xerox is a leader in document technologies, products, and services, which helps to improve work processes and business results.

Responsibilities:

Production application services – The services include maintenance to production applications to correct faults (fix when broken), performance monitoring, and problem support.

Production database services – The services include database administration, maintenance to production databases to correct faults (fix when broken), performance and data growth monitoring, and purging and archiving of data.

Worked on Resolving Tickets, databases to fix issues and data growth monitoring.

Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables.

Responsible for making the PL/SQL code changes.

Involved in Importing the Order Management data from legacy system to Order Entry Interface tables using SQL*Loader, validating the data using PL/SQL Script and Creating Orders using Order Import Program.

Used Putty, SSH, Telnet for UNIX login to check the server logs.

Client: Saudi Telecom Company (STC) APR 2015 – AUG 2016

Role: ERP Oracle Apps Developer

Environment: Oracle Apps R12

Description: Saudi Telecom Company, together with its subsidiaries, provides telecommunications, information, and media services in the Kingdom of Saudi Arabia and internationally. The company’s GSM segment offers mobile, third and fourth generation prepaid card, international roaming, and messaging services. Its PSTN segment provides fixed line, telephone car ds, interconnect, and international call services, wholesale and retail trade of recharge card services, and telecommunication equipment and devices and maintenance and operation of commercial centers. In addition, the company operates and maintains telecommunication, computer systems, and Internet networks and operates, maintains, and installs telecommunication and information technology systems and programs. Further it provides mobile, international telecommunications, broadband, and other related services. The company was founded in 1998 and is headquartered in Riyadh, the Kingdom of Saudi Arabia.

Responsibilities:

Worked on OAF reports. Worked on OAF forms.

Training the end users and preparing end user training material.

Attending Review calls, team meetings and knowledge sharing meetings.

Worked on UNIX to upload the data into database tables.

Worked BRSD rejection reason Interface to upload all the rejected orders.

Developed PLSQL code for OAF forms.

Developed PL/SQL Packages, Procedures, Functions, Triggers For OAF reports.

Developed PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQL*Plus.

Developed Generic Packages using PL/SQL to build flat files to migrate data from Legacy to Oracle Systems.

Worked on UNIX to upload all the orders into database tables.

Developed OAF forms to view the manager details, user details.

Preparing End user manuals to all the developed pages.

Worked on Monthly calculation run and Quarterly calculation run for EBU Reseller.

Client: NATIONAL RESPONSE CORPORATION (U.S.A.) JUN 2014 – FEB 2015

Role: ERP Oracle Apps Developer

Environment: Oracle Apps R12

Description: National Response Corporation (NRC) is one of the largest providers of oil spill response

Services in the United States. NRC Environmental Services Inc., a leading provider of environmental

And industrial services on the West Coast; and SEACOR Response Inc., which provides oil spill and

Emergency response services to in various international markets.

Responsibilities:

Building the SQL Queries. Worked on custom and customization of forms.

Requirement Study in detail.Interaction with client/end users & updating the status.

Training the end users and preparing end user training material.

Attending Review calls, team meetings and knowledge sharing meetings.

Working with third party tools.

Worked on Interfaces.

Developed Prepayment Receipt Report using XML Publisher.

Reviewed the Existing System and prepared Loader Scripts to migrate the data from Existing System to new Oracle System.

Worked on PO Interface to upload the Headers, Lines and Distributions Details from the legacy to PO Base tables.

Worked on Supplier Interface.

Developed Outbound interface to extract data from Base tables to Flat file using the UTL_FILE utility in HRMS module.

Developed PL/SQL package to insert customer information using TCA API. Worked on Customer open Invoices Conversion in AR for importing open invoices data from legacy system. Developed a script to exchange sites info in AP from one Operating Unit to another.

Customized GL Search Form by enabling existing DFF to store tax details.

Customized PO Workflow to populate the Charge account in PO distributions.

Client: BLUE STAR (U.S.A.) JUL 2013 – MAY 2014

Role: ERP Oracle Apps Developer

Environment: Oracle Apps 11i/R12

Description: BlueStar, Inc. is the leading innovator in solutions-based distribution for RFID, Auto 1D, POS, and Mobility products. BlueStar is committed to working exclusively with Value-Added Reseller (VAR) partners to help deliver the finest Supply Chain, Mobility, and POS hardware and software solutions in the world.

Responsibilities:

Requirement Study in detail.Interaction with other modules consultants.

Training the end users and preparing end user training material. Interaction with client/end users & updating the status.

Attending Review calls, team meetings and knowledge sharing meetings.

Testing P2P and O2C cycles.

Customization of forms, reports and xml publisher reports.

Worked on Query find Forms.

Customized Invoice History Report.

Design and Developed a Sales Order Report - XML Report.

Worked on Item Interface to upload items including Categories and revisions.

Worked on Daily Rates Interface to upload exchange rate dates from legacy systems to GL Base Tables.

Worked on Forms Personalization.

Client: Black & Veatch APR 2011 – JUN 2013 Role: ERP Oracle Apps Developer

Environment: Oracle Apps R12

Description: Black&Veatch is a global leader in engineering, procurement and construction (EPC) services for the crucial areas of energy, water, and telecommunications.

Responsibilities:

Requirement study in detail. Interaction with other modules consultants.

Testing all the componants.Testing P2P and O2C cycles.

Developed customization of forms, Reports.

Preparation of Test Plan and Day to Day Execution schedule.

Test cases creation and execution for Account payables, Account Receivables modules and Order to cash cycle. Testing INV, PO, OM, AP, AR, GL modules.

Testing Estimations for R12 Implementation.

Preparation of Test Strategy Document.

Review of Test Scripts and deliverables done by offshore team.

Conducting knowledge transfer trainings.

Sending Status updates to the client daily.

Interaction with client/end users & updating the status. Training the end users and preparing end user training material.

Contact this candidate