SUMMARY:

• I have over 14 years of experience in Oracle E - Business Suite. I completed Master’s degree in Management Information System (MIS) from University of Memphis, Tennessee in year 2000 and a Masters in Computer Application ( MCA) from Birla Institute of Technology, Mesra, India.
• Worked in several projects that spread across New Implementations, RICEW, PLSQL, Unix Shell Scripting, Upgrades, Interfaces, Conversion, Production Support and Rollouts of Oracle E-Business Suite.
• Extensive expertise in leading large and multi-faceted software development and customization projects.
• Proven ability to deliver results and motivate teams, in challenging and often stressful environments.
• Ability to lead a team to accomplish goals/assignments and create team atmosphere.
• Expert in analyzing business processes, process re-engineering, and recommending solutions and implementing necessary solutions to insure automated functionality.
• Ability to deliver high quality results with attention to details. Excellent Analytical skills and ability to work efficiently in a multi-tasked environment.
• Involved in Planning, Operation Analysis, Design & Build, Transition, Production, Support and Sustenance and prepare project deliverables in AIM (Application Implementation Methodology).
• Involved in improving operational metrics, business case development & performance measurement
• Worked in various industries such as Software, Finance, Credit Card Services, Insurance and Manufacturing
• Excellent communications and interpersonal Skills. Well versed in gathering requirements from customers/clients.

TECHNICAL SKILLS:

Oracle E: Business Suite (AOL, Application System Administration, Oracle Alerts, General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Project Accounting, Purchasing), Unix Shell Scripting.

Worked as Technical consultant in Various Oracle financials (EBS), supply chain Modules (SCM) and BI Publishers Report.

Extensively worked on Design and Analysis and implementation of RICEW components.

Having Good knowledge of Testing, Migration and version Control tools, Toad, Sql Developer, SQL Tools, ALM (Application Lifecycle Management)

Well Experienced in various versions of Oracle Database.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Application Development Specialist

• Managed and supported the Oracle Financials, especially on General Ledger, Accounts Payable, Accounts Receivable, Inventory, Purchase Order, Oracle Project Accounting and Fixed assets as part of the routine process.
• Architect, Troubleshooting and Test the environment for Go Live
• Responsible for analysis, design, development, work assignment and tracking, estimation, bug fixing, debugging, testing, review, documentation and internal tool development.
• Managed on-shore and off-shore group of Developers.
• Work effectively with Oracle support and the Business users to resolve issues.
• Formulate project scope and objectives and monitor the progress in DEV, QA, UAT and PROD instances and make sure SOX controls are followed.
• Initiate and conduct design review meetings with both management and Business.
• As part of 10g database upgrade, worked with QA in testing all the business processes.
• Performed extensive conversions, interfaces of Oracle Payables, Oracle Receivables, Oracle Purchasing, General Ledger and System Administrator modules and resolved issues in the Production instance.
• Worked on the Interface Solution design specifications.
• Facilitated Design sessions with resources in geographically dispersed locations to execute key project milestones and deliverables.
• Developed Dashboard to record the SAT and UAT sessions.
• Served as Testing Lead for multiple work streams to ensure system readiness and viability
• Coordinated and facilitated sessions with Confidential Client and third party teams to drive, plan, execute data conversion and archiving strategy

Confidential, Houston, TX

Oracle Application Consultant

• Worked on several packages, procedures, functions, trigger and other database objects.
• Communicate and Report on project progress with IS management, business users, and other project staff.
• AP Vendor Conversion: Designed and Developed custom program for Vendor conversion.
• Created Vendor Interface for the flow of data from Oracle to POS/Legacy systems.
• AP Invoice Interface.
• AR Invoice Conversion/Interface: Used both Interface table and API
• Worked on several packages, procedures, functions, trigger and other database objects.
• Customer Conversion: Used Bulk Load Process to load the Party and relationships. Very conversant with TCA Architecture.
• AR Receipts Conversion/Interface: Used both Invoice API and also standard Invoice Interface table.
• Worked with business users to prioritize issues and monitor adherence to Production Support SLAs, development standards and procedures.
• Involved with user at all levels to determine the user requirements and preparing the technical and functional documentation (MD070, MD050. MD120).

Confidential, Houston, TX,

Lead Oracle Application Developer

• Projects, Task, Agreement, Funding and Budget conversion in Project Accounting (PA) Module.
• Designed a custom hierarchy report which provides executives with immediate access to the PO approval hierarchy along with the approver’s approval limits.
• Provide periodic Stats and Reports on the conversion and interface activities as required by PMO.
• Management and development of offshore and onshore team.
• Interact with the team of developers and offshore group to define the requirement and track the progress of the deliverables.
• Created value sets and descriptive flex fields.
• Create GL import program on R12 network. Converted Oracle 11i extract from NPC to Confidential R12 environment.
• Use PL/SQL Tables, Bulk collect for better performance
• AR Invoice, Receipt and Adjustment conversion.
• Implemented AP Invoices Conversion.
• Worked on several packages, procedures, functions, trigger and other database objects.

Confidential, Charlotte, NC

Sr. Oracle Application Consultant

• AR Conversions and Interfaces:
• Customer Conversion/ Interface: Used Bulk Load Process to load the Party and relationships. Very conversant with TCA Architecture.
• AR Invoice Conversion/Interface: Used both Interface table and API
• FA Conversion: Fixed Assed conversion using Mass Additions. Customized the FA Account Generator WF.
• General Leger Conversion and Interface:
• Created Custom Collection Process for Oracle Incentive Compensation Module.
• AP Vendor Conversion: Designed and Developed custom program for Vendor conversion.
• Worked on several packages, procedures, functions, trigger and other database objects.
• Analyzing and Tuning the code using TKPROF and Explain Plan.
• Involved with user at all levels to determine the user requirements and preparing the technical and functional documentation (MD070, MD050. MD120).

Confidential, DeForest, WI

Oracle Application Consultant

• System Administration activities included creating new responsibilities, requesting groups and users, registering custom applications, and registering forms as functions and reports as concurrent programs.
• Involved with user at all levels to determine the user requirements and preparing the technical and functional documentation (MD070, MD050, CV060, MD120).
• Designed/developed various interface/conversion in AP and AR modules
• Worked on receipts conversion using Receipt API.
• Worked on conversion; used standard customer interface table and TCA API to update customers
• Worked on the customization of Subcontractor Conversion. (ENCE Conversion)