Rahul Patil, Developer in Oakville, ON, Canada
Rahul is available for hire
Hire Rahul

Rahul Patil

Verified Expert  in Engineering

Data Architecture Developer

Location
Oakville, ON, Canada
Toptal Member Since
July 29, 2020

Rahul is a versatile, results-oriented professional with demonstrated success in enterprise data architecture, analytics, strategy, and software development. He has expertise in overseeing technology improvement initiatives, aligning information services with business goals, increasing reliability, maximizing productivity, and introducing system efficiencies. Rahul possesses a unique blend of business acumen and diverse industry background spanning banking, asset management, and insurance.

Portfolio

Private Markets Investment Firm
Data Architecture, Business Intelligence (BI), Data Integration, Azure...
Large Global Insurance Firm
Amazon Web Services (AWS), Business Intelligence (BI), Data Architecture...
Asset Management Firm (based out of NYC/CT)
Amazon Web Services (AWS), Tableau, Talend, Microsoft SQL Server, ETL...

Experience

Availability

Part-time

Preferred Environment

Data Architecture, Data Warehousing, ETL, Visualization, Microsoft Power BI, Snowflake, Synapse, Data Modeling, Salesforce, PL/SQL

The most amazing...

...customer analytics platform I've built integrated multiple data systems and created a single data repository that enabled a 360-degree customer view.

Work Experience

Enterprise Data Architect

2021 - PRESENT
Private Markets Investment Firm
  • Developed a detailed roadmap outlining key milestones and initiatives for the data architecture, providing a clear guide for the implementation and evolution of data systems over multiple phases.
  • Pioneered the conceptualization and implementation of an Enterprise Data Warehouse (EDW) from the ground up, tailoring it to the organization's unique requirements and data sources.
  • Led the successful set up of a comprehensive data infrastructure in Microsoft Azure, leveraging a wide range of Azure services, including Azure Data Lake Storage, Azure SQL Database, Azure Data Factory, and Azure Synapse.
  • Crafted a forward-looking vision for the firm's data architecture, aligning it with strategic business objectives and ensuring scalability to accommodate future growth and evolving data needs.
Technologies: Data Architecture, Business Intelligence (BI), Data Integration, Azure, Microsoft Power BI, Synapse, Data Modeling

Senior Data Architect

2020 - 2021
Large Global Insurance Firm
  • Planned and executed a strategy roadmap for migrating 14 on-premise data stores/marts to Cloud (AWS – Snowflake).
  • Spearheaded a cost-effective and high-speed-to-market method of acquiring new data into the warehouse, reducing development time by 80%.
  • Became a key member of Analytics CoE across all lines of business and data applications under Canadian segment purview.
  • Led and executed architecture and delivery of highly scalable, cloud-native/on-premise analytics data platform.
Technologies: Amazon Web Services (AWS), Business Intelligence (BI), Data Architecture, Snowflake, Data Warehouse Design, Oracle, SQL Server BI, Data Integration, Key Performance Indicators (KPIs)

Data Architect

2017 - 2020
Asset Management Firm (based out of NYC/CT)
  • Led the efforts to construct data lake/data hubs to enable advanced analytics and dashboarding that empowered better business decision making.
  • Enabled 360 client view by establishing intuitive Tableau reports/dashboards with highly effective and simplistic visualizations.
  • Outlined overall data architecture plan and analytics initiatives within the customer analytics group for data from third-party applications/data repositories and Sales cloud/Pardot/Google Analytics.
  • Accomplished end-to-end event-driven integration leveraging messaging queues - Rabbit MQs/Active MQs.
Technologies: Amazon Web Services (AWS), Tableau, Talend, Microsoft SQL Server, ETL, Microsoft Power BI, Business Intelligence (BI), Power Query, DAX

Data Governance and Architecture

2015 - 2017
Asset Management Firm
  • Established data governance strategies; devised and modeled robust data schema to build custom intuitive data marts readily used by reporting and data visualization teams.
  • Partnered with a cross line of business teams to facilitate data registration and processes related to overall data management.
  • Closely coordinated with business intelligence and technology teams to call out and align data dependencies across platforms and capabilities.
  • Served as the central point of contact for data definition standards, data extraction, translation, and lineage patterns leveraged by the enterprise analytics team. Also promoted the usage of certified datasets across reporting enterprise.
Technologies: Datastage, MicroStrategy, Oracle Exadata, ETL, Business Intelligence (BI), Power Query

DW Architect

2011 - 2015
Insurance Firm in CT, USA
  • Re-architected, led, and executed several key data transformation processes within the group resulting in lower overhead maintenance cost and helped to enhance modules for new business acquisitions and setups.
  • Controlled and administered data warehouse environment including security, data growth, performance, platform upgrades, support agreements, and disaster recovery.
  • Executed long term data archival, proactive monitoring, database metrics, and storage cost optimization strategies.
  • Translated business and data requirements into Logical data models in support of enterprise data models, OLTP, operational data structures, and analytical systems.
  • Formulated and constructed business schema to drive the creation of business reports, documents, and dashboards.
Technologies: Tableau, Informatica, Oracle, ETL, Microsoft Power BI, Business Intelligence (BI)

ETL Technology Lead/Business Intelligence Developer

2006 - 2010
Insurance/Investment firm
  • Specified and standardized architectural solutions across investment group. Facilitated consistent BI designs, resolved issues and ensured deployment of projects sourcing data from Oracle systems, as well as from third-party application DB’s.
  • Led multiple different roles such as release manager, data migration lead, integration architect, and technical lead. Gained 360-degree work experience in various aspects of data warehouse solution development.
  • Built ETL processes, query optimization techniques, and replication schemas to facilitate high-quality and efficient data processing and delivery as enforced. Collaborated in the development of technical designs and functional specifications of ODS.
  • Led partnership with data integration hubs around data modeling, data mappings, hierarchy management, and overall security. Provide continuous enhancement and review of MDM matching rules, data quality, and validation processes.
Technologies: Oracle, Business Objectives, Informatica, SQL, DB, ETL, Business Intelligence (BI), DAX

Customer Analytics Platform

A customer analytics platform built up from group up enabling 360-degree client view. I was the lead architect and developer and liaised with several internal and external groups to integrate customer data from several disparate systems under a single data repository. It provided highly effective business insights and enabled strategic decision-making abilities.
2019 - 2020

Master's Degree in Applied Data Analytics

Boston University - Boston, MA

JUNE 2020 - JUNE 2022

SnowPro Core

Snowflake

MAY 2020 - PRESENT

Tableau Desktop Specialist

Tableau

MARCH 2019 - MARCH 2022

AWS Certified Developer - Associate

AWS

MARCH 2019 - MARCH 2022

AWS Certified Solutions Architect - Associate

AWS

Tools

Informatica ETL, Microsoft Power BI, Power Query, Tableau, Oracle Exadata, Synapse, SQL Server BI

Languages

SQL, Snowflake, Python 3, R

Paradigms

ETL, Business Intelligence (BI), Data Science

Platforms

Talend, Windows, Oracle, Amazon Web Services (AWS), Salesforce, Azure

Storage

Database Modeling, Microsoft SQL Server, DB, Datastage, PL/SQL, Data Integration

Other

Data, Data Modeling, Data Architecture, Informatica, Business Objectives, MicroStrategy, Data Warehouse Design, Data Warehousing, Data Scientist, erwin Data Modeler, DAX, Visualization, Key Performance Indicators (KPIs)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring