SUMMARY:

• Over 9 years of experience as an Oracle Applications Technical Consultant while working with Confidential , Confidential Computers System and Confidential Systems.
• Worked on Implementation, Upgrade, Confidential and Support Projects.
• Worked on INV, PO, AR, OM, AP, Depot Repair and Custom modules as per the business requirements Modules.
• Project work excellence acknowledged by Valuable Contribution Award and recognized as an Oracle Certified Associate.
• Technically competent development/customization of applications using the Oracle Applications R12, 11i, PL/SQL, Oracle Forms/Reports.
• Acquired Process knowledge through various roles like System Administration, Configuration Management and Value Innovation.
• Strong problem solving & analytical skills.
• Self - motivated, excellent team player with proven leadership skills.

TECHNICAL SKILLS:

• Inventory
• Purchasing
• Order Management Business Flow
• Accounts Payables
• Account Receivables
• Depot Repair
• Projects, Lots, Tasks, Classifications
• Oracle P2P (Procure to Payment) Cycle
• Oracle O2C (Order to Cash) Cycle
• Develop Custom Module as per Business Requirement
• Inventory
• Purchasing
• Order Management Business Flow
• Accounts Payables
• Projects, Lots, Tasks, Classifications
• Oracle Org Setups
• Work shifts
• Request Group, Request set, Concurrent Manager
• Define Flex fields
• Define LOV, Profiles
• Form, Report Registration
• User Access Control
• Oracle Apps R12
• Oracle D2K 10g, Oracle D2K 6i
• Form Personalization
• SQL, PL/SQL
• UNIX
• SVN (Apache Subversion )
• HPPM
• Item, Item Attributes, Categories, Relationships and Lots (INV)
• Oracle Projects, Classifications, Tasks (PA)
• Vendor, Vendor Sites (PO)
• Purchase Order(PO)
• AP Invoices (AP)
• Sales Order, RMA (OM)
• Customer, Customer Sites and Contacts (AR)
• Projects, Tasks and Project Expenditure (AR)
• Invoices, Receipts (AR)
• Service Request, Service Lines (Depot Repair)
• Logistic Lines, Customer Estimates (Depot Repair)
• Customer Billing, Vendor Billing (Depot Repair)
• Development/Enhancement in Oracle Forms
• Developed/Modified .RDF report as per the business requirements
• Developed/Modified Packages, Procedures and Triggers
• Form personalization

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Onsite Techno Functional Lead

Responsibilities:

• Working as Onsite Technical Lead managing offshore team size of 15 members.
• Business meetings to get the requirement gathering.
• Understand the requirements and propose the functional solution compatible with existing application, Prepare CF250 (Functional design for all components) Document.
• Perform Business deliverables review (CF250, MD200), Code review before submitting for business review.
• Review codes and execution times to maintain the application performance mark as per the SLA.
• Review MD200 (Technical Solution for Approved CF200) document along with Business to confirm the solution provided by Technical team matches with Solution proposed in CF250.
• Write Functional Test scripts ( TE.010 ) to cover all business scenarios and perform positive and negative testing.
• Review the defects and monitor team is entering defects in Defect tracking tool.
• Conduct monthly defect meeting.
• Performing Code Walkthrough, Peer Review.
• Successfully worked on form personalization to provide easy and oracle vanilla solution for complex business requirements.

Environment: Oracle ERP R12, PL/SQL, Account Receivables Module, Oracle Forms/Reports

Confidential

Technical Lead, Grand Prairie, TX

Responsibilities:

