Home

Madhu - OBIEE/OBIA Consultant | H 1B - He is Open to relocate !!

[email protected]

Location: Novi, Michigan, USA

Relocation:

Visa: H 1B

Skill Set: OBIEE/OBIA Consultant Name Madhu Years of Experience 10+ Location with zip code Novi, MI 48375 Relocation Yes Availability Immediate Visa Status H1b Madhu Sr. OBIEE/OBIA Consultant [email protected] 732 339 3471 SUMMARY: 10 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse/ Data Marts and Business Intelligence. Good understanding of all phases of Software Development Life Cycle SDLC including Business Requirement Analysis, Development and Testing. Extensive Data warehouse development experience using OBIEE/ Siebel Analytics, BI APPS, Informatica, Oracle Data Integrator ODI, BI Publisher, Oracle 12c/Exalytics 11g, 10g, SQL/PLSQL. Experience in Business Intelligence and Transactional applications, Design and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling. Hands on experience in the Data Modeling, Meta Data Development, BIAPPS Implementations and Testing of OBIEE/BIAPPS Functionalities Expert in working with OBIEE administration tool in developing RPD with Working on Advanced concepts like aggregated tables, fragmentation, time series functions security privileges. Developed many Reports / Dashboards with different Analytics Views Drill-down / Dynamics, Pivot table, Chart, Column Sector, Tabular with local and global filters using Analytics. Experience in writing and modifying Design documentation, technical requirements analysis, test results documentation and standard operating procedures SOP documentation. Developed packages by using ODI interfaces, procedures, variables alongside working on all three layers of the OBIEE repository to facilitate end user reporting. Experience in Creating Dimensional modeling of STAR, SNOWFLAKE schemas in OLAP and customizing Fact and Dimension tables as per the user requirements. Created and scheduled OBIEE IBOT's to be delivered to key business users in various function areas. Experience in ESP (Enterprise Service Platform) Sate Street exclusively built platform and complete data modeling techniques and standard information delivery system to business clients. Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently. Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions and effectively manage client expectations. Created interfaces, Procedures and Packages, generated scenarios using Oracle Data Integrator Designer. Experience in Dimensional data modeling, Banking Domain, Investment Banking and Agile Development approach. Actively involved in business-related project milestones such as in Requirements Gathering, Data modeling logical and physical design of databases, Business Gap Analysis, Unit/Integration-Testing, Data Migration, User Training, and System Maintenance. Good Programming Skills using Shell Scripts and PL/SQL Coding Procedures, Functions, Database Packages and Triggers for Automation of ETL Process. Expertise in Cache Management, Performance tuning at report level and database level. Experienced in deploying Informatica workflows to the DAC configure, monitor and schedule ETL routines and created dependent Hierarchical tasks. Responsible for conducting interviews with stakeholders to gather requirements, perform data analysis to design ODI interfaces from multiple source systems. Optimized solutions using various performance tuning methods SQL tuning, ETL tuning i.e. optimal configuration of transformations and memory parameters, Database tuning using Hints, Indexes, partitioning, Materialized Views, External Table, Procedures, functions etc. Keywords: business intelligence procedural language Michigan