SUMMARY
Is having over 9 years of experience in Design, Development, Conversion, Migration, Customization, Interfacing, Validation and Implementation of Business Applications using Oracle Applications (R12/R11i/11.0.x/10.7). Highly experienced as Subject Matter Expert,Project Management,Leader ship skills. Can work independently,within a team,good project planning and execution skills. Consistently able to deliver multiple concurrent projects on schedule and with in budget.
Proficiency in Oracle Applications R12/11i/10.7 (SCM,Manufacturing,INV, OM, GL, AP, AR, PO,P2P, O2C),SQL, PL/SQL, SQL*Loader, Developer 2000 (Forms 4.5/5.0/6i, and Reports 4.5/5.0/6i), Discoverer 3i/4i/9iAS/10g, Oracle 7x/8i/9i/10g and UNIX shell scripting. Complete exposure on the process flow of EDI 856,945,944 Good Knowledge on the Oracle Configurator Performed computer validation and qualification activities in support of the implementation of Oracle EBS. Includes authoring and review of validation/qualification documentation.Provided thorough documentation and review for the validation activities and deliverables of the regulated GxP modules of Oracle EBS R12 and SQL LIMS Integration.Strong experience in generating and executing Operational Qualifications,Performance Qualification Scripts. Very strong Skills in Oracle SQL, PL/SQL, Oracle Reports 6i and Oracle Forms 6i extensions using Forms personalization.Strong knowledge of business flows like Quote to Order, Order-to-Cash and Procure-to-Pay along with the dependencies and relationships between Oracle Applications modules.Worked extensively on Data Conversions in INV, OM, Purchasing, GL, Personalization, Alerts, Setups, Categories, Approval groups for iProcurement.Strong knowledge in Using Toad,Putty,PLSQL Developer,SQL Navigator. Hands on experience working with Order Management API, Pick Release and Shipping API.Expertise in development and customization of Oracle workflows in Order Management, Inventory and Purchasing.RMA, Drop ship and Internal sales orders.development/customization of Forms, Reports converting 6i Reports to XML Publisher reports. Well versed with Unix Shell Scripting and SQL* Loader.Expert level experience of Unix principles and concepts, including shell scripts.Performance Tuning for Complex SQL statements, along with the DBA team to improve the over all performance.Good at advanced PL/SQL topics like Collections and Bulk Binds. Involved in Application Integration Methodology (AIM- MD050/MD070).Good exposure working in 21CFR Part 11 and SOX environment.Experience in gathering Requirements, System Analysis, Design, Development, Testing, Implementation, Support, Documentation and Design Reviews.Good experience in developing Crystal reports for Adhoc requirements.Good experience of Business Intelligence reporting tools viz. Oracle Discoverer 3i/4i/10g.Good working knowledge in XML Publisher Reports.Strong experience in Using Metalink Service Requests and raising TAR to resolve issues. Good experience in Project Management Methodologies like MPP,PMBOK,VISIO.Strong experience in Project Planning, Resource Allocations, Task Assigning, Work Breakdown Structure.Strong experience in QA,Validation and all levels in Testing. Good Issue resolution, testing, debugging and Documentation skills. Possess excellent communication skills. Good team player. Ability to quickly earn credibility in Developer and Business Communities.Ability to develop within a well-structured environment following standards and procedures.Ability to write technical and business documents as well as produce and deliver oral presentations.Good relationship building skills with Team Members and Business Users.
Technical Skills:
ERP : Oracle Applications R12/11i (SCM,Manufacturing,INV, OM, GL, AP, AR,
PO,P2P, O2C)
Tools : Reports 6i, Forms 6i, Oracle Workflows, Oracle Discoverer 10g, SQL * Loader, XML,Autosys,
Logical Apps, BI(XML) Publisher
Databases: Oracle 10g,9i,8i.
Languages: SQL, PL/SQL, Shell Scripting, Core Java
O/S : Windows 2000, Windows NT, UNIX .
Environment : 21 CFR Part11,SOX
Proffessional Experience
Confidential,San Clamente,CA Aug 2009– Till Date
Environment: Oracle ERP Applications R11.5.10 (OM, INV, AR, AP, GL,Shipping,CRM,Oracle Transportation),Discoverer 10g, XML Publisher,Logical APPS)
Senior Oracle Techno Functional Consultant
Responsibilities:
Worked with Techincal Architect and Business Analysts to gather business requirements for UPS Integration . Participated in discussions to decide the scope of the project and the development of the business solution for UPS Domestic Integration. Designed and developed inbound/outbound interface programs for EDI 944( Receiving Transactions and RMA’s) and EDI 947 (Inventory Adjustments). Developed custom form for reprocessing the error data from EDI 944 and 945 Inbound from UPS. Modified the standard Regions ans Zones form to perform validations on assignment of the regions to Zones. Developed custom Business Events at Customer Site and Site Uses level to automatically populate the warehouse on the customer site level based on the region setup. Developed a mass update custom program to update the warehouse at Postal code, City,State and Country levels for UPS shipment. Modified the Standard Dependency Hook Package to enable the dependency between Ship From and Shipping Method. Created a Custom API to default the Ship Method based on the shipping organization on the sales order and performed the required Defaulting Rule Setups. Developed a custom program to extract Item Masters changes periodically. Created and successfully executed reports like Invoice Min Max Reports, in both reports 6i and XML Publisher for the applications Inventory,Shipping,OM applicable globally which resulted in implementing in Production and system avialable for business Users for Critical Care and inventory for regions Europe,NA. Worked closely with business users in gathering Functional Specifications to create Financial reports like GL Account Analysis customization, Daily Journal Book Entry Report, Invoice On Hold Report, Modified Standard Preliminary Payment Reports for PO Payments and checks. Worked on Invoice aging reports and customization in GL whch resulted in Users having the detail information on the Aging. Created custom XML Publisher reports Packing Slip,Pick Slip, Commercial Invoice reports which resulted in using the BARCODE generated reports for Shipping and Logistics departments. Developed Critical Discoverer reports for Sales reporting in GPO,regular sales and details in acquisition of products from Hospira in CRM.,WIP reports indicating the production status assigned for specific jobs. Created WIP component issue, BOM Tube segment detail reports in BOM and WIP modules for the users to have the complete details on the components issued for the Jobs. Developed Custom rules using Forms Personalization and Logical APPS. Developed Notification mailer reports using Logical APPS for generating certain notification in WIP related Jobs. Confidential,Novato,CA Jun 2009– Aug 2009
Environment: Oracle ERPApplications R12 (SCM,Manufacturing)
Senior Oracle Techno Functional Consultant
Responsibilities:
Created and successfully executed Operational Qualification, Performance Qualification and Installation Qualification scripts for R12 SCM and Manufacturing Modules which resulted in implementing in Production and system avialable for Users Worked closely with business users in gathering Functional Specifications and Software Configuration Specifications,User requirement Specifications,Genereated and Executed Test scripts for Oracle Manufacturing modules and SCM resulted standard approved documentation for the implementation of the modules. Done ‘AS IS’ and Gap analysis for QA team to find the gaps in the requirements and implementations which resulted in Trace Matrices for the Supply Chain requirements, LIMS-ERP Systems and General Requirements.Performed Computer Validation and Qualification activities and approved for the implementation of Oracle EBS.Provided thorough documentation,review,approval for the validation activities and deliverables of the regulated GxP(GMP) modules of Oracle EBS R12 and SQL LIMS Integration. Confidential,Chicago Jan 2007– May 2009
Environment: Oracle Applications R12/11.5.10(OM,BOM,INV,Shipping Execution,OTM,AdvancedPrcing,XML Publisher, PL/SQL)
Techno Functional Lead Consultant
Responsibilities:
Customized the Order entry form,Order Detail Report,Work Flows,drop-ship order process using EDI 850 inbound,customer specific pricelists,creating Order lines using Process Order API, which resulted in using the order form for businesss users as per the new requirements Developed the Customer Order Backlog Report in Discoverer,custom XML reports for WIP costs and Billing Costs,performed Forms Personalization to open Standard Discrete Jobs Form and Move Transactions Form from the custom Form for a selected WIP job resulted in providing the perfect solution for the business needs Involved in doing QA Test,Unit Test, Regression Testing,Test scripts generation and Validation on High end with the business users. Resopnsible for Resource Allocation, Project Management, Tracking Schedule, Staus reports resulted in implementing the project on time and within budget allocated. Done setups for auto shipping methods. Developed programs to automate shiping methods, Done setups in OTM for Regions and Zones for Shipping and Billing Methods. Done mapping for Regions and zones at Zip Code,City,State,Country Levels. Confidential,Boston Jul 2004– Dec 2006
Environment: Oracle Applications 11.5.10/11i(OM, INV,iProc,PO,GL,AP,Workflow 2.6,
Discoverer 3i/10g,Noetix Views, PL/SQL,TOAD)
Techno Functional Lead Consultant
Responsibilities :
Designed and developed custom program to load Orders into Order Management and send custom acknowledgement codes through Outbound from Order Management,understanding the hold process,created new workflow SubProcess for applying hold condtion,OM Automation Hold Release Program,business events to send notifications when schedule dates and promise dates are changed on order lines,custom API’s to change the move order lines after pick release,Packages to copy Orders across operating units using process order API resulted in succefully promoting the OM module into production. Designed and developed programs for conversion of Items from legacy systems to Oracle Inventory using Interface tables,Inventory API’s to create dynamic categories in Inventory,Done Data Validation comparing with the legacy systems resulted in business to manage inventory systems easily. Developed custom modification for the Journal entries to report to Financial Management, Analyzed the impact on the Account Generator Workflow as per the setups in OFA.Defined a wrapper program for Journal Import to Update attributes in Journal Lines,Standardized the DFF structure for invoices within AP,AR,GL and did the impact analysis,Wrote Test Cases for AP module and performed Regression testing which resulted in fixing the issues in Finance modules and implement in production.. Involved in developing and migration of reports from Discoverer 3.1 to 10g.developed business areas,complex/simple folders,item classes,import/export untilities to import work books,work sheets across instances.Tuned backend queries for Discoverer reports for better performance,developed new reports in discoverer plus with features like custom functions, parameters, complex conditions and calculations.Worked with the Noetix views to create different adhoc discoverer reports both in financial and manufacturing modules which helped business users in forecast and productivity of materials. Actively participated on the Conference Room Pilots, for system integration testing.Developed test documents TE 20’s covering exhaustive test cases for all the components.Was Higly Involved in UAT along with the business users to understand the complexity of the issues and give back to development team to fix and redeliver on time. Responsible for doing post Production Support for I-Procurement, (Custom Approval Workflows),MRP,Resolving support tickets on daily bases for iProcurement,MRP Custom Reports,Understanding the various business processes currently followed in Procure to Pay Cycle i.e. Requisitions (I-procurement).Setup in PO and I-Procurement: Define Approval Groups, Define Catalogs, Assign Approval Groups, and Define Master and Organization, Purchasing Options, Receiving Options, Buyers and Tax Codes. Developed ER diagrams using Visio for the project flow.Tracking Project scheduleusing MPP.Done Resource allocation, Status Reports resulted in ontime delivery and completion of the project Confidential,India Oct 2003- Jun 2004
Environment: Oracle Applications 11.5.9(OM,PO,GL,AP,INV,BOM, PL/SQL,Discoverer 9i,Reports 6i, TOAD)
Senior Technical Consultant
Responsibilities
Analyzed the client’s reporting needs and was involved in the design of functional specification,documents.Cancellation and creation of order lines using Process Order API.Developed the customer order backlog report.Developed PL/SQL procedures to load Price list Data (Qualifiers, Modifiers and Price Lists) resulted in providing the perfect solution for business needs and implementation. Designed and developed custom reports in AP,AR,Designed report to obtain the Net Book Value for assets within a specific Cost center and location.Customized the standard Preliminary Payment register report.Designed a custom report similar to the standard payment register report in AP, to provide the final check amount details for all the payment batches.Designed a custom report to show the customer details and his credit limits usage. This was used by the credit department to make several credit decisions which resulted in maintaing the correct financial transactions. Item Conversion using interface tables and Item Import.conversion of BOM Bill of Materials using Process BOM API.Developed custom Unavailable by Warehouse report to show the shortage of the inventory by warehouse.Developed conversion code in PL/SQL for Supplier Conversions, Item Conversions, Employees Contingent workers details, Employee termination/re-hire,mapping document CV60s for conversions such as Supplier Conversions, Item Conversions,Employee Conversions, etc.
Designed and developed Discoverer reports in Discoverer 9i across various modules. This involved creation of EULs and business areas to obtain workbooks,technical design documents and coordinated with the Onsite team,Developed XML reports for packing slip and shipment verification,Inventory onhand value custom report.Interact with the onsite functional team and understand the requirements resulted in having a true report solution in all the areas for auditing purposes. Confidential, Apr 2001 - Sep 2003
Environment: OracleApplications10.7(AP,AR,OM,OP,Forms6i,Reports6i,PL/SQL,UNIX,
TOAD)
Technical Consultant
Responsibilities :
Worked on the solution design based on the functional specifications and prepare the Technical.Design Document. designed complex reports as per the client business needs.custom report in Order management which shows the customer order details and item availability in inventory. Developed code to upload Billing events. Designed and developed complex forms with multiple canvases and multiple tabs using Forms 6i.Developed and customized reports using reports 6i.Involved in the Unit testing and integration testing along with the functional team and client. Post Go-Live support for the components after successful implementation.Developed Alerts for specific business requirements.Developed UNIX shell scripts to send auto mail notifications with attachments. Education:
Masters degree in Computer Applications.
Privacy Policy
