• Over 7+ years of experience in implementing Business Intelligence and Data Warehousing solutions...
• Over 7+ years of experience in implementing Business Intelligence and Data Warehousing solutions for various clients across diverse business segments. • Experience using Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g, Oracle BI Apps and DAC. • Around 5 years of experience with ETL Informatica Powercenter 9.0.1/8x • Experience in all the phases of Data Warehouse life cycle involving Requirement analysis, Design, Coding, Testing and Deployment. • Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER. • Worked with OBIEE Administration tool, Security, Repositories creation and management (Online and Offline ). • Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill- down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges) and scheduling iBots. • Profound experience in developing Analyses, Dashboards, KPI’s, Reports, Graphs, Filters and agents using OBIEE 10g/11g. • Hands on experience on working with BI-Publisher in OBIEE 11g. • Experience in OBIEE Security setup (users/group, access/query privileges) • Experience in OBIEE features (i.e. Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc.) • Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema). • Expertise in Working Multi User Development (MUD) environment. • Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2/Type3) loads. • Experience in different data sources like Oracle 9i/10g, DB2, XML Files, Flat Files(delimited and fixed), Mainframes, Essbase, Netezza, MS SQL Server and MS Access. • Knowledge of implementing LDAP and External Table Authentication for better security. • Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses using Informatica Power Center. • Extensively worked on Informatica Designer Components – Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer, Workflow Manager, Repository Manger, Workflow Monitor. • Developed complex mappings in Informatica to load data from various sources into the Data Warehouse, using various transformations. • Experience in different data sources like Oracle 9i/10g, DB2, XML Files, Flat Files(delimited and fixed), Mainframes, Essbase, Netezza, MS SQL Server and MS Access. • Experience in UNIX Operating System and Shell scripting. • Excellent written and oral communication, interpersonal skills and presentation skills. • Experience in working with senior level managers, business people and developers across multiple disciplines. Technical skills: Reporting Tools: OBIEE 10g/11g, BI Publisher, BI Apps ETL Tools: Informatica 9.1/8.x (PowerCenter) (Designer, Workflow Manager, Workflow Monitor, Server Manager) Data Modeling: Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Data Quality, Entities, Attributes, ER Diagrams. Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000, MS Access, Teradata and DB2 Languages: SQL, PL/SQL, C, C++, Data Structures, UNIX Shell Script, Visual Basic Web Technologies: HTML, XML, Java Script Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader Job Scheduling Tools: Autosys, Control M, CronTab Operating Systems: Windows NT/2000/2003/XP/Vista/7, UNIX, MS-DOS Others: IDQ, DB2, B2B.
* Click the button to send an offerSend offer