SUMMARY

• 11+ Years of overall experience in SCM (OM, INV), Finance (AR, GL, AP, PO, TCA) and HRMS modules of Oracle Applications 11i & r12 (Oracle EBS) as both Project Lead and Sr. Techno - functional consultant.
• Proficiency in handling overall cutover activities & global mapping logic changes.
• Proficient in all Phases of the Project from Requirements to Cutover Phases. C
• Prepared Project Plans, Migration Strategy documents and responsible for the offshore delivery.
• Tracking & handling large volume of files coming from different third party systems.
• Support the functional users during CRP1&2 testing phase & Liaison between onsite & offshore teams.
• Hands-on worked extensively in SQL, PL/SQL, Oracle Forms, Oracle Reports, Data Conversions, AOL, Oracle BI Tools (Discoverer) and XML Publisher (RTF & XSL layout), UNIX shell scripting, SOA Web services, WebADI & Oracle APEX 3x, 4x & 5x, TOAD, JIRA, WinSCP, SQL Developer, Control-M, SOAP UI, Oracle Workflow.
• Knowledge on PeopleSoft HRMS, Workday & HCM Cloud at intermediate level.
• Vast Experience in OBIEE/OBIA creating reports with various views Like Tables, Pivots, Charts, View Selectors, Narrative View, Prompts and Gauges etc
• Proficiency in technical troubleshooting and RCA root cause analysis in SCM, FIN & HRMS modules.
• Worked in Customisation of Oracle Processes and created customised Interface for Legacy systems and 3rd party application.
• Knowledge on workflow builder, workflow Packages and can resolve issues in workflow.
• Proficiency in Microsoft Office Suite: Word, Excel, PowerPoint, Visio & Projects.
• Well versed with both Order to Cash and Procure to Pay cycles & Employee/Payroll cycles.
• Experienced in leading team and responsible for offshore delivery.
• Experienced in building Center Of Excellence and internal trainings.
• Expertise in integrating 3rd party systems with Oracle E-Business Suite.
• Expertise in handling Electronic Data Interchange EDI & e-commerce gateways.
• Experienced in change management, Process improvement & Performance Tuning.
• Possess good understanding of SDLC and Software Quality Management System which also includes Oracle DBA & System/Network Administration skills.
• Possess people skills to work as a Project Lead, Team Player and manage an effective team; can exhibit better learning curve in adopting new skills and new tools
• Communication and Presentation Skills, Team player, Quick learner, Adapting to new roles are strengths. Flexible to work in any type of environment, can adapt to situations and eager to learn new Technologies.
• Ability to interact directly with client and/or end users to solicit information and define solution requirements with Proof of Concepts.

PROFESSIONAL EXPERIENCE

Confidential

Sr.Programmer Analyst

Responsibilities:

• Implemented Solution of PO for Email and Faxing capabilities for this client using XML Bursting
• Implemented Cash Management Module to reconcile AP and Payroll payments.
• Gathered all the requirements for the Implementation & documented as per standards.
• Created BR100, MD50, test Cases and MD70 for Cash Management implementation.
• End-2-End customization of Check Printing for Payroll process using XML Publisher.
• Customization of Third Party Check (Garnishment Check) using XML Publisher.
• Fixing AP Checks for MICR Alignment using XML Publisher.
• Involved in development of customizations of BI reports.
• Working extensively on OBIEE answers and dashboards to create the reports as per the client requirements.

Confidential

Sr. Lead/Project Manager

Responsibilities:

• Preparing Project Plan and responsible for the offshore delivery including CutOver activities.
• Review and delegation in getting signoff for Technical Specifications.
• Responsible for Unit Test, Mock Conversions, UAT support and Data Migration Rehearsals for CutOver to ensure smooth transition of Data Migration to Production CutOver and DryRuns before handing over to business.
• Extracted and customized the pre-built BI solutions of tables using Oracle BI Apps 7.9.6.3 / 7.9.5 (Financial Analytics)
• Designed, Developed and Tested Data Security and Dashboard Security in OBIEE.
• Involved in development of Conversions/Interfaces & Reports.
• Involved in mentoring team members to complete the CEMLIs.
• Responsible for code migrations and deployment of custom objects.

Confidential

Oracle Functional Analyst

Responsibilities:

