Deepanshu Vohra

Deepanshu Vohra Email and Phone Number

SVP - Lead Data Engineer & Data Scientist | EX- JP Morgan Chase / Goldman Sachs / Fidelity Investment | AI & ML -Engineer | NLP | Tableau | Azure Data Factory | AWS | Data Engineering | SQL Engineer | Python @ NatWest
Deepanshu Vohra's Location
Edinburgh, Scotland, United Kingdom, United Kingdom
About Deepanshu Vohra

An experienced Senior Technology Lead with a track record of success in the US & UK financial services and UK General Insurance sector. Having strong domain expertise in Fixed Income, Capital Markets, and Equity Markets, as well as a track record in the financial services business (Investment banking and Retail banking).Due to my keen interest in the data science field, I recently earned MSc Degree in Artificial Intelligence from the University of Aberdeen, UK in Nov 2021.DATA is the new oil, and deriving, analyzing, and converting knowledge from data into meaningful results is my passion. Data Science, Machine Learning Algorithms, Big Data Analytics, Data Warehousing, and Visual & Web Analytics are some of my favorite topics.With over 10th plus years of expertise in the fields of business intelligence and data analytics, as well as certifications as a Scrum Master and a Google Analytics Developer.1) Extensive experience (8+ years) with a variety of Business intelligence tools, including Tableau, Power-BI, Qlikview, and QlikSense, as well as MS-SQL Server Reporting Services (SSRS).2) Strong T-SQL database development background with over ten years of expertise writing stored procedures, views, materialized views, user-defined functions, triggers, and CTEs (Common Table Expressions) for a variety of ongoing SQL database projects (T-SQL in SQL Server 2008/2012).3) Practical experience in developing an AWS Cloud Data Pipeline utilizing Python and Pyspark, AWS Glue, AWS S3, Airflow, and AWS Redshift.4) Hand-on experience in building ETL Pipeline (SSIS, Informatics, Azure Data Factory, Azure Data Lake and Azure Data bricks).5) Hand-on of experience in building Physical and Logical data models in line with the Conceptual model and therefore in line with Data warehousing technical components (e.g. Data Modeling, ETL/ Data pipelines).6) Strong experience in GitHub to manage releases, and to collaboratively build and deploy clean pipelines using Jira (Confluence) tool and have good knowledge of Agile Methodology (SCRUM). 7) Experience with using python data-centric packages such as PySpark, Numpy, and Pandas etc.Why hire me?• Proficient to derive meaningful insights out of data with know-how• Passionate to learn, won’t shy away from asking ‘How?’ to solve complex business problems• Innovative, logical, and data-driven approach.Love Business Intelligence and Data Science & Analytics. Data Enthusiast. Technology Geek

Deepanshu Vohra's Current Company Details
NatWest

Natwest

