Piyush Mahajan

About Me

A Senior System Engineer with 3+ years of experience developing system driven solutions, automation, and business intelligence to optimize performance. Expertise in SQL, Python, Java, and data visualization tools. Passionate about data, system optimization, and problem solving, with a proven track record of developing solutions that enhance system efficiency, scalability, and strategic decision making.

Work Experience

Infosys, India

Senior System Engineer (Sep 2021 – Dec 2023)

Developed a B2B sales funnel using SQL, optimizing lead prioritization, which increased lead generation by 57% and boosted sales by 17%.
Designed and implemented SQL queries and Tableau dashboards, improving data accuracy and increasing revenue by 60% within 12 months.
Optimized 25+ SQL query deliverables in Teradata BTEQ, improving data processing efficiency by 39% and refining EDW processes.
Eliminated 40% of data anomalies by evaluating Ab Initio GDE graphs and enhancing ETL workflows for cleaner, more reliable datasets.
Mentored new hires in SQL and data analytics, accelerating onboarding and enhancing team productivity.

Industrial Control and Appliance, India

Machine Learning Engineer (Jun 2020 – Sep 2021)

Developed a Smart Home Automation system using Random Forest and K-Means clustering, optimizing energy usage and improving efficiency by 12%.
Designed a Fault Detection System using SVM and Anomaly Detection, identifying network issues in real-time and improving system efficiency by 10%.

Mansai Biomedical PVT LTD, India

Graduate Intern (Jun 2018 – Jun 2019)

Built a Waste Management and Vehicle Tracking System using AWS IoT Core and GPS sensors, enabling real-time monitoring and route optimization.

Projects

IBM Employee Attrition

Data Modeling | SQL | NoSQL (Jan 2024 – Apr 2024)

Reconciled the IBM Attrition Dataset into 3NF, established an ER model representing relationships between data entities, and loaded data into MySQL and MongoDB. Analyzed various factors driving employee attrition using complex SQL and NoSQL queries to extract insights aligned with business use cases.

Market Research Firm Data Analysis

Business Data Warehousing (Jan 2021 – Mar 2021)

Built a Dimensional Fact Model from a normalized transactional database to enable reporting and gain insights into customer behavior in the market.

Skills

Programming Languages

Java
Python
SQL

Databases

Teradata
MySQL
MongoDB

Tools

Tableau
Power BI
Ab Initio GDE
AWS IoT Core
Git
Scrum
Jira

Education

Lindsey Wilson College, Kentucky

Master of Science in Information Technology (Dec 2025)

University of Texas at Arlington, Texas

Master of Science in Business Analytics (Dec 2024)

University of Pune, India

Bachelor of Engineering, Computer Science (May 2021)