Summary
Overview
Work History
Education
Skills
Timeline
Generic

Pooja Patel

Melbourne,VIC

Summary

Well-versed in building positive relationships with customers and other stakeholders. Strong requirements gathering, scope development and inventory coordination abilities. Skilled at overseeing complex, high-value technical projects with excellent planning competencies. Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment.

Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.

Overview

7
7
years of professional experience

Work History

Senior Data Engineer

Tech Mahindra Ltd
03.2023 - Current
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Designed and implemented effective database solutions and models to store and retrieve data.
  • Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
  • Built databases and table structures for web applications.
  • Communicated new or updated data requirements to global team.
  • Explained data results and discussed how best to use data to support project objectives.

Data Engineer

Tech Mahindra Ltd
10.2021 - 02.2023
  • Develop code in PySpark and unit test using pytest based on approved design specifications and provide support for business and functional acceptance testing
  • Implement optimization techniques, performance enhancement of queries for enhancing the data load performances in various applications
  • Performing data validation using putty and data analytics studio to check the latest changes deployed or data present in the source tables and work closely with data team to fix if any discrepencies found or reload is needed
  • Designing and scheduling Control-M jobs, deliverables and assisting technical reviews during all phases of SDLC, code migration from development to test and production environments
  • Pushing the code to bitbucket repository and working on release jobs to deploy the code into DEV/SIT/UAT/PROD with support of L3 team
  • Coordinated with cross-functional teams to resolve project issues and mitigate risks.
  • Provided detailed project status updates to stakeholders and executive management.

Team Leader - Project Management

KMC India Pvt Ltd
04.2021 - 10.2021
  • Analyzing the business requirements with Business Analyst to develop ETL procedures that are consistent across all systems
  • Developing data mappings between source systems and warehouse components
  • Identified plans and resources required to meet project goals and objectives.
  • Facilitated Scrum framework – sprint planning, backlog grooming, daily scrums, sprint reviews, and sprint retrospectives.

Senior Developer

Wipro Ltd
12.2016 - 04.2021
  • Participated in Analysis, Design, and Implementation of Business Applications using the Oracle (RDBMS)
  • Expertise in Client-Server application development using Oracle 11g/10g
  • Implementing and managing ETL solutions
  • Optimizing and tuning Redshift Environment ,enabling queries to perform faster on visualization tools
  • Defined and deployed monitoring,metrics and logging in AWS
  • Implemented work load management in Redshift to prioritise basic dashboard queries over the complex ones, at client facing role in Helsinki, Finland
  • Led sprint reviews and planning meetings to promote full team engagement.
  • Collaborated with product owners, team members, technologists, and other scrum masters to define solutions and drive progress.

ETL Project

09.2020 - 11.2020
  • I worked on the ETL project during my PG program with IIIT,Bangalore
  • Extracting the transactional data from a given MySQL RDS server to HDFS(EC2) instance using Apache sqoop
  • Transforming the data according to given target schema using pyspark and perform visualisation using necessary graphs using python in Jupiter IDE
  • Loading the transformed data into the S3 bucket
  • Creating the Redshift tables according to the given schema
  • Loading the data from Amazon S3 to Redshift tables
  • Create and run analysis related queries on the tables in Redshift

Education

PG Diploma - Data Science

IIIT

Bachelors of Engineering - Computer Science

Rajiv Gandhi University of Technology
Bhopal, MP

Skills

  • Oracle (SQL, PL/SQL)
  • Python
  • Apache Spark
  • Project Specifications
  • Extraction Transformation and Loading (ETL)
  • Team Support
  • Business Intelligence Project Management
  • Progress Report Preparation
  • Analytical and Critical Thinking

Timeline

Senior Data Engineer

Tech Mahindra Ltd
03.2023 - Current

Data Engineer

Tech Mahindra Ltd
10.2021 - 02.2023

Team Leader - Project Management

KMC India Pvt Ltd
04.2021 - 10.2021

ETL Project

09.2020 - 11.2020

Senior Developer

Wipro Ltd
12.2016 - 04.2021

PG Diploma - Data Science

IIIT

Bachelors of Engineering - Computer Science

Rajiv Gandhi University of Technology

Similar Profiles

CREATE PROFILE
Pooja Patel