Saurav Mitra

Data Architect | Business Intelligence Expert | Data Engineer saurav.karate@gmail.com

I am a Business Intelligence professional with 12 years of proven experience in diverse BI tools and technologies. Apart from my profession, I love developing various web applications using Php/Laravel. Some of them are listed here for demonstration. Commensurately my expertise in Web technologies includes HTML5, CSS3, JavaScript, jQuery, PHP, Laravel, Bootstrap, d3.js, nginx, redis, memcached, Joomla CMS.


Projects

IMS

Manage Entire Operations of any Educational Institute

Login with various roles to try out the system; Login with either staff1@example.com / student1@example.com / guardian1@example.com / faculty1@example.com and password as "password"

FAI

Efficient Off-Internet Advertisement for Publishers and Marketers

DWBI.org

Co-Founder of most popular Online Community for DW & BI professionals


Experience

Data Architect

Ashnik Pte Ltd

Business Intelligence & Data Integration services to Enterprises using Open Source Solutions- Hitachi Pentaho Business Analytics, Hortonworks Data Platform, Hortonworks Data Flow, MongoDb, EnterpriseDB

February 2017 - Present

Senior Consultant

vVolve Management Consultants

Data Integration- SAP Data Services, MSSQL- TSQL, Oracle Stored Procedure, Shell & Batch Script
Visula Analytics- SAP Business Intelligence, SAP Lumira, Tableau, Qlikview
Database- Oracle, MSSQL

October 2013 - January 2017

Data Migration Consultant

Utopia APJ Pte Ltd

Data Quality, Data Cleansing, Master Data Health Assessment, SAP Data Migration using SAP Data Services, SAP Information Steward

March 2012 - October 2013

DWBI ETL Informatica Consultant

United Overseas Bank

Data warehouse development & Data Integration using DB2, Oracle & Informatica

August 2011 - February 2012

SAP BODS Technical Consultant

HP Malaysia

Data warehouse development project of ASTRO, cable communications domain using Vertica, SAP BODS & SAP BOBJ

June 2011 - August 2011

Asst. Systems Engineer

Tata Consultancy Services

Worked as an ETL consultant in Health Care and Life Science domain. Design and Development of ETL through Informatica 8.6.1, UNIX, Oracle, Teradata.

October 2010 - May 2011

Data Specialist-Informatica

IBM India Pvt Ltd

ETL Informatica & SAP BODS Consultant

July 2010 - October 2010

Technical Associate

Tech Mahindra Ltd

Worked as an ETL developer using PowerCenter Informatica and BusinessObjects Data Integrator in Telecom Data Warehousing projects. Also worked in Oracle PL/SQL & UNIX, BOXIR2, OWB and OBIEE.

June 2007 - July 2010

Education

Heritage Institute of Technology

Bachelor of Technology
Electronics & Communications Engineering

GPA: 7.81

May 2003 - April 2007

Jodhpur Park Boys High School

Physics, Chemistry, Mathematics, Statistics

GPA: 7.87

May 2001 - April 2003

A.K.Ghosh Memorial High School

Science, Statistics

GPA: 8.85

April 2001

Skills

Programming Languages & Tools
Workflow
  • 12 years of experience in Business Intelligence & Visual Analytics, Big Data management, Data-warehouse, Data Integration, Data migration, Data profiling and data quality assurance projects
  • Design & development of optimized Dimensional data model for successful Business Analytics. Includes design of solution architecture, logical & physical data models
  • Multiple, full lifecycle Data warehouse solution delivery, including requirements analysis, solution architecture design, ETL & analytics application design and development, testing, and deployment
  • Experience in efficient design and development of robust ETL framework and jobs with data reconciliation mechanism, re-startability using tools like Informatica Power Center, SAP Data Services, Pentaho Data Integration. Experience in extensive Performance Tuning activity at both Database and ETL levels to meet Business SLA
  • Experience in providing value-add analysis to Business, through use of visualization & reporting solutions like SAP Business Intelligence suite, SAP Dashboard, SAP Lumira, Pentaho Business Analytics and Tableau
  • Functional business knowledge experience in Retail & Distribution, Telecom, Banking, Health Care/Life Sciences, Energy and Insurance domain
  • Strong skills include Informatica Power Center, SAP Data Services, Pentaho Data Integration, Apache Hadoop, SAP HANA, SAP Information Steward, SAP Information Design Tool, WebI, SAP Lumira

Interests

I am a Business Intelligence professional with 12 years of proven experience in diverse BI tools and technologies across multiple functional domains like Retail, Sales & Distribution, Telecom, Healthcare and Banking. I have worked thoroughly in more than one ETL tools like Informatica PowerCenter, SAP Data Services, Pentaho Data Integration, Microsoft SSIS and I am well conversant in Oracle, MSSQL, SAP HANA, Postgres and MySql databases. On the Data Visualization front I have worked on tools like the SAP BI BO suite - Information Design Tool, Web Intelligence, Dashboard, SAP Lumira, Tableau and Qlikview. With regards to Data Quality I have worked in SAP Information Steward, to perform data health assessment & cleansing.

Certified Hortonworks Developer with working experience with tools & technologies of Hadoop eco system namely- HDFS, YARN & MapReduce, Zookeeper, Hive, Impala & Hbase, Sqoop, Pig & Flume, Spark.

My expertise includes, but not limited to, data warehouse, data integration, data migration, data analytic, big data management, big data analytics, data governance & data quality assurance projects where I have worked substantially and demonstrated proven results for projects with complex integration/ quality assurance landscapes.

In addition to a profession, Business Intelligence has been my passion all throughout and I have contributed to the larger BI community to the best of my capacity. I am the co-founder of DWBI.org (Previously DWBIConcepts.com) - the largest non-profit community website for Data warehousing and BI professionals - where I also contribute prolifically on technology whitepapers.


Awards & Certifications

  • Hortonworks Certified Developer
  • Hortonworks Certified Associate
  • R Programming - Coursera
  • The Data Scientist’s Toolbox – Coursera
  • SAP Certified Application Associate SAP HANA 1.0
  • SAS Certified Base Programmer for SAS9
  • Co-Founder of most popular Online Community for DW & BI professionals DWBI.org