Jiwan Singh
Ghaziabad
Summary
Senior data analyst with extensive experience at Adda247, utilizing SQL and Power BI to facilitate data-driven decision-making. Proficient in machine learning and data preprocessing, delivering actionable insights that enhance reporting accuracy. Strong collaborator, effectively working across teams to improve efficiency in data analysis processes.
Overview
8
8
years of professional experience
Work History
Senior Data Analyst
Adda247
Gurugram
2025.07 - 2026.05
- Owned end-to-end development of the Power BI reporting ecosystem, delivering executive dashboards to track revenue, enrollments, lead conversion, and campaign performance, enabling leadership to make data-driven decisions in near real time.
- Partnered with Sales, Marketing, Finance, and Product teams to develop structured analytical solutions, facilitating informed cross-functional decision-making.
- Led analytics for the telesales function, identifying lead funnel bottlenecks and enabling enhanced performance tracking and sales optimization.
- Automated reporting workflows and standardized data models, improving data reliability, consistency, and reporting efficiency across teams.
- Built and optimized advanced SQL queries and worked with JSON-based data to extract, transform, and analyze structured and semi-structured datasets, reducing stakeholder dependency on manual data extraction.
- Led analytics transition during CRM migration, re-architecting dashboards and data pipelines to maintain uninterrupted reporting workflows.
- Collaborated closely with Finance teams to validate sales and revenue datasets, reconcile reporting figures, and ensure data accuracy for financial forecasting, revenue analysis, and management reporting.
- Generated insights on student behavior, course demand, revenue trends, and customer segments, supporting targeting strategies and improving engagement.
- Supported financial and business performance analysis by tracking revenue, sales targets, enrollments, campaign ROI, and key business KPIs through automated reporting and dashboards.
Data Analyst
EXL India Pvt Ltd
Gurugram
2023.03 - 2024.03
- Developed and deployed machine learning models to detect and prevent credit card fraud, achieving a reduction in false positives by 20%
- Utilized Python and scikit-learn to implement and optimize predictive models, improving fraud detection accuracy by 15%
- Preprocessed and engineered features on large datasets using SQL and Python, enhancing model performance and reliability for accurate fraud detection
- Performed exploratory data analysis (EDA) with pandas to identify trends, outliers, and potential fraud patterns in large datasets, informing data-driven decision-making
Software Developer 1
Pristyncare
Gurugram
2022.05 - 2022.08
- Developed and implemented Python scripts to automate data cleaning, transformation, and analysis processes, resulting in significant time savings and improved data accuracy
- Utilised advanced SQL queries to extract and analyse data from large databases, uncovering key trends to inform decision-making
- Collaborated with cross-functional teams to gather business requirements, translating them into SQL queries and Python scripts to maintain data integrity
- Conducted thorough data validation and quality checks using SQL and Python, ensuring data accuracy, consistency, and completeness
- Created visualisations to clearly communicate results of data analysis
Senior Analyst
R1 RCM Pvt Ltd
Gurugram
2019.04 - 2021.03
- Collaborated with cross-functional teams to gather data requirements and deliver SQL-based solutions that directly addressed business needs
- Developed and optimized complex SQL queries for data extraction and analysis, improving query efficiency by 20%
- Implemented stored procedures and triggers to automate routine database tasks, resulting in a 40% reduction in manual effort
- Designed and developed interactive Power BI and Tableau dashboards to display key performance indicators and highlight business trends
- Developed and maintained Excel reports, dashboards, and templates, improving data visualization and streamlining reporting processes
Analyst
MD everywhere Pvt Ltd
Noida
2018.02 - 2019.03
- Engaged with clients to gather requirements, clarifying business needs for effective project alignment
- Created customized reports in Microsoft Excel to meet specific client needs, enhancing decision-making capabilities
- Compiled and distributed reports on revenue collection and insurance claims, detailing pending, paid, and unpaid claims for relevant stakeholders
Education
Bachelor of technology - Electronic and communication
R.D engineering college
Ghaziabadpython with data science -
Ducat India Pvt Ltd
Ghaziabad, UPSkills
- Power BI
- Tableau
- AWS
- SQL
- Python
- Finance
- Machine Learning
- Airflow
- Amazon Redshift
- JSON
Languages
English
Timeline
Senior Data Analyst
Adda247
2025.07 - 2026.05
Data Analyst
EXL India Pvt Ltd
2023.03 - 2024.03
Software Developer 1
Pristyncare
2022.05 - 2022.08
Senior Analyst
R1 RCM Pvt Ltd
2019.04 - 2021.03
Analyst
MD everywhere Pvt Ltd
2018.02 - 2019.03
Bachelor of technology - Electronic and communication
R.D engineering college
python with data science -
Ducat India Pvt Ltd