Pratyay Modi

Business Intelligence Developer



About Me

Pratyay Modi

Understand, analyze and visualize – these three words describe what I do with data. I design processes to collect, analyze, and present the relevant data to the people who need it. I search for the most valuable insights and work to understand the data. I work with various individuals and departments to help visualize market potential, business trends, and competitor activity. With my ability to understand, analyze, and visualize data, I can help to guide your team in their product and marketing decisions.

I specialize in Tableau dashboards, collecting and processing data, and Python – particularly automating ETL processes using Docker

Experience

Inventorum GmbH

Business Intelligence Developer, Feb 2014 to May 2017

Inventorum is a Berlin based start-up that provides a cloud-based solution for small and big retailers. Apart from providing the necessary KPIs to each department, I've worked closely with marketing, product, and development. Like any startup job the team always works like a bunch of well-co-ordinated firefighters, so you get to wear multiple hats and learn new things every day.

Accomplishments:

  • Implemented a slack-bot for live reporting on sales using python-bottle apps
  • Integrated statistics from different sales and marketing channels to reduce the monthly marketing costs upto 20%
  • Setup the data warehouse to collect and store data from sales, product and marketing channels
  • Helped decision making for product features and releases by measuring and reporting on usage of different product features


Tata Consultancy Services

Data Center Administrator, April 2011 to April 2013

Worked with government projects from Gujarat government and CEPT University.

Investor facilitation portal is a Gujarat government venture supported by Tata consultancy services which helps domestic and foreign investors to invest in the state of Gujarat. The Vibrant Gujarat event is held every 2 years.I helped analyze the investment data of small-medium sized industries to huge industrial projects.

The Performance Assessment System (PAS) project is about developing appropriate methods and tools to measure, monitor and improve delivery of water and sanitation in cities and towns in India.

Accomplishments:

  • Regular delivery of necessary KPIs and statistics to the clients
  • Automated report generation and backups on the Actian database


Data First

Trainee Systems Engineer, Jan 2011 to Mar 2011

Data first is one of the leading 3 tier data centers in India. My short tenure was focused on learning to work with enterprise hardware and software.

Accomplishments:

  • Deployed a virtual environment using Vmware ESXi and Vsphere including backups on a Dell Power Vault TL2000 tape library.
  • Deployed UEC Eucalyptus cloud on an IBM HS22 Blade Center
  • Implemented monitoring solutions using PRTG, MRTG, and munin


Electromech

Systems Engineer, November 2010 to December 2010

At electromech, I focused on infrastructure, operating systems and administration. It was a shift from developing software in a specific framework for a customer to implementing open source solutions. We would understand the client requirements and propose economical and scalable solutions and deploy them.

Accomplishments:

  • Deployed an NFS solution for a hospital helping them use their old hard drives


Education

European University Viadrina

Masters in Business Informatics, 2013 - 2015

Thesis:

  • Internt start-ups: Chances and risks of using open source software


Contact

hi@prat.io
Berlin

Skills

 Databases


 Postgresql
 MySQL
CouchDB
Neo4J

 BI Tools


Tableau
Microsoft Power BI
Metabase
QlikView

 Programming Languages and Tools


 Python
 Docker
 Nginx


 Languages

  English (Fluent)

  German (Beginner)

 Hobbies

  Reading

  Music

  Film Photography

  Travelling