Gary F. Sladcik

***** ***** ****

San Antonio, TX 78247

Cell: 210-***-****

e-mail: adx9pm@r.postjobfree.com

Technical Summary

Operating Systems: Windows XP/7/10, Linux

Languages: Java, Spring, J2ee, HTML, JavaScript, jQuery, PL/SQL, Angular, Groovy, GWT, SQL Software: ServiceNow, Eclipse, RTC, UCD, NetBeans, TOAD, SQL-Plus, Gradle, Maven, Ant, Hibernate, MyBatis, ehCache, MS Office/Project/Visio, SoapUI App Servers: Websphere, Tomcat, Weblogic, Glassfish Database: Oracle, MongoDB, MySql, DB2, UDB, Sybase, PostgreSQL Source Control: RTC, Subversion, GIT, Perforce, StarTeam Professional Work Experience

Boeing, Bellevue, WA (remote) (Sept 2021 to present) Senior System Programmer Analyst (contract TCS)

Created monitoring tool that checks the status of DB accounts, expiry of active applications, historical information of expired/deactivated applications.

Supporting application: IDWS – Identity and team services – Java,Oracle, REST

Supporting application: IDAP – Identity/teams front-end to IDWS – Java, Angular

Supporting application: InSite – People Search – Combo Facebook, StackOverflow, YouTube Java, Struts, Oracle, Zookeeper, Puppet, Jenkins

Supporting application: Metascan – Multiple virus/malware scanner Citibank, Irving, TX (remote) (May 2020 to July 2021) Senior System Programmer Analyst (contract TCS)

Supporting Spring JMS integration of micro-services into cloud services Assisted clients with configurations including multiple profiles

Supporting HTTP micro-services communication channels Assisted clients with configurations

Maintain Java and Spring code supporting cloud integration to Oracle database including PL/SQL functionality USAA, San Antonio, TX ( February 2018 to Feb 2020) Senior System Programmer Analyst (contract TCS) 1 (USAA ServiceNow Certified) May 2019-Feb 2020 (Enterprise GRC)

Lead technical team for ServiceNow and Java REST integrations Performed Business Analysis, identified tasks and provided level of effort estimates

Working GRC strategy regarding control testing

Leveraging ServiceNow GRC Control object for POC Created a secondary control table to store additional control information Calculated Design Effectiveness

Utilized ServiceNow Control indicator to automate control testing and calculate Operational Effectiveness

Created REST WebService to retrieve control/risk data from MetricStream into ServiceNow

Created REST WebService to retrieve policy data from MetricStream into ServiceNow 1 Part of team which received USAA’s Grace Hopper Award for 2018 Sladcik – Page 1 of 7

USAA continued...

Created REST WebService to convert PDF (policy document) into encoded HTML to be injected into ServiceNow policy and Knowledge Base article

Performance tuned queries (Oracle) and PL/SQL functions November 2018-May 2019 (Print and Mail)

Lead the team and project through the conversion Performed Business Analysis, identified tasks and identified technology stack

Conversion of billing and status tracking system for Print and Mail to Spring Batch

Interfacing with Control-M and database connectivity with SQL Server

Unzip files, parse of XML files, and FTP processed files and generated reports February 2018-November 2018 (Digital Content Delivery)

Created SMS Feedback servlet for new provider (Java, DB2)

Implemented caching improvements to SMS out and feedback

Added new test cases to Health Check servlet for the new SMS provider

Implemented the slow roll from GCM to FCM for PUSH notifications

Included throttling and ERDC

Education Services Center -Region 20, San Antonio, TX ( February 2017 to December 2017) Senior Java Programmer Analyst – Java Architect

Corrected defects (Human Resources): (Java, Spring MVC, jQuery, JSP)

Javascript validation added to correct abnormal end of program

Javascript corrections for navigation

Javascript correct on screen calculations

Created a new report for employee demographic tracking (Java, Spring MVC, jQuery, JSP, Sysbase)

Rewrote account codes module including additional validations (Java, Spring MVC, jQuery, JSP, Sysbase)

Rewrote chart of accounts module including additional validations (Java, Spring MVC, jQuery, JSP, Sysbase) Linebarger Goggan Blair & Sampson, LLP, San Antonio, TX ( May 2016 to December 2016) Senior System/Database Programmer Analyst – Java Architect

· Enhanced servlet used for eFiling lawsuits

· Created a tool to summarize log file activity and email results (Java, Spring)

· Created modified REST Web Service to receive responses from Amazon Simple Notification System

(Amazon SNS) (Java, Spring)

· Created REST Web Service to take Noble call history and store in a DB (Java, Spring)

· Created batch process to rerun failed REST Noble requests (Java, Spring)

· Modified PL/SQL packages to support multiple processes (Oracle, PL/SQL) Trinity Millennium Group / Averisource, San Antonio, TX ( June 2014 to January 2016) Senior System/Database Programmer Analyst – Java Architect – Technical Manager

