Back to Developers
Amarjeet Singh

Amarjeet Singh

Data Analyst and Business Analytics professional

India $30/hr Remote Full-time 4+ yrs exp 98 · Outstanding

About

Data Analyst and Business Analytics professional with 4+ years of experience conducting deep-dive analysis, Root Cause Analysis (RCA), data quality investigations and operational performance analysis across large datasets. Proven ability to identify trends, anomalies, recurring issues and systemic process gaps, translating analytical findings into actionable recommendations that improve operational performance and business outcomes. Proficient in SQL, Python, Tableau, Power BI, statistical analysis, data modelling and ETL pipelines, with a strong focus on data quality, controls, governance and risk. Experienced in collaborating with cross-functional stakeholders, investigating operational issues and escalations, and applying AI and Machine Learning to accelerate insight generation.

Skills & Expertise (78)

SQL Advanced
8.4/10
5
Years Exp
Python Advanced
8.2/10
5
Years Exp
Business Requirements Gathering Advanced
8.0/10
5
Years Exp
Stakeholder Management Advanced
8.0/10
5
Years Exp
Data Visualization Advanced
8.0/10
5
Years Exp
Google BigQuery Advanced
7.8/10
5
Years Exp
Postgresql Advanced
7.6/10
5
Years Exp
Machine Learning Intermediate
7.5/10
3
Years Exp
Tableau Advanced
7.4/10
5
Years Exp
Power BI Advanced
7.2/10
5
Years Exp
Data Integration Advanced
7.0/10
5
Years Exp
Advanced Excel Advanced
7.0/10
5
Years Exp
Microsoft Office Advanced
7.0/10
5
Years Exp
Google Workspace Advanced
7.0/10
5
Years Exp
Data Quality Intermediate
7.0/10
4
Years Exp
Data Validation Intermediate
7.0/10
4
Years Exp
Data Transformation Advanced
7.0/10
5
Years Exp
ETL Pipelines Advanced
7.0/10
5
Years Exp
Statistical Analysis Intermediate
7.0/10
4
Years Exp
Data Modelling Intermediate
6.8/10
5
Years Exp
DAX Intermediate
6.8/10
5
Years Exp
Exploratory data analysis Intermediate
6.5/10
3
Years Exp
VBA Intermediate
6.5/10
5
Years Exp
Time Series Analysis Intermediate
6.5/10
3
Years Exp
correlation analysis Intermediate
6.5/10
3
Years Exp
Model Evaluation Intermediate
6.5/10
3
Years Exp
Hypothesis Testing Intermediate
6.5/10
3
Years Exp
Classification Intermediate
6.5/10
3
Years Exp
Regression Intermediate
6.5/10
3
Years Exp
XGBoost Intermediate
6.5/10
3
Years Exp
Random Forest Intermediate
6.5/10
3
Years Exp
Generative AI Intermediate
6.0/10
2
Years Exp
scikit-learn Intermediate
6.0/10
2
Years Exp
Git Intermediate
6.0/10
3
Years Exp
Docker Intermediate
5.0/10
2
Years Exp
Business Intelligence Excel VBA Business Process Improvement Report Automation Cross-Functional Collaboration Executive Reporting Problem Solving Business Analytics Workflow Automation KPI development Forecasting Trend Analysis Root Cause Analysis Data Storytelling process automation Dashboard Development Executive Dashboards Dimensional Modeling Python Automation SQL Automation Feature Engineering Sap s 4hana Power Query Interactive Dashboards Prompt Engineering Gen AI Data Modeling Data Cleansing Supervised Learning Unsupervised Learning Clustering Functional analysis Cross Validation Logistic Regression Decision Trees Probability Linear Regression Confidence Intervals Statistical Modeling Pandas NumPy Matplotlib

Work Experience

Data & Business Intelligence Analyst

Imperial Logistics

Jun 2025 - Present

Own end-to-end data analysis, business intelligence and reporting initiatives supporting Operations, Finance, Supply Chain, Warehouse and executive leadership teams. Conduct deep-dive Root Cause Analysis (RCA) across operational and performance issues, analyzing transactional data to identify recurring patterns, underlying drivers, anomalies and systemic process gaps. Investigate operational issues, performance exceptions and SLA breaches using SQL-based analysis and process-level investigation, translating findings into corrective actions and process improvement recommendations. Analyze 1.5M+ transactional and operational records annually using SQL, Python, Google BigQuery and PostgreSQL to uncover trends, correlations, anomalies, business risks and improvement opportunities. Partner with cross-functional stakeholders to understand business issues, gather analytical requirements and translate complex findings into actionable change recommendations. Design and maintain 15+ interactive Power BI dashboards tracking 30+ business-critical KPIs across operational performance, transportation efficiency, inventory movement, SLA adherence and productivity. Build advanced SQL queries using joins, aggregations, subqueries and analytical techniques for deep-dive investigations, KPI reporting, data validation and executive decision-making. Investigate data quality issues and discrepancies across operational systems, performing validation and reconciliation to identify root causes and improve reporting reliability. Implement automated data validation, reconciliation and quality control frameworks, improving reporting accuracy by 30% and reducing manual verification effort. Support data lineage and authoritative source identification by documenting source systems, transformation logic, KPI methodologies and validation processes. Design and support ETL pipelines integrating SAP S/4HANA, PostgreSQL and operational systems into centralized analytical datasets and reusable data models. Automate 30+ recurring executive and operational reports using SQL, Python, Excel VBA and Power Query, reducing manual reporting effort by 70% and saving 2,000+ hours annually. Perform statistical, trend and variance analysis to identify performance gaps, operational anomalies and optimization opportunities, monitoring KPI outcomes to evaluate the effectiveness of implemented actions. Developed a Freight Cost Optimization and Billing Reconciliation Framework integrating third-party GPS and billing data to identify discrepancies, validate charges and strengthen pre-invoice controls. Present dashboards, root causes and analytical recommendations to business and technical stakeholders, translating complex data into clear operational actions. Lead reporting standardization, KPI governance and continuous improvement initiatives, contributing to an 18% improvement in operational productivity.

Co-Founder – Operations & Analytics

Amar & Jeet Logistics Private Limited

Jul 2020 - Jun 2023

Co-founded and managed operations and analytics for a logistics business specializing in transportation, warehousing and supply chain services. Directed operations supporting 8,000–10,000 shipments annually across 20 warehouse locations while coordinating with 80+ transport vendors. Conducted deep-dive analysis of operational delays, service issues, cost variances and performance exceptions to identify root causes and implement corrective actions. Investigated operational escalations involving transportation delays, warehouse coordination and service performance, working across teams and external partners to resolve issues and prevent recurrence. Built centralized reporting systems and established KPI governance across On-Time Delivery, SLA Compliance, Fleet Utilization, Dispatch Efficiency, Transportation Cost and Warehouse Productivity. Analyzed recurring performance issues and operational trends to identify systemic process gaps and recommend changes to workflows, resource allocation and transportation planning. Designed executive MIS dashboards and KPI scorecards using Advanced Excel, enabling leadership to monitor trends, exceptions and operational risks. Improved fleet utilization by 22% through analytical route optimization, shipment consolidation and data-driven transportation planning. Reduced operational turnaround time by 20% through Root Cause Analysis, workflow optimization, standardized procedures and continuous improvement initiatives. Automated reporting using Power Query, Pivot Tables, VBA and advanced Excel, reducing manual reporting effort by 60% while improving consistency and control. Led and mentored a cross-functional team of 12–15 employees, allocating work, coordinating resources and supporting consistent operational delivery.

Education

Master of Science in Business Analytics - University of New Haven

2023 - 2025 · United States

Bachelor of Computer Applications (BCA) - GITAM University

2017 - 2020 · India

Certifications

BCG x Forage Data Analytics

Forage · 2026

Six Sigma White Belt

Six Sigma Council · 2026

Google Data Analytics Professional Certification

Google · 2025

Learned about data analysis process life cycle functioning of the job role , along with a capstone project using Google Sheets, Google Big Query, SQL, Google Sheets and R

Google Prompting Essentials

Google · 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 13/15
💰 Rate 5/5
🏆 Certs 5/5
Verified 5/5
Total Score 98/100

Profile Overview

Member sinceJul 2026
Work ModeRemote
AvailabilityFull-time

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation