Ishitaa Bhatnagar
Senior Data Analyst
Toronto,Ontario
Summary
- Data Analytics professional with 10-years of experience in designing, developing, and implementing data-driven solutions to support business decisions.
- Proficient in using SQL, Excel, Tableau, PowerBI and advanced Python (Pandas, Numpy, Matplotlib) to manipulate, analyze, and visualize data.
- Strong experience with ETL and working with relational, NoSQL databases including cloud data warehouses solutions like RedShift (AWS), Snowflake.
- Skilled in managing and leading teams across geographies to deliver high-quality data-driven recommendations.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
Work History
Team Lead - Sr. Reporting Analyst
Fidelity Investments Canada
Toronto, Ontario
08.2018 - Current
- Managed Cross-functional teams of 10 in 3 locations (Toronto, Montreal, Mumbai) consisting of data analysts, data engineers and data scientists.
- Brought in Tableau for department's visual analytics need and used advanced functionalities (Dual Axis, Heat Maps, Box and Whisker charts, Scatter Plots, Cross tabs, Histograms, Pivot Table) to build visually compelling dashboards.
- Lead the migration from manual Excel reporting (32 daily reports) to automated self-serving, codified, on-demand reports in Tableau
- Used advanced Python libraries (Pandas, Numpy, Matplotlib, Seaborn) to perform exploratory data analysis (EDA) and feature engineering on curated data from various sources stored in AWS S3
- Performed transformation and quality checks on raw data by using Python (Pandas, UDFs) and advanced SQL.
- Used statical functions in Python to determine standard deviation, Z-score ,linear regression, and variance for outlier detection and identifying ideal data sets.
- Ran forecasting models on historical data for Client Services Dept data which helped to make critical hiring decisions to meet Quarterly targets.
- Mentored and trained junior analysts on data analysis techniques, best practices and tools.
Sr. Reporting Analyst
RBC Investor & Treasury Services
Toronto, Ontario
05.2017 - 05.2018
- Performed SQL server automation of monthly reports which greatly improved productivity by reducing about 12 hours of manual work every month
- Helped align all RBC I&TS Transit changes to sync up with the RBC global platform using advanced Excel functionalities like Pivot Table, V-lookups, H-lookups, Index, Match, IF statement, Macros and Logic checks
- Attended to all HR RFI’s and adhoc RFP’s, which included Tableau dashboards and Excel Reports for all of global I&TS in a prompt and timely manner
- Performed ETL in SQL-Server environment which included database loading, data profiling, data validations and quality assurance
Education
B.Tech - Electronics And Electrical Engineering
PEC University of Technology
Chandigarh, India 09.2007 - 05.2011
Skills
SQL
undefinedTimeline
Team Lead - Sr. Reporting Analyst
Fidelity Investments Canada
08.2018 - Current
Sr. Reporting Analyst
RBC Investor & Treasury Services
05.2017 - 05.2018
B.Tech - Electronics And Electrical Engineering
PEC University of Technology
09.2007 - 05.2011
Similar Profiles
Brittany DurisinBrittany Durisin
Dealer Relations Manager at Fidelity Investments CanadaDealer Relations Manager at Fidelity Investments Canada
Soham ChaubalSoham Chaubal
Coordinator, Client Solutions at Mackenzie InvestmentsCoordinator, Client Solutions at Mackenzie Investments
MICHAEL O'BRIENMICHAEL O'BRIEN
FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)