PROFESSIONAL SUMMARY

2 and ½ years experience in the field of Information Technology with expertise in Oracle Applications, Software Testing, Performance Tuning, and Programming.

Experienced in designing and developing Oracle Reports, sql and pl/sql.
Worked on Interfaces and Conversions to load the legacy information system to Release 11i which includes Item Attributes/Categories, Safety Stocks, AP Invoices, PO Approved Suppliers, Item Costs, Item On Hand Quantities using PL/SQL and SQL* Loader.
Worked on Modules Inventory and Cost Management.
Experienced in designing and developing Inbound Interfaces, Outbound Interfaces and Conversions in Oracle Applications.
Bench marking for the performance Tuning of SCMnet– JDE integration.
Good at XML Scripting.
Good GUI testing skills. Strong testing experience of the GUI in terms of standards and functionality.
Have Knowledge in writing of Test Case Design, Develop and Execution.
Expertise in Functional, Regression, Performance/Stress, Testing.
Good presentation and technical documentation skills.
A team player with concern for quality at all levels and ability to perform under stress.
Good understanding and Excellent Grasping Skills.
Comprehensive problem solving abilities.
Certified OCA on the Introduction to Oracle 9i.

OBJECTIVE
Seeking a challenging full-time position with a Company which will require me to utilize my skills, abilities and experience in the field of Information Technology to ensure the Company’s Success.

EDUCATION

Bachelor of Technology - Information Technology

TECHNICAL SKILLS

• Operating Systems: Windows 95/98/2000/2003/XP/NT/Vista/Windows 7, DOS, UNIX, LINUX
• Languages: SQL, PL/SQL, C, Java
• Databases: Oracle 9i
• GUI: Report 6i
• Case Tools: Toad, SQL*LOADER, SQL Developer
• Testing Tools: QTP, QC
• Scripting: PL/SQL, Shell, XML & VB
• Web Technologies: HTML

CERTIFICATIONS

• Certified OCA (Oracle Certified Associate), Introduction to Oracle 9i.

WORK EXPERIENCE
Confidential, Hyderabad, AP, India
Software Engineer / Associate Consultant May 2007 – Aug2009
Worked at Confidential, an IT services company operating in the off shoring enterprise applications and outsourced product development space as an accomplished software engineer.
Below are the various projects handled during my tenure at Sierra Atlantic starting from the most recent project.

Project: Confidential,
Client: Confidential,USA
Modules: Warehouse Management System (Oracle E-Business Suite)
Role: Test Engineer
Duration: May 2009 - Aug 2009
Environment: Oracle Applications 11.5.10.2, Oracle 10g, Internet Explorer

Project Description:
Confidential, is a world-class developer and provider of leading-edge solutions that help customers optimize the physical infrastructure through simplification, increased agility and operational efficiency. Panduit’s global manufacturing, logistics, and e-commerce capabilities along with a global network of distribution partners help customers reduce supply chain risk. The objective of this project is to ensure that all patches that are applied to existing Oracle modules at Panduit do not negatively impact the production Oracle systems.

Responsibilities:

• Understanding the business requirements and developed test scripts to test the complete functionality of the WMS (Warehouse Management Module).
• Involved in Automation of test scripts of Order Management & Warehouse Management Modules using QTP 9.5, QC 9.2.
• Interacted with Developers to identify and resolve technical issues.
• Tracked the bugs and reported them using defect manager of Quality center 9.2.

Project: Confidential,
Client: Confidential,USA
Modules: Inventory and Cost Management
Role: Software Consultant/Programmer
Duration: July 2008 – May 2009
Environment: Oracle Applications 11.5.10, SQL, PL/SQL, SQL Developer, Toad

Project Description:
Confidential,deals with production and sales of electronic goods. It has used a 3rd party database called BPCS to process its data. This project is an implementation project. The data has to be completely transferred from BPCS to Oracle Applications. The project deals with the development of different types of Conversions and Oracle Reports.

Responsibilities:

• Developed pl/sql procedures and packages for carrying out Item Attributes/Categories, Item On Hand Quantities, Item Costs, Safety Stocks, PO Approved Suppliers, and AP Invoices Conversions.
• Developed code for Attachments.
• Performed various validations on the Legacy data.
• Developed code for providing an Error Report for all the Conversions.
• Had mapped data from BPCS (Legacy values) to the Oracle values.
• Was responsible for the development of CV060 Documents.
• Was responsible for development of MD120 Document.
• Developed reports on Reports 6i.

Project: Confidential,
Client: Confidential,India
Role: Software Programmer
Duration: Jan 2008 – July 2008
Environment: Oracle Apps 11.5.10, Java on Windows XP, QTP 9.2, XML

Project Description:
The project involves design and development of QTP Automation framework for Oracle Applications along with automation of the test scenarios identified by DELL. The framework is an XML driven which is robust and easy to maintain. Test cases are defined in the XML format with navigation, execution steps and input data along with some critical validations that are needed for the test execution. The QTP fram4errework has XML engines which interpret the XML file into actions on the Oracle Apps system.

Responsibilities:

• Scripting of functional end to end integration scenarios.
• Involved in Review of Test Scripts (XML).

Project: Confidential,
Client: Confidential,USA
Role: User Interface Tester
Duration: Nov 2007 – Jan 2008
Environment: Windows XP, Java, JSP, MySql, Ajax, Tomcat 5.2, NSWB and AQUA Studio

Project Description:
Confidential, a leading targeted media company has embarked on an OSCAR Implementation project to mainly handle and manage its online subscriptions. This effort is to replace its existing COLT (Centralized online Transaction system) application. The key features of this project revolve around Offers and its subscribers. The project comprises of various modules including media management, template management, offers and its cross marketing options, reports, customer service and integrations into different applications.

Responsibilities:

• Understand the functional specifications and writing the test cases for Magazines, Offers, Discounts and Stores modules.
• Involved in the review of functional requirements.
• Involved in System Testing, Smoke Testing, Regression Testing.
• Reporting the defects to the developer and tracking the defects using defect-tracking system until closure.

Project: Confidential,
Client: Confidential,India
Role: Performance Tuner
Duration: May 2007–Nov 2007
Environment: Oracle 9i

Project Description:
Confidential,is a adapter product which connects Agile Applications to JDE .SCMnet 4.4 connects Agile09.X to any version of JDE. While testing SCMnet 4.4 one will have to use Agile extensively and verify if the data has been pushed to JDE. In view of the testing one will have to navigate into JDE thru various transaction codes for different parts.

Responsibilities:

• Fine Tuning of the Stored Procedures.
• Running the explain plan on the Queries to ensure, Oracle is picking the right indexes and joining tables in the most efficient manner.