· Served in managerial role: organize development activities, ensure quality assurance is completed, and contribute to organization of delivery tasks

Performed Business Analysis and identified essential tasks and level of effort

· Served as team lead/Project Manager for MVC .NET Web interface project

· Configured and architected hybrid data access layer with MyBatis and Hibernate – configured in Spring snd used Maven to build

· Used MyBatis to call PL/SQL functions

· Implemented data look-up with caching

· Participated in DB tuning as well as review SQL queries (Oracle)

· Participated in design and code reviews

Sladcik – Page 2 of 7

· JUnit test cases modified or created as needed

· Designed and implemented Grails (Groovy on Rails) application to execute current functionality on a server

· Prototyped a new Web interface utilizing GWT and Bootstrap UI, Java, and PostgreSQL. MinistryOnThe.Net,, Montgomery, AL ( January 2014 to June 2014) System/Programmer Analyst – Contract (remote)

· Enhanced UI to to be more usable (JSP/Struts)

· Corrected coding and design defects

Bass Pro Shops Corp., Springfield, Missouri ( December 2012 to May 2013) System/Programmer Analyst – Contract – Java Architect

· Enhanced TillWatcher application (loss prevention). Added PDF reporting and enhanced UI (JSF) Verified data in DB (PL/SQL)

· Created SOAP Web Service for Rewards program. Client and server pieces. Client piece was integrated into the Point-of-Sale (POS) software; check points, add points, use points, find Reward number. Server fulfilled client requests. (Apache CXF) – Maven was used to build the POS software Regions Bank, Birmingham, Alabama ( July 2012 to September 2012) System/Programmer Analyst – Contract

· Generated DB analysis report for table row size (Spring IOC)

· Generated user report identifying missing information found in active directory (Spring IOC)

· Create application to receive documents from third party, create metadata in XML to be ingested into FileNet. (Spring IOC)

Bank of America, Charlotte, North Carolina (August 2010 to June 2012) System/Programmer Analyst – Contract – Full Stack Java Developer

· Created/enhanced data extraction and statistical analysis used to predict possible incomes in stress events – this process was integral part of evaluating RISK (PL/SQL)

· Created a view to integrate existing risk management system with new analytic system (Oracle)

· Created a new admin console to manage batch jobs (Spring IOC, AJAX, Servlets)

· Enhanced UI using GWT (AJAX, Servlets)

· Segregated security access to be build independent

· Enhanced logging

· Enhanced continuous integration by modifying CruiseControl config files

· Providing support for securities risk system

· Peer-tested all aspects from reporting to data extraction to statistical analysis

· JUnit test cases modified or created as needed

Florida Department of State, Tallahassee, Florida (August 2010) Database/Programmer Analyst – Contract

· Identified duplicate voter address records; created correction script

· Correct PL/SQL process to avoid duplicate addresses Sladcik – Page 3 of 7

The Freeman Companies, Dallas, Texas (June 2000 to June 2010) System/Programmer/Database Analyst – Contract – Java Architect – Technical Manager

· Served as project manager and SME for many of the major enhancements Performed Business Analysis and identified areas of impact along with level of effort

· Written several hundred stored functions, procedures, packages, and triggers in PL/SQL

· Lead developer for Freeman’s Total Show System (TSS), a Java-Swing application which they use to run their business

· Wrote the application security process which included dynamic menu based on the user’s security group; included encryption of logon id and password in the database (Swing) Modified to have password expiration, failed logons, and strong passwords.

· Wrote the ORDER process for TSS, which included generation of Work Tickets (Swing)

· Wrote the interface between TSS Orders and Freeman Online Orders

· Wrote the Price Master process, which included price templates (Swing)

· Wrote the invoicing process (Swing, PL/SQL)

· Assisted in writing the Credit Card transaction processing (Swing, PL/SQL)

· Assisted in the rewrite of the Upload/Download process (Swing)

· Rewrote the Customer Matching process

· Assisted the DBAs in performance enhancements

· Responsible for the Oracle script for each TSS release

· Wrote the Consolidated Billing System for program accounts; this JSP application’s principle function is to create a single invoice for all activity for a customer across all of the various Freeman Companies (j2ee, WebLogic, JSP, Servlets)

· Expanded the functionality of Consolidated Billing to include general jobs. Utilized EJB technology for this enhancement. (j2ee, WebLogic,JSP, Servlets)

· Expanded Consolidated Billing to include billing templates (j2ee, WebLogic,JSP, Servlets)

· Expanded Consolidated Billing to create EDI file for 3M invoicing (j2ee, WebLogic,JSP, Servlets)

· Created SOAP WebService to interface with SalesForce to create shows in the TSS application

· Created SOAP WebService to interface with SalesForce to invoke Cognos reporting

· Created WS Client for TSS to Ontaap Concierge services

· Created an interface to a document management system (Sharepoint); generated ETL and PDFs

