Data Analyst Support Specialist

Essi M Kpoedzu - ********@*****.*** – 704-***-****

Collaborative team player with excellent technical abilities offering four years of related experience. Solution-driven IT Specialist adept at contributing to highly collaborative work environment, finding solutions and determining customer satisfaction.

SKILLS AND CERTIFICATIONS

SQL, Python, Java, JavaScript, Angular, HTML/CSS, SQL. MySQL, PHP, T-SQL, Hadoop, Cloud Storage, Docker, Spark, GCP, AWS, Azure, Agile, MS Server SQL, PostgreSQL, Maven. Testing with Maven, Junit, Spring Boot, Spring MVC, Apache Airflow, Power BI, Tableau, Visual Studio Code, WORD, Excel, PowerPoint, React, Redux, Git

WORK EXPERIENCES

MERN-FULL STACK DEVELOPER-ECOMMERCE September 2022 Remote

Designed full responsible dynamic client-side applications using HTML5 and React/Redux web development UI features (registration, login, reset password, place order, checkout the bucket, review & more)

Developed server-side using Express.js and Node.js that handled requests and responses.

Achieved the database connectivity using Node.js.

Used testing with Thunder Client and Postman

Data engineering. August 2022 Charlotte, NC

Created a data warehouse where data is scraped from the CPI average price website.

Aggregated the raw data into a staging area (data lake) From the staging area, transform and load the transformed data (consistent data for analytics) into a data warehouse.

Designed an automation monthly update of the data warehouse and the consumer average price index plot.

Designed an ETL pipeline using Apache Airflow for task orchestration and scheduling.

Designed and connect PostgreSQL database to Airflow, and load extracted data into the database.

Checked the consistency of the data and load it daily to the data warehouse using Apache Airflow task scheduler.

Revature-Software Engineering-Ful Stack developer May-august 2021 Remote

Developed application allowing users to login and submit requests for reimbursement and view their past tickets and pending requests using Incorporated Object-Oriented Programming such as Encapsulation and Inheritance as well as Maven as a project management tool to handle dependencies inside the application.

Leveraged server-side technologies such as Java, Servlets, and Filters to handle requests and responses and single -paged application using Angular and NodeJS as well as achieved 84% test coverage of the service layer using Junit.

GCP/AWS/CLOUD COMPUTING DATA engineering and Machine learning. May 2022 CHARLOTTE, NC

Processed data using GCP technical tools to create a bucket to store objects and ingest data into the cloud and to control access.

to MySQL database management system and populate the database.

Achieved migration of existing MySQL and Hadoop/Pig/Spark/Hive workloads to Google Cloud using Cloud SQL and Dataproc

Implemented interactive data analysis through Big Query

Built Resilient Streaming Analytics Systems and Batch Data Pipeline on Google Cloud

Modernized Data Lakes and Data Warehouses with Google Cloud

Novant HEALTH TECHNICAL support specialist January 2017-april 2020 charlotte, NC

Led to create database system for a medical emergency clinical record with features to support security, privacy, audit trail using NetBeans with MySQL Workbench

Developed application programming interface via developing web pages to transfer data, using XAMP with phpMyAdmin to allow the users to apply data manipulation language (create, insert, delete, update) using PostgreSQL database to design and connect to Airflow to load the data after extraction and transformation using Apache Airflow for tasks orchestration and scheduling and visualization purpose.

University of North Carolina at Charlotte - Graduate Courses, Projects & RESEARCH Dec 2018 - Dec 2020

UNCC-Tableau Developer: Data Analyst /Used Cars Dataset from Craigslist

Used data visualization tools to provide comprehensive interface for end users to access their Data.

Creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts,

Developing and producing peer quality metric performance to validate data and process for accuracy, making key decision.

Created demos in Tableau Desktop and published on Tableau server (Shared Link: https://public.tableau.com/profile/essi5523#!

UNCC-Principles of Information Security and Privacy Project

Worked in all aspects of standard security technologies: firewall, antivirus, antimalware, authentication methods, IPS/IPD, encryption,

Built methods for incident response, policy creation and enforcement, assessing security vulnerabilities and proposing solutions, and ensuring business critical applications are deployed and maintained in a secure manner.

Introduced architecture plans of existing network infrastructure, network design review, security recommendation for network security solutions, products, controls, and sensor.

Gained knowledge of security and network policies and procedures, principles, cloud infrastructure and applications, TCP/IP, security protocols such at TLS, IPsec, SSH, and network services such as DNS, SMTP, HTTPS, Packet Eavesdropping and Analysis using wiretapping software tool such as Wireshark

UNCC- Big Data Project/Kaggle /Data Analyst Aug 2020 – Dec 2020 Charlotte, NC

Lead team to predict House Sale Prices using Linear Regression, Decision Tree Regression, Radom Forest Regression, Gradient Boost Regression

Discovered, gathered, and cleaned a total dataset of more than 2000 data entries.

Reviewed Data and assigned tags to accurately describe its contents.

Result scored among the top 10 scores and our rank lied in the top 3% out of 5300 participants.

EDUCATION

University of North Carolina at Charlotte: Master of Science Information Technology, gpa 3.6, December 2020

Senghor University (Francophonie), Master’s in Business Administration & Project Management, May 2005

University of Paderborn, Germany, German Language Certificate, June 2008

University of Lomé: Bachelor & master (C1 & C2) in Sociology Community Development June 2001

Contact this candidate