SURESHKUMAR PAULPANDIAN

Mobile

:

+91-735*******

Email Id

:

acp7vw@r.postjobfree.com

OBJECTIVE

Around 12+ years of IT experience in oracle applications, including 9+ years of experience in abroad (Kuwait) among them 4.5 years of experience as OBIEE, INFORMATICA developer and Oracle PL SQL Developer.

PROFILE SUMMARY

Around 4.5 years of experience as OBIEE, INFORMATICA developer and more than 4 years of experience as Oracle PL SQL developer.

Hands on experience in Oracle Business Intelligence 11.1.1.7.0.

Experience in working with BI Admin Tool, BI Answers, and BI Publishers.

Expertise in ER and Dimensional data modeling.

Configured Dimensional Hierarchies in the Business Model and Mapping Layer.

Created Calculation Measures Using Logical Columns, Physical Columns and the Calculation Wizard.

Developing business reports using OBIEE Analytics to display the reports in Dashboards.

Created Dimensional Hierarchies and Level-Based measures.

Created Comparison Measures Using Time Series Wizard.

Create reports with various views like Tables, Pivots, Charts, View Selectors, Prompts and Gauges etc.

Implemented data level and object level security in reports.

Experienced in working with Variable Manager to define session and repository variables and Initialization blocks.

Strong Knowledge of Dimensional Data Modeling, Data Warehousing Concepts, Star & Snowflake Schemas, OLAP and OLTP Systems.

Responsible for Extracting, Transforming and Loading data into source database.

Validating OBIEE report by writing SQL queries in source database.

Impact Analysis of existing applications and preparation of strategy for work request.

Preparation of design document using standard document followed in JPMC.

Developing applications as per design document & Enhancement of existing applications.

Checking UNIX log files and trace files for errors.

Work with business analysts, business users and DBA to analyze PROD issues and finding a way to resolve it.

Understanding the scope of the project, and communicate with the client for technical clarifications

Development and testing of ETL processes, components using Informatica.

Conduct knowledge transfer within the team and help team members in understanding the Client business and existing systems.

Enrolling new users and maintaining system security (Profiles), Roles, System and Object Privileges and managing user quotas.

Data file Consistency using DB Verify.

Responsible for the dealing with the Job monitoring, bug fixing and troubleshooting.

Developing RDBMS Database objects such as Stored Procedures, Queries, Joins, Triggers, Views, and Packages in Oracle PL/SQL.

Working on handling performance issues of Oracle SQL queries and PL/SQL procedures and evaluating current logic for tuning possibilities.

Involve in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica 9.x or SQL Loader.

Good experience in Oracle Application Development Framework (ADF).

Good working knowledge in Web services-related work.

Experience interacted with customers and provided production support at customer base.

Worked with multi cultured teams, thus gained team work capabilities.

Adaptability to new technologies, teams and environment.

Gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities.

Good communication and interpersonal skills.

TECHNOLOGIES

ERP

Oracle Application 11i, R12 (PO,OM,QC)

Language

SQL, PL/SQL, Java

Database & Tools

Oracle11g, SQLDeveloper, Toad

GUI

OracleForms & Reports10g, ADF, JDeveloper,

XML Publisher, Discoverer

ETL

Informatica 8.5.1, Informatica 9.5.1

Reporting Tool

OBIEE Versions -10.1.3.4, 11.0.1.7

Technology

Application Development Framework (ADF)

Operating Systems

Windows 7/XP/NT/98/95, server 2003

EXPERIENCE

Worked as a Oracle Apps Technical Consultant with Kharafi National KSC (Closed) from November 2006 to March 2015

Worked as a IT field as Technical Assistant / System Administrator with AL-ASWAR Technology Group Co. From April 2005 to November 2006

Worked as a Programmer with Integra Software from February 2000 to April 2002

Worked as a Programming Trainee with Software Solutions Integrated from

September 1999 to January 2000

EDUCATION

M.C.A (Master of Computer Application) From Manonmaniam Sundaranar University, Tirunelveli, India

B.sc (Bachelor of Science) From Manonmaniam Sundaranar University, Tirunelveli, India

WORK EXPERIENCE

1) Organization : Kharafi National KSC (Closed)

Position : Oracle Apps Technical Consultant

Place : Mina Abdullah, Shuaiba, Kuwait

Period : November 2006 to March 2015

ROLES AND RESPONSIBILITY

Proficient in Developer suite Report / Form Builder, Oracle Discoverer, XML Publisher Reports and OBIEE

Worked in different Modules in Oracle Applications (PO, OM, QC).

Created different Hierarchies, Level Based, Ragged level, Skip level, Parent-Child.

Developed report with conditional filters, Prompts, Drill Down reports, Drill Reports, different Analytics Views (Pivot Table, Charts).

Involved in implementing data level security and object level security.

Provide ERP training to End users of ERP QC module in project and Oracle Technical Support / assistance in ERP QC module implementation and Co-ordination with Department heads.

Developing RDBMS Database objects such as Stored Procedures, Queries, Joins, Triggers, Views, and Packages in Oracle PL/SQL.

Involve in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica 9.x or SQL Loader

Extensive expertise in Oracle Developer Suit and involved in complete development Cycle

Created Pixel Print Reports using BI Publisher.

Exposure writing complex SQL Queries

2) Organization : AL-ASWAR Technology Group Co.

Position : IT field as Technical Assistant / System Administrator

Place : Hawally, Safat, Kuwait.

Period : April 2005 to November 2006

ROLES AND RESPONSIBILITY

Maintaining Desktops

Data Analysis including report generations in MS Excel

Working with MS PowerPoint for Paper Presentations in seminars for new project proposals.

Installation and configuration of Windows 98 and XP operating systems.

Maintenance of Intranet, trouble shooting problems in LAN

TCP/IP Network Administration.

Updating data using MS Excel

Trouble shooting as well as managing the performance of the software and network

System Maintenance and trouble shooting of Printers

3) Organization : Integra Software

Position : Programmer

Place : Nagercoil, TamilNadu, India.

Period : February 2000 to April 2002

ROLES AND RESPONSIBILITY

Part of the team, worked with the Order and Production Handling System developed for a printing company to computerize their Order and Factory production details

Designed and developed user screens and reports using VB and MS Access

Tools Used: Windows xp, Visual Basic, MS Access

4) Organization : Software Solutions Integrated

Position : Programming Trainee

Place : Chennai, TamilNadu, India.

Period : September 1999 to January 2000

ROLES AND RESPONSIBILITY

Worked in the prototype applications for banking systems.

Developed user entry screens and reports.

Tools Used: Windows xp, Visual Basic, MS Access

PERSONAL DETAILS

Father’s Name

:

Paul Pandian

Date of Birth

:

04th May 1975

Passport No

:

M5452572

Place of Issue

:

Kuwait

Passport Expiry

:

10/02/2025

Present Location

:

Chennai

Marital Status

:

Married

Languages Known

:

English, Tamil & Malayalam

Contact this candidate