Business Intelligence and Data Warehouse Applicationsâ€‹ Resume

SUMMARY:

Having over 11+ years of IT experience in gathering Business Requirements, Analysis, Design, Development, Upgrade, Customization and Maintenance of Business Intelligence and Data Warehouse Applications using OBIEE, BI Publisher, DAC, Pentaho and Informatica.
Extensive experience in configuration of OBIEE/Siebel Analytics Applications using OBIEE Answers, OBIEE Dashboards, OBIEE Delivers, DAC and OBIEE Admin Tool.
Expertise in Business Model development with Dimension Hierarchies, Measures, Aggregation Rules, Variables, Time Series Functions, Cache Management.
Extensive Experience in configuring interactive Dashboards with drill - down capability using global and local Filters, OBIEE Security setup (groups, access/query privileges).
Expertise in creating Metadata Objects and Web Catalog Objects (Dashboards, Pages, Folders, Reports) using OBIEE Admin Tool and Siebel Analytics Web.
Expertise in Implementation, Upgradation and Development of various Analytics systems such as Sales and Marketing Analytics, Pharma Analytics, HR Analytics, Financial Analytics, Procurement Analytics, Supply Chain Analytics and Service Analytics.
Expert in design, develop and implement Reports using BI Publisher tool.
Expertise in using Oracle Data Warehouse Administration Console (DAC).
Expertise in Design and implementation of Star Schemas, Fact tables, Dimension tables, ETL processes.
Experience in Extraction, Transformation and Loading of data from multiple sources to Data Warehouse using Informatica Power Center Tool.
Experience in Pentaho Design tools like Pentaho Data Integration(PDI) and Report Designer.
Experience in Siebel CRM Marketing Applications and Siebel Marketing Analytics.
Good Functional and Technical knowledge and understanding of Oracle E-Business Suite Financial/SCM/CRM and PeopleSoft HCM/FSCM data models for OBIEE Reporting.
Expertise in writing SQL Scripts, developing Functions, Procedures, Packages, Triggers, Views and other Database Objects using SQL, PL/SQL.
Strong Analytical, Interpersonal, Communication skills and excellent Team player.

TECHNICAL SKILLS:

Data Warehouse Tools: OBIEE 11g/10g/Siebel Analytics 7.8.x/7.7.x, DAC10g/7.8.x, BI Apps 7.9.6.3, BI Publisher 11g/10g, Informatica 8.x/7.x/6.x, Pentaho 7.0

Databases: Oracle 11g/10g/9.x/8.x, MS SQL Server 7.0/6.0/2005/2008, MS Access, Teradata version 12/V2R6.2x/V2R6.1x/V2R6.x

Applications: PeopleSoft HCM 8.8/9.0, PeopleSoft FSCM 8.8/9.1 Siebel CRM Marketing 8.1, Oracle EBS 11.5.10/12.2.3, Oracle Applications (R12/11i) modules: Financials, SCM, CRM, OMIPM

Languages: SQL, PL/SQL

Operating Systems: Windows XP/NT/2000, UNIX, Linux

Other Tools: SQL*Plus, Teradata SQL Assistant, TOAD, Oracle SQL Developer, PVCS, HP Quality Center, HEAT Software, BMC Remedy

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence and Data Warehouse Applications

Responsibilities:

Expert in design, develop and implement Reports using BI Publisher tool.
Expertise in using Oracle Data Warehouse Administration Console (DAC).
Expertise in Design and implementation of Star Schemas, Fact tables, Dimension tables, ETL processes.
Experience in Extraction, Transformation and Loading of data from multiple sources to Data Warehouse using Informatica Power Center Tool.
Experience in Pentaho Design tools like Pentaho Data Integration(PDI) and Report Designer.
Experience in Siebel CRM Marketing Applications and Siebel Marketing Analytics.
Good Functional and Technical knowledge and understanding of Oracle E-Business Suite Financial/SCM/CRM and PeopleSoft HCM/FSCM data models for OBIEE Reporting.
Expertise in writing SQL Scripts, developing Functions, Procedures, Packages, Triggers, Views and other Database Objects using SQL, PL/SQL.
Strong Analytical, Interpersonal, Communication skills and excellent Team player.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship