Pulkit Bansal, Developer in Hyderabad, Telangana, India
Pulkit is available for hire
Hire Pulkit

Pulkit Bansal

Verified Expert  in Engineering

Bio

Pulkit has 15+ years of experience in data analytics and data warehousing and a master's in data science. He's passionate about solving real-world business challenges using data analytics and is proficient in constructing data warehouse solutions from scratch, including data modeling, data engineering, and visualization in demanding business environments. He's adept at building ML and predictive models for pattern recognition and business insights.

Portfolio

D. E. Shaw
Data Analytics, SQL, Data Warehouse Design, Data Warehousing, SQL Server 2016...
Emerson Electric
Oracle E-Business Suite (EBS), Erwin, Oracle, Tableau...

Experience

  • Data Analytics - 14 years
  • SQL - 10 years
  • Machine Learning - 6 years
  • Python 3 - 5 years
  • Data Warehouse Design - 4 years
  • Data Warehousing - 4 years
  • Tableau - 4 years
  • Artificial Intelligence (AI) - 1 year

Availability

Part-time

Preferred Environment

Microsoft Power BI, Erwin, Predictive Analytics, Machine Learning, Tableau, SQL Server Integration Services (SSIS), Python 3, Microsoft SQL Server

The most amazing...

...thing I've designed is a centralized data warehouse for the marketing team, integrating LinkedIn, Google Analytics, IBM, YouTube, and other marketing platforms.

Work Experience

Associate Director

2020 - PRESENT
D. E. Shaw
  • Established operational standards and guidelines for the global analytics and reporting team within talent acquisition.
  • Automated 80% of cadenced reports using Python and Power BI.
  • Deprecated Cognos and migrated existing executive-level reports to Power BI.
Technologies: Data Analytics, SQL, Data Warehouse Design, Data Warehousing, SQL Server 2016, Machine Learning, Microsoft Power BI, Python 3, Microsoft SQL Server, Artificial Intelligence (AI)

BI Technical Lead

2009 - 2020
Emerson Electric
  • Delivered and managed data analytics and an SQL data warehouse per business requirements.
  • Maintained the Tableau server and delivered Tableau dashboards for over 7,500 users.
  • Delivered an integrated data hub for marketing analysis using REST APIs, sourcing data from web platforms like Google Analytics. IBM, Eloqua, and Service and Sales Cloud.
  • Developed multiple Tableau dashboards per business requirements, including RedZone, BI Usage, and Issue Tracker for all ongoing projects.
  • Defined and established a change management process and standards for SQL Data Warehouse.
  • Developed complex data warehouse designs using Kimball methodologies in ERwin.
  • Designed and developed operational reports in Noetix WebQuery based on complex database views and custom objects.
  • Provided tier III support on BI application, log, and track user tickets in HPSM and ServiceNow.
  • Developed complex custom views in Oracle 11g from order to cash and procure to pay business cycles.
  • Gained hands-on experience with OBIEE RPD and dashboard development.
Technologies: Oracle E-Business Suite (EBS), Erwin, Oracle, Tableau, SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL, Data Warehouse Design, Data Warehousing, SQL Server 2016, Microsoft Power BI, Python 3, Data Analytics

Experience

Digital Data Hub

Centralized data hub sourcing data from various web platforms like Google Analytics, IBM, Eloqua, YouTube, LinkedIn, Oracle Service Cloud, and many other web application using Python to source the data via REST APIs.

Predicting Credit Card Defaulters

Predict possible defaulters' new customers acquisition by analysis of their demographic and credit history data. Designed a Random Forest model to predict the default customers and logistic classification for scorecard

BI Usage Analysis

Sourcing application usage data from various BI applications (Tableau, Power BI, OBIEE, SSRS, Excel) and analyzing the usage and growth trends in Tableau visualization, resulting in showcasing effective utilization of organization resources and ROI.

Predict Customer Churn

Predicting customer churn in the telecom industry after analyzing the last 3 months of usage patterns. Designed SVM, Random Forest along with logistic classification to predict the probability scores utilizing PCA for feature transformation and cluster centroid methods for handling class imbalance and achieved 85% model accuracy.

Education

2018 - 2023

Master's Degree in Data Science

Liverpool John Moores University - Liverpool

2018 - 2019

Post-graduate Diploma in Data Science

International Institute of Information Technology - Bangalore, India

2005 - 2009

Bachelor of Technology Degree in Computer Science

Punjab Technical University - Chandigarh, India

Certifications

MARCH 2025 - PRESENT

Advanced Certificate Program in GenerativeAI

upGrad

Skills

Tools

Tableau, Erwin, Oracle E-Business Suite (EBS), Microsoft Power BI

Languages

SQL, Python 3, C++

Platforms

Oracle

Storage

SQL Server Integration Services (SSIS), SQL Server 2016, Microsoft SQL Server, Databases

Other

Data Engineering, Data Warehouse Design, Data Modeling, Data Warehousing, Artificial Intelligence (AI), Data Analytics, Machine Learning, Predictive Analytics, APIs, Data Science

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