SUMMARY:

• Oracle EBS Process Re - engineering/ Confidential Solutions
• Techno-Functional specialist offering 10+ Years of information technology experience in delivering optimal business solutions and technology services on oracle enterprise platforms.
• Capabilities include Project implementation, design, development and deployment over Oracle E-Business Suite 11i/r12 extensions.
• OTBI/OBIA/FRS data modeling for EPM R2R & BI Catalog repository management.
• On-prem ERP to Oracle Confidential conversion.
• Expertise in PL/SQL APIs, Oracle EBS seed API’s, Fusion Security Console, Fusion FSM.
• Hands on experience in SQL, PL/SQL, Object Oriented programming, report building using Oracle XML/BI Publisher, Fusion OTBI, Fusion BIP.
• Experience in Data Loading/Conversions using HCM Data loader (HDL) and spreadsheet loaders for co-existence model.
• Expertise in securing applications using RBAC/MOAC/Entitlements platforms.
• Expertise in Supporting Multi-Org environments for Business Group, Legal Entities, Operating Units and Set of Books.
• Application customizations/enhancements following SOX practices and compliance.
• Extension/customization of standard and business specific workflow or approval processes.
• Knowledge and delivery of applications integration using Oracle Fusion Middleware SOA Suite and BPEL Process manager.
• Expertise in design, integration and implementation of custom processes into applications foundation and entities that are shared between multiple applications.
• Experience in business requirements gathering, GAP Analysis, Test Plan Preparation, Unit testing, Technical Architecture, System Integration testing, UAT/CRP.
• Handling business critical extensions to technical components and assessment of impact to product and process requirements.
• Develop and implement methodologies and procedures to ensure systems and applications are in compliance with industry standards.
• Extensive experience in business process re-engineering methodology including understanding & gathering business requirements, developing AS-IS & TO-BE business use cases, business test suites and defining road map for rollout & implementation of projects/products.
• Professional understanding of the Software Development Processes in line with Agile and waterfall methodology standards.
• Proven project & people management skills, proficient in managing widely-divergent, simultaneously occurring projects within agreed cost / time lines, by using strong organizational skills, out-of-the-box thinking, and innovative problem-solving abilities.

AREAS OF EXPERTISE:

• Database Design & Architecture
• Technology Solutions
• Testing & Process Improvement
• Reporting & Documentation
• Performance Tuning
• Financials Suite
• General Ledger
• Payables
• Receivables
• Purchasing
• Fixed Assets
• Cash Management
• Supply Chain Suite
• Inventory
• Order Management
• BOM
• Advanced Pricing
• OTBI
• BIP Datamodels
• BICS
• Fusion Extracts
• FBDI
• Financial Reporting Studio
• Functional Setup Manager

TECHNICAL SKILLS:

Hardware: IBM PC Compatibles, HP-UX

Operating Systems: Windows 95/98, Win NT/2000/XP/7/8, Unix, Linux

Languages: Sql, PL/SQL, HTML 4.0, XML, J2SE, Shell Scripting, BPEL

Databases: Oracle 8i/9i/10g

GUI: Developer 4i/6i( Forms & Reports), Discoverer 4/6i

Web Related: HTML, XML

Tools: & Utilities: SQL*PLUS, SQL*Loader, Quest Software, jDeveloper 11g, WinSCP, Putty

ERP Packages: Confidential, Oracle Applications 11i/r12(GL, AP, AR, PO, OM, INV, BOM, WIP, MRP/MPS, ASCP, POS),BES, Alerts, AOL, System Administration.

Applications: Remedy, Star Team, Kintana, Subversion, Clarity, Quest STAT, ControlM, Dimensions, Reporting Workbench

PROFESSIONAL EXPERIENCE:

Confidential

Lead Consultant

Responsibilities:

• Manage Reports and Analysis workspace Security.
• Security Console to Review and Analyze Roles.
• Extract Fusion data using BI Cloud Services for reporting needs.
• Designing Financials OTBI and BI publisher reports.
• BI Catalog management.

Confidential

Principal Consultant

Responsibilities:

• Extensively used BI Composer to define data models for Aging and P&L finance reports.
• Extensively used cloud webservices to integrate, transform, encrypt and transfer to webcontent server and on-premise server.
• Extensively used BICS/Cloud Integration Services to sync incremental/ delta changes only to on-premise EBS.
• Developed Cloud Financial reports using Financial Reporting Studio for Enterprise Performance management and scheduling using BI Answers catalog for R2R.
• Build custom reporting data models using BI Composer, dashboards, infolets and BI Publisher reports.
• Design and Develop common FTP mechanism to read/write/transfer files between servers both internal and external.
• Functional setup manager usage to configure the various offerings on Oracle fusion.
• Financials, SCM data conversion/migration using FBDI.
• Extensively used cloud webservices to integrate, transform, encrypt and transfer to webcontent server and on-premise server.
• Extensively used BICS/Cloud Integration Services to sync incremental/ delta changes only to on-premise EBS.
• Involved in creation of Custom Security for Oracle Confidential which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Oracle Fusion Access provisioning and Identity management with policy store.
• Oracle Identity Management (OIM) user interface to manage security policies, users, and identities.
• Developed xsd for custom HCM Extracts/OBI Reports for Global HR.
• Loaded data using HDL and spreadsheet loaders in a co-existence model.
• Involved in end-end UAT testing by drafting test cases/scripts.
• Used Oracle Fusion Functional Setup Manager (FSM) to implement offerings under HCM Cloud & Financials Cloud.
• Build integrations for ERP and SCM touch points utilizing all available integration services.
• Design and Develop common FTP mechanism to read/write/transfer files between servers both internal and external.
• Payables Invoice and Expenses workflow approval extension to route approvals based on various funds whose approvers are designed on rules based on AME.

Confidential

Techno Functional Lead Consultant

Responsibilities:

• Design and development of Oracle Payments and disbursements custom interface from Legacy systems on 11i and R12 systems.
• Designed new OAF page to display additional information of a project from custom table record.
• Supporting Metropolitan Atlanta Rapid Transit Authority Oracle 11.5.10 financials production environment.
• Designing new Financial Statement Generator reports according to business specifications.
• General ledger and Ledger Account analysis reports customization.
• Involved in pre-upgrade and iterative post-upgrade R12 analysis and resolving setup issues related to financials suite.
• Implementation and extension to iSupplier self service module.
• Financial General Ledger, Sub ledger accounting reports for reconciliation.
• BI Publisher reports.
• Investigated and resolved various production issues and performed data fixes, reversals & extractions.
• Log, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Analyzing business needs, conferring with users to improve procedures and identifying and solving potential problems.
• Report content development on reporting workbench platform for Financials, Supply Chain and Manufacturing.

Confidential

Technical Lead

Responsibilities:

• Involved in Tradesphere mini-project that checks for export compliance for all physical shipments from Confidential to global customers. The orders, shipment line items and partners are compliance verified at JP Morgan using streaming data maps that are transferred when the order workflow is initiated. The process involves several business rules to screen for ‘what items’ to ‘what customers’ in ‘which countries’ and generates license exceptions that helps Confidential process orders in accordance with the US export control norms.
• Implemented the Oracle AR receipts creation using bank receipts from a third party system.
• Designed and created DW transactions process that interfaces all pending and un-transferred transactions to GL interface when AR period close activity happens and triggers the %gl.period.close% business event.
• Designed and developed smtp e-mailer program that is used in sending notifications to multiple ‘To’ & ‘Cc’ as well as ‘Bcc’ as base UTF-8 encoded text. Utilized several oracle pl/sql database packages.
• Supported Partner Order Submission Tool (POST) that converts SPR & quotes to customer orders in oracle using BPEL and web services.
• Developed P2P Reports in Application Express such as Invoice Detail Report, PO Details and Payment Details Report.
• Modified the Contracts interface and tested during the up-gradation process which involves, service contracts creation, customer creation, item creation.
• Developed Invoice Report for Digital Signature in XML/BI Publisher.
• Involved in customization of reports for Account Receivables like Aging Balance for Customers, Debtors Ledger, Collection details and 7 Bucket Aging Reports as per user requirements.
• Created java concurrent programs for most custom interfaces by implementing java class calls.

Confidential

Project Lead

Responsibilities:

• Responsible for identifying business processes and architecting & implementing database applications to support high demand services.
• Identifying and addressing operational discrepancies through design and implementation of technical solutions.
• Handling project schedule, load balancing, prioritizing tasks & deliverable for critical software checkpoints and milestones.
• Coordinate with key stakeholders for seamless project deliverable and implementation.
• Developing project status reports and managing the team to resolve day-to-day issues.
• Reviewing software designs, code and documentation activities.
• Supporting as point of contact for the discrete manufacturing process customizations of Confidential Inc.
• Advanced Supply Chain Collections process integration from Legacy into APS Suite.
• Knowledge Transfer on several Inventory module custom reports and the Inventory Consigned Process.
• Modified the daily Price Purchase Variance report to allow the dynamic insertion of the Organization from the operating unit parameter.
• Design/Development/Extension of custom IQR interface that estimates and generates forecast of Item requirements based on the supply and demand.
• Designed/Developed the Min Max Analysis Report that calculates the past weekly usage of items per Organization/Sub-inventory, assisting the organization planners to replenish the Min Max thresholds.
• Customized and integrated the Business Rule Monitor workflow process of Oracle Service.
• Enhanced the existing escalation process workflow in oracle field service module.
• Creation of Purchase Requisition Report, Purchase Order Report, Work Order Reports and Quotation analysis Report as per User Requirements.
• Identified and resolved functionality loss in the Service Requests form in participation with Oracle Advanced

Confidential

Senior Technical Consultant

Responsibilities:

• Successfully led the full life cycle of product development including design, development, configuration and maintenance of application modules quick codes.
• Effectively handled integration and system testing, debugging and troubleshooting of wide variety of applications.
• Worked with multiple clients Pericom, Fujitsu, PWC, Falken for the offshore conversions and interfacing team.
• Coordinated and consulted the onsite team in applying the data conversion templates after identifying and mapping the legacy data to be converted into Oracle.
• Designed the code development strategy for converting the master data and then the transactional data followed by historical data.
• Converted the master data for oracle setup like - Item Master, Customer Master, Vendor Master, Customer Items, BOM, Routings, Installed Base etc.
• Created employees, assignments using seed HRMS API like hr employee api, hr assignment api.
• Converted the dynamic transactional data like - Open and closed sales orders, Open/Closed PO, Open AR, Open AP Invoices, BOM and Routings, GL Daily rates, Item Xrefs, QOH, Item Costs, Categories/Catalogs etc.
• Developed a fully automated and reciprocating interface to synchronize the Azerity CRM system that captures the Edi and standard sales orders with Oracle and correlatively updating the Azerity system with the orders created in oracle. The interface has an inbound from Azerity and outbound from Oracle with standard alert feature to report any import or extract errors. The interface also handles oracle updated orders based on GOP with the Audit History consolidator feature.
• Designed/Developed several custom interfaces.
• Enabled and utilized several Audit trail functionalities for core transactional changes in Order Management, Service Contracts and Installed Base.
• Technical writing and knowledge transfer.

Confidential

Technical Consultant

Responsibilities:

• Successfully implemented Auto Lock Box to constantly poll and integrate data files using BPEL applications adapter.
• Developed the code for the supplier interface that will be run as a interface multiple times a day.
• Designed and developed code for Oracle 11i to Catalog Tool Server for BPO as an outbound interface.
• Involved in development of Transport Instructions and shipment confirmation interfaces.
• Designed and developed i-proc to OPM PO creation interface.
• Designed and developed interface to mirror global sales orders captured at legacy pro-channel system with Oracle 11i.
• Converted Inventory dynamic and static data like- Item Master, Item Categories and Catalogs, Item Costs, On-hand Quantities, Stock Locators.
• Integrated non oracle system data to EBS and utilized Oracle AS Adapter for Oracle Applications concurrent programs to move data into base tables.
• Invocation of business process by configuring and deploying the DB Adaptor for applications for outbound interfaces.
• Genworth Unified Oracle Archival is a system that was proposed to create a separate database Instance for Genworth Financial from the global SSS Confidential database system. The Genworth UO Archival system was aimed at providing a composite EUL for Discoverer and BI based reports.
• Owned the Account Payables module from the source extraction stage until migration into the target system.
• Migrated and validated AP, i-procurement and custom module tables data into the UO Archival Staging and Production databases.
• Developed scripts to Identify Genworth related business data from the SSS system.
• Prepared the extraction logic and scripts based on the Genworth Org id from the base set-up and transactional Payables tables and other dependent module tables.
• Created and Registered concurrent programs for the extraction process.
• Prepared the Implementation Methodology CV-40 and MD-70 process documentation