Jan C.B. Serapio Email & Phone Number

*Same as the previous wit the added responsibility of:Operations and development:-Help maintain and onboard databases through a mixture of on-server maintenance, Azure, and sometimes, direct download and interpretation of data.-Led a 4 person projects team towards automation goals.

Operations and development:-Monitors day-to-day server and task performance to ensure stable data production across multiple financial and non financial data types and data vendors such as MSCI, Refinitiv, Markit, ICE, Bloomberg, etc. -Investigate and coordinate with global data vendors and client side teams to ensure data availability and timeliness on FTP, SFTP, etc.-Identify and perform maintenance procedures on existing Perl, Python code base.-Co-engineered data architectures and scripts for new day-to-day production processes.

*Same as the previous with the added responsibility of:Production, continuous improvement, and Data QA:--Led and managed a five-person team in maintaining the data quality and timeliness of legal entity and ESG data. Is responsible for the day-to-day operations and performance monitoring. Also serves as point of escalation for the team.--Coordinated with various international teams to develop new company wide workflows for entity data QA.--Helped research and develop new product features driven by client demand. Also, coordinated with data vendors to support this new feature. --Helped review and onboard new data vendors for the company.Technical assistance and reporting:--Developed a python Tkinter GUI to consolidate analyst's tools for production QA and performance monitoring.--Worked with global teams to develop a Futures and Options API.

Zuellig Building, Makati Ave. Cor Paseo De Roxas, Makati City, Philippines.

*Same as the previous with the added responsibility of:Production, continuous improvement, and Data QA:--Led a three-person team in maintaining the data quality and timeliness of legal entity and ESG data. Was responsible for the day-to-day operations, performance monitoring, and served as point of escalation for the team.--Coordinated with various internal teams, to develop and test company wide web based (JAVA, XML, etc.) based tools.--Led automation efforts to reduce QA time from 4-6 hours to 30 minutes via development of several Python based tools. Technical assistance and reporting:--Provided technical assistance and expertise to various teams and is point of contact for all reference data questions related to equity, issuer, and ESG data. --Prepared reports via Power BI to monitor team metrics, performance, and various statistics on the database--Conducted training on Python/ and other internal tools--Developed and co-developed of several Python based tools for day to day workMisc:--Was responsible for interviewing and training new candidates for the team during the hiring process

Zuellig Building, Makati Ave. Cor Paseo De Roxas, Makati City, Philippines.

Production, continuous improvement, and Data QA:--Maintained the timeliness and consistency of an ever evolving and diverse database containing equity, fund (mutual, equity, and fixed income), bonds, structured products, benchmarks, options, and futures reference data. --Responsible for the planning, testing, and development of Perl/C++/Python based scripts to meet client demands, and improve data quality and timeliness.--Worked with various Operations and Development teams monitoring data timeliness in Autosys. --Responsible for answering client and internal team queries via Salesforce. Technical assistance and reporting:--Prepared reports via Spotfire to monitor team metrics and performance--Conducted training on Perl/ and other internal tools--Co-authored several internal documents for day to day operations.

Main Road, Phase 1-A, San Lorenzo South, Santa Rosa City, Laguna

Taught several weekly classes of high-school students in the history, application, and skills training in arts.

Master Of Science - Ms, Economics

*Studies ongoing

Bachelor Of Science - Bs, Economics, Gwa 2.20

Coursework in: Econometrics, business management, business law, accounting, stocks and monetary management, human behavior in management.

High School, 2Nd Honorable Mention

Activities and Societies: Head of the Artists Guild of SLCS (2009-2012), Class President (2008-2009; 2009-2010).