Result Oriented IT professional with around7+ years of progressive expertise in analyzing the requir...
Result Oriented IT professional with around7+ years of progressive expertise in analyzing the requirements, application design, development, testing and a comprehensive background in Database development, RDBMSData Warehousing, ETL and Oracle Business Intelligence10G/188.8.131.52.8 • Expertise in developing Business Intelligence Solutions, gathering Business Requirements and implementing them using BI Tools such as SiebelAnalytics/OBIEE. • Extensive experience in OBIEE Administration Tool, OBIEE Answers/Analysis, OBIEE Intelligent Dashboards, BI Publisher, Delivers and iBots/Agents with OBIEE Applications. • Proficient in building business models,configuring metadata, Answers, Delivers / iBots, generating analytical reports, cache monitor, and building Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer) . • Experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), MetadataObjects and Web Catalog Objects (Dashboard, Pages, Folders and Reports). • Building of RPD application design for Physical, Logical (BMM), and Presentation layers, configuration of those layers, development of Reports, Dashboards, BI Publisher, and integration to Microsoft suite of tools, testing, and deployment • Thorough knowledge in Data Warehousing Concepts with expertise in ETL methodology for supporting data extraction, loading and transformation processing using Informatica Power Center. • Experience in tuning Informatica Mappings, Sessions and SQL queries for better performance. • Hands on experience in all phases of Data Modeling – Conceptual, Logical and Physical modelingusing tools likes ERWINand MS Visio. • Designed Star schemas, Snowflake schemas for Data Marts and DataWarehouse. • Expertise in debugging and optimizing the Oracle BI / Siebel Analytics Dashboards / Reports and Informatica Mappings / Workflows. • In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies. • Good Knowledge and experience in various databases like Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, TOAD,PL/SQL, SQL and SQL Developer. • Developed Mappings and Workflows with Worklets and Tasks using various Transformations for Informatica to feed data from multiple sources to data warehouse. • Proficiency in Informatica Designer Components (source analyzer, warehouse designer, mapping designer, mapplet designer, transformation developer, workflow manager and workflow monitor) • Good understanding of Software Development Life Cycle (SDLC). • Excellent communication, leadership, analytical, trouble-shooting, problem-solving and motivation skills. • Ability and aptitude in scheduling, tracking and prioritizing activities in order to meet user requirements in a timely and efficient manner. TECHNICAL SKILLS: RDBMS Oracle 7.3/8i/9i/10g/11g , MS SQL Server 2000, 2005 , DB2, MS Access ETL Tools Informatica Power Center 8.6/ 8.2/7.1.4/5.1, Informatica Power Mart 5.0/4.7 OLAP Tools Siebel Analytics 8.1.1/7.8.2/7.7.1/7.5.2, OBIEE 10.1.3.4, 10.1.3.3 /Oracle BI Publisher /Delivers (iBots). Data Modeling Tools MS Visio,ER Studio,Erwin Languages/Utilities C, C++,Java, SQL, PL/SQL, HTML,Toad, Java Script, VB Script Operating Systems Windows XP/00/NT/98/95, Linux, UNIX (Solaris)
* Click the button to send an offerSend offer