Robert Scott Leitch

Seguin, Texas *****

210-***-**** adymq1@r.postjobfree.com

Experience summary

Technology, Data, Application Support, Requirements, Analysis, Data Governance, Data Quality, Business Analytics and Business Intelligence, Dashboards. Functional, Regression Software Testing, Requirements, Statistical/Business, Metrics, and Security Analysis. Applications building spreadsheets, graphs for metrics, and statistical analysis in identifying company level performance indicators, Defining, developing and writing test plans and cases, Ability to communicate both orally and in writing, Experience developing web applications, automation test tools, Relational database management systems, ETL development, Data Warehouses, SQL scripting, Data Analysis and Report development, Manual and automation testing web applications, desktop applications, Troubleshooting applications and data. Also working in collaboration with stakeholders and others in customer support of projects, requirements and assignments related to IT.

MILITARY

United States Navy/Marine Corps (Active Duty), O-2/3 (Reserves) Communications/Weapons Officer, Honorable Discharge

Deployments: Desert Storm, Operation Iraqi Freedom awarded Distinguished Service Medal and other honors.

Education

University of West Alabama – Magna Cum Laude Livingston, AL

Bachelor of Science in Business Administration in Computer Systems Management

Certifications & Training

Oracle 8i, 9i, 10g Developer and Discoverer Admin Series Training

Informix 7

MCSE 2009

CompTIA Security+ 2012

Technical Skills & expertise

DATABASES

Oracle Client versions 7,8i,9i,10g and 11g, Teradata Client version 13, Microsoft SQL Server versions 2005, 2008 R2, 2012, 2016, MySQL, Sybase SQL Anywhere, Informix, Microsoft Access, Microsoft Active Directory, IBM Netezza. Snowflake Cloud DW.

ADVAnced SQL DEVelopment

Oracle PL/SQL, Oracle E Business Suite, Functions, Views/Tables, Procedures, Triggers, SSIS, SSRS, T-SQL.

Operating systems

HP UX, IBM AIX, Solaris, Linux, UNIX, Windows Advanced Server, Windows 3.1/ 95/98/2000/XP/Vista/Windows 7/10.

SCRIPTING

XML, HTML, Teradata Fast Load & Fast Export, Unix Shell, Python, Windows scripts, Oracle SQL, Oracle PL/SQL, MS SQL Server T-Sql, Stored Procedures, SAS, VBA, Control M automation.

Hardware

Sun SPARC Solaris, HP L1000, HP 9000.

VERSIONIng

CVS, Serena PVCS, Microsoft Source Safe, TFS, Subversion, Clear Quest, DOORS, Documentum, Jira, Confluence.

EXTRACT, TRANSFORM & LOAD

Informatica PowerCenter v 8.5/9, Microsoft SSIS packages.

Business Intelligence/CRM

OLAP, Data Mining, Process Mining, Business Performance Management, Digital Dashboards, Oracle BI suite v10.1, Oracle E Business Suite 11i and 12i, Seibel.

REPORT development Tools

Cognos 11/Impromptu, Oracle Discoverer (Oracle OBIEE}, Oracle BI Publisher, Oracle XML Publisher, SAS Enterprise Guide 9.3/4, Crystal Reports 9, SAP Business Objects, MS Access, SSRS, MS Excel, SAS EG 8.1,Tableau Desktop 19.

gui tools

MS Project, Visio, MS Office suite, Crystal Reports 8.5/10, Business Objects X/XI, Teradata SQL Assistant v13, MS Office for Mac, SQL Plus GUI, Toad version 8.5 /9, Toad, Oracle SQL Developer version 12, Dreamweaver, SAS EG 8.1, Aginity Workbench for Hadoop.

defect tracking

Serena Team Track, BMC Remedy, HP Service Manager, Clear Quest, HP Quality Center.

IT Methodology

Agile, Scrum, ITIL, SDLC, Waterfall, Jira, Rally, Confluence.

