Professional Summary:

• Oracle ERP professional with around 10 years of diversified experience in Developing, Implementing, Support, testing and managing full lifecycle projects globally.
• Implemented and supported various Oracle application modules: Account Payables, Accounts Receivable, General Ledger, Fixed Assets, Cash Management, iexpenses, ireceivables, EBTax, Project Accounting.
• Experience in all phases of complete Life-Cycle Implementation of Oracle SCM including Definition, Operation Analysis, Solution Design, Build, Transition and Production support.
• Proficient in support, upgrade and implementation of Oracle E-Business Suite R12 and 11i.
• Expertise in Inventory, Purchasing, Order Management, Shipping, Advanced pricing and procurement modules with a very good understanding of the integration between the distribution and finance modules.
• Good understanding of financial applications, processes and supported AR Invoices and Accrual reconciliations.
• Proficient in functional flow of Order to Cash O2C and Procure to Pay P2P cycles
• Provided technical support for all Inbound / Outbound transactions utilized within Order to Cash O2C and Procure to Pay P2P cycles
• Proficient in writing PL/SQL Scripts and other related tools and techniques on Oracle Database.
• Proficient in registering Concurrent Programs, Form, Functions, Tables, developing Descriptive Flex-fields in Custom Applications and defining Profile values by using Application Object Library AOL , System Administration and Documentation in Oracle Applications.
• Expert in preparing Technical specs, user manuals, test procedures, training and document preparation.
• Proficiency in understanding client's needs and generate, modify reports existing in Oracle Applications according to the requirements and specifications.
• Experience in Workflow. Development and Customization of RICE components-Reports, Interfaces, Conversions- and packages related to Oracle Apps Modules OM, INV, Oracle EDI Ecommerce Gateway in Oracle Application R11i

Professional Experience:

Confidential

Role: Oracle Apps Techno functional consultant/Team lead

Environment Oracle R12.1.3, Oracle 9i, Sql, Pl Sql, Unix OS, Toad, Service now, Quality center, Version Control tool: PVCS, Issue Track, Oracle AP, AR, GL.FA, CM, OM, PO, INV, PA, Iexpenses, Ireceivables, EB tax

Responsibilities:

• Application production support and bug fixing Data Fix.
• Major/Minor Enhancements Detailed Design and review, Integration and Regression Testing.
• Stabilization Activities for applications.
• Onsite Offshore Coordination/Status Review and meetings with the offshore Team and other vendors.
• Preparation of Business documentation.
• Technical assistance on Iexpenses transactions and integration.
• Custom Process Designing, Providing functional inputs at the time of development of the component.
• Fixing all the bugs that may arise in production.
• Unit testing and integration testing of the enhanced modules.
• Work on Incidents, Request items and provide RCA, solution and permanent fix within SLA.
• Co-ordination with IT team of client and development of components with technical team.
• Supported AR Invoices and Accrual reconciliations.
• Designed and developed Asset Conversion by running Mass Additions Concurrent Program to transfer the data from interface to base tables in Fixed Assets FA .
• Developed an interface to load bank statements into the Cash Management.
• Requirements Gathering and Gap Analysis between the AS-IS and the To-Be process.
• Work with the Business Analysts to prepare functional specification during the project requirements stage. Direct the offshore team for documentation of functional requirements for client submission and approvals.
• Preparation of technical design document and submit document for client approval. Implement client revisions and comments to the application design.
• Unit Testing, Integration Testing and deployment.

Confidential

Role: Oracle Apps Techno functional consultant/Team lead

Environment Oracle R12.1.3, Oracle AP, AR, GL.FA,CM, PA, EBtax, Iexpenses, Ireceivables, OM, PO, INV, Oracle 9i,Sql,,Pl Sql, Java ,Unix OS, Toad, Action Request system Remedy , Quality center, Version Control tool: PVCS, Issue Track

Cbeyond is using Oracle Applications for Enterprise Resource Planning--Team CADMS is aimed in providing technology solutions and IT support for the core corporate business functions, primary area of focus includes Finance and Accounting functions, as well as Human Capital Management HRIS Payroll . Activities include preparing business cases to validate priorities, business requirements definition, define UAT test scenarios.

Responsibilities:

• Oracle Apps Implementation of Financial Modules AP, AR,GL.FA,PA,EBtax
• Requirement Analysis, Design and Development.
• Data Migration from Legacy system to oracle application
• Created Concurrent Programs, Executables, Parameters and Value Sets through backend process API development
• Interface development in Financials Modules.
• Accountable for the entire project lifecycle spanning scope, design, build, test, rollout and warranty support using Oracle's AIM Methodology.
• Develop and maintain productive business relationship with customers.
• Extensively worked on Fixed Assets FA, Project Accounting PA Billing, Costing and Management .
• Developed an interface to load bank statements into the Cash Management.
• Involved in effort estimation, consolidation of project plans and participating in status calls.
• Focus on mitigation of risks based on requirements, review of documents, designs deliverables RDs, MDs, TEs .
• Coordinate testing and rollout of projects with the user community and render post production onsite support for the client.
• Writing Technical specification document for the Functional specification document.
• Developing RICE components,-Reports, Interface, Conversions, Extensions
• Supporting Iexpenses transactions, integration
• Supported AR Invoices and Accrual reconciliations.

Confidential

Role: Oracle Apps Techno functional consultant

Environment:Oracle Apps 11.5.10 Oracle Order management , Oracle OM,PO,INV, Install base/Service contract, Oracle 9i,Sql,Pl Sql, Java ,Unix OS, Toad, Action Request system Remedy , Ireceivables, Quality center, Version Control tool: PVCS

Cisco common workspace

A single integrated, scalable, intuitive workspace to engage with Cisco throughout the purchasing process. 1. All opportunities, quotes, configurations and orders in one place 2.Simplified user experience across all four steps 3.Scalable and reliable system architecture resulting in drastically improved performance 4.Foundation for services and solution selling

Responsibilities:

• Writing Technical specification document for the Functional specification document.
• Working on Change requests and provide necessary technical solutions.
• Working with Cross flows and technical team to move toward resolution of problems reported, and update the concerned on latest status and progress resolving those issues.
• Complete Software development process-Design, test and deploy according to Cisco's DMAIC Methodology
• Support of Install Base/service contract Error Resolution, Item Instance Management, and Full Cycle Manufacturing through Shipping Install Base Instance Maintenance.
• Create and maintain customized mapping and provide technical support for all inbound / Outbound EDI transaction sets utilized within Procure to Pay PTP and Order to Cash OTC processes.
• Developing code and application and testing them in Test instances.
• Manage priorities to deliver to the SLA.
• Responsible for status reporting.
• Developing, testing and debugging of program code.
• Involved in Setup Requirements gathering through BR100 MD050
• Following and keep track of BR100 MD050-- there may be changes to these docs depending on the reviews, testing results.
• Validating the BR100 and actually entered data in DV1OMR if there is discrepancy- reaching out and getting the clarification from cross flows.
• Review Fixes: Reviewing BR100 MD050 docs and those configured in dev. env to identify any gaps, issues and later clarified absorbed by cross flow teams to update the fixes/changes to the respective setup requirements/configurations

Confidential

Role: Oracle Apps Techno functional consultant

Environment: Software Application: Oracle 12.1.3 Oracle AP, AR, GL.FA, CM, OM, PO, INV, Ireceivables, Database: Oracle 9i, Languages: SQL, PL SQL, JAVA, Server: UNIX OS, Tools: Toad, Service now, Quality center, Version Control tool: perforce

GAMS-East:

Oracle Apps Implementation

• Oracle Apps Implementation of Financial Modules AP AR.
• Requirement Analysis, Design.
• Data Migration from Legacy system to oracle application.
• Complete setup of AP AR.
• Extensively worked on Fixed Assets FA, Project Accounting PA Billing, Costing and Management .
• Preparation of AIM documents such as BP080, TE040, BR100 Business Scenarios.
• Focus on mitigation of risks based on requirements, review of documents, designs deliverables RDs, MDs, TEs .
• Supported AR Invoices and Accrual reconciliations.
• UAT at onsite.

Confidential

Role: Oracle Apps Technical Consultant

Environment: Oracle Apps 11i, Oracle 10g, Forms 6i, Reports 6i, SQL, PL/SQL, Unix, PL/SQL Developer, Kintana, Perforce, Application Object Library AOL , System Administration, OM, Inventory, WIP, Order Management, Account Receivables, Account Payables, Purchasing PO and BOM

