Experience Summary

I have a rich experience of 18 plus years in Software Engineering with extensive experience in implementing and Supporting ERP-Oracle Applications. Also having good technical and functional knowledge (Financial & Procurement Domains) in Oracle Applications ERP, Core Oracle SQL/PLSQL and DELPHI. A good leadership, capable of managing large and complex projects and has good understanding of Quality process.

Experience in implementing ERP- Oracle Applications GL, AP, AR, FA, CM, OM, PO, INV, HRMS, CRM and EPB.

Extensive experience in development and implementation of new modules in ePASS (iProcurement, iSupplier, Contract etc.,) and EBS AMS support for the clients FedEx, McDonalds, State Street, Vanguard Logistics .,

Excellent in Project Management and Leadership skills

Experience in implementing business application software across wide area of industries like Financial services, Human Resource, Insurance, Retail, Rental, Logistics and Securities.

Extensive expertise in solutions, designing, data modeling, coding and testing of variety of software applications using Oracle 8/9i/10g, Unix Shell Scripting, Developer 6i/9i/10g, XML Publisher, WebADI, Discoverer, Workflow, Oracle Applications (10.7, 11i and R12) and Delphi.

Developed Client/Server applications using TCP/IP, Windows Components and Internet applications using DELPHI (Object Pascal Language)

Excellent analytical, logical and programming skills

Capacity for Work - Meeting Deadlines

Diagnostic Ability - Ability to go to the core of the problem

Good understanding of quality process.

Technical Expertise

OPERATING SYSTEMS Windows NT 4.0, XP, Windows 95, 3.1, Linux and Dos

SOFTWARES ERP-Oracle Financials 11i and R12 iProcurement (Specialized in AOL, General Ledger, Accounts Payables and Accounts Receivables, iProcurement, Contract and iSupplier).

DATA BASES Oracle 9i, MS Access and Interbase

LANGUAGES SQL, PL/SQL, UNIX Shell Scripting, C, C++, Java and Object Pascal (DELPHI)

GUI & TOOLS Developer 6i/9i (Forms & Reports), Delphi 1-5, SQL Loader, BI Publisher, Workflow, Discoverer, WEB ADI and OAF

Project Details

SEP 2016 – MAY-2017 – FedEx Inc. - Oracle R12 Applications

Client FedEx Inc. (Revenue Management System)

Location Collierville, Tennessee - 38017, USA.

Role Onsite Technical Lead – AMS (Support and Enhancements).

Description:

FedEx implemented revenue system in Oracle Applications Release 12 and the modules are Accounts Receivables (AR), Advanced Collections (SOA, Dunning, Adjustments, Tasks and Disputes), General Ledger and AOL.

GRCC Adoption II: This project is to merge Domestic and International system into single entity in order to maintain and support application less effort and cost.

Merge the code without changing the functionality of Domestic and International Package

Changed Payment Receipt method to Lockbox method to API method.

GRCC Production Support

Support Issues / Requirements / Country Rollouts for Receivable applications like Invoice Interface, Receipt Payments, Collections and Customer and Sites

Develop and deploy for the business requirements in XML Reports Interface/Conversion changes for the new country rollouts.

Responsibilities

Review and analyze the specifications (SRS) provided by the RAD Team for all the components like Interfaces/Reports/ etc. and converting it into Technical design document

Prepare and review the technical design documents (IDD) for all the components developed and delivered to the customer.

Prepare and review the test design documents (DWPR) for all the components designed by offshore team to the developed and delivered components

Prepare SMTD documents on each tracks and present to the client and SMEs

As a Technical lead and On-Site coordinator, responsible for all the components developed by offshore team that are to be delivered to the customer. This includes development of Interfaces/XML reports/Custom objects and also Production Support defects assigned to team, etc.

Environment : Oracle Applications R12 (12.1.3), Oracle 10g, PL/SQL, Workflow, XML Publisher, Web ADI.

APR 2015 – SEP 2016 – McDonald Corporation - Oracle R12 Applications

