CRM and Database Analyst

Chander Rekha Sehgal

908-***-**** **********@*****.*** LinkedIn GitHub New Jersey, US

Summary of Experience

Data Analyst with 4 years of experience in analytics and visualization, recently graduated with an MS in Data Science from Saint

Peter s University, Jersey City. Proficient in SQL, Python, Power BI, Tableau and statistical methods to create interactive

dashboards and timely reports. Demonstrated success integrating survey and CRM data to produce actionable insights for

stakeholders. Strong communicator skilled at translating complex findings for both technical and non-technical audiences.

Skills

Programming Languages: Python, R, SQL, DAX

Data Visualization Tools: Power BI, Tableau, Advanced Excel (Pivot Tables and Power Query)

Applications & Platforms: Salesforce CRM, Power BI Service, JIRA, Balsamiq and Visual Paradigm, VS Code, GitHub

Databases: Microsoft SQL

Data Management: Data Cleaning, Data Extraction, Working With Large Datasets

Data Engineering Concepts: ETL Pipelines, Data Modeling, Data Warehousing, Data Integration, SQL Views & Tables

Soft Skills: Eagerness To Learn

Certifications

Microsoft Power BI Data Analyst Associate: May 2024

Data Analytics Essentials: University of Texas at Austin, McCombs School of Business (May 2024)

Certificate in Business Analysis: Techno Canada Centre of Excellence (2020)

Salesforce Sales Consultant Certification: 2020

Salesforce Administrator: 2016

Projects Jan 2025 May 2026

Capstone Project - Cardiovascular Risk Prediction Dashboard (Python, Scikit-learn & Streamlit)

Developed an end-to-end cardiovascular risk prediction system using Machine Learning models to analyze patient health data

and identify high-risk individuals.

Built and optimized predictive models using Scikit-learn (Gradient Boosting / Random Forest), applying feature engineering

and preprocessing techniques to improve model performance.

Designed an interactive Streamlit dashboard for real-time risk scoring, patient analysis, and healthcare data visualization.

Implemented feature importance analysis and what-if scenario simulations to identify key cardiovascular risk drivers and su

pport clinical decision-making.

Utilized Python, Pandas, and NumPy for large-scale healthcare data cleaning, transformation, and exploratory analysis.

AI Healthcare Agent (IBM Watsonx & Streamlit)

Developed and deployed an Agentic AI Healthcare System using Python, Streamlit, Scikit-learn, and IBM Watsonx for cardi

ovascular risk prediction and explainable AI-driven clinical assessment.

Built a multi-agent orchestration pipeline consisting of diagnosis, triage, recommendation, and LLM-based explanation agents

to simulate intelligent healthcare decision workflows.

Trained and optimized a Random Forest classification model using clinical heart disease data, implementing feature scaling, p

robability calibration, and cross-validation for improved predictive performance.

Integrated IBM Watsonx foundation models to generate natural-language clinical explanations and patient-friendly interpretat

ions of ML predictions.

Designed and deployed an interactive Streamlit dashboard with real-time risk scoring, triage visualization, and AI-generated

recommendations, hosted through GitHub and Streamlit Community Cloud.

Movie Recommendation System (Apache Spark & Databricks)

Developed a scalable recommendation engine using ALS Collaborative Filtering on a dataset of 20M+ ratings.

Optimized a distributed ML pipeline to manage 3.7B possible user-movie interactions, achieving an RMSE of 0.8159.

Leveraged Spark MLlib to perform matrix factorization, learning latent features for 138k+ users to generate Top 5

personalized recommendations.

Urban Thermal Regime & Warming Trend Analysis (K-Means clustering and Linear Regression)

Applied K-Means Clustering to a Berkeley Earth dataset of major global cities to identify 4 distinct urban thermal regimes

based on temperature variability.

Engineered 26 temporal and geospatial features, including latitude-based segmentation, to analyze structural heterogeneity in

temperature dynamics.

Conducted Linear Regression to estimate warming rates, discovering that Hot-Variable regimes are warming at 0.10 C per

decade nearly twice the rate of colder regimes.

Delivered actionable insights on urban heat risks, highlighting how land-surface transformation in rapidly urbanizing regions

accelerates local warming.

NYC Waste Diversion & Sustainability Analytics (Tableau)

Synthesized 10 years of DSNY and Census data (2013 2023) to visualize borough-level disparities in waste generation and

diversion performance.

Architected an interactive Tableau storyboard to identify "recycling gaps" and seasonal waste patterns, uncovering specific

underserved areas for municipal intervention.

Leveraged data storytelling to translate complex sustainability challenges into actionable insights for targeted, data-driven

service accessibility improvements.

University Enrollment Relational Database (SQL)

Engineered a robust relational database in 3rd Normal Form (3NF) to manage academic records, ensuring 100% data

consistency and eliminating redundancy.

Designed a complex ER Schema featuring 1:M and M:N relationships to support cross-listed courses, faculty assignments,

and student enrollments.

Implemented Referential Integrity constraints and Primary/Foreign Key architectures to maintain a scalable and

high-performance DBMS structure.

Starbucks: Digital Transformation & Operational Strategy (Python & Tableau)

Engineered a multi-dimensional analytics framework to evaluate the impact of digital transformation and loyalty programs on

Starbucks' global revenue and post-COVID recovery.

Analyzed customer offer engagement across diverse demographics using Python, identifying key behavior patterns to

optimize offer personalization and loyalty retention.

Conducted a data-driven sustainability audit, benchmarking GHG emissions, waste diversion, and reusable cup adoption

against 2030 corporate targets.

Developed interactive Tableau dashboards to visualize regional financial trends, providing strategic recommendations for

operational efficiency and sustainability acceleration.

Automotive Fuel Efficiency Predictive Modeling (Python, R, & Tableau)

Engineered a comparative analytical framework using Python and R to evaluate the impact of engine specifications on fuel

efficiency (MPG) for the Auto MPG dataset.

Developed and optimized Multiple Linear Regression models on 300+ training samples, achieving high predictive accuracy

validated through R-squared metrics.

Conducted rigorous model validation on a 98-sample test set, utilizing residual analysis and error metrics to ensure statistical

reliability.

Designed an interactive Tableau suite to visualize exploratory data patterns, translating complex regression outputs into a

stakeholder-ready final report.

NYC Food Scrap Accessibility & Geospatial Analysis (Python & Power BI)

Analyzed the spatial distribution and operational efficiency of 591 food scrap drop-off locations using NYC Open Data.

Engineered a geospatial analysis pipeline in Python to identify "service deserts" and accessibility gaps in borough-level

composting infrastructure.

Architected an interactive Power BI dashboard visualizing site density and operational availability, providing data-driven

recommendations to improve municipal waste diversion.

Synthesized complex operational patterns to identify underserved neighborhoods, directly supporting long-term sustainability

and composting equity goals.

Work Experience

Synergy Technofin Pvt. Ltd.

Data Analyst Power BI Developer Jun 2024 - Nov 2024

The project was to generate actionable insights from farmers survey data across 11 states in India, analyze key agricultural trends and

identify areas for improvement to enhance productivity and efficiency.

Designed and developed interactive Power BI dashboards, leveraging SQL and Python for data extraction, transformation, and

analysis of large datasets.

Built and maintained data transformation pipelines to clean, merge, and validate data from multiple sources, ensuring data integrity

and consistency.

Developed structured datasets for reporting and performed data modeling for analytics, improving dashboard performance and

usability.

Created and optimized DAX calculations, including measures, calculated columns, and tables.

Collaborated with cross-functional teams to define data requirements and deliver actionable insights for decision-making.

Automated reporting processes and presented insights to stakeholders, supporting process improvements and strategic planning.

Bolkris Solutions, Toronto

Data Analyst Admin Toronto Oct 2019 - Jul 2022

Analyzed Salesforce CRM data and developed Tableau dashboards to monitor key business metrics and support operational

decision-making.

Supported ETL processes by transforming and integrating data from multiple sources into structured formats for reporting.

Assisted in creating and maintaining tables, views, and data structures to improve data accessibility and reporting efficiency.

Collaborated with stakeholders to gather requirements and align BI solutions with business objectives.

Participated in full SDLC lifecycle, ensuring successful delivery of data-driven solutions using Agile methodology.

CRM Consultant Toronto Feb 2016 - Apr 2017

Managed and customized CRM systems, improving data capture, storage, and reporting efficiency.

Developed dashboards and reports using structured datasets to provide actionable insights for sales and marketing teams.

Implemented data validation, migration, and transformation processes, ensuring high data quality and reliability.

Integrated third-party tools to streamline data flows and reporting pipelines across systems.

Bell Media, Toronto

Data Administrator (SAP) Toronto Jan 2015 - Jun 2015

Monitored and resolved workflow errors in SAP Business Workplace for TS Group managers to ensure smooth financial o

perations.

Coordinated with vendor representatives for quotes, status and invoice updates.

Created purchase orders for capital and operating budgets for several departments

Created and maintained financial budget and cash flow reports for projects on a monthly/quarterly basis.

Created accrual reports for finance on a monthly basis.

Synergy Technofin Pvt. Ltd.

Agri-Business Manager New Delhi Oct 2011 - Mar 2013

Conducted financial analysis and developed strategic business plans.

Led monitoring and evaluation projects for government schemes.

Prepared feasibility studies, value chain analyses, and project reports.

Indian Society of Agri-business Professionals

Assistant Project Manager New Delhi Jul 2010 - Sep 2011

Managed the India Certified Crop Adviser (CCA) program.

Coordinated marketing initiatives and developed outreach materials.

Identified funding opportunities and built partnerships with stakeholders.

Global AgriSystem Pvt. Ltd.

Assistant Manager New Delhi Sep 2007 - Jun 2010

Developed feasibility reports and business plans for agriculture projects.

Managed project planning, budgeting, and performance tracking (MIS/reporting).

Conducted data analysis and supported clients with business strategy and expansion.

Sutlej Agriculture Pvt. Ltd.

Assistant Manager New Delhi Oct 2005 - Aug 2007

Managed large-scale farm operations (1000+ acres) and crop planning activities.

Implemented data tracking systems, forecasting, and productivity monitoring.

Ensured compliance with quality standards (GAP, GlobalGAP, HACCP) and supported supply chain coordination.

EDUCATION

M.S in Data Science Jan '25 - May '26

Saint Peter's University, Jersey City, NJ

Trained in data analytics, machine learning, and business intelligence

Experienced in Python, Power BI, Tableau, SQL, and data visualization; applied learning through project-based work

Contact this candidate