Suresh - OBIEE, Informatica - Singapore

Pachiappan Suresh



OBIEE, Informatica


• 15+ Years of experience in Business Application Software Development for various Industry verticals including Banking, Manufacturing Industry, Data center etc
• 4+ Years experience in Data warehousing and Business Intelligence Technologies including Development of Data Warehouse/Data Marts
• Specialties: Oracle Business Intelligence (OBIEE) 10g,11g.
• Good understanding of dimensional modeling based on Kimball methodologies.
• Involved in customizing and extending BI Apps data model for Financial Analytics and Sales Analytics subject areas.
• Exposure to Oracle Apps 11i/R12 modules as source systems for EDW
• Worked extensively in Informatica mappings using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & Tasks and scheduling
• Expertise in Data Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies
• Experience in gathering Business Requirements, Analysis, Development, Testing and Documentation of various functionalities
• Familiar in PL/SQL Procedures, Packages, Functions, Triggers and other objects.
• Good in performance tuning mainly SQL Queries for ETL Extraction and Reports.
• Excellent problem solving skills and troubleshooting skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

Work History

Senior Systems Analyst

Cittabase Solutions Pte. Ltd.

From August 2011

Software Engineer

P.S.S.Nidhi Ltd

September 1997 - August 2011

Freelance Developer

September 1997 - August 2011

Software Engineer

General Computer India Ltd

January 1993 - August 1997

Qualifications & Certifications


Anna University


Anna University

B.Sc Applied Sciences

Govt College of Engineering, Salem

Vasavi High School

Skillpages has been acquired by! is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Are you sure that you want to leave?