• Responsible for Oracle support delivery for Confidential ’s Hotel Collect Business Process.
• Responsible for Support on Oracle Applications at Confidential ’s which is integrated to 3rd party tools like OMS, ATLANTIS, EDW, AP RECON & BOOKING Audit Tool BAT.
• Monitoring daily OTC critical tasks by creating and updating JIRA tickets (ORASUP).
• Well versed with Confidential OTC process and Orders flow from Upstream systems till Oracle base tables. Creating visibility to IT and business as and when required based on severity of the issues.
• Performing Root Cause Analysis and creating FSIT tickets if code bug is identified.
• Supporting the test cycles, Migration activities from DEV and QA to Production.
• Interacting with end user in case of issues in progressing with the transactions.
• Suggesting the Best solutions and Risks to implement the business solutions.
• Verifying the Control-M jobs on daily basis to see scheduled jobs run fine.
• Verifying the Inbound and Outbound file transfer jobs to BankOfAmerica.
• Worked on the usual BI concepts like drill down hierarchies, Action links in 11g, Delivers, Scheduler, GoURL, Pivots To develop the necessary star schemas in the RPD in OBIEE reports
• Log Service Request with Oracle and in case of issues related to Standard Programs and timely follow-up till closure.
• Performing UAT for any code changes/migrations. Handled issues related to WebADI on Customer Upload (TCA). Responsible for reconciling Hotel Collect orders between Oracle and Upstream systems (Atlantis)as a part of Monthly Pre-Invoicing Activities.
• Prepared KIDBs (Known Issue Database) for issues related to Direct Debit process.
• Prepared KIDBs (Known Issue Database) for issues related to Oracle-Atlantis Reconciliation.
• Provided cross-team (DEV & QA) support in sharing knowledge on Confidential HC, Direct Debit & Reconciliation processes.
• Work on issues related to Discoverer reports. Monitoring daily on Kyriba File transfers done through Control-M. Preparing Play By Play document on Direct Debit process.
• Preparing Play By Play document during Monthly Invoicing.
• Worked on monthly cleanup activities post-invoicing which involve updates in TCA & AR
• Performing UAT for r12.2.5 upgrade project. Daily monitor and take care of any Struck transactions in AR. Daily monitor Cyclotron and Transaction Bridge dashboards to check smooth transmission of Orders from Upstream systems to oracle.
• Responsible for the offshore delivery of support tickets in OTC track.

Confidential

Technology Lead

Responsibilities:

• Involved in the design and development of Date Migrations/Interfaces & Reports.
• Involved in TS design and reviews of Inventory Reports.
• Involved in development & implementation of Discoverer reports.
• BRD Analysis
• Impact Analysis on Oracle Order management system and Interfaces
• Responsible for offshore delivery.

Confidential

Technology Analyst

Responsibilities:

• Involved in development of Discoverer reports.
• Involved in mentoring juniors to get competency in Oracle Applications.
• Analysis of the Production bug
• Estimating the Development hours for the Bug.
• Unit testing and system testing after fixing the bug.
• Over all documentation before and after the bug fix.
• Supporting the test cycles
• Migration activities from dev to test and test to Production.
• Preparing UTR and UTC for the Fix.
• Verifying the Test scripts of the QA team.

Confidential

Technology Analyst

Responsibilities:

• Involved in development of Interfaces & Conversions.
• Involved in Technical Specification development and delivery.
• Involved in development of XML reports.
• Involved in mentoring juniors to get competency in Oracle Applications.
• Lead the technical team and responsible for delivery of implementation till CRP1.

Confidential

Technical Consultant & DBA

Responsibilities:

• Involved in Interfaces development
• Involved in the design and development of custom reports.
• Involved in the design and development of custom packages/program units.
• Worked as primary Technical resource for 1099 taxation process.
• Worked on many discoverer reports as a part of daily support process.
• Expertise in EDI process and Discoverer Reports.
• Developed an XML report in FA module which is a customization to Journal Entry Reserve Ledger report & worked on OPM Create/Adjust Immediate process for OnHand Quantities.
• Customized Daily ATP reports as per the business requirement.
• Developed shell script to purge old archived data periodically once in 2 weeks.
• Worked on APIs to update VAT codes and other customer information.
• Installation and maintenance of the GL Wand tool.
• Worked on budget upload interface to a tool which provides current month’s sales and next month’s forecast.
• Worked on customizing XSL template which is used in XML publisher reports
• Created a web based time keeping system for the offshore team in India using APEX.
• Preparation of Technical Documents, Unit Test Cases and Unit Testing

Confidential

Technical Consultant

Responsibilities:

• Training for 4months on Oracle Applications.
• Design and Development of PL/SQL Procedures, Functions and Packages
• Unit Test Case Preparation & Testing, Integration Testing.
• Development of Interfaces.
• Development of pl/sql program units for conversions.
• Preparation of Unit Test Cases and Unit Testing.
• Preparation of Technical Documentation.