testing tools

Junit Test, HP Mercury Test Suite v11, LoadRunner, WinRunner, Test Director, Quick Test Pro, IBM Rational Test Suite, Rational Robot-Test Manager v7.

DATA Modeling TOOLS or CASE TOOLS

Erwin 2.5, BPwin, Vizio, UML, IDEF0, IDEF1X, Power Designer.

Professional experience

January 2023 – Present BI Reports Developer - Quadrant Inc Robbins Gioia

Optics MRO project

Deveoped sql scripts and provide data development and cleanup of data.

Created test scripts and requirements for the project.

Participated in Agile scrum development team meetings.

Researched BI tools for use of business intelligence reports for the project.

May 2022 – December 2022 – Business Analyst – Marathon Petroleum IT HESS Compri Consulting San Antonio, TX

Developed scripts and tested projects and supported business process owners for Intelex ACTS.

Created Leakdas user accounts and troubleshoot problems with leakdas.

Created change requests for production releases in service now.

Participated in Agile scrum development team daily stand ups and updated user stories related to ois, geotab, and Acts.

Updated ETL autosys jobs, Json packages, ms sql for geotab, ois and leakdas and performed test and production validation testing of mpc applications.

April 2020 – April 2022 – Business Analyst – USAA Federal Savings Bank – BBIA – Millennium Group San Antonio, TX

Developed SQL scripts, Procedures to develop and test Reports in SAS Enterprise Guide, IBM Netezza and Snowflake.

Developed SQL scripts, macros in SAS EG and Hadoop for projects, reports, dashboards, and Tableau Desktop.

Created spreadsheets of project data in MS Excel, Hadoop, visualizations in Tableau, analyzed and reviewed project data requirements from USAA FSB Customers and tested SAS EG programs for quality assurance. Also facilitated meetings with POC’s.

January 2018 – March 2020 – SQL Developer / Reports Developer United States Air Force Population Health - KeAki Technologies Joint Base San Antonio, TX

Developed SQL scripts, Procedures to develop and test Reports of Air Force military personnel, retirees, civilians, spouses and dependents data related to expenditures, in SAS, MS Excel, Tableau and MS Power BI.

Developed Dashboards, visualizations and reports of government health data relating to expenditures for customers, automated SQL, and Unix / windows scripts in Teradata, MS SQL Server with use in MS Power BI & Tableau.

Developed SQL scripts in Teradata, Oracle, SQL Server T-Sql scripts, Clustered, Non-clustered indexes, SSIS packages, SSRS reports and dashboards using Informatica ETL, SAS and updated Data warehouse for reporting of government health data and expenditures.

May 2017 – December 2017 – Business Analyst - Distributed Data Analytics - USAA - Strategic Staffing Solutions San Antonio, TX

Developed SQL scripts, stored procedures to develop and test Reports in SAS and IBM Netezza.

Developed SAS programs and exported USAA monthly Member Service Reps data from SAS to MS Excel and created MS Excel Pivot Tables and charts and verified data accuracy against Salesforce.

Developed visualizations of monthly MSR data using SAP Lumira, and Tableau.

Created Pivot Tables, visualizations in Tableau and reports in MS Excel, gathered data requirements for projects from stakeholders and reviewed reports, graphs, dashboards, presentations, and data for quality assurance.

Reported Trends and Forecasting for USAA’s MSR data and management structure using SAS, MS Excel in Tableau for presentation of data analysis to USAA upper management.

January 2016 – April 2017 – UDP - SQL Developer/Data Warehouse and Reports Developer San Antonio, TX

Developed SQL scripts, clustering, non-clustering databases, Procedures to develop Reports in Crystal Reports, Tableau, and SSRS.

Developed SSIS packages for reports development and DW development of customer databases in Sql Server 2016.

Tested and deployed data migration from MySQL to Sql Server 2016 and customer-based reports and data gathering.

