Praveen Negi, Developer in Delhi, India
Praveen is available for hire
Hire Praveen

Praveen Negi

Verified Expert  in Engineering

Software Developer

Delhi, India

Toptal member since September 28, 2020

Bio

Praveen is a seasoned data warehouse professional with a demonstrated history of working in the information technology and services industry and client-facing roles. Skilled in big data technologies, Informatica, SQL, Oracle Database, requirements analysis, and Agile methodologies, PowerBI, and Birst, Praveen also excels at building large-scale data warehouses and data lakes using Delta Lake architecture.

Portfolio

Southside Medical Services
Microsoft Power BI, Databricks, Azure SQL Databases, Azure Data Factory (ADF)...
Reckitt Benckiser
Azure, Microsoft Power BI, Data Warehouse Design, Data Warehousing, Birst, SQL

Experience

  • SQL - 10 years
  • Birst - 4 years
  • Azure SQL Databases - 3 years
  • Azure Data Factory (ADF) - 3 years
  • Azure - 3 years
  • Microsoft Power BI - 3 years
  • PySpark - 2 years
  • Spark SQL - 1 year

Availability

Part-time

Preferred Environment

Python 3, Spark SQL, Azure, Birst, Microsoft Power BI, Databricks, Windows 10, Azure SQL, PySpark

The most amazing...

...thing was building an end-to-end reporting platform on Azure Cloud using Data Factory (ingestion), BLOB (storage), SQL DWH (MPP), and Power BI (reports).

Work Experience

Azure Data Engineer

2018 - PRESENT
Southside Medical Services
  • Designed and developed an end-to-end ingestion framework to ingest data from different sources ranging from on-premise (relational databases as well as flat files) to Blob Storage and then to Azure SQL Database using Azure Data Factory.
  • Performed data modeling for the enterprise data warehouse and led a team for reporting on Power BI for the end-users.
  • Performed requirements gathering and worked in a client-facing role.
  • Set up a Git repository for version control of the source code on Azure DevOps.
Technologies: Microsoft Power BI, Databricks, Azure SQL Databases, Azure Data Factory (ADF), Azure, SQL, Python

Senior Business Analyst

2017 - 2018
Reckitt Benckiser
  • Worked as a single point of contact for the reporting platform using Birst and Power BI.
  • Performed a migration from AWS and Birst to the Azure platform (Power BI and Azure).
  • Migrated multiple scheduled reports from Birst to MRS and developed new reports after requirement gathering from end-users.
Technologies: Azure, Microsoft Power BI, Data Warehouse Design, Data Warehousing, Birst, SQL

Module Lead

2016 - 2017
Happiest Minds Technologies
  • Led the project architecture and developed the ETL-and-reporting solution to track the clickstream on a support portal for a customer.
  • Gathered the requirements from stakeholders and drove project delivery for multiple parallel projects.
  • Developed complex reports and dashboards as per customer requirements.
Technologies: SQL, Birst

Implementation Consultant

2014 - 2016
Birst India Pvt Ltd
  • Creating a standard data model applicable on behalf of multiple customers.
  • Built reports and led teams for reporting deliverables.
  • Supported customers by guiding/mentoring them in the use of Birst.
Technologies: SQL, Birst

Associate Consultant

2013 - 2014
Capgemini India Pvt Ltd
  • Developed an integration platform using Informatica PowerCenter.
  • Gathered requirements by directly interacting with the stakeholders.
  • Performed UAT and provided post-implementation support of the developed ETL and reports.
Technologies: SQL, Informatica PowerCenter

Systems Engineer

2010 - 2013
Infosys Ltd
  • Contributed to Informatica mapping and workflow development in the build of a data warehouse on Oracle Database.
  • Gathered requirements by directly interacting with the end users and document preparation.
  • Provided UAT and production support for the deployed application.
Technologies: Oracle SQL, Informatica PowerCenter, SQL

Experience

Insights Platform | Reporting Platform on Power BI

I developed and designed an end-to-end reporting platform on Azure Cloud starting from ingestion (Azure Data Factory), storage (Blob Storage), database (Azure SQL Database) and a reporting platform (Power BI).

Education

2006 - 2010

Bachelor of Technology Degree in Electronics and Communication Engineering

Guru Gobind Singh Indraprastha University - New Delhi, India

Skills

Libraries/APIs

PySpark

Tools

Microsoft Power BI, Informatica PowerCenter, Spark SQL

Languages

SQL, Python 3, Python

Storage

Azure SQL, Azure SQL Databases, Oracle SQL

Platforms

Databricks, Azure

Paradigms

Azure DevOps, Business Intelligence (BI), Dimensional Modeling

Other

Birst, Windows 10, Azure Data Factory (ADF), Blob Storage, Data Warehousing, Data Warehouse Design

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring