SUMMARY:

• Highly committed, self - motivated and goal-oriented BI / DW Consultant having 10+ years of work experience in Project Planning, Project Execution, Analysis, Design, Development of Data Warehousing applications and Implementation of BI Dashboards.
• Experience in Technologies Talend Enterprise big data, Tableau, Pentaho Kettle with big data, Amazon Web,Services (AWS), Informatica, SAP BO, Data Modelling, Hadoop HDFS, Hive, Hbase, MongoDb, AWS Arora, AWS Redshift.
• Having Domain expertise in Pharma, Banking, Insurance, and Hospitality.
• Currently working with Confidential ., Confidential as Technical Lead Consultant.
• Certification in Talend Enterprise big data.
• Having exposure to big data echosystem.

TECHNICAL SKILLS:

Primary Skills: Pentaho Kettle, Amazon Web Services(AWS),Tableau with big data, Talend Enterprise big data, Hadoop (HDFS, Hive, Hbase, Spark), Business Objects,Informatica, Data Modelling

Programming languages: Shell Scripting, Python

Databases: Google Cloud(Big query), hbase,MongoDb,Cassandra,Hadoop-hive,Oracle9i,Oracle 10g,SSMS

Domain: Pharma,Banking,Insurance,Hospitality

Tools: Pentaho Kettle, Tableau, Talend Enterprise big data, Informatica, SAP BOBJ, Data Modelling.

PROFESSIONAL EXPERIENCE:

Confidential

Big Data Technical Lead

• Working on Design and Development of Data Model.
• Working on ETL Architecture.
• Working on Creation of Technical Design document.
• Working on Creation of Data Model document.
• Working on Design and Development of “ETL Build”.
• Mentoring ETL Team on Design and development.
• Taking complete Ownership of the Project.
• Document creation on Runbook and Operations
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Generated Tableau Dashboard with quick/context/global filters/action filters/ drill downs, parameters and calculated fields on Tableau.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: Pentaho Kettle,Tableau,MSSQL,Oracle,Excel.ER Studio(Data Modelling),Amazon Redshift

Confidential

Big Data Technical Lead (BI Dashboards/ETL Load)

• Coordinating with clients on Business Requirement.
• Working on Design and Development of Data Model.
• Working on ETL Architecture
• Prepared Design Document.
• Creation of Data Model document.
• Working on Design and Development of “ETL Build” using Pentaho Kettle/Talend.
• Working on Reading data from HDFS File system and loading it in Hive db.
• Working on pulling data from Hbase and loading it back in SSMS db on AWS.
• Deployment in Production.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Generated Tableau Dashboard with quick/context/global filters/action filters/ drill downs, parameters and calculated fields on Tableau.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: Tableau 10.3, Talend Enterprise big data, Pentaho Kettle, AWS, Hadoop HDFS, SSMS.

Confidential

Big data Technical Lead (BI Dashboards/ETL Load)

• Coordinating with clients on Business Requirement.
• Working on Design and Development of Data Model.
• Working on ETL Architecture
• Working on Design and Development of “ETL Build”.
• Mentoring ETL Team on Design and development.
• Taking complete Ownership of the Project from scratch.
• Deployment in Production.
• Document creation of ETL Architecture, Run Book and Operational Manual.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Generated Tableau Dashboard with quick/context/global filters/action filters/ drill downs, parameters and calculated fields on Tableau.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: Talend Enterprise big data (ETL Tool), AWS (Amazon Redshift), Tableau, Pentaho Kettle.

Confidential

ETL Team Lead

• Coordinating with client on Business Requirement.
• Working on Design and Development of Data Model.
• Working on ETL Architecture.
• Working on Design and Development of “ETL Build”.
• Mentoring ETL Team on Design and development.
• Working on MDM Creation with extensively diversified data coming from flat files, salesforce.
• Extensive use of Transformations like ‘Filter Transformation’, ‘Joiner Transformation’, ‘Rank Transformation’, ‘Sorter Transformation’.
• Extensive use of ‘Update Strategy’, ‘Lookup Transformation’, ‘Router Transformation’.
• Working on Mapplet.
• Working on Sessions and Workflow.
• Taking complete Ownership of the Project from start.
• Deployment in Production.
• Document creation of ETL Architecture, Run Book, and Operational Manual.

Environment: Informatica, Oracle.

Confidential

BI Consultant

• Coordinating with clients on Business Requirement.
• Working on Design and Development of Data Model.
• Reporting Architecture.
• Working on Design and Development of Universe Creation.
• Working on Design and Development of Dashboard Creation.
• Design document creation.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Generated Tableau Dashboard with quick/context/global filters/action filters/ drill downs, parameters and calculated fields on Tableau.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: Tableau, SAP BO Universes.

Confidential

System Analyst

• Coordinating with clients on Business Requirement.
• Working on Design and Development of Data Model.
• Reporting Architecture.
• Supporting day to day activities of Data warehouse.
• Working on BO Migration Project.
• Working on Design and development of Universes.
• Working on Design and Development of Dashboard Creation.
• Demonstration of Project to the client.
• Giving training to the Business Users.
• Design document creation.
• Deployment of Universes, Reports and Dashboard in Production.

Environment: Informatica, SAP BO.