Manager Oracle

Location:

Posted:

August 02, 2018

Resume:

OVERVIEW

Highly accomplished Senior Oracle Cloud and EBS manager/Solutions Architect/Techno-Functional Lead with a proven track record of managing and delivering complex IT projects and exceeding expectations.

Over 15 years of extensive experience in the Information Technology industry as Oracle Cloud Application Manager, EBS Solution Architect, Techno-functional Lead and consultant.

Subject matter expert and thought leader possesing both technical and functional knowledge of complex procure to pay and fnancial systems.

Highly creative and innovative Oracle professional with advanced communication skills and abilities, who seeks and enjoy responsibility, a problem solver, experienced with multi-tasking and resolving complex problems. Enjoys working with people and interacts effectively at both technical and management levels. Strong strategic thinker and team builder.

Expertise in Business Requirement gathering, GAP Analysis, Application configuration, Prototype design and End user training. Extensive experience in business process flow development, and configuration of test instances, demonstration, unit and integration testing, documentation, end-user training, go-live and post-implementation support.

Extensive experience in developing and reviewing Business Process Architecture documents (BP30/40/80/90), Business Requirement Mapping documents (BR30/100), Build and Module Design Documents (MD50/70/120) using AIM Methodology standards.

Skilled in interacting with customers or Business partners to gather information and implement functional and technical aspects of analysis and design. Strong presentation and communication skills with the ability to communicate at different levels within the organization

Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.

Experienced with Change Management, Risk management and AMS processes, Defect management & Remedy ticketing system.

Strong Hands on Implementation and Support of ERP packages in different functional and technical areas of Oracle EBS.

Good knowledge in handling Oracle TAR/SR process/procedures.

Areas of Expertise

Oracle Fusion Functional in Financials, Order Management

Solutions Architect/Technical Lead/Techno-Functional Lead

Business Process Analysis/Redesign

Proposal writing, End User Training

Managing requirements related to Internal Audit, ITGC and DR

Management of Offshore and onshore resources of various skillsets

Designing and Implementing ERP Solutions including Interfaces, conversions, Reports,

Forms, Workflow and AME

Extensive hands-on experience in updating and rewriting existing custom processes

SKILL Synopsis

Applications

Oracle Fusion Financials, Oracle Fusion Order Management,Oracle Purchasing, Oracle iProcurement, Oracle Inventory, Oracle Accounts Payable, Oracle General Ledger, Oracle Accounts Receivable, Oracle Cash Management, Fixed Asset, Cost Accounting, Order Management, Work In Process, Bills of Material, Oracle CRM, Oracle HRMS, Service, Install Base, Oracle Projects, System Administration, Application Object Library, Oracle Self service, KOFAX, Markview, GTKonnect, Netwin

Version: R12/11i

Language

Oracle SQL, PL/SQL, XSL-FO, Java

Tools

Oracle Reports 6i/9i/10g, Oracle Forms 6i/9i/10g, Oracle JDeveloper (10g, 11g), OA Framework, Oracle Workflow, Oracle Discoverer 4i/10g, Oracle APEX, XML Publisher, AME, TOAD, SQL Navigator, JIRA, QuickBase, Testing tools (Test director, Mercury, Remedy), Migration tools (Kintana, STAT), Rational Portfolio Manager, Rational Clear Case, Rational Requisite Pro, Visual Source Safe/VSTS, PVCS, SharePoint, LoadRunner, Caosys, FileZilla, BOX, Ocean

Databases

Oracle 11g, 10g, 9i, 8i

OS/Platforms

Linux, AIX, Unix, Windows 2000/NT

Training/Certification:

Training and Certification of KOFAX Capture and Extraction for Markview

Internal training on Scrum Master; in process of obtaining CSM

Currently pursuing training on DEVOPS

Internal training on Project Management to prep for PMP

Oracle Training and Certification in OAF and ADF

Oracle certification in SQL

EXPERIENCE

Company: Halo Top Creamery

Role : Oracle Cloud/ERP Applications Manager

Duration: Aug’2017 – June’2018

Responsibilities

As Oracle Cloud Application Manager

Actively involved in Building Roadmaps, Budgeting, Planning, defining scope, priority setting, setting the timelines, assigning project resources, monitoring, promoting team development and managing multiple efforts concurrently.

Implement Oracle ERP Cloud for financials, Order Management, SOA/B2B, EDI and Oracle Sales Cloud.

Designed and Lead various Projects related to Oracle Cloud Implementations and enhancements.

