An accomplished, results-oriented BI Tech Lead with 15+ years of experience directing large scale projects. * Experience in gathering Business Requirements, Developing Business Intelligence Program strategies, designing & implementing Business Intelligence information & analytical solutions. * Excellent understanding of data sources like Flat File, Oracle DB, Oracle EDW, MS-SQL Server, MS Access. * Expertise in Data Warehousing development using ETL tools such as Informatica Power Center 9x and ODI 12c. * Good experience in developing Informatica Mappings/Mapplets and Workflows with Worklets & Tasks using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure and Lookup) for ETL of data from Multiple Sources to Data Warehouse. * Extensive experience in ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Informatica and designed data conversions from wide variety of source systems including Mainframe/DB2, Oracle, SQL server, Hive, Flat files, and unstructured data files. * Expertise in developing ETL process with PL/SQL: packages, procedures, functions and triggers etc. * Experienced in different stages of the software development life cycle such as requirement gathering, analysis, and design, coding, and testing and experienced in data Migration projects. * Using OBIEE versions (11/12C) as a front-end BI tool and Oracle EDW as a back-end database, designed and developed RPD, Answer, dashboards, global filters and complex parameter-based calculations. * Expertise in providing end-to-end business intelligence solution by designing dimensional modeling, configuring metadata & building Analytics Repository, building business models, generating reports, creating Inter-active Business Intelligence Dashboards using Oracle Business Intelligence (OBI) EE 10.x, 11x and 12c . * Worked Extensively on Oracle BI Administration Tool, web / Presentation Services, Answers, & Interactive Dashboards and Security Implementation. * Strong in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series, Caching & Mapping. * Expertise in implementing the Oracle BI Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports). * Extensive experience in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Contextual Navigation, Business Rules with User Identity & Roles, Profiles & Personalization. * Experience in installation and configuration of OBIEE 10g, 11g and 12c. * Excellent understanding of Star & Snowflake Schema methodologies & Dimensional Modeling. * Extensively worked on Operational Data like PeopleSoft, Oracle EBS, Salesforce and POS Systems like JDE, Kronos etc., and created a sophisticated reporting structure with Fact-less Fact table. * Worked in different Industry Verticals and well experience in Sales, Finance, Order and value chain planning Marketing Functional Areas. * Very good in Debugging, Optimizing and Performance Tuning of BI Dashboards/Reports. * Excellent command over Oracle Forms/ Reports, SQL, PL/ SQL programming, which includes stored procedures, functions, packages, views, cursors, triggers, indexes, Dynamic SQL, snapshots, materialized views, table/ index partition, collection, analytical functions, Oracle UTL_FILE features, external tables, SQL Optimizer Hint, Explain Plan, TKPROF, AWR Report, SQL*Loader and SQL/ stored procedure tuning. * Multi-platform experience on UNIX / Linux and Windows Server family. * Results oriented, self starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills. * Having good knowledge of Power BI.

Highlights:

• Informatica
• Project Management
• Project Manager
• Stored Procedures
• Management
• Power (Os Enhancemnt Tool
• Data Modeling
• Microsoft SQL Server
• Modeling Experience
• Security