SUMMARY:

• 13+ years of strong IT experience in Oracle e - Business Applications 11i/R12 Multi Org environment as a techno functional lead consultant involved in implementation, re-implementation, upgrade, support and rollout projects.
• Technical Expertise in SQL, PL/SQL coding, Reports, XML Publisher, BI Publisher, Forms Development, Form Personalization, SQL * Loader, Workflow Builder 2.6, EDI, Web ADI, Discover 10g, ADF, Unix Shell Scripting and TCA Architecture with excellent Trouble Shooting skills.
• Well versed experience in creating Procedures, APIs, Packages, Functions, Triggers views, collections (nested tables and arrays), Records, Sequences, Materialized views, Table, Indexes, Constraints and other database objects using SQL and PL/SQL.
• Led on Conversions / Interfaces of Manufacturing, Order Management, Price Lists, Financials, Procurement, Oracle Process Manufacturing and Quality (OPM), Enterprise Asset Management (eAM), Project Accounting, Project Billing, Project Costing, Project Management, Project Resource Management modules.
• Experienced with Oracle Alerts to send notifications to business users based on business conditions and Work Flow Builder to automate business process.
• Experienced with System Administration, Application Object Library modules for registering Concurrent Program, Users, Responsibilities, Forms, Functions, Tables, Key and Descriptive Flex Fields, Profile Values and Value Sets.
• Led/Worked on various Oracle Applications Implementation, Re-Implementation, upgrade, support and rollout projects which includes RICEW/CEMLI components development with R11i/R12i releases of EBS (Oracle E-Business Solutions).
• Competent with Supply Chain (OM, PO), Inventory (INV, BOM, WIP), Shipping and WMS (WSH), Finance (AP, AR, GL), Enterprise Asset Management (eAM), Oracle Process Manufacturing (OPM) Modules, Project Accounting, Project Billing, Project Costing, Project Management, Project Resource Management, and knowledge in OTL, HRMS and HCM modules.
• Strong knowledge to Cash (O2C) and Procure to Pay (P2P) cycles.
• Developed integrations with oracle using APIs.
• Conversant with performance tuning using EXPLAIN PLAN, SQL Trace, and TKPROF.
• Documented of various stages of the project and tasks using AIM methodology like MD-70s, CV-60s, MD-50s, TE-20s and MD-120 documents.
• Experienced to Prepare Query Feedback Forms, Unit Test Plans, and performing testing with Test logs and participated in Peer reviews, Technical reviews for deliveries with the client.
• Efficient in code migration from one instance to other instances with zero issues.
• Worked individually as well as in a team with excellent problem-solving skills, troubleshooting capabilities, learn new tools and concepts.
• Experienced in working with multiple parties (Technical, Functional, Business users, Client Managers, DBAs and other parties), coordinating with them and delivered project components.

TECHNICAL SKILLS:

ERP Application: Oracle e-Business (10.7,11.0.3,11i, R12.1.3)

ERP Modules: OM, INV, PO, BOM, WIP, AP, AR, GL, eAM, OPM, CRM, Alerts, Projects Accounting, Project Billing, and Project Costing, Project Management, and Project Resource Management.

ERP Business Flows: Order to Cash (O2C), Procure to Pay(P2P)

Methodologies: AIM(Oracle), GIEA(Cummins)

Languages: SQL, PL/SQL, Shell Scripting, Core Java

Database: Oracle 8i/9i/10g/11g

Operating Systems: Windows NT, Unix, Linux

Versioning Tools: VSS, SVN

Tools: /Utilities: Workflow Builder, SQL * Loader, Developer 2000, SQL * Plus, Putty, SQL Developer, PL SQL Developer, Reports 6i/10g, Forms 6i/10g, Forms Personalization, BI Publisher and XML Publisher, TKPROF and QTP

PROFESSIONAL EXPERIENCE:

Confidential, Bethlehem, PA

Techno Functional Architect

Responsibilities:

