💡
Data Engineering Intern, Principal Financial Group (May-July 2022)
🚨
DORA Metrics Project
Implemented a workflow by utilizing AWS cloud infrastructure tools to calculate DORA Metrics (DevOps Research and Assessments) and produce a dashboard in AWS Quicksight to help teams work more efficiently.
To accomplish this task, we worked with AWS CDK (in Python) and automated a workflow. We first wrote a chain of three lambdas and connected them via a StepFunction to extract relevant data from Github pull requests and Azure project/pipeline APIs. In the process, we validated the data (by using the pydantic library) and wrote the data to an S3 bucket. A new file in the S3 bucket would trigger a data transfer into DynamoDB (which itself was created by using AWS Glue), which was finally used to produce a dashboard in AWS Quicksight.
🚨
IT Code Jam (Hackathon)
Created a website as a demo for a Personalized Onboarding Experience in four days. This website was built using React and Node.js (hosted on AWS Amplify), which would take an individual's name & team as input and produce personalize webpages with relevant onboarding/installation information. As part of this project, we also made sure to implement several layers of security by using AWS Cognito.
💡
IT Intern, Service Management & Automation Team
Accelerated Career Track (ACT), Bank of Oklahoma (BOK) Financial (May 2018-May 2019)
🚨
ServiceNow Deployment Project
Assisted the team in a company-wide release of ServiceNow, a service management tool from the beginning of the process to the Go-Live Phase and beyond. Specifically, I assisted in the discovery & documentation of ServiceNow Configuration Management Database (CMDB), wrote scripts for ServiceNow notifications, and debugged/tested issues with the interface.
🚨
Battle of the Interns (2018)
The second project of the summer was part of the "Battle of the Interns," where a group of us IT interns proposed a solution and provided a demo to company executives. We created a digital recommendation dashboard to streamline prospecting new customers for the bank. In the process, I utilized SQL to explore the data and build visualization in R & PowerBI.
💡
IT Intern, Bank Data Warehouse & Salesforce Team
Accelerated Career Track (ACT), Bank of Oklahoma (BOK) Financial (May 2017-Aug 2018)
🚨
Regression Testing Project
Helped eliminate techinical debt by doing regression testing for Salesforce (in Apex language). I provided value by increasing the test cases passed from 75% to 93%.
🚨
Battle of the Interns (2017)
As part of the "Battle of the Interns" project", we interviewed several teams across the bank and gauged which teams needed a streamlined service management system. We wrote a 30-page white paper and presented our findings to company executives. The next year, the company implemented ServiceNow, and I was called back next summer to work continue the deployment work with the Service Management team.