Oracle Professional

ROSHY CHACKO ***********@*****.***, ***********@*****.*** 614-***-****(M)

OBJECTIVE

* ***** ** ******** ********** in developing Internet Applications & Client-Server technology based applications (2 and 3 tiers) for financial, telecommunication, sales, manufacturing,retail and marketing domains. Gained expertise in working with technologies and languages like SQL,PL/SQL, Oracle 9i,Oracle 10g, Oracle XML Publisher, Oracle Discoverer, Oracle Forms 6i, Reports6i, Reports 10 G,Crystal Report ,Oracle 10G , 9i Application Server ,Oracle RMS and RDM. Well organized in business analysis, problem solving, decision making, requirement gathering, defining scope, database design, scheduling, and issue/risk control.

TECHNICAL SKILLS

PROJECT EXPERIENCE Abercrombie And Fitch(AnF) OH, Columbus: Jun 2008 - Till Date

Role

• Req Gathering

• Tech Spec

• Development

• Design BL

• User Testing

Working as senior software engineer to implement Oracle RMS,DTC and RDM(WMS) interfacing.

AnF is one of the leading Retail company in US.AnF is getting implemented RMS,that will be replacing the current Host system.RMS will be providing similar functionality to WMS and OBWIMS as the Host does today as merchandising system. The RMS 13 project is implemented in two releases. The system will facilitate the management of Domestic and International Supply Chain processes. All WMS and RMS interfacing transactions regarding Inventory Management (Receipts, Allocations, Inventory Adjustments, Transfers Adjustments) is getting implemented by the RMS and WMS interfaces. The OB WIMS (Supply Chain Visibility) system conversion performed in RMS extension table.

Responsibilities:

- Collecting the requirements for the RMS to WMS and WMS to RMS interfacing implementation

- Design and Technical documentation for RMS , CWD and RDM interfacing implementation

- Customising the oracle RMS forms and new reports for the inventory balance.

- Creation and modification on RMS and WMS messages for the

reconciliation of transaction

- PO Reports creation,Transfer Form and Locatioon Form Creation and Reports.

- Working on the following Oracle RMS RIB Subscription and publishing packages

• Appointment Subscription Package

• PO Receipt Subscription Package

• Sample Pull adjustments

• Transfer Receipt Subscription Package

• Allocation Receipt Subscription Package

• Inventory Adjustment Subscription Package

• Stock order status Subscription Package

- Packages, procedures and function creation for the ANF custom changes for the above subscription package

- Extension table creation for the RMS core tables for the RDM to SIMS and OBWIMS functionality

- Inventory balancing between different systems like RMS,CWD and RDM through Snapshot

- Version control through PVCS

Environment: Windows XP, Oracle 10G,Forms 10g,Reports10g,Toad, ,PL/SQL Developer, Oracle 10 Application Server for Linux,Oracle RMS13,RDM.

PROJECT EXPERIENCE Network Appliance (NetApp), CA, Sunnyvale: Dec 2007 – Jun 2008

Role

• Coding B.O.

• User Testing

• Design BL

Working as software engineer to develop SMART Sales tool.

- NetApp’s current set of tools used to manage its Participant Data, Sales Reporting Hierarchy, Permissions, and Sales Credit Adjustments suffer from limited performance, functionality, and integration, and are therefore not scalable to its anticipated growth.

-

- SMART’s nearly every process related to sales operations, from participant data management to the payment of commissions, is impacted by the tools and processes which support Participant Data Management, Sales Reporting Hierarchy and Permissions, and Sales Credit Adjustments and Validation.

Responsibilities:

- Requirements Consolidation & Development of the participant and compensation plan, worksheet module

- Functional specification creation based on rudimentary user specification.

- Backend functionality of

- Hierarchy Data Management

• Hierarchy Goal and Forecast Data Management

• Comp Plan Data Management

• Participant Data Management

• Goal Sheet Administration

- Creating packages, stored procedures,function,triggers, batch job creation, optimizing and tuning the queries and partitioning the tables

- Validation management for the compensation plan module ,participant module

