SUMMARY:

• A Dynamic and accomplished professional working in Information Technology industry for approx. 14 years.
• Having over 12 years of total experience in Oracle Applications as Techno - Functional consultant with expertise on RICE (Reports, Interfaces, Conversions, Workflow, API’s, Data Migration, Data Conversion, and Concurrent Program API’s.
• Strong technical experience in design, implementation of interfaces, API and customization of Oracle Applications 11i and R12 (GL, AP, AR, CM, SLA, PO, OM, WSH, OM, INV, BOM, Pricing modules)
• Experienced as Techno Functional Consultant in Development, Analysis, Production support, Bug Fixes, Enhancements, Design, and team member in Implementation rollout of Oracle Applications Financials and Manufacturing suite of products.
• Expertise in AOL, System Administration, XML Publisher/BI Publisher, Workflow, Alerts and Trading Community Architecture (TCA).
• Having functional knowledge in Order to cash flow and Procure to Payment cycles.
• Involvement in Month End Activities and monitoring issue. AP, AR, INV Period close/open activities.
• Good experience in leading team as Onsite coordinator as well as offshore leads.
• Rich experience in writing AIM documents MD-50, MD-70, MD-120, CV-40 etc
• Customized various forms, reports and custom objects according to client’s requirements and integrate with the new system.
• Strong programming experience in creating Procedures, Packages, Cursors, Functions, Triggers and other database objects using SQL and PL/SQL.
• Proficient in writing stored procedures, Packages and functions using SQL & PL/SQL. Experience in UNIX Shell Scripting.
• Creation and follow ups of SR and Applications of Patches as and when required
• Excellent in analysis of current business processes, application configuration, managerial reports, and information processing.
• Hands on experience with Oracle Discoverer which includes report development, Discoverer Administration, configuring Discoverer and End User Layer (EUL)
• Excellent leadership and management abilities with effective interpersonal and communication skills with ability to work independently or part of the team.

TECHNICAL SKILLS:

Verticals:  Manufacturing, Software solution, Retail

Domains / Programming Skills:  Financials, Distribution/ ORACLE Apps 11i / R12 (A GL, AP, AR, CM, SLA, PO, OM, WSH, OM, INV, BOM, Pricing modules, India Localization), AOL, Oracle Alerts, BI Publisher Oracle Property Manager, Service contracts, Install Base.

Tools & Techniques:  MS Power Point, Service Now ITIL Tool, CVS & Ticket Handling tool (Vantive)

Databases:  Oracle 9i/10g/11g, PL/SQL,SQLSERVER 2000

Software Tools:  Developer 6i, 10g (Forms & Reports),SQL, Oracle SQL*Loader, TOAD, Workflow, Appworx, OAF, VB 6.0, Crystal Report 9,

Operating Systems:  Sun Solaris, Windows,UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential,CA 

Onsite Coordinator & Techno-functional consultant

Responsibilities:

• Leading team of multiple resources, assign tickets / tasks to offshore team.
• Involved in Production support and enhancement.
• Month End Activities and monitoring issue. AR, INV Period close/open activities.
• Responsible for applications support for systems/ business processes running on Oracle EBS platforms.
• Provided short-term and long-term solutions for issues in business processes in production support environment.
• Designed, developed and implemented change requests.
• Manage users' requirement and prioritize multiple tasks.

Confidential

Sr. Techno-functional consultant.

• Involved in Production support and enhancement.
• Responsible for applications support for systems/ business processes running on Oracle EBS platforms.
• Provided short-term and long-term solutions for issues in business processes in production support environment.
• Designed, developed and implemented change requests.
• Manage users' requirement and prioritize multiple tasks.

Confidential 

Sr. Techno-functional consultant.

• Involved in Production support and enhancement.
• Period Close Activities.
• Financial Reconciliation between GL & Sub-ledger modules.
• AOL related job like defining concurrent program, DFFs, Form Registration, Value-sets creation, new User creation, responsibility definition etc.
• Design and Development of reporting components (Oracle Forms ; PL/SQL; Oracle Reports; XML Publisher) for Oracle Applications modules and parts of the custom system.
• Manage users' requirement and prioritize multiple tasks.
• Creation of various Oracle Alerts (ALR) to inform internal users of certain events, or to notify suppliers of invoice payments.

Confidential 

Techno-functional consultant.

• Involved in Production support and enhancement.
• Period Close Activities.
• Financial Reconciliation between GL & Sub-ledger modules.
• India Localization Tax / Tax category definition, location assignment to IL tax regimes.
• AOL related job like defining concurrent program, DFFs, Form Registration, Value-sets creation, new User creation, responsibility definition etc.
• Defining Security rules and cross validation rules.
• Component design and technical specification for Interface program from Oracle Retail to Apps in AR, AP & GL modules. Accounts mapping & events related to Oracle Retail integration.
• Design and Development of reporting components (Oracle Forms ; PL/SQL; Oracle Reports; XML Publisher) for Oracle Applications modules and parts of the custom system.
• Act as team mentor for custom development like Quantitative Fixed Assets Register, Custom Audit Trail for Supplier Master & Bank details, AR-AP Net off program etc..
• Work with client to meet and exceed all agreed to Service Level Agreements (SLA) for the organization.
• Providing fixes to the issues for post migrated objects which are getting addressed after upgradation.
• Manage users' requirement and prioritize multiple tasks.
• Creation of various Oracle Alerts (ALR) to inform internal users of certain events, or to notify suppliers of invoice payments.
• Handles Oracle SR for R12 bug fixing.

Confidential

Techno-functional consultant

• Analysis of requirements for new enhancement and impact analysis.
• Period Close / Month End Activities.
• Preparation of High Level & Low Level Design documents.
• Development of code as per the business requirements
• Guided Unit testing and system integration testing of the developed code.
• Providing fixes to the issues identified in testing phase.
• Packaging of the developed component to be deployed in production environment.
• Provide support for day to day issues in smooth functioning of the applications.

Confidential

Sr. Technical consultant

• Study and analysis of the requirement and provided the available scopes for development.
• Development and writing codes for validation of data in staging table coming from CRM to Oracle Apps.
• Created PL/SQL scripts/package by using API like UTL SMTP, UTL FILE etc. for mailer program. It will perform actions like sending emails to concerned person/team for customer creation and project creation. Some flag updations are included as well.
• Registration of Concurrent Program to enable users to schedule and run program from Standard Report Submission.
• User interaction to train them how to use the program.
• Value sets creation using complex clauses/where by statements.
• Contribution in exhaustive testing, creating and debugging for new and existing packages.

Confidential 

Sr. Technical consultant

• Provide production support for the project.
• Unit testing and system integration testing of the developed code.
• Design and customization of Oracle Apps Form.
• Development and writing codes for SQL Loader, Packages for loading Item master.
• Created PL/SQL scripts to upload data from Flat file into Oracle Interface tables.
• Involvement in customization reports. Registration of the PL/SQL scripts and Reports as Concurrent Programs to enable users to schedule and run programs from Standard Report Submission.
• Massive contribution in exhaustive testing, creating and debugging for database packages, functions, procedures, triggers etc.

Confidential 

Techno-functional consultant

• Production support in day today basis.
• Involved in month-end activities.
• Hands in Purchase Workflow.
• Worked with SQL Loader for loading Item master.
• Massive involvement in customization reports. Registered all the PL/SQL scripts and Reports as Concurrent Programs to enable users to schedule and run programs from Standard Report Submission.
• Design and development of customized Apps form.
• Exhaustive testing, creating and debugging for database packages, functions, procedures, triggers etc.

  Confidential 

Techno-functional consultant

• Played key role in AOL related job like defining DFF, Form Registration, Value sets creation, new User creation, responsibility definition etc.
• Defining Security rules and cross validation rules.
• Working with Oracle Alert definition and scheduling.
• Hands in Purchase Workflow.
• Worked with SQL Loader for loading Item master.
• Created PL/SQL scripts to upload data from Flat file into Oracle Interface tables.
• Massive involvement in customization reports. Registered all the PL/SQL scripts and Reports as Concurrent Programs to enable users to schedule and run programs from Standard Report Submission.
• Design and development of customized Apps form.
• Exhaustive testing, creating and debugging for database packages, functions, procedures, triggers etc.

Confidential 

Technical consultant

• Design and implementation of reporting components (Forms 6i; PL/SQL; Reports 6i) for Oracle Applications modules and parts of the custom system.
• Created PL/SQL scripts to upload data from Flat file (trial balance data) into Oracle General Ledger Interface tables.
• Worked on custom module called Clearing Control System developed using Forms and Reports which is an interface between HINDALCO’S Clearing Reconciliation Systems and Oracle Financials GL system.
• Development of GL customization reports like Gross Profit Statement, Net Income Statement, Balance Sheet, Trial Balance, Fixed Asset Schedule, Sales & Operating Revenue and all other schedules annexed to the Balance Sheet and Profit & Loss Account statements.
• Registered all the PL/SQL scripts and Reports as Concurrent Programs to enable users to schedule and run programs from Standard Report Submission.
• Testing, creating and debugging for database packages, functions, procedures, triggers etc.

Confidential

Technical consultant

• Design, development and integration of customized forms and reports into Oracle Payables module using D2K. Reports were developed to view material receipt summary, material cost difference, Invoice Approval/ Unapproved Lists, Approved Bills, Tax details, payment related reports, various payment formats etc. Forms were developed to facilitate on-line edit of charge accounts in PO details, MRR adjustments, creating SubLedger etc.
• Enabled Descriptive Flexfield Segments to transfer additional invoice specific information to Oracle Payables.
• Involved in production support for Accounts Payable, responsibilities included job scheduling, payment processing, check printing and invoice posting. Involved in integrating Accounts Receivable System from a legacy system to Oracle Receivable through Oracle Customer Master Open Interface.
• Created PL/SQL scripts to upload data from Flat file into Oracle Receivable Interface tables.
• Generated Form executables and registered to Apps environment.