Oracle Techno Functional

Hari Mallemala

Seattle, WA • *********.****@*****.*** • LinkedIn

Oracle Applications Implementation Architect

Innovative and strategic ERP Architect with over 18+ years of expertise in Oracle EBS R12/11i, Fusion Cloud, and Oracle Financials across global enterprises. Specialized in financial systems design, data engineering, integration, and reporting with a strong focus on Oracle SQL/PLSQL, BI tools (Power BI, Noetix, OTBI), and cloud data pipelines (Snowflake, Power Automate). Proven record in managing full-lifecycle ERP implementations, upgrades, and hybrid integrations (EBS–Fusion–SAP). Proven track record of driving large-scale ERP implementations, cross-functional collaboration, and post-merger transitions. Skilled in delivering reporting automation, bank integrations, compliance (SOX/GxP), and ERP-to-analytics pipelines using modern tools like Power BI, Snowflake, and Power Automate.

Areas of Expertise

Requirement Gathering Functional Gap Analysis Application Design Configuration Custom Solution Design

System Interface Architecture Oracle AIM Oracle OUM Project Management Production Support Test Script Generation Documentation Change Management Agile SOX Compliance Core Skills

• ERP Systems: Oracle Fusion Cloud, Oracle EBS R12, Workday (familiar with procurement and integration touchpoints).

• Business Domains: Procure to Pay (P2P), Order to Cash(O2C), Supplier Management, Payment Automation, Month-End Close, Financial Reporting, Bank Integrations, AP Automation, GL, AP, AR, FA, CM, PO, OM, Eb-Tax, SLA (EBS & Fusion), FCCS.

• Functional Expertise: Business Requirements Gathering, System Configuration, UAT, CRPs, Approval Workflows, P2P lifecycle, Invoice Automation, Reporting Dashboards.

• Cross-Functional Collaboration: Finance, Procurement, Technical Engineering Teams, Product Owners

• Oracle Technologies: Oracle SQL, PL/SQL, OAF, Workflow, Forms/Reports, XML Publisher

• Data Engineering & Reporting: Power BI, Noetix/Angles Hub, OTBI, FRS, SmartView, BI Publisher

• Integrations & Pipelines: Concur, Coupa, Snowflake, Workday, XML, ISO20022, Bank APIs, Bank Interfaces, Supplier Portals, Power Automate, FBDI, Web Services, GitHub, OCI

• Tools & Platforms: Toad, SQL Developer, ServiceNow, Jira, WinSCP, SharePoint

• Methodologies: SDLC, Agile, Oracle AIM/OUM, SOX, GxP, PCI Compliance Professional Experience

Pfizer (Acquired Seagen), Seattle, WA October 2020 – Present Senior Engineer, ERP & Finance Systems

Apr 2022 – Present

• Led Oracle Fusion Cloud Financials implementation across multiple BUs for Procure to Pay (P2P), post- merger with Pfizer.

• Conducted detailed requirement-gathering sessions with Finance, Procurement, and Compliance teams to ensure alignment with corporate finance processes and reporting standards.

• Configured modules including Fusion Payables, Procurement, Payments, and Cash Management— defining key setups like payment terms, approval hierarchies, payment formats, supplier validation rules, and tax defaults.

• Collaborated with global Finance, Procurement, Compliance, and Engineering teams to configure AP, Payments, CM, and PO modules aligned with corporate finance policies.

• Led implementation and tuning of Oracle Intelligent Document Recognition (IDR) to enhance invoice processing accuracy and reduce AP cycle time by over 30%.

• Integrated Fusion with third-party systems like Concur (T&E), Snowflake, and multiple banks (Bank of America, Citi, Credit Suisse, US Bank) for outbound payment files in XML/ISO20022 formats.

• Built and maintained OTBI dashboards and SmartView reports to support finance operations with dynamic visibility into invoice aging, liabilities, payment forecasts, and exceptions.

• Enabled SOX-compliant user provisioning and approval workflows using role-based security and segment-level data access controls in Fusion.

• Led functional testing, data migration, and reconciliation efforts for supplier master data, PO carry- forwards, AP invoice load, and open payment transactions.

• Designed and implemented auto-reconciliation and automated payment disbursement flows

• Collaborated with business and technical teams to configure new Oracle Fusion environments and support post-go-live stabilizations

• Conducted SOX and GxP validations for ERP and reporting tools (Noetix, Spotfire)

• Acted as primary point of contact for issue resolution, enhancement requests, and quarterly release regression testing—managing communications with Oracle support, business stakeholders, and technical teams.

• Trained business users globally on Fusion AP, Payment, and Supplier modules through virtual workshops and SOP documentation.

• Orchestrated data pipelines from Oracle EBS to SAP using Power Automate; ensured seamless archival of historical financial records.

