Summary
Overview
Work History
Education
Skills
Certification
Additional Information
Timeline
Generic

Rajesh Mameda

Summary

Detail-oriented data engineer designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Engineer

09.2023 - Current
  • Automated data extraction and ETL processes using SQL Server Agent and Python scripts, ensuring seamless data integration and synchronization
  • Developed Python scripts to retrieve real-time data from APIs for energy production, weather patterns, and market trends, crucial for decision-making
  • Designed and optimized SQL queries for actionable insights from large datasets, enhancing operational efficiency in renewable energy management
  • Implemented scheduled tasks in SQL Server Agent for timely updates of energy performance metrics, improving data accuracy and reliability
  • Utilized Python for dynamic API responses, data preprocessing, and error handling, ensuring data consistency for analysis and reporting
  • Collaborated with teams to design PySpark workflows for advanced analytics and machine learning on renewable energy data, accelerating model training and predictions.

Python developer Intern

IBM
05.2022 - 01.2023
  • Developed Python and Java applications to enhance online banking experiences, working with cross-functional teams
  • Utilized Pandas, NumPy, Apache Commons for managing extensive banking datasets and ensuring data accuracy with robust validation
  • Maintained backend services with Django, Flask, and Spring Boot, optimizing APIs and managing MySQL, PostgreSQL databases
  • Automated data extraction and transformation, reducing manual workload, and created interactive visualizations with Matplotlib and JFreeChart
  • Developed Power BI dashboards for complex data visualization and collaborated with DevOps to optimize deployments
  • Implemented RESTful APIs in Python and Java, improving system efficiency and customer interaction on digital platforms.

Data Engineer

Addison it solutions
01.2019 - 04.2021
  • Generated a comprehensive dataset of 10,000 patient records using pandas and NumPy, achieving an 85% accuracy in diabetes prediction
  • Extracted (ETL) & enhanced data quality for 90% of patient records with SQL & Python, focusing on outlier and null value management
  • Resolved data quality issues in SQL and Power BI to maintain data system integrity
  • Created insightful Power BI reports and dashboards using power Query, Power Automate, Power Apps, DAX Functions, and visuals (Charts, Graphs, KPIs, Maps, Gauges, Matrix), improving data visualization and analysis efficiency by 45%
  • PROJECTS
  • City Water Usage Database: SQL, Microsoft Access
  • Developed a database using MS Access and SQL for the NYPD to simplify the retrieval process of crime information
  • Developed a database using MS Access and SQL to simplify the retrieval process of water usage data for the city
  • Identified and resolved data consistency issues by setting up referential integrity constraints
  • Created 8 tables and 10 queries with calculations, criteria, and prompts to facilitate data analysis and reporting
  • Renewable Energy Output Analysis: Python, Google Colab
  • Analyzed stock performance data from web APIs on Toyota Motors from 2017-2022 using Python, Pandas, and Matplotlib
  • Analyzed renewable energy production data from web APIs on various energy sources from 2018-2023 using Python, Pandas, and Matplotlib
  • Generated production trends, capacity, and 100-day moving average graphs and charts for renewable energy sources with the analyzed data
  • Collaborated with 2 other teammates to generate an energy output performance report for three renewable energy companies
  • United Airlines Excel Data Modeling Case Analysis: Microsoft Excel
  • Performed sensitivity analysis on 59,049 data cells to calculate Economic Value Added (EVA) for purchasing a new plane
  • Visualized the variables impacting EVA and profitability utilizing Tornado Charts.

Education

Master of Science - Data science, Data Science and Analytics

SAINT PETERS UNIVERSITY

Bachelor of Technology - Computer Science Engineering

JAWARHLAL NEHRU TECHONLOGY UNIVERSITY

Skills

  • Programming Languages:
  • Python, C, java, HTML, SQL
  • Database Management:
  • MySQL, PostgreSQL, T-SQL, NoSQL, SSIS, SSRS Data Analytics and BI Tools: Tableau, Power BI, Excel modeling Libraries: Pandas, NumPy, Matplotlib, Seaborn
  • Methodologies: Agile, Scrum
  • Software & Tools: ETL, Rest Api, Fast Api, Hadoop, KPI dashboards, finance, google analytics, PySpark, statistics, data visualization, project management, Big Data, AWS, ad-hoc analysis, Salesforce (CRM), predictive modeling, quality A/B testing & machine learning algorithms

Certification

Microsoft Machine Learning|python &. Data science: https://coursera.org/verify/2ZHU3M38

Additional Information

  • |Django : http://www.smcertificationservices.com/national-client.php?search_key=QMS23163&submit= Credential ID 0136-422-0013 Aws solution Architect: https://aws.amazon.com/verification user:ddf02ac4c6cb4689ad3dd9d9acda88a6

Timeline

Data Engineer

09.2023 - Current

Python developer Intern

IBM
05.2022 - 01.2023

Data Engineer

Addison it solutions
01.2019 - 04.2021

Master of Science - Data science, Data Science and Analytics

SAINT PETERS UNIVERSITY

Bachelor of Technology - Computer Science Engineering

JAWARHLAL NEHRU TECHONLOGY UNIVERSITY

Similar Profiles

CREATE PROFILE
Rajesh Mameda