Prashan Patel

Senior Analyst @Air Canada

Toronto, ON, CA

Developing Operational and near Real-time Power BI, Tableau, Paginated Reports for Airports Operations, Customers, and Baggage data. Cross-combining datasets to generate useful insights. Drive production releases, training, and change management for effective use of reports- Providing end-to-end support for developed reporting infrastructure, maintaining and managing the dataflows and data pipelines- Developing ETLs using Azure Data Factory, Data Lake, Snowflake stored procedures, Talend Jobs, Control-M Jobs, Snowflake views, and tables to enable efficient reporting and data accessibility- Enhancing the existing data processes, handling and solving the job failures by debugging and engaging necessary stakeholders. Working in Agile / Scrum based methodology working in sprints and backlogs- Technical Business Lead for Data Projects: Understand and Gather business requirements, perform exploratory data analysis, generate technical documents and data models, SQL and python scripts for business logics, calculate KPIs and measures, ensure compatibility with enterprise data warehouse and reporting infrastructure, conduct UAT testing, and facilitate production promotion. Working closely with product owners, data architects, and data engineers to develop ETLs- Managing and mentoring a team of Business Insight Analysts, Working on multiple assignments and project requests; Adjusting quickly to changing priorities, and effectively managing complexity and change. Maintaining and promoting a culture of learning and collective growth- Working with tools and languages: Snowflake, Power BI, Oracle DB, SQL, Python, Tableau, Control-M, Azure Data Factory, JIRA, Azure Repos, Git, CI/CD

University of Toronto

Master of Engineering - MEng

Indian Institute of Technology, Roorkee

B. Tech