Hir Joshi
208-540 Smith Ave, Coquitlam
Summary
Skilled Data and Finance Professional with 4+ years of experience in data analysis, financial forecasting, and process improvement. Proficient in Power BI, SQL, and Excel for advanced data visualization and financial reporting. Skilled in budgeting, cash flow management, and financial modeling to support strategic decision-making. Strong leadership in process optimization and cross-functional collaboration to enhance data accuracy and efficiency.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Financial Business Analyst
TransLink
07.2023 - 12.2024
- Performed monthly rollovers to prepare financial data and reports for the new reporting period.
- Created and analyzed cash flow reports to assist in financial planning and forecasting.
- Regularly updated the FSM tool with the latest financial data, and organized projects into batches, importing them into Access for streamlined data management.
- Conducted regular data checks to ensure accuracy and consistency across all databases and reporting tools.
- Provided support for technical issues related to databases, finance tools, and reporting systems, to ensure smooth operations.
- Managed forecasting, budgeting, and projections using advanced Excel techniques, including pivot tables and budget formulas.
Data Analyst
Cognizant
02.2020 - 06.2023
- Developed interactive dashboards and reports using Power BI, Tableau, and Excel, facilitating data visualization and storytelling.
- Performing data cleaning using Python and SQL to ensure data accuracy, integrity, and quality for effective analysis and decision-making.
- Developing and maintaining efficient ETL workflows for consolidating and transforming diverse data sources into a centralized repository, supporting analysis and reporting needs.
- Applied statistical techniques and hypothesis testing to derive meaningful insights from large datasets.
- Collaborated with cross-functional teams to define data governance practices and enforce data quality standards.
- Designing, creating, optimizing data models (in collaboration with data architect) and migration methods for existing data.
Education
Bachelor of Science - Computer Science
York University
09.2019
Skills
- Excel, Power BI
- Data Analysis, Reports
- Cash Flow Forecasting
- SQL, Python, HTML, CSS
- ETL, Azure Pipeline
- Data Auditing, Data Governance
- Azure Data Factory, Salesforce
- JIRA, ServiceNow
Certification
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Salesforce Certified: Administrator (ADM-201)
Timeline
Financial Business Analyst
TransLink
07.2023 - 12.2024
Data Analyst
Cognizant
02.2020 - 06.2023
Bachelor of Science - Computer Science
York University
Similar Profiles
Sun Young ParkSun Young Park
Innovative Impact Award at TranslinkInnovative Impact Award at Translink
Srikanth VenkataSrikanth Venkata
ETL QA Specialist at TransLinkETL QA Specialist at TransLink
Simran PuriSimran Puri
Cost Administrator at TransLinkCost Administrator at TransLink