Krishna Macherla

SUMMARY

• Over six years of total IT experience as a Functional Consultant in
Implementation, Support and Maintenance of Oracle ERP Financial
modules.
• Major work till now included performing Full Life cycle
Implementations, Roll Outs, Upgrades, GAP analysis, Production
Support, Testing, Migrating data from legacy system to Oracle
Financials.
• Expertise in Oracle General Ledger, Payables, Receivables, Fixed
Assets, Cash Management and imodules
• Experience in implementing and testing of Order-to-Cash (O2C),
Procure-to-Pay (P2P) business processes
• Proficient in integration of various Oracle Application modules,
Concepts of Multi Org, Multiple Reporting Currency, Financial
Statement Generator (FSG)
• Extensive experience in preparation and Review of BRDs, Gap
Documents, FDs, Test Strategy and Test Plan Documents.
• Well conversant with Oracle AIM (Application Implementation
Methodology) and prepared required documents at each stage of
implementation.
• Worked extensively on Global instance - Multi Org implementations
(11i).
• Created Financial Statements and ad-hoc reports using Financial
Statement Generator (FSG)
• Reconciled Sub-ledger modules with GL module
• Experience in Upgrade and Conversion/Migration of data from legacy
systems to Oracle Systems
• Worked with Oracle Support and go through the Service Request
process, and solve implementation/Support issues
• Involved in End User training, preparation of user manuals, user
guides and Desktop procedures for various projects
• Good Understanding of the Business Process across various business
domains
• Ability to work with Cross-functional teams including Users,
Financial Analyst, Business Analyst and Technical Consultants
• Excellent interpersonal, communication, presentation and problem-
solving skills

TECHNICAL PROFILE
Oracle Application: General Ledger, Accounts Receivables, Accounts
Payable, Purchasing, Fixed Assets, iExpense, Order Management, Cash
Management
Oracle Application Processes: Procure to Pay (P2P) Order to Cash
(O2C)
AIM: RD20, BP40, BP80, BR100, TE040
Language: Experience in SQL, PL/SQL.
Database: Oracle 9i, SQL Server 6.5, MS Access 2000

Education
Masters in Accounting (Kelley School of Business, Indiana
University)
Master of Business Administration

PROFESSIONAL EXPERIENCE

Blue Coat, Sunnyvale, California Jan 2008- Jun 2008
Functional Consultant (GL,AR,CM)

Project Description
Blue Coat secures Web communications and accelerates business
applications across the distributed enterprise. Blue Coat’s family of
appliances and client-based solutions – deployed in branch offices,
Internet gateways, end points, and data centers – provide intelligent
points of policy-based control enabling IT organizations to optimize
security and accelerate performance for all users and applications. My
role in current project includes study and implementation of Accounts
receivable, General ledger and Cash Management modules for Blue Coat
Systems Switzerland and part of Oracle Team involved in Global
Support.
Environment: Database: Oracle 9i, SQL, PL/SQL, Oracle Apps 11.5.10,
TOAD

Responsibilities:
Oracle Financials Implementation
• Study of the existing processes and development of To-Be Business
Processes and Solution Design based on the To-Be Processes and
Implementation.
• Co-ordinate with OM team to complete financial required setups for
completing the Order to Cash cycle (O2C).
• Implemented Accounts receivable, General Ledger, Cash Management for
the Blue coat Swizz entity
• Designed interim solution and prepared journal entries to do
Intercompany adjustments in General ledger
• Defined the revenue recognition set up for different order types.
• Customized revenue recognition process for POS (stocking orders).
• Created different transaction types, customers setup related to
impact of AR module and sources for Receivables
• Set up the Auto Accounting and Accounting rules for Swizz operating
unit
• Setup the custom lockbox process for creation of receipts
• Coordinated with business team and technical team and designed
custom auto invoice pre process to recognize revenue in proper period
and avoid creation of various accounting rules
• Defined statement cycles, customer statement reports and aging
reports
• Set up the Cash Management module to reconcile Payables and
Receivable with bank statements
• Reconciliation of Accounts receivable with general ledger by running
custom reports (Waterfall report).

