Candidates About

 

Hari Krishnan Kunnathu Puliyakotte

 

Name	Hari Krishnan Kunnathu Puliyakotte
Current Role	Senior BI Architect/Tableau Developer
Languages/Packages/Tools Known	Tableau (8,9,10)  , Erwin R9.7, SQL, Data stage, AWS,Teradata utilities
Domains worked on	Healthcare , Finance, Telecom & Media
Databases Worked On	Teradata (V2R5 to13) (Teradata Certified Master (8 certifications) ,Oracle(10g,11g),Greenplum

 

Career Summary:

 

·         Have 11 + years of experience in business intelligence datawarehouse  designing along with 3+yrs in tableau report development

 

·         Well versed with DWH concepts. Had been always updating skills with the latest technologies and project execution methodologies available in the market.

 

·         Currently working as, a Senior BI Architect/Tableau at Capgemini USA and have been managing a few teams as well, during my tenure

 

·         Expert in  creating report dashboards, visualization in Tableau & maintaining good Report designs

 

·         Expert in converting complex business requirements into technical design ,data model and mapping

 

·         Built, published customized interactive reports and dashboards, report scheduling using Tableau

 

·         Created action filters, parameters and calculated fields for preparing dashboards and worksheets in Tableau.

 

·         Restricted data for particular users using Row level security and User filters.

 

·         Developed Tableau workbooks from multiple data sources using Data Blending.

 

·         Training the users on data refresh, data source replacement and refreshing flat file data sources.

 

·         Created solution driven dashboards by developing different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts and Scatter Plots in Tableau Desktop.

 

·         Showing the client on usage of sets, parameters, formatting, filtering calculated fields and action filters.

 

·         Created and implemented effective datamarts in case of complex reporting to ensure the complexities does not affect other systems

 

·         Good knowledge of Relational database concepts and possess strong knowledge in writing SQL queries

 

·         Expert in converting complex business requirement into technical specifications

 

·         Expert in creating normalized/denormalized entity structure, data model/mapping and design of the datawarehouse

 

·         Teradata certified Datawarehouse Architect. Also completed all 8 level of certifications to earn the Master title.

 

·         My domain knowledge includes Healthcare, Media, Finance & Telecom. Project methodologies learnt and followed includes, Agile methodologies

 

·         Also worked as a Tech lead/onsite coordinator for a leading bank in Singapore.

 

·         Always up for the technical challenge and enthusiastic in taking up the initiatives to provide solution for the same

 

·         Good at managing the team ensuring good spirit with team  at the same time meeting deliverables on time

 

·         Professionally certified and business process focused

 

·         Quality assurance maintained in all the deliverables assigned

 

·         Team player ,career oriented & ready to update skill set by learning new technologies coming on the way

 

 

Certifications & Awards :

 

1. Teradata Certified Master V2R5 (completed all 8 levels )

 

 

 

1. Won an award from Customer (Telstra Telecom) while working with Satyam Computer Services Ltd for providing a solution for a complex business scenario which was successfully implemented.

 

 

Educational Qualification:

 

Bachelor Of Engineering (2005) Vishwesaraya Technological University, India

 

 

Project Name :  FDA Databeats

 

Role in the project         :           Senior Data – Tableau Architect

Name of the Client         :           Johnson & Johnson , New Jersey USA

Organization                  :           Capgemini,USA

 

Responsibilities :      

·         Requirement gathering from business units

·         Business Requirement document preparation

·         Convert the business entities into technical design

·         Data modelling and mapping

·         Identify the data elements and map it to their corresponding    

attributes in the model

·         Data analysis along with the impact study

·         Define data relationship & constrains

·         Ensure the standardization and alignment with the reporting requirements

·         Report design ,development & Visualizations using Tableau

·         UAT support

·         Production support as per agreed timelines 

 

            Tools    : Tableau , Teradata,SQL Server,AWS

 

            Duration            July 2017 – till date

 

Project Name :  PQW Business Reporting

 

Role in the project         :           Senior Architect / Tableau developer

Name of the Client         :           GE Healthcare Milwaukee , WI

Organization                  :           Capgemini,USA

 

Responsibilities :      

·         To get the requirements from business

·         Prepare the Business Requirement documents

·         Technical Designing , data modelling and mapping

·         Convert business requirements into Data entities and models

·         Identify the data elements and map it to their corresponding    

attributes in the model

·         Complete impact analysis if required

·         Identify the relationship between the model and the constrains

·         Ensure the standardization and alignment with the reporting requirements

·         Create visualizations and develop Tableau designs for Reports.

·         Support User acceptance testing end to end

·         Ensure smooth release into the prod after the Manage offshore team

·         Production support as per agreed timelines  

 

            Tools    : Tableau , Teradata,SQL Server

 

            Duration            Nov 2016 – June 2017

 

 

Project Name:  HotSOS/REX utilization reports by Resort

 

Role in the project         :           Tableau developer /Data Architect

 

Name of the Client         :           Disney Resorts, FL ,USA

 

Organization                  :           Capgemini,India

 

            Responsibilities:  

·         Understand the business and help functional team to prepare BRDs

·         Mapping of business requirements into Technical Design

·         Identify the data elements in Data entities and models

·         Map it to their corresponding attributes in the model

·         Complete impact analysis if required

·         Bringing data into the repository for reporting calling APIs

·         Setting up the connections for report debelopment

·         Create visualizations and develop Tableau designs for Reports.

·         Support User acceptance testing end to end

·         Ensure smooth release into the prod after the Manage offshore team

·         Production support as per agreed timelines 

 

            Tools    : Tableau & Teradata, SQL Server.

 

Duration            Sep 2016 – Nov 2016

 

 

Project Name:  RTS - Business Intelligence Reporting

 

            Role in the project         :           Tableau Report Developer / Project Lead Architect

 

Name of the Client         :           NBC Universal – NYC, USA

 

Organization                  :           Capgemini,USA

 

            Responsibilities: 

·         Business Requirement document preparartion

·         Creation of database architecture , model and mappings

Identify permanent solutions for preexisting issues

·         Create visualizations and develop Tableau designs for Reports.

·         Production move of developed Tableau reports

·         Ensure data security for different level set for the tableau users

·         Production support and fix as per agreed SLAs

 

            Tools    : Tableau & Teradata.

Duration            Dec 2015 – Aug 2016

 

 

 

Project Name   : Ad Sales - Business Intelligence Reporting

 

Role in the project         :           Senior Archietct/Tableau Report Developer

 

Name of the Client         :           AMC Networks – NYC, USA

 

Organization                  :           Capgemini,USA

 

            Responsibilities:             

·         Analysis of Advertisement sales data available for reporting

·         Suggest metrics that could create meaningful report for management and sales

·         Create visualizations and develop Tableau designs for Reports.

·         Create architectural solutions for the entire BI database

·         Ensure business objectives are met with the new reporting facilities

·         Investigate the possibility of new forecast methods to help the business grow and bringing them to Tableau

·         Production support as per agreed timelines 

 

Tools    :           Tableau is used for Reporting.

Backend data exist in Oracle.

 

Duration            Aug 2015 – Dec 2015

 

 

 

 

 

 

Project Name   : GRID

 

Role in the project         :           Senior Architect/Project lead

 

Name of the Client         :           GE Power and Water ,Atlanta, USA

 

Organization                  :           Capgemini,USA

 

 

Duration            Sep 2014 – Aug 2015

 

Responsibilities: Analyzing the requirements from the existing code.

Convert it into technical design

UAT Support

 Tools Used        : Tabeau ,Talend & Greenplum

 

Duration of the Project   :           Sep 2014  -  Aug 2015

 

Project Name   : BI Marketing

 

            Role in the project         :           Onsite Coordinator /Architect

 

Name of the Client         :           GE Capital,CT ,USA

Organization                  :           Capgemini,USA

 

 

           

            Tools:   Tableau ,Informatica , TD utilities for developing the code

 

            Responsibility     : To convert the design into technical design using Erwin tool

  Develop the same using Teradata utilities.

  Support user validation &  production move.

 

            Duration of the Project   :  Mar 2014 – Sep 2014

 

 

 

 

Project Name   Global Service visibility

 

            Role in the project         :           Project Lead/Data Architect

 

Name of the Client        :            GE Health Care ,Milwaukee ,USA

 

Organization                  :           Capgemini,India

 

            Tools                            :           Teradata,Informatica

 

            Responsibility     : To convert the design into technical design using Erwin tool

  Develop the same using Teradata utilities.

  Support user validation &  production move.

 

            Duration of the Project   : August 2011  - Mar 2014

           

 

Project Name   Global MIS Malaysia

 

Role in the project         :           Technical Lead.

 

Organization                  :           HCL technologies,Singapore

 

Tools used  :      Teradata FSLDM (Financial Service Logic Model)  ,ODI

 

Responsibility       : Trained new members on ODI(Oracle data integrator) & FSLDM.

    Provided mapping solutions for data using FSLDM.        

    Responsible for Team management and on time quality deliverables.

 

Duration of the Project   :  Oct 2010  - July 2011

 

 

Project Name   :  Kenobi

 

Role in the project         :           Module Lead

 

Name of the Client         France Telecom, Paris,France

 

Organization                  : Capgemini,India

 

Tools    :           Teradata views created for direct reporting

Ab-intio to do complex transformations on large number of records

 

Responsibility     : Design and develop the module using Ab-intio .

  Make teradata views using TD utilities and DDL s for direct reporting

 

Duration of the Project   :  Sep 2009 -   Aug 2010

 

 

 

 

 

 

 

           

Project Name   : Data-out Telstra

 

Role in the project         :           Senior Software Engineer

 

Name of the Client         :           Telstra Telecom,Melbourne ,Australia

Organization                  :           Satyam Computers,India

 

 

 

Tools used in the project             :           Teradata views created for direct reporting

CLDM (Communication Logic Data Model)

 

Responsibility     :           Design and develop the module using Datastage,TD utilities .

Implement CLDM models to accommodate the business

 

Duration of the Project   : Sep 2007  -   Sep2009

 

Project Name   : Dialogue GSM

 

Role in the project         :           Software Engineer

 

Name of the Client         :           Dialogue GSM Srilanka

 

Organization                  :           Satyam Computers,India

 

Tools used in the project             :           Teradata views ,Datastage Jobs

 

Responsibility     :           Design and develop the module using Datastage .