Profile:

I was employed as a& Technical Analyst& in& Enterprise Solutions (Oracle Apps) group of
Infosys Technologies Limited& (CMM Level5) with over& 4 years& of experience in IT industry from&
Sep 2006 to Oct 2010.

I have worked on& Oracle Applications 11i Oracle Tools (Reports, PL/SQLetc).& Ihave been involved in translation of Business needs into Technical Specifications, development Testing of solutions and identifying and solving related issues. I have been involved in implementing many features for the optimization of procedures and also implemented Dynamic SQL in Procedures.

I have also been involved in imparting Training to other colleagues and I am always ready to take up new challenges and come up with Best Solutions.

Good& interpersonal, communication and presentation skills& with ability to work in team with diverse background. My objective is to obtain a scalable position in IT industry, for the purpose of demonstrating and sharing the professional skills, that rewards continuous growth. Focus on undertaking any responsibility, which offers an immediate challenge according to my performance and ability.

Worked with& Infosys Technology Ltd& as& TechnicalAnalystfrom Sep 2006 to Oct 2010.

Post-GraduationB.Sc Computer Science and MCA from Confidential, University.

Skill Type:

PLATFORMS:

Microsoft Windows (All versions), Unix / Linux.

DATABASE:

Oracle 9i, Oracle 8i.

LANGUAGES:

SQL, PL/SQL.

FRONTEND TOOL:

Developer 2K (Forms 6i, Reports 6i), XML Reports.

ERP:

ORACLE APPS (Release 11.5.9 and 11.5.10).

TOOLS:

Toad, SQL Developer, SQL*Loader.

VERSIONING:

VSS, Perforce.

Project Details:

Starbucks Global Business System Solutions (GBSS) Program – NA Rollout

Client :Confidential, Seattle, USA
Duration :Jul 2009–Oct 2010
Role :& Development, Testing, Documentation, Knowledge Transfer, Supporting&
OS/Tools :& Oracle 9i, Oracle Apps (11.5.9 11.5.10), Oracle Developer 6i, TOAD, SQL Developer,
UNIX, Microsoft Office, Perforce
Location& :& Offshore

I was involved in Implementation and System Testing of Oracle Apps 11.5.10.2 of& Oracle Purchasing,& OTM (Oracle Transportation)and& QualityModules for North America rollout phase.

Role:

• Technical Analyst

Key Responsibilities:

• I was involved in Implementation of Oracle Apps 11.5.10.2 of Oracle Purchasing; Qualityand OTM modules for the North America rollout phase for a US based Coffee Retail Company. As a SCM track technical consultant, I was responsible for preparation/review of technical designs, Test plans, build, unit testing, handling client requests, troubleshooting and co-ordination.
• Proficiency in SQL/Data Loader. Created complex code for loading Purchase Orders manually during the System Testing phase.
• Took extra responsibility as a Configuration Controller along with the regular Project Work. Being a configuration controller, I was responsible for version maintenance in Perforce, VSS and migration of components in various instances like Assembly Testing Instance, System Testing Instance etc.
• Involved in the development of Interfaces, Extensions and Reports.
• Imparted KT sessions on OTM within the team.

Starbucks Global Business System Solutions (GBSS) Program – 5RP

Client :& Confidential, Seattle, USA
Duration :Apr 2009 – May 2009&
Role :& Development, Testing, Documentation, Knowledge Transfer, Supporting&
OS/Tools :& Oracle 9i, Oracle Apps (11.5.9 11.5.10), Oracle Developer 6i, TOAD, SQL Developer,
UNIX, Microsoft Office, Perforce&
Location& :& Offshore

Project Description:-

I was involved with Assembly Testing for various Report‘s Components which includes RDF and XML Publisher Reports.

Role:

• Technical Designer
• Software Developer

Starbucks Global Business System Solutions (GBSS) Program – EMEA Rollout

Client :& Confidential, Seattle, USA
Duration :Jul 2007–Mar 2009
Role :& Development, Testing, Documentation, Knowledge Transfer, Supporting&
OS/Tools :& Oracle 9i, Oracle Apps (11.5.9 11.5.10), Oracle Developer 6i, TOAD, SQL Developer,
UNIX, Microsoft Office, Perforce&
Location& :& Offshore

Project Description:

The project was one of the biggest IT project’s of the company, aimed at implementing a global financial, order management, and logistics system using Oracle Applications as the platform. Europe was chosen as the first Implementation site (known as phase 1). Infosys undertook end-to-end implementation starting with Project Conceptualization carrying through solution Design, development, testing, cut-over and post go-live support.
I was involved in implementation of Oracle Apps 11.5.10.2 of Oracle Process Manufacturing suite, OPM; Order Management and Inventory modules for the EMEA rollout phase for a US based Coffee Retail Company. As a SCM track technical consultant, I was responsible for preparation / review of technical designs, test plans, key role in planning and execution of Integration Test, System Test , handling client requests, troubleshooting and co-ordination.

Key Responsibilities:

• To translate functional requirements into Technical Specifications, development and testing of RICE Components in Oracle, PL/SQL.
• Involved in the development of Interfaces.
• Involved in Conversion from Legacy to Oracle. Designed, developed and tested On-Hand Inventory Conversions e.g., uploaded the Transaction data from Legacy system to Oracle Inventory and perform validations and Error handling of legacy data before importing and Stock Locators Conversion.
• Used Procedures, Cursors and Functions to code various interfaces and implemented many features for the optimization of Procedures.
• Designed / Developed and Tested PL/SQL Packages and Oracle Reports according to the timelines specified. Actively debugged the PL/SQL code to resolve errors encountered in various test phases.
• Provided the maintenance and testing support for the Project whenever required.
• Developed and tested OTC and FTP Reports using Report Builder 6i as per the client requirements and also developed XML Publisher Reports if the output required was of type PDF or EXCEL.
• Prepared RIPE components (Re-usable components) for both conversions as mentioned above and imparted KT sessions for the same within the team.

Others

• Development and testing of Forms as part of the Project.
• Forms developed :-
• Holiday Tracker – developed to provide read, write and other access to a particular user based on his/her role.
• Leave Tracker – It captures all details like how much effort was spent over a particular component so that day to day work done by an individual can be tracked easily. It involved populating most of the details dynamically.
• Mentored and trained fresh recruits in Oracle Apps at Infosys with the help of various technical / functional presentations and Knowledge Transfer sessions.

Achievements / Extra Curricular:

• Working Member of an& NGO PRAYAAS& at Infosys. Have been a part of& Old Age Home visit, Orphanage Program and Rural Education Reach.
• Event coordinator in College Festivals.
• Gold medalist in Badminton Sub Junior Group at State Level Championship.