Sowmya Subramanian

Email: ablp0u@r.postjobfree.com

SUMMARY

. Above 7+ years of experience in IT Industry with expertise in

requirements gathering, development, testing, data migration and

implementation using Oracle and Java.

. Expertise in design, development and customization of Oracle

Process Manufacturing (OPM) and Discrete Manufacturing with strong

knowledge on Oracle Advanced Supply Chain Planning, Inventory,

Oracle Purchasing and Order Management.

. Skilled in Forms and Reports Customizations, Data Conversions,

Version up-gradation, Data Migration, Data Modeling and Interface

Development.

. Expert knowledge in Oracle Inventory, Discrete and Process

Manufacturing and Oracle Advanced Supply Chain Planning (ASCP)

including understanding of table structures and integration with

OPM Planning.

. Highly skilled in Oracle Database Programming with Queries,

Triggers, Stored procedures and PLSQL packages.

. Excellent programming/shell scripting skills in UNIX, C, and C++

along with strong understanding of object oriented methodologies

and software life cycle.

. Strong knowledge of Application Object Library (AOL) and knowledge

of System Administration.

Proficient in Database design and SQL Performance Tuning.

. Good knowledge in Oracle Complex, Maintenance, Repair and Overhaul

(cMRO) including understanding of table structures and integration

with Oracle Projects and enterprise Asset Management (eAM).

. Conducted various training sessions to the Oracle Support team on

technical details of OPM and CMRO.

. Experience in Application System Administration activities like

creating concurrent programs, application user setup, defining

responsibilities, values sets, flex fields, registering menus,

forms, reports, providing support to apps users for any technical

issues.

. Extended experience in projects requiring excellent customer

relationship skills.

. Experience in working with System Integrators/Implementation

consultants in the implementation of Oracle Applications.

. Experience working with large data sets and/or high transactional

volumes

. Excellent communication skills, interpersonal skills, leadership

qualities, systematic approach and ability to work effectively in

fast paced environments.

. Ability to work independently in any product/ service business

because of ability to rapidly grasp and assimilate knowledge

associated with that business.

CERTIFICATION

. Completed Basics of Supply Chain Management (BSCM) in APICS CPIM

Functional Certification

. Completed professional Diploma in Network-centric Computing with

excellent rating.

TECHNICAL SKILLS

Languages SQL, PL/SQL, JAVA, C, C++

Web JSP, XML, HTML, DHTML

Technologies

Databases Oracle 9i / 10g

Operating Unix/Linux, Windows 2000/NT/XP and MS-DOS

Systems

Tools/Utilitie Forms 6i/10g and Oracle Reports 6i/10g, Oracle Discoverer 10g,

s XML Publisher, SQL Navigator, Toad, SQL*Plus, SQL*Loader,

JDeveloper, Visual Basic, Erwin, MS - Office

Oracle Oracle 11i Applications - Oracle Process Manufacturing (GMA,

Applications GMI, GMD, GME, GMF, GMP), Oracle Inventory, BOM, WIP, eAM,

Oracle Purchasing, Order Management, Configure to Order (CTO),

Advanced Supply Chain Planning (ASCP), Mobile Supply Chain,

Project Accounting and Oracle Regulatory

EDUCATION

Master of Computer Applications, University of Madras, INDIA.

PROFESSIONAL EXPERIENCE

Cambridge Technology Enterprises

Feb 2008 - Till Date

Title : Senior Application Consultant

Project : PROSPER 12.0 Implementation

Client : Penn Color Inc, Harleysville, PA

Penn Color is the most diverse manufacturer of pigment dispersions and

color concentrates in North America. For over 40 years, they have been

providing color and additive master batches to just about every industry

that uses color. Customer is in the process of implementing R12 modules

like Oracle Inventory, Oracle Process Manufacturing (OPM - All modules),

Warehouse Management System(WMS), Purchasing, Order Management, Regulatory,

iProcurement and Mobile Supply chain.

Responsibilities

. Developed new forms in Oracle Inventory module that captures the

essential details of the Items to cater the customers

requirement

. Involved in functional design discussions in order to understand

the customer requirements.

. Developed new forms in New Product Development module to capture

the recipe details in a matrix format to suit the customer

requirements

. Extensively involved in data conversions from legacy system to

Oracle system - Develop PL/SQL packages/scripts to load

items/formulas/recipes onto interface tables.

. Developed interface programs to load the Item Categories, items,

manufacturers, and regulatory information into Interface tables

using PL/SQL and then Imported all the above mentioned using

standard Import program

. Developed new interfaces in Order Management, Oracle Regulatory

as per customer's requirements using OA framework.

. Worked extensively on APS Data collections from source to the

demand servers in-order to analyze the data.

. Register custom Forms and Reports in Oracle Applications,

