Andrew Stafford
Support Engineer at Happy Cabbage Analytics- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Okta Certified Professional
OktaNov, 2021- Sep, 2024
Experience
-
Happy Cabbage Analytics
-
United States
-
Software Development
-
1 - 100 Employee
-
Support Engineer
-
Jan 2022 - Present
Managed and prioritized technical support team issues from customers R API Shiny Github Bug fixes SQL Pipeline development Technical/Customer Support HubSpot Managed and prioritized technical support team issues from customers R API Shiny Github Bug fixes SQL Pipeline development Technical/Customer Support HubSpot
-
-
-
Envestnet, Inc
-
United States
-
Financial Services
-
700 & Above Employee
-
Production Support Engineer
-
Sep 2021 - Dec 2021
-Handling application alarms -Python -Selenium -Handling application alarms -Python -Selenium
-
-
-
Syapse
-
United States
-
Biotechnology Research
-
100 - 200 Employee
-
Clinical Data Analyst
-
Jul 2019 - Sep 2021
R scripting using: -Shiny-RMarkdown-SQL
-
-
Data Support Engineer
-
May 2019 - Jul 2019
- Used SQL, PSQL, and Redshift across multiple databases to ensure data completeness and provide useful information to clients- Created reports using R scripts and RMarkdown in RStudio to provide useful insights into the databases for clients.- Used terminal commands (Bash) to move files between secure environments- On-Call 24/7 to respond to critical customer facing issues.R scripting for clinical analytics -Shiny-RMarkdown-SQL
-
-
-
Mitchell Martin Inc.
-
United States
-
Staffing and Recruiting
-
300 - 400 Employee
-
Data Support Engineer
-
Feb 2019 - May 2019
Contractor working at Syapse • Used SQL, PSQL, and Redshift across multiple databases and Kubernetes to ensure data completeness and provide useful information to clients • Created reports using R scripts and RMarkdown in RStudio to provide useful insights into the databases for clients. • Used terminal commands (Bash) to move files between secure environments • On-Call 24/7 to respond to critical customer facing issues. Contractor working at Syapse • Used SQL, PSQL, and Redshift across multiple databases and Kubernetes to ensure data completeness and provide useful information to clients • Created reports using R scripts and RMarkdown in RStudio to provide useful insights into the databases for clients. • Used terminal commands (Bash) to move files between secure environments • On-Call 24/7 to respond to critical customer facing issues.
-
-
-
SEI
-
China
-
Industrial Machinery Manufacturing
-
Specialist - Production Support
-
Nov 2017 - Feb 2019
• Created SQL Queries to view and update databases using SELECT, UPDATE, INSERT, and JOIN statements• Slashed process time from 10+ minutes to seconds while removing chances for user error using SQL automation scripts I created• Work with account managers to resolve client issues they are facing in timely manner• Create workflow processes to improve efficiency of user administration tasks and streamline information for audit requirements• Took on extra projects and learned other teams systems in depth to broaden my experience and knowledge• Collaborated with Business Analysts and approved/validated production level technology changes o Overhauled current platform issues and advised on improvements.• User Administration for more than ten different applications• Troubleshoot issues that users encounter and escalate to appropriate teams after due diligence Show less
-
-
Operations Analyst II - Institutional Transfers Agency
-
Mar 2017 - Nov 2017
• Increased responsibility from Analyst I to include training of new hires on my team• Took initiative by looking for new projects and sat in on coworkers everyday duties to assess how to cut down on overall work• Heavily used VBA to work between excel and other applications to increase automation and minimize human errors• Primary source of all Microsoft access reports for team due to my understanding of how SELECT and JOIN statements are used
-
-
Operations Analyst I - Institutional Transfers Agency
-
Apr 2016 - Mar 2017
• Place and assist with trades, trade issues and account inquiries made by phone • Open and update institutional accounts (i.e. mutual funds, money markets & CIT funds)• Place redemptions, purchases, exchanges and transfers from email and fax instructions
-
-
-
-
Operations Analyst I - Institutional Transfers Agency (Contract)
-
Dec 2015 - Apr 2016
• Place and assist with trades, trade issues and account inquiries made by phone • Open and update institutional accounts (i.e. mutual funds, money markets & CIT funds) • Place redemptions, purchases, exchanges and transfers from email and fax instructions • Place and assist with trades, trade issues and account inquiries made by phone • Open and update institutional accounts (i.e. mutual funds, money markets & CIT funds) • Place redemptions, purchases, exchanges and transfers from email and fax instructions
-
-
-
-
Financial Processing Associate (Contract)
-
Sep 2015 - Dec 2015
• Processed new and existing client paperwork and checks • Verified all documentation was in accordance with FINRA, the SEC, and Vanguard • Processed new and existing client paperwork and checks • Verified all documentation was in accordance with FINRA, the SEC, and Vanguard
-
-
-
Cafe 210 West
-
United States
-
Consumer Services
-
1 - 100 Employee
-
Doorman - Part-Time
-
May 2013 - May 2015
• Check ID and monitor client behavior in accordance with LCB regulation • Assist restaurant staff • Check ID and monitor client behavior in accordance with LCB regulation • Assist restaurant staff
-
-
-
United States Department of Defense
-
Armed Forces
-
1 - 100 Employee
-
Human Resources Summer Intern
-
May 2014 - Aug 2014
• Held Top Secret Security Clearance • Completed verification of employment requests • Processed new hire personnel actions into the Human Resources management system • Performed and completed an audit on over 400 employee official personnel folder (OPF) • Created new hire files with correct paperwork in the proper order • Assisted in benchmarking with other federal agencies on their electronic personnel file project • Prepared retired employee's official personnel folders for transfer to the National Personnel Records Center • Utilized the Microsoft Office Access OPF tracker tool to track personnel folders to various locations • Assisted employees with performance management tool issues • Educated on large government project budget process o Familiarized with the steps needed to approach a large scale project o Attended strategy meeting for funding of the project Show less
-
-
-
-
Intern
-
Jun 2012 - Aug 2012
• Reviewed and rated resumes, searching for specific criteria required by client • Scheduled phone interviews for candidates that had already applied online • Called and encouraged qualified candidates to apply for positions online • Researched and analyzed hundreds of available internet-based Job Posting and Resume Mining resources and reported on their features using Excel • Reviewed and rated resumes, searching for specific criteria required by client • Scheduled phone interviews for candidates that had already applied online • Called and encouraged qualified candidates to apply for positions online • Researched and analyzed hundreds of available internet-based Job Posting and Resume Mining resources and reported on their features using Excel
-
-
-
-
Intern
-
Jun 2010 - Aug 2010
-
-
Education
-
2018 - 2019
Penn State Great Valley
Lean Six Sigma -
2016 - 2017
Penn State University
Master of Science (M.S.), Information Science -
2011 - 2015
Penn State University
Bachelor of Science (B.S.), Dual Major: Labor & Employment Relations & Criminology (Business Option)
Community
