SQL
NISHANT KUMAR
Business Analyst At Whitehat Jr.
Summary
Perceptive Business Analyst with 7 years driving successful business processes for startup companies. Dedicated to maximizing the impact of key performance metrics to enhance and expand business processes. Known for leveraging both macro and micro-scale analyses to generate holistic images of ongoing business operations for immediate actionability.
Overview
7
7
years of professional experience
2
2
Certifications
2
2
Languages
Work History
Business Analyst
Whitehat Jr.
05.2021 - Current
- Spearheaded the automation of data processes using PostgreSQL, significantly improving operational efficiency
- Enhanced Paid Class Completion by 32% within 3 months, resulting in a revenue increase of approximately $700,000 per month
- Streamlined project management with effective communication and collaboration across cross-functional teams.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Reduced communication costs by 67% within 6 months, saving the company $85,500
- Devised and implemented a fraud detection strategy, reducing incentives by 14% ($580) and ensuring lead quality
- Improved overall class completion from 46% to 71% within 4 months, enhancing user engagement
- Automated reporting systems, reducing monthly report times from 1 week to 2 hours, optimizing operational efficiency
- Spearheaded the implementation of a new data visualization tool, resulting in an increase in stakeholder engagement and data-driven decision-making processes
- Collaborated with the tech team to optimize PostgreSQL queries, reducing data processing time and enhancing overall system efficiency
- Identified areas for process improvement and recommended solutions to enhance operational efficiency and effectiveness
Business Intelligence Analyst
Wedeo Inc.
12.2019 - 04.2021
- Optimized TensorFlow code for efficient video processing, utilizing FFmpeg and Boto3 for enhanced functionality
- Led product demos and gathered client insights to drive product improvements and customer satisfaction
- Streamlined video processing operations, enhancing upload, download, trimming, and compression processes
- Improved data quality and accuracy through rigorous validation, cleansing, and normalization techniques.
- Implemented a data monitoring system that resulted in reduction in data errors, improving data accuracy and decision-making processes
- Optimized data management processes by creating streamlined data pipelines for efficient analysis and reporting
- Developed predictive models to support proactive decision-making in areas such as customer segmentation, churn prediction, and demand forecasting
Associate Consultant
PricewaterhouseCoopers
07.2017 - 08.2019
- Streamlined data flow to PostgreSQL servers using Python scripts, enhancing data accessibility and analysis
- Optimized code efficiency by promoting local functions to global, improving overall system performance
- Implemented lazy loading techniques, reducing page loading time by 22% on the testing server
- Utilized DML scripts to update inconsistent data points, enhancing data quality and reliability
- Developed a process optimization strategy that led to an increase in data accessibility and analysis efficiency
- Enhanced client satisfaction by providing tailored solutions and recommendations for their business needs. Acted as a liaison between stakeholders ensuring open lines of communication throughout project life cycle
- Managed multiple projects simultaneously while maintaining attention to detail, organization, and adherence to deadlines
Education
B.Tech. (Hons.) - Metallurgical & Materials Engineering
IIT Kharagpur
West Bengal 04.2001 -
Skills
SQL Automation and Reporting
Visual Reporting and Data Visualization
Fraud Detection Strategies
Team Collaboration and Solution Delivery
Performance Improvement
Customer Experience Enhancement
Business Impact Analysis
Risk Assessment & Mitigation
Leader
Problem Solver
Multi Tasker
Critical Thinker
Planner
Collaborator
Software
Excel
Python
Tableau
Power BI
Data Analytics
ETL
R
Certification
Hackerrank: Python (Advanced)
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Type
Full TimeLocation Preference
On-SiteRemoteHybridImportant To Me
Work-life balanceCompany CulturePersonal development programsCareer advancementPaid sick leaveHealthcare benefitsTeam Building / Company RetreatsTimeline
Business Analyst
Whitehat Jr.
05.2021 - Current
Hackerrank: Python (Advanced)
09-2020
Hackerrank: SQL (Intermediate)
09-2020
Business Intelligence Analyst
Wedeo Inc.
12.2019 - 04.2021
Associate Consultant
PricewaterhouseCoopers
07.2017 - 08.2019
B.Tech. (Hons.) - Metallurgical & Materials Engineering
IIT Kharagpur
04.2001 -