Data Analyst Visualization

Business / Data Analyst

AURA ROMERO

ad124p@r.postjobfree.com • 970-***-**** • Brighton, CO

• LinkedIn • GitHub

SUMMARY

Over two years of experience in data gathering, cleaning, and analysis, I specialize in translating data insights into effective business strategies. My unique blend of technical expertise and a deep understanding of business implications equips me to leverage technology for innovation and process improvement. I have a proven track record of independent and collaborative work to achieve project objectives.

SKILLS

●SQL (PostgreSQL Database)

●Python (Pandas, NumPy, Matplotlib, Seaborn)

●Microsoft Excel (Pivot Tables, XLOOKUP, Data validation, Pivot Chart)

●Tableau (Literacy of Data Visualization)

●Git

Power BI

Other: Data Analysis, Data Visualization, Reporting, Data Strategy, Critical thinking, Project Management, Written and Verbal Communication, Logical Reasoning, Decision Making, Attention to detail, Data Analytical and problem solving, Leadership, Collaboration

PROFESSIONAL EXPERIENCE

Data Analyst, Remote August 2022 – March 2023

Wilshire

●Unearthed strategic data management opportunities like data collection and storage for over 125 different products aimed at optimizing resource allocation and operational efficiency, fostering robust growth, and facilitating the seamless expansion and consolidation of the company.

●Uncovered insights that served 4+ stakeholders in making decisions to improve the availability of products and recognize the most demand, using SQL, Python, and Tableau; resulting in a 7% increase in sales and revenue

●Maintained and updated over 3 reports on a weekly basis which included dashboards, KPI’s, and in-demand records of information about the past and latest incidents in data; resulting in a 20% total decrease in reported incidents

●Collaborated with cross-functional teams and stakeholders (3 departments total) to address their ongoing data needs; resulting in the growth of inventory rotation and sales collected, cleaned, and analyzed over 125k data records on a daily basis to be used as support for reports and dashboards using SQL and Python

Environmental Engineer, Carmen de Bolivar, Colombia March 2014 - December 2014

Fundación Semana

●Collected data through 450 surveys to be analyzed and visualized in order to get insights that allowed +10 stakeholders across 3 departments to make decisions and structure the elements of the projects to ensure success and sustainability

●Collaborated with cross-functional teams across 4 departments alongside the community in the development of activities and surveys that let us identify +25 opportunities and weaknesses to be worked on regarding the development of new agriculture projects

●Ensured that the environmental requirements were met for the formulation and execution of the 125 agriculture projects through the analysis of the ecological and agricultural parameters

Planning Director, El Cairo - Valle, Colombia January 2011 - September 2011

City Hall

●Designed the annual budget ($4,500M CO total) and allocated funds for the 700 different projects and programs that benefited the community; a population of 20000 community members

●Collected, processed, and analyzed data generated in the 7 government offices for supporting the use of funds and the success of the projects while collaborating with 7 different office director

●Compiled data into an annual Federal Government report using pivot tables in Excel, showcasing the city’s growth and sustainability impacting more than 2000 families in the rural area

●Oversaw the civil and construction projects executed by the government and third parties, tracked project progression, and provided ongoing insights and recommendations; resulting in the improvement of the principal, secondary, and third roads that communicate the community with the city and state

TECHNICAL PROJECTS

COMMERCIAL AIRLINE FLIGHT DELAYS 2015 -Personal Project -

●Determined the fluctuation in flight volume across months, noting that holidays and vacations coincide with peak traffic months, totaling around 2.5 million.

●Examined the correlation between flight delays and high-traffic months, revealing that February, June, and July in 2015 experienced delays exceeding 40%.

●Revealed that extreme winter conditions in 2015 led to February having the highest percentage of canceled flights, primarily due to weather-related issues.

●Conducted data analysis to ascertain the most and least reliable airlines in terms of on-time departures.

EDUCATION

Data Analyst Certification - Google Certificate - Coursera - August 2022

Bachelor of Engineer, UCEVA, Unidad Central del Valle, Colombia

Contact this candidate