Home

MADHU - OBIEE LEAD BI DEV (PMP CERTIFIED)

[email protected]

Location: Everett, Washington, USA

Relocation:

Visa: H1B

Employer : [email protected]; [email protected]; (609) 778-4215 ext 1000 MADHU PMP Certified SUMMARY: Around 18 years of experience in gathering Business Requirements, assessing & developing Business Intelligence Program strategies, and designing and implementing Business Intelligence information & analytical solutions. Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications. Strong experience in Data warehousing and OLAP tools using Siebel Analytics 7.8.2, Oracle BI(OBIEE) 10g/11g/12C, OBIA 7.9/10.X, OACS, OAS,OIC,OTBI,Power BI, Tableau and ETL/ELT tools using Informatica Power center 6.x/7.x/8.x, Oracle Data Integrator (ODI)11g/12C. Strong Experince in developing BI Publisher Reports. Expertise experience in OBIEE with in-depth knowledge on Oracle BI Server Administration, RPD, Oracle BI Answers, Oracle BI Interactive Dashboards, Oracle BI Publisher, Oracle BI Delivers, Data level and Object level Security. Strong Experience in Building Reports using Power BI. Hands on Experience on Tableau Desktop Versions 7/8.2,Tableau Reader and Tableau Server Empowered Business teams with efficient solutions by integrating Power BI with Various Data Sources. Good experience of having worked with ELT Tool ODI against different databases Oracle (11g), MS SQL Server (2005, 2008) and MS Access. Good experience on ELT Tool ODI Navigators like Designer, Topology, Operator and Security Navigator. Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager. Strong experience in Dimensional Modelling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modelling. Good experience in all modules of Oracle Data Integrator like Topology Manager, Designer, Operator. Strong Experience in Extracting Data from various Applications like Siebel CRM,Oracle EBS. Having good Experience in Informatica and DAC (Data warehouse Application Console) like Configuration of Informatica, task creations and assigning dependencies for the task in DAC. Well versed with SDLC life cycle process with Agile and Waterfall Methodologies. TECHNICAL SKILLS: Business Intelligence Tools Siebel Analytics 7.8.2, OBIEE 10.x,11.x,12.x, OACS,OAS, OBIA, Power BI, DAX, Power Query, Tableau, Business Objects 5.x, 6.x, XIR2, QlikView ETL Tools Informatica Power Center 9.x/8.x/7.x/6.x,ODI 11g/12c Tools Toad, SQL Developer, SQL*Plus, DAC (Data Warehouse Application Console) RDBMS Oracle10g/9i/8i, Siebel CRM, Oracle EBS, MS Access Operating System Windows Family, Unix Domains Sales and Service, Call Centre, Financial, Marketing, Supply Chain, Manufacturing CORE STRENGTH: Data Analysis, Mapping & Modelling. IT Process and Best Practices. Solution Designing. Client & Stakeholder Relations. Leadership. Customer-Relationship Management. Business Intelligence. EDUCATIONAL DETAILS: M.Sc. in Computer Science from Andhra University, India in 2004. B.Sc. in Computer Science from Andhra University, India in 2002. PROFESSIONAL EXPERIENCE: Client: Niagara Bottling Inc, CA July 2023 - Till Date Role: Lead BI Developer Description: Niagara has various report systems and we have recently Implemented OACS to make it as Enterprise Reporting System. As part of this process, we have implemented Various Projects such as Migrating Reports from Cognos to OACS, Power BI to OACS and Migrating Informatics Mappings to Oracle Data . Also, we have enabled lot of out of the box subject areas for different departments like for Finance, Supply Chain, Asset Management, Manufacturing etc. Responsibilities: As part of this implementation, I have been taken the lead on the below initiatives. As a Lead BI Developer, managing Reporting team and assign tasks and make sure the deliverables on the time. Apart from Lead, I also contributed developing/migrating reports to OBIEE/OACS from Cognos/Power BI. Enabled OOTB OBIA modules like finance, supply chain. Worked with ETL Team to Convert all mappings from Informatica to ODI. Converted reports from Cognos to BI Publisher. Developed BI Publisher Reports using various data sources. Created Reports in OTBI for Finance and OTM Modules in Cloud. Developed New ODI Mappings as per Business Requirement to cater the needs. Developed Various Data Sets and Data flows to get the data from multiple sources using OACS DV. Also supporting Various departments who are using Power BI Reports to fix any issues/Building New Reports. Expedited the designing process of interactive dashboards and systemized reports with Power BI, reducing production time by 30% Implemented advanced DAX queries in Power BI desktop, providing detailed insights and enabling significant better performance. Improvised ETL methodologies using SQL and ETL/ELT to import data into Power BI, resulting in a significant boost in data reliability. Client: Darigold Inc, WA August 2017 - July 2023 Role: BI Lead (Full Time) Project: Product Profitability Description: Darigold has BI Apps environment with OBIA 7.9.0 with Informatica version 9.X and it s in the process of implementing the latest pre-built Oracle Datawarehouse solution (11.1.1.10.1). As part of this implementation, the following OTB (Out of the Box) application modules have been installed and configured. And as part of the upgradation process we have upgraded/migrated all BI Reporting tools to latest OBIA/OBIEE and to make one single enterprise Reporting pprocess, in Darigold. Financial Analytics (GL, AR, AP, FA) Supply Chain (OM, Inventory) Procurement (Purchasing) OPM Transportation Management Analytics As part of implementation Projects, I have been taken the lead on the below initiatives. BI Consolidation: As part of this project, we have Migrated all BI Reports/Dashboards from the OBIEE older version to OBIEE 12C version. Worked on upgrading OBIEE12C to OAS Due to Oracle not supporting OBIEE 12C Migrated all Custom ETL mappings from Informatica to ODI. Enabled OOTB OBIA modules like finance, supply chain, order management. Converted all custom loading process to ODI Interfaces. Transportation Management Analytics: Since the OTM data is not available in our new unified enterprise data warehouse, we have worked on this project to extract the data from the cloud to on-premises DWH. Used BI Publisher approach to extract the data from cloud to on-premises DWH. Developed Reports in OTBI from OTM Cloud. Oracle EBS Upgrade to Fusion Cloud: Upgrading all ETL Mappings to ODI12C to support the data coming from Fusion. Used OIC to extract data. Responsibilities: Development of Metadata in OBIEE Repository. Performing Lift and shift from 11g to 12C/Cloud. Supporting existing BI Apps with Informatica. Implemented ODI Interfaces. Upgraded from OBIEE 11G to 12c. Upgraded from OBIEE 12C to OAS. Creating Data Visualizations using Oracle DV Desktop. Migrated Informatica to with ODI. Developed P&L reports for monthly statements. Supporting Power BI Reports and developing new reports as per Business Requirement. Client: Gilead Life Sciences, CA September 2016 August 2017 Role: Sr. Informatica/BI Consultant Project: Finance Recon Description: To enable FP&A to continue headcount reconciliation reporting using Hyperion and Workday (using HRA 2.0) reporting solution .OBIEE as the reporting solution and Informatica as the ETL Tool for getting the data from Two different data sources like Hyperion and Workday and designed the OBIEE metadata repository as per the reporting requirements. Responsibilities: Involved in gathering requirement from Business Users. Involved in BRD's and Technical Design Documentation. Coordinate with application team and develop all ETL processes. Develop mappings and workflows as per provided requirements. Perform the Unit Testing on developed code. Build reports and dashboards. Environment: OBIEE 11.1.7, Oracle 11 G, Informatica 9,Hyperion,Workday. Client: Fidelity Investments, Durham, NC June 2015 October 2016 Role: Sr. ETL and BI Developer Project: FMDB Reporting Description: Migrating the Existing customized reports which are built in .net applications to the OBIEE Reporting. Responsibilities: Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor. to design the business process, dimensions and measured facts Design and Building the Data model for OBIEE reports. Developed reports using BI Publisher using rtf templates. Created various Informatica mappings and corresponding workflows to load the data from source to the OBIEE Target tables. Developed technical specifications of the ETL process flow. Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse in Oracle. Involved in Developing BI Publisher reports in OBIEE 11g Developing of OBIEE Repository Environment: Oracle BIEE11g, Informatica 9,Oracle 11g. Client: CIMB Bank, Malaysia December 2010 - December 2014 Role: Sr. ETL/BI Developer Project: 1View-Reports Description: CIMB is a Leading MNC Bank prominent in Malaysia, Singapore, Thailand, and they are aggressively expanding its operations in Malaysia. The Bank uses various legacy systems in their day-to-day transactions. To improve the efficiency, they are implementing the 1view application using Siebel and building the reports in OBIEE. Responsibilities: Involved in requirement gathering from business user and finalize of the User requirement specification . Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports. Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules. Customized out of the box Financial Reports for Investment Banking. Design and Building the Data model for OBIEE reports. Developed technical specifications of the ETL process flow. Invlolved in Developing BI Publisher reports using I/O process in OBIEE 10g Developed BIP Reports in OBIEE 11g. Implemented data and object level Security in OBIEE. Developed Mappings to extract data from Siebel CRM into DWH. Created tasks for the Informatica mappings in DAC and created execution plan in DAC to schedule the Informatica Jobs automatically from DAC. Environment: Oracle BIEE10g,11g,BI Apps, Informatica, DAC, QlikView Oracle 10g,Siebel CRM. Company: Hitachi Consulting (Formerly Sierra Atlantic Software Services) Apr2007- August 2010 Role: Sr OBIEE Developer Responsibilities: Gathering of Report requirements and involved in Building the Data model for OBIEE report. Worked with Oracle Procurement and Spend Analytics and Oracle Financial Analytics. BI Apps/OBIEE/Informatica/DAC/OBAW implementation of Oracle Financial Analytics. Subject Areas: General Ledger & Profitability Analytics, Payables Analytics, Receivables. Analytics, VP of Finance & CEO, Profitability of biz units, meeting goals, early warning on revenue misses, improvement based on trends, Results-qtr. over qtr., Operating expense. mgmt., Headcount & Product Costs Extracting data from source tables to the staging tables Developing of OBIEE Repository. Building the reports and Dashboards. Implemented Security. Monitored the daily Incremental Load in Production environment and fix any issues during the Load. Created Custom Mappings in ODI (Oracle data integrator) to Load the Source Data from Oracle database. Environment: OBIEE/OBIA,ODI 10g, Oracle EBS, Oracle 10g/11g. Company: Polaris Software Labs, India March 2006 March 2007 Client: Citigroup, USA Role: Developer Description: The Siebel eBusiness Data Warehouse is an online analytical processing (OLAP) database, which allows you to selectively extract, analyze, and view data. The OLAP schema was designed using star schema modelling techniques to support the analysis requirements of Siebel Analytics. OLAP data is stored in a relational database that considers each data attribute (such as product, account, and time period) as a separate dimension. We use Informatica Power Center to extract data from our existing Siebel database to create a multidimensional OLAP database for Siebel Analytics. An OLAP database does not contain every piece of data stored in a transactional database, because not all transactional data is needed for analysis. Responsibilities: Support Siebel Analytics applications to ensure system is available 24/7. Providing solutions to the issue tickets raised by the end users. Worked on the new enhancements requested by the users. Preparing documentation for the issues with the resolutions. Providing immediate resolutions for severity1 issues within an hour. Environment: Siebel7, Siebel Analytics 7.8.2, Informatica 6, Windows NT, Oracle10i. Keywords: business intelligence information technology microsoft Arkansas California North Carolina South Carolina Washington