Jiwan Singh
Ghaziabad
Summary
Senior data analyst with extensive experience at Adda247, utilising 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, India
2025.07 - Current
- Owned end-to-end development of 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, enhancing cross-departmental decision-making.
- Led analytics for telesales function, identifying lead funnel bottlenecks and improving performance tracking.
- Automated reporting workflows and standardized data models, enhancing data reliability across teams.
- Built and optimized advanced SQL queries, reducing stakeholder dependency on manual data extraction.
- Led analytics transition during CRM migration, re-architecting dashboards to maintain uninterrupted reporting workflows.
- Validated sales datasets for finance team, ensuring accuracy and reliability for financial forecasting and reporting.
- Generated insights on student behaviour and course demand, refining targeting strategies for improved engagement.
Data Analyst
EXL India Pvt Ltd
Gurugram
2023.03 - 2024.03
- Utilized Python and scikit-learn to implement and optimize predictive models, improving fraud detection accuracy by 15%
- Developed and deployed machine learning models to detect and prevent credit card fraud, achieving a reduction in false positives by 20%
- Preprocessed and engineered features on large datasets using SQL and Python, improving model performance and reliability
- Performed exploratory data analysis (EDA) with pandas to uncover trends, outliers, and potential fraud patterns in large datasets
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, supporting informed decision-making and revealing key trends
- Collaborated with cross-functional teams to gather business requirements and translate them into SQL queries and Python scripts, maintaining data integrity and fulfilling project objectives
- Conducted thorough data validation and quality checks using SQL and Python, ensuring data accuracy, consistency, and completeness
- Developed visualisations to effectively 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 addressing 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 to enhance data visualisation and reporting efficiency
Analyst
MD everywhere Pvt Ltd
Noida
2018.02 - 2019.03
- Communicated with clients to gather requirements, ensuring clear understanding of business needs
- Developed tailored reports in Microsoft Excel based on specific client requirements
- Compiled reports on business-related issues such as revenue collection and insurance claims, including pending, paid, and unpaid claims, using Excel for distribution to relevant stakeholders
Education
Bachelor of technology - Electronic and communication
R.D engineering college
Ghaziabad2015-08
python with data science -
Ducat India Pvt Ltd
Ghaziabad, UP2022-01
Skills
- SQL
- Python
- Data Preprocessing
- Machine Learning Expertise
- Power BI
- Tableau
Languages
English
Timeline
Senior Data Analyst
Adda247
2025.07 - Current
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