Developed customer dashboards in SSRS and Tableau for UDP.

Developed Data Warehouse for UDP customers using SSAS, SSIS and SSRS for reporting.

January 2015 – December 2015 – Amdocs/AT&T Mobility – Reports Developer/Data Analyst

Developed SQL scripts, Procedures to retrieve Uniform Listing of All Tell Wireless data from Oracle Databases/DW.

Developed MS Excel / Tableau Dashboards, Pivot Tables, graphs and metrics.

Developed canned and ad hoc reports using Business Objects, Oracle BI Publisher and SSRS for All Tell Wireless data.

Developed UNIX shell scripts to automate process of execution of Oracle SQL scripts and conversion of data.

Data Analyst responsible for data analysis requirements, data governance, data quality, scripting, configuration management, and data mapping.

March 2012– December 2014 – Sprint Corporation/Information Technology Group - Business Analytics –SQL Developer/Data Analyst

Uploaded Sprint Customer Care data from Oracle databases and Teradata Data Warehouse to Vendor.

Developed Automation of Oracle and Teradata SQL scripts of Sprint Customer Care data to Vendor.

Designed Device by Operating Systems, Enterprise by Operating Systems, and Device Swap Type, Apple devices business case projects, Sprint Customer care, and adhoc reports developed in MS Excel, Business Objects. Oracle BI Publisher and SSRS from Teradata Data Warehouse.

Provided Call Center and Customer Specialist Retail Store data mapping, customer data, data governance, data quality, metadata for Pulse initiative.

Developed Customer Survey data automatically to Sprint management in SSIS packages and T-SQL scripts.

Designed and automated process of Teradata Fast Export scripts to export Customer Care data from Data Warehouse to Vendor location.

Developed Stored Procedures in Oracle and MS SQL Server for automation of SQL/data tasks.

Reported trends and forecasting of monthly/quarterly Sprint Customer data visualizations in MS Excel and Tableau to Sprint Management.

September 2011 – February 2012 – AT&T - Group O Marketing Solutions – San Antonio, TX –Data Analyst

Developed SQL queries for AT&T U-verse marketing campaign, MS Excel pivot tables, PowerPoint presentations of dashboards, and reports in Business Objects and SSRS.

Developed U-verse marketing campaign reports utilizing Teradata SQL Assistant, and Toad for Data Analysis.

Performed and analyzed U-verse marketing campaign data for trends and reporting requirements.

Developed Teradata and Oracle views, procedures, and tables for reporting requirements.

February 2011 – September 2011 – Boeing - PDS Technical Services, Inc. – San Antonio, TX – Systems/Data Analyst

Business and Data Application Support Analyst responsible for 787 mechanic, inspector, and engineer support staff.

Equipment and Application Defect Support Analyst providing resolutions in HP Quality Center Service Manager.

Application Support Trainer for 787 project applications.

Developed Cognos Business Intelligence Data Warehouse reports on 787 aircraft/Line Numbers for 787 Operations Management.

Systems and applications development consultant for product enhancements and deliverables.

November 2009 – August 2011 USAF - Information Innovators Inc. – San Antonio, TX – Enterprise Service Help Desk Project - SQL Developer

Reports Developer utilizing SSRS, Business Objects and Excel for USAF Enterprise Service Help Desk website reports.

UNIX shell script developer responsible for production maintenance, Backup/Recovery, installation of patches and upgrades to SQL Server Databases, clustered, non-clustered indexes, SQL Server testing, MySQL, Oracle databases.

Developer responsible for exporting Remedy Help desk reports developed in Business Objects or SSRS to SharePoint portal.

Business Analyst responsible for requirements gathering for Visio technical diagrams, workflows, flowcharts, and technical documents.

Application Workflow Analyst responsible for SSIS packages, ETL processes, developing T-SQL scripts and Procedures.

May 2008 – November 2009 – Air Force Services Agency - SAIC – San Antonio, TX –SQL Developer