Client McDonald Corporation

Location Oak Brook, Illinoise - 60523, USA.

Role Onsite Technical Lead – AMS (Support and Enhancements).

Description:

McDonald Corporation (MCD) is the leading global foodservice retailer with more than 35,000 local restaurants serving approximately 70 million people in more than 100 countries each day with corporate headquarters in Oak Brook, Illinois, U.S. More than 80% of McDonald’s restaurants worldwide are owned and operated by independent local men and women. Of the total McDonald’s restaurants worldwide.

Project is to support and maintenance of Oracle E-Biz suite It involves resolving issues, providing enhancements to existing functionalities in finance and iProcurement modules, monitoring and fixing batch job issues at the customer location. It also involves preparing design documentation, coding new modules, attending client review meetings, end to end testing and deployment. The project is being executed on Oracle Financial E-Biz and its supporting applications identified.

Responsibilities

KAP-Knowledge acquired from respective SME in Transition phase

Prepare SMTD documents on each tracks and present to the client and SMEs

Providing technical support to EBS Applications / Client Projects.

Identify the improvement areas in application when request.

Root cause analysis and implement minor enhancements.

Coordinate with offshore technical team for the applications support EBS, TREC and UC4 Jobs Schedules

Follow and adhere to McD ticketing management tools for support and maintenance

Environment : Oracle Applications R12 (12.1.3), Oracle 10g, PL/SQL, Discoverer, Workflow, XML Publisher, Web ADI and JDeveloper.

NOV 2013 – FEB-2015 – Marsh & McLennan Companies - Oracle R12 Applications

Client Marsh & McLennan Companies

Location Hoboken, New Jersey- 07030, USA.

Role Onsite Technical Lead – Implementation.

Description:

Marsh (www.marsh.com), the world’s leading insurance broker and risk advisor, teams with its clients to define, design, and deliver innovative industry-specific solutions that help them protect their future and thrive. This project will involve re-implementing current Oracle applications instance to Oracle R12 single global instance for North American Operating Companies.

Conversion – Supplier and Bank Conversions using PLSQL

Web ADI Build – Custom Web ADI developed for Supplier and Bank Data for Enrichment Activities.

Workflow – Delegation, Forward rules have been customized for Approval process in Requisitions, POs and iExpense Approval workflows

BI Publisher – Developed Local Check Printing Reports for JPMC and CITI Banks aligned to MICR template.

OAF – Controller extension done in the requisition page to default the project source and project code value from requisition lines to distributions

Responsibilities

Requirement gathering from client’s functional team

Preparing Technical and Design Documents.

Develop the core conversion code build.

Assign and Guide offshore team for the technical development

Help the team in technical challenges

Preparing Migration Documents.

Environment : Oracle Applications R12 (12.1.3), Oracle 10g, PL/SQL, Discoverer, Workflow, XML Publisher, Web ADI and JDeveloper.

JAN 2012 – NOV 2013 – State Street AMS - Oracle R12 Applications eProcurement

Client STATE STREET Corporations

Location Boston, MA - 02111, USA.

Role Onsite and Offshore Technical Lead – AMS Maintenance / Support / Analysis / Developments.

Description:

State Street Corporation (http://www.statestreet.com) is a financial holding company. The Company, through its subsidiaries, including its banking subsidiary, State Street Bank and Trust Company, provides products and services for institutional investors worldwide.

SS-AMS project is a maintenance and support project awarded to Wipro by State Street. This project covers the maintenance and support of 533 applications spread across various technologies in all the Line of Businesses across State Street. As part of SS-AMS, Corporate Systems & Operations (CSO) is one of the LOB that comprises of 123 applications with multiple technologies like Java, Microsoft, Lotus & UNIX and major products like Oracle E-Business suite, PeopleSoft and Data warehouse. Wipro AMS team for CSO LOB will be responsible in acquiring the knowledge of all 123 applications, documenting the maintenance activities, shadow support and primary support during the Transition phase. Also, Wipro team is involved in bug fixes and minor enhancements of all these applications.

Following activities are performed

e-Procurement AMS for Purchasing and Contract modules in Oracle R12 Applications.

1.Attending KAP session from SMEs and understand functionalities and prepare documentation like SMTD and SOPs.

2.Walkthrough the existing codes of Interfaces, Workflows and Reports.

3.Secondary support with eProcurement development team and get on-hands experience.

4.Customized the requisition creation workflow and setup for the Punchouts.

5.Minor enhancements done on PO XML templates, PO Standard views.

Finapps Discoverer AMS Reports in Oracle 11i Applications.

6.Analyzing the Oracle Finance Discoverer Report tickets and providing Time Estimation and categories the tickets as Defects / Minor Enhancements.

7.Fixing defects and Developing Minor Enhancements for Oracle Finance Discoverer Reports.

Responsibilities

Gathering Knowledge from Application Support Maintenance Engineers

Preparing documentations like SMTD, SOPs and Technical Documents.

Analyzing the issues and estimating the time to fix and assign the tickets to the appropriate resources.

Help the team in technical challenges.

Environment : Oracle Applications R12 (12.1.3), Oracle 10g, PL/SQL, Discoverer, Workflow and XML Publisher.

JUL 2011 – JAN 2012 Oracle R12 Applications Implementation - eProcurement

Client STATE STREET Corporations

Role Offshore - Technical Lead – Implementations Solutions / Analysis / Developments.

Description:

State Street Corporation is a world’s leading provider of accurate and reliable investment services such as

Custody, Accounting and Administration,

Consulting, Outsourcing and Implementation,

Transfer Agency and Recordkeeping,

Performance, Risk and Compliance,

Capital, Lending and Liquidity.

There is a requirement to implement global eProcurement solution that meets client's requirements and brings best of breed procurement solutions, process standardization, system enhancements, and service excellence. It shall focus on goal of reducing global spend, streamlining the procure-to-pay processes, and driving policy compliance rigor across the organization. There is also a need of downstream integration with all global Oracle EBS Financial Applications.

Following activities are performed

Techno-Functional Support for Preparing Technical Design documents, and Developed interfaces, Reports, Workflows and PL-SQL Packages for Purchasing and Contract modules in R12 Applications.

1. Mass Update Repository Contract Program – This program is used to maintain the data integrity of the Repository Contract records if a Buyer or Attorney on the contract needs to be updated in bulk for any reason (i.e. employee termination, reassignment, internal reorganization, etc

2. PO Document Layout – Custom Template is created by using standard oracle contract template using BI Publisher. The output is in PDF format with company logo in watermark.

3. Legal Project List Report – The legal department requires a report to support their daily transactional operations. This report should also capture the data necessary to facilitate a detailed analysis to any inquiries made by executive management, and either internal or external auditing authorities. Specifically, the detailed responses provided for a particular agreement will provide the business with the data necessary to analyze a myriad of engagements and risks incurred by the organization and Report output is in Excel format with company logo.

4. Legal Project List Report with Questions – This Report is same as the above Legal Project List Report and additionally it has questions and answers made by the Buyers.

5. Delegated Requisition Report – List all requisitions that were approved while they were delegated. The report should give an option to include parameters such as user name (delegator and/or assignee), date range, cost center and category.

6. PO Approval Workflow – Customized the PO Approval workflow for ePass.

Responsibilities

Requirements Analysis, Solutions and All type of Technical Developments.

Help the team in technical challenges.

Environment : Oracle Applications R12 (12.1.3), Oracle 10g, PL/SQL, XML Publisher.

APR 2008 – MAY 2011 Oracle 11i Applications Production Support and Enhancements

Client Vanguard Logistics (NACA Logistics)

Role Offshoe - Solution Architect – AMS. Solutions/Analysis/Supports/Developments.

Description:

NACA Logistics Company is an Ocean World Shipping services in USA, UK, Australia, New Zealand, China, Hong Kong, Dubai and Singapore etc. NACA Logistics has a Technical Resource Center for its IT division in Chennai INDIA, NACA has implemented Oracle 11i Financial Application for its Business. And NACA supports multi Org, Multi Currency and Multi Language.

Following activities are performed

Techno-Functional Support for day-to-day issues Monitor and fixing interfaces issue and development for new enhancements.

Daily Data will be interfaced from different Location and Different Source Systems.

1. Customers - New Customer and Sites will be created through Customer Interface,

2. Suppliers - New Supplier and Sites will be created,

3. Customer Invoices – Invoices will be created through Standard Interface

6. Supplier Invoices -Invoices will be created through Standard Interface

7. Receipts - Receipt Batches will be created through Auto Lockbox

8. Journals - Journals will be created through ADI

Enhancements and Development for the users requirements and adopting new features to the Oracle Applications financial modules

1.Customer Statement Report developed and features added to send via E-Mail and Fax with logo and send through RightFax server.

2.AR Aging 7 Bucket by Invoice Date Report is customized the aging bucket by Invoice date and not by due date and included all required fields from Business application (Directions) and can be loaded in excel. The Report width is 800 characters.

3.AP Laser-Check Print format report is customized for each location according to their bank pre-printed cheque sheets.

4.Dunning Letter, AP Laser-Check and AP Remittance Advice report are customized in XML Output for the required layout developed in BI Publisher (XML Publisher Report).

5.Workflow Notifications developed to send EMail to the Finance Manager when user Open/Close Periods in AR, AP and GL.

Responsibilities

Requirements Analysis, Solutions and All type of Technical Developments, Monitor and fixing daily Interfaces issues.

Response for the user tickets (like problem solving both functionally and technically)

Environment : Oracle Applications 11i (11.5.10.2), Oracle 9i, PL/SQL, Developer 9i

Mar 2007 – Apr 2008 Oracle 11i Applications OM, AR, GL and CRM and Implementations

Client NEXUS Insurance Brokers L.L.C

Role Onsite and Offshore - Team Lead in Data migration – Onsite and Offshore

Description:

NEXUS Insurance Company is an established force in professional financial services in Dubai. Nexus is a new Insurance Broking Operation formed a management of the Direct Sales Force (DSF) arm of an Insurance Company (Zurich). Nexus sell and service the Product of Zurich Insurance Products to the Customers trough their consultants. And Nexus gets commission from Insurance Providers and Split the commissions to Nexus and their Consultants. Nexus maintains the information of each Policies and Clients and their corresponding sales consultants. Nexus has sales hierarchy as Branch Managers, District Managers and Sales Consultants. And each of them has their own Commission Split hierarchies. So Birlasoft implements Oracle Applications Financial, HRMS and CRM modules. And Nexus already used SAGE as Financial Applications and CPS system, INCENTIVE system for Commissions, Incentives respectively. So Birlasoft migrated old legacy system data to Oracle Applications.

Following activities are performed

Data Migrations

All Master data are migrated from legacy system to Oracle Applications to the respective modules. Like

1. Products - Inventory Item Master and Categories,

2. Providers - Customer Master,

3. Suppliers - Supplier Master,

4. Banks - AP Bank Master,

5. Admin staffs and Sales Representatives - Employees & Assignments

6. Clients and Policies - CRM Custom module tables

7. SAGE Accounts - GL Accounts with Hierarchy

All Transactions data migrated into Oracle Applications to the respective modules from different Legacy systems.

1. SAGE Financial Transactions - GL Journals as Balances

2. SAGE Assets Detail - Fixed Assets Mass Additions

3. CPS Reporting Hierarchy - CRM Custom Module tables

4. AMPS Commission Hierarchy - CRM Custom Module tables

5. TARGET Criteria Setup - CRM Custom Module tables

6. CPS Commission Historical Data - CRM Custom Module tables

Technical Design, Development of Datamigraion Program, Reports and Forms.

Environment : Oracle Applications 11i (11.5.10.2), Oracle 9i, PL/SQL, Developer 6i/9i/10g

Sep 2006 – Feb 2007 Oracle 11i Application EPB Implementations

Client ROLL International.

Role Offshore - System Analyst

Description:

The scope of this implementation includes implementation, setup, Metadata Creation, Identify and Creation of 5 Important Business Processes. Use of Standard tools (Cross Tabs, Graphs, worksheet templates), Training to Business Process Owners and Key users to be able to create new Processes and Reports using the standard tools. At the completion of this implementation project, 5 Important Business Processes are defined and set up of reporting tools to enable creation of reports by the user. It also includes creation of detailed documentation on the steps included in the Implementation and setup of EPB.

Following activities are performed

Analysis and identification of GL Segments and EPF Dimensions

Created Accounts Value, Hierarchy and Parent Child Relations

Enterprise Performance Foundation (EPF) Set up and Dimension mapping with respect to the existing General Ledger Set up

Oct 2005 – Aug 2006 Oracle 11i Application Implementations

Client Nigeria Engineering Works Ltd, NIGERIA.

Role Onsite and Offshore - System Analyst

Description:

Nigeria Engineering Works Ltd is a leading manufacturing company in Nigeria; their products are Appliances (Air Conditions, Refrigerators, Deep Freezers, Fluorescent Fittings, Cooking Ranges and Stoves), Electricals (Transformer, Feeder Pillars, Generators, Multi-Purpose Engines and Car Components) and Sheet Metals (Cupboards, Cabinets, Lockers, Office Desks, Chairs and Shelving). Client has Tally system and we have implemented Oracle Applications 11i For One operating Unit and fourteen Inventory Organizations. OM, INV and FINANCE modules are implemented in first phase.

Following activities are performed

Data Migrations

All Master data are migrated from legacy system to Apps, like Items, Customers, Suppliers, Banks and Employees & Assignments.

All Transactions data from 98 to 06 were migrated, like Item Transactions (Current On-hand Quantity for each sub inventories), AP Open Invoices, AR Open Invoices, Fixed Assets and GL Balances.

Reports Customizations

There are 54 Reports were customized for HRMS, OM, PO, INV, AP, AR, FA and GL Modules. All reports are bitmapped reports with Company Logo and background watermark.

Responsibilities

Technical Design, Development of Interfaces and Reports, Testing and Delivery.

Environment : Oracle Applications 11i (11.5.10), Oracle 9i, PL/SQL, Developer 6i

FEB 2005 – SEP 2005

BAHWAN CYBERTEK – www.bahwancybertek.com

Feb 2005 – Aug 2005 Oracle 11i Application Implementations

Client Mazrui Holding U.A.E.

Role Onsite - Senior Technical Consultant

Description :

Mazrui Holding is a distributor in U.A.E for HILTI Corporation. It is a complete Oracle ERP implementation for Mazrui holding company. I have worked in CRM and Other modules like OM, AR, BOM, GL, Sales and Services. I developed Eight Custom Forms, One Custom Library, One Report, Two Interface Programs One Form Personalization Customization.

The purpose is given below.

LANDED COST FORM

This form is used to apply the over head cost for the purchased order Items while receiving the items to the Inventory, The feature is Multiple Landed Costs (like Landed Cost, Freights etc) can be applied for each or range of purchased orders. And this costs will be applied as average cost for on hand quantities and newly arrived goods and calculates the over head cost.

Enterable Fields : GRN Number From, GRN Number To (Receipt Number). Type of Landed Costs and Amounts.

Calculated Fields :. Total Value, Cost and Over head Cost

SALESMAN TARGET MAINTENACE FORM

This form is used to enter Sales Targets for a Sales Man in a Sales group for the Period of months. This form has the information history of Sales Invoices for the Sales man. This form contains the following information for each period of month.

Enterable Fields : Target Sales, Target Growth Proposal, Target Discount and Target Gross Margin

Calculated Fields from AR, BOM, GL and INV : Actual Sales, Target Sales Achieved, Growth Proposal Achieved, Actual Discount, Actual Gross Margin and Last Modified Date & Last Modified By.

SALESMAN BU TARGET MAINTENANCE FORM

This form is used to enter Targets for each BU in Item Categories for each Sales Man for each month. BU is one of the column Structure in Item Categories. This form contains the following information

Enterable Fields : BU Target Quantity, BU Target Value.

Calculated Fields from AR : BU Actual Quantity, BU Actual Value.

SALESMAN FAMILY TARGET MAINTENANCE FORM

This form is used to enter Targets for each Family in Item Categories for each Sales Man for each month. Family is one of the column Structure in Item Categories. This form contains the following information

Enterable Fields : Family Target Quantity, Family Target Value.

Calculated Fields from AR : Family Actual Quantity, Family Actual Value.

SALESMAN ITEM TARGET MAINTENANCE FORM

This form is used to enter Targets for each Item for each Sales Man for each month. Item is one of the column in Sales Order. This form contains the following information

Enterable Fields : Item Target Quantity, Item Target Value.

Calculated Fields from AR : Item Actual Quantity, Item Actual Value.

DEPOT REPAIR CUSTOM LIBRARY :

In Depot Repair form, there are Chargeable Repair and Warranty Repair. Customer needs Alerts when the total amount for Chargeable Repair and automatically updates the No Charge flag in the form. The conditions like follows

If Total Amount <= FOC Then Message = “This is a FOC Repair”

If Total Amount <= DIRECT Then Message = “This is a Direct Repair”

If Total Amount > DIRECT Then Message = “This Beyond Economic”

This has been done through Custom Library file

QUOTATION FOR REPAIR REPORT :

This report is to print the Quotation for Repair Charges for the items to the specific customer, and it contain notes for Special Remarks and HILTI Service Guarantee information. This report will be printed in Bitmap format in with HILTI logo.

DATA MIGRATION FOR INSTALL BASE FROM GBS LEGACY SYSTEM :

GBS is General Business System, which is used by Emirates Air lines and Mazrui Holding. Data extracted from Legacy system for Install Base Migration, Information like Customer name, Locations, Part number, Serial Number and Shipping Date.

DATA MIGRATION FOR SERVICE CONTRACT FROM GBS LEGACY SYSTEM :

After Install Base Migration, Using the OKS_IBINT_PUB API Service Warranties are Migrated using Install Base Records.

FORM PERSONALIZATION CUSTOMIZATION FOR DEPOT REPAIR FORM:

Using Personalization form features, I validated and defaulted values for few fields. Because user needs to use a hard ward scanner for creating repair order.

Responsibilities

Database Design, Forms Design, Technical Design, Development, Testing and Delivery.

Environment : Oracle Applications 11i, Oracle 8i, PL/SQL, Developer 6i

Oct 2004 - Feb 2005 AR Invoices (Revenue Invoices and Credit Memo Reports)

Client Rose Mount U.S.

Role Offshore - Senior Technical Consultant

Description :

The purpose of the Revenue Invoice is to print the Oracle Accounts Receivables (AR) invoice for delivery to the customer for payment. It contains the parameters to customize the report for user desire, like Transaction Number, Open Invoices Only and New Invoices Only. The reports updates the Printing Flag fields to keep track of Original or Copy. And the report contains all information about Remit to address, Ship From, Bill To and each line level information. Finally the report shows the Summary of Sub Total, Freight and Handling Charges, Packaging and Crating Charges and Tax.

Responsibilities

Technical Design, Development, Testing and Delivery.

Environment : Oracle Financials 11i, Oracle 8i, PL/SQL, Developer 6i

Aug 2004 - Sep 2004 PIR – Projected Inventory Report

Client Rose Mount U.S.

Role Offshore - Senior Technical Consultant

Description :

The PIR is a report includes material requirements planning data for a DRP, MPS, or MRP. This is the central planning report that gives all the information to understand the material plan, includes the detail for Sales Order, Forecast, Dependent Demand, Gross Requirement, Schedule Receipts, Planned Order, Current Schedule Receipts and Projected Inventory for a Item, or range of Items or a category in Horizontal Listing, Vertical Listing with Summary and Detail.

Responsibilities

Technical Design, Development, Testing and Delivery.

Environment : Oracle Applications 11i, Oracle 8i, PL/SQL, Developer 6i

Jul 2004 - Aug 2004 CSC-AMS Annual Maintenance Support

Client CSC-Whitbread U.K.

Role Offshore - Senior Technical Consultant

Description :

This is Annual Maintenance Support for CSC, which we already implemented in all modules for CSC. Modules are Finance, HRMS and Purchase. And PO Approval workflow was modified.

Responsibilities

Support from Offshore, Development, Testing and Delivery.

Environment : Oracle Applications 11i, Oracle 8i, PL/SQL, Developer 6i and Workflow

Jun 2004 - Jul 2004 Planner Launcher (Web Reports)

Client iCelerate Technologies / Rose Mount U.S.

Role Offshore - Senior Technical Consultant

Description :

This is an Implementation and up-gradation Project from 10.7 to 11i to Publish the reports in Web based. So that all the user can run the reports form the browser and mail to the customer.

This up-gradation Projects related to OM and PO Modules on Web Reports and PL/SQL Procedure and custom tables creations.

Responsibilities

Technical Design, Development, Web Deploy, Testing and Delivery.

Environment : Oracle 8i, PL/SQL, Developer 6i and Web Deployment.

May 2004 - Jun 2004 Rose Mount CCI

Client Rose Mount U.S.

Role Offshore - Senior Technical Consultant

Description :

This is an up-gradation Project from 10.7 to 11i

This up-gradation Projects related to OM and PO Modules on Forms / Reports and PL/SQL Procedure, Packages, triggers and custom tables creations.

Responsibilities

Up-gradation, Testing and Delivery.

Environment : Oracle Applications 11i, Oracle 8i, PL/SQL, Developer 6i

Dec 2003 - Apr 2004 Data Migrator

Client CSC-Whitbread U.K

Role Offshore - Senior Technical Consultant.

Description :

This is a tool for automating to create Interfaces code for both Inbound and Outbound files. It is used to create Interface files (inbound / outbound) for Data conversion from legacy system to new system. For this, Three Forms are provided to setup or Pre-requests.

One Form is to define File structures like whether it is of type delimiter or fixed length type, and it is co-ordinates. Second Form is for Data Validation, It is to check the data file and whether it has valid data or not, if it doesn't have then default value will be generated. Third Form is for Data Mapping, It is used to Map the legacy data with standard Interface table columns for corresponding module Interfaces.

Finally Using these data information in table, the pl/sql program will generate the Interface inbound / outbound files.

Responsibilities

Database Design, Form Design, Technical Design, Development, Testing, Delivery and Demonstration to the Client

Environment : Oracle Applications 11i, Oracle 8i, PL/SQL, Developer 6i

Mar 2003 - Dec 2003 Oracle 11i Applications Implementation

Client CSC-Whitbread U.K.

Role Offshore - Senior Technical Consultant

Description :

The customization of Oracle implementation included the Data conversion (17 Num) from legacy systems, Report customization (90 Num) for Oracle AP, AR, FA, PO, CE, INV and HRMS modules. Other than this interfacing (60 No) with other systems as outbound Interface.

Responsibilities

Technical Design, Development of Reports and Forms, Testing, Delivery and Quality Coordinator for the project.

Environment : Oracle Applications 11i, Oracle 8i, PL/SQL, Developer 6i

Apr 2002 - Mar 2003 Oracle 11i Applications Reports development

Client Select Comfort Corporation – U.S.

Role Offshore - Senior Technical Consultant

Description :

The Customer is a leading manufacturer/retailer of mattress, mattress pads, pillows, bed frames

Contact this candidate