Oracle Financials Testing and Support
• Involved in Design, Review & Testing of Customized Reports. Review
of Technical Design Documents for Reports and ensure that the
functionality was covered
• Performing application Setups in CRP and production instance, and QA
testing
• Preparation of project implementation documents such as Test
Scripts, Training Materials and Set up Documents, Functional
Specifications, solution proposals etc in line with AIM methodology
• Testing of end-to-end process flow of custom program, custom reports
etc
• Testing of custom process and documentation of the process flows
together with preparation of test cases required for testing
• Production support covering the end user issues and functional
issues after implementation
• Supported on Accounts Receivables issues and Custom process like POS
(Stocking Sale)
• Part of global period close team where in key activities include sub-
ledgers period closure and month end issues resolution. Reconciliation
of sub-ledgers with GL to identify and thereby reduce the data
integrity and wrong accounting issues
• Support of interface on a day to day basis and enhancement requests
to interface additional data like POS data into ORACLE
• Conducting End User training programs covering all financial modules
and custom processes

EGL, Houston, TX Sep 2006 –
Dec 2007
Functional Consultant (AP, GL, FA, Iexpense)

Project Description
Eagle Global Logistics is a leading provider of end-to-end supply
chain solutions demonstrating core competencies in domestic and
international freight transportation, integrated logistics management
and information technology. My role in current project involves
different assignments, part of roll out of ORACLE application for all
countries of operation and part of corporate ORACLE team involved in
upgrade and Global support. Study and analysis of current asset
management system accounting rules and process of depreciation and
asset capitalization.

Environment: Oracle Applications 11.5.10, Oracle database 9i, TOAD,
PL/SQL and part of R12
upgrade analysis team

Responsibilities:
Oracle Financials implementation
• Requirement gathering specific to the country of implementation and
communicating with corporate team for new requirements to be developed
• Implemented Fixed Asset security by book, defined asset categories
and conversion of data from old system using ADI
• Performed Accounts Payable (Procure to Pay), iexpense setups
• Study of client reporting structure and reporting requirements
configuration of primary reporting structure for the client
• Setup of expense reports approval limits and defined required
templates covering comprehensive requirements
• Co-ordinate with Purchasing team to complete financial required
setups for completing the Procure to Pay Cycle (P2P)
• Performing application Setups in CRP and production instance,
conversion of data from legacy system and QA testing
• Preparation of project implementation documents such as Test
Scripts, Training Materials and Set up Documents, Functional
Specifications, solution proposals etc in line with AIM methodology
• Interacted with end users, super users to gather requirements for
development of new reports and changes to any existing reports and
prepare MD-50 documents for new requirements

Oracle Financials Upgrade and Support
• Testing of standard features of ORACLE and custom features developed
for EGL specific operations
• Identification of process changes and preparation of impact analysis
documents for change in features from 11.5.8 to 11.5.10 and testing
modification of custom programs to meet the changes
• Studying the process impact and customizations impact benefit
analysis for upgrading to Oracle R12
• Supported issues pertaining to Asset Books, Asset additions and
Depreciation rules in Fixed Assets
• Testing of end-to-end process flow of custom program, custom
interfaces from legacy systems, custom reports etc
• Post upgrade support for global countries, part of level 1 support
providing support after for all countries go live date
• Production support covering the end user issues and functional
issues after implementation.
• Co-ordination with business team to identify custom reports required
with country specific requirements and testing of the reports
developed
• Part of global period close team where in key activities includes
sub-ledgers period closure and month end issues resolution.
• Reconciliation of sub-ledgers with GL to identify and solve the
issues related to data integrity and wrong accounting issues

Excel Electrocircuits, Orion, MI May 2005 to Jul
2006
Functional Consultant (GL,AP,FA)

Project Description
Excel, TS – 16949 certified, is the manufacturer of Printed Circuit
Boards. Providing the electronic industry with high quality, low cost
PCB’s free of defects, fast quick and on – time. This equates to
unparalleled value by exceeding the customer expectations in service,
quality, delivery and cost-effectiveness. They are in servicing wide
variety of industries, like automotive, aerospace, industrial,
commercial and military electronics