View
SVP - Lead Data Engineer & Data Scientist | EX- JP Morgan Chase / Goldman Sachs / Fidelity Investment | AI & ML -Engineer | NLP | Tableau | Azure Data Factory | AWS | Data Engineering | SQL Engineer | Python
Deepanshu Vohra Work Experience Details
  • Natwest
    Senior Vice President - Lead Of Data Engineering & Ai
    Natwest Jun 2023 - Present
    Gb
    View
  • Direct Line Group
    Lead Aws/Azure Data Engineer & Machine Learning Engineer
    Direct Line Group Oct 2022 - Dec 2023
    Bromley, Kent, Gb
    1) Acting as the main day-to-day contact for clients, building strong relationships with senior Pet Business stakeholders and working in the Pet business data tribe and the Data chapter Area, on various AWS ETL Data Engineer and Business Intelligence projects across the Insurance business.2) Responsible for constructing end-to-end data cycle and developed a key data pipeline to process over 500 TB of data by consolidating Pet data from multiple disparate sources into a single destination AWS S3, enabling quick data analysis for reliable business insights.3) Working as T-SQL Developer to performed Performance Tuning and wrote the Stored Procedures, Views, Materialized view, User Defined Functions, Triggers and CTE (Common Table Expression) for various existing SQL Pet projects (T-SQL in SQL Server 2008/2012) and used AWS Redshift to provide structured data to business units by combining millions of rows of data from 19 disparate data sources.4) Created AWS Glue Data load jobs to perform transformations on S3 data and load it to Redshift and/or in pre-ingestion layer on S3 of DLG network.5) AWS Airflow is used to orchestrate the AWS Glue load, pre-ingestion, ingestion and curation AWS Glue jobs. 6) Responsible for Designing Logical and Physical data modelling for various data mart on AWS Redshift Data Lake such as Policy and Quote Lake Short Mart (Data Marts) which are built on Kimball Methodology and uses star and snowflake schema.7) Built Tableau forecasting POC using parameters, trend lines, and reference lines that were reported to UK FCA for quarterly earnings reports, saving 60 hours of manual work each quarter.8) Experience building standard POC supervised (classification) and unsupervised (clustering) models for Pet Policy Pricing , and an understanding of standard industry libraries (pandas, sklearn, keras etc)
    View
  • Awin Global
    Senior Data Engineer & Data Scientist
    Awin Global Jun 2022 - Sep 2022
    Berlin, De
    Working as an Azure Data engineer for different clients on different azure data engineering and analytics services. Working on Azure, Python, SQL, and Data Analytics.The project is intended to ingest the advertisement data from multiple systems and massage it as per the business requirement and need. Also conducted predictive analysis for advertisement data.Responsible for constructing end-to-end data cycle, starting from ingesting data from sources like internal databases MySQL, Oracle, or files, to the hdfs and then massaging data based on business requirement.1) Created multiple pyspark jobs to transform data and create multiple features based on business logic.2) Conducted a proof of concept to build multiple machine learning models to forecast the outcome of advertisement data using supervised learning.
    View
  • Jpmorgan Chase & Co.
    Vp - Data Analytics And Business Intelligence Technology Team
    Jpmorgan Chase & Co. Aug 2018 - Dec 2021
    New York, Ny, Us
    Worked as in Leadership role in the field of Business Intelligence & Data Analytics and Database Development for the US Trading Reporting framework in the JP Morgan Fixed Income Division (Asset Management and Wealth Management)Designed KPI Dashboard for JP Morgan Fixed Income Management to give them insight and visual storytelling on traders performance (Total Numbers of Fixed Income Trades done by Traders and data analysis on number of Late and Cancel Traders posted by Traders and who was best broker to make a deal and calculating standard deviation in choosing the best broker ).Roles and Responsibilities------------------------------1) Translate stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.2) I have explored a different lean method that can be implemented in dashboards to drive the business better and get better insights and visual storytelling in Tableau and QlikSense tool.3) Work with BAs, DBAs, and other Developers to understand the existing system.4) Performed predictive analysis on 45000+ observations to identify the traders that are most likely to subscribe to the best broker for trade.5) Work in the end to end development of a new set of reports, dashboards & KPI Scorecards in tableau and Qlikview.6) Worked as SQL Server Database Architect.
    View
  • Jpmorgan Chase & Co.
    Senior Associate
    Jpmorgan Chase & Co. Feb 2015 - Aug 2018
    New York, Ny, Us
    View
  • Goldman Sachs
    Vp - Data Engineering Team (Technology Team Lead)
    Goldman Sachs Mar 2014 - Jan 2015
    New York, New York, Us
    Roles and Responsibilities------------------------------1) Gathered business requirements and form effective solutions for business problems resulting in 40% reduction in manual effort and increased productivity in the trading team.2) Identification of use case opportunities, scoping (documenting business requirements), coordinating project working groups, and designing and implementing innovative change initiatives.3) Designed databases, ER Modelling, and wrote Queries, SQL blocks, Functions, and Stored Procedures in SQL 2005/2008. 4) Created views in Tableau Desktop that were published to the internal team for review and further data analysis and customization using filters and actions, using SQL, and Python.5) Designed and developed a data warehouse using SSIS and SQL by extracting, transforming, and loading data into target tables.6) Conducted Tableau Doctor Sessions to assist Business Users, Program Managers, and End Users to combine views and reports into interactive dashboards for in-depth analysis and as a self-service BI tool.7) Worked as Tableau SME, Analytics, and Visualization expert to various business groups to track key performance metrics and management objectives. 8) Created action filters, and parameters and calculated sets for preparing dashboards and worksheets in Tableau.9) Worked with DBA activities like Installing, automation of maintenance jobs, DMVs to Identify Missing Indexes, unused indexes, long-running Job /Stored procedure alert, and identifying blocking.
    View
  • Fidelity Investments
    Senior System Analyst - Business Intelligence And Data Engineer
    Fidelity Investments May 2011 - Feb 2014
    Boston, Ma, Us
    Roles and Responsibilities------------------------------1) Worked as T-SQL Developer (Stored Procedures, Indexes, Views, User Defined Functions, Triggers and CTE (Common Table Expression).2) Worked as SSRS Developer (RDL Concept & RDLC Concept in SSRS (2005/2008 R2) and Expert in Charts, Tablix, drill down & drill through reports, Matrix, Subreports, dynamic row grouping and writing Custom Assemblies (C# or VB.NET) in SSRS.3) Worked as SSIS/ETL Developer and experience in (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS services.4) Building the Analytics and Data Visualization projects from scratch.
    View
  • Atyati Technologies
    Senior Software Engineer - Data Engineer
    Atyati Technologies Mar 2009 - Apr 2011
    Bangalore, Karnataka, In
    Worked as Business Intelligence Developer & SQL Server Database Developer in atyati Technologies (an GENPACT Company)
    View

Deepanshu Vohra Education Details

  • University Of Aberdeen
    University Of Aberdeen
    Artificial Intelligence
  • Visvesvaraya Technological University
    Visvesvaraya Technological University
    Computer Science

Frequently Asked Questions about Deepanshu Vohra

What company does Deepanshu Vohra work for?

Deepanshu Vohra works for Natwest

What is Deepanshu Vohra's role at the current company?

Deepanshu Vohra's current role is SVP - Lead Data Engineer & Data Scientist | EX- JP Morgan Chase / Goldman Sachs / Fidelity Investment | AI & ML -Engineer | NLP | Tableau | Azure Data Factory | AWS | Data Engineering | SQL Engineer | Python.

What schools did Deepanshu Vohra attend?

Deepanshu Vohra attended University Of Aberdeen, Visvesvaraya Technological University.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.