PUJA AGARWAL
SUMMARY:
Over eight years in the Information Technology industry, which includes:
Over five years of experience in analysis, design, development and
implementation of information systems and real-time relational database
applications, predominantly in Oracle development tools -Oracle
Manufacturing/Financials 10.7/11i and Oracle databases (10g, 9.X, 8.X, 7.X).
Well conversed with the Oracle AIM Methodology and specialized in usage of
Oracle Discoverer. Oracle Applications activities include customization,
development, system administration, system testing, documentation, user training
and user support.
Over one year of experience in ETL Informatica , TeraData and Cranberry. Was
part of SAP implementation at PepsiCo.
Over Two and a half years of experience in client server technology, working
on development, testing, and implementation for Back-Office module of Card
Management System using Oracle-8i/9i, PL/SQL, Forms-6 and Reports-6, Pro*C and
Unix.
Over one year of experience in 3-tier technology, working on an Internet-based
Funds Administration Package for a financial consulting company in the US using
web technology, Oracle8i and Oracle Application Server.
Awarded for outstanding performance in Sony-ITD Services Forecasting project.
EDUCATION:
B. E (4 Year Degree in Electronics & Telecomm.)
CBSE, DAV Jawahar Mandir, Ranchi
ICSE, Sacred Heart Convent
TECHNICAL SUMMARY:
Technical Expertise: Oracle Discoverer 9i,10g (Desktop and Admin version) ,
PL/SQL, Developer 2000/6i(Forms and Reports), Pro*C, SQL * LOADER, SQL*Plus,
Unix Shell scripts, C, C++, Oracle 8i ,9i,Sybase
ERP:
Packages (Incl Versions): Oracle Applications Release 11.5.9, 11.5.10 ,
11.0.3 , 10.7
Modules: Oracle Manufacturing - BOM, WIP, Inventory(INV), Purchasing (PO)
Oracle Financials General Ledger, Account Receivables, Account Payables.
Order Entry/Shipping , Oracle Demand Planning
SAP ECC 6.0
Modules AP, SD
Technical - ABAP
Packages Sales force Application (CRM)
Modules SFA Sales force Automation
Database: Oracle 7.3/8.x , 9i , 10g , Teradata 7.2
Operating System Unix, Windows NT
H/W platform Sun, HP, Windows 2000/NT
GUI Developer-2000(ORACLE Forms 6i/5.0/4.5 and Reports 6i/3.0/2.5)
Discoverer 9i , 10g
Tools Developer 2000( Forms and Reports) , Informatica 8.1.1 ,Oracle Reports,
PL/SQL, Pro*C, SQL * LOADER, SQL*Plus, Unix Shell scripts, vi , Blue Wolf, Sybase
, Cranberry , BTEQ Scripts
Application Server Oracle Application Server
Languages C/C++, HTML
PROFESSIONAL SUMMARY
PepsiCo Chicago Feb-08 Till date
Technical Consultant
Was part of Data conversion Project within PepsiCos SAP Enterprise Solution
Project. Worked on a data migration solution that begins with documentation and
includes establishing and deploying a baseline architecture.
Responsibilities :
1) Responsible for the design and build of ETL ('Extract/Transform/Load') and
conversion components.
Primary steps involved are :
Legacy system extract Cranberry and SQL* Loader were used to extract data.
Establishing reference data - default, valid, and cross reference values - and
transforming data into a pre-load staging area.
As the data is transformed, exceptions are captured. Analysis of the
exceptions along with continual data quality assessment are used to rapidly cycle
data, improving it with each run until it is ready to load in the target system
(SAP) Extensive use of database procedures/functions to validate data.
Data improvement is assessed via use of data quality tools. Finally auditing
support information is provided before passing the data on to the target system.
2) Responsible for maintaining Cross reference data between legacy applications
and SAP for GL Balances and Project Planned Cost. Developed a interface to map
Oracle legacy GL Code combination to SAP Code combination.
Discoverer reports were developed to view Oracle staging data.
3) Was also part of Technical team required for TPM Sales reporting ODS
within Teradata for the latest release.
As part of this initiative various interfaces were developed to populate master
data for various attributes required for Sales reporting .
Informatica was used to load the inbound tables.
BTEQ scripts were used for performing validation.
Simple reports were developed in Discoverer to aid business users analyse the
data.
4) Responsible for Trouble Shooting and Performance Tuning.
ENVIRONMENT: Oracle PL/SQL, Teradata, SQL Server , UNIX, BTEQ, Cranberry,
Informatica , TOAD, Teradata SQL Assistant , Star Team , Discoverer
Northern Trust Bank Sep-07 Feb-08
Oracle Technical Consultant
Worked as Oracle technical consultant for fundamentals team. Involved in
migration/conversion of code from Sybase to Oracle.
Using Fundamentals tool , user can select from over 8000 market indices and
performance universes to assess the market environment and determine his relative
position .
View daily and periodic returns , pre-set reference dates and benchmark
preferences to expedite the analyses .
Create customized index blends to utilize in a variety of analytical reports .
Responsibilities:
Involved in conversion activity of code from Sybase to Oracle. Involved in
extensive customization of database Packages/Procedures etc.
Used SQL*Loader to move data from Sybase to Oracle tables .This activity also
involved administrative activities like creating tables, synonyms , granting
rights etc.
Developed technical Specifications for all new RICE items.
Was also a part of support team , helping them maintain/develop reports in
discoverer.
ENVIRONMENT: Oracle Discoverer , Oracle PL/SQL, Sybase,SQL*Loader, Shell
Script, Windows NT, UNIX, TOAD, SQL Navigator, SQL*PLUS, PVCS
United States Gypsum Corporation Apr 06 Sep-07
Oracle Discoverer Consultant
Worked as Oracle technical consultant for SCM and Cost teams .Worked on
development of key discoverer reports and an interface for material
summarizations .Provided production support for the Cost team.
Responsibilities:
Developed Discoverer 10g Workbooks with Custom folders in a 24x7 manufacturing
environment utilizing Noetix views and Custom EULs :
Forecast Accuracy --- This report was the key metric for Network
optimization planning. This report would compare actual shipment to forecasted
shipments over various time periods.
Plan attainment report This report was used to measure each plants
compliance to the manufacturing plan .It was used to compare actual production to
planned production at item and category level.
Developed Material Summarizations --- Business wanted to develop reports
related to production and inventory activity within Oracle. For this purpose we
wrote an interface to populate a custom table with all the production and
inventory activity reported by primary item. All of the sub elements and their
costs used to make that primary item were associated with the primary item .Any
variances incurred were also associated with the primary item. Production or was
summarized at lowest level by transaction date.
Created functional and technical designs for RICE objects.
Helped in migrating discoverer reports from 9i to 10g.
Involved in functionality design of the reports like sorting, calculations,
creating lovs conditions, parameters, giving page items etc in Discoverer
desktop edition.
Used to share the reports to the user, scheduling reports, exporting the
reports to excel sheets etc in Discoverer desktop edition.
Use Discoverer 10g administrator for various administrative maintenance
activities.
ENVIRONMENT: Oracle Discoverer , Oracle Applications (11.5.10), Oracle PL/SQL,
D2K (Forms6i, Reports6i), SQL*Loader, Shell Script, Windows NT, UNIX, TOAD, SQL
Navigator, SQL*PLUS, PVCS
Chicago Housing Authority August 05 Apr-06
Customization/Implementation of Sales force
Oracle Techno Functional Consultant
This project involved implementation/Customization of Salesforce CRM
application.
Responsibilities:
Customize Salesforce application which helps in managing clients and processes
more efficiently.
Involved in customization of Modules like Account Management,
Forecasting/Analytics (Dashboards) and Workflow.
Wrote interfaces to map data b/w Mainframes and Sales force. Extensively used
Oracle PL/SQL and UNIX shell script for developing interfaces.
Facilitate to resolve the technical problems and issues
Develop Oracle and Salesforce reports.
Implemented a tool namely Blue Wolf to extract data out of Salesforce. Then
developed Oracle View s/ Reports etc to help users view the data.
ENVIRONMENT: Oracle PL/SQL, D2K (Forms6i, Reports6i), Discoverer, SQL*Loader,
Shell Script, Windows NT, UNIX, TOAD, SQL Navigator, SQL*PLUS, PVCS, Blue Wolf
Darc Corporation Chicago April 2005 Aug 05
Implementation at Parelli Systems
Oracle Techno Functional Consultant
This project involves various customizations for an Oracle Applications
(11.5.10) implementation at Parelli Systems.
Responsibilities:
Involved in Design and development of Customer Interface which is used to
import and validate current and historical customer information from other
systems in Oracle Receivables. Wrote Unix shell Scripts for Importing of data
from the legacy system to the Oracle Database using SQL*Loader. Created
procedures etc for validations and population of data into the Oracle live
tables.
Customized the Packing Slip shipping document which is used to print all the
confirmed sales orders in a Selected Delivery.
Modified the Oracle Standard Format Payment Program to adhere to Client
needs.
Facilitate to resolve the technical problems and issues
Worked with Administrative and Desktop Edition of Oracle Discoverer. Building
workbooks, editing existing workbooks , adding/editing worksheets and scheduling
workbooks for user.
Involved in functionality design of the reports like sorting, calculations,
creating lovs, conditions, parameters, giving page items etc in Discoverer
desktop edition.
Used to share the reports to the user, scheduling reports, exporting the
reports to excel sheets etc in Discoverer desktop edition.
Created discoverer End User Layer (EUL or Repository), Business areas,
Folders, Summary Folders, Custom Folders, Custom Joins In Discoverer
Administrator.
ENVIRONMENT: Oracle PL/SQL, D2K (Forms6i, Reports6i), Discoverer, SQL*Loader,
Shell Script, Windows NT, UNIX, TOAD, SQL Navigator, SQL*PLUS, PVCS
SONY Electronics Inc San Diego Mar 2004 April 2005
Sony-ITD Services Forecasting (San Diego, USA)
Oracle Techno Functional Consultant
The project involves implementation of a Custom Solution to support integration
of Oracle Applications with Storms, GRIMS and SIS legacy systems used for Service
Operations.
The objective of this project is to Satisfy following business needs in terms of
forecast for:
Short term (IRP-Initial Repair parts)
Long term (ARP- Additional Repair parts)
One time purchases (EOL-End of life) from vendors.
Responsibilities:
Participate in the Discovery phase of the solution.
Interact with Sonys key users to seek clarifications on the Functional
Specifications.
Facilitate to resolve the technical problems and issues.
Production support
Co-ordinate offshore development for the project
Design and Development of Interface Programs ( Standard ITEM and BOM Load) ,
Concurrent Programs and Customization of Forms and Reports.
Created Alerts and user Profiles for end users.
Modified the packages and stored procedures for new user requirements.
Created procedures for validations and population of data into the Oracle live
tables.
Wrote Unix shell Scripts for Import of data from the legacy system to the
Oracle Database using Sql*Loader.
Part of the development team involved in designing an online Case submission,
which allowed dealers and users to submit orders for service, or exchange for
defected products. It included integration of Oracle CRM with Oracle BOM,
Accounting etc.
ENVIRONMENT: Oracle PL/SQL, D2K (Forms Reports), Discoverer, SQL*Loader, Shell
Script, Windows NT, UNIX, TOAD, SQL Navigator, SQL*PLUS, PVCS
SONY Electronics Inc Oct 2003 Feb 2004
Sony Music Distribution Integration Project
Oracle Technical Consultant
This Project involves Implementation & RICE (Report, Interface, Conversion, &
Enchantments) Object Development for Oracle Manufacturing Modules - Inventory,
Purchase, Bills of Material, & Work in process
Responsibilities:
Integrating Clients Legacy Systems with Oracle Manufacturing involves
development of objects like:
Order Distribution Form: This Form provides the following features:
Revaluate distribution orders sent from CTHE
Assign an order to one or more warehouses
Break an order into workable segments and create kit build shop orders or
breakdown orders
Set up the necessary sub inventories for WIP.
Reports
Development of reports to print the component and sub inventory details of a
WIP Job.
Interface:
WIP Interface To Break an Order into workable segments and create kit build
shop orders.
ENVIRONMENT: Oracle PL/SQL, D2K (Forms & Reports), Discoverer, SQL*Loader, Shell
Script, Windows NT, UNIX, TOAD, SQL Navigator, SQL*PLUS, PVCS
SONY Electronics Inc San Diego June2003 Oct2003
Sony-ITD Services Forecasting (San Diego, USA)
Oracle Technical Consultant
The project involves implementation of a Custom Solution to support integration
of Oracle Applications with Storms, GRIMS and SIS legacy systems used for Service
Operations.
Responsibilities:
The interface of the legacy systems with Oracle involved development of Objects
like:
Forms:
Model Setup: - This includes one time setup of new Models/Components for which
IRP need to be generated in Oracle
Parts Demand Tracking: - Displays the parts demand details
Model return ratio Form: - Displays the Model return details. Some error
correction forms to modify master data related to Models and respective
components.
Forecasting reports:
ARP Parts/Model Detail Reports: Oracle Reports to generate ARP requirements on
model /parts basis Parts
EOL Calculation report: Oracle Reports to generate EOL requirements on model
/parts basis Parts Consumption.
Interface:
This interface is used to load the Inventory and BOM details from Storms to
Oracle ( Standard ITEM and BOM Load)
Modified the packages and stored procedures for new user requirements.
Created procedures for validations and population of data into the Oracle live
tables.
Wrote Unix shell Scripts for Import of data from the legacy system to the
Oracle Database using Sql*Loader.
ENVIRONMENT: Oracle PL/SQL, D2K (Forms & Reports), SQL*Loader, Shell Script,
Windows NT, UNIX, TOAD, SQL Navigator, SQL*PLUS, PVCS
SONY Electronics Inc San Diego April2003 June 2003
AV - Monthly GL feed
Oracle Technical Consultant
AV - Monthly GL feed - Provides the facility to feed monthly balances into
Oracle General Ledger R10.7 - AV maintains their day-to day transactions in BPCS
(Oracle database). At month-end AVCO needs to extracts all its balances into a
flat file in the required format and send to Oracle General Ledger R10.7. Once
oracle gets the flat file it will validate the data and populate these balances
into GL_INTERFACE and then kick off the Oracle standard Journal Import program.
This Interface program was scheduled monthly.
Responsibilities:
Involved in Development and testing of following objects related to AV - Monthly
feed: --
Concurrent Request set
For Loading the flat file data into Staging table (Using SQL*Loader)
Created procedures for Validations ( As per Business rules) and populate data
into the Oracle live tables. (Load data into GL_INTERFACE )
Then Call Standard JE Import .
Concurrent program to send mail.
In case of any errors, respective user groups were intimated via an e-mail
Custom mapping form
This form was used to enter the mapping between the AVCO account segments with
Oracle General Ledger 10.7 account segments. AVCO had their unique chart of
accounts having 3 segments accounting format which was mapped to Oracle General
Ledger 10 segment account format
Monthly Interface report
This report was used to display the details of all the records successfully
uploaded into Oracle General Ledger.
ENVIRONMENT: Oracle PL/SQL, D2K (Forms & Reports), SQL*Loader, Shell Script,
Windows NT, UNIX, TOAD, SQL Navigator, SQL*PLUS, PVCS
Worked in India for Different clients Jun-1999 to
Mar-2003
namely Wipro, KPIT and Opus Technologies
Contact details :
Email :- [Send email using form at bottom]
Tel :- [Send email to request phone number] 21-6550(C)
|
