Naresh Kumar B Email & Phone Number

Singapore

Singapore

Singapore

• Good experience with OBIEE production support & runtime issues analyzing, monitoring and troubleshooting the jobs as a BI production support. • Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.• Formulating the ETL mappings to implement the business logic. Used transformations like lookup, update strategy, expression, filter, router, aggregate and sequence generator• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.• Mastered in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts.• In depth knowledge in Tableau, advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines.• Responsible for creating new libraries for upcoming small scaled projects to the end users in SAS Server using SAS Management Console 9 4 and have performed all admin activities like user creation, registering tables, database and server configuration and Scheduling jobs. • Worked on Hadoop File System (HDFS) to Capturing data from existing databases that provide SQL interfaces using Sqoop.• Worked on Structured and semi structured data of two TB in size (6 TB with replication factor of 3). Extracted the data from oracle into HDFS using Sqoop. Worked Sqoop jobs with incremental load to populate Hive External tables• Good understanding of Partitions, Bucketing concepts in Hive and designed both Managed and External tables in Hive to optimize performance.

Kuala Lumpur, Malaysia

Uae

Malaysia

• Involved in gathering the business requirement and completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts.• Developed Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers. Responsible for administration and migration of repositories between Development, Test (QA) and Production environments.• Configured the three layers in the OBIEE repository using the Administration tool.• Created Aggregate tables and Alias Tables for easy reporting and better Performance.• Configured iBots to deliver analytics content based on schedule to obtain weekly, Monthly reports and sent notification.

India

Key Profile: Reporting to the IT – Manager and working as an OBI Consultant for Microbumi system and services (M) Sdn Bhd .• Oracle Business Intelligence Enterprise Edition 11g Installation on Windows 7.• Creation of Data Models, Interactive Reporting using Oracle BI Answers.• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation services using Oracle BI Admin tool.• Managed security privileges for each subject area and dashboards according to user requirements.• Good Experience with OBI Delivers, created iBots and scheduled them to display alerts as well as to send the reports to the inbox of users.