Gaurav Saraswat
Kitchener,Choose...
Summary
Proven IT Business Analyst with a robust background at Conestoga College, adept in data analytics and strategic planning. Leveraged Power BI and Tableau to enhance decision-making and operational efficiency, demonstrating exceptional teamwork and innovation. Excelled in financial analysis, showcasing a proactive approach to identifying growth opportunities and improving business results.
Overview
6
6
years of professional experience
1
1
Certification
Work History
IT Business Analyst
Conestoga college
Kitchener, Ontario
09.2023 - 12.2024
- Collaborated in meetings with sales and marketing departments to uncover new prospect and client interaction avenues.
- Developed and distributed revenue and client activity benchmark reports to support strategic decision-making.
- Researched client and prospect data, using analyst reports and financial data, to identify risk profiles and opportunities for growth
- Supported the adoption of sales strategies by preparing operational guidance and coordinating resources
- Designed and delivered presentations with data-driven insights to support business development initiatives.
IT Business Analyst
Conestoga college
Kitchener, Ontario
09.2023 - 12.2024
- Conducted data cleaning, transformation, and visualization to derive actionable insights
- Built dynamic dashboards in Power BI and Tableau to track KPIs and pipeline performance
- Analysed the effectiveness of marketing campaigns and recommended strategies to enhance ROI
Financial Analyst
College Project
Delhi, India
08.2018 - 07.2021
- Conducted a comprehensive financial analysis of Reliance Industries Limited, focusing on its financial statements, market performance, and growth strategies
- Analysed key financial ratios such as profitability (Net Profit Margin, ROE), liquidity (Current Ratio, Quick Ratio), and solvency (Debt-to-Equity Ratio) to evaluate the company's financial health
- Studied the revenue contribution from RIL's diverse business segments, including energy, retail, and telecommunications, to understand diversification impact
- Assessed market trends and industry benchmarks to compare RIL's performance against key competitors
- Evaluated the company's capital structure and investment strategies to understand its long-term growth potential
- Prepared detailed financial reports and presented findings, including insights on areas of improvement and potential investment opportunities
- Key Skills: Financial Statement Analysis, Ratio Analysis, Industry Benchmarking, Revenue Segmentation, Capital Structure Analysis, Report Preparation
IT Business Analyst
Conestoga College
- Collaborated with cross-functional teams to document business processes and identify areas for improvement
- Applied SWOT, PESTEL, and RACI methodologies to develop comprehensive business solutions
- Supported the creation of stakeholder engagement plans and project charters for academic case studies
Education
IT Business Analyst -
Conestoga College
Kitchener, ON12.2024
Bachelor of Business Administration - Major (Finance and Accounts)
Aligarh College of Engineering & Technology
Aligarh, UP01.2021
Skills
- Business Analysis
- Operations Support
- Strategic Planning
- Pipeline Composition Analysis
- Revenue Tracking
- Process Improvement
- Data Analytics
- Data Visualization
- Power BI
- Tableau
- Excel
- Python
- NumPy
- Pandas
- SQL
- Customer Relationship Management
- CRM Systems
- Marketing Automation Tools
- Project Management
- Agile
- Scrum
- Waterfall
- JIRA
- Communication
- Training
- Financial Statement Analysis
- Ratio Analysis
- Industry Benchmarking
- Revenue Segmentation
- Capital Structure Analysis
- Report Preparation
- Minitab
- MySQL
- Eloqua
- Aon Connect
- Visual Studio Code
- PyCharm
- Google Colab
- Client Value
- Teamwork
- Innovation
- Business Results
- Integrity
- Trust
- Proactive Approach
- Requirements gathering
- Use case analysis
- Data modeling
- Business intelligence
- User acceptance testing
- Software development life cycle
Certification
- CELPIP, Overall, 8
- Advanced Excel Certification
- Python for Data Science
- Power BI Essential Training
Accomplishments
- Spearheaded the development of a data analytics project that improved pipeline tracking accuracy by 25%.
- Recognized for exceptional teamwork and operational support in academic and professional settings.
- Delivered training sessions to peers on CRM tools and advanced data visualization techniques.
Hobbies and Interests
- Passionate about data-driven decision-making and continuous learning to stay updated with industry trends.
- Enthusiast in developing innovative solutions to drive business growth and operational efficiency.
Behaviouralcompetencies
- Client Value: Skilled in understanding client goals and delivering solutions to drive value.
- Unmatched Teamwork: Effective collaborator, ensuring team alignment with business objectives.
- Innovation: Ability to identify and implement creative solutions for complex problems.
- Business Results: Focused on achieving measurable outcomes through strategic planning and execution.
- Values: Demonstrates integrity, trust, and a proactive approach to protecting organizational interests.
Timeline
IT Business Analyst
Conestoga college
09.2023 - 12.2024
IT Business Analyst
Conestoga college
09.2023 - 12.2024
Financial Analyst
College Project
08.2018 - 07.2021
IT Business Analyst
Conestoga College
IT Business Analyst -
Conestoga College
Bachelor of Business Administration - Major (Finance and Accounts)
Aligarh College of Engineering & Technology
Similar Profiles
Mantasha ShaikhMantasha Shaikh
Operations Support Assistant at Conestoga CollegeOperations Support Assistant at Conestoga College
Karanjeet SinghKaranjeet Singh
SKILLED TRADES TRAINING at Conestoga CollegeSKILLED TRADES TRAINING at Conestoga College
Srinivas GarlapatiSrinivas Garlapati
Professor at Conestoga CollegeProfessor at Conestoga College
Soham PatelSoham Patel
CNC Mill Operator at Conestoga CollegeCNC Mill Operator at Conestoga College
Alexander MoulsdaleAlexander Moulsdale
Duty manager at Lane7Duty manager at Lane7