SUMMARY:

• 12+ Years of experience in the IT industry as a Lead Level Techno functional Consultant involved in full cycle Implementation, Upgrade, Support and Maintenance projects Oracle Fusion HCM and Applications 11i, R12.
• We own the Ruby award(given by oracle) in 2017 for Fusion HCM implementation
• Worked in 4 Implementation Projects (Two 11i one R12 one Fusion HCM)
• Worked in 1 upgrade Projects (11i to R12)
• Worked in 5 Support and Development Projects (11i and R12)
• Worked 1 Fusion HCM implementation project
• Expertise in Data Migration & Integration - HCM Extracts, HDL & FBL.
• Expertise in OBIEE, BI Reports, OTBI & Fast Formulas
• Expertise in creating and customizing Roles and BPM Workflow.
• Expertise with SQL, Pl-Sql, XML, Reports, Forms (FRICEW).
• Raising Oracle SR's and working with them to resolve the product bugs and improvements.
• Upgraded from fusion release 11 to 12 to 13.
• Testing the product after each quarterly patch.
• Worked extensively in various modules (ERP/CRM) like Field Service (FS), Mobile Field Service (MFS), Install Base (IB), Service Contracts (OKS), Order Management (OM), Quoting, Inventory (INV), Receivables (AR), Purchasing (PO), I Expenses, Payables (AP), ASCP, Trading Community Architecture (TCA), General Ledger (GL), Oracle Alerts, CORE HR and, Oracle Learning Management (OLM)and AK Developer.
• Good technical knowledge in Application Object Library (AOL) like Registering/creating the concurrent executable, programs, request sets, responsibilities and value sets, Web ADI, EDI and FRICEW.
• Worked in P2P, Quote to cash and O2C and Service to Resolution and HRMS (SCM, Finance And CRM)
• Working knowledge on Forms Development, Form Personalization’s, Form Customizations CUSTOM.pll and OAF Page Personalization and Development
• Closely working with oracle support (SR’s) for standard issues resolution and participated in month end activities
• Having Very good experience to work with global teams, onsite/offshore model, Team Lead and onsite coordinator.
• Knowledge and experience on Ticketing Tool Team Track, TFS, Service Now, JIRA and HPSD.
• Documentation experience, keeping in line with the AIM and OUM Methodology implementation standard and System Development Life Cycle (SDLC).
• Prepared the Cut over plan for GO-Live and taken the responsibility to move all the CEMLI objects to PROD.
• Worked in Multilingual environment Developed reports and forms in Multilingual environment

TECHNOLOGIES:

Oracle Fusion(HCM): Oracle Fusion 11,12,13, Oracle Fusion(HCM), Core HR, Benefits, Absence, Compensation

Oracle Applications: Oracle Applications(EBS) 11i, R12.1.3, 12.2.3

Oracle EBS HR: Core HR, Benefits and OLM

Oracle ERP Financials: Account Payables(AP), Account Receivables (AR), General Ledger (GL),I-Expense, Trading Community Architecture (TCA)

Oracle ERP SCM: Order Management (OM), Purchasing (PO), Inventory (INV)

Oracle ERP CRM: Field Service(FS),Installed Base(IB), Service Contracts(OKS),Depot Repair, Mobile Field service (MFS)

Operating Systems: Windows (XP, 7), UNIX, Linux

Languages: SQL, PL SQL

RDBMS: Oracle 8i, 9i, 10G, 11G and 12C

Development Tools: Jdeveloper, Forms, Reports, XML Publisher, Discoverer, Work Flow Builder, OBIEE, Web ADI, EDI, APEX, TFS, PVCS, Putty, HPSD, Service Now etc

Data Base Tools: Toad, Sql Plus, Sql Developer, PL SQL Developer etc

Methodologies: AIM,OUM, Agile (Scrum)

Clients Worked For

PROFESSIONAL EXPERIENCE:

Confidential, Ann Arbor, MI

Techno Functional Consultant

Responsibilities:

• Involved in Data migration to fusion HCM.
• Developed the ADP payroll interface for Mexico, Canada, Chile and Costa Rica
• Implemented the Data masking for Human resource sensitive data
• Developed system extracts in Cloud HCM.
• Created and customized reports using XML /BI Publisher in PO, GL and HRMS modules
• Implemented Fusion HCM in 26 countries with more than 60 Legal Entities in 5 Languages.
• Configured of Core HR, Benefits and Absence using Fusion HCM
• Migrated data from EBS to Fusion HCM using HDL and FBL.
• Automated the data flow between ebs to fusion and fusion to ebs using HDL, HCM Extracts, BIP reports and web services
• Developed OTBI and BIP reports using new data models, E-Text template & RTF file formats for Core HR, Benefits & Talent modules.
• Customized oracle provided seeded reports.
• Tailored the fusion application by using page personification to change the look and feel.
• Customized and crated new roles to secure the data.
• Implemented benefits and developed the vendor interfaces.
• Involved in Taleo implementation.
• Payroll interface to ADP Workforce now, Stream Line and Single Data Hub (SDH)
• Built Extract interface between Fusion and Confidential internal applications.
• Developed various objects in EBS financials (RICEW).
• Raising Oracle SR's and working with them to resolve the product bugs and improvements.
• Upgraded from fusion release 11 to 12 to 13.
• Testing the Fusion HCM after each quarterly patch and make sure the integrity of application.
• Started EBS upgrade from12.1.3 to 12.2.5

Environment: : Oracle Apps R12 - OM, AP, AR, GL , Core HR, OAB, OLM modules and SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential, Columbus, OH

Techno Functional Consultant

Responsibilities:

• Attending daily stand up meetings and by weeks sprint planning meetings
• Enhanced the Quote to order process.
• Developed the custom shipping execution process
• Created and customized reports using XML /BI Publisher in AP,OM,AR,IB and Contracts modules
• Responsible to design various AIM document deliverable MD050, MD070, functional, and technical documents.
• Developed Custom invoicing process implemented custom solution to automate the web edi integration based on customer and ware house
• Implemented 856, 863 integration with business partners (B2B)
• Involved in performance improvement

Environment: : Oracle Apps R12 - OM, Quoting, Inv, AP, AR, GL , IB, OKC, modules and SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential, Paramus, NJ

Techno Functional Consultant

Responsibilities:

• Involved in 11g TO 12C database upgrade and modified the custom program to improve the performance
• Developed the supplier termination program, Invoice Import Program
• Created and customized reports using XML /BI Publisher in PO,AP,OM,AR
• Responsible to design various AIM document deliverable MD050, MD070, functional, and technical documents.
• Developed Supplier, Supplier site and Bank inbound interfaces
• Working in the Costa Rica and other country roll outs

Environment: : Oracle Apps R12 - i Expense, i Proc, PO, AP, AR, GL modules and SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential

Senior Techno functional Consultant

Responsibilities:

• Requirements Gathering, Data Migration, Extensive work on RICE components that include Reports (RDF and XML Publisher), Conversions, Interfaces, Customizations, Data Mapping, Technical Design, Code/Script Development, issues resolution, Performance Tuning, OAF Page Customization and personalization Documentation(AIM).
• Involved in data back up and purging to improve the stability and performance across the application
• Involved in GAP Analysis and fixing it.
• Lead the stand up meetings and actively involved in Sprint(agile) planning meetings
• Created and customized reports using XML/BI Publisher in AP, AR,AP and GL
• Converted RDF to xml reports
• Created PL/SQL and SQL*Loader scripts and External Tables as a part of conversion process to extract the legacy data from external applications and loaded them into Oracle Application tables.
• Developed and modified existing OBIEE reports.
• Developed the invoice interface using EDI
• Re-Implemented the custom programs as per changes in R12 to support the business logic
• Modified all the custom code with R12 changes
• Involved in debugging various interface related issues in OKC and Order Management.
• Responsible to design various AIM document deliverable MD050, MD070, functional, and technical documents.
• Working with Business users and Key super user for requirement gathering.

Environment: Oracle Apps R12 - OM, INV, AP, AR, GL modules and SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential

Technical Team Lead (Techno Functional Consultant)

Responsibilities:

• Leading the report remediation team (developed around 120 reports) of 10 members and working as a key developer in the team
• Working with Business users and Key super users onsite team and functional team for requirement gathering.
• A regular meeting with SME’s to get the requirements.
• Involving the Document preparation we are following OUM for documentation.
• Developed various reports using different tolls like RDF, RTF, data template and pl sql
• Developed and customized reports using XML /BI Publisher in OM, INV, AR, ASCP,PO and AP
• Developed the complex reports eg. Check Printing, Invoice report, Shipping Execution reports using XML publisher
• Developed multi tab excel report by using oracle plsql.
• Developed error correction forms in OM, INV and AR so that the end users can reprocess the errors directly through the form.
• Developed custom OAF forms and customized the standard pages using J developer.
• Developed reports in Discoverer like Vendor analysis and Product analysis report in PO.
• Worked on AP Invoice Inbound Interfaces.
• Developed custom interface program to import items from the legacy system to Oracle Inventory by creating staging tables.
• Customized all shipping reports, invoice, eft and vendor audit etc part of report remediation.
• Assigning tasks to the team.
• Supported business user and Super users in SIT and UAT.
• Planned the cutover activities and closely worked with DBA team for smooth go live
• Post production support handled in warranty period

