OBIEE, Tableau, Data Warehousing, RPD modeling, BI reporting

Thiyagarajan Panchalingam

*******.************@*****.*** 732-***-****

Summary:

Have 9 years as BI Developer with extensive experience in OBIEE & Tableau, helping organizations in their BI journey.

Extensive hands on experience on designing and building OBIEE Reports and Dashboards.

Detail experience on stake holder management and playing the Business/IT alignment

Seasoned professional on leading requirement gathering, stake holder interviews, UAT preparation, prototype design, wireframe design and BRD Preparation

Extensive experience in data warehouse design, maintenance, data loading, Real time and OLAP reporting.

Excellent experience and highly recognized in playing the role of Business Analyst and SME to provide optimal value adding business solutions.

Worked on OBIEE RPD and Web Catalog Administration. Have good understanding of setting up authentication and authorization for users and groups. Deep understanding of working on EBS OLTP and OLAP models.

Have excellent skills in OLAP/ BI Tools – OBIEE, BI Publisher, Siebel Analytics, and DAC. Expertise includes design and development of Standard/Ad-hoc Reports & Dashboards using OBIEE suite.

Expertise and demonstrating prolific level of achievement in OBIEE Dashboards & Reports development, data warehouse design, maintenance, data loading, Real time and OLAP reporting

Extensive experience in working closely with business in BI domain for multiple Manufacturing and Logistics fortune 500 clients.

Experience working on Tableau 9.x (Desktop, Server, Reader), creating various Reports and Dashboards using different functionalities. Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

Experience in design and setup BI standards, best practices and rules for DWBI environment on enterprise level. Well experienced on handling Status calls with business and technical teams and delivering Qualitative products with innovative solutions to business.

Excellent leadership, team management and communication skills in leading teams during the project phase, training and guiding team members and enabling knowledge sharing sessions among the team and business through CRPT.

Skills:

BI Reporting Tools: Tableau 9.1, OBIEE 12c (12.2.1.0.0)/11.1.1.5/6/7/9.1,10.1.3.4.1, Siebel Analytics 7.8.x

ERP: EBS 11.5.10.2, EBS R12

Data Modeling Tools: Erwin 7.3, MS Visio, Rational Rose

Databases: Oracle Exadata/10g/11g, Tera Data 14.0/12, Sql Server 2005/08, MS Access

DW Utilities: DAC 10.1.3.4.1, MS-VSS, TOAD, Oracle Sql Developer

Other Utilities: SharePoint, FTP, WinScp, Putty, ClearCase

Professional Experience:

Cummins Inc., (Man & Log) Sep 2014 – Till Date

Sr. DWBI Lead Developer/Administrator (OBIEE/Tableau)

Cummins EIM BU Positions and Cummins ADSC BI Enhancements: Worked in two different projects: Cummins EIM BU Positions and Cummins ADSC BI Enhancements. Cummins ADSC BI Enhancements Team is responsible to develop and implemented the Enhancements activities to support the growing business needs and current demands, Multiple Enhancements are initiated by Business users. Business Intelligence platform in Cummins Inc., comprise of various business units such as Components, Engine, Power Generation, Distribution, Etc. Data from various Business Units and Regions are made available in corresponding Business Warehouses as well as in EDW environment. Various Analytical Reporting systems are built on EDW & Business warehouse to support business team.

Responsibilities:

Expertise in Business requirements development on interactions with client SME’s and document the requirements and designed application architecture as per business requirement and DW BI standards.

Deriving estimations for development effort for each phase of OBIEE and Tableau Dashboards/ reports.

Deployment.

Preparation of Agile approach and detailed task identification, resource estimation, coordination to prepare project plan.

Review existing Noetix Views environment to allow and adapt to new requirements in OBIEE and Tableau to improve its performance.

Design and implemented security in OBIEE and Tableau environment based on Oracle EBS, Noetix Views roles and responsibilities.

Design Data model for customization of existing model and new development from non-Oracle integrated sources and Legacy source systems in data warehouse

Experience in performing Install & upgrade out of Place, In – Place OBIEE 10.1.3.4.1 11.1.1.5 11.1.1.7.0 11.1.1.9.0 12.2.1.1.0 (POC).

Expertise in administration activities like migrating RPD and Web Catalog Objects from DEV SIT UAT PROD environments

Implemented Writeback and MUDE functionality in OBIEE as per business and Stack holders request.

Review existing OBIEE environment to allow and adapt to new requirements to improve its performance.

Created and standardized OBIEE environment and applications best practice and rules on enterprise level as COE (Center of Excellence) and BIDRB (Business Intelligence Design Review Board) member.

Implemented Object and Data level security by creating groups in WebLogic, and writing SQL or PL/SQL quires in RPD as per business scenario.

Designed new meta data and Data marts for exiting OBIEE report and RPD data model applications.

Supported different business applications like CORP (Finance), FBU (Fuel Business Unit) and FSBU (Fuel Shell Business Unit), CBU (Component Business Unit), EBU (Engine Business Unit), DBU (Distribution Business Unit)