• Description: Developed a tool to track spending to the level of individual parts. It provides functionality to enter cost based on negotiations, add/ modify cost as per Drum beat, maintain cost based on Primary commodity code and secondary commodity code levels, upload cost shared by contract manufacturers. Responsibilities:
• Worked on Item export from oracle to Spend management tool.
• Developed reports needed for Spend management tool like Item cost report, Item Assembly Report, Cost Comparison Report etc.
• Developed package that will move orders to order management through Order Import API.
• Developed Package that will display Items where used for BOM in Spend Management tool.
• Worked on cycle count concept on Spend Management Tool.
• Auto create Purchase Orders
• Description: This project was initiated as there were PO's with more than 100 Lines

Responsibilities:

• Created Concurrent Programs and attached LOVs to the programs to select the employees
• Creating Temp tables and sequences for loading the Po's
• Written Shell scripts to move CSV file from shared drive to the server and then load them to the temp tables using SQL loader
• Created Request set for loading the Po's in Oracle Purchasing.

Other Responsibilities:

• Worked on Shell scripts to send report to users through email as well as multiple scripts including writing a code to make sql loader Generic.
• Developed Auto invoice interface that will move invoices to oracle AR from excel sheet.
• Used Perforce tool to manage code and Kintana to move objects to PROD.
• Redesigned existing reports for performance using temporary reporting tables, materialized views, indexes, and hints.
• Developed Payables Open interface which imports data from a data file into oracle AP

Confidential

Role: Oracle Apps Techno functional consultant

Environment: Oracle Apps 11.5.10 Oracle E-Commerce Gateway , Database: Oracle 9i, Languages: SQL, PL SQL, JAVA, Server: Unix OS, Tools: Toad, Action Request system Remedy , Selenium, EDIFY Translator application EDIFACT coding standard. Version Control tool: VSS, Perforce, EDI Standards EDIFACT, EDI Document ORDERS, INVOIC, DESADV etc, Direction Inbound, Outbound.

Confidential

Role:

• Responsible for handling issue logs
• Work with SME and technical team to move toward resolution of problems reported, and update the concerned on latest status and progress resolving those issues.
• Trading Partner, customer setup in EDI tool and Ecommerce Gateway setup.
• Manage priorities to deliver to the SLA.
• Responsible for status reporting.
• Developing, testing and debugging of program code.
• Testing Components

Confidential

Role: Oracle Apps Techno functional consultant

Environment: Modules: Oracle Applications 11.5.10, OM, INV. Languages: PL/SQL, Database : Oracle 9i,Tools :Toad,Remedy,Putty,FileZilla,Winscp3,Perforce,SQLPlus. O/s : Windows, Oracle Fusion Middleware, Oracle SOA Suite 10g/11

EA AMS WAVE1 Enterprise application production support

Project Description

Electronic Arts is one of the market leader in Gaming industry with revenue over 4Billion running across the globe. Currently EA is going under re-organization from Region based NA, EU, APAC, etc to Label Based structure EA Sports, EA Online, EA Studio, etc .Currently EA is having different production environment for each region and planning to have global instance with Oracle Applications R12.

Contribution

• As an Analyst, I was responsible for Application Maintenance Support and the following are my daily activities as a part of Application Support.
• Troubleshooting the Reports, Interface Struck Records.
• Troubleshooting the Errored out Concurrent Programs and finding the root cause for the same.
• Daily Interface Health Checks Job Monitoring.
• Incident and Issue Closure.
• Data Pull as per the user requirement.
• Performed Month End / Quarter End closing activities
• Participated in Daily and Weekly Status/Client Meetings.
• Providing solutions to client regarding the runtime errors through mails and updating the Remedy/Work Log with resolutions and root cause.

Confidential

Role: Oracle Apps Techno functional consultant

Environment: Software Java/JSP, Pl/Sql, XML, Database: Oracle 9i Tools: Oracle Designer, Oracle Workflow, Head start, XML Spy, Oracle CMSDK

O/s: Win NT, Sun OS

Confidential

Project Description

Electronic Warehouse is a storage facility used to permanently store Elsevier Science journals and all of the articles that comprise them as electronic files. It can then retrieve these stored files and transform them into a variety of electronic products - customized to meet the requirements of internal and external customers/market. The compiled products can then be delivered via a wide range of media like Network, CD-ROM, and diskette to external customers, to host systems such as Science Direct, and to their own internal departments.

Contribution

• As a developer, I was responsible for
• Development
• Coding using PL/SQL
• Testing - unit testing integration testing
• Document preparation and Management
• Providing technical solutions to the team for development as well as support issues