Handled large-scale projects and interacted effectively with business and stakeholders to translate business requirements into IT deliverables. Demonstrated and projected strong interpersonal skills leading to effective team building and delivering projects on time and within budget.

Extensive experience with Change Management, Risk Management, Scrum releases.

Requirement analysis and Effort estimation for each gap and involved in preparation of development plan. Assigning GAPs/Incidents/CRs to Offshore and onsite technical team and tracking of the development.

Involved in Day-to-Day production support and month end Book Close assistance to the users.

Extensive experience in troubleshooting Oracle Fusion Order Management, Oracle Fusion Payables, and Oracle Fusion Receivables related issues.

Chair daily standup, weekly status update meetings with internal team and Vendors, participate in monthly steering committee meeting higher management.

Implement Cyber Security for the organization.

Environment : Oracle Fusion/Cloud Modules(Order Management, Payables, Receivables, General Ledger, User Management, Sales); Oracle EBS R12 Modules(PO, iProcurement, INV, AP, AR, GL, Cost Accounting, FA); OA Framework, Oracle Workflow, Forms/Reports customization, Forms Personalization, XML Publisher, Oracle Discoverer, Interface, Conversion, Flexfield, Concurrent Prog and other AOL objects. KOFAX/Markview, GTKonnect

Tools: Jdeveloper, TOAD, SQL Navigator, QuickBase, JIRA, LoadRunner, SharePoint, CrowdStrike, Box, Ocean, FileZilla, PUTTY

Company: Harbor Freight Tools

Role : Oracle ERP Manager/Techno-functional Lead

Duration: May’2013 – Aug’17

Responsibilities

As Oracle ERP Manager

Projected thought leadership, technical/functional expertise and was actively involved in Planning, defining scope, priority setting, setting the timelines, assigning project resources, monitoring, promoting team development and managing multiple efforts concurrently.

Manage all aspects of the application development life cycle, including systems analysis, design, development, deployment, maintenance and enhancements.

Designed and Lead various Projects related to Oracle E-Business Suite - Implementations, Conversions and Upgrade.

Projects included transitioning business units with various legacy systems to centralized Oracle ERP system

Lead the requirements gathering workshops to drive unique footprint for specific business need

Extensive experience with Change Management, Risk Management, Scrum releases

Involved in Day-to-Day production support and month end Book Close assistance to the users.

Worked with Open Interfaces and was involved with Application Programming Interfaces (API) related to Oracle Inventory, Payables, Receivables, Suppliers and GL.

Was the first point of contact for Production issues, R12 projects, development, customization, testing, debugging and support of Oracle applications.

Involved in development of PL/SQL stored procedures, functions, packages, XSL-FO templates and Oracle Reports with different output formats like PDF.

Addressed operational problems, concerns, and questions posed by business users.

Participated in systems integration between Oracle APPS, APTOS, WMS Manhattan, GTKonnect, KOFAX/Markview, STEP, PMA, Mainframe and few other third party Applications. Resolved various issues related to Oracle APPS and data flow between other legacy systems.

Managing and performing Inventory sync process during yearly Physical Inventory in Distribution Centers. Process Cycle Count to sync inventory between multiple systems.

Responsible for utilizing a formalized project management lifecycle - Interacting with users, requirement gathering, identifying functional and technical gaps, application design, functional/technical specifications, configuration, module setup, programming, scheduling, documentations, test script generation, training end users and production move.

Assisted the director on mission-critical software development and production support projects.

Production Support, Conversions, Upgrades, Implementation, System Administration, Change Control, Audits, ITGC, Disaster Recovery related to Oracle eBusiness Suite.

Demonstrated the ability to interact with all levels of management. Consult with business management to identify and prioritize opportunities (projects and enhancements) to enhance the use of applications in support of their business objectives.

Led the following Programs/Projects –

-Implementation of Oracle iProcurement to replace Legacy system

-Implementation of KOFAX and Markview

-AIX to Linux migration of R12 environment

-Redesign Organization Structures of the Company in R12

-GTKonnect Upgrade

-Implement Caosys for ITGC (IT General Controls)

-Support Manhattan WMS implementation with respect Oracle Financials

-Support and manage Disaster Recovery project with respect to Oracle ERP

-Resolve and Clean-up PO Receipts and In-transit Shipment stucks

-Yearly Physical Inventory Sync of Distribution Centers

