I have 9 years' experience working with ORACLE Databases. I was promoted from Data Analyst to Software Engineer 1 in March, 2014. For eight of those years, I updated a TIBCO Master data Management database using Extract, Transform and Load (ETL) processes. For the last year I updated Master Data using Salesforce CRM Software with ETL. My primary duty at Rent A Center was to maintain a store database, with more than 250 fields for over 4500 stores. The store data has such information as addresses (including latitude and longitude), phone numbers, manager names, and ACH and Merchant ID information. To maintain all this data and ensure accuracy, I utilized several ETL tools such as SQL Developer, SAS 9.4 for Windows, other databases, emails, and spreadsheets (using at times VBA for Excel) to the proposed updates. I have written and periodically executed various quality control queries to ensure accuracy. I developed a report that combined information from Salesforce into a daily report distributed to top management. I was furloughed March 26 after 9 years with RAC, due to a merger with another company and during the pandemic. I am looking forward to the next chapter in my life, where I can contribute to the success of your organization.

I Started at Rent A Center loading store data for over 4500 stores into a TIBCO Master Data Management System from emails and spreadsheets. Progressed to analyzing the data for accuracy by comparing said data to other databases using various tools. I was instrumental in correcting bad addresses for thousands of stores in the database. I wrote a report in SQL DEVELOPER that combined data from over 20 tables into one report that showed over 250 fields for each store and included alignments of the stores to districts, regions, and SVP's. I was promoted to position of Software Engineer 1.

I was an Independent Contractor working for VisionIt. My position was as a SAS DATA INFORMATION ANALYST. I used various products including but not limited to SAS for Windows version 9.1.3, Teradata 13.0, Teradata SQL assistant 13.0, Microsoft SQL Server Query Analyzer, Crystal Reports 2008, SAS Management Console 9.1 and Platform Process Manager 3.0.

Certified Linux+ and studied SQL and Oracle.

• Promoted to Assistant Vice President in 2007• Maintain and update the Tivoli Enterprise Portal (TEP)• Train associates in the US and INDIA on how to use the Tivoli Enterprise Portal• Use SAS Data Step, CA-View(SARS), SDSF with JES2, and SDF with JES3, and CONNECT:DIRECT to get raw data into Microsoft Excel for monthly statistical upper management reports.• Support Disaster Recovery drills• Began training in Six Sigma

• Promoted to Officer Aug, 1998• Converted the Tape Library System (TLP) from using NETMAN as input to use Service Center as input• Worked with the Security department to implement security between RACF and CA7• Wrote a flowchart process in 1996 that programmers, schedulers, and managers use. This saved the company $38,000 that they were going to spend to purchase a vendor product• Wrote programs to automate the Disaster Recovery Process job flows using data from SUNRISE and CA7• Wrote a program that combined CA7 jobs, requirements, and triggers into a single report and created CLISTS to make the information available from ISPF• Used SAS SQL and SASVIEWS to get data from DB2, Service Center, and Endevor• 24 Hour on call support for over 240 jobs for both Europe and North America that were written in COBOL, FOCUS, and SAS• Automated a process that saves Production Control approximately 520 hours a year that combines data from CA7 and Service Center into a single report and show problems that might exist prior to the nightly production run. This compared the nightly schedule to a forecast that was done a month ago to document the changes that had been made to the schedule.• Automated a process to do auto balancing with accounting data. This showed whether credits and debits were in balance prior to running the nightly cycle. If credits/debits were out of balance the nightly cycle would abend.

• Supported CICS• Installed Playback system• Maintain file control tables• Developed a SAS program to rename all (2000+) CICS terminals when SSBA moved to Hallmark 1 building in 1993

• Automated date cards• Led a team of 2 to install CA11 on all jobs• Taught various departments how to use CA11• Developed a site specific CA11 Manual for operations and programmers to use• Developed a series of reports that allowed Production Control to identify and move jobs from tape to DASD that resulted in 75,000 fewer tape mounts per month• Developed a Delaware Network on CA7 to allow Delaware to schedule their own production jobs. • Wrote programs to aid in the determination and cure of bottlenecks to production

• Responsible for properly scheduling jobs, restarting jobs, and eliminating scheduling errors.• Developed a flowchart program to chart UCC7 job flow based on job requirements• Developed a SAS program to verify that all predecessor jobs were in the schedule for the night• Wrote 26 assembly programs to eliminate manual updating of date cards.

• Responsible for operational aspects of UCC7 and UCC11• Headed team of three to completely reorganize UCC7.• Rebuilt every job schedule, trigger, pre-requisites and networks. This team did all subsequent scheduling• Worked with programming staff to have internal reader submitted jobs changed to be under the control of UCC7• Used recommendations from UCCEL to have the datasets moved to their proper locations• Used a combination of UCC7 & UCC11 commands and SAS programs to produce reports for management and programmers• Removed all hold cards in jobs• Set up parameters and turned on workload balancing• Provided training for operations and programming staff• Developed and implemented a reason for rerun table and SAS programs to graph the reasons causing abends. This report went to upper management. • Developed SAS programs to flowchart job triggers on UCC7• Reduced operations staff and eliminated use by Operations of flowcharts to run nightly processing• Reduced reruns by scheduling jobs correctly• Greatly reduced run times for all systems• Ran 44,678 more jobs in 1986 than in 1985 (a 27 % increase)

• Used COBOL to maintain Accounting systems

Primary responsibility for the Software International General Ledger System and the Customs Accounting System, and had secondary responsibility for the Accounts Receivable and Work Orders SystemBrief exposure to the Komand System using K/DAS, K/RBS, K/DIS, K/DAMS,K/CCI

• Responsible for using UCC7 and UCC11 to do the following: job scheduling; defining datasets; renaming datasets; setting up job triggers and job restarts; research documentation; and reviewing and updating date cards• Eliminated 65% of the date cards by use of IEBGENER.• Wrote standards and implemented UCC7/RPT• Used TSO/SPF to run programs that I had written in COBOL, Easytrieve and SAS; to run various utilities; to restore files before a restart• Did forms design programming on the XEROX 9700 printers• Abend Recovery

• Responsible for operating Harris RJE shop. • Prepared jobs for execution, scheduled jobs, and prepared all output for distribution • Fixed JCL errors • Trained other operators and part time help • Supervised the activities of 2 coworkers.