Data Engineer

• Feb 2023 - Present

Senior Systems Analyst / Data Architect

• May 2020 - Feb 2023

ETL Development - Design, develop, and maintain Extract, Transform, and Load (ETL) processes utilizing combination of shell scripting, Pentaho Data Integration, SQL development (Oracle & MySQL), JavaScript, REST API, and Python. Maintain version control and concise code management via GitHub. Build and maintain various DBs and DB models. AWS Architecture – Primary cloud POC responsible for deployment and configuration of EC2 and RDS instances and site-to-site VPN purposed for hosting processes that handle LMS / HR pre-processing logic, storage, and HANA DB for reporting. Business Intelligence / Data Analytics Development – Responsible for design, development, and publication of executive-level dashboards within AWS Quicksight to provide real-time insights and trend analysis of various datasets. Report Development - Design and develop automated CSV, HTML, and PDF reports utilizing Eclipse Business Intelligence Reporting Tool (BIRT) or Plateau Report Designer (PRD), SQL queries, and XML. Tier 3 Support - Responsible for investigating interruption of availability or integrity of data within supported systems’ Staging or Production environments. Fields technical email inquiries from client stakeholders and escalations from tier 2 support. Supports the investigation, short or long-term remediation, and root cause analysis of issues observed in systems. Linux System Administration – Responsible for ensuring the availability, resiliency, and health of underlying infrastructure OS hosting business process applications. Security Engineering – Responsible for configuring infrastructure to comply with security hardening requirements as set forth in AWS best practice industry-accepted standards such as DISA STIG. Requirements Engineering – Responsible for eliciting system needs / pain points from client stakeholders and developing functional / non-functional requirements into proposed solution. Show less

Application Support Analyst Lead

• Mar 2020 - May 2020

Acted as lead and primary POC for escalations regarding production matters in supported portfolio.Lead monthly accounting close status meetings. Lead POC for providing application status, processing progress, and overall process health to business process owners, application owners, and other key stakeholders.Developed LAI execution quality of life improvement application: “LAI Touch-Notifier” and deployed to Fannie Mae PowerApps cloud for mobile or desktop use.Served as Maintenance Coordinator, Server Maintenance Coordinator, and Change Coordinator for portfolio assets.Coordinated and published work schedule for team.Lead T2 production incident triage caused by one or more of the following: ETL workflow, data quality, performance degradation, application defect, service availability, and / or system configuration.Managed problems and incidents by conducting root cause analyses, applying short-term solutions, and recommending long-term solutions to development team or shared service teams.Sole POC for managing portfolio NUID passwords through password vault and / or PAM.Coordinated, implemented, and verified database modifications as necessary within Oracle and IBM Netezza platforms.Identified, created, and maintained knowledge article candidates for L1/L1.5 knowledge repository. Show less

Application Support Analyst II

• Jan 2017 - Mar 2020

Provide Tier 2 Support for production applications as part of enterprise Loan Accounting Initiative (LAI) including database and platform rules engine for accounting.Coordinate, track, an implement all production changes to enterprise LAI configuration items.Maintain and execute LAI runbooks.Coordinate, implement, and verify database modifications as necessary within Oracle and IBM Netezza platforms.Identify, create, and maintain knowledge article candidates for L1/L1.5 knowledge repository.Coordinate LAI production processes in relation to infrastructure maintenance / downtime.Study business processes in client or host unit and how they are automated. Examine business processes in unit to determine how they could be translated into requirements for IT applications.Assist staff in unit with use of application that automates or executes their business processes.Develop data extractions or develop reports from requests or requirements stated by clients. Use database, report writer, data mart, or specialized applications to generate reports or analyses.Note interruptions or bugs in operation and perform problem solving exercise to determine problem and ensure continued use of the application.Track production issues and report periodically to group charged with monitoring uptime and efficiency of production application.Participate in project meetings to plan rewrite of addition to application in production or being revised for release into production. Show less

Production Support Engineer

• Jun 2016 - Jan 2017

Provided 24x7x365 on-call tier 2 support to troubleshoot and resolve production issues with applications developed using one or more of the following: Windows, UNIX, AutoSys and Oracle. Documented resolution details in Knowledge repository Reviewed, approved and executed (if appropriate) Data corrections/DBMODs and other ad-hoc production requestsReviewed and provided FCC approvals for all change requests.Reviewed and certified production activity logs - CLAM (Central Log Analysis Manager)Sent daily management reports on time and attend daily status calls if necessaryCreated necessary defect, enhancement and/or problem tickets for issues identified in production and assigned them to appropriate teamsReviewed and coordinated daily change requisitionsUtilized BMC Remedy work order system to document incident and problem tickets for supported applicationsUtilized ServiceNow tracking system to document and execute change tickets for supported applications Show less

IT Helpdesk

• Mar 2016 - Jun 2016

Provided Tier 1 helpdesk/customer service support for proprietary grants and contract application software to both government and federal recipients Assisted customers with information and system inquiries using the Education department’s Central Automated Processing Systems (EDCAPS) Identified and resolved issues impacting user’s ability to manage their grants and contracts systemically Tracked and logged all customer inquiries using the RemedyForce incident tracking system Resolved issues via telephonic and email customer support Assigned all issues that could not be resolved at the Tier 1 level to Tier 2 for resolution Show less

Quality Assurance Intern

• Nov 2013 - Oct 2014

Utilized Jira issue tracking software to report, regression test, assign, and prioritize bugs to appropriate development teams Tested, reported, tracked, and regressed newly implemented scripting issues in proprietary software engine Tested, tracked and reported bugs across multiple platforms such as Windows 7, Mac OS, Playstation 4, Xbox One Ran daily smoke tests to ensure core functionality Ran integration tests to verify functionality of newly implemented mechanics across different versions Collaborated with other test and development teams to run large scale in-house stress tests Attend daily scrums with different development & testing teams to go over production goals and priority targets Show less

IT Intern

• Apr 2012 - Sep 2012

Collaborated with MC OIT in the removal of SD technology and installation of HD across three campuses Ran pass / fail functionality tests on all newly installed multimedia and desktop equipment Provided removal, installation, and maintenance of multimedia assets for academic and administrative technology Provided telephonic customer support Provided troubleshoot and installation services for common desktop and classroom multimedia peripherals including but not limited to: cameras, microphones, keyboards, mouse, input switches, printers, projectors, speakers, and monitors Soldered, programmed, and installed Mediatech proprietary “Buttonmate” input switch interface into classrooms Contacted, networked, and escalated issues among other IT departments depending on context of incident source Installed Mediatech control systems and accessories across all campuses Integrated, removed, supported, operated, maintained, troubleshot and resolved/repaired computer hardware and software for Smart Instructor Workstations (computers, data projector systems, document cameras, audio systems and control systems). Show less