Environment : Oracle Apps R12 Modules(PO, iProcurement, INV, AP, AR, GL, Cost Accounting, FA); OA Framework, Oracle Workflow, Forms/Reports customization, Forms Personalization, XML Publisher, Oracle Discoverer, Interface, Conversion, Flexfield, Concurrent Prog and other AOL objects. KOFAX/Markview, GTKonnect

Tools: Jdeveloper, TOAD, SQL Navigator, QuickBase, JIRA, LoadRunner, SharePoint.

Company: ESCO Corporation

Role : Techno Functional Lead/Oracle Application Developer

Duration: Apr 2011- Jan 2013

Responsibilities

Techo-functional lead for Procure to Pay and Inventory modules (PO, OM, INV, AP)

Prepared Business and functional requirement documents for all implementation and enhancement projects.

Requirement analysis by interacting with business along with cross functional team and Effort estimation for each gap.

Mapping the Client requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds, reengineering and form personalization.

Prepared BRD020, BP040, BP080, BR100, MD050 documents for each financial module.

Responsible for the Kintana migration the components form one instance to other instance also using the PVCS for version control.

Developed extensions for Supplier & Customer OAF pages on R12

Oracle Workflow extension for PO Approval, Requisition Approval and AP.

Developing Reports using XML Publisher, Report 6i/Oracle Discoverer/XSL-FO (PDF) in different Modules like PO, AP, AR.

Developed conversions for Open invoice (AR), Customer, (PO) Open Purchase Order, Supplier, and Approved Supplier List.

Forms customization and Personalization in PO/AP/Inv

Position Data conversion and customization of reports for Headcount /

Remuneration/Position Hierarchy reports in HRMS

Managed the upgrade to Oracle Framework over the Oracle Forms during R12

Upgrade from 11i.

Environment : Oracle Apps R12, 11i Modules(PO, AP, Inv, AR, HRMS); OA Framework, Oracle Workflow, Forms/Reports customization, Forms Personalization, XML Publisher, Oracle Discoverer, Interface, Conversion, Flexfield, Concurrent Prog and other AOL objects; tools: Jdeveloper, TOAD, Kintana, STAT, Mercury.

Company: IBM

Client: MTU Detroit Diesel Australia

Projects: NOVA Implementation & MTUDDA AMS

Role : Project Lead/Technical Team Lead

Duration: Aug2008- Mar 2011

Responsibilities

As Project Manager or Lead the responsibilities are

Works with key business functional partners, plans, configures and supports system implementations and business process integrations.

Develops project scope definition and implementation plans to maximize allocation of resources, ensure timeliness of delivery and optimize technology solutions.

Establishes and maintains standards for system and application configuration, documentation; develops and implements methodologies, policies and procedures to ensure system and applications are in compliance with company standards.

Leads manage and participate in Key organizational IT initiatives, such as business continuity planning, IT audits, Reviews.

Manage Change Requests and one point of contact for the Change Request team.

Coordinate with all consultants and Development team and update Offshore/GEO PM with CR status.

Provide Incidents/CR Status updates to the whole account team.

Quality review of code and Technical Spec; provide quality control over all development activities and deliverable products from IBM as defined in deliverables.

Involved in interaction with clients/GEO PM and co-ordination with the team.

Implemented certain process improvement initiatives like peer review process and

defect management.

Conducted internal training on Oracle Discoverer10g for the team members. Technical guidance to team members when required.

Assisting the GEO/Offshore PM in managing and updating the timesheet and

integrated project plan for IBM team

Technical issue management and tracking for the developments; track progress on systems development tasks of IBM team and report status and issues to GEO PM.

Streamline the resolution of issues by resolving as many issues as possible prior to

entering the escalation process.

Responsible for RPM management, Metrics Co-coordinator for the project &

Preparation of the weekly Dashboard project report.

Participates as key stakeholder in ERP implementation projects to develop requirements, design, build and support, on-time implementations.

Manages a fully integrated team to provide user support, on-going system maintenance (patching), and additional configurations that enhance business process changes and prevent system downtime.

Acts as a SME reviewer of other Oracle Apps Projects.

Development and Deliverables

Developing new OAF Pages and customization of seeded pages in CRM, Service.

Workflow extension in PO (PO Approval workflow).

Developing Reports using Report 6i/Oracle Discoverer/XSL-FO (PDF) in different

modules. Customization of reports in Cash Management (Cash Forecasting, Bank

Statement Reconciliation reports.).

Complex XML customizations of Purchase Order Print for Standard/Blanket PO

