Professional Summary

Having ** years of experience in IT Industry on Oracle Applications 11i / R12 EBS Projects as a Oracle Apps Techno-functional Consultant,(Financial,SCM,HCM modules).

Worked on various projects like Spectrum,BELKIN INTERNATIONAL Upgradation R12, GATI, NCI MPS Implementation Project, GE Aviation Amber road Project, GE Health Care Project, INA_HKD_WATSON_T&M_DVLP, BBBS_Oracle_Support_FP(Balfour Beatty Group Limited. Expedia, Seagate Management Project, Transaction Process System (Central Govt Infrastructure) The SEW organization is authorised by Central Government Infrastructure, Automation of Finance and Accounts Group, SQL Star, Dealer Management System (DMS), National News Advertising Group.

TECH MAHINDRA EXPERIENCE SUMMARY

Category

Description

No of Projects

Role

Oracle Apps Technical Consultant - upgrade

(BELKIN INTERNATIONAL Upgradation R12 Project)

Oracle Apps Technical Lead - MDM

( GATI Implementation R12 Project )

Oracle Apps Tech Lead - Developer

( NCI MPS Implementation Project )

Oracle Apps Tech Lead - Developer

( GE Aviation Amber road Development Project )

Oracle Apps Tech Lead - Developer

(GE Health Care Development Project )

Oracle Apps Tech Lead - Developer

(INA_HKD_WATSON_T&M_DVLP Development Project )

Oracle Apps Tech Lead - Developer

(BBBS_Oracle_Support_FP-

Balfour Beatty Enhancement- Development Project )

1

1

1

1

1

1

1

Oracle Apps Technical practice for over Ten years which includes assignment in for the clients (Belkin,NCI,GE Health,GE amber road,Watson,Balfour Beatty)

Worked on Reports, Function modules, Interfaces and conversions,plsql performance tuning and complicated packages and sub programs, User exits, SQL Scripts and forms.

Extensive working knowledge Oracle Technical concepts, Data Dictionary, Interfaces, XML / BI Publisher Reports, Oracle SQL Scripts, Forms, and Reports.

Exposure in Oracle Financials and SCM modules like GL,AP,AR,PO,OM,INV.

Education

Management Information System on Computer Applications (MISCA), March 2001, Osmania University, Hyderabad.

Bachelor of Commence (B.Com), March 1998.

Professional Experience

Company

Period

Pyramid

December 2017 – Oct 2018

Tech Mahindra – Hyderabad

January 2015 – March 2017

Zensar Technologies – Hyderabad

August 2014 – December 2014

Wipro Technologies – Bangalore

April 2014 – July 2014

Ivas Solutions – Hyderabad

April 2013 – April 2014

SQL Star International – Hyderabad

April 2011 – October 2011

Ivas Solutions – Hyderabad

August 2010 – March 2011

Genesis Software – Hyderabad

June 2007 – February 2010

COMPETENCIES

Category

Major Skills – Primary

Minor Skills – Secondary

Verticals

OracleApps Project Technical Developer

Domains

Financials

(SCM) Supply Chain Management

Programming Skills

(As Applicable)

Oracle sql and plsql Objects.

Java Programs

Oracle Apps Modules

General Ledger, Account Payables, Account Receivables, Purchase Order,Order Management,

AOL&System Administration,HRMS,Pricing,Costing.

(HRMS) Human Resource Management System

Tools & Techniques

Legacy to Oracle Apps

Notepad++, .dat files, .ctl files, Host Programs

Databases

Oracle 8/8i/9i/10g/11g

Sql Developer, Virtual XP Mode, sql*plus

Software Tools

Developer 6i,10g (Forms & Reports),

sql,pl/sql, Oracle SQL* Loader, toad,sql developer tool

Toad, BIPublisher Report, Winscp, Putty.

ERP

EBS - Oracle Apps Technical

Oracle Apps Financial functional, Oracle Apps dba.Web ADI, Oracle Apex

Database

Oracle core dba

Oracle rac dba

Operating Systems

Linux 5, windows 2000,NT server 4.0

Unix, Linux

Current Projects :

ORACLE APPS Experience:

Project 14 # (Implementation))

Company : Pyramid

Project / Client : Spectrum International R12

Description : Spectrum provides all the products of hospitalities like fixed assets,

bio chemical products, pharmaceutical industrial products export business.

Modules : Inventory,Purchase Order, Order Management,Pricing.

Role : Team Member

Duration : Dec/2017 – OCT 2018.

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibility : worked as a Techno-Functional Consultant on SCM modules

Previous Projects :

Project 1 # (Upgradation))

Company : Tech Mahindra

Project / Client : Belkin International Upgradation R12

Description : Belkin International, California in 1983, It includes award-winning

innovations for easy-to-use networking solutions, accessories for mobile devices, such as iPod®, iPhone, laptops, and netbooks, as well as energy,conservation,products.Belkin also provides business-class solutions that include KVM switches, LCD rack consoles, racks and enclosures, in addition to a broad USB and cable product mix.

Modules : Inventory,Purchase Order, Order Management,Pricing,Costing,

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibilily : worked as a Technical Consultant on SCM modules

Role : Team Member

Duration : Feb/2015 - Aug/2015

Project 2 # (Development)

Company : Tech Mahindra

Project / Client : GATI

Description : Gati is an intermediate Transport agency. Gati Limited is India’s

pioneer in Express Distribution and Supply Chain Solutions,

A market leader in India, Gati has a strong market presence in the Asia.

Modules : Account Receivables,Account Payables,General Ledger,Inventory,

Purchase Order, Order Management,Pricing,Costing, AOL and System Administration module

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibility : worked as a Technical Consultant on Financials,SCM

Role : Team Member

Duration : Aug/2015 - Sep/2015.

Project 3 # (Development)

Company : Tech Mahindra

Project / Client : NCI MPS Implementation Project

Description : NCI PROCUREMENT SERVICE also assists companies interested in outsourcing part of their production process of specific product lines, or the entire production process through sourcing and developing international manufacturers for private label production outsourcing. Positioning the department in relation to other Supply Chain Departments and the necessary operational structure, connecting it to other departments of the company.

Assistance to establishing logistical and financial partners for effective operation within the goals and interests of the companies

Modules : Account Receivabl,Inventory,Purchase Order, Order Management,AOL and System Administration module

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibilily : worked as a Technical Consultant on,Financials,SCM modules

Role : Team Member

Duration : Oct 15 - Dec 15

Project 4 # (Implementation and Development)

Company : Tech Mahindra

Project / Client : GE Aviation Amber road Project (General Electric Company)

Description : GE Aviation is a world-leading provider of jet

engines,components and integrated systems for commercial and military aircraft. GE Aviation has a global service network to support these offerings. GE Aviation, a subsidiary of General Electric, is headquartered in Evendale, Ohio,outside Cincinnati.GE Aviation is among the top aircraft engine suppliers, and offers engines for the majority of commercial aircraft.

Modules : Account Receivables,Account Payables,General Ledger,Inventory,

Purchase Order, Order Management, AOL and System Administration module

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibilily : worked as a Techno-Functional Consultant on Financial,SCM

Role : Team Member

Duration : Dec 15 - Mar 15

Project 5 # (Implementation and Development)

Company : Mahindra Satyam

Project / Client : GE Health Care Project (GEHC BA COE CDDT)

Description : This project is based on the client GE Medical Systems for the GE

Health Care. Selling and Purchasing, Purchase orders, Order Management, Inventory, General Ledger, Account Receivables and Account Payables, these all taken into consideration for the smooth flow of business using EBS - ERP Oracle Apps R12 Software Package.

Modules : Account Receivables,Account Payables,General Ledger,Inventory,

Purchase Order, Order Management, AOL and System Administration module

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibilily : worked as a Techno-Functional Consultant on Financials,SCM

Role : Team lead

Duration : April 16 - June 16

Project 6 # (Support and Maintenance)

Company : Tech Mahindra

Project / Client : INA_HKD_WATSON_T&M_DVLP

Description : The A.S. Watson Group is the largest health and beauty retail

group in Hond Kong, with over 12,000 stores in 25 markets worldwide serving over 28 million customers. the company is majority owned by multinational.Its head office is in the Watson House – Chinese.

Modules : Account Receivables,Account Payables,General Ledger,Inventory,

Purchase Order, Order Management, AOL and System Administration module

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibilily : worked as a Technical Consultant on Financials,SCM modules

Role : Team Member

Duration : August 16 to September 16

Project 7 # (Support and Enhancement)

Company : Tech Mahindra

Project / Client : BBBS_Oracle_Support_FP.

Description : Provides the essential infrastructure assets which society needs to

function,develop and thrive. The teams operates across the full infrastuctrue lifecycle:The Finance,Design and Project manage,Develop and Construct,Operate and Maintain Assets.Operate principally in the UK and the US, with developing balfarbette businesses in Canada, the Middle East and South East Asia. Reports on Business’s Performance in three segments:Infrastructure,Investments,Construction Support Services

Modules : Account Receivables,Account Payables,General Ledger,Inventory,

Purchase Order, Order Management, AOL and System Administration module

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibilily : worked as a Techno-Functional Consultant on Financial,SCM

Role : Team lead

Duration : October 16 to March 17

Project 8 # (Upgrade and Maintenance)

Company : Zensar Technologies

Project / Client : Expedia

Description : Expedia is one of the world's largest travel company.

The Expedia since from 1996, the Microsoft launched online travel booking site Expedia.com, giving consumers a revolutionary new way to research and book travel.Since that time Expedia has evolved world's leading online travel company, with a porfolio that includes approximately a dozen of the world 's most notable travel brands.

Modules : Account Receivables,Account Payables,General Ledger,Inventory,

Human Resource and Payroll, AOL and System Administration module

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Modules : Account Receivables,Account Payables,General Ledger,

Purchase Order, Order Management.

Responsibilily : worked as a Technical Consultant on Financial,SCM modules

Role : Team lead

Duration : August 2014 to December 2014.

Project 9 # (Upgrade and Maintenance)

Company : Wipro Technologies

Project / Client : Seagate Management Project

Description : The Seagate Group has grown into one of the largest retail organizations

in the Middle East. It currently operates more than over 600 stores across the world. In addition to its retail sector, the Group has also diversified into electronic products and has created a comprehensive infrastructure including its own logistics and distribution division, to support its retail operations and other business

Modules : Account Receivables,Account Payables,General Ledger,

Human Resource and Payroll, AOL and System Administration module

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibilily : worked as a Techno-Functional Consultant on Financials,HCM

Role : Team Member

Duration : April 2014 to July 2014

Project 10 # (Maintenance)

Company : Ivas Solutions

Project / Client : Transaction Process System

Description : The SEW organization is authorised by Central Government

Infrastructure, Hyderabad. This Project is focused on Highways, Bridges & Metro Rail with the liberalization of the economic policies, the Country is making rapid strides towards developing the infrastructure facilities everywhere. More thrust is given to bring the existing National Highways,State Highways and Roads in rural area to the latest standards by widening which facilitates the faster movement of traffic more economically.

Modules : Account Receivables,Account Payables,General Ledger,Inventory,

Purchase Order, Order Management, Human Resource and Payroll, AOL and System Administration module

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibilily : worked as a Techno-Functional Consultant on Financials,SCM,HCM

Role : Team member

Duration : April 2013 to April 2014.

Project 11 # (Support and Maintenance)

Company : SQL Star International

Project / Client : Automation of Finance and Accounts Group

Description : The Sql Star International organization has branches at international

(Hyderabad,Delhi,Bangalore,Orissa,Chennai,Pune,Kolkata,Maharastra,Madya Pradesh), It has branches at international level at UK,US,Australia,Singapore.It is a partner of Oracle University, rendering the latest versions services to mnc's with corporate training schemes.

Modules : Account Receivables,Account Payables,General Ledger, AOL and System Administration module

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibilily : worked as a Technical Consultant on Financial modules

Role : Team member

Duration : April 2011 to October 2011

Project 12 # (Support and Maintenance)

Company : Ivas Solutions

Project / Client : Dealer Management System (DMS), GTN Industries Limited

Description : The GTN Group, founded in 1966, is one of the pioneers tracing its

origins to Cotton Trading Yarns and Textiles for over five decades.

Backed by rich experience and in-depth knowledge of various cotton growing areas in the Country and also overseas, the group has established close touch with the cotton yarn markets worldwide.

Skill Set : SQL,PL/SQL,Forms,Reports,Migration,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibilily : worked as a Techno-Functional Consultant on SCM modules

Role : Team member

Duration : August 2010 to March 2011.

Project 13 # (Maintenance)

Company : Genesis Software

Project / Client : National News Advertising Group

Description : The Vaarttha Organization is rendering its news and advertisement

media at National Level and Regional Level.It has 2 editors one is Hindi edition and another is Telugu edition. In Telangana State, all together is has 16 zones, coming to Andhra Pradesh State it has 24 regional offices.The Head Office branch is at Hyderabad.It provides different types of advertisements like Earpanel Advertisements,Classified Advertisements,Classified Display Advertisements.

Modules : Account Receivables,Account Payables,General Ledger,Inventory,

Purchase Order, Order Management, AOL and System Administration module

Skill Set : SQL,PL/SQL,Forms,Reports,RICE Components,Migration,

BI Publisher Reports, SQL*Loader,Profiles,

Valuesets,cursor,exception,join,constraints

sequence,index,lookups,procedures,Functions,Triggers,Packages,

Collections,views,table types,object types, rowtypes,etc….

Responsibilily : worked as a Techno-Functional Consultant on Financial,SCM

Role : Team member

Duration : June 2007 to February 2010

Contributions for various projects:

As a team member I was actively involved in the below phases of project :

Analysis of requirements for the project.

Worked on payroll,human resources modules, defining fast formulas, creation of components, running the payroll . creation of job,position in hrms module, running the payroll module for the monthly payroll for the employees,etc…..

Development of code as per the business requirements.

Unit test and system integration test of the developed code.

Package developed & deployed in production environment.

Provided Oracle SQL scripts modified while migration process.

Worked on modification on db objects on High Level Technical Design.

Understanding the test requirements, identification of business scenarios.

Using the development instance and version controlling.

Using Project portfolio management system for migration and managing instances and code move.

Managing relevant Technical Communication with client as well as involved in design and build phase.

Modifying the code to accommodate the latest requirements. Testing the modified programs for requested functionality.

Worked on Stored Programs like Procedures,Functions and Packages.

Functional requirement query development.

Played key role in case study about GATI Business Rules. It is an Hight Level Project. The client want to avoid the third party and want the accounting to be done through ERP Oracle Apps R12. I worked on BMS extraction and Documention. And also at Interfaces case study at High Level and which is been documented.

EBS/ERP Oracle Apps R12 worked on Oracle Reports, Oracle Apps Discoverer Reports, Builting the complex queries as per business requirements and updating the documentation on the same.

The Project is on the development, the implimentation and the testing at different instances by appling the patches too. Creating Trading Partners at XML Gateway, Workflow business events created for partner creation, product creation and PO creation.Testing at SOA and also at AR at the point of,while the business events are triggered.

Worked as a Oracle Apps Technical Developer. Worked on PL/SQL complex source code queries (PO,Partner,Product). Worked on the Trading Partners Creation at XML Gateway based on the Supplier Creation for the imported POs . Testing on all the types of PO creation, PO cancelation, PO releases, Adding the PO line, cancelation of POs respective line,etc.. with all the senarios based on the Supplier creation Trading Partner and tested at SOA and AR with an EBS - ERP Oracle Apps

The role is on study, design, development of existing forms and Reports.

Oracle RDBMS Project is converted into Oracle Apex.

Design and Development of Apex Forms, Apex Reports, Apex Pages, Apex List of Values, Apex Triggers.

Creation of Database objects like sql and pl/sql

(Public Synonyms,views,Indexes,Packages,Procedures,Functions.)

Worked on Custom Objects.

Played key role in the Project Enhancement, worked on the following objects.

Oracle Reports,XML Publisher Reports,Customization and Development of Oracle Forms,Value Sets, Database PL/SQL Packages and Procedures and Functions.

Forms level,Block level,record level,Item level Triggers, Program units, List of Values,Record Group, Check boxes,list item.

Worked on the Performance Tuning for running the form at less time.

Worked on the Oracle apps Web ADI.

Package developed & deployed in production environment.

Provided production support for the deployed project till it is stabilized.

Played key role in upgradation of Seagate Management development and transaction testing project.

Impact analysis of requirements for the project.

Unit test and system integration test of the developed code.

Provided fixed solution to the issues idenified in testing phase.

Package developed component to be deployed in production environment.

Received client appreciations for the project upgradation.

Provided Oracle Forms & Reports customization.

Provided Oracle SQL Scripts modified while migration process of upgradation.

Worked on the development,implementation,migration,upgradation and transaction test.

Analysis of requirements for the project and impact analysis.

Provided fixed solution to the issues identified in testing phase.

Development of code as per the business requirements

Worked on the RICE Components for the item creation.

Worked on KFF and DFF as per the custom Forms.

Worked on Data Migration.

the key role in development of Oracle RDBMS project by creating the custom objects.

Analysis of requirements for new project and impact analysis.

Development of code, stored programs as per the business requirements

Design of forms,Design of Reports

Creation of database stored procedures,functions,packages,triggers.

Customization of Reports,Çustomization of Menus,Customization of Forms

Data migration and upgration.

Analysis of requirements for new project and impact analysis.

Preparation of High Level & Low Level design documents.

Development of code as per the business requirements

Provided the customization of Oracle XML Publisher Reports.

Worked on sql script programs.

Provided the development of new custom objects as per upgradation.

Development of database packages as per custom requirement.

Played ad key role in implementation of Seagate Management Development,Implementation,Upgradation and Transaction Testing project.

Analysis of requirements for new project and impact analysis.

Development of KFF registration, kff segment columns in a custom form.

Development of DFF registration, dff attribute columns in a custom form.

Worked on all Validation Types,Creation of table registration.

Worked on APIs,Worked on interfaces,Development of stored procedures,functions,packages,triggers.

Certifications

Pursued Course Certificates (sql,pl/sql) – CMC Limited.

Oracle Apps Technical – Genesis Software Systems.

Oracle Apps Functional – Genesis Software Systems.

Oracle Core DBA – Wilshire.

Oracle RAC DBA – Techzone.

Oracle Apps DBA – Techzone.

PERSONAL DETAILS

Name

:

VANISREE VALABHOJU

Education

:

MCA – Master in Computer Applications – IGNOU.

MISCA – Management Information System on Computer Applications – Osmania University.

B.Com – Bachelor of Commerce – Osmania University.

CV Updated upto

:

JAN 2020

Authenticated By

:

VANISREE VALABHOJU

PAN Details

:

AJYPV7524P

Aadhar Details

:

550*********

Passport Details

:

Passport No : P3386714

Issued at : Hyderabad,

Date of Issue : 01-08-2016

Expiry date : 31-07-2026

Contact this candidate