Business Analyst created financial reports for Oracle E-Business Suite of AR, AP, and GL accounting data in Oracle Discoverer, BI Publisher and Microsoft Excel.

Oracle Process Manager responsible for configuring development environment concurrent manager scripts.

Requirements Analyst utilizing Serena Team Track and PVCS for version control of code or configuration management.

Oracle Programmer responsible for database support, and data analysis for Air Force Services application.

Oracle E Business Suite 11i Applications Analyst responsible for SQL scripting, PL/SQL scripting, testing and data mapping.

Created tables and data in Oracle databases for Air Force Services customer databases AR, AP, and GL financials.

September 2007 – April 2008 – AFPC - Diversified Technical Services Inc. – San Antonio, TX –Systems Analyst

Web Applications Programmer Analyst responsible for gathering technical business requirements for application projects.

Documentation Specialist responsible for all SDLC phases of change management, discovery items, and conversion documentation.

Testing Analyst responsible for Data Conversion, FoxPro database testing, data integrity, data migration to SQL Server.

Business Analyst responsible for translating business requirements into technical diagrams, workflows, flowcharts, and creating technical documents.

Developed Procedures, T -SQL scripts, Views/Tables, SSIS Packages for web app development in MS SQL Server.

January 2005 – September 2007 – Lockheed Martin – San Antonio, TX –Systems Analyst

Responsible for updates and modification to Command Core databases for the Department of Air Force.

Responsible for all data throughout the USAF bases in Oracle databases versions 8i/9i and 10g.

Built and maintained PL/SQL packages in Oracle databases to support Command Core Program.

Built MS Access application to provide Ad hoc reports, and ticket metrics reports to USAF Program management.

Developed USAF Bio Environmental Engineering Data Warehouse reports utilizing Oracle Discoverer (OBIEE).

Business Requirements Analyst responsible for technical diagrams, workflows, flowcharts, and documents.

Coordinated Hardware Tech support of Unix Solaris/HP hardware platforms, Backup/Recovery, performance tuning, patches and upgrades to Oracle databases and Unix servers.

Application Tester responsible for beta testing of Command Core application and coordinating schedule release.

Developed Unix/shell scripts to support file maintenance and backup Oracle databases in all environments.

March 2000 – December 2004 - Sprint Corporation – Overland Park, KS – Software Engineer IV

Software Test Engineer responsible for System Test, Regression, Integration & functional testing and test scripts.

Requirements Analyst responsible for gathering and translating customer technical business requirements.

Testing Analyst responsible for coordinating requirements with development teams, release and project managers.

Data Analyst responsible for requirements gathering, configuration management, data mapping, creating Informatica ETL packages for Testing and Application Project teams within Sprint Enterprise.

Reports developer used Cognos Impromptu and Toad to query/collect data for Sprint testing and development teams.

Developed Business Intelligence reports for upper management release testing metrics in Crystal Reports.

Oracle and MS SQL Server 2005 SQL Developer responsible for SQL development, ETL packages and reports.

Developed Unix Shell scripts for database and file maintenance for Sprint Customer Care projects.

Responsible for gathering and translating business requirements to technical documents for customer projects.

SKILLS & Expertise

Technology, Data, Application Support, Requirements, Analysis, Business Analytics and Business Intelligence expertise in Functional, Regression Software Testing, Requirements, Statistical/Business, Metrics, and Security Analysis. Including applications building spreadsheets, graphs for metrics, and statistical analysis in identifying company level performance indicators, Defining, developing and writing test plans and cases, Ability to communicate both orally and in writing, Experience with web applications, automation test tools, Relational database management skills, SQL, Data Analysis and Report writing tools, Manual and automation testing web applications, desktop applications, Troubleshooting equipment and applications. Also working in collaboration with stakeholders and others in customer support of projects, requirements and assignments related to IT.

Contact this candidate