Import pre-build Noetix views in OBIEE operational environment and regenerate RPD for enhancement activities

Create custom views on top of Noetix views by creating hooks script.

Analyze and fix data level issue in Inventory, GL, AP, PO, AR, FA and BOM views.

Created Test case scenarios to validate business requirements in OBIEE operational reports data against Noetix views source data and shared test results with application requester or users.

Worked with production support team and communicating missing data or integrations to ETL team for redesign ETL technical specification fit with business scenarios.

Developed Visualization reports and applications by using different UI objects like filled maps, Bar Chart, Line Chart, Pie Chart, Straight table and Pivot table in Tableau.

Used Sets, Bins, Parameters, Aggregate Functions, Filters in Tableau Desktop to analyze and obtain insights into large data sets.

Combine the visualizations into Interactive Dashboards and publish them to the web using in Tableau Desktop 9.1.

Designed new Data marts for Tableau Reports from exiting OBIEE report and RPD data model applications.

Created various Tableau Visualization Dashboard and Reports by using data blending on existing data model, SSAS cubes, OBIEE reports, Discoverer Reports, Noetix Views and Oracle Forms & Reports build in DWBI environment.

Created weekly/monthly auditing, Ticket summary, Region level BI reports for stakeholder’s and application owners

Provide Application training for Business Users by sharing application user’s manual, run book/playbook and CRPT training for different regional users.

Experienced in creating BI Publisher reports against OLTP systems to analyze and obtain insights into large data sets.

Work with different DBA team like Oracle, Teradata, SQL Server and technical team to identify and resolve performance bottlenecks and provide appropriate solution with redesigned of SQL&PL/SQL quires to business.

Design, development and evaluate of BRD, HLD, LLD, SIT and UTC

Technical Environment: Tableau 9.1, OBIEE 12C/11.1.1.7/9.1, BI Publisher, Noetix, Smart View, Oracle 11g/ Exadata, Teradata, SQL Server 2008 R2, SSAS, Windows Server 2008, WinScp, SharePoint, Citrix, ClearCase, Toad 9, Oracle SQL Developer 1.5.5, SQL Navigator 5.5.

Ingersoll Rand Inc., (Man & Log) Sep 2013 - Aug 2014

Sr. DWBI Developer (OBIEE)

Ingersoll Rand as a manufacturing MNC has three Business sectors ITS (Industrial Technologies sector), Climate control Technologies and Securities Technologies. Since IR is involved into a lot of takeovers and therefore are in need for a single Data warehouse with Reporting to make the Information available to targeted users in a common and more structured format. To streamline the data flow process and information availability to various users via proposed Business Intelligence program is the main objective of work for this project.

Responsibilities:

As a Sr. BI developer involved in OBIA 7.9.6.0 (Financial Analytics) implementation OBIEE development.

Involved in: BI Apps /OBIEE/ Informatica/ DAC/ OBAW implementation of Oracle Financial Analytics Subject Area modules:

oFinancials - GL Balance Sheet,

oFinancials - GL Budget and Expenses,

oFinancials - GL Detail Transactions.

Involved in Designing and development of RPD data modeling.

Involved in Designing and development of OBIEE Dashboards, Answers and catalog Administration.

Involved in Configuring scheduler, iBOTS.

Monitored the data load using DAC.

Created mapping logic and documented data transformation from source to target by using ELT(ODI)

Gathered business requirement analysis and responsible for providing OBIEE reports and dashboards.

Created detailed Functional& Technical Specifications Documents, including data samples, use cases, key project assumptions, report samples, data flows, and data models in OBIEE environment.

Implemented Data Quality and Cleansing, Data Governance, Metadata usage and management, and Master data management on OLAP and OLTP

Have created impact analysis and resolved the post production break fixes through enhancements and implementations in OBIEE reports.

Created various test case scenarios and validate reports and execute the same in different test environments, first to test with the sample data and then with the live data of about 1 million records to fulfill the business requirements and shared the test results to Business users.

Designing and development of BRD, HLD, and UTP

Designing and developed strategies for CDC and SCD’s in DW.

Performed duties of a production support personnel such as:

oIdentifying the cause of failure,

oRectify the problem or notify appropriate personnel,

oAnd stream development and production support to IR Financial Analytics (OBIA)

Technical Environment: OBIEE 11g, BI Publisher, ODI 11g, SQL Server 2008, Smart view, Oracle 11g, Windows Server 2008, Citrix, OEL 5.x, Erwin, Toad, SQL Server.

Auto Shell Groups (Man & Log) May 2011 – Sep 2013

OBIEE Developer

“Auto Shell Groups Reporting” (ASGR) is developed and implemented as an in-house POC project for ASG. ASGR is mainly developed for analyzing and managing the historical data from the enterprise and developing reports based on existing oracle forms. The framework is designed in such a way to create a custom generic data model to fit all the basic decision making analytics capabilities. Highly supported and extendible Star Schema for Analytics server is the design approach adapted for ASGR’s data model. Auto Shell Groups Reporting possess the capability to have only very little or least level of customization for any given workflow. Decision making capability is very efficient and adaptable using ASGR. Analytics reports are developed, deployed and delivered for the departments and groups based on Products, Voucher, Human Resources, Invoice, Sales, Customer’s and company Budget information.