(Utilize PL/SQL and triggers to accomplish most of the ETL processing) Bank of America (Community Investment Group), Dallas, Texas (August 1996 to May 2000) System/Programmer/Database Analyst - Contract

· Written over 800 SQL queries in QMF accessing the DB2 database; some queries were in excess of 500 lines

· Converted QMF SQL queries to SAS – performed data extraction and statistical analysis.

· Written over 200 REXX Execs for data extraction, reports, and utilities; approximately 45000 lines of code

· Generated monthly reports as well as ad hoc reports

· Provided data via downloads for ACCESS database applications

· Assisted in performance enhancing of ACCESS databases

· Support and enhance 8 ACCESS applications. Also design/develop new applications which use ODBC

· Part of team which developed a Java application to track investment data. Designed DB2 tables and wrote all the SQL calls to these tables. (Swing)

· Wrote about 10,000 lines of Java code (this does not include generated code)

· Served as Java code librarian

· Architected Web conversion of Java application to Java Server Pages (JSP) with JavaBeans (j2ee, servlets)

· Converted existing Java classes to EJBs (j2ee, servlets) Sladcik – Page 4 of 7

IBM Corp., Southlake, Texas (August 1993 to July 1996) System/Programmer/Database Analyst / Field Manager - Contract

· Maintained monthly SQL reports on the DB2/VM database.

· Generated over 300 REXX Execs for reports and utilities; 80,000+ lines of code

· Served as level 2 and level 3 support for our application

· Maintained 30 remote databases connected to our main DB; ensured data integrity

· Performed some DBA activities such as REORGs and system authorizations

· Performed all new installations of the application which included database generation

· As a manager, responsible for 21 contractors and 22 subcontractors ABN-AMRO Holding Corp., Chicago, Illinois (June 1993 to August 1993) Programmer Analyst - Contract

Coordinated and automated PROFS migration from two PROFS systems into one. Activities involved developing programs to perform necessary conversions and transmittal of data. Chrysler Technologies Airborne Services, Waco, Texas (May 1993) Database/Programmer Analyst - Contract

· Used VISIO to create data models and data entity models for their Job Cost Accounting system, Payroll system, Manufacturing system, and General Ledger system.

· Documented the data flow in WordPerfect

IBM Corp., Southlake, Texas (January 1990 to April 1993) Programmer Analyst - Contract

· Developed test plans and executed tests

· Participated in design process

· Developed test tools in REXX and C to test the OV/VM product

· Developed SAS reports on testing status and defective components

· Programmed fixes to defective code

· Held leadership positions: Meeting moderator, project leader, and interim contract manager IBM Corp., Irving, Texas (June 1988 to December 1989) Programmer Analyst - Contract

· Enhanced and maintained special bids tracking system with REXX Execs and PL/I programs

· Served project as code librarian and project leader

· Generated VP level reports in QMF

· Trained new IBM employees on the system

Central Systems, Inc., Dallas, Texas (November 1987 to June 1988) Systems/Database/Programmer Analyst

· Maintained and installed software on the system

· Developed system utilities, system backup, and user directory management tools in REXX

· Implemented of microcode fixes and PUT tapes

· Installed and supported SQL/DS as the DBA

· Designed the database as well as applications

Sladcik – Page 5 of 7

Southern Methodist University Computer Center, Dallas, Texas (November 1985 to November 1987) Programmer Analyst

· Maintained and installed software

· Assisted students and faculty on software with an emphasis on statistical software like SPSSx and SAS

· Taught short courses on VM/CMS, SPSSx, SAS, and network usage

· Contributed articles to the monthly newsletter and the computer center's user guide

· Assisted faculty with tape management

Shilstone and Associates, Inc., Dallas, Texas (May 1985 to November 1985) Programmer Analyst

· Developed and maintained BASIC programs for the concrete industry

· Shipped computers and software to customers

· Developed enhanced version of MIX design program and BATCH design program in Turbo Pascal

· Used a statistical optimization routine in MIX program to minimize waste Sladcik – Page 6 of 7

Education

Southern Methodist University - Dallas, Texas (1984-1985) Applied Mathematics Davidson College - Davidson, North Carolina (1980-1984) B.S. Mathematics Training

IBM Corp. Technical Center - Atlanta, Georgia. (October 1989) DB2 (Intro and Advanced) Completed Intro to FOCUS and Management Training in 1991, Interpersonal Management Skills in 1994, Resource Management and Enlightened Leadership in 1995. Fresco Play online training:

Cybersecurity Prologue (2018) Wireframing (2018) Git Slack Integration (2018) Spark Preliminaries (2018) Spark Streaming (2018) Spark SQL (2018) Docker – Container Orcas (2018) AWS Essentials (2018) Scala Constructs (2018) Web User Interface Design Techniques (2018) jQuery (2018) Kafka - Premiera Ola (2018)

[ References available upon request ]

Sladcik – Page 7 of 7

Contact this candidate