Home

Madhukar - OBIEE Developer

[email protected]

Location: Novi, Michigan, USA

Relocation:

Visa: H1B

Madhu Sr. OBIEE/OBIA Consultant 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 OAC/OAS/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 Oracle EBS 11i on GAP Analysis, process mapping, implementation and configuration of Oracle Financial Modules including GL, AP, AR, OM, FA, CE. 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 using SSIS tools such as Package Installation, import and export wizards and SSIS Package 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. TECHNICAL SKILLS: Reporting Tools OAC 7.1.0, OAS 5.5.0, OBIEE 12.2.1.1, OBIEE 11.1.1.7, OBIEE 11.1.1.6, OBIEE 11.1.1.5 OBIEE 10.1.3.x, ODI 11g/10g ; OBIA 7.9.6.1, 7.9.6.2, 7.9.6.3, OBIA 7.9.6.4. Databases ORACLE 12c, 11g/10g/9i/8i, SQL Server-2005/2000/7.0/6.0, DB2, MySQL, Teradata V2R6, EBS 11i. Programming SQL, PL/SQL, UNIX Scripting. Data Modeling Dimensional Data Modeling, Star Schema, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin7.1/ 4.x, ESP Meta Data Modeling. ETL Informatica Power Center9.1/8.6.1/8.1.1, DAC 7.9.x, SSIS, ODI & ESP. Operating Systems Windows 98/NT/2000/XP/7, MAC, Server 2003/2007, UNIX, MS-DOS. EDUCATION & DETAILS: Bachelor s in Engineering (Computer Science & Engineering), JNTU, HYD, India, 2008. PROFESSIONAL EXPERIENCE: E*Trade, Arlington, VA Nov 2020 - Till Date Role: OAC/OAS-OBIEE Developer E*Trade is a pioneer of online trading for retail investors which is a part of Morgan Stanley. LHRB Agile Dev. Team serves Business Intelligence solutions to both HR and Financial users. It holds a variety of ad-hoc and BI Publisher reports. Worked with complete Software Development Life Cycle SDLC, from gathering requirements, develop, deploy and document requirements. Involved in planning and delivering GL and reporting module including defining the calendar, security, roll up groups, journal categories etc; Created Answers reports .Demonstrating expertise in Oracle BI Server, Oracle BI Answers, Oracle BI Interactive Dashboard, Oracle BI Publisher, and Oracle BI Delivers. Created dim tables, hierarchies, aggregations, logical columns, calculations in the BMM layer. Created hierarchies, complex joins and foreign joins, initialization blocks for session variables and presentation variables. Analyze partitions, fragmentations, calculations, aggregates, and slowly changing dimensions. Create dashboard prompts, customized and Ad Hoc reports. Prepared the web cat and repository. Created security groups and application roles. Migrated Weblogic Server applications from existing version to OBIEE 11g and 12c to OAS and OAC. Involved in troubleshooting and fixing day-to-day problems of the applications in production, production-Fix and testing environments. Coordinated with business users in understating and implementing the security feature. Using Object level and Data level Security. Administered MUD RPD, reviewed developers RPD development before merging into MUD server. Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements. Created ODI Packages, Jobs of various complexities and automated process data flow. Used ODI Operator for debugging and viewing the execution details of interfaces and packages. Documented processing times for each module, developed test cases and used them to run through each process. Environment: OAC 7.1.0,OAS 5.5.0, ODI, OBIEE 12.2.1.1.0 & 12.2.1.3.0, OBIA 11.1.1.8.1, Oracle 12c. Health Care Service Corporation, Chicago, IL Oct 2019 Nov 2020 Role: OBIEE Developer HCSC is a member-owned insurance company and a mutual legal reserve company which offers a wide variety of health and life insurance products and related services through its operating subdivisions and subsidiaries. Financial Ops Billing holds a list of ad-hoc and BI Publishers Business Intelligence reports for them usage to Sales teams, claims team and other expert decision makers to make business decisions based on sales history and claims History. Worked extensively on OBIEE Architecture and Administration Successfully implemented cluster/standalone OBIEE 10g/11g solutions on Windows and Linux platforms. Worked on multiple OBIEE upgrade projects Worked on implementing projects for Enterprise Data Warehouse and Operational Reporting using OBIEE Worked on Enterprise Data Warehouse, Data Marts Developed and maintained data warehouse/BI solutions through the entire project life cycle Developed and created OBIEE- RPDs, BI Analysis, Dashboards, Alerts, Agents and BI Publisher reports Worked on migrating RPD files and Web Catalogs across different environments. Developed Multi User Development MUD standards for OBIEE Worked on developing BI Publisher 11g reports from Oracle Golden Gate replicated tables in ODS for Enterprise Operational Reporting needs. Worked on providing SSO access to BI Publisher reports on OBIEE dashboards. Worked on Performance tuning of several existing reports in OBIEE. Exclusively worked on creating and updating indexes in the source DB tables thoroughly understanding the explain plan. Worked on privileging OBIEE write-back for front end users. Creating multiple OBIEE variables in RPD including Repository, Session and Presentation variables. Created SSIS packages using SSIS designer and exported data from Oracle to SQL server. Created SSIS reusable packages to extract data from multi formatted flat file. Environment: OBIEE 12.2.1.1.0 & 11.1.1.9.0, Oracle 12c, MS SQl. Bayer Healthcare, Shawnee, KS Nov 2017 Oct 2019 Role: Lead OBIEE Developer Animal Health- Bayer Commercial Operations Team provides sales history, commissions and warehouse stocks using OBI reports to its sales representatives, regional sales managers, veterinary clinic and retails based on Companion, Farm and Poultry animals. Consumer Health- Support existing several OBI objects based on sales history, warehouse stocks etc. Responsibilities: Work with complete Software Development Life Cycle SDLC, from gathering requirements, develop, deploy and document requirements. Support, Enhance, Design and Implement custom business intelligence solutions Metadata and Dashboards/Reports using the Oracle Business Intelligence OBI Analytics platforms (OBIEE 12.2.1.1.0 & OBIEE 11.1.1.9.0). Analyze and validate the Oracle BI Repository by performing consistency check as the Oracle best practice. Develop custom Ad-hoc Reports using OBIEE Answers and assign them to application specific dashboards. Created groups and users to manage the Security Privileges for each subject area in RPD and Dashboards following user requirements. Create/ Customize Reports Drilldown, Aggregation to meet client requirements. Develop reports using multiple views like Pivot, View Selector, Chart View and Gauges. Implement data and object level security based on the business requirements through External table. Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Creation / Re-building of Indexes and managing Cache etc. Maintain effectiveness in creating the dashboards through guided Navigational links leading to further detailed reports. Created and scheduled IBOT's for delivering personalized reports to users. Perform Unit, Integration and Regression testing to validate report and mapping functionality. Defined ETL architecture for integrating data at real time and batch processing to populate the Warehouse and implemented it using Oracle Data Integrator Enterprise Edition 11g. Support in full legacy to ODI data conversion and Integration task Translated business requirements into technical specifications to build the Enterprise Data Warehouse Environment: OBIEE 12.2.1.1.0 & 11.1.1.9.0, Teradata 15.10.07.31, Teradata SQL assistant, ODI 11g/10G. Sodexo, Buffalo, NY Jun 2017 Nov 2017 Role: Sr. OBIEE Developer OMD Reports/ Supply Chain Management Metric Reports usage by Sodexo and its clients to track and assess the status of supply business process. Conversion, Enhancement & Implementation of existing Hyperion reports from Essbase cube to OBI reports from RDBMS be Sodexo Information Management Team. Responsibilities: Worked on requirements gathering of the various work streams by meeting with the business user and base lining the details. Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g. Worked with OBIA RPD, making use of the existing physical/logical objects, creating reports based on pre- built RPD. Created Dashboard prompts and advanced filter criteria. Created new connection pools for different data sources and designed from the scratch (physical, business model and presentation). Created major and important dashboards like Customer Profitability from the scratch. Built priority reports like Monthly Net Sales, Customer Profitability, Funds Details, and Credit Summary. Utilized features like dashboard prompts, pivot tables, column selector, drill down, hierarchy. Configured Web Catalog Objects (Dashboards, Pages, Folders, and Reports). Implemented various Repository Variables and System Variables depending up on user requirements. Extensively worked on Informatica PowerCenter 8.6 tools Designer, Workflow Manager, Workflow monitor. Designed and developed complicated/complex reports. Tuned the performance of the reports by creating various types of indexes wherever appropriate. Configured MUD for OBIEE Tool Used existing data from Hyperion Essbase for analysis. Environment: OBIEE 11.1.1.7.1, Oracle BI Publisher, BI APPS 7.9.6.3, Oracle 12c/ Exalytics, SQL Developer, TOAD. Harvard University/ HBS, Allston, MA Nov 2016 - May 2017 Role: Sr. OBIEE Publisher Developer HBS Alumni Records - Office of External Relations through ERBI Team needed migrating the existing Hyperion Alumni Reports to pristine XML BI Publisher reports for them usage by both HBS and its Alumni s. Donor Relations - HBS also required BI Publisher reports to be built for HBS Funding and Giving s History so the donors have the chance to view into funding and HBS Newsletter for client. Responsibilities: Worked with complete Software Development Life Cycle SDLC, from gathering requirements, develop, deploy and document requirements. Create BI Publisher reports by selecting an Analysis request and/or Data model as Data Source. Customize HBS Alumni funding history reports, Solicitations and Donor Relations reports using XML/BI Publisher. Document the requirements and implement design solution for BI Architecture. Design and Implement OBIEE object level security using custom roles and privileges and row level security based on client requirement. Created hierarchies, complex joins and foreign joins, initialization blocks for session variables and presentation variables. Analyze partitions, fragmentations, calculations, aggregates, and slowly changing dimensions. Create dashboard prompts, customized and Ad Hoc reports. Create ibots/intelligence Agents and audit differences delivered to dashboard. Work upon complex mapping using transformations namely aggregator, router, sequence, stored procedures, external procedures, expressions etc. Develop Reports / Dashboards with different Analytics Views Drill-down / Dynamics, Pivot table, Chart, Column Sector, Tabular with local and global filters using Analytics. Performance Tuning of Dashboards, Reports and make changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc., Create different types of Customized Reports Drilldown, Aggregation to meet client requirements. Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Creation / Re-building of Indexes and managing Cache etc. Environment: OBIEE 12.2.1.1, BI APPS 7.9.6.3, Oracle EBS R12.1.1, Oracle 12c, Oracle BI Publisher. State Street Corp., Quincy, MA Oct 2015 - Nov 2016 Role: Sr. OBIEE/OBIA Developer IMS Agile Team - State Street s ESP (Enterprise Service Platform) provides complete middle and back office solution to business client, managers and asset owners giving a customizable, dynamic and scalable self-service platform complete enough to provide end to end middle and back office information delivery. OBIEE was used to provide State Street with the market statistics information for investments and demo reports for marketing new clients into the data model. Responsibilities: Worked on requirements gathering of the various work streams by meeting with the business user and base lining the details. Created Reports, prompts and Filters using OBIEE 11g. Responsible for setting up, installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration. Created groups and users to manage the security privileges for each subject area in RPD and dashboards following user requirements. Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards. Analyzed and validated the Oracle BI repository by performing consistency check as per the oracle best practices. Created saved several BI Publisher reports by selecting an Analysis request as Data Source. Created Reports with graphical representation such as Bar charts, pie charts. Involved in managing appropriate Security privileges on subject areas and dashboards following business requirements. Created different types of Customized Reports Drilldown, Aggregation to meet client requirements. Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Creation / Re-building of Indexes and managing Cache etc. Customized the repository with new custom functionally and developed new Reports / Dashboards with different Analytics Views. Created proactive agents IBOT'S and interactive Dashboards to alert the business teams about business changes. Formatted the Reports as per the Client requirement. Performed Unit, Integration, and Regression testing to validate report and mapping functionality Created bookmark Link, Prompted Links and Saved Customizations. Exclusively worked on extract generation, extract event setup, Extract Tolerance checks and setup manual and auto extract generations. Exclusively worked with Infra-team to set up Auto-sys jobs, Message Queue setup and channel setups. Developed and Modified Interactive views (IV s) making functional data available for the Business users and State Street s Demo ESP model. Participated in complete project life cycle starting from vendor selection process in the foundation releases, worked successfully on multiple cross functional back to back quarter releases. Involved in project planning and complete execution, Hosted status biweekly meetings with the IT teams and reported management teams. Created dashboard pages and sections. Proficient in Importing Schemas to Database, Creating Map Viewer Data Source, Installing & Configuring Map Builder Created Color styles, Marker styles, Text styles, Base map, Tile Layer, State Themes and City Themes. Integrated Maps with OBIEE. Performance Tuning of Dashboards, Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc., Environment: OBIEE 11.1.1.7.1 & 12.2.1.1, BI APPS 7.9.6.3, Oracle EBS R12.1.1, Oracle 11g, Oracle data integrator 11.1.1.6, DAC, TOAD, Oracle BI Publisher, ESP. Houghton Mifflin Harcourt, Boston, MA Jan 2014 - Sep 2015 Role: Sr. OBIEE/OBIA Developer HMH is an educational and trade publisher of technology and textbook materials in United States for young and adult readers. Literacy Team used Business Intelligence over the Data Warehouse to provide analytical reporting to HMH managers. BI Reports & Dashboards were built for executive reporting about sales, services and warehouse. Responsibilities: Developed packages by using ODI interfaces, procedures, variables alongside working on all three layers of the OBIEE repository to facilitate end user reporting. Involved in overall SDLC lifecycle of the project in all stages right from the Analysis, requirement gathering, design & development reporting requirements. Developed reports, dashboards, standard filters and prompts using OBIEE 10g, OBIEE 11g. Created dashboard pages and sections. Designed dimensional hierarchies, materialized views and aggregate tables to support the reporting system. Designed Star schema for Fact/ Dimensional tables and created alias for the dimension and fact tables when necessary. Configured the LDAP to OBIEE for Authentication and Audit for Fusion Middleware. Performed Consistency check and Global Consistency check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices. Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Creation / Re-building of Indexes and managing Cache etc. Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Creation / Re-building of Indexes and managing Cache etc. Developed reports using multiple views like Pivot, View Selector, Chart View and Gauges. Implemented and developed the migration plan for moving the repository and web catalog from DEV to UAT and PROD. Implemented data and object level security based on the business requirements through External table. Created Reports, prompts and Filters Created Reports with graphical representation such as Bar charts, pie charts. Implemented aggregated tables, Fragmentation Partitions, Time Series Functions Security privileges for better performance and security measures. Created and scheduled IBOT's for delivering personalized reports to users. Developed Java classes that used JMS to communicate with the Queue managers. Environment: OBIEE 11.1.1.7.1, Java, JDK, Oracle BI Publisher, BI APPS 7.9.6.3, Oracle EBS R12.1.1, Oracle 11g, Informatica 9.x, DAC, TOAD. SUNY RF, Clifton Park, NY Sep 2012 Dec 2013 Role: OBIEE Developer The project involved creating business intelligence solutions for the various work streams, by comparing data from various sources and then consolidating them at the report/dashboard level. Responsibilities: Worked with Business Users, Involved in Discussing and Gathering the Analytics requirements from different user groups. Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the Oracle Business Intelligence OBI Analytics platform. Installed and configured the OBIEE 10.1.3.2 on servers and dealt with the installation issues. Designed and Developed OBI Repository at three layers i.e., Physical Layer connecting to Data Warehouse imported objects with joins, Business Model / data mapping create Logical tables, Drill-Down Hierarchies complex joins, and Presentation Layer level create presentation catalogs, create presentation folders, test and validate the model. Responsible for creating custom columns in the BMM layer to calculate the percentage changes in the sales using inbuilt functions and expressions. Identified Facts, Dimensions Hierarchies of the Business Model. Developed Time Series object for comparing between the annual and quarter sales. Implemented the variables in the repository to import them in the presentation layer. Actively resolved all the issues in the development process to satisfy the client's best requirements. Developed the ANT scripts for preparing WAR files used to deploy J2EE components. Implemented Security by creating roles web groups, checks with External tables. Set-up Security using SSO Authentication. Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns. Setup the visibility of dashboards to employees with respect to their responsibilities Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance. Used DAC Data Warehouse Administration Console Client to manage, configure, customize, and monitor ETL process. Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc. Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc. Environment: OBIEE 10.1.3.2, Informatica Power Center 8.1.1, Flat files, Oracle 10g/9i, MS SQL Server 2008, DB2, PL/SQL, UNIX Shell Scripting, TOAD, Core Java, J2EE, Windows NT. Keywords: business intelligence database active directory information technology container edition microsoft procedural language Arkansas Illinois Kansas Massachusetts New York Virginia