Jean Paulo Moran

Professional Profile

As a programming and data enthusiast, I specialize in transforming complex data into practical and actionable information to improve decision making. I master tools that allow me to perform effective analysis and visualizations that optimize processes.

My goal is to contribute to innovative projects that challenge my skills and allow me to continue growing in the field of data analysis and management.

Skills

Data Analysis – Python, Pandas, NumPy, Jupyter Notebook, Excel, Descriptive Statistics
Databases – SQL (PostgreSQL, MySQL), Advanced Queries, Relational Databases
Data Visualization – Power BI, Tableau, Excel Dashboards, Matplotlib, Seaborn
Automation and Pipelines – Automated tasks and ETL with Python
Methodologies and Processes – ETL (Extract-Transform-Load), Exploratory Data Analysis (EDA), Data Modeling and Documentation
Version Control – Git, GitHub

Experience

Cashier Supervisor

Totto

09/2017 - 03/2022

Skills: Excel • Google Sheets • Data Cleaning • ETL (Extract-Transform-Load)

Achieved a 20% increase in efficiency by implementing data export and cleaning for inventory preparation.
Analysis and use of logical functions in Excel to compare and report daily, weekly, and annual sales.
Prepared detailed administrative reports on sales, inventory, schedules, and financial statements using office programs.
Coordinated sales, billing, and e-commerce deliveries using Google Sheets, ensuring efficient communication with all departments involved.
Trained and developed new personnel, supervising a team of up to 4 people in administrative and operational procedures, as well as office tool usage.

Education

Specialization in Systems Administration

"Francisco de Orellana" High School

Subjects: English • Mathematics • IT Applications Module • Mono and Multiuser Information Systems Module • Programming Fundamentals Module • Database Management Systems Module

Projects

Customer Churn Analysis

Identification of key churn factors in telecommunications: 44.82% churn attributed to competitors and 63.24% in California. Proposals to improve retention based on analysis with Power BI and Python.

Skills: Power BI, Jupyter Notebook, Python

Interactive Dashboard: London Bike Trends

This project highlights how data analysis and visualization can be leveraged to solve business problems and optimize operations. Using the London bike-sharing dataset, I developed an interactive dashboard to extract and present actionable insights, such as usage patterns, peak demand times, and the influence of environmental factors.

Skills: Tableau, Python, Pandas, Kaggle API, Calculated Fields, Set Actions

Motorcycle Parts Sales Analysis

Exploration of net revenues by product lines and warehouses in Power BI dashboards. Highlighted a 25% increase in sales during July and cost optimization based on payment methods.

Skills: Python, PostgreSQL, Power BI

ETL Automation

Design of a modular pipeline to integrate data from multiple sources, reducing processing times. Flexible implementation for analysis in PostgreSQL and MySQL.

Skills: Python, SQLAlchemy, Pandas, PyYAML

Customer Segmentation and Retention Analysis

Churn analysis of 6,500 customers with a churn rate of 26.86%. Identification of critical segments: 40% churn in customers over 65 years old and 75% churn in specific states.

Skills: Statistical Analysis, Pivot Tables, and Dashboards with Excel

Certifications

SQL Data Analyst Associate – DataCamp
Data Analysis with Python – freeCodeCamp
Design in Power BI – DataCamp
Excel Fundamentals – DataCamp
Data Visualization – Kaggle
Data Storytelling – DataCamp
Introduction to Git – DataCamp