- Staging and publishing of the compensation,hierarchial,participant module

- Managing the sun Solaris Unix operation system oracle Enterprise manager ,Oracle Application Server(OAS) and database server management

- Version control through PVCS

- Implementation of the DB functionality through the BL designed in Spring application

Environment: Windows XP, Oracle 10G,Toad, ,PL/SQL Developer,tomcat,Sprng Technology.

PROJECT EXPERIENCE Oracle Financials Ltd (SuperSoutions Daybreak), Minnesota: Feb 2007 –Dec 2007

Client

• Old Mutual Fund Bank, SA

Role

• UI Design

• User Testing

• Design Reports,Forms,Backend objects

• System and User Support documentation

Key Deliverables

• Functional and Technical spec for interfaces

• System and User Support Documentation

• Scheduling Go-live Tasks

Worked as Associate consultant to develop Daybreak Lending Suite.

Daybreak™ Lending Suite – OMF Implementation is a consumer lending system that includes origination, customer service and collection modules. For OMF – Daybreak Implementation, the system has been enhanced to support the following product lines

- -Policy Loan, Mortgages and Motor and Computer Finance

The system has been developed with Oracle Forms 6i, PL/SQL and Report writer on Oracle 10g Enterprise Edition Release 2 version 10.1.2.0.2 and deployed and tested in Oracle 10g Application Server Enterprise edition Release 10.1.2.0.2.

Responsibilities:

- Requirements Consolidation & Development of the module

- Developing functional specifications based on rudimentary user specification

- Implementing enhancements in the Application entry, underwriting, funding and customer service screens

- Creating packages, stored procedures,function,triggers, batch job creation, optimizing and tuning the queries and partitioning the tables

- Edits creation for the policy loan, mortgages and MCF through form 6i

- Conversion of all application tables into accounts table through the backed packages after the whole cycles of the modules.

- New application creation through form6i

- Production Support on the modules delivered.

- Getting the objects through FTP and Deploying the objects into server through Unix

- Data modeling for the new policy,mortgage,MCF application based on the Daybreak standard.

- Creation of shell script for the execution of form,menu,reports

- Batch job creation for the statements of customer service application

- Loading of client database information to the working database through the oracle utility sql loader

- Creation of libraries pll,olb

- Managing the sun Solaris Unix operation system oracle Enterprise manager ,Oracle Application Server(OAS) and database server management

- Creation of Pl/Sql Engine wrappers, engine main,engines,engine libraries packages in a well standardized way for the multiple functionality

- Oracle AQ for the Flex cube integration to Daybreak lending suite

- Development of Corporate bulk loan functionality

- Developing reports and letters for the Daybreak through report6i

- Creation of ad hoc reports through the oracle discoverer

- Debugging and Testing

- Design document, Test case, SOD Documentation

- PVCS librarian

- Generation of reports for application entry and underwriting through XML publisher reports for the java ADF DLS application

- Rationalization and customization of the product

Environment: Windows XP, Oracle 10G,SQL Loader, Oracle XML Publisher, Oracle Discoverer, form 6i,Reports 6i, Reports 10G,PL/SQL Developer, Oracle Work flow,Unix,Oracle 10G application server.

PROJECT EXPERIENCE Oracle Financials Ltd (SuperSoutions Daybreak), Minnesota: Nov 2006 – Feb 2007

Client

• Barclays Bank ,SA

Role

• Associate Consultant

• Interface Design, Coding

• User Testing, Regression Testing

• Forms and Reports creations

Key Deliverables

• Specification creation for the product

• System and User Testing

• Delivery of the product on time

Worked as Associate consultant to develop Daybreak Lending Suite.

