Summary
Overview
Work History
Education
Skills
Certification
Linkedinprofile
Personal Information
Timeline
Generic
Dinesh Patil

Dinesh Patil

Database Architect
Pune

Summary

AWS Certified Solution architect associate, Oracle certified associate, having overall 21 years of extensive experience in Oracle database, design, data modeling, migration, performance tuning, data warehouse design / Architecture and ETL practice including 10 years professional experience of distinguished Data Warehousing.

Specialize in designing, implementing, and managing robust data architectures. Expertise spans various domains, including cloud migration, microservices, and relational databases

Overview

21
21
years of professional experience
6
6
years of post-secondary education
3
3
Certifications

Work History

Technology Architect

Infosys
Pune
2 2019 - Current

As an accomplished Data Architect with Cloud Certified Professional, I specialize in designing, implementing, and managing robust data architectures. My expertise spans various domains, including cloud migration, microservices, and relational databases. Here are the key aspects of my role:

  • Led the modernization of monolithic mainframe systems to microservices architecture on AWS.
  • Successfully migrated on-premises applications (Java and Oracle) to Python/Pyspark with AWS Aurora PostgreSQL.
  • Presented business cases and budget estimates to stakeholders during transformation initiatives.
  • AWS Solution Architect Associate
  • Azure DP-300 Administering MS Azure SQL
  • Snowflake SnowPro Core

Technical Specialist

Tech Mahindra Ltd.
- 02.2019
  • Leading team of 12 ODI developers and 3 L1/L2 resources for production support
  • Extensive experience in onshore coordination
  • Extensive experience in developing the load plans, packages and job scheduling
  • Good knowledge in installing ODI11g, ODI12c and to create Master and work repositories in different RDBMS products like Oracle11g on different platforms like windows servers
  • Implemented performance engineering by introducing parallel jobs in current load plan, Re-arranging steps, partitioning to improve query performance, monitoring of database SQLs which are taking more time and CPU, Optimized SQLs by adding indexes, Query rewriting
  • Worked along with business analysts, developers, management professionals and with business users from various locations of customer to gather requirements
  • Successfully delivered Drop 3, 4 and 5
  • Optimized ODI performance with respect to daily ETL load
  • Successfully delivered 2 complex CRs.

Lead Consultant

CapGemini
02.2015
  • Developed conceptual and logical information models within the context of the Enterprise and Line of Business Information Architecture
  • Understood Zurich's EDW i.e
  • IBM's IIW which is source for GPD data model
  • Successfully designed and developed conceptual and logical model.

Project Lead

Golden Source
09.2012 - 01.2015

Design, Develop and maintain Golden Source Data Warehouse Model and Data Warehouse Product for existing and new customers

  • Project management activities like - requirement analysis, Gap analysis, Impact analysis, Design, Estimation, Product releases etc
  • Design review, Test case review, code review, Coding
  • Created and Maintained GS DWH data model in ERWin
  • Successfully designed and deployed partitioning solution for client with billion rows in table
  • Re-designed existing Data warehouse Product in fact dimensional model
  • Performed various POC and R&D related to data and processes

Associate Consultant

Tata Consultancy Services
04.2012 - 09.2012
  • Study 'As Is' state
  • Gap analysis - Current state Vs Industry trends
  • Define Analytics Strategy - 'To Be' state specification
  • Design Solution framework
  • Design & Implement Dashboards & associated structures
  • Design, develop, and implement Marketing Analytics Models
  • Generate Insights based on execution of Analytical models

Tech Lead

Tech Mahindra Ltd
01.2006 - 03.2012
  • To understand current system, interact with the current user
  • Prepare Low Level Design and chalked out execution plan, get sign-off
  • Data modeling, Identify ETL strategy
  • Test case review and code review.

Consultant

ZenSar Technologies ltd
- 01.2006

Programmer

FWL Technologies ltd
11.2003 - 06.2004

Consultant

Spider System Pvt. Ltd
05.2003 - 11.2003

Marketing Executive

Jalgaon Janata Info-Tech Pvt Ltd
- 09.1999

Lead-Operation

Photon Graphics Pvt Ltd
10.1999

Education

Master Degree in Business Administration (M.B.A. [Marketing]) -

North Maharashtra University
Jalgaon
07.1996 - 04.1998

Bachelor of Computer Science (B.C.S.) -

North Maharashtra University
Jalgaon
07.1992 - 04.1996

Skills

ODI 12c, 11g, MS SSIS , SSRS

Certification

AWS Solution Architect Associate Badge, https://www.credly.com/go/rtmHCfjSvch5R8b5lFk5Pg

Linkedinprofile

www.linkedin.com/in/dinesh-patil-52180b2b

Personal Information

  • Passport Number: P2429283
  • Passport Expiry Date: 09/29/26
  • Date of Birth: 09/04/74
  • Nationality: Indian
  • Marital Status: Married

Timeline

Snowflake SnowPro Core Certification

06-2023

Azure DP-300 Administering MS Azure SQL

06-2022
AWS Solution Architect Associate Badge, https://www.credly.com/go/rtmHCfjSvch5R8b5lFk5Pg
04-2021

Lead Consultant

CapGemini
02.2015

Project Lead

Golden Source
09.2012 - 01.2015

Associate Consultant

Tata Consultancy Services
04.2012 - 09.2012

Tech Lead

Tech Mahindra Ltd
01.2006 - 03.2012

Programmer

FWL Technologies ltd
11.2003 - 06.2004

Consultant

Spider System Pvt. Ltd
05.2003 - 11.2003

Lead-Operation

Photon Graphics Pvt Ltd
10.1999

Master Degree in Business Administration (M.B.A. [Marketing]) -

North Maharashtra University
07.1996 - 04.1998

Bachelor of Computer Science (B.C.S.) -

North Maharashtra University
07.1992 - 04.1996

Technology Architect

Infosys
2 2019 - Current

Technical Specialist

Tech Mahindra Ltd.
- 02.2019

Consultant

ZenSar Technologies ltd
- 01.2006

Marketing Executive

Jalgaon Janata Info-Tech Pvt Ltd
- 09.1999
Dinesh PatilDatabase Architect