Summary
Overview
Work History
Education
Skills
Websites
Certification
References
Timeline
Generic

Joshitha Mandali

Frederick,MD

Summary

Dedicated and motivated Data Engineer with nearly five years of experience in designing, implementing, and optimizing data solutions. Proven expertise in building automated ETL pipelines, data analysis, and understand customer requirements and translate into actionable project plans. Proficient in a broad spectrum of tools and languages including Python. Demonstrated success in mentoring teams, collaborating with cross-functional units, and ensuring robust data governance.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Data Engineer

WeatherBug (GroundTruth)
11.2021 - Current
  • Built and maintained automated ETL pipelines
  • Developed Redshift stored procedures to process data from S3, DynamoDB, and Redshift Spectrum
  • Utilized Looker to craft dashboards and charts for data visualization
  • Installed and configured Airflow on EC2 instances; set up AWS Managed Airflow environments
  • Developed a Python repository for Airflow DAG management, integrating ETL code and deployments
  • Created and updated AWS Glue tables and schemas using Hive, AWS Console, and CloudFormation template
  • Implemented code linting, unit, and integration tests for ETL pipelines
  • Produced reports for executive-level employees for use in all-hands meetings
  • Mentored junior team members and interns
  • Established and enforced data governance standards for WeatherBug Clients, overseeing client-side code testing and validation throughout the data pipeline
  • Migrated the Redshift cluster from RA2 to RA3 using CloudFormation template
  • Developed Python code to extract data from external sources.

Data Analyst

EPMPOINT
06.2020 - 01.2021
  • Developed ETL processes using a combination of SQL, Python
  • Built key business metrics, visualizations, dashboards, reports with PowerBI.
  • Collected and analyzed huge amount of data using Python and SQL and shared actionable insights to help in client's decision-making process.
  • Performed data pre-processing to clean, eliminate outliers in data and conducted data exploration to detect correlation, trends, and patterns in data

Data Analyst

Towson University
06.2019 - 05.2020
  • Built VB scripts to manipulate data. Built SQL queries/views to fulfill adhoc data requests.
  • Generated reports and visualizations based on insights mainly using Tableau, PowerApps and developed dashboards for university insight teams.

Software Engineer

NCR Corporation Pvt Ltd.
01.2013 - 04.2018
  • Lead team for data migration from few bug tracking tools to JIRA. Extracted data from tools, cleaned data, manipulated data, imported into JIRA
  • Automated web scraping tasks using Selenium
  • Subject Matter Expert for Agile/Engineered tools like JIRA, Confluence, Subversion, Zephyr. Having hands-on experience in installing, monitoring, maintaining, configuring, upgrading of specified tools
  • Strong in troubleshooting, monitoring, training and 24/7 production support in mission critical environments

Education

Master of Science - Computer Science

Towson University
Baltimore, MD
08.2021

Bachelor of Science - Computer Science

Jawaharlal Nehru Technological University
Hyderabad, Telangana
05.2012

Skills

Programming

  • Scripting/Modules: Python, SQL, Matlab, Pandas, Tensorflow/Keras, Numpy
  • Databases: Redshift, PostgreSQL, MySQL, MongoDB, DynamoDB
  • Tools: Apache Airflow, Looker, AWS EMR, Spinnaker, SoapUI, PowerBI, Tableau

Data Science and Statistics

  • Machine Learning: Regression Analysis, Time Series Analysis (ARIMA, AR, MA, LSTM, SARIMAX), Support vector machines, Unsupervised Learning- Clustering Algorithms, Gradient Boosting, Ensemble methods (Boosting, Bagging), Neural networks
  • BigData: Hadoop, Map Reduce, HIVE
  • Computation: Principal Component Analysis
  • Data Visualization: Matplotlib, Seaborn, Tensorboards

Cloud Computing

  • AWS: EC2, S3, RDS DB, VPC, CloudWatch, CloudTrail

Other

  • Version Control: SVN, GIT
  • Defect Tracking: JIRA, Bugzilla
  • Notebooks: Jupyter
  • CI/CD: Jenkins
  • MS Office: Excel, PowerPoint

Websites

Certification

  • SAFe Agilist Certification- Scaled Agile, Inc.

References

  • Adam Lauer (Senior Manager, Engineering) : alauer@weatherbug.com
  • Zeiffrey Jeiberg (Ex- Manager, Data Engineering): Jzeiberg@gmail.com
  • James Phillips (Senior Data Engineer) : jphillips@weatherbug.com

Timeline

Data Engineer

WeatherBug (GroundTruth)
11.2021 - Current

Data Analyst

EPMPOINT
06.2020 - 01.2021

Data Analyst

Towson University
06.2019 - 05.2020

Software Engineer

NCR Corporation Pvt Ltd.
01.2013 - 04.2018

Master of Science - Computer Science

Towson University

Bachelor of Science - Computer Science

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
Joshitha Mandali