Oracle Techno – Functional

Consultant (BI)

BONDAHJAGALU Krishna

Oracle Techno – Functional Consultant

PERSONAL DETAILS

Address: Circonstance St-Pierre, Mauritius

Email: acxnso@r.postjobfree.com

Phone: +230-****-****

Date of Birth: 5th September 1982

Marital Status: Married

PROFESSIONAL PROFILE

Working in banking industry for 5 years as Data Warehouse Analyst at State Bank of Mauritius Ltd. Exposure to Oracle E-Business Suite R12 (12.1.3) – Oracle General Ledger, Fixed Assets and Payables, FLEXCUBE, VISION+, BASE24 and Internet Banking for building reports as per user and business requirements. Implementation of a single operational store where all reports of the bank were being done.

Join VESL Technologies Ltd. since MAY 2012 and working as Oracle HRMS Techno- Functional Consultant (BI). Exposure in implementing a reporting repository in Ghana for an electrical supplying company named GRIDCO from JUN 12 to NOV 12.

Worked at Air Mauritius Ltd for Oracle HRMS upgrade (DEC 2012 to APR 2013). Has been assign job role in assisting users for their reporting requirements both for Oracle HRMS and Financials and development of Online Payslip.

FEB 2013 till date providing support to Airtime Satellite Ltd. (Mauritius) on a billing application software developed on C-Sharp and MySQL database

MAY 2013 to AUG 2013 training and implementation with Financial Services Commission (Mauritius) for data masking and BI training to IT users.

NOV 2013 till date, project manager for report development at Mauritius Union for a health insurance application developed on Oracle ADF. Oracle Techno – Functional

Consultant (BI)

JUNE 2014 till date, Project Manager for implementation of Administrative Penalty Management software Financial Services Commission (Mauritius). Developed on Oracle Developers Suite 10g and Oracle Database 10/11g.

SEPT 2014 till date, Project Manager for implementation of a Loan Scheme Management software for Restructured Work Group (RWG Mauritius). Developed on PHP and Oracle database 11g.

Skills Acquired:

o International License for Microsoft Office Tools o Oracle BI Enterprise

Hands on experience in installing, configuring OBIEE 11g .

Defining repositories and templates for reporting.

Dashboard and automatic scheduling of reports.

Mobile integration.

o Oracle Warehouse Builder

o Data Warehousing (ETL/ELT,ERDs)

o Networking, Router configuration

o Unix Shell Scripting

o Oracle Applications- EBS (11i/ R12)

o SQL, SQL/PL, C-Sharp

o Database Administration (Oracle 9i,10/11g, MySQL) o Oracle Bi Publisher Desktop and Sever

o Oracle Developer Suites

o SOA and Business Process Management:

Hands on experience in implementation and configuring SOA Suite10g/11g.

Designed, Configured and Deployed BPEL Processes, ESB /OSB Services using BPEL Process Manager, and Web Logic Server on SOA Suite 10.1.3.x and 11g.

Expertise in using BPEL process activities, Decision Service, Partner Links and Adapters (File Adapter, FTP Adapter, Database Adapter, Oracle Applications Adapter, JMS Adapter) for developing custom business processes using Oracle BPEL Process Manager. MAJOR ACHIEVEMENTS/EXPERIENCE

Project Details 1 :

Oracle Techno – Functional

Consultant (BI)

o ERP modules : Oracle E-Business Suite R12 (12.1.3) – Oracle Financials, Core HR, SSHR, Performance Management, iRecruitement, Payroll and Online Payslip.

o Designation : Reporting Functional Consultant

o Period : Dec 12 – Apr 13

o Client : Air Mauritius Ltd, Mauritius

Responsibilities :

o Analyzing the current Business Activities.

o Requirement gathering and giving suitable solution to the client for a proper reporting environment.

o Reports analysis and design as per user requirements, using tools as Report Builder, XML/BI Publisher and Oracle Discoverer

o Identifying gaps and discrepancies that existing reports may address. o Reports designed for modules: IRecruitement, Performance Management, Online Payslip and Oracle Financials.

o Changing reports & Interfaces queries according to the R12 changes. o Worked on purchase order reports which will send email notification to the supplier when we create purchase orders in PO.

o Worked on report Journal entries with operation date which is linked with new concept like SLA.

o Customized Payment Register Report according to the client requirement o Finding changes in tables from 11i to R12. Replacing them with new tables in Reports & Interfaces