• Managed requirement intake, sprint planning, and delivery tracking using Jira and ServiceNow. Sr. Business Systems Analyst & Reporting Developer Oct 2020 – Apr 2022

• Supported Oracle EBS R12.2.9 upgrade project for financials in a multi-ledger, multi-currency setup

• Collaborated with Workday downstream integrations for vendor master, procurement transactions, and financial data reconciliation during Fusion implementation.

• Delivered P2P enhancements in bi-weekly Agile sprints, working closely with product owners and finance leaders.

• Designed test cases and executed CRP/UAT across AR, AP, PO, and FA modules

• Spearheaded the integration of Barclays and Credit Suisse payment formats into Oracle EBS for EU operations

• Drove business enablement for month-end close processes, including 1099 form customization and financial reporting improvements

Hitachi Vantara, Seattle, WA March 2017 – October 2020 Manager, IT Services

2017 – 2020

• Oracle R12 rollouts and upgrades across global subsidiaries with strong P2P focus including PO, AP, Eb- Tax.

• Built and managed supplier approval workflows, requisition templates, and custom payment formats.

• Spearheaded ERP integrations with 3rd party systems (Concur, FX feeds, bank file transfers), optimizing vendor onboarding and invoice approvals.

• Partnered with BI and engineering teams to deliver self-service reporting on spend, invoice status, and month-end liabilities.

• Delivered XML-based document transformations and bank templates as part of integration pipelines.

• Designed, tested, and deployed ERP integrations and custom solutions across P2P, GL, FA, and reporting domains.

• Built scalable reporting infrastructure using Noetix and later migrated insights to Power BI.

• Ensured audit compliance through structured validations, reconciliations, and end-user documentation.

• Provided UAT and hypercare support for smooth financial close, reconciliation, and supplier payment cycles.

• Led global Oracle R12.2.4 implementation and enhancement projects for finance, procurement, and reporting functions.

• Managed cross-functional delivery teams, functional design, stakeholder engagement, and solution deployment.

• Spearheaded SOX-compliant ERP reporting strategy using Noetix and Power BI. Hitachi Consulting, India March 2012 – March 2017

Manager – Specialized Services, Consulting

2014 – 2017

• Worked with strategic clients to roll out custom ERP configurations and integrations.

• Focused on streamlining P2P cycles and improving audit readiness for global finance operations.

• Directed CRP, UAT, and post-go-live support for EU and US rollouts. Senior Consultant / Technology Lead – Oracle ERP

2012 – 2014

• Delivered key ERP modules for global Oracle implementations including GL, AP, FA, CE, PO, and Eb-Tax.

• Developed custom workflows, interfaces, and reporting objects tailored to client requirements.

• Mentored offshore developers and ensured delivery of high-quality technical components (RICEW). Infosys – India, UK February 2006 – March 2012

Technology Lead – Consulting

2009 – 2012

Clients: Emerson Climate Technologies (USA), Control Techniques (UK)

• Led ERP enhancements, upgrades, and support for Oracle EBS Financial and SCM modules across international subsidiaries.

• Managed client workshops, functional documentation, testing coordination, and production support for multi-entity rollouts.

• Delivered integrations between Oracle EBS and external systems for order processing, fixed assets, and AP/AR functions.

Technology Analyst – Consulting

2007 – 2009

Clients: Emerson Process Management (USA), ASCO Joucomatic Numatics (France), Emerson Joint Finance Implementation (India)

• Gathered requirements and configured Oracle Financials modules (GL, AP, FA, AR) for global shared services implementations.

• Led offshore teams for interface development and RICEW object delivery in compliance with global design standards.

• Facilitated localization efforts for finance processes in European and APAC regions. Developer / Technology Analyst

2006 – 2007

Client: Emerson Process Management (USA)

• Developed custom Oracle reports, interfaces, and forms for Order to Cash and Procure to Pay cycles.

• Participated in global template rollouts, working closely with onsite teams to support UAT, go-live, and hyper care activities.

• Created reusable code components and enhanced the performance of legacy customizations. RL Infotech Consultancy Services August 2004 – July 2005 Software Programmer

• Developed ERP customizations and database-driven solutions in Oracle PL/SQL and Forms. Education

Bachelor of Computer Science and Engineering

Certification and Training

• Oracle Application Development Framework 11g Certified Implementation Specialist

• Oracle Financials Cloud: General Ledger 2019 Implementation Essentials 1Z0-1054

• Oracle E-Business Suite R12.1 General Ledger Essentials 1Z0-516

• Oracle9i PL/SQL Developer Certified Associate (OCA)

• Oracle Cloud Infrastructure 2025 Certified AI Foundations Associate

• Oracle Fusion AI Agent Studio Foundations Associate - Rel 1

Contact this candidate