• Working as Confidential Track Lead at Onsite.
• Prepare Confidential Project plan depending on resource count and timelines provided by business to complete the project.
• Client interaction for requirement gathering and Creating CV.010 (Define data Confidential requirements and strategy) Document.
• Reviewing Business objectives, Understanding the Business processes and the feasibility study for Successful Confidential .
• Developing Business Scenarios, GAP Analysis to propose the new functionalities.
• Creating and Reviewing with business for approval CV.10 ( Confidential Strategic Plan) Document.
• Creating and Reviewing with business for approval CV.40 ( Confidential Functional Dependencies Documents) Document.
• Creating CV.200 ( Confidential Technical/Functional Design) Documents.
• Map the Legacy application table with Oracle base table and define DFF’s for Custom attributes and Get business approval on it.
• Define Extract layout to get date from Legacy application to Oracle application data load.
• Documenting Test Scripts to carry out the different scenarios pertaining to the technical object in scope of test.
• Successfully Completed Confidential for below modules:
• Oracle SCM Item, Item Attributes, Categories and Relationships
• Oracle Finance Projects Lots, Projects, Classifications and Tasks
• Oracle Order Management Sales Orders, Price List, Customer and Vendor Quotes
• Vendor, Vendor Sites, Purchase Orders, Customer, Customer sites and contacts
• Open AR and AP Transactions.
• Depot repair service lines and corresponding all data
• Held CV.200 documents reviews with Business for Final Approval.
• Pursue a Good technical and functional knowledge on P2P and O2C cycle provided solutions to other teams to work on vanilla module.

Environment: Oracle ERP R12, PL/SQL, INV, AR, PO, P2P, O2C and OM module

Confidential

Onsite Co-Coordinator, Team Lead, Stamford, CT

Responsibilities:

• Worked as Onsite coordinator at Onsite for 1 year and Team Lead at offshore for team size of 15 members.
• Business meetings to get the requirement gathering.
• Understand the requirements and propose the functional solution compatible with existing application, Prepare CF250 (Functional design for all components) Document.
• Held Business meeting for CF250 Documents Final Approval.
• Review MD200 (Technical Solution for Approved CF200) document along with Business to confirm the solution provided by Technical team matches with Solution proposed in CF250.
• Write Functional Test scripts ( TE.010 ) to cover all business scenarios and perform positive and negative testing.

Environment: Oracle ERP R12, PL/SQL, Account Receivables Module

Confidential

Offshore Team Lead, Performance Tuning, Integration Admin

Responsibilities:

• Manage Development team for Interface, Reports and RA to HZ changes.
• Assign and Monitor the team members’ tasks as per the project plan, make sure the timelines are followed by team mates to meet the project deadlines.
• Raise the risks or delay due to any issues and report the same to management, Update the project plan if required with approval.
• Work as Technical lead for team, Review the teammates work and provide inputs as per findings.
• Mentor and motivate team members to work on project.
• Schedule and Conduct training sessions for new team members.
• Prepare weekly project report and present it to Client.
• Provide updates on project progress.
• Perform Business deliverables review (CF250, MD200), Code review before submitting for business review.
• Review codes and execution times to maintain the application performance mark as per the SLA.
• Handle/Monitor /Setup Integration with other Applications
• NDM
• FTP
• SFTP
• MQ (Message Queuing)
• Review the defects and monitor team is entering defects in Defect tracking tool.
• Conduct monthly defect meeting.
• Performing Code Walkthrough, Peer Review.
• Work on the Complex performance issues and provide solution.
• Carrying out System Integration Testing SIT and User Acceptance Testing UAT
• Preparing Design of the Confidential Programs and Confidential Unit Test/ Validation test for these programs.
• Handling Change Requests for enhancement in the project functionalities
• Performing System Administration Activities.
• Communicating with Oracle Metalink for technical assistance in some issues.
• Value Innovations by process changes.
• Received opportunity to interact with client and lead team from Mexico office for short term.

Environment: Oracle ERP 11i, R12, PL/SQL, Forms, Reports Account Receivables Module

Confidential

Team Member

Responsibilities:

• Understanding Business requirements and prepare IT requirement Document.
• Developing Interface programs i.e. PL/SQL packages.
• Performing Code Walkthrough, Self/Peer Review.
• Carrying out System Integration Testing SIT and User Acceptance Testing UAT
• Preparing Design of the Confidential Programs and Confidential Unit Test/ Validation test for these programs.
• Handling Change Requests for enhancement in the project functionalities
• Performing System Administration Activities.
• Production Support, resolution of production issue/tickets reported by users.
• Communicating with Oracle Metalink for technical assistance in some issues.
• Value Innovations by process changes.
• Configuration Management of elements through check in - check out requests and ensuring the integrity of elements for given project functionality.
• Conduct Defect Prevention Meetings and discussion on trend charts.

Environment: Oracle ERP 11i, PL/SQL, Forms, Reports Account Receivables Module