Andy Doan
Summary
Experienced DevOps and data engineer with over a decade of expertise in delivering solutions with load balancing, horizontal scalability, high availability, microservice architecture, and a strong emphasis on robust security measures. Proficient in optimizing query performance, data analysis, data migration, ETL workflows, and enterprise data warehousing. Skilled in migrating applications and databases to Amazon Web Services and Microsoft Azure. Distinguished career with notable roles at Amazon Web Services, Humana, and AAA, supported by a computer science degree and 9 technical certifications, including AWS's, Azure's, MongoDB's and MS SQL Server.
Overview
22
22
years of professional experience
4
4
years of post-secondary education
Work History
DevOps Engineer and MongoDB Administrator
Humana
10.2019 - Current
- Oversaw a scalable cloud-based system utilizing the MEAN stack (MongoDB, Express.js, Angular.js, Node.js) in conjunction with AWS services (EC2, S3, ELB, VPC, Direct Connect, Private Endpoints, CloudWatch), accommodating up to 150,000 concurrent users during peak periods
- Leveraged Agile methodologies using Azure DevOps services; managed source code with Azure Repos, streamlined CI/CD with Azure Pipelines, and team collaboration on project backlogs through Azure Boards
- Successfully orchestrated the migration of a terabyte-scale MongoDB database from an on-premises setup to MongoDB Atlas, enhancing scalability and reducing operational costs by 50%
- Design and optimize the system's database schema, focusing on data integrity and performance tuning
- Optimize numerous queries, achieving execution time reductions from minutes to milliseconds
- Ensure high availability, scalability, and security of the system, monitoring performance and promptly resolving issues using tools such as Dynatrace, AWS CloudWatch, Atlas Metrics
- Develop custom DB shell scripts for task automation and enhanced database management efficiency
- Collaborate closely with the development team to ensure smooth system operation and rapid issue resolution.
Cloud Support Engineer
Amazon Web Services, AWS
05.2017 - 10.2019
- Acted as the 'Cloud Ambassador' for all AWS cloud products, equipping customers with tools and tactics to maximize product and support investments
- Investigated root causes of issues, analyzed trending metrics, and collaborated with Amazon engineers to automate operational challenges
- Specialized in Databases and Analytics, providing in-depth support for Amazon Aurora, MySQL, Microsoft SQL, Oracle, PostgreSQL, MariaDB, Database Migration Services, Redshift, and Elastic Search, Athena, Kinesis and Kafka
- Communicated with customers via email, chat, and phone to deliver prompt and effective support, resolving issues quickly and accurately
- Received the 100 Five-Stars Award for achieving the first 100 five-star ratings from supported customers.
Data Engineer
LifeSync Behavioral Health
03.2013 - 05.2017
- Designed and implemented data warehouse solutions, ETL processes, and reconciliation processes, resulting in improved data accuracy and analysis capabilities
- Demonstrated expertise in Microsoft SQL Server, TSQL, SSIS, SSRS, Informatica PowerCenter, Oracle, PL/SQL, Tableau, and Qlikview
- Leveraged a deep understanding of data warehousing concepts, data modeling, and data integration technologies to deliver effective solutions
- Created reports and visualizations to communicate findings and support data-driven decision-making.
Senior Software Developer
MindEcology
12.2008 - 03.2013
- Led the design and development of dynamic landing pages, significantly boosting the efficacy of marketing and advertising campaigns for various companies and organizations
- Leveraged expertise in a diverse technology stack, including C#, ASP.NET, IIS, HTML, SOAP, XML, PHP, QuickBooks SDK, and Active PDF SDK
- Successfully executed the creation of hundreds of dynamic landing pages, fostering increased revenue and bolstering customer trust in the brand.
Software Developer
American Automobile Association, AAA
06.2007 - 11.2008
- Managed and enhanced multiple complex internal databases for business analysis and intelligence applications, serving thousands of users across various departments
- Transformed data from production (DB2) to data warehouses (MS SQL Server), optimizing database performance and ensuring data quality
- Collaborated with developers and DBAs to identify and resolve performance issues, ensuring data availability for business analysis
- Leveraged expertise in MS SQL Server, TSQL, SSIS, SSRS
- Recognized for contributions with the Employee of the Month award.
Software Developer
Orbit Technology
09.2001 - 06.2007
- Developed and maintained a web-based Metal Fabrication scheduler and automation software, tailoring features for clients and managing both on-site installation and continuous customer support
- Demonstrated expertise in a wide range of technologies, including C++, C#, ASP.NET, VB.NET, IIS, MS SQL, MySQL, COM, DCOM, XML, SOAP, RFID, OPC
Education
Bachelor of Applied Science (B.A.Sc - Computer Science
California Polytechnic State University
01.1997 - 01.2001
Microsoft Certified Solutions Expert: Data Platform. - Microsoft E901-5125 PowerCenter Data Integration Developer Specialist - Informatica 041-000867 AWS Certified Developer - Associate - Amazon Web Services (AWS) AWS-ADEV-8034 Azure Fundamentals - Microsoft 989992642 MongoDB Certified DBA Associate (C100DBA) - MongoDB 454719347 MongoDB Certified Developer, Associate (C100DEV) - MongoDB 477736943 Certified SAFe 5 Agilist - Scaled Agile, Inc. 31212432-3811 Microsoft Certified Professional - Microsoft E395-6045 Microsoft Certified Solutions Associate: SQL Server 2012. - Microsoft E757 - undefined
Skills
TECHNICAL EXPERTISEundefined
Timeline
DevOps Engineer and MongoDB Administrator
Humana
10.2019 - Current
Cloud Support Engineer
Amazon Web Services, AWS
05.2017 - 10.2019
Data Engineer
LifeSync Behavioral Health
03.2013 - 05.2017
Senior Software Developer
MindEcology
12.2008 - 03.2013
Software Developer
American Automobile Association, AAA
06.2007 - 11.2008
Software Developer
Orbit Technology
09.2001 - 06.2007
Bachelor of Applied Science (B.A.Sc - Computer Science
California Polytechnic State University
01.1997 - 01.2001
Microsoft Certified Solutions Expert: Data Platform. - Microsoft E901-5125 PowerCenter Data Integration Developer Specialist - Informatica 041-000867 AWS Certified Developer - Associate - Amazon Web Services (AWS) AWS-ADEV-8034 Azure Fundamentals - Microsoft 989992642 MongoDB Certified DBA Associate (C100DBA) - MongoDB 454719347 MongoDB Certified Developer, Associate (C100DEV) - MongoDB 477736943 Certified SAFe 5 Agilist - Scaled Agile, Inc. 31212432-3811 Microsoft Certified Professional - Microsoft E395-6045 Microsoft Certified Solutions Associate: SQL Server 2012. - Microsoft E757 - undefined
Similar Profiles
Monifah CocroftMonifah Cocroft
Healthcare Customer Service Representative at HumanaHealthcare Customer Service Representative at Humana
Cher Ann ChaputCher Ann Chaput
Care Management Support Supervisor at HumanaCare Management Support Supervisor at Humana
SALAE JENKINSSALAE JENKINS
Health Educator at HumanaHealth Educator at Humana
Kevin RossKevin Ross
Grievance and Appeals Resolution Specialist III at HUMANAGrievance and Appeals Resolution Specialist III at HUMANA
Swetha RachamallaSwetha Rachamalla
Database Administrator - PostgreSql, MongoDB at SquadlockerDatabase Administrator - PostgreSql, MongoDB at Squadlocker