Balaraj Anachal Rajamma
- Oracle Financials (FAH) Functional Lead
- McLean, VA
- Member Since Feb 13, 2023
Balaraj Anachal Rajamma
Career Synopsis
§ Seasoned Oracle Cloud, EBS R12 professional with several full-lifecycle, multi-million dollar implementation experiences over 18 years, including 3 years at Strategic Accounts division in Oracle Consulting.
§ Functional Consultant/Techno-Functional Consultant/Project Lead/Technical Consultant/Onsite-Offshore Coordinator for multiple Oracle Cloud/EBS implementation at PepsiCo, Panasonic, State Street, Marsh & McLennan, JC Penney, Michaels, Ionics, Arbonne International and many other clients.
§ Experience in EBS Implementation, Upgrades, Cloud Implementations and Support.
§ Proven success in influencing adaption to global standard processes; aligning process with technology, business goals with IT strategies; communicating effectively with people at different levels of hierarchy and expertise
§ Solution-focused, business-value-driven, self-motivated and quick-learning team player excellent at skills of requirements engineering, presentation, documentation, organization, interpersonal and time management
§ Experience in business flow accelerators, global blended delivery, project management, analysis, design, development, testing, and post go-live support.
§ Experience in process flows: Fusion Financials, FAH (Financial Accounting Hub), Oracle Revenue Management & Billing, Procure to Pay, Order to Cash, Advanced Pricing, iProcurement, Supply Chain Management, Logistics, Asset Management, Warehouse Management, Manufacturing & HRMS
§ Extensive on hand experience in Custom Interfaces, EDI and B2B solutions across modules.
§ Extensive on hand experience in development using Oracle Technologies including SQL, PL/SQL, Forms, Reports, Workflow ,BI Publisher, XML DB, XML Gateway, Oracle Express (APEX) , ADF, UNIX Scripting, OBIEE
§ Management of People, Processes and Performance to drive excellence; problem-solver and change-catalyst with exceptional skills in strategic action, implementation, scalability and sustainability
Skill Sets
Applications : Oracle E-Business Suite 11 / 11i / R12 / Cloud /Fusion
Modules : GL, AP, AR, FA, PA, Advanced Collections, HRMS, INV, BOM, OM, Advanced Pricing,
Purchasing, Warehouse Management, Shipping, Enterprise Asset Management, Purchasing,
Process Manufacturing, Cash Management, Bill Presentment, FAH - Oracle Fusion Financial
Accounting Hub, Oracle Revenue Management & Billing
Databases : Oracle 7/ 8i / 9i / 10g / 11g /12c
GUI : Oracle Forms 3.0/Developer 2000 /6i / 9i / 10g, J Developer, OAF, ADF
Languages : SQL, PL / SQL, Pro*C, UNIX Scripting
Tools : SQL Plus, Oracle Workflow, SQL Loader, TOAD, BI Publisher, XML DB, Oracle XML
Gateway, APEX(Oracle Express),Oracle Forms/Reports, Oracle e – Commerce
Gateway, OBIEE, Data Loader
Methodologies : Oracle Application Implementation Methodology, IBM Ascendant Oracle ERP Method
(RICEW)
Productivity : Excel, Word, Visio, PowerPoint, Microsoft Projects and Access
Awards
· Oracle Corporation - Bravo Award for best employee (2003 – 2004)
· Oracle Corporation - QOOL - Oracle Most Consistent performer Award (2004 – 2005)
Professional Experience
Oracle Financials (FAH) Functional Lead at Marsh & McLennan (Contractor) from June 2017 to Present
Marsh & McLennan Companies, Inc. is a global professional services firm, headquartered in New York City with businesses in insurance brokerage, risk management, reinsurance services and I am placed there as a contracting Oracle Financials Functional Lead for a Oracle FAH & RMB (Revenue Management & Billing) implementation project.
Responsibilities
· Requirement Gathering
· Leading CRP Sessions on Financial Accounting Hub (FAH)
· Financial Accounting Hub (FAH) implementation & support
· Oracle Revenue Management & Billing implementation
· Analyse and Resolve post production issues as per the SLAs
· AIM Documentation – BR100, TE40 & MD50
Accomplishments
· Designed interfaces to port data from Oracle RMB (Revenue Management Billing) to Oracle FAH
· Configuring Oracle RMB
§ Customer
· Defining Sub ledger Accounting setups using Accounting Method Builder :
§ Event Model, JLT’s, JED’s, Sources, Application Accounting Definition, Mapping Sets, Sub ledger Lookups based on Business Requirements
· Defining Complex Accounting rules via Account Derivation Rules
· Configured
§ Legal Entities, Ledgers, Value Sets, Data Access Set, Sequence, Journal Source, Journal Category, Currency, Rates and Ledger Sets
· Configured Complete COA Structure, Primary and Secondary and Statutory Ledgers, Legal Entities
· Supporting Revaluation, and Translations activities
· Supporting Period End activities
· Resolving Staging & Accounting errors
· Defined Request Set and Interfaced the data to oracle via FAH from Oracle RMB by scheduling Interface Jobs
· Interfacing setup data like mapping sets and currency rates using Data Loader
· Configured Complete Setups in Accounts Payables
· Configured Banks Accounts, LookUps, Aging Periods, Payment Methods, XML Publisher Format Template, Formats, Payment Documents, Payment process profile, Payment Systems & System security Options
Oracle EBS Consultant at State Street (Contractor) from April 2016 to Present
State Street is a leading American worldwide financial holding company and I am placed there as a contracting Oracle EBS Consultant.
Responsibilities
· Custom Billing Application implementation & Integration with Oracle Receivables.
· Transforming business and stakeholder needs into practical requirements
· AIM Documentation - MD50 & MD70
Accomplishments
· Successful Implementation of a Custom Application (Fund Connect Billing & Institutional Billing) in Oracle R12 to process data from State Street online trading portals.
· Interface Data from global on line trading Portals to Oracle EBS
· Forms & BI Publisher reports to review interfaced data
· Processes to apply cash & calculate revenue
· Interface pricing data from external system to EBS
· Generate Invoices & Statements for customers
· Create Invoices & Cash Receipts in Oracle Receivables and apply cash and post to GL
· AIM Documentation - MD50
ABeam Consulting from April 2007 to 2016
ABeam Consulting is the leading Japanese consulting firm with world HQ in Tokyo and US division out of Irving, Texas.
Responsibilities
· Project Manager
· Functional consultant
· Technical Consultant
· Oracle R12 / Could Implementation
· Transforming business and stakeholder needs into practical requirements
· 11i to R12 upgrade
· AIM Documentation - BR100,MD50, MD70 & MD120,CV40,CV60
Accomplishments
· Participated in implementation of Oracle 11i GL, AR & Advanced Collection modules for Canada and US at PepsiCo
· Successful Implementation of Oracle R12 GL,AP,FA & PA modules for Canada and US at PepsiCo
· Participated in implementation of Fusion Financials.
· Configuration of GL & AR modules including Cart of Accounts in R12 & Fusion
· Sub ledger Accounting setups using :
§ Mapping Sets , Event Model, JLT’s, JED’s, Sources, Application Accounting Definition, Sub ledger Lookups based on Business Requirements
· Upgrade from Oracle 11i to R12 (GL, AR & Advanced Collection) at PepsiCo
· Configuring Payment Methods, XML Publisher Format Template, Formats, Payment Documents, Payment process profile
· Developing & Modifying OTBI reports in Oracle Fusion.
· Customer & Supplier Data interface using FBDI (File Based Data Import) in Fusion
· Participated in Upgrade of EBS to Could infrastructure.
· Implemented a fully automated custom solution for generating, distributing & archiving statements for PepsiCo’s 50000+ customers
· Provided solution to capture and maintain PepsiCo’s customers with complex hierarchical structure which can have up to 5 levels of parent child relationship between those 50000 + customer accounts
· Led a team to successful upgrade from 11i to R12 for Panasonic Electrical Works America
· Designed and implemented a fully automated B2B process to interact with Panasonic’s trading partner (Kintetsu World Express) to interface PO, Receipts, Shipping Requests & Advices between them using XML Gateway
· Successful integration of Oracle R12 with a 3rd party software - IBM AR Collect a workflow driven collection tool as part of PepsiCo’s global rollout
· Worked on setting up and interfacing Price Lists, Modifiers, Qualifiers, Formulas and Pricing Attributes
· Designed a custom solution to eliminate the financial overheads & risks involved in PepsiCo drivers collecting money on delivery at stores which helped PepsiCo to save millions of dollars
· Implemented automated scheduling process to run nightly batch
· Defining Process Manufacturing Organizations, Item & Formula conversion from legacy system
· Provided a solution to interface 1 Million lines of AR invoice lines worth 45 Million dollars with excellent performance on a daily basis which is highly critical for PepsiCo’s cash flow.
· Designed and developed Inbound and Outbound EDI – 810, 812, 850,860 using Oracle Edi Gateway
· Designed and developed a custom solution to generate Late Fee’s for overdue AR transactions which allows PepsiCo to generate revenue worth couple of millions of dollars annually. Where the late fee can be calculated & posted at Top Account or Child Account level.
Top Clients
· PepsiCo – Pepsi Bottling Company
· Panasonic Electrical Works America
IBM (Contractor) from June 2006 to April 2007
Employed to System Guru and was placed as a contractor for IBM Global.
Responsibilities
· Techno – Functional consultant
· Oracle R12 Implementation
· Business Process Re-engineering
· RICEW documentation
· Post Production Support
Accomplishments
· Successful Implementation of Oracle R11i
o Designed and implemented a THROTTLE process where deliveries of new Orders will be grouped together with back orders for the same customers. So that Arbonne will be saving millions of dollars every year.
o Implementation of interfaces for Item, Item On Hand, Customers, Sales Orders, Delivery, Picking & Shipping from other system to Oracle R12
o Design & development of a custom solution for reporting & handing of daily interface error’s
Top Clients
· Arbonne International – Irvine, CA
Oracle Consulting from June 2003 to June 2006
OC’s Strategic Account division caters to the topmost clients of Oracle Corporation.
Responsibilities
· On Site – Off Shore Coordinator
· Techno – Functional consultant
· Senior Technical Consultant
· Associate Technical Consultant
· Oracle R12/11i Implementation
· Business Process Re-engineering
· AIM documentation – BR100, MD50, MD70, MD120, CV40, CV60, CV70
· Post Production Support
Accomplishments
Top Clients
· JCPenny Salt Lake City, UT
· Michaels Stores Irving, TX
· ACCO Brands Chicago, IL
· McCarthy Construction St. Louis, MO
· Buzzi – Unicem Bethlehem, PA
· Ionics Boston, MA
· UT Star Alameda, CA
· 1800Flowers Carle Place, NY
Mascon Global Limited from Mar 1998 to June 2003
Mascon Global Limited (MGL) is a global provider of IT and ITES services with offices and software development centres across USA, Mexico, Europe, and Asia
Responsibilities
· Technical Consultant
· Oracle 11i Implementation
· Business Process Re-engineering
· AIM documentation – BR100, MD50, MD70, MD120, CV40, CV60, CV70
· Post Production Support
Accomplishments
Top Clients
· Grupo Industrial Saltillo, Mexico
· Telefonica Movie Star, Mexico
· PSEG India, Chennai, India
· L&T (Larson & Toubro), Chennai, India
· Wockhardt Pharmaceuticals, Mumbai, India
· Bharath Electronics Limited, Bangalore, India
Education
§ Masters in Computer Science, Technical University, Sofia, Bulgaria
§ Bachelors in Mathematics, MG University, Kerala, India