Strong experience in production support, ETL design, monitoring, cloud resource management, data analysis, executive management report creation, geographic information analysis, planning, documenting, and execution of operational readiness and testing.
Skilled in deployment of client/server applications, SQL and Python development, and working with various tools such as Informatica 10.5, Informatica Intelligent Cloud Services (IICS), Azure PaaS DB, Snowflake, Oracle BI, Jupyter Notebook, QGIS, ArcMap, MySQL DB, Unix, Linux, ScienceLogic, Windows 2012 R2, SSIS, and MS Power BI.
Utilizes scripting and automation to enhance efficiency and performance. Track record of successful project completions, demonstrating strong understanding of integration methodologies.
Demonstrated leadership, attention to detail, and the ability to make technical decisions.
Excellent experience in Agile development methodologies and full project lifecycle management.
Overview
7
7
years of professional experience
Work History
Monitoring Data Integration Engineer
NYC Office Of Technology and Innovation
07.2023 - Current
Currently support and upgraded six primary data collector servers from ScienceLogic version 11.2.1 to version 12.1.1, resulting in no issues to the team and clients
Single-handedly built an ETL pipeline using Python and SQL to extract and transform relevant monitoring data from multiple devices to ScienceLogic’s MySQL database, effectively managing 12,191 devices at zero cost to the team and department
Developed an integration architectural diagram using Microsoft Visio to illustrate the relationship between integrated processes, data sources, custom scripts, and target databases
This diagram has help drastically reduce the team response time to issue by more than 75 percent
Created and organized a central documentation repository for all custom scripts, incidents, and resolutions, enhancing incident management and documentation
Collaborated with NYC OTI’s Security team to set up a secure location (Centrify) for storing team passwords, improving password management
Ensured all our applications are free of common coding vulnerabilities and follow standard security practice
Conducted morning validation checks on systems at the start of business, analyzing data for abnormalities and making necessary corrections/enhancements
Integrated various Restful APIs to ScienceLogic and custom scripts to monitor New York City government agencies’ resources
Coordinated with team members to ensure Service Level Agreement (SLA) compliance
Board of Trustee
Alexandra Robertson School
10.2020 - 07.2024
Oversee the Head of School and senior management to ensure the best interests of Alexandra Roberson School
Monitor the school's financial performance and implement cost-cutting measures when necessary
Ensure compliance with all legal and ethical standards in New York and other states
Assist the Head of School in redesigning the school math curriculum and provide guidance for the acquisition of technological resources
Data Engineering Support
NYC Office Of Technology and Innovation
10.2017 - 07.2023
Served as a subject matter expert, supporting nightly/daily ETL data loads into New York City’s central databases
Managed and communicated with clients regarding the Citywide Performance Reporting Dashboard and commissioners' daily reporting dashboard issues, participating in cross team coordination for incident resolution
Created and maintained ETL pipelines using SQL, SSIS, and Informatica for NYC Office of Emergency Management, resulting in various dashboards created for executive management
Identified registrants per emergency notification and the devices and languages used by users
Led interviews with stakeholders and teams to ensure data requirements were met for each project, contributing ideas aligned with project objectives, participating in testing, and ensuring system validation
Oversaw the deployment of releases in different environments and coordinated break fixes
Business Analyst
Research Foundation of the City University of New York/NYC DOITT
01.2018 - 07.2018
Conduct interview sessions with bureaus, clients or stakeholders related to information gathered, document Define Business/Functional Requirements Documents (BRD/FRD) and be actively involved in managing business analysis with technical assessments for new information technology requests
Analyze business requirements and technical specifications to ensure full understanding of individual deliverables
Develop, document, and maintain functional test cases and other test artifacts, such as test data, data validation and automated scripts
Document test results, and compile results of other testers into consolidated report for management, clients, applications staff
Manage the execution of technical and functional requirements
Support the technical team in development and testing, to ensure execution of project deliverables goes as expected
Education
Certificate in Strategy Execution -
Harvard Business School Online
07.2024
Master of Science - Applied Urban Science and Informatics, Applied Data Science
NYU, Tandon School of Engineering
Brooklyn, NY
05.2022
Certified Oracle Business Intelligence 11g Implementation Specialist -
Oracle University
New York, NY
09.2018
Bachelor of Business Administration - Computer Information Systems
Baruch College, CUNY, Zicklin School of Business
New York, NY
05.2017
Skills
Linux/Unix
Windows 10/11
MS SQL Server 2018/2019
Snowflake
Oracle SQL Developer 11g/12C
MySQL DB
Azure PaaS DBs
SQL/Python/Unix shell scripts
TCP/IP/Ftp/WinSCP
SQL Server Integration Services (SSIS)
Informatica Intelligent Cloud Services
Jupyter Notebook
ScienceLogic
QGIS/ArcMap
OBIEE 11g/Oracle Analytics Server (OAS)
MS PowerPoint/MS Excel
SSMS
MS Visual Studio Code/
ServiceNow
Application integration
GitHub
Awards
New York University Professional Student Award, 2022
New York University Academic Scholarship, 2020
Inducted member of The National Society of Leadership and Success, Kingsborough Chapter
Timeline
Monitoring Data Integration Engineer
NYC Office Of Technology and Innovation
07.2023 - Current
Board of Trustee
Alexandra Robertson School
10.2020 - 07.2024
Business Analyst
Research Foundation of the City University of New York/NYC DOITT
01.2018 - 07.2018
Data Engineering Support
NYC Office Of Technology and Innovation
10.2017 - 07.2023
Master of Science - Applied Urban Science and Informatics, Applied Data Science
NYU, Tandon School of Engineering
Certified Oracle Business Intelligence 11g Implementation Specialist -
Oracle University
Bachelor of Business Administration - Computer Information Systems
Sr SharePoint Developer/Admin at NYC Office of Technology and Innovation- ОТІSr SharePoint Developer/Admin at NYC Office of Technology and Innovation- ОТІ
Communications Electronic Specialist at Port Authority of New York and New JerseyCommunications Electronic Specialist at Port Authority of New York and New Jersey