Krishna Macherla
SUMMARY
=95 Over six years of total IT experience as a Functional Consultant in
Implementation, Sup****t and Maintenance of Oracle ERP Financial
modules.
=95 Major work till now included performing Full Life cycle
Implementations, Roll Outs, Upgrades, GAP analysis, Production
Sup****t, Testing, Migrating data from legacy system to Oracle
Financials.
=95 Expertise in Oracle General Ledger, Payables, Receivables, Fixed
Assets, Cash Management and imodules
=95 Experience in implementing and testing of Order-to-Cash (O2C),
Procure-to-Pay (P2P) business processes
=95 Proficient in integration of various Oracle Application modules,
Concepts of Multi Org, Multiple Re****ting Currency, Financial
Statement Generator (FSG)
=95 Extensive experience in preparation and Review of BRDs, Gap
Do***ents, FDs, Test Strategy and Test Plan Do***ents.
=95 Well conversant with Oracle AIM (Application Implementation
Methodology) and prepared required do***ents at each stage of
implementation.
=95 Worked extensively on Global instance - Multi Org implementations
(11i).
=95 Created Financial Statements and ad-hoc re****ts using Financial
Statement Generator (FSG)
=95 Reconciled Sub-ledger modules with GL module
=95 Experience in Upgrade and Conversion/Migration of data from legacy
systems to Oracle Systems
=95 Worked with Oracle Sup****t and go through the Service Request
process, and solve implementation/Sup****t issues
=95 Involved in End User training, preparation of user manuals, user
guides and Desktop procedures for various projects
=95 Good Understanding of the Business Process across various business
domains
=95 Ability to work with Cross-functional teams including Users,
Financial Analyst, Business Analyst and Technical Consultants
=95 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=92s family of
appliances and client-based solutions =96 deployed in branch offices,
Internet gateways, end points, and data centers =96 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
Sup****t.
Environment: Database: Oracle 9i, SQL, PL/SQL, Oracle Apps 11.5.10,
TOAD
Responsibilities:
Oracle Financials Implementation
=95 Study of the existing processes and development of To-Be Business
Processes and Solution Design based on the To-Be Processes and
Implementation.
=95 Co-ordinate with OM team to complete financial required setups for
completing the Order to Cash cycle (O2C).
=95 Implemented Accounts receivable, General Ledger, Cash Management for
the Blue coat Swizz entity
=95 Designed interim solution and prepared journal entries to do
Intercompany adjustments in General ledger
=95 Defined the revenue recognition set up for different order types.
=95 Customized revenue recognition process for POS (stocking orders).
=95 Created different transaction types, customers setup related to
impact of AR module and sources for Receivables
=95 Set up the Auto Accounting and Accounting rules for Swizz operating
unit
=95 Setup the custom lockbox process for creation of receipts
=95 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
=95 Defined statement cycles, customer statement re****ts and aging
re****ts
=95 Set up the Cash Management module to reconcile Payables and
Receivable with bank statements
=95 Reconciliation of Accounts receivable with general ledger by running
custom re****ts (Waterfall re****t).
Oracle Financials Testing and Sup****t
=95 Involved in Design, Review & Testing of Customized Re****ts. Review
of Technical Design Do***ents for Re****ts and ensure that the
functionality was covered
=95 Performing application Setups in CRP and production instance, and QA
testing
=95 Preparation of project implementation do***ents such as Test
Scripts, Training Materials and Set up Do***ents, Functional
Specifications, solution proposals etc in line with AIM methodology
=95 Testing of end-to-end process flow of custom program, custom re****ts
etc
=95 Testing of custom process and do***entation of the process flows
together with preparation of test cases required for testing
=95 Production sup****t covering the end user issues and functional
issues after implementation
=95 Sup****ted on Accounts Receivables issues and Custom process like POS
(Stocking Sale)
=95 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
=95 Sup****t of interface on a day to day basis and enhancement requests
to interface additional data like POS data into ORACLE
=95 Conducting End User training programs covering all financial modules
and custom processes
EGL, Houston, TX Sep 2006 =96
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 trans****tation, 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 cor****ate ORACLE team involved in
upgrade and Global sup****t. 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
=95 Requirement gathering specific to the country of implementation and
communicating with cor****ate team for new requirements to be developed
=95 Implemented Fixed Asset security by book, defined asset categories
and conversion of data from old system using ADI
=95 Performed Accounts Payable (Procure to Pay), iexpense setups
=95 Study of client re****ting structure and re****ting requirements
configuration of primary re****ting structure for the client
=95 Setup of expense re****ts approval limits and defined required
templates covering comprehensive requirements
=95 Co-ordinate with Purchasing team to complete financial required
setups for completing the Procure to Pay Cycle (P2P)
=95 Performing application Setups in CRP and production instance,
conversion of data from legacy system and QA testing
=95 Preparation of project implementation do***ents such as Test
Scripts, Training Materials and Set up Do***ents, Functional
Specifications, solution proposals etc in line with AIM methodology
=95 Interacted with end users, super users to gather requirements for
development of new re****ts and changes to any existing re****ts and
prepare MD-50 do***ents for new requirements
Oracle Financials Upgrade and Sup****t
=95 Testing of standard features of ORACLE and custom features developed
for EGL specific operations
=95 Identification of process changes and preparation of impact analysis
do***ents for change in features from 11.5.8 to 11.5.10 and testing
modification of custom programs to meet the changes
=95 Studying the process impact and customizations impact benefit
analysis for upgrading to Oracle R12
=95 Sup****ted issues pertaining to Asset Books, Asset additions and
Depreciation rules in Fixed Assets
=95 Testing of end-to-end process flow of custom program, custom
interfaces from legacy systems, custom re****ts etc
=95 Post upgrade sup****t for global countries, part of level 1 sup****t
providing sup****t after for all countries go live date
=95 Production sup****t covering the end user issues and functional
issues after implementation.
=95 Co-ordination with business team to identify custom re****ts required
with country specific requirements and testing of the re****ts
developed
=95 Part of global period close team where in key activities includes
sub-ledgers period closure and month end issues resolution.
=95 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 =96 16949 certified, is the manufacturer of Printed Circuit
Boards. Providing the electronic industry with high quality, low cost
PCB=92s free of defects, fast quick and on =96 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
=95 Conducted Business Process Review and GAP analysis to determine
business requirements
=95 Defined Chart of Accounts, Calendar, Currencies and Set of Books
=95 Setup cross validation rules, security rules, Financial Statement
Generator (FSG)
=95 Set up of Rollup Groups and Summary Accounts
=95 Designed multiple Financial Statements and ad-hoc re****ts for
accounting departments using Financial Statement Generator (FSG)
=95 Defined the Recurring journal allocation formulas for allocation of
various expenses across various business units
=95 Defined Mass Allocation Journals, Consolidation.
=95 Implemented Accounts Payable module
=95 Involved in doing the set up in test and production instance
=95 Do***ented and Tested the functionality using tests scripts
=95 Imparted training to the end users on Financial Modules as per the
Standard Operating Procedures of the Client
=95 Set up of Suppliers, Payment terms and discount policy for early
payment in Accounts Payables
=95 Resolved problems relating to the process of reconciliation between
the Payable and Receivable modules with the General Ledger
=95 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
=95 Provided Post-Production sup****t 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 sup****t for General Ledger
and Accounts Receivable modules.
=2E
Environment: Oracle Database 9i, SQL, PL/SQL, Oracle Apps 11.5.10
Responsibilities:
=95 Production Sup****t for GL AR
=95 Integration issues on Order Management
=95 Resolution of functional & technical issues assigned to the Sup****t
team.
=95 Extensions & Development activities related to Oracle Applications
11i suite
=95 Training users on the functionality of various Oracle 11i modules.
=95 Do***entation related to Extensions and Development tasks taken up.
=95 Do***entation of Business process of European operations with the
help of European Business analysts.
=95 Trained new hire and updated professionals for Oracle Financials,
AR, GL and User Sup****t, Prepared lesson plans, created curriculums,
and provided counseling on one-to-one basis. Also provided training in
Oracle Application Development Tools (Toad, Oracle Forms/Re****ts
etc.).
=95 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 encomp***** 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
Sup****t & Integration testing across the Financial, Distribution
modules
Environment: Oracle Applications 11.5.9, Oracle Database 9i, SQL, PL/
SQL, Mercury test Director
Responsibilities
=95 Involved in implementation of modules including Accounts Payable,
Fixed Assets
=95 Configuration of the Set-ups in Test instance followed by Regression
testing
=95 Preparation of Functional Specification Do***ents
=95 Involved in Internal Project Management including design of business
processes, feasibility study=92s, Funding and planning work scenarios.
=95 Preparation of Standard Operating Procedure Do***ents.
=95 Data Conversion which included transfer the opening balances of AP
from legacy systems to Oracle
=95 Testing the New Standard functionality offered by 11.5.10
=95 Testing the Interfaces, workflows and API=92s.
=95 Extensively used Mercury test Director for testing and defect
handling
for more details contact
BALU
ASSENTIA SOFTWARE INC..,
balu_p@[EMAIL PROTECTED]
EXT 204
|