creating Request Groups and assigning to appropriate

responsibilities using System Administrator in Oracle

Applications.

. Made few changes in Mobile Supply chain application (MSCA) - to

suit customer requirements.

. Tune custom code for Performance and Easy Maintainability.

. Designed workflows for label generation that need to be sent

from the OPM Regulatory to the third party systems.

. Developed few reports in modules like - Oracle Inventory, Oracle

Purchasing and in ASCP (to analyze demand and supply of items).

. Developed few XML reports to display the batch related

information.

Environment: Red Hat Enterprise Linux, Windows XP, Oracle 10g,

Oracle Forms 10g and

Reports 10g, Discoverer 10g (Desktop and

Administrator), XML Publisher.

Oracle Corporation

Title : Senior Applications Engineer

Product : Complex Maintenance, Repair and Overhaul (cMRO), Bangalore,

India

Duration : Sep 2006 - Dec 2007

Oracle cMRO delivers the total functionality such as Maintenance, Repair &

Overhaul; organizations demand to successfully manage complex assets - like

aircraft. The product is integrated with Oracle APS, Oracle EAM and Oracle

Projects extensively. It basically consists of few modules like :-

. Engineering - where the parts used in maintenance of the

aircraft are defined,

. Visit Work Package - in which maintenance jobs are defined,

. Execution - the defined jobs are executed, and

. Long term Planning - where maintenance is planned and scheduled

Visit work package is compiled for every maintenance visit. Each package

contains a detailed work scope based on the maintenance requirements and

the associated routes, resource requirements in terms of man-hour by skill,

tools and material. The initial visit work package is handed to

Production/Production Control for execution.

Responsibilities:

. Having sound knowledge of Engineering, Visit Work Package and

Long term planning modules.

. Worked on number of customer enhancements with using JTF

architecture where the front end changes were done using JSP's.

. Wrote number of new methods in the factory and bean and have

successfully generated number of Rosetta files.

. Worked closely with Product Management team in designing and

building customer enhancements.

. Was actively involved in providing solutions for various

customer issues/queries by constantly interacting with the

support executives during implementations/customizations.

. Played critical role in mentoring the new comers with the coding

standards, providing technical assistance and functional

trainings.

. Was responsible for maintaining the eTRM (Technical Reference

Manual) for the database changes for VWP and LTP modules

. Was involved in creating LDT files for messages, regions,

attributes to regions and ODF for database changes.

. Worked on the Oracle Apps releases 11.5.10 and R12.

. Actively involved in developing workflows in the engineering

module to generate appropriate messages to other modules.

Customers:

I have closely worked with some of the customers in their E-Business

Suite implementation as well as providing TAR resolutions like - OGMA,

Turkish Navy, Mexicana, and Korean Airlines.

OGMA (11.5.10 Implementation)

. Handled major enhancements single handedly to be delivered

to the customer.

. Involved in writing Technical Design Document for all the

enhancements.

. Performed number of UI changes, generation of LDT for

region additions and attribute additions.

. Created ODF's for the modifications of tables, views and

generation of rosetta files

. Worked on performance intensive queries for the issues

reported by customers (in various time zones) having heavy

setup in airlines

. Provided continuous support for TAR Resolutions for the

code and setup issues raised/faced by the customer

. Have prepared documents that were given to the customer

which provided steps for execution of the new features.

. Appreciation from the customer for providing a very user

friendly UI and for very quickly implementing one of the

major feature.

Environment: Red Hat Enterprise Linux, SQL, PL/SQL, JDev, SQL

Navigator

Product : Oracle Process Manufacturing (OPM), Hyderabad, India

Duration : Oct 2003 - Aug 2006

Oracle Process Manufacturing (OPM - Oracle 11i/12.0) targets some of the

process industries such as oil, pharmaceuticals and dairy and is highly

adaptable to the ever-changing business needs. OPM is highly integrated

with ASCP which looks at the effective items and their inventory levels,

checks against the existing supplies and accordingly suggests for

production/transfer/purchase based on the demand and schedules the

resources based on their availability and unavailability.

Responsibilities:

. Implementation of OPM Modules and suggesting customizations

wherever required

. Development of new features in OPM modules of releases 11.5.10

and R12 using SQL, PLSQL, Forms 6i, Reports 6i and Pro-C

. Involved in developing new and modifying existing forms

. High degree of interaction with the product management for all

the enhancements, which aided me in better understanding of the

customer requirements.

. Providing workaround solutions for various customers issues both

functionally and technically

. Performance tuning of various time intensive batch programming

and SQL queries

. Working with Customer support representatives from various time

zones in providing resolution of issues/queries

. Creating LDT files for the new Profiles, Messages, Concurrent

