Learn Data Skills

Hector Melendez

Certified

Senior Analyst (Data Analytics)

U.S. GAO

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Track

SQL Fundamentals

My New Course

Introduction to Python

From Raw Data to Insight: Proficiency in Python, SQL, R, Visualization, and AI

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to R

course

Introduction to Python

course

Introduction to SQL

My Certifications

These are the industry credentials that I’ve earned.

AI Fundamentals

AI Fundamentals

Data Literacy

Data Literacy

Other Certificates

SAS SAS Certified Associate: Programming Fundamentals Using SAS 9.4

SAS SAS Certified Specialist: Base Programming Using SAS 9.4

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to R
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

US Government Accountability Office | Jul 2022 - Present

Senior Data Analyst Forensic Audits Team $400B+ in potential FWA identified

• Uncovered and reported $400B+ in potential fraud, waste, and abuse through advanced analytics, driving stronger federal compliance and improving the effectiveness of internal controls. • Analyzed and integrated 1M+ record datasets from multiple sources to uncover insights that informed policy decisions and strengthened oversight effectiveness, identifying $31B+ in estimated improper payments. • Developed SAS, SQL, and Python code to automate the cleaning, testing, and validation of large, complex datasets from three of the largest agencies with combined budgets exceeding $1T, strengthening data reliability for statistical analysis and evidence-based reporting. • Integrated generative AI with traditional statistical tools (SAS, Python, R) to streamline analysis of structured and unstructured data, reducing manual effort by hundreds of hours annually and enabling faster, higher-quality insights for program evaluation. • Prepared reports, presentations, and visualizations to communicate findings and recommendations to management and other stakeholders. • Co-authored and contributed data analysis to federally published GAO reports, delivering evidence-based recommendations that strengthened compliance frameworks and improved data quality.
Show More

USDA | Mar 2020 - Jul 2022

Senior Data Analyst $160B+ food & nutrition programs oversight 99% timeliness improvement

• Coached and mentored cross-functional teams in data analytics and visualization, elevating technical proficiency, improving reporting accuracy, and fostering collaboration, which led to promotion as Lead Analyst for the Southwest Region. • Led regional analytics for 16 federally funded food and nutrition programs with budgets exceeding $160B to ensure effective program oversight and compliance, reducing payment error rates by 10% in the Southwest Region. • Streamlined data preparation and analysis workflows using SAS, SQL, Python, Excel/Power Query, Tableau, and ACL, saving approximately 5 days per report and accelerating the delivery of performance dashboards and visualizations for senior administrators and public stakeholders. • Automated monthly reporting processes using ACL scripting and Tableau, reducing production time by over 90% (from two weeks to under two hours) while improving consistency, accuracy, and operational efficiency.

U.S. Department of Labor | May 2012 - Mar 2020

Regulatory Compliance Manager Led 50+ compliance & 5 complaint reviews $7M+ back wages collected

• Core member of team that identified wage and hiring discrimination across federal contractors through statistical analysis, resulting in the recovery of over $7 million in back wages and interest and promoting equitable employment practices. • Automated wage data analysis and impact ratio assessments, enhancing the efficiency, accuracy, and consistency of compliance reporting workflows, which reduced audit completion time by an average of 3 - 4 days per audit. • Led data cleaning and preparation efforts for the district office, improving data quality and enabling timely, reliable reporting for compliance evaluations, cutting preparation time by almost 2 weeks per audit. • Streamlined construction review audits by automating data entry, analysis, and reporting tasks, reducing manual workload, and improving process accuracy and turnaround time by approximately 30 days per audit. • Trained peers on interpreting analytical outputs and generating compliance reports, strengthening team capacity, data literacy, and a culture of continuous improvement. • Conducted and completed 5 in-depth investigations into discrimination complaints by analyzing personnel datasets and organizational policies, producing detailed evidence-based reports ensuring timely resolution and full compliance with federal requirements within the mandated 180-day time period.

Law Offices of Stephen H Artman | Apr 2010 - May 2012

Intern for Private Practice Practice handled criminal defense, wills, trusts, contracts, and more

Awarded Honors for Legal Research and Writing and Appellate Advocacy in Law School

10th Judicial District Attorney | Aug 2009 - Apr 2010

Certified Legal Intern for the State Attorney

Managed 300+ misdemeanor caseload Prosecuted jury and non-jury trials, handled plea negotiations, and conducted depositions

ACCURATE SURGICAL & SCIENTIFIC INSTRUMENTS | Jan 2006 - Sep 2006

Florida Sales Manager $1M+ in annual sales Sold premium micro and plastic surgery instruments

I independently marketed and sold premium surgical equipment to hospitals, surgery centers, and medical offices across Florida increasing total sales by 100% in under 6 months. Led annual sales growth to $1M+ Doubled total territory sales in the first 6 months Exceeded sales goals by an average of 50% for 9 consecutive months

Micrins Surgical, Inc. / Renaissance Surgical, Inc. | Aug 2004 - Jan 2006

Southeast Regional Territory Manager B2B Marketing and Sales to hospitals $1M+ annual sales

Directly marketed and sold premium micro-surgery and plastic surgery instruments to surgeons, hospitals, and surgery centers throughout Alabama, Florida, and Georgia. Led all sales managers in total annual sales ($1M+) Awarded Rookie of the Year in total sales Averaged $5K+ in direct sales representing the company at medical trade shows and conferences

Pfizer | Apr 2002 - Apr 2003

Territory Sales Manager | Pharmaceutical Products

Oversaw the strategic presentation and marketing of Pfizer's $10B+ portfolio, ensuring alignment with business objectives and market demands. Drove sales growth over 100% for key blockbuster products Lipitor, Norvasc, Viagra, and Zyrtec Southeast Regional Performance Fund 2002 Award for “Teamwork Resulting in Performance”

US Army | May 1997 - May 2002

U.S. Army

As Maintenance and HQ Platoon Leader, supervised and trained 68+ individuals Maintained $250M+ worth of equipment (Launcher/Radar/ECS/Launchers/ Generators) Improved equipment operational readiness rate from 85% to 98% As HQ and Battery Executive Officer, planned and coordinated training, and managed supply and logistics for 138+ individuals As Battalion S-1, maintained personnel accountability of unit (650+ individuals) Air Assault School 1995 Deployed to SWA during Operation Desert Fox in 1998 Provided Air Defense support as part of the 108th ADA Brigade for XVIII Airborne Corps Combat Warfighters at Fort Bragg, North Carolina

My Education

Take a look at my formal education

Nanodegree, SQLUdacity | 2020
Nanodegree, Business AnalyticsUdacity | 2020
Juris Doctor, LawUniversity of Florida - Fredric G. Levin College of Law | 2009
Bachelor of Science, Computer ScienceUnited States Military Academy at West Point | 1997

About Me

Hector hasn't filled in a bio text

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free