Sreenivasan Kandhasamy
Professional Summary
Overall 10-12 years of experience in implementing, supporting and upgrading of Oracle EBS 11i, R12, and Fusion Applications.
Project Snapshot:
o1 Oracle Fusion Financial applications End to End Cloud Implementation,
o4 End to End R12 Implementations & 2 R12 Support Projects,
o2 Upgrade Projects (11i to R12, & R12.1.3 to R12.2.5),
o3 CoA (Chart of Accounts) Restructuring projects using 1:1, M:1, & 1:M logic,
o3 Airline SIS/XML (Simplified Interline Settlement) Projects with GL, AR, AP Integration
o2 Legal Entity Spin-off Projects for Airline industry including data migration & knock-off
o1 Support project in 11i,
Have extensive experience in designing Chart of Accounts and strong functional knowledge in full life cycle implementations of GL, AP, AR, CM, FA, Ebiz Tax, and iExpense modules.
A strong leadership skills to manage large no of teams.
Have followed CMMi process/documents to effectively monitor & controlling the projects. The documents are Project Plan in MPP, Project Management Plan (Charter), Effort Estimation, RFP, Requirement List, Project Team Member Training, Risk Register, Configuration Management, Weekly/Monthly Status Report, Issue Log, Mile stone acceptance certificate, Future Process, Functional/Technical Designing Document, Test Case, Defect Log, Metrics and Analysis, DAR etc.,
Have used oracle OUM methodology from Project Inception to Closure stage. (Requirement Gathering, Design, Development, Verification, Validation/Tesing)
80% Functional & 20% Technical (able to use SQL queries, extracting and debugging issues in GL, AP, AR, FA and CM tables)
Education
Degree
University
Year of Passing
Bachelor of Commerce (B.Com)
Bharathidasan University (Regular)
1994-1997
M.S (Management)
Madurai Kamaraj University (Regular)
1997-1999
Experience
Organization
Designation
Duration
7. TransSys Solutions Pvt Ltd
Principal Consultant
08/2010 – 01/2017
6. Polaris Software Lab Pte Ltd
Sr Project Lead
03/2010 – 06/2010
5. Syntel Ltd
Project Lead
08/2009 – 03/2010
4. Satyam Computer Ser Ltd
Functional Consultant
10/2008 – 08/2009
3. Oracle India Pvt Ltd
Senior Analyst
03/2005 - 10/2008
2. Infodesam Comp Education
Centre Coordinator
2001 - 2004
1. Prabhu Printers
Executive
1999 - 2001
Project Experience
Client
Industry
Work Location
Role
SaudiGulf Airlines
Airlines
Chennai/Saudi
Principal Consultant / PM
Oman Air
Airlines
Muscat/Chennai
Principal Consultant / PM
ADNOC, Distribution
Oil & Gas
Chennai
Senior Consultant / PM
Flydubai
Airline
Dubai/Chennai
Senior Consultant / PM
OOCEP
Oil & Gas
Offshore/Oman
Senior Consultant / PM
Emirates Airlines
Airline
Dubai/Chennai
Senior Consultant / PM
Kenya Airways
Airline
Kenya/Chennai
Lead
Etihad Airlines
Airline
Abudhabi/Chennai
Lead Consultant
Cameroon Airlines Corporation
Airline
Cameroon
Lead Consultant
Abdulla Abdulghani Co
Automobile
Qatar
Functional Consultant
DHL
Logistics
Singapore
Senior Project Lead
Zain Vodafone Communications
Telecom
Bahrain/Nigeria
Stream Lead
LOLC
Banking
Colombo - Sri Lanka
Module Lead
Oracle India Pvt Ltd
Software
Bangalore, India
Senior Analyst
Professional Work Experience
18.
Project Name: SaudiGulf Airlines Oracle Fusion ERP Implementation
Client
Oman Air
Role
Project Manager/Delivery Manager
Location
Muscat/Chennai
Organization
TransSys Solutions Pvt Ltd
Duration
12/2015 - 05/16
Team Size
Project: Approx. 7
Software
Fusion ERP Financials, Supply Chain, HCM, Payroll
Application
Oracle Fusion Financials, Procurement, SCM & HCM
Responsibilities:
As a Principal Consultant/PM responsible for,
Requirement Gathering, Design, Development, Verification and Validation
Solution designing for airline specific key requirements such as COA structure, Revenue Accounting, Direct Operating Costs (DOC), Simplified Interline Settlement (SIS), GL, AP, AR, FA, CM, and Procurements, HRMS and Payroll.
Handled Administrative tasks using IDM/OIM for user creation, role assignment
Familiar with APM, BPM, UCM, SOA, BPEL and Essbase cubes.
Followed TransSys 5X project methodology such as eXpose (Inception), eXploit (Elaboration), eXamine (Transition), eXperience (Production phase) which is similar to oracle OUM methodology
Was handled Post Production Support
17.
Project Name: Oman Air Upgrade, LE-Spin Off & AMC Support
Client
Oman Air
Role
Project Manager/Delivery Manager
Location
Muscat/Chennai
Organization
TransSys Solutions Pvt Ltd
Duration
03/2015 - 01/2017
Team Size
Project: Approx. 20
Software
R12.2.5
Application
Oracle FIN/SCM/HRMS/Payroll/Custom Bolt-on
Responsibilities:
As a Principal Consultant/PM responsible for,
Over all team co-ordination and interaction with client IT manager.
Maintaining/updating Project Plan, Risk Register, Milestone Acceptance, Issue Log, WSR, Metrics, DAR, CR etc.,
Solution Designing/Support for all the standard application issues on GL, AP, AR, FA, CAM & custom requirements
Day to Day Support and Month End Close
Implemented SIS solution for Inbound and Outbound process as per IATA automation.
Cargo LE Spinoff solution design including Data migration and Knock-off process
Ground Handling solution design including Data migration and Knock-off process
Upgrade from 12.1.3 to 12.2.5
Managing the production support issues
16.
Project Name: ADNOC GL COA Restructure
Client
ADNOC Distribution, Abudhabi
Role
Offshore PM
Location
Offshore/Onsite
Organization
TransSys Solutions Pvt Ltd
Duration
12/2014 – 03/2015
Team Size
Project: 6+
Software
11i
Application
Oracle Financials, SCM, HRMS, Payroll
As a Senior Consultant/PM responsible for,
Preparing a Project Plan, Monitor and Controlling the overall activities such as Pre-Switch, Technical Switch, Post Switch, Testing, and Cut-over activities
Modified the GL CoA Structure using 1:1, Many to One and One to Many logic
Performed end to end testing with reconciliation and period end close activities
15.
Project Name: flydubai R12 implementation
Client
Flydubai
Role
PM
Location
Offshore/Onsite
Organization
TransSys Solutions Pvt Ltd
Duration
06/2014 – 12/2014
Team Size
Project: 20+
Software
12.1.3
Application
Oracle Financials, SCM, HRMS, Payroll
Responsibilities:
As a PM responsible for,
Taken care of the mile stone target such as CRP’s, UAT and the Go-live activities on GL, AP, AR, FA, CM, eBiz tax, and iexpenses
Handled large size team to close all the custom components
Handled complex revenue accounting and SIS integration
Taking care of the support issues and the recon and period close activities.
14.
Project Name: GL CoA Restructuring/Switch
Client
Oman Oil Company Exploration and Production (OOCEP)
Role
PM
Location
Offshore/Onsite
Organization
TransSys Solutions Pvt Ltd
Duration
03/2014 - 05/2014
Team Size
Project: 7
Software
12.1.3
Application
Oracle Financials, SCM, HRMS, Payroll, Projects
Responsibilities:
As a Senior Consultant/PM responsible for,
Preparing a Project Plan, Monitor and Controlling the overall activities such as Pre-Switch, Technical Switch, Post Switch, Testing, and Cut-over activities on GL, AP, AR, FA, CM and SCM/HCM
Modified the CoA Structure using 1:1, Many to One and One to Many logic
Performed end to end testing with reconciliation and period end close activities
13.
Project Name: GL CoA Restructuring / Switch
Client
Emirates Airlines
Role
PM
Location
Offshore/Onsite
Organization
TransSys Solutions Pvt Ltd
Duration
07/2013 - 01/2014
Team Size
Project: Approx. 7
Software
12.1.3
Application
Oracle Financials, SCM, HRMS, Payroll
Responsibilities:
As a Senior Consultant/PM responsible for,
Monitor and Controlling the overall activities such as Pre-Switch, Technical Switch, Post Switch, Testing, and Cut-over activities in GL, AP, AR, FA, CM, SCM and HCM
Changed the character size from 4 to 5 for Cost Center and Natural Account Segment
Performed complete end to end testing will all the modules.
12.
Project Name: KQ SIS Implementation
Client
Kenya Airways
Role
Lead
Location
Chennai Offshore
Organization
TransSys Solutions Pvt Ltd
Duration
01/2013 - 03/2013
Team Size
Project: Approx. 5
Software
11.5.10
Application
Oracle Financials (GL, AP, AR, Custom Form)
Responsibilities:
As a Lead responsible for,
Design functional specifications for XML Mapping, GL Interface, AP Interface, inbound Interface form, Custom holds release program, AME approval, Invoice exception report
Design functional specifications for AR invoice extraction, Mapping invoice information from AR base table to Custom table, Outbound interface form and validations, XML file generation.
System test for the integrations, sandbox testing for XML outbound file
Perform System Testing, UAT Support, Production Migration
Production Support for 2 Weeks
11.
Project Name: R12 Upgrade Project (Testing done using OATS tool 9.1)
Client
Emirates Airlines
Role
Lead
Location
Chennai Offshore
Organization
TransSys Solutions Pvt Ltd
Duration
06/2012 - 12/2012
Team Size
Project: Approx. 5
Software
12.1.1
Application
Oracle Financials
Responsibilities:
As a Lead responsible for,
Taken care of the complete upgrade activities by co-ordinating with client, DBA, technical and functional teams.
Given the training on OATS tool to the entire testing team.
Lead the team to prepare the functional and load test scripts for financial modules such as GL, AP, AR, FA, CM and SCM modules
Executed/Evaluated the test scripts and generated the analysis report and graph outputs
Performed entire end to end testing with 3 iterations.
10.
Project Name: Etihad SIS Implementation
Client
Etihad Airlines
Role
Consultant
Location
Chennai Offshore
Organization
TransSys Solutions Pvt Ltd
Duration
01/2012 - 05/2012
Team Size
Project: Approx. 4
Software
11.5.10
Application
Oracle Financials (GL, AP)
Responsibilities:
As a Consultant responsible for,
Design functional specifications for XML Mapping, GL Interface, AP Interface, Interface form, Custom holds release program, AME approval, Custom Invoice exceptional report
Data Mapping for Inbound Interfaces, System test for the integrations
Data Conversion, Perform UAT, Production Migration
Production Support for 2 Weeks
9.
Project Name: CAMAIR-CO Airlines R12 E-biz oracle Implementation
Client
CAMAIR-CO Inc
Role
Lead Consultant
Location
Cameroon
Organization
TransSys Solutions Pvt Ltd
Duration
11/2010 – 02/2012
Team Size
Project: Approx. 5
Software
12.1.3
Application
Oracle Financials – GL, AP, AR, FA, CM, PO, Inventory
Responsibilities:
As a Project lead responsible for,
Exposing the business application to the Key Users in the form of Overview Training
Conducted CRP1 session utilizing our predefined Airline business process flows
Solution Walk through and confirmation (CRP2)
Finalization of GAPS and customized needs
Firm up data conversion/migration requirements
Interface development with RAPID (Revenue accounting system)
Conducted Key User Training/User Acceptance Testing session
Finalization of End User Plans/Progress
Data Migration & Production Support for 1 year
8.
Project Name: 11i Oracle Apps Support
Client
Abdulla Abdlghani & Bros Co WLL (Toyota/Lexus Dealer)
Role
Financial Functional Consultant
Location
Qatar
Organization
TransSys Solutions Pvt Ltd
Duration
08/2010 – 11/2010
Team Size
Project: Approx. 5
Software
11.5.10.2
Application
Oracle Financials – GL, AP, AR, FA, CM
Responsibilities:
As a Project lead responsible for,
Worked on the issue/enhancement list to close all the issues as per the deadline of 3 months support period for all the financials track
7.
Project Name: TM300i Transport Integration Project
Client
DHL Exel Supply Chain Pte Ltd
Role
Senior Project Lead
Location
Singapore
Organization
Polaris Software Lab Pte Ltd
Duration
03/2010 – 05/2010
Team Size
5
Software
11.5.10.2
Application
Oracle Financials – GL, AP, AR
Responsibilities:
As a Senior Project Lead, was responsible for
Designing Functional Specifications for 4 Inbound and 5 Outbound Interfaces between T300i transport system and Oracle system
Inbound such as AR invoices, AP Invoices, AR & AP Accruals from T300i to Oracle system
Outbound such as Customer Master, Supplier Master, GL Segment Values, GL Code Combinations, and GL Exchange rates from Oracle to T300i
Data Mapping for Inbound Interfaces
System test for the integrations
Data Conversion and Perform UAT
Data Conversion and Production Migration
Production Support for 2 Weeks
6.
Project Name: 11i Finapps Testing
Client
State Street Corporation, USA
Role
Project Lead
Location
Chennai
Organization
Syntel Ltd
Duration
08/09 – 02/10
Team Size
7
Software
Version : Oracle E-Business Suite 11i (11.5.10)
Database : Oracle 10g
Application
Oracle Financials – GL, AP, AR, FA, CM
Responsibilities:
As a Project Lead, was responsible for
Closely interacted with Onsite & Offshore team for functional manual end to end, and regression testing.
Successfully completed Q4/09 & Q1/10 Regression projects, Data encryption, BI Publisher & Q1/2010 Financial statement review projects.
Was handling 7 Members offshore team.
5.
Project Name: MTC Vodafone R12 Implementation
Client
Zain Vodafone Communications Ltd
Role
Stream Lead
Location
Bahrain/Nigeria
Organization
Satyam Computer Services Ltd
Duration
04/2009 – 08/2009 (Roll out)
Team Size
6
Software
Version : Oracle E-Business Suite R12
Application
Oracle Financials – GL, Ap, AR, FA, CM, PO, Inventory
Responsibilities:
As a Stream Lead, was responsible for
Completed Analysis & Requirement Gathering as per the country specific requirements
Conducted KUT, UAT and Given KT for the Key User
Daily interaction with client and provide the status on behalf of all the team members
Setups for all the modules, Data Conversion & Production Migration
Integration with TABS billing system
Support for Month End Close
4.
Project Name: LOLC R12 Implementation
Client
Lanka Orix Leasing Company
Role
Team Member
Location
Colombo
Organization
Satyam Computer Services Ltd
Duration
11/2008 - 02/2009
Team Size
4
Software
Version : Oracle E-Business Suite 11i (11.5.10)
Database : Oracle 10g
Application
Oracle Financials
Responsibilities:
As a Module Lead, was responsible for
Analysis of current business structure and prepared AS IS (BP-40)Document
Daily interaction with the client and provide the status on financial modules
Gathered Requirements and prepared RD-20 Document
Prepared Solution design(BP-80) as per the requirements
Prepared Functional interface document (MD-50) and Test (TE-40) document
Prepared Setup document (BR-100) and additional responsibilities include CRPs & UAT
3.
Project Name: R12 Upgrade / Support – Americas Region
Client
Internal Projects - Americas Region
Role
Senior Analyst
Location
Bangalore
Organization
Oracle India Pvt Ltd
Duration
01/2008 - 10/2008
Team Size
12
Software
Version : Oracle E-Business Suite R12
Application
Oracle Financials – GL, AP, AR, FA, CM
Contribution:
As a Senior Analyst, was responsible for
Handled a team and assisted to prepare test cases/scenarios
End to End testing with respect to process/business scenarios
Training to the other team members.
Co-ordination with the respective team for issue fixes
2.
Project Name: Enhancement & Support
Client
Americas Region – Oracle
Role
Team Member
Location
Bangalore
Organization
Oracle India Pvt Ltd
Duration
12/2006 - 12/2007
Team Size
5
Software
Version : Oracle E-Business Suite 11i (11.5.10)
Application
Oracle Financials
Responsibilities:
As a team member, was responsible for
End user processing, support and issue fixes in P2P areas
Month end process support
1.
Project Name: Financials 11i Support
Client
Oracle Internal team – Global
Role
Analyst
Location
Bangalore
Organization
Oracle India Pvt Ltd
Duration
03/2005 - 11/2006
Team Size
18
Software
Version : Oracle E-Business Suite 11i (11.5.10)
Database : Oracle 10g
Application
Oracle Financials
Responsibilities:
As a team member, was responsible for
End User Processing, support and enhancement activities for P2P cycle
Handling call requests and provided the resolution to the end users
Raising TAR/ SR with internal technical teams, in case of bugs or data in-consistency
Prepared test cases and knowledge transfer to rest of support team
SPOC for train the trainer
Honors & Awards – Oracle India Pvt Ltd
Have made a commendable contribution to the AP process in the month of Feb’06 and is acclaimed as the You Are Recognized (YAR Award)
Youreka Certified for new LOV added “Supplier Activation/Inactivation” in Prod track sheet
Youreka Certified for default Pay group added in Brazil stripe
You Are Recognized (YAR Award) for the month of Nov’07
Won Peer-to-Peer Award for the year 2007
Honors & Awards – TransSys Solutions Pvt Ltd
Star of the Quarter Jun’2014 from TransSys Solutions Pvt Ltd
Leadership Council Award 2015
Personal Details
DOB: 28th May, 1977, Passport Number: K7813576
Mobile: +1-475-***-****
Current Location: Wallingford, CT
Willing to Relocate: No
Expected Location: Within Connecticut