and Sales Order/Blanket Sales Order (BSA), and also for Sales Quotation using XSL-FO

Templates/Reports.

Forms customization and Personalization in PO/OM/Service/WIP/BOM.

Employee/Position Data conversion and customization of reports for Headcount /

Remuneration/Position Hierarchy reports in HRMS

Expertise in Drill Down and Link reports using Oracle Discoverer 10g in several

Modules like Finance and Service, WIP.

SQL Tuning and improving the performance of the source code.

Preparing Test Plans and Test cases (UTP) for unit testing.

SQL/PL/SQL package/procedures/functions; Interface; Conversion.

Knowledge of XML publisher report.

Environment : Oracle Apps R12, 11i Modules(CRM, Services, PO, AP, Inv, AR, CM, HRMS, WIP, BOM); OA Framework, Oracle Workflow, Forms/Reports customization, Forms Personalization, XSL-FO customization, Oracle Discoverer, Interface, Conversion, Flexfield, Concurrent Prog and other AOL objects; Tools: TOAD, Jdeveloper, RPM, MPP, Test Director, Remedy.

Company: DELL International Services

Role : Technical Team Lead

Duration: Example: Aug2005- Jun 2008

Responsibilities

Involved in requirement gathering and analysis of Clients requirements and effort

estimation.

Interacting with business and co-coordinating with Offshore-Onshore members.

Preparation of MD050, MD070, MD020 (Technical Design Document), Configuration doc, release plan, RTM (Requirement Traceability Matrix) docs.

Developing new OAF Pages and customization of seeded pages for Tele

Services (Service Request, Universal Work Console etc). Customization of apps

forms/screens using Forms Personalization & OAF Personalization.

Developing Interfaces, Concurrent programs, PL/SQL package, and procedures.

Developing notifications mechanism using UTL SMTP functionality.

SQL Tuning and improving the performance of the source code.

Preparing Test Plans and Test cases (UTP) for unit testing.

Maintaining Code review check lists and making review of developed codes.

Hosting Conference call and regular discussion on issues, risks and status with the

Offshore team and management.

Handling migration into different environment like Development --> SIT --> UAT -->

Production Using Kintana.

Environment : Oracle Apps 11i Modules(CRM, Services, Install Base); OA Framework, Oracle Workflow, Forms/Reports customization, Forms Personalization, Oracle Discoverer, Interface, Flexfield, Concurrent Prog and other AOL objects; Tools: TOAD, Jdeveloper, MPP, Kintana.

Company: iGATE Global Solutions

Role : Senior Software Development Engineer

Client/Project: METRO (Germeny)

Duration: Example: Aug2004- Aug 2005

Responsibilities

Analysis of Clients requirements and preparing system Design Document (HLD, LLD)

Developing of Forms and Reports as per client’s requirement.

Preparing Test Plans and Test cases (UTP) for unit Testing.

Maintaining Code review check lists and making review of developed codes.

Preparation of documentation for developing of Forms and Reports, database

functions/package/procedure/Triggers and PLLs as per the standard.

Delivering finished product, which includes required document, approved

design document, source code, Test Plan and its results for each maintenance request.

Worked on Oracle Apps forms and Reports customization.

Environment :Oracle Apps 11i(Forms, reports - PO), AOL Objects, Developer 2000(Forms6i, Reports 6i), Oracle Reports, Oracle SQL, PL/SQL; Tools: TOAD

Company: Score Information Technology

Role : Software Engineer

Duration: Mar2002- Mar2004

Responsibilities

Designing Table structures and constraints for Raw Material and Inventory sub

modules & Production Planning.

Creating tables and constraints for the project; creating database Triggers, database Functions, Procedures and Packages; creating Synonyms, Roles for users.

Designing and developing Forms and Reports for the modules.

Solely handled Purchase, Asset Management and Production Planning modules.

Participation in studying and understanding the system and processes at client end.

Making some complex reports including Matrix reports and character based reports.

Preparing Test Cases with Test data (UTP) for Unit Testing.

Maintaining Code review check lists and reviewing of codes.

Implementation at client end and user training to clients.

Training of D2k to a junior team.

Active participation in demonstration of the project to the clients.

Environment : Developer 2000(Forms6i, Reports 6i), Oracle Reports, Oracle SQL, PL/SQL; Tools: TOAD

Indrani Dey

West Hills, California 91304

E-mail:*********@*****.***

Cell: 503-***-****

Contact this candidate