Data Developer

Summary

I am working as a BI Consultant at Snuvik Technologies. I have 7+ years of IT experience in Business Intelligence and Data Warehousing for industry sectors like healthcare, Telecom and Finance. Across several functional areas like Financial, Sales and Human Resources. My core skills include Business analysis, BI solution development, analytical and reporting solution development and implementation, Enhancements, and maintenance with a range of technical skills like dashboard and reporting solution development with OBIEE and Tableau.

My professional experience can be summarized as

Building, Publishing Customized interactive reports and dashboards, report scheduling using Tableau.

Created parameters, action filter and calculated set for preparing dashboard and worksheet in Tableau.

Implementation of row level security to restrict the data for different user.

Developed tableau workbook for multiple data source using data blending.

Administration of tableau server including installation and configuration.

Upgrading Tableau server 8.x to 9.x

Create backup primary, Use back up primary

User management in Tableau.

Daily maintenance activity of Tableau like Cleanup, Back up, restore etc.

Strong knowledge of SQL package

Developed IT Wiz analytics Product in Tableau and BICS.

OBIEE platform design and implementation with multiple cluster

Finalize Architecture of OBIEE high availability environment.

Upgradation OBIEE 11.1.1.7 to OBIEE 12.2.1.0.0

Installation and configuration of OBIEE (11g and 12c)

Strong experience in OBIEE administration (Using WebLogic, EM, Unix / Linux Script)

Load plan monitoring and Troubleshooting through ODI operator.

Expertise in developing and Customizing all 3 layers of the Analytics Repository (Physical Layer,

Business Mapping and Modeling Layer & Presentation Layer).

Experienced in configuring OBIEE Reports & Dashboards, OBIEE Delivers, Narrative views.

Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.

Experienced in full life cycle system development: comprised of Data Requirement Analysis, Design,

Development, Testing, Implementation and Documentation of Business Applications.

Well versed with SDLC lifecycle processes.

Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules,

Time Series and Cache Management.

Configuring Analytics Security and creating User’s Groups and setting Privileges.

Implementation and review of BI Publisher Reports

Dimensional modelling for new DataMart.

Implementation of data level and object level security.

Implementation of writeback, usage tracking in OBIEE reports.

Ability to translate functional specifications into detailed technical design specification.

Implemented RPD Level Security, Object Level Security and Data Level Security in OBIEE.

Involved in Performance Tuning at RPD Level & Database Level.

Created the Reports in different view likes Table, Pivot, Graphs, Charts, Filter, Title,

View selector and Prompts.

Strong experience in client interaction and understanding business application, data flow and data relations.

Proven analytic, critical thinking and problem solving skills.

Experience on data warehousing concepts, ELT tool ODI.

Good in Business communication to understand the business requirement.

Additional Roles: Imparted training on OBIEE and Tableau to others. Taken Part in RFP response writing and Project Timeline estimations and Client Presentation.

Educational Qualifications

-MS in Software Engineering – San Jose State University. San Jose. CA, USA

-Bachelor of Engineering from I.G.I.T, Sarang, India

Skillsets

-BI / Data Warehousing: OBIEE 11g,10g

-Databases: Oracle (RDBMS) 9i/10g/11g, MongoDB

-Operating System: Windows 2000/XP/NT

-Software: Oracle, OBIEE, BICS, EBS R12, BI Publisher, Tableau Server

-Tools: OBIEE 11.1.1.x/12.2.1.0.0, Pl/SQL Developer, ODI, BICS, Datasync, Tableau 9.x,10.x,Oracle SQL Developer, Advance Excel

Certifications/Training

-Oracle Business Intelligence Foundation 10 Certified Implementation Specialist

-Oracle Business Intelligence Foundation Suit 11g Certified Implementation Specialist

-Tableau E2 certification from Snuvik.

Projects Summary

ITWiz and APEX

Snuvik Technologies, San Jose, CA Oct 2016 – till Date

BICS Tableau Desktop 10.x ODI OBIEE 12c RPD SQL Tableau Server Reports and Dashboard

Flagship Product of Snuvik technologies ITWiz is “A cloud based Analytical Solution for your ITSM “. ITWiz is a cloud based analytical solution that can be plugged in with Service-Now / ITSM tools to derive actionable insights.

For quick overview see http://snuviktechnologies.com/itwiz/

My responsibility involves

Working with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.

Involved in the Environment Architecture design.

Designing Architecture for Tableau environment.

Installation of Tableau server.

Administration of Tableau server.

Created backup primary, Used back up primary

Create group, Sync group with AD.

Assigning site role for user.

Migration of OBIEE ITWiz application to Tableau.

Developed IT wiz Product in tableau which source data from Service now.

Building, Publishing Interactive reports and dashboards, report scheduling using Tableau

Scheduling extracts and monitoring scheduled extract

Security implementation in Tableau.

Implementation of BICS Reports

Development of RPD and reports in OBIEE 12c.

ODI Data mapping and loading

Involve in the data modeling

Incorporated best development and Design Practice

Review of the deliverables (OBIEE and BICS) and Data validation

Involved in OBIEE Training to other team members.

Enterprise Reporting Dec 2015 – Sep 2016 Synaptics Inc, San Jose, CA

OBIEE 12c RPD SQL BI Publisher Reports and Dashboard Oracle ODI Tableau Desktop Tableau Server

Synaptics is a human interface solution developer. It develops and supplies intuitive human interface solutions for a range of electronic devices and products worldwide. Synaptics sells its solutions to original equipment manufacturers (OEMs) for applications including smartphones, tablets, notebooks, automobiles, wearables and PC peripherals.

