Project Developer
Resume:
PINKI BHADRA
***********@*****.***
SUMMARY
• Around 5 years of experience in designing, developing, converting, implementing and
upgrading Oracle Applications 11i, R12 using ORACLE 10g/9i, SQL, PL/SQL, Reports
10g, XML Publisher 5.6.3., E-Business Suite.
• Experienced in Oracle interface programming, Concurrent Manager, Performance tuning, Flex
fields, Value sets, Request sets, profile.
• Experienced in development of Inbound and outbound interfaces in modules such as
Accounts Payables (AP), General Ledger (GL), Fixed assets (FA) to import data from
legacy systems and integrate it into Oracle Applications using open interfaces, APIs and
utl_file Packages and SQL copy.
• Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components.
• Strong understanding of Oracle Application Object Library (AOL) and System
Administration, XML Publisher Administrator.
• In-Depth knowledge of the Apps data model, which helps in all aspects of development cycle such
as building Custom Reports, Data Validation, Data Import etc.
• Experienced in customizing standard reports as well as developing custom reports in Oracle
Applications using Oracle XML Publisher/BI Publisher and customizing Oracle Reports
10g .
• Experienced in setups like RTF templates, Data template, E-Text template of XML
Publisher.
• Experienced in Functional setups like Payment process profile, Payment format, Payment
document, Template for payment format, MOAC, General ledger setup like calendar,
currency, ledger, ledger set.
• Well versed with client server environment and tools like SQL*Loader, XML Publisher
desktop and TOAD.
• Experienced in PL/SQL Procedures, Functions and Packages, triggers, views, and
materialized views, dynamic sql, temporary tables and UNIX shell scripts .
• Experienced in all stages of documentation in the implementation life cycle, well versed in
creation of Business requirement document (BR),Technical requirement document (TR),
Detail design document (DD), Unit test case and Unit test results document (UTP, UTR),
User traceability matrix document (UTM), Production Migration document .
• Proven ability to quickly learn and apply new technologies with strong technical background.
Excellent analytical, problem solving skills and ability to follow through with projects from
inception to completion.
• Excellent Communication and Team Collaboration skills.
• Good understanding of accounting principles and financial processes.
Page 1 of 7
TECHNICAL SKILLS
ERP Oracle applications 11i (11.5.10), R12.
General Ledger (GL),
Accounts Payable (AP),
Fixed assets (FA),
Modules:
System Administrator,
XML Publisher Administrator,
Application developer.
Reports Oracle Reports 10g, XML publisher reports
Tools SQL*PLUS, TOAD, SQL*Loader, XML Publisher Desktop
Programming Skills PL SQL, SQL, Shell Scripts, C#, C++
OS Windows NT/2000/2003/XP, UNIX, Linux, MS-DOS.
TRAINED ON ORACLE APPS FRAMEWORK (OAF) FROM ORACLE (40
HOURS).
CERTIFICATIONS:
• Oracle PL/SQL Developer Certified Associate – May 2008
• Oracle certification “R12 Oracle Financials New Feature Fundamental Ed 1 PRV” – June
2008
• Oracle certification “11i eBusiness Suite essential for implementers Ed 4” – Sept 2006
• Oracle certification “11i System Administrator Fundamentals Ed 3” – Sept 2006
• Oracle certification “11i Navigate Oracle Applications Ed 2” – Sept 2006
• Oracle certification “11i Extend Apps-Forms Ed 1” – Sept 2006
• Oracle certification “Oracle 9i Reports Developer: Build Reports” – Sept 2006
• Oracle certification “Introduction to Oracle 9i : SQL” – Sept 2006
ACADEMIC QUALIFICATIONS:
• Master of Computer Applications (MCA) from Bangalore University (Mount Carmel
College), India with distinction.
• Bachelor of Computer Applications (BCA) from Bangalore University, India with distinction.
CURRENT WORK EXPERIENCE – PROJECT SUMMARIES
AT&T, San Ramon, CA Nov 2009-June 2010
Position : Technical Consultant
Oracle ERP Implementation and Reporting Team
This is an Implementation and Reporting project for AT&T. It involves the development of Interfaces,
Reports, PL/SQL Packages, Procedures and Scripts for the Oracle Applications R12.
Responsibilities:
Page 2 of 7
• Requirement gathering for development on FA Module objects.
• Creation of Detailed Design Document.
• Developed FA Asset Conversion Importing the asset from legacy systems to Oracle FA
• Developed FA Location Conversion Importing the location details from legacy systems to
Oracle FA
• Developed Custom Mass Add Wrapper
• Developed custom Retirement wrapper.
• FA Book Control Setups and FA Categories Setups
• Creation of custom new integrator.
• Designing and development of XML Publisher Reports Layout Templates and Data
Templates.
• Responsible for troubleshooting and resolving the day-to-day issues.
Accenture Services, Bangalore- India May 2009-Oct 2009
Position : Analyst Developer
Project Description:
Client is implementing the complete Oracle Applications e-Business Suite (Version 11.5.10 to R12).
Data from new Legacy system was to be brought in to Clients system as result of a new acquisition.
Project involves in Re-Designing the existing business processes based on the new R12 features and
capability. Project includes Data Conversion, Data Migration of GL Module.
Responsibilities:
• Handling Client meetings from offshore.
• Design and Develop the Technical Solutions (Detail design) for the Functional Specifications
provided and obtaining user signoff.
• Perform Impact Analysis and Identify areas which would affect the other RICE objects both
being developed and also the ones in Production.
• Did data mapping and data extraction for the Interface between the R12 and the legacy
systems
• Developing the Code for Conversions and interface in General Ledger in PLSQL which
includes packages, stored procedures, triggers, views, dynamic sql, temporary tables.
• Writing shell scripts to extract data, SQL Copy and to mail status of dataload.
• Creations of Concurrent programs, request set, value set, managing profile values.
• Creation of Unit test plan, Unit test results and implementation plan.
• Unit testing, System testing and supporting user testing.
Accenture Services, Bangalore- India Nov 2008-April 2009
Position : Analyst Developer
Project Description:
This was a Reporting project in which I had the complete responsibility for the development of new
reports, customization of the existing reports using Reports 10g and XML Publisher.
Highlights: Received appreciation from client AT&T as well as Accenture for quick and efficient
delivery.
Responsibilities:
• Developed and customized reports in General Ledger and Accounts Payable modules.
• Customized various XML Publisher reports using RTF templates, defining their respective
Templates and Data Definitions and adding parameters.
Page 3 of 7
• Converted Oracle 10g reports to XML/BI Publisher Reports.
• Used the features of BI Publisher such as Sort, Group, Total, Subtotals and dynamic
columns to make data intense operations happen at the template level.
• Created a package that contains different procedures and functions using Pl/Sql for
customizing standard reports like “Journal Entries Report”, “Journal day Book”, “Tax
Audit Report”,” Account Analysis Report”, “Payment Instruction Register ”.
• Developed Pl/Sql Packages to populate the data in to customized tables which were used to
create reports.
• Prepared various technical documents like technical design, detailed design, UTP, UTR,
Migration Document, Requirement traceability matrix.
• Responsible for troubleshooting, training offshore team and resolving the day-to-day issues
regarding XML output generation.
• Coordinated with users to ensure, System Testing was done and production install of code was
successful.
Accenture Services, Bangalore- India April 2008-Oct 2008
Position : Analyst Developer
Project Description: This project involved Customization of payment formatter as international
payment came into picture. The international payment which was done using oracle report needed to
be paid using standard payment process of R12.The International check formatters were for Canada,
Deutsche,Japan and Citi. Deutsche and Citi had many combinations of legal entities and operating
units for different countries.
Highlights: Received appreciation token from client AT&T as well as Accenture for quick
solution and turnaround.
Responsibilities:
• Gathering the business requirements by interacting with the clients
• Preparing the application design document separate for Canada, Japan, Citi and Deutsche.
• Customized Oracle Supplied user exit “IBY_FD_EXTRACT_EXT_PUB” package to invoke
payment process depending on the legal entity.
• Custom profile and lookup creation
• Setup for multiple Payment process profile.
• Setup for multiple Payment format.
• Setup for multiple Payment document.
• Setup for multiple Templates for payment format.
• Creation of multiple Etext rtf for payment format.
• Developing 4 different set of code for custom payment formatter in PLSQL which includes
packages, stored procedures, triggers, views, dynamic sql.
• Creation of multiple UTP, UTR and Installation guides.
Accenture Services, Bangalore- India Nov 2007-Mar 2008
Position : Analyst Developer
Project Description: This is an implementation project, in which my responsibilities were to develop
conversion packages in R12 for Accounts Payable from 3 sources which were in 11i.
Responsibilities:
• Gathering the business requirements by interacting with the clients
• Preparing the application design document and getting sign off.
Page 4 of 7
• Worked on Account Payables Interface to import vendor, vendor site and vendor contacts
from 3 different legacy systems.
• Developed shell scripts for dataload.
• Developed custom package to validate data in the staging table and insert data into AP
Interface tables.
• Preparation of UTP, UTR and migration document.
• Responsible for troubleshooting and resolving the day-to-day issues.
• Coordinated with users to ensure, System Testing was done and production install of code was
successful.
Accenture Services, Bangalore- India May 2007-Oct 2007
Position : Analyst Developer
Project Description:
This project involved upgrade to R12 and merger of international data which includes multiple ledger
ids, concept of MOAC.
Highlights: Received appreciation from client AT&T as well as Accenture for quick turnaround
and efficient delivery.
Responsibilities:
• Gathering the business requirements by interacting with the clients and leading a team in
offshore with 3 members.
• Impact analysis for Upgrade for GL and AP components.
• Creation of Detail Design Document.
• Customization of the assigned Components according to the Business Process Analysis and
development standards. The components were more than 400.
• Unit Testing.
• Conversion of multiple Oracle reports into XML Publisher Reports.
• Modification to FSG reports.
• Preparation of UTP, UTR and migration document.
• Responsible for troubleshooting and resolving the day-to-day issues, guiding team members
and ensuring efficient delivery.
Accenture Services, Bangalore- India Jan 2007-April 2007
Position : Analyst Developer
Project Description:
As a result of a merger many inbound and outbound interfaces were developed. The historic data was
archived into flat files and stored.
Responsibilities:
• Gathering the business requirements by interacting with the clients.
• Creation of Application development document.
• Written PL/SQL packages with cursors, functions and procedures for inserting the data into
vendors, invoices interface tables from various staging tables while validating the data.
• Written control files and shell scripts to load data from flat file and mailing the success status.
• Preparation of UTP, UTR and migration document.
• Creation of archival files for historic data for Accounts Payable and Fixed assets.
Accenture Services, Bangalore- India Sept 2006-Dec 2006
Position : Application Developer
Page 5 of 7
Project Description:
Conversion of General Ledger and Fixed assets for Adv.&Pub data from 11.0.3 to 11i..
• Developing the Code for Conversions in General Ledger and Fixed Assets in PL/SQL which
includes packages, stored procedures, triggers, views, dynamic sql, temporary tables.
• Developed validation packages based on the business rules for conversion.
• Look up creation and lookup data loading with data loader.
• Writing shell scripts to extract data, SQL Copy and to mail status of dataload.
• Creations of Concurrent programs, request set, value set, managing profile values.
• Performed system administration functions such as creation of users, Responsibilities and
Menus and Functions.
• Unit testing, System testing and supporting user testing.
Accenture Services, Bangalore- India May 2006-Aug 2006
Position : Application Developer
Project Description:
Conversion of General Ledger and Fixed Assets for BellSouth data from 11.0.3 to 11i.
• Developing the Code for Conversions in General Ledger and Fixed Assets in PL/SQL which
includes packages, stored procedures, triggers, views, dynamic sql, temporary tables.
• Writing shell scripts to extract data, SQL Copy and to mail status of dataload.
• Data loading from non oracle data source.
• Creations of Concurrent programs, request set, value set, managing profile values.
• Performed system administration functions such as creation of users, Responsibilities and
Menus and Functions.
• Unit testing, System testing and supporting user testing.
Accenture Services, Bangalore- India Sept 2005-April 2006
Position : Oracle Developer
• Involved during the preliminary design phase of the project and analyzing the requirements
and coming up with layout.
• Experience in using SQL*Plus and Toad for writing SQL scripts and PL/SQL programs.
• Knowledge of creating users and granting privileges to the same.
• Developed Control files for loading data from flat files to oracle database tables using
SQL*Loader.
• Developed PL/SQL Packages for data validation and for implementing the business rules.
• Wrote Database Triggers as needed to meet business functionalities.
• Development of Forms based on Procedures/Views etc.
• Usage of Dynamic Execute Immediate statements to fetch data as needed.
TECHNICAL ACHIEVEMENTS:
• Successfully conducted Accenture's internal trainings for XML Publisher reports Oracle
App.
• Developed documents on XML publisher reports for Accenture asset library.
• Awarded twice as best employee under the category of team player and proactiveness in
Accenture.
Page 6 of 7
Page 7 of 7
Contact this candidate