• Minimize job completion times, and done performance tuning for all important jobs like Sales Order Line Batching, ASN Inbound, Order Verification, WIP Mass Move and Row Rack Bin Assignment.
• Development of Performa Invoice and Packing List report.
• Enhancement to PO Scrutiny report
• Form Personalization for “Only specified users can select the EDO sub inventory in Release Sales Orders form’
• Form Personalization for “disabling quantity field, Back Order menu item in Transact Move Order Lines screen for specified users”.
• Tuned queries which extract shipping and booking details.
• Customized the Project Approval workflow using Oracle Work Flow Builder.
• Customized Project Accounting (Supplier Invoice Account) workflow using Oracle Workflow Builder.
• Analyzed the issue for no performer in Projects Accounting Status Report which in turn pointing to the PA REPORT WORKFLOW CLIENT package.
• Prepared all data templates for all conversion in all tracks (Finance, eAM, OPM
• Attended regular scheduled and unscheduled calls with onsite coordinator.
• Setting the objectives to the team and communicating well, making plans and ensuring the objectives are achieved.
• Planning, and organizing the team members’ activities and turning these into reality and ensuring these are going smoothly.
• Coordinated team efforts to ensure objectives are accomplishing smoothly
• Monitored the progress against the plans and controlling and took corrective action as and when required if something out of the track.
• Ensured for open communication among the team members so that team is
• Brought uniqueness, reusability in development across all conversions
• Responsible for all developed code is checked-in VSS configuration tool.
• Doing the Data migration activities of Core HR/Payroll through conversion scripts (like personal, assignment, job, position, grade, qualifications, phones, SIT's, initial balance, bank details, element entry, pay proposals)
• Helped team as and when required in development, testing, migration and in all phases.
• Reviewed conversion objects and making sure they are adhering to quality standards.
• Keep the project manager informed about the task accomplishment, issues, and status.
• Providing guidance to the team based on the management direction.
• Served as a focal point to other functional teams.
• Successfully completed Mock1, Mock2, SIT and UAT runs and migrated all code into production with zero issues.
• Communicating with business users, attended status meetings, loading important conversions and coordinating offshore team on data loading during SIT and UAT.
• Coordinating with .net application development team for their development activities, required to develop database and oracle e-Business objects.
• Post production support, performance issues, and bug/issue fixing.
• Worked on major performance issues in customer submission module which were holding for warranty support signoff.

Environment: Oracle 11g, Reports 10g, Forms 10g, XML Publisher, Linux and Oracle Applications 12i(12.1.3), AR, AP, INV, BOM, OM, OPM, OPM Quality, eAM (enterprise Asset Management), TCA Architecture, O2C and P2P Cycles, Project Accounting, Project Billing and Project Costing, Project Management and Resource Management.

Techno Functional Consultant

Responsibilities:

• Making DFF mandatory when defining Project Type, and user should not be modifying this if any project used this project type.
• Restricting copying specific orders using Processing Constraints extension in Order to Cash (O2C).
• Completed customer, BOM and Routings conversions.
• Code deployment for CEMLI and customizations with zero issue.
• Customized various reports in Project Accounting, Billing and Costing.
• Service Contracts issues are closed using Defaulting Rules in Order Management.
• Analyzed eb-tax customization with defaulting rules and form personalization in Order Management rather than applying triggers which works this customization ideal way, and the tax was calculated correctly for electronic shipments.
• Estimated of objects assigned them to team, monitored, tracked and delivered.
• Providing solutions for the team’s objects and pushing towards delivery.
• Task Monitoring in PULSE and updating team.
• Learned Defaulting Rules and Processing Constraints functionality in OM and apply them in customizations/issues.
• Interacted with business users and database administrators to identify business requirements.

Environment: Oracle 11g, Reports 10g, Forms 10g, XML Publisher, Linux and Oracle Applications 12i (12.1.3), ), Order To Cash(O2C) and Procure to Pay cycles (P2P), BOM, AR, AP, INV, PO, ONT, TCA Architecture, Alerts, Project Accounting, Project Billing and Project Costing, Project Management and Resource Management.

Techno Functional Consultant

Responsibilities:

• Analyzed report issue where commitment costs are not shown in Projects Summary Amounts.
• Analysis of requirements for Additional objects and estimation.
• Assigning work pockets among team, monitored, tracked status and delivered.
• Developed Tuned, tested (All various 11 scenarios) and Delivered DCAA - Prorating Time Cards in OTL and importing entries into Projects using PRC Import Transactions program, and personalized/customized the ADF page in OTL, with this the Project Costing is happened ideal way.
• Fixed issues in retrofitted service contract Views and Alerts.
• Customized various reports in Project Accounting, Billing and Costing.
• Queries are written to extract data during internal and external auditing.
• Vendors audit information view is retrofitted as per R12 TCA architecture.
• Working on multiple objects in multiple technologies whenever there is a technical bottleneck in deliverable of the project, worked and pushed them towards delivery, like DCAA, Supplier Audit Trail Worked on Alerts, Workflows, form personalization, Reports, and CRM Triggers.
• Printing CC# on Sales Order Form using form personalization.
• Sync up additional objects which are modified in R11 to R12 up gradation.
• Fixing post-production issues.
• Creation of new plans, jobs, position, grades, payrolls, interfaces, Rates, Benefit Structure, Premiums, Coverage, Eligibility, Plan Types, Options, Life Events, Literatures, Extracts, Quick Codes, Global Values, Rule creations and Rule enhancement (Fast Formulas) in HRMS.
• Development of new (finance and hr) reports using Reports 10g (Xml publisher, rdf Reports 10g).

Environment: Oracle 11g, Reports 10g, Forms 10g, XML Publisher, Linux and Oracle Applications 12i(12.1.3) Order To Cash(O2C) and Procure to Pay cycles (P2P), BOM, AR, AP, INV, PO, ONT, TCA Architecture, Alerts, Project Accounting, Project Billing and Project Costing, Project Management and Resource Management.

Techno Functional Consultant

Responsibilities:

• Involved/co-ordinate daily status call with client.
• Communicating, building trust relationship, Provided maximum visibility to the client.
• Streamlining the migration process, as per standards which are acceptable by OOD Admin, CGX QA team, and CCRB team.
• Prepared checklist for deliverables to improve quality.
• Provided deliverables for STAGE and PROD as per standards of OOD and CGX.
• Prepared configuration items in DEV and TEST using MS-TFS
• Assisting with OOD for migrations
• Enhancements done for Press XML/Card Rotation, Re-generation of press XML, WIP Mass Move, Pick Pack Slip, Scheduled Ship Date, and Order Import.
• Done form personalization for ‘Enter Quality Form’.
• The Sales Order batch processing jobs are optimized to 5 min from 8 hours.

Environment: Oracle 11g, Reports 10g, Forms 10g, XML Publisher, Linux and Oracle Applications 12i(12.1.3) Order To Cash(O2C) and Procure to Pay cycles (P2P),, BOM, AR, AP, INV, PO, ONT, TCA Architecture.

Techno Functional Consultant

Responsibilities:

• Involved in daily meetings internally and with client.
• Offshore coordination for migration of objects.
• Reviews of team developed objects for standards.
• Design, development, testing and delivery of custom objects.
• Importing Sourcing Rules and Sourcing Rule Assignments.
• Receiving Worksheet Report with MSCA Screen development.
• ‘Pick Release by Batch’ for the stores which are geographically batched.
• ‘No bin Assignment’ Report to show items which are not assigned to the pick phase sub-inventories.
• Item Barcode Printing form retrofitting
• EDI 850 and 86 0, modified the PO Approval Workflow using workflow builder and gathered all information from Payables and other modules into DFFs s of PO forms, and transmitting all required info into a file in required format by modifying the custom EDI package.
• Retrofitting 1103 packages, all packages ae retrofitting as per the R12.1.3

Environment: Oracle 11g, Reports 10, Forms 10, XML Publisher, Linux and Oracle Applications 12i (12.1.3, 10.7), TCA Architecture, Order To Cash(O2C) and Procure to Pay cycles (P2P),, BOM, AR, AP, INV, PO, ONT Confidential

Techno Functional Consultant

Responsibilities:

• Gathered requirements, Designed and Developed Claim Batch Approvals form for finance dept.
• Allowing uses to create move orders if customer BC code and Rev Account is same through form personalization.
• Make sure that all items are shipped to customer as per specified lots through form personalization.
• Users are allowed to modify D&L items prices in priced list which are specified in custom value set.
• Shipment of kit parts will be allowed if there is no difference between rollup cost of child parts with parent part’s sale assessable price and excise assessable price.
• Development of Performa Invoice and Packing List report.
• Enhancement to PO Scrutiny report
• Form Personalization for “Only specified users can select the EDO sub inventory in Release Sales Orders form’
• Form Personalization for “disabling quantity field, Back Order menu item in Transact Move Order Lines screen for specified users”.
• Tuned queries which extract shipping and booking details.
• Added last receipt date, EDO consumption of item to on hand quantity Report.
• Added hold flag on sales orders, free stock is calculated only for asset inventories to first fill report.
• Label Printing Report to consider picking quantity instead of shipped quantity.
• All tasks completed from analysis and design phase to delivery to production, which includes interacting with users, functional owners, managers, and DBAs.

Environment: Oracle 10g, Reports 6i, Forms 6i, Form Personalization, XML Publisher, BI Publisher, Unix and Oracle Applications 11i(11.5.10.2), TCA Architecture. Order To Cash(O2C) and Procure to Pay cycles (P2P), BOM, AR, AP, INV, PO, ONT ( Order Management).

Technical Consultant

Responsibilities:

• Warehouse to plant tracking customization.
• Blanket Agreements & Releases Conversion
• ASL, SR and SR Assignment Conversion
• BOM Routing Conversion
• Common Utilities (Purging Custom Table, Archiving inbound/outbound files)
• Mail program, sftp to IMS(Mainframe) and archiving in shell scripting
• Label Printing Form Development and Enhancement.
• Reasonable check of expense (Anixter) items received against usage report.
• Labor at current reactive in inventory report.
• Parent and Child cost discrepancies report.
• Self-testing is done with test logs and provided user manuals for developed objects.
• Prepared deliverables to move to production.
• All tasks completed from analysis and design phase to delivery to production, which includes interacting with users, functional owners, managers, and DBAs.

Environment: Oracle 10g, Reports 6i, and Oracle Applications 11i(11.5.10.2) PO, AP, INV, Order To Cash(O2C) and Procure to Pay cycles (P2P),, BOM,WIP, AR, AP, INV, ONT, TCA Architecture, Alerts, Chain Link, VSS, Clear Case.

Confidential

Technical Consultant

• Customizing and Development of various Reports for GL, AP, and PO modules.
• Involved in writing of PL/SQL Script to upload the supplier details from staging tables into base tables.
• Analyzing functional specifications, designing, and implementation of reports.
• Self-testing of developed objects, preparing test logs.
• Peer reviewing & providing suggestions to team member’s objects.
• Preparing deliverables and users manuals for the objects.

Environment: Oracle 9i, Reports 6i, SQL, PL/SQL and Oracle Applications 11i, TCA, GL, AP and PO modules, Order To Cash(O2C) and Procure to Pay cycles (P2P), BOM, INV, ONT.

Confidential

Technical Consultant

Responsibilities:

• Developed Cntrol files for Payables Open Interface to upload data from flat file through SQL * Loader to staging tables.
• Developed PL/SQL procedures to perform business validations for interface programs.
• Customized various reports as per the client requirements.
• Registered developed reports into Apps.
• Unit testing and prepared test logs for developed objects
• Peer reviewed team member’s objects, and provided suggestions as per standards.

Environment: Oracle 9i, Developer 2000, SQL, PL/SQL, SQL * LOADER and Oracle Apps 11i AP and PO modules

Confidential

Developer/Team Lead

Responsibilities:

• Interacting with financial department to gather requirements.
• Designed and developed Prepaid to Postpaid conversion reports, ad-hoc reports to the financial department and Management.
• Created tables using the Structured Query Language (SQL).
• Created Stored Procedures in PL/SQL to manipulate data.
• Using Forms 6i to develop data entry forms and menus that access reports.
• Upload data from xl sheets to Oracle tables using SQL * LOADER.

Environment: Oracle 8i, Developer 2000, SQL, PL/SQL, SQL * LOADER