KESNER FIGNOLE

Lake Worth, FL *****

Phone: 561-***-**** - ady7s8@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Well versed in OOP

Advanced knowledge in Database design,

implementation, and management (Logical and Physical)

Generating Data Analysis

Use Pandas

Use PHP

Use MySQL

Python for more than 1 year

Use Linux

Knowledge of REST API

Experience working with AWS

Agile methodology

Excellent collaboration of offshore and local engineers

Strong Data structures and algorithm optimization

Git

QA for more than 1 year

MVC framework

Docker for more than 3 years

JavaScript, HTML, CSS

Rally

Excel for Data Analytics

etc

PROFESSIONAL EXPERIENCE

Netsurance

Data Specialist

West Palm Beach, Florida – September 2019 - current Use PHP and/or SQL for Data Integration, Data Extraction, Data Maintenance, and Data Management, Pandas for Data Cleansing. Develop SQL Scripts. SQL and Excel for Data Analysis.

(Project details on page 2)

Managed Maintenance Inc.

Software Developer (Data Integration & Data Analysis) - Supporting Lenovo, IBM and other Manufacturers.

Boca Raton, Florida — October 2016 - August 2019

Use PHP and SQL intensively and Python moderately to develop integration (back end) components on a Linux environment. Implement and use various tools to monitor the integration system. Also, build Shell scripts (bash) for automatic testing of the integration system, and use Linux, Pandas, SQL, and Excel to do file and data analysis.

(Project details on pages 2 & 3)

Managed Maintenance Inc.

Quality Assurance - Supporting Lenovo, IBM and other Manufacturers.

Boca Raton, Florida — December 2015 - October 2016 Build Shell scripts (bash) and SQL scripts for automatic testing of the backend and, also, use manual processes for any type of testing.

(Project details on page 3)

JPWEBS

Software Developer

Royal Palm, November 2014 – October 2015

● Use HTML, CSS, WordPress, JavaScript

● ...

PROGRAMMING LANGUAGES

JavaScript

PHP

Python

SQL

HTML

CSS

SKILLS FOR DATA ANALYTICS

NumPy

Pandas

R

Qlik

Excel

Seaborn

Matplotlib

Python

Tableau

OTHER SKILLS FOR DATA ANALYTICS

Mathematics (Solid Level)

Statistics (Solid Level)

EDUCATION HISTORY

Master Degree, Data Science, Eastern University, St. Davids, Pennsylvania 7/2022

Bachelor Degree, Information Management – Database Administration Concentration, Palm Beach State College, Lake Worth, Florida 8/2014

Associate Degree, Computer Programming, Palm Beach State College, Lake Worth, Florida 05/2011

Bachelor’s Degree, Industrial Engineering, GOC University, Port-au-Prince, Haiti 7/2001

CERTIFICATES

Data Analysis For Healthcare Claims Data 07/2023

Data Analysis Essential Using Excel 06/2023

Introduction to Google Cloud BigQuery 02/2023

Tableau 2020 Training for Data Science 10/2021

LANGUAGES

English, French, and Creole

Page 1 of 4

Netsurance

Data Specialist

West Palm Beach, Florida – September 2019 - to present Details

● Data Management (SQL and Linux)

o Determine Irrelevant data based on requirement logic o Analyze the Data to answer client’ questions

o Recommend modification of requirements based on historical of data issues o Design and implement Database

● Build Integration components (PHP, MySQL)

o Using scripts to extract data from different sources o Use Scripts to build files from data extracted from Databases

● Evaluate and resolve tickets (PHP, MySQL)

● Data Maintenance

o Build SQL scripts to perform data maintenance

o Build SQL objects to perform data adjustment

● Data Cleansing (Pandas)

● Data Analysis (SQL, Excel)

o Building Graphs and Charts

o Formulate Models

Use of PHP, MySQL, Linux, HTML, CSS, JavaScript

Managed Maintenance Inc.

Software Developer (Data Integration & Data Analysis) - Supporting Lenovo, IBM and other Manufacturers. Boca Raton, Florida — October 2016 - August 2019

Details

● Data Analysis (Pandas, SQL, and Excel)

o Determine Irrelevant data based on requirement logic o Analyze the Data to answer client’ questions

o Recommend modification of requirements based on historical of data issues o Build queries to perform data maintenance

o Build SQL objects to perform data adjustment

o Clean-up Data

o Look for trends

o Build appropriate graphs for visualization

● Build Integration components (PHP, MySQL)

o Monitoring components (Scripts to catch errors)

First level components to monitor the entire integration system

Second level components to monitor the integration jobs

Third level components to monitor the details of each process o Inbound jobs (Scripts to process files received from the FTP)

Receive data files from the FTP

Process files based on business logic

Fill the database

Page 2 of 4

o Outbound jobs (Scripts to build files from the data stored in the database)

Build different files formats, based on business logic, from data available in the database

Upload files to the FTP and S3

o Data Side

Design database

Build efficient and complex queries

Build store procedures, Functions, Triggers

o Other actions

Build components based on new requirements

Modify components based on modified existing requirements

● Evaluate the tickets of end users (PHP, MySQL, Pandas) o Compare the tickets of end users to the business logic o Make data analysis to discover eventual data issues o Take appropriate actions to resolve the eventual issues

● Evaluate performance of the system (PHP, MySQL, Python) o Measure the time taken by each job

o Determinate existing performance issues

o Determinate the cause of eventual performance issues o Take actions to resolve eventual issues

● Creation object issues (PHP, MySQL)

o Determine if the issue is internal or external

Review business logic

Evaluate the endpoint communication

File analysis

Take actions to resolve eventual issues

● System endpoint communication errors (PHP, MySQL, Python, Pandas) o Evaluate the state of the FTP server

o File analysis

● By pass the standard process in some special cases to keep high performance of the system (MySQL, Pandas) o .Process big files manually

Make plan

Build special and adapted SQL scripts

Take actions

● Test the integration components (Shell scripts)

o Build shell scripts for automation testing

o Keep results in S3

o Make plans for QA to test the backend

● Interact with FTP, S3, SQL, DBMS, GIT, Python, Linux, PHP, Excel, Pandas, MVC framework, Rally, Docker, etc Managed Maintenance Inc.

Quality Assurance - Supporting Lenovo, IBM and other Manufacturers. Boca Raton, Florida — December 2015 - October 2016 Build Shell scripts (bash) and SQL scripts for automatic testing of the backend, use manual processes, and use Pandas and Linux to do file and data analysis. Details

● Testing

o Integration Testing

Using SQL scripts

Using Shell scripts

Using manual process

Page 3 of 4

o Regression Testing

Using SQL scripts

Using Shell scripts

Using manual process

o System Testing

Using SQL scripts

Using Shell scripts

Using manual processes

● Interact with FTP, DBMS, GIT, Linux, PHP, MVC framework, Rally, JavaScript, CSS, HTML Page 4 of 4

Contact this candidate