Jerry Cable Email & Phone Number

Plano, Texas

Assisted in migrating actuarial modeling ETL application from on-premise environment using Datastage and Netezza to Azure cloud environment using Databricks and Scala.Participated in software defect resolution effortsHelped new team members in the setup of their development environmentConducted code review of other developers’ software changesTested new software changes in preparation for submission to the QA teamSkills used: Datastage, Netezza, Powershell, Microsoft Azure, VBA, Microsoft Excel, Microsoft Access, SQL Server, SQL Server Management Studio, XML, Stored Procedures

Plano, Tx

Maintained and supported financial reporting applications as a member of the Transamerica Technology Finance Systems team

Mckinney, Texas

Automation Developer for the Retrospective Claims Accuracy Engineering team at Cotiviti

Mckinney, Texas

Conducted initial interview with user to gather information such as systems used, client software required, and current manual process used to retrieve the information, as well as what information needed to be retrieved and for what members and/or claims to targetCreated SQL Server tables to house the retrieved informationCreated SQL Server stored procedures to build the initial list of targets, fetch the candidates for use by the automation software, and update the fetched information in the database, storing the results in an XML formatDeveloped the automation software scripts to fetch the list of candidates, extract the candidate information from the target systems, and store the results in the databaseWork with the local engineering teams to take this information and present it to the analysts in a useful wayAutomated creation of weekly reconciliation report previously done manually via a spreadsheetSkills used: VBA, Microsoft Excel, Microsoft Access, SQL Server, SQL Server Management Studio, AutoIT, Automation Anywhere, XML, Stored Procedures

Dallas/Fort Worth Area

Performed analysis of the 300+ suite of Access and Excel user tools to determine which were impacted by the upcoming VLS to ALA conversion project. This project involved converting / merging the Bank One loan origination system into Chase’s proprietary loan origination system.Conducted interviews and gathered requirements for Business Requirements Documents and Functional System Design documents for several conversion-related projectsAttended project meetings, provided project status updates, and created status reports highlighting accomplishments, milestones achieved, and outstanding tasks.Developed / modified User Tools (UTs) which were primarily MS Access \ VBA front-ends with either MS-Access or Oracle 11 back-ends.Utilized Toad for Oracle and PL/SQL to query Oracle Databases, and created / modified Oracle packages and / or Stored ProceduresConverted form letters written in Microsoft Word into an HTML format and prepared them for use in a specialized mail merge repository. Ensured that the HTML version of the letter precisely retained the format of the original form letter and made any adjustments to the HTML as necessary to achieve this goal Supported Attachmate (now Microfocus) Extra automation scripts which extracted information from mainframe processes for use in Microsoft Access database processesSkills used: VBA, Microsoft Access, Microsoft Visio, Oracle PL/SQL, TOAD for Oracle, HTML, Microsoft Excel

Dallas/Fort Worth Area

Reporting Analyst for the Director of Corporate Applications and IT Purchasing at Neovia Logistics (12/2015 - 2/2016)Access/VBA Developer for the Auto Finance Business Operations team at JP Morgan Chase (2/2016 - 2/2017)

Dallas/Fort Worth Area

Conducted company-wide survey of current Microsoft Office 365 usersCompiled the results of the survey for use by upper level management to determine software licensing needs for 2016

Dallas/Fort Worth Area

Excel/VBA Developer for the Business Intelligence and Technology (BIT)/All Battery team at Interstate Batteries - August, 2015 to October, 2015

Dallas/Fort Worth Area

Enhanced existing macros which produced weekly and monthly sales reports by agent based on data feeds coming from SQL Server Reporting Services (SSRS)Worked with users to determine specifications for new reports which would roll up all activity for a store into one reportAnalyzed macros which produced current reports to determine changes to be made for new store-level reportModified macros to create report to new specifications based on existing data feed and minimized changes to SSRS inputsResearched issues reported by users and determined whether or not problem is with macro or with input report data, or both

Dallas/Fort Worth Area

Reporting Analyst for the GoToMarket Sustainment team at the Frito-Lay North American headquarters campus in Plano, TX

Dallas/Fort Worth Area

Ensured weekly Business Objects reports were set up to run properly and verified that they ran as scheduledKicked off macros to reformat Business Objects reports in Excel and created pivot tables as needed for eventual distribution to sales force. Corrected any problems with macros and re-ran as necessary.Assembled an analysis of the weekly reports for use by executivesAutomated the creation of reports which were previously created manuallyImproved the running of currently existing report automation macros and corrected any discovered issuesWorked with report developers to resolve any issues with Business Objects reports or Excel spreadsheets currently in production and accepted any new reports which are put into production by the reporting development teamAssisted team reporting lead with any tasks that needed to be done or reports that needed to be createdBuilt any ad hoc reports requested by team staffSkills used: Microsoft Excel, VBA, Business Objects, Microsoft Access

Dallas/Fort Worth Area

Client: Onsite contract at USMD in Irving, TexasVBA/Excel Report Writer consultant for the Physicians Practice Management team at USMD, Determined the steps necessary for automating the creation of Powerpoint slides for the PPM Monthly Statistics report, which up to this point had been manually created each month by one of the business analysts.

As a member of the consumer direct base lending product team, I developed, maintained, and supported the browser-based loan origination software productOther accomplishments and assignments: Participated in defect resolution effortsHelped new team members in setup of their development environment Participated in peer testing of other developer's solutionsAssisted with integration testing of new software fixes in preparation for being submitted to QAMaintained the onboarding documentation which was provided as a resource for new team membersSoftware used: HTML, XML, XSL, Javascript, JSON, JQUERY, SQL Server, ADS (ARGO middle-tier language)

Client: Onsite contract at FIS in Dallas, TXAs part of the FIS team at the FDIC in downtown Dallas, I was responsible for supporting Excel, VBA, and SQL Server programming projects in the Special Projects GroupEnhanced Excel spreadsheets by automating the creation of transactions for use by a downstream data service using VBA

As a Reporting Analyst in the Tactical Solutions Group of MetLife Home Loans, I was responsible for the maintenance and enhancement of a suite of Access databases and Excel spreadsheets used for reporting on various facets of the business.

Streamlined Access queries to speed up processing of reporting data and eliminate memory errors on larger record setsDesigned a standalone Access database to automate the creation of loan release forms using a spreadsheet of loan information as the inputEnhanced Excel spreadsheets by automating the creation of pivot tables, sorting report data, and formatting reports using VBAProduced ad hoc spreadsheets requested by various departments on an as-needed basisCreated a database using data from an external data source to produce CSV output files containing a list of records which had been either added or deleted that dayDesigned Access queries to read Oracle databases, produce a daily list of imaged documents, and output the results to a formatted spreadsheetAnalyzed problems with Access queries, fixed problems with queries using incorrect report criteria, and optimized queries to speed up the extraction of data from Oracle and SQL Server tables

Client: Onsite at Dallas Independent School District, Dallas, TXAs an IT Specialist in the Medicaid Services group of Dallas Independent School District, I was responsible for creating an Access database to keep track of students receiving services reimbursable by Medicaid.Developed an Access database to track special education students who receive Medicaid-reimbursable services to replace the maintaining of several Excel spreadsheets for the same purpose. This allows Medicaid Services staff to centralize information into one place and allow for the addition of reports.Created a VBA process to automatically import student information into the new Access database instead of running an extract and importing the information manually, which saved district personnel time and reduced potential errorsCreated data entry forms to allow the entry of a student’s Medicaid eligibility, status, and to allow the entry of missing Medicaid numbers, allowing for edit checks for valid data to reduce the occurrence of invalid informationDesigned forms to log information received from the district’s Medicaid providers into the new database concerning the status of the providers’ students.Created tables and forms to build and maintain a roster of the district’s special education providers, making it easier to maintain up to date provider information (current school and service assignments, etc.) in one place.Assembled a system to track letters sent to parents of students who are receiving Medicaid services for the first time and to track parent responses to these letters.Created several Access reports to provide both detailed listings and summaries of students, providers, and service assignments and replace the manual creation of these reports, reducing the number of possible mistakes.

Client: Onsite at Mary Kay Cosmetics, Addison, TXAs a member of various groups within Mary Kay's International IT division, I worked on a variety of projects to maintain and enhance legacy interactive systems for the Mary Kay subsidiaries in Australia, Argentina, Brazil, China, Korea, Malaysia, Philippines, Mexico, New Zealand, Poland, Portugal, Russia, Taiwan, United Kingdom, and Uruguay.Maintained and enhanced a suite of VB6 applications for both the Europe and Asia-Pacific subsidiaries including Accounting, Consultant Inquiry, Customer Service, Invoicing, and Order Processing, which acted as a front-end to an Oracle databaseModified the VB6 Invoicing program for one of the Europe subsidiaries to handle new government requirements and redesigned the invoice format per the customer’s requestModified the VB6 Invoicing program for the Asia/Pacific subsidiary to generate one PDF report file for the entire batch instead of one file for each invoiceAssisted in the design and implementation of conversion programs to move data from Microfocus Cobol proprietary data files to tables in an Oracle database for the China subsidiary. Assisted in the modification of programs that were part of the legacy consultant support system to process online orders and new consultant agreements for the Uruguay subsidiary. Functioned as first-line support for online ordering and customer service online application issues for Argentina, Brazil, and Mexico. Designed and implemented process improvements in the consultant support system for China subsidiary to more efficiently access the Oracle database. Software used: Microfocus COBOL, PL/SQL (Oracle), Transact SQL (SQL Server), ASP.NET, VB (version 6), Windows NT, Windows XP, Microfocus (formerly Liant) Relativity, Crystal Reports, MS Access (97, 2003, 2007), MS Excel (97, 2003, 2007)

Client: Excel CommunicationsAs a member of first the IT Billing group and later the IT Finance group, worked on a variety of projects to maintain and enhance legacy batch systems. Supported problem resolution, acting as a technical resource to the maintenance team for on-call and high priority problems.Provided support for Excel's billing products while Excel personnel were developing new technologies for the Billing groupDesigned and implemented conversion programs to move Finance data from the legacy systems to the new billing systemSoftware used: Realia COBOL, Microfocus COBOL, SQL, UNIX, Sybase Transact SQL, Crystal Reports, CA Unicenter, MS-DOS, Windows NT, Novell Netware

I was a part of the in-house staff providing technical writing services to various clients in the oil and gas industry. Also functioned as the company's computer support tech - installing, maintaining, and repairing the computer equipment in the office Assumed the role of network administrator when the previous network administrator left the company.Software used: MS-DOS, OS/2, Windows 3.1, Windows 95, Novell NetWare 3.12

Dallas/Fort Worth Area

Dallas/Fort Worth Area

Dallas/Fort Worth Area

B. S, Computer Science

Activities and Societies: Concert Choir, University Chorale, Alumni

Information Technology

Activities and Societies: Phi Theta Kappa, 2010