Data Analyst/Programmer

Jean-Philippe Michel

Queens Village, NY ***** Tel No.: 347-***-**** Email: *******@*****.***

Highly experienced in Business Intelligence, ETL Processes, and data analysis with in-depth programming skills.

Proficient using BI tools such as Precision BI, SQL, Focus, and WebFocus. Possess excellent quantitative, analytical,

and problem-solving skills. Recognized for strong interpersonal and communication skills.

Core Skills and Competencies

Business Intelligence

ETL Processes

Data Analysis

Statistical Analysis

Computer programming

Quality Control

Problem Resolution

Presentation and Public Speaking

Team Building and Leadership

Work History

Clever Devices Woodbury, NY

DATA SPECIALIST II February 2016 to May 2019

Created Databases to deliver into bus fleet for scheduled operations.

Trained clients on using Clever Devices Database editing proprietary application.

Utilized agile methodology for project flow.

Troubleshoot bugs and provided suggestions for improving the DB tool.

Utilized MS SQL and excel to analyze data and to verify data integrity.

Trained peers on how to better use the proprietary software.

Created applications using VBA for more efficient procedure flow.

Automate data mining procedures using VBA and excel macros to read schedule paddles.

Worked with different departments to ensure on time and high quality deliverance of the database.

Key Achievements

Arbitrated and clarified issues between client and project manager.

Created spec documents for client specification in order to build databases.

Managed multiple projects that had equal priorities.

SKY IT GROUP INC. New York, NY

ETL Developer May 2015 to November 2015

Created ETL processes for data migration from flat files to DB2 database.

Developed and scheduled ETL flows using WebFocus Data Migrator.

Verified data integrity and analyzed the data from overnight ETL processes.

Analyzed data by creating reports in WebFocus.

Created tables and views in DB2 SQL, also analyzed data by querying such database objects in SQL.

Created Excel file parsers using Qlikview.

Documented my projects and codes for better comprehension.

Key Achievements

Created innovative methods for more efficient and accurate ETL Process.

Acquired data mining skills.

APEX SYSTEMS INC. New York, NY

Business System Analyst (Consulting at Cablevision, Hicksville, NY) May 2014 to February 2015

Implemented reporting tools using WebFocus and SQL.

Conducted projects with complete ownership from inception to completion.

Created GUI using JavaScript and HTML for reporting tools.

Verified data integrity through analysis of NETEZZA, HADOOP, REMEDY, and MYSQL data systems.

Used Aginity for SQL coding in NETEZZA and Hive for SQL queries in HADOOP.

Advised the programming team for better solutions of data flow and reporting.

Key Achievements

Automated processes and provided key ideas to my team for effective ad elegant coding.

Acquired knowledge of SQL for different platforms.

WestMed Medical Group Inc. Purchase, NY

Business System Analyst January 2012 to March 2013

Managed the integrity of business letter generation for patients produced by precision BI.

Created business and clinical reports for users via Precision BI.

Checked for errors in the ETL at the extraction, load, and translation level.

Resolved ETL issues by identifying ETL errors and communicating the error to the DBA.

Verified data integrity via EMR and Centricity Business from GE Centricity Business.

Project coordinator for reports based on physician’s meaningful use for Medicare reimbursement.

Tailored and created custom reports using VBScript in Precision BI.

Created reporting application for Call Center scheduling using MS Access.

Produced and delivered anesthesia and immunization records to government agencies.

Key Achievements

Automated report distribution and error analysis.

Acquired knowledge of EMR processes.

Assured Guaranty Inc. (formerly Financial Security Assurance), New York, NY

Programmer/Analyst 06/00-12/10

Maintained data integrity of Assured Guaranty’s database system via automation.

Produced reporting application for Accounting, Legal, and Surveillance department using WebFocus.

Analyzed and resolved problems that arose in the overnight cycle of WebFocus data warehouse.

Created ETL routine via SQL and WebFocus to transfer data from Sybase into data warehouse.

Managed and maintained the SOX compliant Data Deliverable application using WebFocus.

Created Basel II compliant reporting and data deliverable application using WebFocus.

Manipulated data flow using SQL by creating store procedures and data queries.

Created test cases and regression testing script for my own applications.

Prepared documentations for user requirements to implement the waterfall model of development.

Presented application programs to business unit managers for UAT testing.

Key Achievements

Created business processes compliant with SOX and Basel II regulations.

Engineered overnight processes for data integrity checks.

Other Work History

Hunter College New York, NY

Research Assistant March 2013 to May 2014

Ran tests on patients to measure brain signal output from light emitting patterns.

Analyzed resulting data on Excel to determine the human visual pathway (HVP).

Created Excel application to plot data on graphs and to facilitate analysis of the HVP.

Managed computer networking system of laboratory.

Used MatLab for data analysis.

NLCHC Queens, NY

Volunteer January 2011 to May 2013

Screened patients for blood pressure, sugar, and cholesterol.

Helped staff with computer applications such as Excel.

Created a system to assess patient’s evaluation of our service.

Coordinated efforts to procure an EMR system for the organization

Lenox Hill Manhattan Eye and Ear Hospital (NSLIJH) New York, NY

Volunteer June 2011 to August 2011

Registered patients and setup appointments.

Helped staff manage organizational logistics by creating statistical reports of patient throughput.

Created Excel application to analyze patient throughput.

Led research projects concerning patient scheduling and efficiency in patient’s waiting time.

Education

City College of New York - New York, NY

Computer Science, physics minor

Hunter College – New York, NY

Bachelor’s Degree in Biology

Skills And Activities

Focus, WebFocus, C++, Pascal, MatLab, SQL, Excel, Access, Word, Power Point, Cognos, Precision BI, EMR, Centricity Business, VBScript, JAVA, JavaScript, HTML, WebFocus Data Migrator, and Qlikview

Conversational French, Spanish, and Creole

Contact this candidate