SUMMARY

• More than 17 Years of experience as a Technical Consultant in Confidential (R12/11i/11.03/10.7) with proficiency in Financials, Purchasing, General Ledger, Account Payables, Account Receivables, Order Management, Fixed Assets, Cash Management, Service contracts, Manufacturing, Bill of Materials, Shipping, Field Services, Work in Process, Oracle Projects, Human Resources and Inventory modules with major involvement in design, development and migration and open interfaces.
• More than 1 year experience in Oracle financials Cloud Technical Consultant
• Functional Experience in Financial Modules - Account Receivables, Fixed Assets, Payables, General Ledger, Cash management and Order Management.
• Experience in integrating custom and/or legacy applications with Confidential
• Years of development experience in Oracle technologies like PL/SQL, SQL* Plus, Oracle Reports (10G/6i/2.5) and Oracle Forms (10G/6i/4.5).
• Experience in ORACLE Workflow builder and AME Approval hierarchy setups
• Experience in Discoverer 10G and XML/BI Publisher Reports.
• Experience in OBIEE Dashboards and Analysis Development.
• Experience on Confidential Framework.
• Experience in Data conversion and Interface Development
• Experience in developing UNIX shell scripts.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, UNIX Shell Scripting

RDBMS: Oracle 12c/11G/10G/9i/8i/8.x/7.

Oracle Tools: Developer11G, 10G - Forms 6i/4.5/10G, Reports 6i/2.5/10G, Oracle Workflow Builder, XML/BI Publisher, OAF and Discoverer10G

DB Tools and Utilities: SQL*Plus, SQL*Loader, T OAD, WinScp, FileZilla and Putty

Operating Systems: IBM, Linux, Sun Solaris, HP-UX, UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential

Senior Systems Analyst

Responsibilities:

• Techno Functional consultant.
• Involves in Business meetings to gather requirements
• Responsible for Customization of Oracle Application objects as per the Business requirements
• Convert Business processes to Technical and functional Solutions
• BI Publisher Report Development in Financials, Payables, Receivables Purchasing, Projects and Fixed Assets.
• Preparing Installation shell scripts to migrate the custom code.
• Custom Interfaces development using PL/SQL, SQL Loader
• Iprocurment customizations using Requisition Workflow and AME Approval Setups.
• Implementation of New Warehouse at BC Province.
• Production support in various Confidential Modules
• Functional setups in various Financials, Inventory, Order Management and Shipping.
• Assists the Business to test the solutions in UAT and promote to PROD.

Confidential

Systems Analyst

Responsibilities:

• Technical consultant with functional knowledge.
• Involves in Implementing Travel card and Procurement Cards.
• Responsible for Customization of Oracle Application objects as per the Business requirements
• Convert Business processes to Technical and functional Solutions
• BI Publisher Report Development in Purchasing, Receivables and Projects Accounting
• Preparing Installation shell scripts to migrate the custom code.
• Custom Interfaces development using PL/SQL, SQL Loader
• Production support in various Confidential Modules
• Functional setups in various modules like GL, PO, AP, AR and Cash Management.

Confidential

Consultant

Responsibilities:

• Financials Cloud Technical Consultant.
• Involves in Business meetings to gather technical requirements and GAP analysis.
• Design, development and testing of OTBI Reports and dashboards.
• Involved in Integration using FBDI and Automation with Webservices.
• Prepared Technical Specification documents.
• Involved in check printing, EFT, Remittance advices and Transmission files.
• Techno Functional consultant.
• Involves in Business meetings to gather requirements and GAP analysis. functional specs, preparing the documentation setups and maintaining Business Requirement Documents, Setup Documents (BR100) and MD050
• Involved in required functional setups in General Ledger, Account Payables and Cash Management.
• Responsible for migrating custom components from 11.5.9 to 12.2.5
• Custom Accounts Payables Invoice Form Upgrade.
• Migrating custom Financials PL/SQL packages and interfaces to 12.2.5
• Preparing Installation shell scripts to migrate the custom code.
• Troubleshoot Issues as part of after upgrade support

Confidential

Developer

Responsibilities:

• Techno Functional consultant.
• Involves in Business meetings to gather requirements
• Responsible for Customization of Oracle Application objects as per the Business requirements
• Convert Business processes to Technical and functional Solutions
• OBIEE Analysis and Dashboards Development.
• BI Publisher Report Development in Field Service,Payables, Receivables and Purchasing
• Preparing Installation shell scripts to migrate the custom code.
• Custom Interfaces development using PL/SQL, SQL Loader
• Production support in various Confidential Modules
• Functional setups in various modules like GL, AP,AR and Cash Management.
• Assists the Business to test the solutions in UAT and promote to PROD.
• Techno Functional consultant.
• Involves in Business meetings to gather requirements and GAP analysis. functional specs, preparing the documentation setups and maintaining Business Requirement Documents, Setup Documents (BR100) and MD050
• Involved in required functional setups in Orer2Cash Process such as Pick Release, Ship confirm etc.
• Responsible for migrating custom components from 12.0.6 to 12.1.3
• Order Management flow and setup testing in 12.1.3
• Migrating custom OM, INV interfaces to 12.1.3
• Preparing Installation shell scripts to migrate the custom code.
• Troubleshoot Issues as part of after upgrade support

Confidential

Systems Analyst

Responsibilities:

• Techno Functional consultant.
• Involves in Business meetings to gather requirements
• Responsible for Customization of Oracle Application objects as per the Business requirements
• Convert Business processes to Technical and functional Solutions
• BI Publisher Report Development in Order management, Payables, Receivables Purchasing and Fixed Assets.
• Preparing Installation shell scripts to migrate the custom code.
• Custom Interfaces development using PL/SQL, SQL Loader
• Iprocurment customizations using Requisition Workflow and AME Approval Setups.
• Customized AR Invoice, Customer Statements and Account status report to send emails
• Production support in various Confidential Modules
• Functional setups in various Inventory, Order Management and Shipping.
• Assists the Business to test the solutions in UAT and promote to PROD.
• As a Lead involved in the process of Oracle Projects Implementation for the Capital and Expense Projects
• Worked on various customizations in Project Costing, Project Management and PO modules
• Developed Custom Forms and Reports for Mapping the Historical Project Data.
• Involved in development of new custom forms, PL/sql Packages and XML Publisher reports
• Developed Extensions for Transaction Controls for Req,PO and Misc. Transactions.
• Developed Custom OAF pages using JDeveloper.
• Worked with business users on various scenarios and functional setups.
• Support the Business to resolve issues in Test cycles.
• As a Lead developer involved in the process of AFE Custom solution for the Capital Projects
• Worked on various customizations in Project Costing, Project Management and PO modules
• Involved in development of new custom forms, PL/sql Packages and XML Publisher reports
• Worked with business users on various scenarios and functional setups.
• Support the Business to resolve issues in Test cycles.

Confidential, CA

Lead Developer

Responsibilities:

• As a Lead developer involved in the process of Manufacturing R12 implementation
• Worked on various customizations and manufacturing scenarios(sun internal mfg) in BOM,WIP,MES(manufacturing execution system),INV and OM modules
• Involved in development of XML Publisher report Customer Information Sheet and Dekit report.
• Involved on personalization of MES screens and Black List Serial Numbers upload OAF page development.
• Worked with business users on various mfg scenarios and functional setups.
• Support the Business to resolve issues in Test cycles.
• As a Lead developer involved in the process of supporting production systems in SCM specific modules like PO, INV, BOM, WIP and OM.
• Interact with Business users in resolving service desk tickets (SDTs) .
• Work directly with Business users and make sure to meet SLAs from Offshore and onsite team members.

Confidential, CA

Consultant

Responsibilities:

• Interact with Client and understand the existing system and requirements for conversions and report creations
• Customize the Purchase Order as XML Publisher PDF document and usage of XML Bursting Program for Email.
• Setup the new codes and environment for Customized modules in ORACLE FINANCIALS
• Develop Discoverer reports 10G, Creation of Business Areas and Workbooks
• Involved in development of new custom PL/SQL Packages, control files to Convert the data from M2M Legacy system to Oracle R12(Immersion Medical)
• Creating SRs for the support of Oracle
• Work with Oracle to solve the Service Requests
• Interact with Client and understand the existing process and requirements to Customize..
• Setup the new codes and environment for Customized modules in ORACLE PROJECTS AND FINANCIALS.
• Involved in development of the custom PL/SQL APIs Interfacing data from Legacy to Oracle Apps(PA Tables)
• Involved in development of new custom PL/SQL Packages to calculate Employee BONUS and PAYCHECKS
• Involved in Designing of new Reports as per Clients requirements in Oracle reports and XML PUBLISHER.
• Creating SRs for the support of Oracle
• Work with Oracle to solve the Service Requests
• Register all the new objects in Confidential Development instance.

Confidential

Associate Consultant

Responsibilities:

• Interact with Business, Understanding the Cisco LEAN AS2 transmission process, analyze the requirements and prepare the technical design documents.
• Setup the new codes and environment for Customized modules.
• Interact with Architecture team about Database object requirements.
• Develop the Pl/Sql custom code and migrate to Test instance for Business testing
• Develop new reports and migrate to the test instance.
• Customize the Oracle Standard Forms as per Business requirement.
• Register all the new objects in Confidential Development instance.
• Define new responsibilities and Menu groups and assign to the users.
• Maintain the code versioning the PVCS.
• Migrate all the Latest version code to the Production using Kintana tool.
• Resolve the issues immediately in TCA, TCB Instances.

Environment: INV, ORACLE Apps 11i (OM, BOM, WIP, AOL), PL/SQL, Forms & Repots 6i, Oracle 8i

Confidential

Consultant

Responsibilities:

• Involved in migration of Business Objects from 10.7 to 11i
• Involved in the modules include Oracle general Ledger, Oracle order Entry, Oracle Inventory, Oracle Bills of Material, Oracle Work in Process and Oracle Purchasing.
• Involved in the study of the existing database and of the tables required
• Involved in designing of the new system using system analysis and normalized tables
• Involved in coding of stored program units and DB Triggers for table level integrity and implementing the code at GUI level..
• Testing the data validity.
• The primary responsibility of this Role is to design and develop the WebPages using Frontpage-2000 customer.
• Maintained the Intranet based information system for various departments of ONGC in order to provide MIS
• This system provides the Information of the all the Business Groups of ONGC.
• As a key member of the team I was involved in customization and interfacing process of Oracle Application for Langdon Shipment Project. Also involved in writing stored procedures, functions, packages, and developed several forms and reports.
• Involved in the study of the companies existing database and of table required .
• Involved in designing and MDI based GUI that interact with the existing database
• Programmed the Data control to retrieve the data, data entry screen using the regular controls like text boxes, list items etc.
• Testing the data validity.

Environment: MS-ACCESS, VB6.0, Crystal Reports