Senior SQL & BI Data Analyst

Robert Scott Leitch

Email: ********@*****.*** Phone: 210-***-**** linkedin.com/in/robert-leitch-42224a8

Veteran’s Preference: Eligible U.S. Citizen Active Secret Clearance Public Trust Eligible

Summary

Senior Data Analyst and Business Intelligence professional with 12+ years of experience delivering enterprise data analytics, reporting automation, dashboards, data integration, and decision-support solutions across Department of Defense, banking, healthcare, telecommunications, and energy environments. More than five years supporting DoD and U.S. Air Force data operations and reporting modernization. Advanced experience with SQL, Python, Tableau, Power BI, SAS, Oracle, SQL Server, Teradata, Snowflake, AWS, Cognos, and enterprise data warehouses. Proven ability to automate recurring reporting, translate complex business requirements into technical solutions, develop executive-level KPI dashboards, validate large datasets, integrate APIs, and support Agile/DevOps delivery. Experienced partnering with business leaders, product owners, data engineers, and technical teams throughout requirements gathering, development, UAT, production readiness, and release support.

Skills

Data Analytics

Business Intelligence (BI)

SQL Development, Advanced SQL

Python Automation scripting

Tableau

Microsoft Power BI

Data Visualization & Dashboard Development

ETL & Data Integration, Data Cleansing/Mining

Data Warehousing

Oracle / PL/SQL

SAS Analytics

Data Governance & Data Quality

Business Requirements Analysis

User Acceptance Testing (UAT)

Agile / SAFe / SDLC Restful API

Experience

IPTA JBSA Randolph AFB, Texas

Data Analyst April 2025 – Present 40 hours/week

Supervisor: Available upon request May Contact

Develop quantitative data visualizations and executive reporting for Air Force Personnel Center leadership, providing visibility into critical management statistics, operational metrics, and personnel information through STARS/RAW.

Automated 10–15 recurring reports using Python, reducing manual reporting workload by approximately 15–20 hours per week while improving repeatability and efficiency.

Develop Python and Java-based automation tools and advanced Excel solutions supporting STARS/RAW and DEMOG datasets and enterprise reporting through Cognos, Power BI, Tableau, and AWS.

Use Python libraries including Pandas and NumPy to manipulate, preprocess, validate, and analyze large operational datasets.

Develop SQL scripts, SAS datasets, test scripts, technical requirements, and reporting solutions including Tableau dashboards, reports, supporting data extraction, transformation, validation, and analysis.

Integrate and validate data from multiple sources using REST APIs, Postman, Python, and enterprise data systems.

Lead discovery and requirements sessions with stakeholders, translating business needs into technical requirements, KPIs, dashboards, data flows, and reporting solutions.

Support UAT, production readiness, release activities, data validation, process mapping, and troubleshooting across business intelligence initiatives.

Author and maintain SOPs for automated reporting processes and collaborate with business users, product owners, and data engineering teams to implement reporting and process improvements.

Quadrant Inc. / Robbins Gioia Remote

Business Intelligence Reports Developer January 2023 – April 2025 40 hours/week

Supervisor: Available upon request May Contact

Developed business intelligence dashboards, reports, and quantitative visualizations enabling MRO leadership to monitor operational statistics, KPIs, and performance through Optics MRO.

Developed Python, Oracle SQL, and PL/SQL solutions supporting data extraction, transformation, cleansing, reconciliation, preprocessing, validation, and automated report generation.

Integrated enterprise data from databases, REST APIs, JSON sources, and cloud platforms using Python, Postman, Oracle, and SQL.

Designed and maintained interactive Tableau dashboards aligned with stakeholder requirements, emphasizing usability, performance, scalability, and actionable business insights.

Translated business requirements into optimized SQL queries and Python workflows for extracting, transforming, analyzing, and validating large datasets.

Developed BI charts and user interfaces using Angular, HTML, CSS, JavaScript, Java, JSON, Google Charts, PrimeNG, Adobe Analytics, Tableau, Cognos, and Power BI.

Used Git, Git Bash, Linux scripting, and VS Code for source control and management of Python, SQL, PL/SQL, Angular, Tableau, and Power BI development assets.

Collaborated with business stakeholders, analysts, product owners, and data engineers to define KPIs, perform UAT, troubleshoot reporting issues, and support production releases.

Produced documentation, user guides, and operational procedures and provided user support and training for Tableau dashboards and enterprise reporting solutions.

Designed reliable CI/CD pipelines and infrastructure-as-code solutions to support complex defense maintenance systems, improving operational readiness and rapid response capabilities in field environments.

Collaborated on integration of enterprise logistics and maintenance platforms, enhancing data flow and diagnostics for sustainment operations.

Marathon Petroleum IT / HESS – Compri Consulting San Antonio, Texas

Business Analyst May 2022 – December 2022 40 hours/week

Supervisor: Available upon request May Contact

Supported a three-person SAFe/Agile team responsible for business application configuration, user-story refinement, testing, UAT, production validation, and solution delivery.

Developed SQL queries, VBA macros, advanced Excel solutions, BI dashboards, and reports using Oracle, SQL Server, Tableau, Power BI/DAX, Cognos, Adobe Analytics, and Oracle Cloud.

Updated ETL AutoSys jobs, JSON packages, Oracle APEX components, SQL Server solutions, and SSIS packages supporting data refreshes for Geotab, OIS, LeakDAS, and related applications.

Served as primary support for the Intelex ACTS solution used to report greenhouse gas emissions and emissions inventories, including configuration, enhancements, data managers, import templates, and associated jobs.

Supported incident, change, problem, and SDLC processes while coordinating requirements and cross-functional impacts among business stakeholders, third parties, and internal IT organizations.

Maintained refinery SQL Server databases and supported SSRS/Excel reporting, data integration, migration, retention, process documentation, and operational reporting improvements.

USAA Federal Savings Bank – Millennium Group San Antonio, Texas

Business Analyst / Business Intelligence Developer January 2020 – April 2022 40 hours/week

Supervisor: Available upon request May Contact

Supported Consumer Lending analytics, SAS development, testing, data management, and enterprise reporting initiatives.

Developed SQL scripts, procedures, VBA macros, advanced Excel automation, and SAS Enterprise Guide solutions supporting reports, dashboards, data validation, and analytical projects.

Built and tested reporting solutions using Tableau, Snowflake Cloud Data Warehouse, IBM Netezza, Hadoop, Salesforce, and SAS.

Analyzed business requirements, developed Tableau visualizations and workbooks, and performed quality assurance and data validation across large financial datasets.

Applied advanced SQL programming, data modeling, relational databases, ETL, query optimization, and performance-tuning techniques to business intelligence initiatives.

Supported KPI reporting, data flows, UAT, production readiness, documentation, data integration, migration, and stakeholder requirements.

KeAki Technologies – U.S. Air Force Population Health JBSA Lackland AFB, Texas

SQL Developer January 2018 – March 2020 40 hours/week

Supervisor: Available upon request May Contact

Developed SQL procedures, dashboards, visualizations, and reports analyzing healthcare expenditures and population data for Air Force military personnel, retirees, civilians, spouses, and dependents.

Developed automated SQL and Unix/Windows scripts using Teradata, Oracle, PL/SQL, SQL Server, SAS, Tableau, Cognos, Power BI/DAX, and Excel.

Built and maintained data warehouse reporting solutions using Informatica ETL, SSIS, SSRS, Oracle APEX, clustered/non-clustered indexes, and enterprise SQL technologies.

Provided data publishing, dashboard, and reporting support to Department of Homeland Security customers, including the U.S. Navy and U.S. Army.

Additional Data & Business Intelligence Experience

USAA – Strategic Staffing Solutions San Antonio, Texas

Business Analyst / Business Intelligence Developer, Distributed Data Analytics May 2017 – December 2017 40 hours/week

Supervisor: Available upon request May Contact

Developed SQL and SAS reporting solutions, Tableau dashboards, Excel analytics, trend analysis, and forecasting for Member Service Representative data; validated reporting against Salesforce and presented analytical information supporting upper-management decision-making.

UDP San Antonio, Texas

SQL Developer / Data Warehouse & Reports Developer January 2016 – April 2017 40 hours/week

Supervisor: Available upon request May Contact

Developed SQL, Python, JavaScript, Java, and Linux solutions; created SSIS packages, SSRS and Tableau dashboards, and enterprise data warehouses; tested and deployed MySQL-to-SQL Server data migrations and customer reporting solutions.

Amdocs / AT&T Mobility Richardson, Texas

Reports Developer / Data Analyst January 2015 – December 2015 40 hours/week

Supervisor: Available upon request May Contact

Developed Oracle SQL, Python, Linux, and Unix automation supporting wireless data; created Tableau and Excel dashboards, metrics, and reports using Business Objects, Oracle BI Publisher, and SSRS.

Sprint Information Technology Group Overland Park, Kansas

SQL Developer / Data Analyst / Business Analyst March 2012 – December 2014 40 hours/week

Supervisor: Available upon request May Contact

Automated extraction and delivery of Customer Care data from Oracle and Teradata environments; developed executive reporting, dashboards, data mappings, governance and quality solutions, SSIS packages, forecasting reports, and automated Teradata export processes.

Education

Master of Business Administration – Business Administration / Computer Systems Management University of West Alabama Livingston, Alabama

Bachelor of Science – Business Administration / Computer Systems Management Magna Cum Laude University of West Alabama Livingston, Alabama

Contact this candidate