Ritesh Choudhari Mobile: - +966-*********

Oracle Developer/Data Analyst Email: - adm99a@r.postjobfree.com

Nationality: - India

Current Location: - Riyadh KSA

Objective

Seeking a suitable position in a growth-oriented organization where I can learn and utilize my expertise and contribute to overall growth.

Professional Summary

I have about 12 years of experience as oracle developer and data analyst particularly in banking domain, my expertise includes below: -

- Debugging and fixing issues in complex oracle plsql application.

- Creating oracle plsql procedures, functions, packages and triggers.

- Performance tuning of oracle sql, plsql code and API`s.

- Good knowledge of advanced plsql, oracle data service ORDS, REST API.

- Creating oracle forms, reports configuration, deployment and migration.

- Worked on data integration and ETL design and development.

- Creating analysis, dashboard, reports, data model, repository file, using BI publisher, OBIEE and BI

administrator tool.

- Oracle application deployment and configuration on oracle weblogic server.

- Good knowledge of business intelligence, data warehousing, oracle apex etc.

- Good knowledge of oracle sql, plsql for analytics and reporting tools.

- Possess good communication and inter-personal skills, able to adapt quickly to new technologies.

- Proficient at working as a team player with an aim of contributing towards the team's success.

Work History: -

Company

Duration

Designation

TechMahindra Ltd.

April-2015 to Present.

Data Analyst.

Tata Consultancy Services (TCS) India.

April-2014 to March-2015.

IT Analyst.

Mphasis IT Ltd. India.

March-2011 to March-2014.

Software engineer.

Melstar IT Ltd.

May-2010 to February-2011.

Software engineer.

Rolta India Ltd.

Jan-2007 to April -2010.

Associate software engineer.

Technical Skills: -

Database

Oracle DB 9i, 10g, 11g, 12c.

Oracle DB IDE

SQL developer, Toad 9.7, PLSQL developer, Golden Benthic.

Data Integration/ETL

Informatica Power Centre 8x, OWB, Oracle data Integrator - ODI.

Oracle Apps

Oracle Forms and Reports, BI Publisher, OBIEE, Oracle Data Visualizer DVD, Discoverer, Oracle Apex, Oracle financial.

Miscellaneous

Qlikview, tableau, Excel, Crystal Reports, ORDS REST API.

Programming Language

PLSQL, Shell Scripting, HTML, CSS, Java script.

Server

Oracle Weblogic, OHS.

Operating System

Windows XP/7, UNIX RH/SS/HP.

Education: -

Course/Degree

Specialization

Duration

University/Education Board

Post Graduate Diploma (PGDBM).

Business Management.

2009

Welingkar Institute of Management.

Bachelor of engineering (B.E.)

Electronics and Telecom. Engineering.

2000 to 2005

North Maharashtra University India.

Diploma in Engineering.

Electronics and Comm Engineering.

1997 to 2000

MSBTE Mumbai India.

HSSC/Schooling.

Science.

1996

MSBSHSE Mumbai India.

Project Details

Project Name

ODMS - Operational data management system

Client

Riyad bank KSA.

Role

Oracle Developer/Data Analyst

Employer

SRACO Company KSA.

Duration

April-2015 to present

Business

Core banking, Internet banking, phone banking

Software’s Used

Oracle Forms/Reports, Database 11g/12c, Toad 9.7, Benthic, PLSQL Developer, ORDS, Apex

BI Publisher

Project description

ODMS-Operational data management application was implemented to improve the overall performance of Bank`s critical business services. ODMS stores the operational minimal data from most of the banking application (like Debit/Credit Cards, Treasury, CRM, General Ledger, Capital and Corporate banking and many more).

This provides speedy response for banking services like: -

-User authorization and authentication.

-Beneficiary creation and management.

-User access/channel management.

-Internet banking/Phone banking.

-Corporate banking/Retail banking.

Data from different banking application is extracted and loaded to it via ETL batch jobs.

Responsibilities

- Debug and provide solution for business-critical issues.

- Development of plsql functions, procedures, packages etc.

- Design and develop data integration and batch processing module for processing data from

interfacing applications.

- Develop oracle forms application for back office administration.

- Performance tuning of complex plsql code and data loader API.

- Creating design and solution documents as per business requirements.

- Provided training to resources on new application/module.

- Worked on data integration and ETL development.

Project Name

PRM – Project Resource management system

Client

Tata Consultancy Services TCS India.

Employer

Tata Consultancy Services TCS India.

Role

Oracle Developer/ IT Analyst

Duration

April-2014 to March 2015

Business

HRMS, Oracle Apps, Data Integration/ETL/DW

Software’s Used

Oracle Apps (PRM) Project management, Oracle Forms10g, Informatica, BI Publisher, PLSQ developer, Toad 9.7, Putty.

Project description

