Profile Highlights
. Santosh Kumar is an experienced Oracle Applications (ERP) Project
Lead, Business Process Transformation Consultant, Systems Designer and
Functional Consultant with over 9.5 years total work experience in
Oracle eBusiness Suite in complete project life cycles.
. Industries include Utility Semiconductor, Software, Distribution
Financials, Building Construction, and Bio Sciences.
. Oracle R12 Experience:
o One full life cycle implementation experience in Oracle Release
12 (Version 12.0.4, 12.0.5) for a Semi Conductor Company
o One full life cycle Upgrade experience in Oracle Release 12
(Version 12.0.6, 12.1.1) in Utility Company proving complex
solution.
o Core skills:- Experience in implementing and testing
. Procure-to-Pay (P2P - iProcurement, Purchasing, iSupplier,
Payables and Oracle Payments and E-Business Tax)
. Financials (Accounting Setup Manager, Sub Ledger
Accounting, Multi-org Access Control, Data Access Sets,
Definition Access Sets, Revenue Manager, and Report
Manager)
. Order-to-Cash (O2C) business processes
. Certified on R12 Oracle Business Accelerators (OBA)
. Experience in capturing and publishing content using Oracle User
Productivity Kit (UPK).
. Diversified Project Profile in Oracle Applications Including
Implementations, Upgrades / Migrations, Production Supports, Testing
Projects, Custom Solutions
. Project Methodologies & System Life Cycle acquaintance: -
Implementations - AIM Methodology, Upgrades / Migration - EMM
Methodology, Production Support - Tier I & II Service approaches,
. Life Cycle Experience: Requirement Analysis, Functional Modeling, Data
Modeling, Legacy Systems Integration, Business Process Workflow
modeling.
. Extensive experience in Analysis, Design and Implementation of
eBusiness Suite - Oracle Applications (Rel 10.7, 11.0.3,11i- 11.5.5 to
11.5.10 & R12) in Functional modules
. Experience in Functional Design, Development and Functional Testing of
Oracle Financials Modules, Reports and Customization cycles
. Experience in Application Design, Customization, Test Script
Generation, Integration Testing, Training End Users and Preparing User
Guides
. Experience in Upgrade and Conversion/Migration of data from legacy
systems to Oracle Systems
. Well experienced in Multi-Org, Multi-Currency Global Oracle
Applications environment Excellent Business Analysis and Documentation
Skills
Skills
Relevant IT Expertise Relevant Functional Expertise
Procure to pay Cycle: Financial Accounting and Audit
General Ledger & Reports Manager Experience
Purchasing Budgeting and MIS reporting
iProcurement & iSupplier Finance and Procurement processes
Oracle Payables, Payments & Process Re-Engineering and
iExpenses Improvement
eBusiness Tax
Cost Management - SLA IT Audit
Order to Cash Cycle Information Systems Audit
Accounts Receivable & iReceivables Application Auditing
Oracle Advanced Collections SOXX
Order Management & Inventory Application controls adherence in
Cash Management accordance with control objectives
Projects Suite under the COBIT & SOXX purview
Project Costing & Billing Periodical reviews on controls
System and User Administration Enabling Audit Trails
System Administration
Application Developer
User Administration (RBAC)
Functional Administrator
Technical:
Operating Systems: Microsoft Windows 98/NT (4.0)/2000, Sun OS 5.6/8/9,
UNIX, Linux
Languages: SQL, PL/SQL
Database Technologies: Oracle 9i/8i/8.0,
Tools/Utilities: TOAD, SQL*PLUS, SQL*LOADER, Financial Analyzer, ADI,
Components: Application Object Library, Alerts
SDLC Project approach: Requirement, Solution design, Build /
Configuration, Testing, UAT, Go Live and Post Production Support phases
Education and Certifications
. Certified Information's Systems Auditor (CISA)
. Post Graduate Diploma in Computer Applications from the Osmania
University
. Bachelor of Commerce from Nagarjuna University
Training/ Certification
. Training to Oracle consultants on Procure to Pay modules at Oracle
Corporation, Hyderabad INDIA.
. GMP and GLP knowledge acquaintance while working at clients place
Project profile
Oracle Applications Rel 12.0.6 & R12.1.1
Client: Tucson Electric Power
Company: Rover Resources Inc
Tenure: Dec 2008 - Till Date
Role: Functional Implementer for Upgrade from 11.5.7 to R12
Modules: GL, AR, AP, SLA, Purchasing, iProcurement, Oracle Payments,
Ebusiness Tax, Receivables, CC&B & Projects
Tucson Electric Power Company (TEP), the principal subsidiary of
UniSource Energy (publicly traded on the NYSE under the symbol UNS),
serves more than 375,000 customers in Southern Arizona. TEP has upgraded
Oracle Applications from 11.5.7 to R12.0.6 to leverage the benefits of
R12 functionalities. The project is a complex one of its kinds which
interacts/interfaces with various third party systems like Work
Management Systems and Billing Systems typically used in the Utilities
Industry.
Migration path 11.5.7 to 11.5.10 to R12
Worked on the Oracle E-Business Suite application across the Supply Chain
and Financial Modules including E-Business Tax, Purchasing, iProcurement
Payables, Payments, Receivables, Cash Management, General Ledger, and
Project Accounting modules.
Primarily worked on requirements specifications, gap analysis, solution
design, configuration, testing and implementation for various Oracle
Application modules and Discoverer business areas.
Conduct Workshops with user base to explain the 11.5.7 and R12
functionality differences
Writing functional design specifications, system configuration documents
and cutover documents.
Job duties include providing functional support to clients during
Conference Room Pilots and System Tests, working with the technical team
to troubleshoot system problems and filing Service Requests with Oracle
Support.
Providing information and training to end-users on various R12 functions.
Performed a variety of data analysis to assist the Technical team.
Configured the Oracle Payments, E-Business Tax and iProcurement modules
and defined related customizations to meet business requirements.
Project Internal Controls
. Verify and introduce appropriately various Internal Controls for
the applications in terms of the following:
. Process Re-engineering - Conduct and Facilitate various
control meeting to ensure that project Controls are
being implemented based on the process changes
introduced by R12.
. Segregation of Duties
. Roles and Responsibilities' (Used both 11i and RBAC
security R12 User Management)
. Audit & Verify the core and Discoverer reports from data
perspective in view of data model changes between 11.5.7
and R12 during the System Test Cycles
Project Challenges Include
AP - Migration issues with respect to 11.5.7 Data to New R12 Data
structure issues in AP and Payments on SLA Uptake - on reporting.
. Oracle Payments Configuration & Automatic ACH transmission files to
Banks (could not succeed because of issues with Core Oracle
Transmission program which could not be made compatible to Well Fargo
Bank)
. PO & iProcurement - PO Accrual migration issues, Data Model changes
with respect to write-offs Category mappings issues, Retro Active
Pricing issue & PO Accrual Migration issues between R12 and 11.5.7 and
reconciliation between Purchasing and General Ledger
. E-Business tax - Configuring complex utility industry solution and
various system bugs and Enhancement Requests due to use of heavy
geography. (Use Tax Issues)
. GL - Report manager (FSG migration issues) & Reporting issues
. SLA - Mapping clients requirements to configure per R12 SLA concepts
. Project Costing - Work Management Systems integration & SLA issues &
Use Tax Interface from AP to PA
. Data Conversion - Supplier, Item and PO Shipment line conversions etc
. External Systems - Resolving Integration with various External systems
which interact with R12 (CC&B - Oracle Utilities Customer Care and
Billing Interface)
. R12 Close Process - Month- end Issues
Project profile
Oracle Applications Rel 12.0.4
Client: Pericom Semiconductor Corp.
Company: Rover Resources Inc
Tenure: Mar 2008 - Dec 2008
Role: Functional Implementer for Oracle R12 Financials Modules
Modules: AR, PO, Payables, Oracle Payments, E-Business Tax, SLA and GL,
Pericom Semiconductor Corporation (NASDAQ: PSEM) offers customers
worldwide the industry's most complete silicon and quartz-based solutions
for the Computing, Communications and Consumer market segments. Pericom
has operations in various countries - United States, China, Hong Kong,
Taiwan and Singapore
Project:
. This is a R12 implementation on Financials, Distribution and
Manufacturing modules
. The Project has followed a custom approach Rapid Application
Implementation with a view to bring the benefits of the application
to the users in a tight span of 9 months
. It implemented Diversified Process flows like P2P, O2C, B2B etc
. Consolidation of Operating Units at highest level
. Multi org and Multi Currency operations
My Primary role is implementing the SDLC for Procure to Pay and GL AR AP
Oracle Payments and E-business Tax Modules
Resolved various R12 system errors and issues specifically Procure to Pay
from eBTax point of view
Utilized the Oracle User productivity Kit (UPK) to Capture and publish
Oracle content
Configured the Payment Setup Administrator
Designed & changed SLA method to meet the specific requirement of the
client
. Configured taxes based on Transaction Types in AR ( since all
transactions are not taxable)
. Configured defaulting rules for both AR and AP taxes
. Flow based taxation for the Sales and Use tax codes for O2C and P2P
cycles
Financial Month end close processes in R12
Setting up of New Ledger for consolidation Purposes
Project Challenges Include
R12.0.4 was not a stabilized environment and issued various System bugs
and issue.
. PO & iProcurement - Challenges on System bugs while transactional
processing - issues with receiving processes
AP - new R12 Functionality and EBTAX and SLA Uptake.
. Oracle Payments Configuration & Testing - Payment Process requests
hanging without allowing users to complete the formatting process,
Check printing issues - specifically XML template issues and check
overflow
. E-Business tax - Product was not matured enough to allow users for
smooth transactional ability. AP data model has various eBTax bugs
which has not allowed the users to validate the invoices for making
payments & VAT
. GL & Report manager - Consolidation and MOAC training & XML template
publishing issues
. SLA - New Concept Mapping clients requirements to configure per R12
SLA
. Data Conversion - Reconciliation Issues in AP and PO with legacy data
. R12 Close Process - Month- end Issues
Oracle Applications Rel 11i
Client: Symantec Corporation
Company: Rover Resources Inc
Tenure: Jan 2008 - Mar 2008
Role: Sr. Principal IT Business Analyst
Modules: GL, AR, AP, PO, iExpense & Project Costing and Billing (PA)
Symantec is a global leader in infrastructure software, enabling
businesses and consumers to have confidence in a connected world. The
company helps customers protect their infrastructure, information and
interactions by delivering software and services that address risks to
security, availability, compliance and performance. Symantec has
operations in more than 40 countries.
Development & Integration - Conducted financial process/ software gap
analysis, process design, mapping, re-engineering and documented
processes using AIM Methodology. Designed and built the specific
application business process model to meet the business requirements.
Responsible for the process related task of the deliverables and
Application Setup.
Project Accounting - Costing and Billing:
. PA system setup and maintenance to map professional services in Oracle
Projects
. New Interfaces: Time Card, Expense, Billing events Interface
. Designed and involved in building of New interfaces like Time Card
interface from OTL and External System Quick Arrow and Expenses from
iExpenses and Concur and Billing Events Interface from Quick Arrow
. Functional design and design review of Oracle Applications dependent
data conversions from third party systems, Interfaces, custom
reporting, and custom applications.
. Creation of Test cases and Testing of developed interfaces
. Resolution of functional & technical issues assigned to the Support
team.
. Extensions & Development activities related to Projects Suite.
. Training users on the functionality of various Oracle 11i modules and
in specific related to Oracle Projects Suite
. Documentation related to Extensions and Development tasks taken up.
Financial Modules
. Gathered and analyzed business requirements. Documented functional
requirements pertaining to financial modules and security features.
. Carried out Gap Analysis between business requirements and application
standard functionalities and bridged them with RICEW components (R-
Reports, I-Interfaces, C-Conversions, E-Extensions and W-Workflows).
. Prepared sample data and test cases for RICEW components.
. Coordinated with technical team and DBA for resolving issues arising out
of RICEW components development.
. Modules Setup and Configurations have been done in the system to meet the
business needs based on the oracle financials application functionality
and oracle implementation methodologies.
. Created custom responsibilities set with the specific menus, functions,
report groups and profile options to restrict the access of application
security. Defined users and assigned responsibilities and profile
options.
. CRP and user acceptance test (UAT) were carried out for the above
modules. Trained the end users and resolve problems during UAT.
. Coordinated with technical and DBA team for resolving the customizations
issues and documenting them
. Provided functional support to other teams and troubleshooting and
maintaining the system
__________________________________________________________________________
___________________
Oracle Applications Rel 11i & 11.0.3 Upgrade
Client: Broadspire FL
Company: Rover Resources Inc
Tenure: Sep 2007 - Dec 2007
Role: Functional consultant & Sr. Business Analyst- Finance
Modules: GL, AR, FA, AP & PO
Broadspire, a Crawford Company is a leading third-party administrator to
employers and insurance companies. As an independent third-party
administrator, Broadspire focuses on service delivery, flexible program
design and optimal processes. It deals in Auto and general liability
claims management, Medical and field case management, either integrated
with casualty services or available on an unbundled basis, Integrated
workers' compensation and disability management programs, Risk and safety
consulting.
Responsibilities:
Implementation of Oracle Upgrade & Design Documentation - Evaluated
business requirements and developed solutions for successful integration
thereby reducing complexity and enabling effective control. Programmed
approach and conversion strategy is aimed to adapt and respond to growth,
streamline and improve the accuracy of information necessary for revenue
recognition.
. Initiated Project Planning and development by conducting JAD
sessions with business users.
. Documented Business Requirements and technical specifications to
develop Solution Design for successful integration into
Broadspire's11i Corporate Suite.
. Oracle Assets Conversion through FA_MASS_ADDITIONS using ADI.
Incorporated changes in remaining lives of newly added assets.
Monitored period end procedures such as depreciation run and
generated Asset Additions Report.
. Troubleshoot extensively to analyze the business logic for
trapping errors in system testing and User Acceptance Testing
(UAT) testing. Project deployment and Production Support.
. Full product lifecycle (vendor selection to implementation of
Oracle Applications Upgrade)
. Providing support on business analysis and IT functions for the
finance department.
. The workflow consists of daily production problem resolution as
well as the full product lifecycle for enhancement requests.
. Supporting two different versions of Oracle Financials (11i and
11.0) and a multitude of other UNIX and proprietary systems.
. There are multiple interfaces to/from systems internally and
externally.
. Daily maintenance consists of user access problems, user general
systems problems and specific Oracle Financials problems.
. Areas supported include GL AR AP FA & PO modules. This is a
multi-tasking area to embrace multi-systems, interfaces.
. Maintenance, troubleshooting, problem-resolution in order to
support 80+ end users.
. AR - To triage all facits such as collections technical
problems, reporting, cash applications, working with line items
and their application to an invoice
. GL - Working on interface tables, month end close & how to
review journals
. To deliver one-on-one training or formal group training.
. Writing requirements documentations & following Change Control
Management.
. Testing Oracle module development by forward thinking to test
all possible business scenarios in looking for bugs or potential
problem prior to go-live.
. Track testing documentation. Document bugs and track re-
development and re-testing.
__________________________________________________________________________
___________________
Oracle Applications Rel 11.5.10.2 Upgrade
Client: Bell Micro Products Latin America FL
Company: Rover Resources Inc
Tenure: Feb 2007 - Aug 2007
Role: Project Lead, Functional consultant & Sr. Business Analyst- Finance
Modules: GL, AR, FA, PO, OM, AP
Client Description
Bell Microproducts Latin America is a leader in computer hardware
distribution to Latin America. Bell Microproducts Latin America has
facilities for memory modules assembly with 2 operational SMT lines and
production output of 120k modules per month. The Latin America operation
has sales, marketing and technical support offices in Brazil, Mexico and
Argentina as well as a full distribution and integration operation in
Chile.
PROJECT DETAILS
Objective of the project was to eliminate as much as possible all the
custom components (forms, Reports, integrations with external Systems)
Four Operating Units in - United States, Chile, Mexico, Brazil
- Bell Micro has migrated Oracle Applications from 11.0.3 to
11.5.10.2 with Modules in Financial and Distribution steams
adding new modules like iProcurement, iSupplier, Advanced
Collections etc.
- The Project has followed a custom approach Rapid Application
upgrade & Implementation with a view to bring the benefits of
the application to the users in a tight span of 5months
- Diversified Process flows
- Chile, Mexico, Brazil Country Localizations
- Consolidation of Operating Units at highest level
- Highly Customized environment - 140 Custom Components
- Full Financial and Distribution Suite
- Multi org and Multi Currency operations
Project Activities & Accomplishments
. Lead the team of 5 people from Project initiation
. Coordination the migration activities with DBA, Functional and
Technical teams.
. Modules - GL, AP, AR, FA iSupplier & iProcurement
. Coordinating the Supply Chain activities from integration
perspective (PO, OM & INV)
. Mapping Custom components to Standard functionalities
. Requirement Gathering for all Operating Units
. Upgrade Steps as per EMM methodology
. New feature / Application consideration
. Thorough documentation of all the project phases
. Testing, UAT and Training Phases
. User Demos, Test scripts preparations, Training Manuals, Bug
resolutions
. Iterative testing involving Unit, Integration, System Stress &
Regression testing of the Business Components
Oracle Applications Rel 11i Production Support & Upgrade
Client: BioReliance Corporation Inc.,
Company: Satyam Computer Services Ltd
Tenure: NOV 2005 - Feb 2007
Role: Functional consultant & Business Analyst- Finance
Modules: GL, AR, FA, PO, OM, AP
Project Description
BioReliance provides services for the development and delivery of
healthcare products through testing, development and manufacturing
services in partnership with clients worldwide. Invitrogen Corporation
acquired BioReliance in 2004. BioReliance is the world's largest
specialist provider of contract biologics safety testing, GMP
manufacturing and pre-clinical and clinical testing services.
BioReliance implemented Oracle Applications as the ERP system to run its
business. The primary objective of this project is to support Oracle
Applications 11i modules for the business.
BioReliance uses Oracle Applications to manage its business. Oracle GL is
the ledger of record. Data flows into the GL through the oracle sub
ledgers like AP, AR, Inv, PO, FA. Some custom applications like LADS
system interface with AR for receiving Customer information and sending
Invoice information to AR. The Order flow is completely customized. Order
changes are effected by using Sub-Inventory transfers. Cost management is
not used and none of the items are costed. All purchases are expensed and
the items are expense items. Creating of Locaters is customized. Some of
the Oracle forms are also customized (example Order Entry, Sub-Inventory
Transfer)
Oracle Applications.
Some interfaces
Outbound interface from Oracle to LADS
Inbound interface from LADS / LIMS to Oracle
Production Support & Enhancements - Responsible for Production support of
a large scale enterprise-wide financial system built on Oracle 11i e-
Business Suite of applications software package. Collaborating with other
members of IT team to trace and escalate application bugs, problem
analysis and resolution, applying fixes and Patches as applicable.
. Monitored Production operations support for US and International SOB's
which involved, initiation and tracking of help-desk tickets and
assignments using Track-IT. Batch jobs, Depreciation runs, design and
testing of production changes to the application.
. Provided Business Process best practice advice and training on the use of
Accounts Receivables, Fixed Assets and General Ledger to enforce common
best practices and gain efficiencies through maximizing the functionality
available within the ERP.
. Conducted Operational GAP Analysis and developed Fixed Assets
Questionnaire for successful integration of Invitrogen BioServices into
BioReliance Corporation.
. Proactive review and recommendation on Workflow improvements in the
system to achieve the required business processes.
. Troubleshoot extensively to analyze the business logic for trapping
errors in system testing and User Acceptance Testing (UAT) testing.
. Production Support for GL AR AP FA
. Oracle Patching & Critical Security Patch updates
. 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, AP,
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, Optio, Oracle
Forms/Reports etc.).
. Handling TARs for various issues.
. SOX & Internal Audit Compliance
Major Enhancements:
Enabled Audit trail functionality as per SOX requirements
Customization of the Revenue Recognition Process (% Completion Method)
Oracle Applications Rel 11i Implementation - RAF Posting to Oracle
Financials
Client: MasterCard International
Company: Satyam Computer Services Ltd.
Role: Functional Design Expert - Finance
Tenure: Jun 2005 - Nov 2005
Modules: GL, AR, OM
Project Description
MasterCard International is a leading global payment solutions company
owned by over 1,500 financial institutions or principal vendors. It has
approximately 13,500 affiliate members worldwide.
Project involved Straight-through process remittance files directly from
MasterCard Global Data Repository to Satyam's Oracle system. Completing
the processing of the Remittance Advice File (RAF) in Oracle for actual
payments from MasterCard to Satyam Computer Services Ltd and to
understand configuration or customization requirements for posting RAF to
Oracle
Contributions
As a part of the project, Santosh Pallerla was responsible to provide:
. Complete Fit/GAP Analysis for MasterCard between RAF and Oracle
Financials (Collections and A/R functions)
. Preparation of functional design and configuration document for
posting RAF in Oracle Financials Identify and document any required
customizations
. Complete the 'proof of concept' testing in Oracle development/test
environment at Satyam (execute tests, document results, etc.)
. To provide file layout to MasterCard Global Data Repository for
posting to Oracle Receivables on transfer requirements provided by
Satyam
. Providing all end-user documentation
. Providing knowledge transfer to MCI
Oracle Applications Rel 11i Implementation - Balfour Beatty Utilities
Client: Balfour Beatty Utilities
Company: Satyam Computer Services Ltd.
Tenure: Nov 2004 - May 2005
Modules: Oracle Project Costing, Billing, GL, AP, AR, iExpenses, PO & OTL
Role: Functional Consultant
Project Description
Description: Balfour Beatty Utilities has interests in the areas of
construction and providing engineering services.
Balfour Beatty undertook implementation of General Ledger, Accounts
Payables & Fixed Assets Management to replace the legacy system by a
superior system with advanced security features and enable its users
spread across their operations.
Contributions
Involved in Implementation Support of Oracle Projects 11.5.7 and Upgrade
from 11.5.7 to 11i. As a Functional Consultant & Analyst, was involved in
analyzing business requirements, design and development of interfaces and
configurations of Project Costing, Project Billing Modules and Testing
their integrations with iExpenses, AP, AR, GL, iProcurement and PO
modules in a Multi-org environment.
. Pre & Post implementation Support for Project Costing & Billing
Modules 11.5.7
. Part of the Upgrade team for Upgrade of Oracle Project Costing &
Billing from 11.5.7 to 11i
. Planned & Conducted the Upgrade testing.
. Integration Testing between Oracle Projects and Financial Modules
including GL, AP, AR, PO, iProc, iExp
. 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 and
in specific related to Oracle Projects Suite
. Documentation related to Extensions and Development tasks taken up.
. Preparation of User Manuals & Desktop Procedures & Functional Design
Documents
2nd phase
As a part of Automation of different functions in Oracle, Balfour Beatty
has implemented EMS (Enterprise Management System). This involved
Implementation of new modules and testing their integrations with
projects Costing / Billing and also to other financial modules like AR,
AP, and GL.
. Impact Analysis of Oracle Projects with Implementation of EMS
. Provide & Document changes to existing configuration due to
implementation of EMS
. Test all the Custom Interfaces, Reports & Workflows with the
implementation of EMS.
. Update existing Test Scripts for implementation of EMS.
. Perform Testing of Standard Functionality for Implementation of EMS
. Provide Documented system and integration Test Results for Oracle
Projects with EMS Implementation and to Open and follow up on Service
Requests
. Update User Manuals & Desktop Procedures after the Implementation of
EMS.
. Assist in Internal Project management
. Provide Support to Business Users
. Provide Training to Users before and after Implementation of EMS
Oracle Applications Rel 11i --- QTC Everest Release
Client: Cisco Systems Inc, USA
Role: Functional Consultant -Lead Role
Tenure: May 2004 - Oct 2004
Modules: OM, & AR Oracle Apps 11.5.9
Project Description: Cisco Systems, Inc. is the worldwide leader in
networking for the Internet with revenues of US$15.7 bn in fiscal 2002.
Cisco is operating from various countries including US, Canada, Japan,
Australia, and New Zealand. Over 23 countries in Europe, Middle East and
Africa. Over 19 countries in Asia and South America
Cisco Systems Inc has upgraded its Oracle Business Suite from 10.7
(Character User Interface) to 11i (11.5.9). Cisco construes 11.5.9 as
"Everest Release" During this migration; they had discarded a few of
their old customisations since 11.5.9 was providing the
functionality. During this migration, in view of additional functional
and business requirements, Cisco has further customized the applications.
The scope of the project included Q2C Functional Testing for Cisco in
Order Management, Accounts Receivables.
Contributions
As a Lead, was responsible:
. Interaction with the client and meeting the quality and functional
requirements of the project
. Interaction with client & co-coordinating with Testers for system
testing issues
. Interaction with the Development team for Customizations.
. Interpreting requirements, specifications, designs, system and
application documentation to determine the most expedient and
complete means of validating business processes and application
functionality.
. Understanding the 10.7 functionality through Functional
Specifications & Detailed Solution Design documents for the 11.5.9
upgrade.
. Execution of Test Scripts provided by Cisco and documenting the
results in Test Director.
. Owning responsibility for major business functions and providing
functional input to Testers within the team.
. Analyzing the test data requirement necessary to execute the
scripts.
. Logging the defects encountered
. Co-ordination with Cisco's Team in resolution of defects based upon
the priority assigned.
. Advising on Review of test scripts where necessary.
. Identifying, documenting and execute test cases from requirements,
. Determine and perform test setup and execution, including
identifying and loading all test data.
Oracle Applications Rel 11i Implementation -- Integrated Application
Software Package (IASP)
Client: Tecumseh Products India Private Limited.
Role: Finance Consultant/Finance Manager
Tenure: Dec 1999 - May 2004
Modules: GL, AP, AR, FA, CM, Oracle Apps 11.5.3
Project Description
Tecumseh India is a 100% subsidiary of US based company called Tecumseh
Products Company having presence in more than 29 countries world wide.
The company manufactures hermetically sealed compressors for catering the
Middle East and Asian Markets requirements.
Tecumseh has implemented Oracle Applications and is utilizing the full
benefits of integration. During the course of employment with Tecumseh,
Santosh K Pallerla had worked on the following areas:
. Oracle Applications Implementation for General Ledger, Accounts
Payables, Accounts Receivable & Fixed Assets modules.
. Closely involved in various phases of Applications implementation
during "As Is" CRP I & II, Solution build and UAT etc..
. Involved in the finalization of accounts of the Company,
Maintaining the books of account of the Company Train the module
champions and users in the Oracle GL, AP, FA and Localization
concepts.
. Perform the required set up needed to implement the Oracle GL, AP
and FA modules.
. Solution design phases (Pre-CRP) and configured the applications in
the Test / Development environment for CRP-1 & CRP-2.
. Document the Setups, Standard Operating Manuals and the Training
Materials for Oracle financial modules
. Preparation of functional test case documents.
. Report Fitment of Oracle Financial modules.
. Handled General Ledger, Accounts Payable & Fixed Assets modules
implementation for this site. This includes study of the existing
processes and development of To-Be Business Processes and Solution
Design based on the To-Be Processes and Implementation.
. Played a key role in To Be flows design of the General Ledger,
Fixed assets, Accounts Payables, Purchasing Modules considering the
varied requirements Statutory requirements.
. Provided functional specs for the development of Custom Reports,
across financial modules.
. Played a significant role in the Users and Responsibility creation
for the entire user base, cutting across modules, processes and
roles, through the System Administrator Module.
. Major contributor for Overall Solution Design of all Financial
Modules.
. Lead the team, which is responsible in drafting & submission of a
set of Documents at different stages of project to the Balfour
Beatty Utilities Management. Also responsible for successfully
executing crucial miles stone like data migration and Conversion
Methodologies
Has worked extensively on Project 404 the compliance section of Sarbanes
Oxley Act (SOX) for his earlier organization on Review of Operational and
Functional Controls, which have effect on the Financial Statements of the
company Contributions