Oracle Project
Resume:
SRUJANA REDDY
***.*****@*****.***
SUMMARY
. Over 7 years of technical experience in Application development, design
and customization of various modules in Oracle Applications.
. Strong in SQL and PL/SQL for writing queries and packages for
Conversions, Interfaces and Customizations.
. Extensive Techno-Functional knowledge and experience in Oracle
Applications including Accounts Payables(AP), Accounts Receivables(AR),
Purchase Order(PO), Core HRMS, Payroll, Fast Formula, Advanced Benefits,
Approval Management Engine(AME), Partner Management, Trading Community
Architecture(TCA), Oracle Time and Labor(OTL), Service Contracts, Install
Base.
. Expertise in Applications Object Library (AOL), System Administration,
Forms, Reports, XML Publisher, SQL *Loader, SQL, PL/SQL, OA Framework
(OAF), APEX.
. Experience in upgrading to Oracle apps R12/11i and Implementation of
Oracle Apps 11i/R12, proficient in customizing the Workflow.
. Extensive experience in customizing and building workflows using Oracle
Workflow Builder.
. Extensive experience in building E-Business Suite reports using BI/XML
Publisher.
. Extensive experience in developing and customizing forms and reports.
. Expertise in development of Interfaces and Conversions in Oracle
Applications.
. Expertise in Development, Maintenance and Support of database objects in
Oracle 9i and Oracle 10g.
. Strong experience of working on Oracle Application Implementation
Methodology (AIM) and other custom methodologies for implementation and
upgrade.
. An organized professional with excellent interpersonal communication
skills.
. Responsible for Oracle 9i/10g administration tasks like User/Role
Management, database backup/recovery and physical database management.
. Have about a year's experience in developing simple reports with APEX.
. Well versed with SQL Tuning, Backup, Restoration and Replication
techniques.
. Have vast experience in using UTIL files in various PL/SQL packages.
. Extensive experience in developing applications using Oracle RDBMS
10g/9i/8i, Oracle Forms4.5/ 6i and Oracle Reports 2.5/6i (Developer
2000/Developer Suite), Oracle Discoverer.
. Excellent written and oral communication, Interpersonal and Analytical
skills.
TECHNICAL SKILLS
Languages: SQL, PL/SQL
Databases: Oracle 8i/9i/10g, SQL Server 2005/2008
Framework: Oracle Application (OA) Framework, Oracle Application Object
Library (AOL)
ERPs: Oracle Applications 11i/R12 (eBS, Core HR, Payroll, Advanced
Benefits, AP, AR,GL, Service Contracts, Trade
Management, Trading Community Architecture(TCA),
Oracle Time and Labor(OTL), Project Accounting(PA),
Approval Management Engine(AME), AOL, Sys Admin),
Alerts.
Tools: Developer/2000 (Forms 6i/ 4.5, Reports 6i/ 2.5), OAF, Oracle
Tools (Workflow Builder, OWB 9.0.4), TOAD,
SQL*Loader, XML Publisher, APEX, OA Framework,
Business Objects.
Documentation: CV040, CV060, CV070, CV120, CM040, MD050, MD070, MD120,
TE020. (Requirement, Design, Unit Testing,
Installation and Signoff Documents).
Scripting Tools: C, C++, Unix Shell Script, XML, SQL, PL/SQL, SQL*Plus
Markup Languages: HTML, XML
Version Control: Win CVS
Operating Systems: Linux, Unix, Windows XP/2003/2008
PROFESSIONAL EXPERIENCE
Intelsat Corporation, DC
Jun 11 - Till Date
Senior Software Engineer
This project is involves supporting Oracle Applications and developing
various customizations and enhancements to meet the business requirements..
Responsibilities:
. Interact with the business users to understand their business
requirements and develop the same.
. Work with the financial, HR and payroll team for addressing their issues
and requests of Oracle Applications.
. Develop various enhancements and customizations to cater to the business
needs.
. Single point of contact as techno functional.
. Actively involved in the analysis for R12 upgrade to be done in house.
. Customized the iexpenses to cater to the business requirements.
. Support the Oracle Applications requests by addressing the production
requirements of the business users.
. Working on developing business object reports for the Payroll team to
verify time card data.
. Address various production requests for financial and HR business users.
Cisco Systems, NC
Dec 10 - May 11
Techno Functional Lead
This project is involves implementing Oracle Applications R12 of Core HR,
Payroll and irecruitment. It involves conversions, interfaces and
customizations.
Responsibilities:
. As a techno functional lead, am the single point of contact between the
HR business users and the offshore team.
. Have been working on the conversions and interface of the core HR Modules
. Interact with the HR business users for gathering the functional
requirements and document the functional specification (MD050).
. Have customized the approval hierarchy in the Manager Self Service, per
the business users functional requirement.
. Have designed and developed payroll interfaces to send payroll
information to third party (ADP) payroll systems for North America,
Europe and APAC regions.
. Have developed the outbound 401K interface for generating a 401K
contributions extract for employees using PL/SQL.
. Have translated the functional specification (MD050) to the technical
design document (MD070).
. Developing scripts to convert prospective parties to customers using TCA
API's.
. Developing conversion programs for bringing in 11.5.10 financial data of
Receivables and Payables to R12.
Oracle Corporation
Mar 05 - May 10
Staff Consultant
Rutgers University, NJ
Oracle Applications Upgrade from 11i to R12
This project was an upgrade from Oracle Applications 11i to R12 of Core HR,
Payroll and Oracle Advanced benefits. It involved conversions, interfaces
and reports development.
Responsibilities:
. Worked on Oracle Applications R12 project, an upgrade from 11i to R12, as
the team lead for an university in all the conversion and testing
activities for bringing in the HR data of the employees of the client.
This involved in validation, conversion and testing of the information.
. Developed PL/SQL packages to bring in time card data to the OTL system.
. Led the team for all the conversion activities, which included in
bringing in data of Employees, Ex-Employees, Address, Phones, Contacts,
Elements, Salary, Assignment, EIT, SIT, Payroll Balances, Federal Tax,
State Tax information.
. Developed inbound and outbound interfaces using PL/SQL for Advanced
Benefits, for the client to integrate with third party system for payroll
processing.
. As a lead of conversions, was involved in the review of the design and
test scripts and testing of the object before the release to client for a
final testing and approval.
. Lead developer for SQL *Loader scripts for loading data into staging
tables for various conversions and inbound interfaces.
. Developed various UNIX scripts for installation of the concurrent
programs and PL/SQL packages across various instances.
Environment: Oracle Apps R12, Oracle 10g, SQL Loader, Win CVS, Workflow
2.6, Win NT and UNIX
Project Scope: Oracle Application (Core HR, Payroll, Advanced Benefits)
Sun Microsystems, CA
Oracle Applications Implementation
This project was implementation of Oracle Applications R12 of Install Base,
Service Contracts, Purchase Order, Inventory, and Accounts Receivable. It
involved development of various interfaces and extensions.
Responsibilities:
. Team lead of four on the project in implementing Oracle Service Contracts
and Install Base.
. As a lead, worked closely with the team and the functional users to co-
ordinate the testing of the developed objects.
. Worked on developing PL/SQL scripts for bringing in the Purchase Order
data from the legacy data base system to Oracle Applications.
. Customized the standard format of Purchase Order report program by using
the XML Publisher report format, which gives an integrated and cost
effective method of creating of report output directly from E-Business
suite without using any third party tool. The report will be customized
to display Purchase Order attachments in pdf format using a series of
custom programs designed for this purpose.
. Was involved in developing PL/SQL scripts to users and user logins for
access to partner data of the customers in the Oracle Applications using
the Partner Management.
Environment: Oracle Apps 11i, Oracle 10g, Reports 6i, Forms 6i, SQL Loader,
Win CVS, Win NT and UNIX
Project Scope: Oracle Application (Core HR, Payroll, Service Contracts,
Install Base, AR, PO)
Hong Kong Hospital Authority, HK
Oracle Applications Implementation
This project was implementation of Oracle Applications 11i. The work
involved more on interfaces and extensions, development of fast formulas on
Core HR and Payroll.
Responsibilities:
. Involved in understanding the client's third party system to capture
their employees insurance details, document the requirements of the
client to have the same information captured with the oracle system.
. Developed Fast Formulas for payroll processing of the client.
. Involved in working with the client in help facilitate their testing of
the objects developed which included help them understand the oracle
system for the HR modules.
. Point of contact between the client and the offshore team for the
development of inbound and outbound interfaces to integrate with the
third party payroll system.
. As an onsite coordinator, was the single point of contact in having the
set ups completed from offshore across multiple instances.
Environment: Oracle Apps 11i, Oracle 10g, SQL Loader, Win CVS, Workflow
2.6, Win NT and UNIX
Project Scope: Oracle Application (Core HR, Payroll)
Ciena Corporation, Baltimore
Oracle Applications Upgrade
This project was an upgrade from Oracle Applications 11.5.6 to 11.5.10
which involved conversions of Core HR, Accounts Receivable, Accounts
Payable, General Ledger, Purchase Order, and Inventory.
Responsibilities:
. Was involved in the development of the conversion routines to migrate HR
data from 11.5.6 to 11.5.10.
. Worked with the client to help them understand the data issues and help
them clean the 11.5.6 data, to further facilitate a clean migration to
11.5.10.
. Was the single point of contact to migrate the complete HR data that
included Applicants, Ex-Applicants, Employees, Ex-Employees, Contingent
Worker, Address, Contact, Phones, SIT, Assignment with history, Payment
Method, Elements, Salary.
. Developed scripts to migrate supplier data from 11.5.6 to 11.5.10 using
SQL *Loader and PL/SQL using API.
. Supported the post production issues and developed a few scripts post go-
live for facilitating a few new requirements.
. Developed various unix scripts to migrate the code to various instances.
Environment: Oracle Apps 11i, Reports 6i, Forms 6i, SQL Loader, Win CVS,
Win NT and UNIX
Project Scope: Oracle Application (Core HR, Payroll, AR)
Avago Technologies
Oracle Applications Implementation
This project was implementation of Oracle Applications 11i for Accounts
Receivables, Accounts Payables, Inventory, Purchase Order, Bill of
Materials, Trade Management, Partner Management, Trading Community
Architecture.
Responsibilities:
. Developed SQL *Loaders and PL/SQL scripts to migrate Customer information
using API's.
. Developed scripts to convert prospective customers as partners and create
various customer accounts.
. Was involved in interacting with the client for the various cleanup
activities of data to be migrated, and help them understand the TCA for
further processing of customer data.
. Was also involved in a poc to convert prospects to customers and create
their login accounts to the oracle applications using api's .
. Developed conversion program/package using PL/SQL to bring in PO vendor
information using API's.
. Was involved in using the Kintana package to migrate code across various
instances.
. Developed various SQL *Loader and PL/SQL scripts to bring in the AP Open
Invoices data to Oracle Interface tables and further execute the seeded
Open Interface Program to migrate the data to Oracle 11.5.10.
. Developed PL/SQL script to bring in Service Contracts data using SQL
*Loader and PL/SQL Package using API.
Environment: Oracle Apps 11i, Oracle 10g, SQL Loader, Win CVS, Win NT and
UNIX
Project Scope: Oracle Application (TCA, AR, Trade Management, Partner
Management)
Stanford University
Oracle Applications Upgrade
This project involved customization of various seeded reports like the
Invoice Report and development of new reports using reports 6i for Oracle
Applications 11i.
Responsibilities:
. Customized the seeded AR Invoice report to generate a report per the
business requirement of the client.
. Developed a few XML Publisher reports to print the invoices on pre-
printed stationary, this included, customizing the seeded report using
XML Publisher, testing the report remotely with client to ensure the
invoice printing is facilitated per the design of the pre-printed
stationary.
. Developed a few customer related reports and check related information
using Reports 6i, for printing on pre printed stationary.
. Developed conversion programs for bringing in Open Invoice Data from the
11.5.6 to 11.5.10 using PL/SQL.
. Developed a conversion program to bring in the vendor details of the
Stanford University.
Environment: Oracle Apps 11i, Oracle 10g, Reports 6i, Forms 6i, SQL Loader,
Win CVS, Win NT and UNIX
Project Scope: Oracle Application (Core HR, Payroll, AR, AP, TCA)
Vault Consulting Union, India
Apr 04 - Feb 05
Associate Consultant (Onsite at Oracle India Pvt. Ltd.)
Buzzi Unicem, TX
Oracle Applications Implementation
This project was implementation of Oracle Applications 11i for modules like
Core HR, Payroll, and Trading Community Architecture. It involved
development of various conversions and interfaces.
Responsibilities:
. Worked on developing SQL Loader scripts to load all the HR related data
from flat files into the staging tables for the conversion activities.
. Registered concurrent programs for SQL Loaders, and for conversion
programs.
. Downloaded LDT's of the concurrent programs registered for SQL Loader,
Conversion, Interfaces, Request Group to which all the programs were
attached.
. Developed conversion programs using SQL scripts and PL/SQL packages to
migrate HR data of address, contacts, phones, payment methods and
elements.
. Developed an outbound interface to generate the 401K extract.
. Developed various Unix scripts to install the conversion and interface
objects across multiple instances, which included downloading and
uploading the LDT's of various concurrent programs.
. Developed an interface for handling the Project Accounting Information.
. Developed a kronos inbound interface to create the time cards of the time
entered by each employee and validate, and transfer the information to
Batch Element Entry for the element entries to hold the information.
. Developed a CIGNA Outbound interface to generate an extract of active and
terminated employees enrolled in the Dental plan, extract file being ' '
delimited.
. Developed a outbound interface to capture Customer, customer ship to and
bill to information in a custom table per the requirements of the client.
Environment: Oracle Apps 11i, Oracle 10g, SQL Loader, Win CVS, Win NT and
UNIX
Project Scope: Oracle Application (Core HR, Payroll, AR, TCA)
Huntington Bank, TX
Oracle Applications Implementation
This project was implementation of Oracle Application 11i. It involved
development of conversions and interfaces for Core HR, Payroll and Advanced
Benefits.
Responsibilities:
. Developed an outbound interface using PL/SQL to generate a 401K extract
for the employees of Huntington Bank.
. Worked on developing SQL Loader scripts to load all the HR related data
from flat files into the staging tables for the conversion activities.
. Registered concurrent programs for SQL Loaders, and for conversion
programs.
. Downloaded LDT's of the concurrent programs registered for SQL Loader,
Conversion, Interfaces, Request Group to which all the programs were
attached.
Environment: Oracle Apps 11i, Oracle 10g, SQL Loader, Win CVS, Win NT and
UNIX
Project Scope: Oracle Application (Core HR, Payroll, AR, TCA)
Defense Research Development Organization (DRDO), Bangalore, India Sep 03
- Mar 04
Developer
The project mainly involved development of forms and reports for analysis
of aircraft test data.
Responsibilities:
. Was involved in the development of designing and implementing a user
interface using Oracle Forms 6i, for capturing of the purchase order
information of the vendors.
. Developed SQL *Loader scripts for loading processed test data of into
backend tables to generate reports for data analysis.
Environment: Oracle Apps 11.5.9, Oracle 9, Reports 6i, Forms 6i, SQL
Loader, Win NT and UNIX.
AWARDS AND RECOGNITIONS
. Bravo Award for Outstanding Consulting Achievement, Oracle India, 2007
. "QOOL Award" - Consulting Club, Awarded to select outstanding achievers,
Oracle India, 2007
. Best Consultant for Practice Initiative, Oracle India, 2006
CERTIFICATIONS
. R12: Oracle E-Business Suite Essentials for Implementers Certified.
. Oracle Certified Associate for SQL
EDUCATION
Bachelors in Computer Science and Engineering, KSIT Bangalore, India
Contact this candidate