This is human resource management application. It receives data from multiple sources and it acts as enterprise repository for most of the applications. The downstream application takes/extracts data as per their required format and there are ETL implemented using Oracle provided and other tools. On top of this there are several reporting applications using various tools like Qlikview, HANA and BI Publisher for reporting for various client/application.

Responsibilities

- Developed plsql functions, procedures, packages etc.

- Designed data integration and batch processing module for processing data from interfacing

applications.

- Performed Data Migration by using bulk collect, external table and data pump utilities.

- Created Informatica mappings with oracle procedures/functions.

- Created Analysis, dashboard, reports, data model, repository file, using BI Publisher, OBIEE

and BI administrator tool.

Project Name

AOL Cash

Client

Royal Bank of Scotland (RBS) Netherlands.

Employer

Mphasis India.

Role

Oracle Developer/Software Engineer.

Duration

March 2011 - March 2014

Business

Banking and financial services, Cash administration.

Software’s Used

Oracle Database 11g. Oracle Forms/reports 10g, SQL Loader, Weblogic Server, TOAD 9.5, PLSQL Developer and Putty.

Project description

Under this project a new cash administration application was developed and delivered successfully to client RBS. At present, the business customers of RBS use AOL Cash (Access online cash) across Netherlands for depositing daily cash and for placing orders for the required cash. This is a web application, through this business user, can place cash order/standing orders, deposits orders, seal bag request and generate various kinds of reports for themselves. Internal user as well as External users can use AOL Cash application.

Responsibilities

- Developed complex SQL scripts for reconcile report generation for various vendors of bank.

- Project monitoring, Incident management, recovery, impact analysis and reporting.

- Database related enhancements, issue solving, changes and bug fixing.

- Carrying out design, construction, review and defect analysis activities.

- Performance tuning, PL/SQL code debugging for resolving production issues.

Project Name

HR AMS.

Client

Idea Telecom Pvt. Ltd. India.

Employer

Melstar IT Ltd. India.

Role

Oracle Developer/Software Engineer.

Duration

May 2010 - February 2011

Business

Human and Resource management

Software’s Used

Oracle Forms10g, SQL loader, Toad 9.5, PLSql developer, Putty, XML/BI Publisher.

Project description

This was a human resource management (HRM) integration project for client Idea cellular and under this project, Oracle HRMS was implemented successfully and migrated data of about 100,000 employees. HR AMS application includes payroll, recruitment, Time card, insurance and many more ERP modules. In this project mainly, I was looking after PLSQL development, data analysis and data integration.

Responsibilities

- Created stored procedures, functions, packages, database jobs and data correction scripts.

- Created OBIEE 10g reports, dashboard and analysis.

- Created ETL data integration batch jobs.

- Involved in tuning of existing ETL data load jobs/plsql code.

Project Name

Central Networks

Client

EON Power UK

Employer

Rolta India Ltd.

Role

Oracle Developer/Software Engineer

Duration

June 2009 – May 2010

Business

GIS/Electrical network digitization.

Software’s Used

Oracle 9i, Oracle forms/reports 9i, PLSql developer, Toad 7, Unix, SQL, Crystal reports.

Project description

This project was GIS implementation project, entire electrical grid/network was digitized under this project. Data was captured from network and terrestrial maps and integrated to GIS software Smallworld. In this project I was Involved in Oracle database side development activities for electrical equipment’s inventory and management module. I have also participated in developing SQL scripts to conduct data quality checks, error handling and reporting.

Responsibilities

- Coding Oracle PLSQL, stored procedures, functions, triggers, packages and SQL Scripts.

- Created data entry Oracle 6i Forms.

- Debugging PLSQL codes to analyze various issues raised by client.

- Created scripts to create new tables, views, queries for new enhancement in the application.

- Created indexes on the tables for faster retrieval of the data to enhance database performance.

- Testing, quality analysis and quality control.

Project Name

US West Smart Network.

Client

Qwest Communication USA.

Employer

Rolta India Ltd.

Role

Associate software engineer

Duration

Jan 2007 – May 2009

Business

GIS/Telecom network digitization.

Software’s Used

Oracle 9i, Oracle forms/reports 9i, PLSql developer, Toad 7, Unix, SQL etc.

Project description

This project was GIS implementation project, under this project entire wired telecom network of Qwest was digitized to improve efficiency, asset and fault management. Telecom networks/exchange data was captured and integrated with the GIS software.

During this 2-year tenure, I learned and developed my skills on Oracle database and respective tools. In this project, I was involved in oracle PLSQL development.

Responsibilities

- Coding of oracle PLSQL, Stored procedures, functions, triggers, packages and SQL scripts.

- Created data entry oracle 6i forms.

- Testing, quality analysis and quality control.

- Developed Oracle 6i forms for data entry application.

- Developed Oracle PLSQL scripts for Data quality check and reports.

- Created Shell Scripts for invoking SQL scripts and scheduled them using Crontab.

Contact this candidate