Programs, Lookups, Request groups and ODF for Database changes.

. Used FNDLOAD commands to unit test them

. Maintaining the eTRM (Technical Reference Manual) for the

database changes for OPM Modules

. Worked on the Oracle Apps releases 11.5.7 to 11.5.10 and R12

Oracle Release 12.0 (New Development):

I was actively involved in the design & development of R12

requirements for OPM Planning module from functional designs

through database level designs.

. Handled the development of new requirements in OPM Planning like

complex routes, sequence dependency and calendar convergence

projects

. Worked closely with the BOM team to come-up with a common

calendar design for Discrete and Process Manufacturing.

. Worked extensively with the Oracle Inventory team for the

Inventory convergence projects and was involved in developing

technical design documents for MRP planning modules

. Involved in preparing high level design documents and detail

level design documents

. Developed new interfaces in Process Manufacturing Engineering

module and Process Manufacturing Migration module

. Worked extensively on APS Data collections from source to the

demand servers, like :

o analyzing the data in APS collections work bench,

o running ASCP plans in generating plans to meet the demand

o run ASCP-ATP enabled plans, and

o finally feeding back this data to OPM for real

implementation

. Wrote a new PL/SQL package for sequence dependency collection

project, extensive usage of explicit cursors and REF cursors,

fine tune few queries in item substitution project in-order to

improve their performance.

. Wrote scripts to migrate data from 11.5.10 to 12.0 tables

. Have created LDT files for profiles, Messages, concurrent

programs and tested using backend scripts, generated ODF's for

the table and view changes

. Was involved in designing and creating workflows in Inventory,

Purchasing, GMD modules.

. Involved in preparing a number of reports using Report 6i and

XML like - Min/Max planning report, Material status report,

reports for ASCP depicting the supply, demand and planned data.

. Have worked on Mobile Supply chain applications (MSCA) - helps

to perform many warehouse and shop floor transactions through

hand held wireless devices

Environment: Red Hat Enterprise Linux, SQL, PL/SQL, Oracle Forms

and XML Publisher

Customers:

I have closely worked with some of the customers in their E-

Business Suite implementation as well as providing TAR resolutions -

ALCOA, Pepsi, Sanofi and Amul Dairy.

Sanofi (11.5.9 Implementation)

. Involved in analyzing the requirements for Item

substitution enhancement and providing suggestions in

mapping their requirements to product features.

. Developed detailed design documents based on the functional

requirements

. Had high level of interactions with Discrete manufacturing

in understanding their data model and functionality

. Had detailed discussions with the ASCP team to understand

the data level mappings and how the item substitution data

should be viewed on ASCP workbench

. Extensive use of analytical functions in the queries to

achieve low memory usage and faster results

. Fine tuned few existing queries to improve the performance

. Wrote the unit test scripts from APS collections through

APS feedback and executed the test cases. The scripts were

written to produce the results in the form of report so

that it is easier to validate the data.

. Added new fields in the existing table, created new views

and generated the ODFs

. Got accolades from customer for their successful Go-Live.

. Appreciation from the higher management for being of one of

the few enhancements with no issues reported by the

customer.

Environment: IBM AIX, SQL, PL/SQL, SQL Navigator

Teva Pharmaceuticals (11.5.10 Implementation)

I was involved in 11.5.10 implementation of new requirements in

OPM planning feedback.

. Involved in writing Technical Design Document for the new

enhancement in feedback.

. Generated LDT's for

o New profiles

o Addition of few parameters to concurrent programs to

support the new requirement of creating a FPO based

on the APS Feedback.

o Supporting the modified api's in-order to consider

the new parameters in the concurrent programs.

. Involved in performing end to end reconciliation of OPM,

MSC and ASCP to test the effectiveness of the new changes

. Documented the unit test scripts and fixed multiple issues

that arose at the time of unit/system testing.

. Helped customers in executing the new features and

resolving their issues/queries.

. Handled report creation at the customer side using Oracle

Reports 10g

Environment: IBM AIX, SQL, PL/SQL, Oracle Forms 6i, SQL

Navigator

Ramco Systems, India

Title : Analyst Programmer

Product : Ramco E-Apps 4.0

Duration : Sep 2002 - Sep 2003

Roles and Responsibilities:

. Have worked on inventory modules in recording the various

transactions that are made like the subcontract issue/returns,

maintenance issue/return and inventory issue/return.

. Was primarily involved in coding stored procedures in Microsoft SQL

Server 2000.

. Actively involved in developing a test framework

. Involved to the great extent in complete unit and system

integration testing of the modules

. Wrote scripts that aided me in unit testing

. Won appreciation from the manager for showing quickly resolving the

issues reported.

Environment: ASP. MTS and SQL server 2000 on Windows 2000

Contact this candidate