Data Analyst, SQL, Python, Tableau
Resume:
Ekene Nwokoye Data Analyst
Houston, TX
GitHub
Data Analyst with a background in mechanical engineering and 4 years experience in renewable energy and project management. Proficient in writing complex queries in SQL, manipulating and data analysis in Python, and visualizing insights discovered using Excel, Python, and Tableau
Skills
Tools/Programs: Excel, Python (numpy, pandas, matplotlib, seaborn), SQL, Tableau, PowerPoint, SalesForce, MatLab
Approaches/Methods: Web-scraping, APIs, missing data imputation, exploratory data analysis (EDA), visualisations, statistical analysis, numerical analysis, A/B Tests
Projects
Analysis and Prediction of GlassDoor Job Postings GitHub: Analysis and Prediction of Salary (ongoing)
●Using python, web scrapped GlassDoor job postings, in order to analysis and predict company salaries based on job title
●Wrote function to, visualize and run statistical A/B test on any two years given
●Built with: Jupyter, Python, Pandas, Seaborn, Selenium, Natural Language Toolkit (NLTK), Scikit-Learn
Statistical Test on World Happiness from 2015 - 2016 GitHub: Analyzed Gallup World Poll for trends due to climate
●Extracted data from Kaggle, cleaned and organized data using python
●Wrote function to, visualize and run statistical A/B test on any two years given
●Built with: Jupyter Notebook, Python, Kaggle API, Pandas, Seaborn
Housing Prices and Heating GitHub: Was asked to find the best homes our investment groups should invest in
●Loaded, cleaned and ran initial EDA using Python and exported to Excel
●Sampled cleaned data based on hypothesis, confirmed for no biases and ran statistical A/B Tests to accept or reject our hypothesis, and presented results
●Built with: Jupyter Notebook, Python, Pandas, Seaborn, Excel, PowerPoint
Education
Houston Community College Houston, TX
Certification in Project Management November 2016
University of New Hampshire Durham, NH
Bachelors of Science in Mechanical Engineering May 2015
●Led in designing, executing, and analyzing various experiments involving real time and forecasting events, using Excel, MatLab, SolidWorks, and PowerPoint to model, analyze, and present various hypothesis
●Participant of DVIAA Semi-Championship Varsity Football Team (was able to graduate on time)
Experience
Thinkful Remote
Data Analyst Apprenticeship January 2020 - May 2020
●Extracted and presented actionable insights that delivered business value from common data sources like Excel, CSV files, and SQL databases
●Performed ETL in various environments using APIs, SQL, and other methods
●Performed AB tests to determine the statistical significance of a stimulus
●Expanded on expertise in use of of Excel (power-query, vlookup, pivot tables), Powerpoint, SQL (PostgreSQL and MySQL), Tableau, and Python(pandas, numpy, seaborn) for data analysis
Sunder Energy Houston, TX
Solar Consultant March 2019 - Present
●Strategize with managers on target goals and timelines for the best way to grow the team and hit our KPIs
●Improved lead generation and contact rates by suggesting new campaign hours that targeted times home owners would most likely be home
●Leveraged CRM systems such as SalesForce and Spotio. Was able to ensure timely completion of projects, while also focusing on customer satisfaction, which in turn led to better reviews for the company and referrals
Alba Energy Katy, TX
Senior Solar Consultant May 2017 – December 2018
●Grew the company by over $2 million in sales by gaining understanding of the market, market share, and using interpersonal skills to educate potential customers and closing deals.
●Leveraged CRM systems such as SalesForce and Spotio to ensure timely completion of projects
●Focused on customer satisfaction, which in turn led to better reviews for the company and referrals
●Responsible for, and delivered on weekly goals with a small team, expanding the Austin based solar company into the Houston area.
●Daily duties included, self-generating leads by using strong interpersonal, and negotiating skills to educate, and persuade customers into making long-term investment.
SolarCity Sugar Land, TX
Energy Consultant October 2016 – March 2017
●Generated leads, scheduled appointments, and presented proposals, involved in back-end operations, and ultimately the company-user liaison for installation of customers' solar array.
●Developed, and built relationships with customers to ensure satisfaction throughout completion of the project.
●Managed multiple accounts at same time, and communicated with other groups of the company using salesforce and email.
RandStad USA Houston, TX
Office Assistant September 2015 - October 2016
●Office assistant for United Way of Greater Houston as they began their fall season company campaigns.
●Utilized CRM system to confirm and validate inventory, purchase orders, and invoices. Responsible for gathering, assembling and shipping orders for the largest wholesale fire-equipment warehouse in Houston, TX and Southern US Region.
Contact this candidate