Environment: Database: Oracle 9i, SQL, PL/SQL, Oracle Apps 11.5.9,
TOAD

Responsibilities
• Conducted Business Process Review and GAP analysis to determine
business requirements
• Defined Chart of Accounts, Calendar, Currencies and Set of Books
• Setup cross validation rules, security rules, Financial Statement
Generator (FSG)
• Set up of Rollup Groups and Summary Accounts
• Designed multiple Financial Statements and ad-hoc reports for
accounting departments using Financial Statement Generator (FSG)
• Defined the Recurring journal allocation formulas for allocation of
various expenses across various business units
• Defined Mass Allocation Journals, Consolidation.
• Implemented Accounts Payable module
• Involved in doing the set up in test and production instance
• Documented and Tested the functionality using tests scripts
• Imparted training to the end users on Financial Modules as per the
Standard Operating Procedures of the Client
• Set up of Suppliers, Payment terms and discount policy for early
payment in Accounts Payables
• Resolved problems relating to the process of reconciliation between
the Payable and Receivable modules with the General Ledger
• Participated in the financial accounting Month-End and Year End
close process to ensure financial sub-ledgers, Accounts Payable (AP)
Fixed Assets (FA) close successfully
• Provided Post-Production support after go-live for GL and AP Modules

Rosendin Electric, Sunnyvale California Mar 2004 to May 2005
Functional Consultant (GL,AR)

Project Description:
Rosendin Electric is a leading electric company with over 1500
employees and revenue of $300 million, headquartered in San Jose, CA,
has branch offices in San Francisco, Sacramento and Los Angeles, CA,
Tempe, AZ, Albuquerque, NM, Hillsboro, OR, and most recently, Las
Vegas, NV. My role in this project is to do support for General Ledger
and Accounts Receivable modules.
.

Environment: Oracle Database 9i, SQL, PL/SQL, Oracle Apps 11.5.10

Responsibilities:
• Production Support for GL AR
• Integration issues on Order Management
• Resolution of functional & technical issues assigned to the Support
team.
• Extensions & Development activities related to Oracle Applications
11i suite
• Training users on the functionality of various Oracle 11i modules.
• Documentation related to Extensions and Development tasks taken up.
• Documentation of Business process of European operations with the
help of European Business analysts.
• Trained new hire and updated professionals for Oracle Financials,
AR, GL and User Support, Prepared lesson plans, created curriculums,
and provided counseling on one-to-one basis. Also provided training in
Oracle Application Development Tools (Toad, Oracle Forms/Reports
etc.).
• SOX & Internal Audit Compliance

Dubai Holdings LLC, Dubai, Middle East Nov 2002 to Dec
2003
Functional Consultant (GL,AP,AR,FA)

Project Description
Dubai Holdings LLC is a leading investment company in Dubai. It
manages and controls more than 20 companies which have diversified
business in real estate, hospitality, finance, healthcare, energy,
research, education, entertainment, media, internet, tourism and
biotechnology. Project scope encompasses upgrade from existing 11.0.3
version of Oracle Financials to Oracle E-Business Suite 11.5.9,
upgrade of custom components, development of around 50 new custom
components and implementation of new module Advanced Collections. As a
Functional Consultant, I was Involved in Implementation / Upgrade
Support & Integration testing across the Financial, Distribution
modules

Environment: Oracle Applications 11.5.9, Oracle Database 9i, SQL, PL/
SQL, Mercury test Director

Responsibilities
• Involved in implementation of modules including Accounts Payable,
Fixed Assets
• Configuration of the Set-ups in Test instance followed by Regression
testing
• Preparation of Functional Specification Documents
• Involved in Internal Project Management including design of business
processes, feasibility study’s, Funding and planning work scenarios.
• Preparation of Standard Operating Procedure Documents.
• Data Conversion which included transfer the opening balances of AP
from legacy systems to Oracle
• Testing the New Standard functionality offered by 11.5.10
• Testing the Interfaces, workflows and API’s.
• Extensively used Mercury test Director for testing and defect
handling

for more details contact

BALU

ASSENTIA SOFTWARE INC..,
balu_p@assentia.com
www.assentia.com
408-986-9808 EXT 204