Deloitte: Department of State - Consular Affairs

My first project at Deloitte was with the Department of State - Consular Affairs. One of the largest parts of Consular Affairs is the management of travel issuances through passport and VISA systems. Deloitte has been asked to help with the upkeep and upgrade of the system.

My role on the project consists of two main responsibilities:
1) Production Support for Passport Applications
2) Data Analytics for Travel Issuance Production Support Systems

Project Highlights:
1) Provide production support for passport systems at the Department of State consular affairs by developing scripts that identify and ingest over 100,000 passports into databases that are missing passport data.
2) Develop technical documentation for passport system issues and resolutions which has removed single points of failure and reduced pending issues by over 60%.
3) Lead the effort at production support to utilize data available from passport and VISA systems to provide analytical that have stopped 100s of incidents that could result in tens of thousands of dollars in work-stoppage costs for the US Government.

Technical Skills:
SQL, Python, Splunk, AppDynamics, Grafanna, OracleBI, PowerBI, Tableau, Technical Writing, and Powershell