Alexis is a seasoned Data Science Professional with 8+ years of experience in the data field as a database administrator and also as a technical lead in data management. He is proficient in analyzing database issues, monitoring database performance and reporting results; making constant improvements to different database systems and tools to create better customer experiences and help clients make smarter business decisions. He moves fast, adapts quickly, and leaves a lasting mark through the new solutions he delivers on projects.
Delivers data warehouse and ETL solutions as part of an agile team using advanced machine learning techniques to improve performance and processes.
Helps build and improve infrastructure, application and performance development and ensures tight security including data encryption, security groups, and environment scanning.
Ensures high-quality deliverables and implements DevOps and security best practices in fast-paced environments.
Architected and implemented solutions on the ASAP Program Management System for CUNY; following database best practices and maintaining evolving industry standards.
Managed database administration workload, assigned work and ensured the success of solutions in the implementation of data management pipeline workflows on the project.
Implemented complex extract, transform, and load (ETL) workflows on the management system; evaluating, recommending and implementing new database functionalities and data management tools.
The ASAP Data Management System project was a complete rebuild of the operations of the current system; correcting the flaws and defects with better data discovery, automation, and support on the Tableau server for researchers and data analyst. Led a team of four on the project; recreating the main source of data input, finding the right dimensions, speed of change and allowing ASAP data culture to flourish. Redesigned the data model - understanding what was working, what data was loaded from other sources and the sections created by users using ETL updates and new integration points. Developed the databases on the project, its objects and the data workflow to move data from distributed systems - adhering to best practices and advocating alternative approaches when needed.
Worked on CUNY's ASAP Tableau Server which allows the system to continue its data-driven culture and empower all level of users to seek data. Implemented the Tableau solution as a visualization engine that allows all ASAP staff to create and share data at a level of data competency in a self-service manner. Designed and installed the Tableau Server; configuring its security, project layout, broad outline of assets, and publishing content for the community to consume. Enhanced access, introduced campus creators and increased the pace at which content is created; automating data sources, validating data marks and building data sources. Defined the direction of the project, guided Tableau developers on the project, and created data pipelines to load data sources to the server.
Prepared and worked on a real-estate-housing market solution that forecasted home prices using Zillow's home market data API. Wrote the experimental write-up for the solution, handled exploratory data analysis, built the model using ARMA and presented the model results with visualizations to aid the interpretation of findings on the solution.
Education
DATA SCIENCE CERTIFICATE
General Assembly
2019 - Present (5 years)
Master of Computer Information Systems Management (Data Modeling/Warehousing and Database Administration)
Keller Graduate School of Management of DeVry University