o Solved issues related to existing Reports & Interfaces due to changes in R12

o Restored all interfaces and reports in as is functionality by making changes according R12 changes.

o Coding and Development of RICE as per Naming and Coding Conventions

o Worked with Custom.pll for several customization o Performing Unit testing and Code review for developed RICE Components o Monitoring the deliverables during each phase of project Oracle Techno – Functional

Consultant (BI)

o Attending the weekly status calls and weekly reporting o Writing SQL queries according to customer requirement o Understanding customer issues.

Project Details 2:

o ERP modules : Oracle E-Business Suite R12 (12.1.3) – Core HR, SSHR, Performance Management, Learning Management and Payroll o Designation : Reporting Functional Consultant

o Period : Jun 12 – Nov 12

o Client : GRIDCO, Ghana Electrical Company, Ghana

Responsibilities:

o Analyzing the current Business Activities.

o Requirement gathering and giving suitable solution to the client for a proper reporting environment.

o Setting up of Oracle Discoverer and security aspect on the database that client may have to address in giving access to users. o Training on Oracle Discoverer.

o Preparing Training Manuals for Oracle Discoverer. o Identifying gaps and discrepancies that existing reports may address. o Reports analysis and design as per user requirements, using tools as Report Builder, XML/BI Publisher and Oracle Discoverer

Project Details 3:

o Company : Financial Services Commission (FSC)

o Modules Exposure : Oracle E-Business Suite R12 (12.1.3) – Oracle General Ledger, Fixed Assets and Payables

o Designation : Reporting Functional Consultant

o Period : Nov 2013 to Dec 2013

Oracle Techno – Functional

Consultant (BI)

Responsibilities:

o Training of users on BI Publisher and registering reports with EBS application. o Implement data masking on DB for certain tables and views. Restricting data to be viewed by particular user on the DB and same impacting on the application.

Project Details 4:

o Company : Mauritius Union

o Modules Exposure : INSIS Health Insurance System. o Designation :Reporting Functional and Data Warehouse Consultant

o Period : Dec 2013 to May 2015

Responsibilities:

o Assign as project manager to project on report development on INSIS Health Insurance System using oracle technology.

o In capacity of project manager was responsible for requirement gathering, validating test results, deliver CRP with project stake holders, end user training, and sign offs. Assisted technical team as and when required as technical lead as well.

o Assist on the migration of reports on BI Publisher and INSIS Health Insurance Application

o Managing a team of 4 resources to develop around 100 reports on insurance application

Project Details 5:

o Company : Restructured Work Group

o Modules Exposure : Custom Loan Application System. o Designation : Project Manager

o Period : Oct 2014 till date

Responsibilities:

Oracle Techno – Functional

Consultant (BI)

o Assign as project manager to project for the implementation of a custom design solution system for loan applications.

o In capacity of project manager was responsible for requirement gathering, validating test results, deliver CRP with project stake holders, end user training, and sign offs. Assisted technical team as and when required as technical lead as well

o Managing a team of 3 resources to develop and implement of the custom solution.

Project Details 6:

o Company : Financial Services Commission

o Modules Exposure : OSP to GB Integration.

o Designation : Senior Consultant

o Period : March 2015 till date

Responsibilities:

o Assisting team in deriving solution for migration and automation process for migration of data from OSP database to GB database.

Project Details 7:

o Company : Financial Services Commission

o Modules Exposure : Forms/Reports Upgrade 6i to 10g. o Designation : Senior Consultant

o Period : March 2015 to Feb 2016

Responsibilities:

o Migration of forms/reports from 6i to 10g

Oracle Techno – Functional

Consultant (BI)

Previous Work Experience:

o Company : State Bank Of Mauritius Ltd. (SBM)

o Modules Exposure : Oracle E-Business Suite R12 (12.1.3) – Oracle General Ledger, Fixed Assets and Payables, FLEXCUBE, VISION+, BASE24 and Internet Banking

o Designation : Business and Data Warehouse Analyst o Period : May 2007 to May 2012

Responsibilities:

o Analysis of Banking and non Banking Activities for an understanding of business processes as to deliver suitable solution as per user requirements. o Maintenance for Oracle E-Business Suite (GL, AP and FA). Maintenance of existing reports and bugging issues on the application. Working in hand with DBA team for Disaster Recovery for EBS and ensuring that application is up and running.

o Setting up of marts for different departments using different ETL techniques o Developing marts using Oracle Warehouse Builder and PL/SQL techniques, both for bank and its subsidiaries (overseas branches and non banking institutions within the bank).

o Developing an Operational Data Store (ODS), replicating all source system of the bank as to have a single layer reporting.

o Tools used for reporting: Business Objects and Oracle Discoverer. o Developing of report catalogue as a web link for users to get access, as to see existing reports and avoiding duplication of reports. o Automatic scheduling of reports generation and distribution. o Exposure to Web development, enhancement and web relating issues of the bank.

o Resource person for non IT users such as HR, Marketing, Audit, Finance and Customer Service, for new requirements, issues that may be facing or proposal of new solutions to enhance business processes. o Developing access matrix for applications, user manuals and procedures. o Training to users for in house applications developed Oracle Techno – Functional

Consultant (BI)

Ongoing Responsibilities and Expertise with VESL: o Support on Billing Application developed on C-Sharp for AirTime Satellite Ltd. Processing of billing information and debugging of current system. Current system reside on MySQL DB.

o Assigning day to day activities to team members for in house development.

o Responsible for custom applications developed by VESL, BI and Data Warehouse Solutions.

o Assisting technical side of tenders that VESL have to prepare, for both Mauritius and African Operations.

o In house development on OBIEE to setup a central banking reporting system. Building of repository and data model for predefined templates to be used by any Central Banking body.

o Internal training for SOA, WebServices, Architecture and Weblogic Portal, EPM.

CAREER HISTORY

Working as Oracle Sr. HRMS Techno – Functional Consultant (Data Migration and Reports) for VESL Technologies Ltd. from May 2012 to till date

Worked as Business and Data Warehouse Analyst for State Bank of Mauritius Ltd. from May 2007 to May 2012

Worked as Sales Person at Courts Mauritius Limited from Jan 2005 to April 2007

Worked as Stock Trainee at Mopirov Ltd from November 2004 to December 2004 Oracle Techno – Functional

Consultant (BI)

SPECIFIC KNOWLEDGE

Skill Set Version Level Current

Oracle Applications

Oracle General

Ledger

R11 and R12 Practical Experience Yes

Oracle Payables R11 and R12 Practical Experience Yes Oracle Payments R11 and R12 Practical Experience Yes Oracle Receivable R11 and R12 Practical Experience Yes Oracle Fixed

Assets

R11 and R12 Practical Experience Yes

Oracle Cash

Management

R11 and R12 Practical Experience Yes

Oracle Sub Ledger

Accounting

R12 Practical Experience Yes

Oracle Advanced

Collections

R12 Practical Experience Yes

Oracle Purchasing R11 and R12 Practical Experience Yes Oracle

iProcurement

R11 and R12 Practical Experience Yes

Oracle Inventory R11 and R12 Practical Experience Yes Oracle Order

Management

R11 and R12 Practical Experience Yes

Oracle Advanced

Pricing

R11 and R12 Practical Experience Yes

Oracle Cost

Management

R11 and R12 Practical Experience Yes

Oracle HRMS R11 and R12 Practical Experience Yes

Oracle Self Service

HR

R12 Practical Experience Yes

Oracle Payroll R12 Practical Experience Yes

Oracle Technology Products

Oracle Workflow 2.6

Extensive Practical

Experience

Yes

Oracle SQL,

PL/SQL

8i/9i/10g

Solid Expert

Experience

Yes

Oracle Forms 6i/10g

Solid Expert

Experience

Yes

Oracle Reports 6i/9i

Solid Expert

Experience

Yes

Oracle Techno – Functional

Consultant (BI)

Oracle Discoverer

[BI] (Desktop &

Administrator)

10g

Extensive Practical

Experience

Yes

Oracle Data

Integrator

10.1.3 Practical Experience Yes

OBIEE 11.1.1.5

Solid Expert

Experience

Yes

Oracle Techno – Functional

Consultant (BI)

ACADEMIC/PROFESSIONAL QUALIFICATIONS/TRAINING

2003 – 2007 B.Sc from University of South Africa, distant learning through learning body, DCDM Business School, Mauritius

1997– 2002 HSC from Mahatma Gandhi Institute, Mauritius

2013 Oracle Database 11g Data Warehousing Certified Implementation Specialist

LANGUAGE

English - Excellent (Written and Spoken)

French - Excellent (Written and Spoken)

Contact this candidate