Daybreak TM is a comprehensive consumer lending system .Daybreak provides supports fir financial and telecommunication products such as loan and lease. Customer service is one module of Daybreak suit. Customer Service form is divided into tabs that perform the following tasks: Search for and load accounts on the Customer Service form ,View comprehensive account and customer details, including status, balances, transaction histories, payoff quotes, and statements ,Track attributes associated with an account ,Record call activities, promises to pay, comments, and references ,Use checklists to perform customer service tasks ,Perform monetary and non-monetary maintenance on an loan, lease, or line of credit, Record information concerning bankruptcies, repossessions, foreclosures, and account deficiencies, View contract information recorded during the funding process, View information regarding account collateral, Perform a credit bureau pull, Add comments to an account during any time of the customer service process.

Responsibilities:

- Implementing enhancements in the underwriting, funding and customer service screens

- Production Support to abf modules created through form 6i

- Creating packages, stored procedures,triggers,batch job creation, optimizing and tuning the codes

- Loading of client database information to the working database through the oracle utility sql loader

- Creation of ad hoc reports through the oracle discoverer and report 6i

- Batch job creation for the newly created letters and reports created in EW,EM,EN,EL package structure

- Creation of libraries pll,olb

- Getting the objects through FTP and Deploying the objects into server through Unix

- Customer service thorough the telecommunication for the loan application status and payment entry.

- Regionalization and customization of the product through the database objects usage in the region.

- Developing reports for the modules and xml publisher reports for java application

- Debugging and Testing

- Design document, Test case, SOD Documentation

- PVCS librarian

Environment: Windows XP,Unix,SQL Loader, Oracle Discoverer, Oracle 10G, form 6i,Reports 6i, Reports 10G,PL/SQL Developer, Oracle XML Publisher, Oracle 10G application Server

PROJECT EXPERIENCE Olam Internationals, Singapore- Global supply chain manager of agricultural raw materials and food ingredients Dec 2004 – Nov 2006

Role

• Customization Design and development

• User Testing

• Design Reports

• Trouble shoot interfaces

Key Deliverables

• Interface Design

• Data Conversion

• Reports Development

• RMIN,DIN,FGRN,DIN User acceptance testing

• Project live scheduling Worked as Software development engineer to develop Olam supply chain management(Trading System)

OLAM trading is a system which enables to Export and Import food products, helps in the creation of Local contracts through price to be fixed(PTBF), Goods note receipt contract(GRN), Fixed Goods note receipt contract(FGRN), Raw Material Issue Note(RMIN), Daily Issue Note (DIN)etc. It also helps in the tracking of processing of agricultural products and food materials, storage and transportation till the Marketing of those manufactured products. This system helps in the supply chain management of multiple products to various customers and markets around the world. The module RMIN raw material issue note is mainly describes the transaction what’s done between the product based on the Processed Goods and Reprocessed goods. DIN module will handle the daily issue notes of the goods and that will be referred in the RMIN module for bulk usage.

Responsibilities:

- Developing System Requirement Specifications based on rudimentary user specification

- Designing the new application Raw material issue note,daily issue notes

- Conversion for JSP to Forms and oracle portals for application image uploading

- Creation of generic functionalities by library files

- Creation of libraries pll,olb

- Creation of generic UI template

- Loading the sql statements into database from the client to the working system through the sql loader

- Creating packages, stored procedures and triggers for the RMIN and DIN application

- New application creation through forms

- Dynamic client request handling and effective changes to the application

- Ad hoc report generation through oracle discoverer and report 6i and 10G

- Deploying reports and form objects in oracle 10G Application Server

- Data loading to the working database from the client through the oracle utility SQL Loader

- Reviewing the module

- Generation of matrix and tabular reports

- VSS librarian

- Debugging and Testing

- Design document, Test case, SOD Documentation

Environment: Windows XP, Oracle J lite ODBC Database, form 6i,Reports 6i,Reports 10G,PL/SQL,TOAD ,SQL Loader, Oracle Discoverer, Designer 2000,Oracle 10 G Application Server

PROJECT EXPERIENCE Reserve Bank of India (RBI) Mumbai, (INDIA) India’s Central Bank Oct 2004 – Dec 2004

Role

• SDE

• User Testing

• Design Reports

• R&D Work

Key Deliverables

• Reports Creations

• User acceptance testing

• Scheduling Go-live Tasks