My Responsibilities

Played BI technical lead role

Designing Architecture for Tableau environment.

Installation of Tableau server.

Administration of Tableau server.

Created backup primary, Used back up primary

Create group, Sync group with AD.

Assigning site role for user.

Building, Publishing Interactive reports and dashboards, report scheduling using Tableau

Scheduling extracts and monitoring scheduled extract

Security implementation in Tableau.

Involve in the data modeling

Incorporated best development and Design Practice

Upgradation OBIEE 11.1.1.7 to OBIEE 12.2.1.0.0

Admin Activities in OBIEE 11g and 12c.

Installation of OBIEE 12 c and ODI.

Development of Physical, BMM, and presentation layer of RPD.

Developed complex RPD model using multiple LTS, Fragmentation and content mapping

Implementation of Data level and object level security for OBIEE 12c.

Set up event pooling to automate cache purge process.

Solved critical issue for OBIEE 12c server instability.

Smart export and import of ODI scenario

Solved issue like un mapping of Physical Architecture, Logical Architecture, after migration

BI Dashboard Jan 2012 - Mar 2013

British Telecom, Bangalore, India

Reports & Dashbpards OBIEE 11.1.1.5 RPD SQL ODI SQL Tableau Desktop Tableau Server

Played BI technical lead role from Offshore.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Created parameters, action filter and calculated set for preparing dashboard and worksheet in Tableau.

Implementation of row level security to restrict the data for different user.

Developed tableau workbook for multiple data source using data blending

Have Implemented Custom data mart for service contracts to ensure service levels while preventing contract leakage by creating a single model of entitlement information that can be shared across the service organization.

Created Pending contract detail report which help to inform customers and/or agents of pending contract expirations.

Created discount analysis report to check which service contract or usage has been applied top 10 discount.

Developed OBIEE agent which will provide alert /sent mail to the customer before service contract expiry.

Involved in analysis of reports.

Maintenance of OBIEE server

Migration of RPD and Presentation catalogue

Involved in development of custom subject area RPD.

Involved in investigation of all production issues in OBI reports.

Creating new reports and dashboard.

Have Implemented data level security and object level security.

Data model design.

OBI Dashboard Feb 2010 – Dec 2011

GE Finance, Bangalore, India

OBIEE 11.1.1.5 RPD SQL BI Publisher Reports and Dashboard SQL Developer

GE Capital, is the financial services unit of the American multinational conglomerate General Electric. It provides commercial lending and leasing, as well as a range of financial services for commercial aviation, energy, and support for GE's industrial business units.

Worked as a Lead BI consultant to decide the data modelling

Involved in analysis of reports.

Created Risk detailed report by operating unit risk reason, account type and region.

Developed risk analytics as a custom component.

Involved in OBIEE upgradation

Involved in preparing mappings of all the required OBI elements starting from the Physical to the Presentation level.

Involved in investigation of all production issues in OBI reports.

Creating new reports and dashboard.

Development of RPD.

Have Implemented data level security and object level security. Created Security settings in OBIEE Admin Tool to setup groups, access privileges.

Data model design.

Created Proactive agents (I Bots) and configured Interactive dashboards.

BI Implementation Feb 2009 - Jan 2010

GE Healthcare, Chennai, India

OBIEE RPD SQL BI Publisher Reports and Dashboard OBIEE Developer

GE Healthcare provides transformational medical technologies and services helping to deliver patient

care to people around the world. The company provides medical imaging and information technologies,

medical diagnostics, patient monitoring systems, drug discovery, biopharmaceutical manufacturing

Technologies and performance solutions services.

Created/Modified Metadata repository (.rpd) by using Administration Tool Physical, Business Model and Mapping and Presentation Layers.

Developed custom dashboards and reports using Answers.

Implemented Out-of-the-box Analytics Reporting Functionality of Datamart Reporting.

Created connection pools, imported physical tables and then created Alias tables, defined joins and implemented authorizations in the physical layer of the repository.

Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics on metrics.

Developed Calculated Measures and Dimension Hierarchies and Time Series Functions in the BMM Layer.

Created logical joins between fact and dimension tables in business model and mapping layer.

Extensively used different performance tuning methods.

Developed reports and configured the Intelligent Dashboards.

Extensively used Dashboard Pages, Prompts, Sections, Dashboard Prompts including View Selector, Column Selector, Pivot Tables, Charts, etc.,

Involved in Unit Testing

Fizzback Jan 2008 – Jan 2009

British Telecom, Chennai, India

Siebel Analytics Pl/SQL Developer ADVANCE EXCEL

This project is to automate the current excel dashboard through OBI showing the Number of

orders and failed order and complete orders by EIN and Manger EIN and CCM EIN. (fragmentation, JavaScript and portal page navigation needed and logical fact used, delivers, Ibot, event pooling, data level security and object level security implementation )

Worked here as a OBI Developer.

Review the performance of reports.

Involved in data analysis and Functional Design

Created Order Summary report which shows Order count by category and region.

Created Order detailed report which enables user to drill down from summary and shows details.

Advance Excel Techniques & Data Management (Pivot Tables, Data Validations, Sorting, Filtering What-if-Analysis, subtotaling, Grouping, Solver,Functions like sumifs, countifs, Lookup, SQL, VBA Macros and automation, preparation of MIS.

Created Failed order detail which shows the reason for the order has been failed

Development of OBI reports and dashboard

Contact this candidate