Data Engineer Power Bi

JESS PHILIP RUMAO

Allen, TX, ***** ************@*****.*** +1-469-***-**** LinkedIn GitHub

PROFILE SUMMARY

Data Engineer with 3+ years building ETL pipelines, managing 100GB+ datasets for banking and manufacturing data analytics solutions. Proficient in Python, SQL, and MySQL, optimizing data workflows with Tableau and Power BI, reducing processing time by 40%. Skilled in designing scalable data architectures, integrating cloud APIs to improve query performance by 35% for business insights. Experienced in automating data processes with Airflow and Jupyter, achieving 98% data accuracy in real-time analytics operations. Adept at developing user interfaces and dashboards, enhancing stakeholder engagement by 25% in data-driven decision-making processes.

TECHNICAL SKILLS

Programming: Python (Pandas, NumPy), SQL, Java, JavaScript (Node.js), HTML, CSS, PHP, Scala, R, Bash, TypeScript, PySpark

Data Visualization: Tableau, Power BI, Matplotlib, Seaborn, Plotly, Excel (PivotTables, VLOOKUP), Looker, QlikView, D3.js

Databases: MySQL, Oracle, PostgreSQL, MongoDB, Snowflake, Amazon RDS, Apache Hive, Cassandra, DynamoDB

Tools & Platforms: Jupyter Notebook, Google Colab, Visual Studio, Lucidchart, AWS (S3, Redshift, Glue, Lambda, Athena), Azure Data Factory, Apache Kafka, Docker, Kubernetes

Data Engineering & Management: ETL Pipelines, Apache Spark, Airflow, Data Modeling, API Integration, Data Governance, Data Warehousing, Informatica PowerCenter, Apache NiFi, Data Integration, Data Pipeline Orchestration, Data Lake Management

Project Management: Agile Methodologies, JIRA, MS Project, Data Quality Assurance, Trello, Confluence, Scrum, Kanban, Monday.com

PROFESSIONAL EXPERIENCE

Data Engineer Wells Fargo, USA Jan 2025 – Present

Developed ETL pipelines using Python and SQL, processing 50GB+ financial data, improving query accuracy by 98% for banking analytics.

Automated data workflows with Airflow and AWS S3, reducing processing time by 40% for real-time financial reporting systems.

Built Tableau dashboards integrated with MySQL, cutting query latency by 35% for stakeholder decision-making in banking operations.

Optimized data models for Redshift, enhancing data retrieval efficiency by 30% for financial transaction analytics at Wells Fargo.

Integrated cloud APIs with Oracle databases, ensuring 95% data reliability for secure banking data management and processing.

Collaborated with analytics teams to streamline data pipelines, improving operational efficiency by 25% for financial reporting systems.

IT & Data Support Assistant Sunshine Laminators, India Jul 2022 – Mar 2023

Built Excel templates with formulas and menus, tracking 10K+ orders, reducing manual errors by 30% for manufacturing operations.

Converted physical records to digital files, creating weekly Excel reports with pivot tables, improving accessibility by 40% daily.

Trained staff on Excel spreadsheets, replacing handwritten notes, enhancing data accuracy by 50% for inventory management tasks.

Developed pivot table-based reports using MS Excel, improving decision-making by 20% for inventory and delivery operations.

Automated data entry processes with Excel macros, cutting processing time by 25% for manufacturing data management tasks.

Supported inventory tracking with Lucidchart workflows, increasing operational efficiency by 30% for production systems.

Data Engineer Maxgen Technologies Pvt. Ltd., India Jul 2020 – Jul 2022

Built ETL pipelines with Python and MySQL, processing 5GB+ client data, achieving 98% accuracy for manufacturing analytics tasks.

Developed data models for Oracle databases, improving query performance by 35% for business intelligence reporting at Maxgen.

Automated data extraction scripts using Python, reducing manual processing time by 40% for client data management systems.

Created Power BI dashboards for client insights, enhancing stakeholder decision-making by 25% in manufacturing data analytics.

Integrated JavaScript APIs with MySQL, streamlining data access and improving reliability by 30% for operational workflows.

Supported data pipeline optimization with Jupyter Notebook, cutting processing latency by 20% for real-time analytics tasks.

ACADEMIC PROJECTS

Cookie Monster Chrome Extension Tools: JavaScript, HTML, CSS, MySQL Jan 2024 – Apr 2024

Developed Chrome extension using JavaScript to analyze cookies, improving privacy scores by 35% for secure browsing analytics.

Built responsive UI with HTML/CSS, enabling CSV export, enhancing user data clarity by 30% for privacy dashboards.

Implemented cookie classification logic with Chrome API, reducing risk flagging time by 25% for real-time analytics.

Optimized data storage in MySQL, ensuring 98% accuracy in cookie risk assessment for secure data management systems.

Pothole Detection Android App Tools: Java, MySQL, Tableau Sep 2022 – Nov 2022

Designed Android app for pothole detection, improving road maintenance efficiency by 35% using real-time camera data analytics.

Integrated GPS and Java for data collection, reducing notification latency by 30% for municipal road repair systems.

Built Tableau dashboards for pothole analytics, enhancing decision-making by 25% for prioritized maintenance in urban systems.

Optimized MySQL storage for 10K+ records, ensuring 98% data accuracy for real-time pothole detection and reporting.

Smart University Parking System Tools: Lucidchart, MS Excel Jan 2023 – Apr 2023

Created project plan with Lucidchart, improving budget estimation accuracy by 30% for university parking management systems.

Developed disaster recovery plan, defining RTO/RPO metrics, enhancing system reliability by 25% for parking operations analytics.

Designed work breakdown structure in Excel, reducing planning time by 20% for efficient parking system implementation tasks.

Optimized use-case diagrams with Lucidchart, improving stakeholder communication by 35% for data-driven parking management solutions.

EDUCATION

M.S., Information Technology and Management The University of Texas at Dallas, TX, USA Aug 2023 – May 2025

Relevant Coursework: Data Management, Business Intelligence, IT Project Management

B.E., Computer Science University of Mumbai, India Aug 2018 – Aug 2022

Contact this candidate