ANMISHA RAO DODTALE
Summary
Innovative and results-driven Data Engineer with over 3+ years of comprehensive experience in designing, developing, and maintaining large-scale data processing systems. Demonstrated expertise in leveraging a wide array of data technologies and programming languages to build reliable and scalable data solutions. Proficient in cloud-based technologies, with a strong focus on optimizing data warehousing, ETL processes, and real-time data streaming services.
Known for team collaboration and adaptability, consistently achieving project goals and driving impactful results. Skilled in Python, SQL, and big data technologies, ensuring reliable and efficient data management.
Overview
5
5
years of professional experience
Work History
AWS Data Engineer /Data Modeler
State street Bank
09.2024 - Current
- Worked on Oracle and PostgreSQL databases, creating and optimizing complex triggers, stored procedures, and queries
- Utilized ERWIN for both forward and reverse engineering to create DDLs, streamlining database schema design and migration processes
- Led migration projects from Oracle to PostgreSQL, ensuring seamless transitions while maintaining data quality and performance
- Deploying applications to the AWS using CloudFormation templates
- Utilized AWS services including Redshift, S3, and Lambda to support scalable and efficient data processing workflows
- Designed and implemented data models to support business intelligence and analytics, improving query performance and reporting efficiency
- Automated data pipelines and optimized ETL workflows using modern tools and best practices
- Implemented CI/CD pipelines for deploying database patches using GitHub and Bitbucket, enabling streamlined and reliable deployments
Azure Data Engineer
AXA XL Insurance Reinsurance
08.2023 - 08.2024
- As a part of Cloud Platform Portal team worked on DevOps using Harness tool deploying a wide range of Azure services using Terraform for infrastructure as code for Automating infrastructure provisioning and management, promoting code reuse and reducing duplication, ensuring consistency, scalability and reducing manual intervention and repeatability in resource provisioning
- Integrated Terraform modules within Harness pipelines to automate and manage the entire deployment lifecycle, from infrastructure provisioning to application deployment
- Utilized OpenShift and Kubernetes to deploy and manage pods, ensuring scalable and reliable container orchestration
- Orchestrated a POC with Azure Data Factory for streamlined data integration for a data engineering project
- Integrated Azure Functions, Azure Batch, Azure Key Vault for scalable, serverless compute options
- Leveraged Azure API Management for modern API gateways and utilized Azure Log Analytics for performance analysis, with Azure Data Lake Storage Gen2 for optimized big data analytics
- Possess comprehensive knowledge of all Azure services, including Azure SQL Database, Azure Storage, Azure Networking, Azure DevOps, Azure Function app, and Azure Logic app, etc
Snowflake Data Engineer
Basel Technologies PVT LTD
01.2020 - 12.2022
- Used Snowflake as Analytical Data warehousing solution to transform and process data from various source systems to support Reporting and Dashboarding needs
- Utilized Snowflake's multi-cluster architecture to optimize query performance and handle large volumes of dimension and fact data
- Used Tidal to schedule and manage daily jobs
- Utilized features such as time travel and data versioning to access historical data and track changes
Education
Master’s - Computer Science
THE UNIVERSITY OF MISSOURI KANSAS CITY
KANSAS CITY, MISSOURI05.2023
Bachelor of Science - Electronics and Communication Engineering
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY
Hyderabad, India08.2021
Skills
- Python, PL/SQL, Terraform, YAML, MYSQL, Oracle,PostgreSQL
- Azure Data Factory, Snowflake, SQLServer, Azure Data Lake
- Logic Apps, Functional App, Azure DevOps, Azure SQL, Redis
- Redshift, ECR, EC2, S3, Harness, PowerBI,Data Modeling
- Tableau, Erwin, SQL querying, ETL, Dbeaver, GitHub, Bitbucket
- Docker, Kubernetes, Visual Studio, Adaptability and flexibility
- Verbal and written communication, Team collaboration, Self motivation
Timeline
AWS Data Engineer /Data Modeler
State street Bank
09.2024 - Current
Azure Data Engineer
AXA XL Insurance Reinsurance
08.2023 - 08.2024
Snowflake Data Engineer
Basel Technologies PVT LTD
01.2020 - 12.2022
Master’s - Computer Science
THE UNIVERSITY OF MISSOURI KANSAS CITY
Bachelor of Science - Electronics and Communication Engineering
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY
Similar Profiles
Zachary WrightZachary Wright
Middle office Associate 2 at State Street BankMiddle office Associate 2 at State Street Bank
Jennie M. ChauJennie M. Chau
Client Admin Project Analyst, Officer at State Street BankClient Admin Project Analyst, Officer at State Street Bank
Mukund KumarMukund Kumar
Manager- Officer at State Street BankManager- Officer at State Street Bank