Robert Leitch Email & Phone Number

Seguin, Tx, Us

Optics MRO project▪ Developed 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.▪ Developed charts in angular, html, css, java script and Git repo for version control.

▪ 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.

Developing SAS Enterprise Guide programs designed to retrieve internal confidential information for USAA Bank.Developing Tableau visual artifacts reflecting business trends or forecasting of USAA bank products for the business.Reviewing requirements for reports with USAA Bank customers.Developing reports using SAS Enterprise Guide 8.1, Aginity Workbench for IBM Netezza and Hadoop.Developing reports using data from requirements and creation of SQL scripts and procedures in Salesforce, Snowflake, Python, Hadoop, SAS Enterprise Guide 8.1, and IBM Netezza.

SQL Developer / Reports Developer KeAki Technologies • Developed SQL scripts, Procedures to develop and test Reports in SAS, MS Excel, Tableau. • Developed Tableau Dashboards and reports for customers, automated SQL and windows scripts. • Developed SQL scripts in Teradata, Oracle, SQL Server, SAS and updated Datawarehouse for reporting.

Developed SQL Scripts using IBM Netezza Agnity Work Bench, SAS Reports in SAS Enterprise 9.4, Excel Pivot Tables, presentations of MSR data using Powerpoint and SAP Lumira and Unit Tested data in SQL and SAS.Also met with customers and management regarding data requirements, business rules for reports and analytics as it concerned MSR Rotations and Workforce management to Executives at USAA.

• Developed SQL scripts, Data dictionaries, Dashboards, Pivot Tables, graphs and metrics in SSRS, Tableau and MS Excel. • Unit Tested reports using MySql Workbench and in MS SQL Server 2016 SSRS and Crystal Reports. • Developed canned and adhoc reports using Crystal Reports/SSRS and data conversion from MySQL to SQL Server. • Developed Data Models in SSAS, and ETL SSIS packages to automate process of execution of MySQL SQL scripts and conversion of data to SQL Server 2016 for Data Warehouse. • Data Analyst responsible for data analysis requirements, data governance, and data mapping.

Chesterfield, Mo, Us

AT&T Mobility / Alltell Migrations Project - AmdocsOracle SQL Development of SQL scripts to retrieve UL tables and other data as it relates to AT&T Mobility and AlTell wireless data that is used for reporting on the status of Migrated customers from AlTel Billing System (Convergys or P2K) to AT&T's Telegence or Renaissance billing system, an Amdocs product.Created Unix shell scripts/cron jobs to schedule and execute the SQL scripts and convert the output of files to csv or comma separated files to be used in MS Excel VBA scripts for Reports output. The reports can run on a daily, weekly or monthly basis.Created MS Excel VBA scripts, Oracle stored procedures, or macros to execute the automated Reports of All Tell migrated customers per the requirements.Tested the automation and execution of the scripts from the database as programmed in the MS Excel VBA code or macros. The reports will also be sent via email to those managers/departments that requested the data.Meet w/Business Analysts and Process owners regarding the requirements of the reports and log all of the work and track the progress of the work and also report any defects or issues encountered during development and testing.Oracle 11G database, HP UX or Unix on HP servers/platforms on multiple test environments including production once tests have progressed to production and implementation phase of the project.

Overland Park, Kansas, Us

Information Technology Group (ITG) Extracted/Uploaded data from Oracle databases and Teradata Data Warehouses (databases) to vendor secure upload site via Secure FTP site.Develop and execution of Oracle and Teradata SQL, packages, procedures and other advanced SQL for migration of data to 3rd party vendors.Created Executive Summary reports from Oracle and Teradata databases/data warehouse in Microsoft Excel and Adobe Acrobat.Data Analyst and Data mining/cleanup of data on existing Oracle databases, Microsoft SQL Server 2008 databases, and Teradata Data warehouse/databases for Sprint Nextel Corporation.Migrated/cleansed Customer care data from Oracle databases to Sprint's thrid party vendor's site/location to Teradata data warehouse/databases at Sprint Nextel Corporation.Reported customer care call data, ICM data, IVR data and retail data from Sprint Nextel Corporation's wireless customers as calls get internally routed to Sprint Nextel call centers and customer specialists at Retail stores for Pulse initiative.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 OS, Enterprise by OS, and Device Swap Type Sprint Customer care reports in MS Excel.Provided Call Center and Customer Specialist Retail Store customer data for Pulse initiative. Developed Customer Survey data automatically to Sprint management in SSIS package and T-SQL scripts.Designed and automated Teradata Fast Export scripts exporting Sprint Care data to Vendor location.Developed Procedures, Stored Procedures in Oracle and MS SQL Server for automation of SQL/data tasks.

▪ 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.

▪ 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.

Enterprise Service Help Desk Project SQL Developer / DBA Lackland AFBReports Developer utilizing SSRS for Enterprise Service Help Desk website reports.UNIX shell script developer responsible for production maintenance, SQL Server testing, MySQL, Oracle databases.Applications Support Analyst responsible for installation of client databases, and troubleshooting desktops. Developer responsible for exporting Remedy Help desk reports developed in Business Objects to SharePoint portal.Business Analyst responsible for requirements gathering. Produced Visio technical diagrams, workflows, flowcharts and technical documents.Application Workflow Analyst responsible for SSIS ETL processes, developing T-SQL scripts and Procedures.Backup DBA responsible for backing up and restoring MS SQL Server 2008 R3 databases via MS Advanced Server, Oracle and MySQL, Remedy, Active Directory, SSRS, SSIS and ETL processes/jobs.MS Sharepoint 2008 developer responsible for publishing reports, metrics, and other documentation to the 590th NSS share point portal.

Reston, Va, Us

Oracle PL/SQL programmer, Oracle HR Federal, Oracle E-Business Suite, Java, XML scripting.Business Analyst created financial reports of AR, AP, and GL data.Oracle Enterprise / Process Manager responsible for configuring development environment concurrent manager scripts. Requirements Analyst utilizing Serena Team Track for version control of code or configuration management.Oracle Programmer responsible for database support, and data analysis for AF Services application.Oracle E Business Applications Analyst responsible for SQL scripting, testing and data mapping.Oracle Discoverer Reports Developer responsible for customer AR, AP, and GL financial reports design.Business Requirements Analyst responsible for Visio diagrams, workflows, flowcharts, reports, and ETL packages developed in Informatica Power Center.

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 2008 databases. Business Analyst responsible for translating business requirements into technical diagrams, workflows, flowcharts, and create technical documents.Developed Procedures,T-SQL scripts, Views/Tables, SSIS Packages (Business Intelligence Development System) for web app development (.Net) in MS SQL Server 2000/2005/2008 and Visual Studio 2005/2008..

Bethesda, Md, Us

Responsible for updates and modification to Command Core database 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.Built MS Access application to provide Ad hoc reports, and ticket metrics to USAF Program management.Developed USAF Bio Environmental Engineering Data Warehouse reports utilizing Oracle Discoverer and Business Objects BI reporting tools.Documentation Specialist responsible for content and portal site management of Command Core Home Page, data migration, data mapping, data analysis, data cleansing, gathering/translating business requirements. Business Requirements Analyst responsible for technical diagrams, workflows, flowcharts, and documents.Coordinated Hardware Tech support of Unix Solaris/HP hardware platforms. 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.

Software Test Engineer responsible for System Test, Regression, Integration and functional testing of Java applications utilizing Rational Test, Mercury Interactive testing suite tools and HP Quality Center for defects..Requirements Analyst responsible for gathering and translating customer technical business requirements.Testing Analyst responsible for coordinating requirements with development teams, release and project managers. Business Requirements Analyst responsible for technical diagrams, workflows, flowcharts, and documents.Help Desk Customer Service representative responsible for outage reporting to customers and ticket resolutions.Data Analyst responsible for requirements gathering, configuration management, data mapping, creating Informatica ETL packages and testing.Reports Analyst using Cognos Impromptu and Toad to query/collect data for Sprint testing and development teams.Senior Business Analyst responsible for budgetary support group business customer requirements.Project Manager responsible for all customer deliverable labor and management budgeting requirements for Viewstar and IVR call center application utilizing the SDLC and SEI CMM.Application Developer responsible for PL/SQL and XML script web customer technical support.Crystal Reports developer responsible for creating reports for upper management release testing metrics.Oracle and MS SQL 2000 Database programmer responsible for database management, ETL packages.Developed Unix Shell scripts for database and file maintenance.SQL Developer responsible for Oracle database design, User management, workflows and Reports.

Houston, Texas, Us

Data Modeling using CASE Tools such as BPwin and ERwin, SQL Development, Created Triggers, Stored Procedures, Functions, and Populated data for DMHRS database using PowerBuilder and MS Access scripts.Reviewed Military manuals for Business rules, data and processes for US Army, Air Force, and Navy; facilitated meetings with other data stewards within the Government to determine the data needs for customer on DMHRS Project.Tools used: Toad, PowerBuilder, Oracle SQL Plus, Informix client, Oracle Client, CASE Tools such as BPwin and ERwin for data modeling and Process modeling.Databases and other Programs used: Informix version 7.3, Oracle version 7.3, Microsoft Access, Excel for data mapping, HP Unix, Shell Scripting, Windows NT Server to back up the databases and data models.

Sudbury, Ma, Us

Developed Business Process Models for current system and new system for TDY to School Accounting Project / AFPC Randolph AFBFacilitated meetings with users of current system and similar other systems throughout the USAF to better understand their processes for similar projects throughout the USAF related to Airman Training.Tools used: CASE Tools BPwin, ERwin for Business Process modeling and Data Modeling based on IDEF0 and IDEF1X standards, Vizio, Microsoft Word, Microsoft Excel for mapping elements and Target elements out of MilPDS Oracle Database.Databases: Oracle, Oracle SQL for defining Temporary tables and views, Functions and Procedures for Application and Database design and deployment of new application. Oracle Applications including Oracle Forms and Reports for developing and later deploying the solution.

Us

Research Analyst / ProctorConducted studies of USAF Basic Trainee Flights from Lackland AFB.Developed applications and SPSS statistical models of data for the USAF Armstrong Lab at Brooks AFB.Also Proctored computerized tests to measure motor skills and other tests and collected the data for analysis at Brooks Armstrong LabsTools used: Borland Object Oriented Pascal, SPSS for PC's, Windows Client OS, Batch file programming and loading of data files of sample data, Windows scripting and MS Excel.Documented the findings of the research and graph models of the data as it pertained to each flight of Basic Trainees responses to the data. The data was shared and presented to the Psychological research team and to the USAF.

Bachelor’S Degree, Business Administration And Computer Information Systems

Academic, Academic