Jayesh Potwade

Enterprise Data Architect @YASH Technologies

Kitchener, ON, CA
MOBILE NUMBERS
+91 *********19

Signup · Get unlimited contacts

WORK HISTORY

Oct 2023 — Present

Enterprise Data Architect @YASH Technologies

View department →

Toronto, ON, CA

Data Architecture and Management: Designed and implemented the Medalion architecture, classifying data sets into High and Low zones for diverse sources. Led the successful ingestion of Oracle HCM Cloud data, creating a robust HR data model within the ADLS data lake. Established a centralized Data Lake & Hub, seamlessly ingesting data from Oracle Cloud, Synapse dedicated SQL Pool, sharepoint and on-premises databases.Delta Lake Implementation and Enhancement: Implemented and managed Delta Lake solutions, achieving a significant 30% improvement in data reliability and query performance. Pioneered the adoption of Lake House architecture, integrating structured and unstructured data for superior analytics and reporting capabilities.Data Governance and Collaboration: Established and maintained a comprehensive Unity Catalog, optimizing data discovery and fostering collaboration. Collaborated with cross-functional teams to design data pipelines, enabling self-service data access through the Unity Catalog.Security and Compliance: Classified data based on PII and Non-PII datasets, implementing a secure high and low zone segregation. Engineered an encryption framework preventing unauthorized data access. Implemented a robust data governance framework with Role-based access policies via Masking.Team Leadership and Coordination: Led a team of 30+ experts in data ingestion, governance, platform engineering, and analysis. Coordinated with other architectural teams to design resilient solutions and implement a toolset supportingthe overall data environment.Security Measures and Monitoring: Implemented comprehensive security measures, including Data Encryption, Classification, Governance, and security.

EDUCATION

2006 — 2009

Ramniranjan Jhunjhunwala College (Autonomous)

Bachelor's degree, Computer Science

SKILLS

Ms Reporting ServicesT-SqlData MartsData WarehousingOracleRequirements AnalysisBusiness ProcessAsp.netMicrosoft Sql ServerMs Integration ServicesSsrsEtlData QualityPowerbiDatabase DesignDtsSql Server Integration Services (Ssis)SsisPl/SqlBusiness IntelligenceAnalysis Services

ABOUT JAYESH POTWADE

As an Enterprise Data Architect, I design and implement cloud-based data solutions that enable reliable, secure, and scalable data analytics and reporting for the transportation sector. I have over 15 years of experience in Big Data, Business Intelligence, and Data Governance, with 8 years of specialization in Azure Cloud Services.I have successfully led the Medalion architecture, the Delta Lake implementation, and the integration of Oracle HCM Cloud data with Azure Data Lake and Hub, achieving significant improvements in data quality, performance, and access. I have also pioneered the adoption of Lake House architecture, leveraging the power of Azure Synapse and Snowflake databases to optimize data environments and insights. Additionally, I have implemented advanced analytics and reporting frameworks using PowerBI, nSight, and Tableau, delivering user-specific dashboards and KPIs that support business decisions and strategies. My mission is to empower Metrolinx and its stakeholders with data-driven solutions that enhance the transportation experience and outcomes.

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.

Jayesh Potwade — Enterprise Data Architect at YASH Technologies in Kitchener, ON, CA | Unifers