Data Analyst Quality Assurance
Resume:
Philip O. Stewart
******.*.*******@*****.***
Summary
Accomplished Senior Database Engineer and Data Analyst with over 15 plus years of comprehensive experience in the software development lifecycle (SDLC), specializing in high-security government environments. Demonstrated expertise in delivering end-to-end database solutions, ensuring data integrity, and managing backup and recovery processes to guarantee 24/7 availability for mission-critical applications. Proven ability to design and implement robust databases, conduct extensive quality assurance, and develop analytics tools. Adept in agile development practices, automated testing, data transformation, and performance tuning, I excel in dynamic project environments, showcasing a unique blend of technical expertise and commitment to data quality and system resilience.
Education
B.S. in Computer Science and Information Systems
Shepherd University, 2004
Technical Skills
Cloud & DNS Services: AWS (Route 53, KMS, SES, EC2), Cloudflare, Azure Databricks
Databases: Sybase ASE, MS Access, Azure Databricks
Servers: Tomcat, Apache, SUN One Webservers
Analytics & Data Transformation Tools: Spark Data Frame API, Tableau, Tableau Prep, Trifacta
Agile Tools: Jira for Agile lifecycle development
Database Management: SQL performance tuning for big data, normalized/denormalized entity-relationship models, 24/7 high availability and failover practices with database anonymous replication
Python Libraries: Pandas, Matplotlib, NumPy
Operating Systems: UNIX, Windows 10/Server, Mac OS X, Sun Solaris
Programming Languages: Python, SQL, Bash, VBA, JavaScript
Professional Experience
Megadon Solutions, LLC
Principal Consultant 2024 – Present
Responsible for establishing and securing cloud infrastructure, managing DNS and email systems, and implementing compliance standards for government clients.
AWS Cloud Infrastructure: Set up cloud hosting for public websites with Route 53 and EC2, adhering to federal security standards and configuring IAM roles for secure resource management.
DNS Security: Implemented DNSSEC for megadonsolutions.com with custom KMS keys, using specific policies for signing and verification to ensure secure, compliant domain management.
Email Security: Deployed Amazon SES with DKIM, a custom MAIL FROM domain, and DMARC records, enhancing email authentication and phishing protection.
Network Access Controls: Configured secure SSH access to EC2 instances, restricting access to specific IPs to protect against unauthorized entry.
DoD, TEKSystems
Data Analyst Oct 2022 - May 2023
Developed Spark applications in Databricks for data ETL and aggregation.
Automated SQL scripts and improved data management through Azure Data Storage.
Navy, Spalding Consulting, Inc.
Senior Data Analyst May 2019 - Aug 2022
Designed dashboards and reports using Tableau Prep and Tableau.
Conducted data transformation and ETL processes for Naval Air Manpower metrics.
Documented SOPs and maintained NAVAIR databases for data readiness.
Department of Transportation, Quantum Vision, Inc.
SQL Developer Apr 2017 - May 2019
Performed SQL tuning, ETL, and database design for data warehouse projects using Sybase and Oracle.
NASA, ASRC Federal Aerospace
Database Engineer Aug 2011 - Apr 2017
Maintained and improved mission-critical databases for EOS Command and Telemetry.
Documented and supported mission data needs and presented deliverables to the engineering team.
DoD, HP Enterprise Services
Database Administrator Mar 2008 – Aug 2011
Managed 24/7 database support, ensuring high availability through backup and recovery.
Reduced outage times by implementing automated backups and disk usage monitoring.
Configured Sybase replication and led optimization for production environments.
Department of State, American Systems Inc.
Quality Analyst/Developer Apr 2007 – Mar 2008
Created use cases and automated test scripts with QTP and VBScript for quality assurance.
Developed regression scripts to ensure application reliability for PeopleSoft GIMs.
Contributed to automation strategy and QA documentation for State Department projects.
Contact this candidate