Environment: Oracle Apps R12 - OM, INV, AP, AR, GL ,WIP, BOM, ASCP modules and SQL Developer, Oracle Reports, XML Publisher, SQL, PL/SQL.

Confidential

Senior programmer analyst

Responsibilities:

• Gathering requirements and preparing MD 50, MD 70.
• Involved in the identifying the business gaps and proposed the solutions to improve the performance.
• Developed a custom application using oracle APEX forms
• Developed the custom functionality by using FS, OM, IB and Service Contracts modules for rental business.
• Review of functional documents for technical feasibility.
• Re implemented the Check printing and Dunning Letters reports.
• Preparing technical designs as per AIM methodology and development of code, preparing Unit Test Scripts documents, issue resolution.
• Involved in France roll out and localization of finance and SCM modules
• Worked in multilingual environment.
• Developed reports and forms in multiple languages.
• Closely working with DB upgrade (10G to 11G)

Environment: : Oracle Apps R12 - FS, IB, Service Contracts, OM, INV, AP, AR, GL modules and SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential

Team lead

Responsibilities:

• Simulating and analyzing the reported Problem. This usually involves a code walkthrough of Interfaces, Forms & Reports and SQL Scripts.
• Supporting business users of Confidential Energy, for Oracle Field Services.
• Working closely with Sys-Admin & DBA teams for regular Outages, Data fix, Code fix, Scheduling of several scheduled requests.
• Developed reports using XML and BI Publisher on AP,INV,OKS,IB and OM
• Developed the GL interface for legacy payroll information.
• Developed the GL daily rates interface.
• Reviewing functional specification and get clarifications from onsite, Preparing technical specification, Coding and unit testing, preparing documents. UTP and installation instructions.
• Proposing solutions for the requirements and Involving in status calls.
• Added custom QA check for Service Contracts and Developed inbound and outbound interface in contracts for legacy system.
• Implemented 856,863 and 810 integrations with Trading Partners(B2B)
• Test the developed code as per the cases given in FDD and fixing bugs.
• Designed MD070, TE20 and developed the code to meet the client’s requirements MD120, for extracting the correct data to meet the client requirements.
• Worked extensively in XML/BI Publisher reports.
• Preparing Unit Test Plan and Installation Documents.
• Coordinating with 3rd party teams to assist in troubleshooting/issue identification.

Environment: Oracle Apps 11i - OM, INV, AP, AR, GL , FS, IB,OKS modules and SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential

Team lead

Responsibilities:

• Simulating and analyzing the reported Problem. This usually involves a code walkthrough of Interfaces, Forms & Reports and SQL Scripts.
• Developed the open interface for inventory items and installed based.
• Developed the customer inbound interface by using oracle open interface.
• Reviewing functional specification and get clarifications from onsite, Preparing technical specification, Coding and unit testing, preparing documents. UTP and installation instructions.
• Proposing solutions for the requirements and Involving in status calls.
• Developed error correction form for service request inbound and outbound interface errors.
• Registered Concurrent Programs and custom Applications using System Administration.
• Test the developed code as per the cases given in FDD and fixing bugs.
• Designed MD070, TE20 and developed the code to meet the client’s requirements MD120, for extracting the correct data to meet the client requirements.
• Preparing Unit Test Plan and Installation Documents.
• Supporting business users of Confidential Energy, for Oracle Field Services.

Environment: : Oracle Apps 11i - FS, IB, CRM foundation and Service Contracts modules and SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential

Responsibilities:

• Closely interacting with onsite team in deriving delivery dates of components and achieve the same deadlines.
• Customization reports and interfaces.
• Developed Custom Forms and Reports
• Worked with development of packages and procedures using PL/SQL.
• Understanding Functional Design and get the clarification, preparing technical design document based on AIM methodology standards.
• Reviewing functional specification and get clarifications from onsite, Preparing technical specification, Coding and unit testing, preparing documents. UTP and installation instructions.
• Proposing solutions for the requirements and Involving in status calls.
• Developed and customized interface between ASCP and ERP(OLTP)
• Registered Concurrent Programs and custom Applications using System Administration.
• Designed MD070, TE20 and developed the code to meet the client’s requirements MD120, for extracting the correct data to meet the client requirements.
• Developed the SR, Task, Debrief and contract conversions.
• Developed conversion for active Service Contracts and billing information.
• Developed conversion for open receivable invoices.
• Developed the Service Contracts inbound interface from clarify system.
• Personalized the Service request and Task Form to hide the unwanted fields
• Preparing Unit Test Plan and Installation Documents.
• Working closely with Oracle, Sys-Admin & DBA teams for regular Patch Applications, Outages
• Closely working with DB upgrade (9i to 10G)

Environment: : Oracle Apps 11i - FS, IB, CRM foundation, Service Contracts, OM, ASCP, AR and GL modules and SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.