Oct 2024 – Mar 2025 · 5 mos · New York City Metropolitan Area · Remote

Feb 2023 – May 2024 · 1 yr 3 mos · Remote

• Implemented and productionalized 12 health insurance client member data warehouses in our PostgreSQL and SQL Server environments, which involved creating a unique data integration template with SQL script, loading and quality assessing the member information, benefit plans, and member accumulations, and publishing the data to the production environment
• Designed and developed 3 programs that provided new opportunities to our team, including a Python script EDI 834 ETL processor to allow for clients to send us files in EDI format, a Jenkins automation job in Shell Script that transferred our files from our AWS S3 data lake SFTP to our Jenkins box for processing, and a Jenkins automation job in Groovy that filtered the client’s latest uploaded SFTP file
• Adjusted and enhanced 9 programs within our team’s system, including improving our generic client data integration template in SQL script, adding a reset check with Python to our Jenkins output when it would detect duplicate member records during the ETL process, remodeling various Jenkins jobs’ Groovy scripts to run more efficiently, and other internal improvements
• Remodeled a client’s SQL script data integration template and Jenkins Groovy automation flow in 33 different instances by either repairing the template and flow following a file modification or a system failure or modernizing older templates and flows to match our current standards
• Executed and quality checked 54 urgent and unplanned ETL file loads to the client data PostgreSQL or SQL Server warehouses, for reasons such as clients sending in new test files, clients missing their automation schedule, etc.
• Generated 10 SFTP user profiles in our AWS S3 data lake environment using ssh public keys, and established myself as go-to for Data Governance due to my efficiency
• Conducted 38 GitHub pull request QA reviews to provide my teammates feedback on their implementations/updates, point out any missing elements in the code, and merge the branch

Nov 2021 – Nov 2022 · 1 yr · Louisville, Colorado, United States

• Built PL/SQL stored procedures in Amazon Redshift to create ETL pipelines for tables used by the UI/API teams in BI reports
• Refined existing PL/SQL stored procedures and tables within the Redshift warehouse to fulfill enhancements requested by customers and to assist in my team’s single-source-of-truth efforts
• Deployed a serverless Dash Plotly dashboard using AWS Lambda and API Gateway that displayed QA automated tests results
• Taught Python fundamentals to the Quality Analysis team to assist in the integration of automated QA testing

Aug 2021 – Dec 2021 · 4 mos · Boulder, Colorado, United States

• Taught the fundamentals of the Python language during the first half of the semester
• Introduced Pandas, NumPy, and Matplotlib to assign a business analytics report for the final project
• Hosted office hours to offer additional assistance outside of the lecture time
• Lectured one section of 46 business school undergraduate students

Dec 2020 – Feb 2021 · 2 mos · Boulder, Colorado, United States (Remote)

• Constructed a Google Apps Script function with Javascript that searched through Infoblox customer information to determine if a partner provided company was a new opportunity
• Automated a process that would typically take each of the 20 national channel account managers 10+ hours a week and increased the accuracy of the returned values
• Wrote 179 lines of code that returned seven values for each row; including four values gathered from other spreadsheets and three conditionals
• Learned Javascript to write the function in Google Apps Script connected to the team’s Google Sheets file

Aug 2019 – Dec 2019 · 4 mos · New Orleans, Louisiana, United States

• Hosted office hours two times a week for three hours to assist any students that showed up in solving assignments and preparing for tests
• Raised one student's grade who continuously came to see me from a failing midterm grade to a B final grade

Jun 2019 – Jul 2019 · 1 mo · Los Angeles, California

• Updated 604 class A/B building stacking plans in SiteSolutions to create database that will help brokers more easily communicate offerings to clients with 4 other interns
• Canvassed 575 buildings in LA West & LA Central submarkets, taking 3,500 total building photos
• Updated and confirmed 1,630 SiteSolutions fields for buildings including amenities, ownership, property manager, floor count, floor size, parking ratio
• Added 1,100 missing SIC codes into the SiteSolutions database

Feb 2019 – Mar 2020 · 1 yr 1 mo · New Orleans, Louisiana, United States

• Budgeted donation money and negotiated deals with local venues for our events
• Assisted in crediting the organization as an official non-profit

Jun 2018 – Aug 2018 · 2 mos · Los Angeles Metropolitan Area

• Researched and compiled information regarding 20-30 policies using Excel to present to clients, allowing the client to make a more informed decision
• Revamped method of storing 500+ client case files, increasing organization and accessibility for the agents
• Simplified detailed policy information and benefit information for clients, providing the client with a more easily understood summary

Jul 2017 – Aug 2017 · 1 mo · Los Angeles Metropolitan Area

• Collected and analyzed data about upcoming films and series, examined potential merchandising and licensing deals
• Tested 40-50 newly developed or improved PowerA products, determined that half were ready for sale and made recommendations for improvement
• Participated in product innovation and merchandising/licensing deals brainstorming sessions with 4-person team, led to more concrete plans and timelines

Jun 2015 – Jul 2015 · 1 mo · Shanghai, China

• Edited 10-15 investor reports, confirming proper translation from Mandarin to English
• Surveyed several potential building sites, assisted acquisition team with recording traffic volume and photographs
• Created a database of 100+ acquired properties, providing the investors with an easy way to rank properties based on quality, price, and other metrics