Jyoti Singh

Data Analyst Intern

CCS Global Tech

Oct 2024 - Current (1 year 8 months)

Collaborated with business stakeholders to define key metrics, ensuring analytics outputs aligned with decision-making requirements. Designed analytical datasets in Snowflake by integrating data from multiple systems using ADF and SQL to support KPI reporting. Created data validation scripts in SQL and Python to ensure consistency, completeness, and accuracy across data layers. Built Power BI dashboards to visualize performance trends, automate business reporting, and provide insights for operational optimization. Implemented Row-Level Security (RLS) in Power BI dashboards to restrict data visibility based on user roles and departments. Optimized SQL queries, Stored Procedures and Snowflake models, reducing dashboard refresh time by 40% and

Data Science Intern

Oncor Electric Delivery

Jan 2024 - Apr 2024 (4 months)

Collected and cleansed large-scale demographic and transaction datasets using Python (Pandas, NumPy) to prepare for analysis. Performed exploratory data analysis (EDA) to detect customer engagement patterns and feature correlations influencing enrolment rates. Developed XGBoost-based model to forecast customer enrolment, improving targeting accuracy by 27% and driving 35% projected growth. Applied K-means clustering to segment customers by behavior and demographics, enabling personalized marketing that enhanced retention. Designed Power BI dashboards to track customer behavior, forecast trends, and visualize model performance in real time and gave recommendations to senior management, enabling data-driven strategic decisions to improve user

C

Business Intelligence Analyst

Collegedunia Web

Mar 2021 - Nov 2022 (1 year 9 months)

Partnered with marketing and finance teams to define KPIs, translate business goals into measurable metrics, and align analytics strategy. Analyzed marketing and financial datasets using SQL and Python to uncover patterns in ROI, conversion rates, and campaign effectiveness. Built optimized data models in Azure Synapse to unify reporting and ensure consistency in financial and marketing performance metrics. Conducted forecasting and variance analysis to identify revenue deviations and support monthly and quarterly financial planning. Built interactive Power BI dashboards with row-level security and user-based access controls, tracking revenue, expenses, and marketing KPIs, improving data reliability and enabling faster insights by reducing

M

Data Analyst

Machenzzo India

Jul 2019 - Feb 2021 (1 year 8 months)

Developed KPIs to measure procurement turnaround, delivery accuracy, and vendor reliability across multiple product lines. Analyzed purchasing data and supplier contracts using SQL and Excel to identify cost-saving opportunities and bundling patterns. Built automated reports to track inventory movement and forecast material demand, reducing excess stock by 13%. Designed Power BI dashboards to monitor supplier performance, lead times, and quality metrics, improving supply chain efficiency by 7%. Collaborated with operations and finance teams to translate analytical findings into actionable strategies that improved margins by 5%.

About

Detail

Timeline

Résumé