Support Oracle

Qualifications Summary

Around * Years of total experience in IT industry, in the Implementation, Development, Unit testing, Functionality Enhancement and production Support of Oracle EBS HRMS,

Oracle ERP systems - PeopleSoft modules (HRMS& FSCM), Developing & Testing dashboards of BI .

Currently working with Zain Communications, Kuwait as a Senior Reporting Analyst in Business Intelligence division.

Hands on with OBIEE reporting(Publisher/Analytical) and developing Dashboards.

Expertise in SAP Business objects.

Have been Trained on SAS and Cloudera.

Have exposure to Oracle ADF.

Strong at Oracle SQL and PL/SQL .

Have exposure to JIRA tool that is required for raising defects while testing the developed application .

Hands on experience with BMC remedy tool, for providing support to the clients .

Have exposure to BI Publisher, Peoplecode,Forms,Visual Studio ( 2013,15 & 16), Application Engine, Application Designer, Component Interface, File Layout and reporting Tools SQR .

Skills

TECHNICAL / FUNCTIONAL EXPERTISE

Oracle & ERP Modules

GL,AR,HR,CM, CA, PC

Reporting Tools

SQR, BI Reporting tools OBIEE,SAS, Crystal Report

Database

Oracle 11g, SQL server 2012 & 2016

Operating system

Windows & Unix

COMMUNICATING LANGUAGES

English

Arabic

Urdu

Hindi

Certifications

Oracle Optimized Solution for Enterprise Cloud Infrastructure Support Specialist

Enterprise Communications Support Specialist

Oracle Database Performance Tuning 2015 Support Specialist

Oracle Policy Automation Support Specialist

Oracle Exalogic Elastic Cloud 2014 Support Specialist

Oracle General Product support specialist

PeopleSoft general product support specialist.

PeopleSoft 9.1 Human Capital Management Sales Specialist.

PeopleSoft 9.1 Human Capital Management Presales Specialist.

Certified in Lean Six sigma, Agile Techniques,Code of Ethical business conduct and Team Motivation from Tech Mahindra

Work History

NTG CLARITY NETWORKS– Kuwait Oct 2017 – Till Date

Senior Reporting Analyst

Project: Zain Communications, BI.

Responsibilities:

Checking the requirements of client divisions and developing the OBIEE reports.

Development & Maintenance of DashBoards.

Working Experience on SAP Business Objects.

Testing the reports and Dashboards developed by the team.

Responding to the concerns of the users with the Dataware house.

Hands on Experience in modifying and Enhancement of the reports in DashBoards.

Troubleshooting the issues and fine tuning the SQLs to improve the performance .

Resolving the issues raised by the users in BMC Remedy .

CIS activities that include Deployment of the reports as per the schedule.

Coordinating with the DBA for changes in the Dataware house .

FUTURE TECHNOLOGY SYSTEMS– Kuwait July 2017 – sep 2017

SQL Database Developer

Project: Implementation of IT Applications for Kuwait Anti-corruption Authority (KANCOR)

Responsibilities:

Performing day to day DB activities such as monitoring SQL Server health, job status, addressing user requirements.

Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied and upgrades were done.

Testing the developed Applications and providing the feedback including the test cases.

Safeguarding data by instilling backup, managing user access and securing databases.

Hands on Experience in creating database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions.

Involved in troubleshooting various database server issues to free up log space, create databases and match their data, log patterns with contingency. Performed many database upgrades using import/export.

Tuning long running SQLs and enhancing the performance

TECH MAHINDRA LTD–India Dec 2013 – May 2017

Senior Software Engineer

Project: Development and Production Support of Oracle FSCM & HRMS modules at Chief Information Office (Tech Mahindra web pages Development and support)

Responsibilities:

Worked on critical Customizations which involved all SDLC cycle, Requirement gathering, Analysis, development, testing and support.

Developing complex SQL queries and providing reports to the management .

Worked on development of Oracle EBS R12 & Peoplesoft (HR & Finance) modules using People code, BI Publisher, Application Engines, File Layout, SQR Reports.

Managing a team of 10 members as a lead by monitoring the tasks assigned to them .

Formulated module specifications to translate business needs into programming codes.

Performing Unit Testing for the developed functionality.

Fixing bugs for the issues faced in Production after Root Cause Analysis.

Preparing documents like RDD (Requirement Definition Document), FDD (Functional Design Document), CRC (Code Review Checklist) and UAT user manuals.

Providing support to the clients using BMC tool.

Worked on a critical task of upgrading Peoplesoft from PS 9.0 to 9.2 for all the applications at Tech Mahindra.

Responsible for the implementation of security for PeopleSoft reports, processes and queries using various tools and in addition,played crucial role in mergers of few firms with Tech Mahindra.

Education

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY – India 2013

Bachelor of Technology in Electronics and Communication Engineering

Achievements

Awarded BRAVO and PAT ON THE BACK as a reward and recognition for the best performance at Tech Mahindra

Received appreciations from the Business owners and clients for delivering the assigned tasks in time .

Succeeded to be the Consistent top performer and received ACE (Associates who consistently Excel) award for the same for getting consistent top rating for 3 continuous years at Tech Mahindra.

Received Best Student award from the principal during my graduation .

Achieved first prize for an excellent paper presentation on Night vision at Madina Engineering college, India .

Personal Details

Date of Birth 06-Aug-1992

Hobbies Craft works, Trekking, Photography, Travelling and Reading Books

Driving License India

Nationality Indian

Gender Male

Civil id of Kuwait 292*********

Visa Status Article 18, Transferable residency.

I hereby declare that the above information is true and correct to the best of my Knowledge and I have all necessary documents for the same.

Date:

Place:

Contact this candidate