Worked as Software Development Engineer to develop RBI Electronic Reporting System.

The Reserve Bank of India (RBI) is India's central bank. It makes monetary policy, regulates banks, the external sector, and the fixed income and currency markets. RBI undertakes consolidated supervision of the financial sector comprising commercial banks, financial institutions and non-banking finance companies. The RBI was storing the critical statistical data in various regional / divisional systems. This made the consolidation of data and report generation to be a tough task. Therefore RBI decided to have an integrated system. RBI wanted to automate the major activities of the Balance of Payments Statistics Division (BPSD),Non Residential Deposit NRD-CSR and to develop an integrated data base management system

Responsibilities:

- Developing System Requirement Specifications based on rudimentary user specification

- Generation of matrix and tabular reports

- Research & Development work on implementing reports in 10g and importing java class into form 6i

- Creation of ad hoc queries and matrix queries for the statements.

- Creation of packages for the common functionality through out the whole module

- User interface for all the reports through form 6i and 10G.

- Implementing java class usage into forms by importing java classes into the application through the JDeveloper

- Reviewing the module

- Administration and placing the objects like reports in oracle 10 G application server.

- Creation of ad hoc reports through the oracle discoverer reports

- Debugging and Testing

- Design document, Test case, SOD Documentation

Environment: Windows XP, Oracle 10G,Form 6i,report 6i,Forms10G,Reports 10G,Oracle Discoverer,Pl/SQL,TOAD ,Jsp,Java,Oracle 10G application server,JDeveloper,Oracle 10G Application Server

PROJECT EXPERIENCE HTC Global Service Pvt. Limited Chennai, (INDIA) - Inc. 500 Hall of Fame Company Aug2003 to Oct 2004

Role

• PPMA Issue Tracking Developer

• Customization Design

• Design Oracle objects

• Trouble shoot interfaces

Key Deliverables

• User acceptance testing

• Tool delivery for the other Modules and applications

Worked as Software Engineer to develop Issue Tracking module of Process Project Management Automation project.

PPMA is a web based Process and Project manage Automation product .It helps organization to define, maintain, measure and optimize the process .It automates the project management activities from project inception to closure. In essence PPMA enables the organization to operate and deliver at optimum level. Issue tracking is one of the important modules in the PPMA product. This module helps to track issues professionally and efficiently. This module provides to raise, track, and resolve issues. It provides the facility to add attachments to the issues. Users can set the sensitivity of the issue to filter user profiles to whom will be visible on the system. Users can also set the severity and priority of the raised issue and the target date by when the issue has to be resolved. The user can assign an issue to specific individual or allow authorized groups to view the issue for any one from the authorized group to pick the issue for resolution. SLA (Service level agreement) defines the time by when the issue is expected to be resolved. If the issue is not resolved or addressed within the time allowed, the system will automatically provides an email alert to the person who has to address the issue informing that the issue is being escalated unless its is resolved within a certain time period.

Responsibilities:

- Requirements Consolidation & Development of the module

- Assisted in developing sourcing strategy

- Creation of issue tracking module application through form 6i

- Developing functional specifications based on rudimentary user specification

- Creation of asp pages for the visual source safe application for ppma

- Management Information base compiler through C#.Net

- Generation of excel reports through crystal report

- Creating packages, stored procedures and triggers for the

- Implementing enhancements in the screen

- Relational Data Modeling and Relational Database design

- Developing reports for the issue tracking through report6i

- Data modeling for the issue tracking application through Oracle Designer

- Debugging and Testing

- Design document, Test case, SOD Documentation

Environment: Windows XP, Oracle 9i,ASP,crystal report, C#.Net,form 6i,Reports 6i,PL/SQL,TOAD ,Designer/ 2000,Oracle 9i Application Server

EDUCATION & RELEVANT SKILLS

Experience :

Master of Philosophy in Computer Science,Manonmaniyam Sundaranar University,(India)

Masters of Engineering in Computer Science, Sathyabama University(India)

Bachelor of Engineering in Information Technology, Madras University(India)

Contact this candidate