Responsibilities:

Responsible for performing Enterprise level RPD design and reporting analysis for the existing divisions, as a SME created data model for good to go with enterprise data.

Analysis and study of existing system running over TPMS (Transaction Processing and Management System) and designed RPD metadata model in OBIEE

Deriving estimations for development effort for each phase of the deployment of OBIEE Dashboards/ reports.

Design and development of OBIEE RPD data model, Dashboards, Answers and catalog Administration.

Design and development of FDD, TDD, UTP, RPR.

Validated Dashboard and Reports by creating test case scenarios and shared the test results to business users with zero defect in UAT

Design and develop custom and customization of ETL mappings and workflows.

Responsible for setting up DAC execution plans and Administration.

Solution designing for reporting requirements from heterogeneous sources.

Business requirements development on interactions with client SME’s and document the requirements.

Design Data model for custom Repository development from non-Oracle integrated sources.

Design and development of Business model and mapping for the Business rules.

Design and develop ad-hoc reports on Sales rep activities and Sales target analysis.

Develop complex reports on one time charges, Work orders, commissions, Site level.

Design and setup Data level security for the super users at the enterprise level and market level.

Design reports with hierarchies for Sales module across Market.

Develop in line record view with action links and develop reports with guided navigation links.

Technical Environment: OBIEE 11g/ 10.1.3.4.1, Informatica, DAC, Oracle 11g, Windows Server 2008, Citrix, OEL 5.x, Erwin.

ACS Vector – Xerox (Transportation) May 2008 – Mar 2011

DWBI Developer (OBIEE/Siebel Analytics)

ACS provides diversified services with leaders in toll collection maintenance with transportation operations lead from German town. Vector provides an in-depth analysis of the Toll by Lane Plaza Management system; the intention of the project is to allow all accounts across the respective State Toll Plazas to manage their own transactions via the EZ Pass Applications and to view various plaza wise related information in the form of monthly reports generated using OBIEE and Siebel Analytics Dashboards and reports. Vector Business Warehouse is designed to facilitate this by consolidating all the relevant data in one location and creation of reports from an individual client based requirement.

Responsibilities:

Requirements gathering on coordination with client SME and BRD preparation.

Design and develop Repository(RPD) for the data model.

Involved in upgrade POC from Siebel Analytics to OBIEE.

Development of Dashboards over the OLAP model designed for MD to deploy for various customers.

Design and development of OBIEE Dashboards, Answers.

Migrated OBIEE RPD, Reports, Dashboard objects from Dev to UAT and PROD

Prepared SIT test case scenarios and UAT test cases to validate the migrated reports in UAT.

Preparation of tollgate approach and detailed task identification, resource estimation, coordination to prepare project plan.

Responsible for migration of Analytics reports, repository to OBIEE Environment.

Involved in SIT, QA, deployment and post production support.

Develop dimensional hierarchies for the Toll collection centers and collection agents.

Responsible for design and development of ETL mappings and workflows.

Develop and schedule iBots for users on the collection details and dues.

Responsible for additional activity as Software Configuration Management coordinator.

Design and development of HLD, LLD, UTP.

Technical Environment: Siebel 8.0, OBIEE 10.1.3.3.2, Siebel Analytics 7.8.5, Informatica 7.1, Windows Server 2003. FTP, Clear Case

HCL Technologies Ltd, Nov 2007 – Mar 2008

Academic project:

Project Title: Sales Analytics Framework: HCL Technologies Ltd, Chennai “Sales Analytics Framework” (SAF) is developed and implemented as an in-house POC internship project for HCL Technologies Ltd, Chennai. SAF is mainly developed for analyzing and managing the historical data from the enterprise and making reports based on the customer specific requirements. The framework is designed in such a way to create a universal or generic data model to fit all the basic decision making analytics capabilities. Highly supported and extendible Star Schema for Analytics server is the design approach adapted for SAF’s data model.

Sales Analytics Framework possess the capability to have only very little or least level of customization for any given sales analytics workflow. Decision making capability is very efficient and accurate using SAF. Analytics reports are developed, deployed and delivered for the customers and groups based on the requirements. Security to the most granular level is possible in Siebel analytics like user level, group level and LDAP authentication is also possible.

Responsibilities:

Siebel Analytics 7.8.5 (Standalone) platform installation in Windows environment

Created Star Schemas in BMM (Business Model Mapping) using Admin tool

Created Presentation layer for Subject Areas required in Admin tool

Created Reports using Siebel Answers and created Dashboards

Created filters in reports and prompts in Dashboards

Created drill down reports and reports navigations between reports and Dashboards and reports formatting

Submitted complete Detailed Technical documentation for the internship work

Technical Environment: Siebel Analytics 7.8.5, MS SQL Server 2000, Windows 2003.

Educational Details:

MCA (Master of Computer Applications) – 2008 – Bharathiyar University, Coimbatore, Tamil Nadu, India

Contact this candidate