Years of IT experience
GYANA RANJAN RATH
Cloud Data Architect. Modeler and Senior Data Engineer
Bangalore
Summary
Accomplished and Azure-certified professional with over 13 years of extensive experience in data warehousing, data modeling, and data architecture. Possessing certifications as an Azure Certified Solution Architect, Azure Certified Data Engineer, and Databricks Certified PySpark Developer, excel in designing and implementing robust data solutions tailored to business needs. Proficient in leveraging Azure services such as Azure Synapse Analytics, Azure SQL Database, ADF and Azure Data Lake Storage, seeking a challenging role as an Azure Data Architect to apply expertise in driving innovation and delivering strategic data solutions.
Overview
16
16
12
12
Years of Data Warehousing experience
7
7
Years experience in Azure cloud
4
4
Years experience into Databricks and Pyspark
7
7
Certifications
Work History
System Architect
Deloitte
Bangalore
01.2024 - Current
- Design solution architecture and prepare architecture diagrams for data processing implementation approach on azure cloud Analytics platform
- Designed and developed data models using Azure services such as Azure Synapse Analytics, Azure SQL Database, and Azure Data Lake Storage, tailored to insurance industry requirements.
- Conduct POC and prepare best approaches for data ingestion and transformation
- Prepare high level design documentation for intended approach
- Part of Scaled Agile team and prepare Technical user stories and take part PI planning
- Mentored junior team members and provided guidance on best practices in system design, development, and deployment.
- Developed technical documentation that enabled efficient knowledge transfer among team members and stakeholders alike
Technical Build Manager
Deloitte
12.2022 - 01.2024
- Prepare technical design and roadmap for development activities of 3 projects in Azure DnA product solution
- Implementation of Dimensional data modelling
- Plan and align new enhancements for best product experience
- Conduct POC, evaluate data security, data governance rules and design ETL data processing solutions in Azure cloud
- Align release plan with Cloud Data Architects and Product managers
- Managing project deliverables of Agile teams of Data Engineers and Analysts.
Senior Data Engineer
IBM
05.2022 - 11.2022
- Design and develop robust Azure ETL solutions using Azure Data Factory and Databricks for 2 projects
- POC and finalize effective reusable ingestion steps from various sources
- Work with Data Analyst for preparing final design solution
- Optimization of spark data transformation logic and Delta Merge
- Guide and mentor junior resources in team.
Data Modeler and Technical Lead
Metricstream Infotech Pvt Ltd
09.2015 - 04.2022
- Lead Customer Services team to create and deliver custom GRC solutions
- Design the solution on product platform and database integration
- Completed cloud data migration for two customers
- Design and develop analytic solution on Azure cloud using Databricks and Data Factory
- Ingest data from in-house application to Azure cloud and produce gold data using Azure DataBricks for analytics reporting
- Managed a team of 6 for the effective customer delivery
- Customer interactions to study and plan the requirement and product enhancements.
Application Manager
Tata Consultancy Services
01.2011 - 09.2015
- Data Warehouse ingestion and ETL development
- Preparation of PL/SQL monitoring scripts to prepare client requested reports
- Remediating and performance enhancement of PL/SQL procedures running daily for report generation
- Helped in the Platform performance in UK for one year and in US for six months
- Led a team of 4 members from India to support the UK and US business.
QUARTZ product development
Tata Consultancy Services
- 01.2011
- Analysis of High-level design requirements
- Preparation of Low-Level Design elaborately pointing out the code changes to be implemented
- Development of Financial domain modules using PL/SQL, C++, UNIX and PowerBuilder10
- Understanding of business modules like Security trading, Free Movements, Forex Transactions, Financial Instruments and Cash Transfers
- Closely interacted with the Team Leads, providing timely fixes to the deliverables.
Education
B. Tech in Electrical Engineering -
NATIONAL INSTITUTE OF TECHNOLOGY, ROURKELA
Rourkela, Odisha 05.2003 - 06.2007
Senior Secondary Education -
Deepika EM School, Rourkela
Rourkela, Odisha 04.2000 - 03.2002
Skills
Azure Bigdata solution
Databricks and Pyspark
Cloud Data Migration
Data Modelling (Dimensional and Datavault 20)
Scaled Agile Methodology
Python and SQL
DevOps Principles and Practices
Technical Design Documentation
Performance Optimization
Problem-Solving
Certification
Azure Solutions Architect Expert-AZ305
Timeline
System Architect
Deloitte
01.2024 - Current
Technical Build Manager
Deloitte
12.2022 - 01.2024
Senior Data Engineer
IBM
05.2022 - 11.2022
Data Modeler and Technical Lead
Metricstream Infotech Pvt Ltd
09.2015 - 04.2022
Application Manager
Tata Consultancy Services
01.2011 - 09.2015
B. Tech in Electrical Engineering -
NATIONAL INSTITUTE OF TECHNOLOGY, ROURKELA
05.2003 - 06.2007
Senior Secondary Education -
Deepika EM School, Rourkela
04.2000 - 03.2002
QUARTZ product development
Tata Consultancy Services
- 01.2011