Sagar Limbachiya

Sagar limbachiya

bookmark on deepenrich
location of Sagar LimbachiyaYork, Ontario, Canada
Phone number of Sagar Limbachiya+91 xxxx xxxxx
Followers of Sagar Limbachiya1000 followers
  • Timeline

    Aug 2015 - Jun 2016

    Lead Project Manager

    K3 PROPERTY LTD
    Mar 2016 - Apr 2022

    Sr. Business Analyst

    Inventure Growth & Securities Ltd.
    Mumbai Area, India
    May 2022 - Jul 2024

    Business Analyst

    QualPro Systems Inc.
    Current Company
    Jul 2024 - now

    Business Analyst

    Metrolinx
  • About me

    Business Analyst - Data & IT Solutions | Microsoft Certified: Power BI Data Analyst PL-300| Business Analytics | Certified Scrum Master(CSM)®

  • Education

    • B.k birla centre for education

      2006 - 2009
      Secondary education above distinction

      Have Scored 89.33%

    • Humber college

      2022 - 2023
      Business insights & analytics business analyst 3.8

      Business Analyst | Data AnalystProgram website: https://business.humber.ca/programs/business-insights-and-analytics.htmlCourses and projects completed/in progress:- Big Data II (R, Neo4j, Cypher)- Big Data I (Hadoop architecture, HDFS, MapReduce, Hive, Pig, Zeppelin, HBase, Sqoop)- Machine Learning (Python)- Data Analytics Tools (Advance Excel, IBM Cognos, IBM SPSS Modeler)- Quantitative Research Methods and Analysis - Data Analytics Governance and… Show more Business Analyst | Data AnalystProgram website: https://business.humber.ca/programs/business-insights-and-analytics.htmlCourses and projects completed/in progress:- Big Data II (R, Neo4j, Cypher)- Big Data I (Hadoop architecture, HDFS, MapReduce, Hive, Pig, Zeppelin, HBase, Sqoop)- Machine Learning (Python)- Data Analytics Tools (Advance Excel, IBM Cognos, IBM SPSS Modeler)- Quantitative Research Methods and Analysis - Data Analytics Governance and Ethics- Introduction to Statistical Software Languages (Java project for the admissions department at Humber College)- Database and SQL Fundamentals (Project: Hypothetical Supermarket database using SQl queries)- Finance and Accounting for Managers- Operations Management (Supply Chain)- Introduction to Business Insights and Analytics (Project: Credit Risk in Banking)- Canadian Business and Industry Show less

    • K. j. somaiya institute of engineering and information technology

      2011 - 2015
      Bachelors of engineering electronics and telecommunications a
    • Bhavans college

      2009 - 2011
      Higher secondary education science a

      Have Scored 83.50%

  • Experience

    • K3 property ltd

      Aug 2015 - Jun 2016
      Lead project manager

      Real Estate and E-commerce Platform• Enrolled and supervised 400+ postgraduate interns for real estate projects.• Conducted training on Indian real estate market fundamentals.• Managed project timelines, resources, and budgets.• Facilitated communication between interns, stakeholders, and management.• Provided mentorship and feedback to interns.• Evaluated project outcomes and implemented improvements.• Collaborated with HR and department heads on internship programs.• Handled administrative tasks for intern onboarding and evaluation. Show less

    • Inventure growth & securities ltd.

      Mar 2016 - Apr 2022

      Capital Markets, IT Solutions, and Process Enhancement• Led a project to build an equity-leveraging product with a substantial fund size.• Executed a project plan for implementing internet trading applications and ERP migration, adhering to the Software Development Life Cycle (SDLC).• Conducted comprehensive Quality Assessments in UAT and IST phases to ensure quality standards for feature development.• Planned and implemented equity trading mobile application development, documenting comprehensive business requirements and processes.• Built an Excel data model and automated dashboard to track company-client Equity/Cash collaterals, significantly reducing working capital.• Increased productivity by building a sales revenue dashboard on Tableau.• Facilitated meetings with stakeholders, team members, and business partners for process optimization and data migration automation in a trading system.• Collaborated with Data Engineers to analyze order retention metrics and trends using advanced data analytics techniques.• Implemented Agile Scrum methodologies for eKYC integration, leading efficient Scrum meetings and achieving faster client acquisition.• Created PowerBI reports and Tableau Dashboards, boosting executive decision-making efficiency.• Worked cross-functionally to create flow diagrams for user flows, system flows, and processes, identifying risks, dependencies, and requirements for the eKYC project.• Wrote complex SQL queries to obtain actionable insights for business process improvement.• Assessed feasibility and impact of requirements by reviewing FRD/TRD documents.• Developed approach and effort estimation documents for project planning.• Created diagrams and flowcharts using Lucidchart and Visio for clear project visualization.• Developed dynamic dashboards using SQL, Tableau, Power BI, and DAX queries.• Developed and executed deployment strategies, ensuring timely deliverable deployments and resolving client queries efficiently. Show less Domain: Banking and Business Operations• Conducted product design reviews throughout the software development lifecycle, providing input on requirements, designs, schedules, and potential issues.• Developed innovative Loan Approval System (LAS) products, driving profitability and market penetration.• Oversaw the LAS product lifecycle, including performance monitoring, key metric analysis, and feedback collection.• Conducted market analysis and competitor monitoring to make data-driven product enhancements.• Assessed and mitigated loan application and collateral risks, collaborating with the risk management team to protect company interests.• Compiled and distributed weekly and monthly reports to track team progress and project milestones.• Ensured accuracy and completeness of Software Requirement Specifications (SRS), Functional Specification Documents (FSD), and other critical documentation.• Facilitated workshops to gather, review, and validate business requirements, business processes, models, rules, and UI designs.• Developed Business and Functional Requirements through Joint Application Development (JAD) sessions.• Managed project schedules and plans, including UI design and UML modeling (use cases, activity diagrams, and state machine models).• Coordinated cross-functional teams for timely code reviews and integration of base code changes; organized and led project meetings. Show less

      • Sr. Business Analyst

        May 2017 - Apr 2022
      • Business Analyst

        Mar 2016 - May 2017
    • Qualpro systems inc.

      May 2022 - Jul 2024
      Business analyst

      Banking and Capital Markets - IT & Data Solutions• Developed Python scripts for seamless ETL processes, extracting data from diverse sources, transforming it, and loading it into target systems for thorough analysis.• Created engaging Power BI dashboards, presenting insights from IST and UAT for effective decision-making by stakeholders, and developed a comprehensive Power BI dashboard showcasing critical regulatory alerts for non-compliance in trade execution within Global Banking and Markets.• Spearheaded the formulation of the System Requirements Document (SRD) for the Market Order Retention project, ensuring data quality, mapping jobs, resolution, storage, and computation for reporting purposes.• Collaborated effectively with stakeholders, including business users, data engineers, and developers, to gather requirements and document data-related aspects in the SRD, aligning with project objectives.• Generated market order data reports by proficiently writing SQL queries in Dremio, handling structured and unstructured data.• Utilized Elasticsearch queries to analyze unstructured data like JSON from Kafka topics, uncovering valuable insights for data-driven decision-making.• Conducted thorough Nifi data pipeline flow analysis, optimizing ETL processes for desired output, streamlining data flow, and enhancing data integrity.• Conducting comprehensive analysis of complex data from varied relational and non-relational sources.• Produced timely ad-hoc reports, distilling insights from data exploration into simplified visualizations and reports for stakeholders. Achieved a 15% reduction in response time for ad-hoc report requests, facilitating quicker decision-making.• Implemented forecast models utilizing regression analysis and time series modeling, resulting in a significant improvement in project completion estimate accuracy by 18%. Show less

    • Metrolinx

      Jul 2024 - now
      Business analyst
  • Licenses & Certifications