Synopsis Resume of:

Robert M. Sather

630-***-**** (Cell)

acxrpx@r.postjobfree.com

** ***** ** ******** ***********, Data Analysis, and Business Analysis

Roles and Responsibilities:

Direct interaction with Business Owners, Middle Managers, Internal and External Business Clients, Actuarial Scientists, Data Architects, and Database Administrators.

Custom Database Application Software Developer.

Experienced in virtually every IT Role; Project Management, Business Analysis, Project Lead, Technical Lead, Application Database Developer/Modeler, Data Analyst, and Quality Assurance.

Database Environment Manager supervising 5 resources, Mentoring Colleagues, and Partnering with Offshore contributors.

Professional Summary:

Senior Data Consultant originating in DB2 (1988-2013), SQL Server (2005), Teradata (2013-14), Oracle (1993-2016), and MS Access 2013 (2016). Business Insurance Analyst (1998-2011).

Technical Accomplishments:

Requirement Gathering, Data Definition, Defining Business Rules, and Use Case Specification. Design and Development of Application Solutions, Logical Data Modeling and Physical Database Design, Data Analytics, Performance Tuning, Designing and Developing Relational Databases objects (Tables, Views, Triggers, Packages, Procedures and Functions), Data Migration/Transformation, and Population (ETL), Quality Assurance Environments Management, Data Scripting, Unit Testing, Integration Testing, System Testing, and Implementation.

MS Access 2013 Database Design and Application Development storing Inspection Images (BLOB).

Teradata Database (Version 14) Developer/Modeler utilizing TDA and BTEQ Designed and Developed Tables, Views, and Stored Procedures.

Oracle Database (versions 7.3-11g) Developer/Modeler Designed and Developed Tables, Partitioning, Views, Materialized Views, Packages, Stored Procedures, Functions and Triggers utilizing Toad, SQLDeveloper, and SQL*Plus, Oracle PL/SQL, External Tables, CLOB Export/Import, SQL*Loader, Unix/Linux, KSH Scripting.

Microsoft .Net C#, XCOMNT

DB2 (1987-2013 versions) QMF, SPUFI, CICS, COBOL II, COBOL, XPEDITER, Microfocus COBOL, XCOM, TSO, ISPF, SAS, Easytrieve Plus and IDMS, Microfiche.

Personal:

High Emotional Intellect demonstrated in strong communication and engaging leadership skills.

Critical thinker and creative solution provider.

Mindful Yogi living a healthy lifestyle enjoying self-imposed challenges. Golf enthusiast.

Application Business Experience:

Accounting (General Ledger): Kemper Reinsurance, Trustmark Companies

Accounting (Receivables/Payables, Escrow Accounting): Sather Insurance (Brokerage)

Actuarial Science: Allstate International, Kemper Insurance Company

Banking/Trust: JPM Chase, The Northern Trust

Credit Card Processing: JPM Chase, Novus (Discover) Card, Sears Credit Corp

Construction Codes Enforcement: B & F Construction Code Services, Inc.

Consumer Feedback: Kemper Insurance Company

Fraud: JPM Chase

Insurance (Property/Casualty, Life, Health, Reinsurance): Allstate Insurance Company, Trustmark Companies, Kemper Insurance Company, Kemper Reinsurance

Pharmaceuticals: Abbott Laboratories

Regulatory/Surveillance: Chicago Stock Exchange

Sales Experience:

Insurance Sales: Illinois Licensed Insurance Broker 1980-1991 (Property, Casualty, Life, Health)

Professional Employment and Contracts:

B & F Construction Code Services, Inc. Elgin, IL 02/19/2016-04/12/2016 (Full Term Contract)

Microsoft Access 2013 Database Modeler/Developer

Sole IT Resource Fulfilling EVERY Role; Business Analyst partnering with Business Owner, Master of Inspection Codes, Lead Field Electrical Inspector, Business Client; and End Client; ComEd.

Database Modeler/ Developer Designing Inspection Quality Assurance Schema including Inspection Entry and Reporting in MS Access 2013.

Inspection metrics documented in Pivot Reports. Inspection Violations captured in photographs stored in BLOB column. Inspection failures and successes traced through Meter Address Reports.

ComEd installing 4.2 million Residential Smart Meters, requiring accredited Quality Assurance Inspections performed by B&FCCS.

Computer Aid, Inc. Chicago, IL 10/26/2015 – 02/18/2016 (Full Term Contract)

Oracle 11g Senior Database Developer

Oracle 11g PL/SQL Developer of custom modular stored procedures packages to communicate Licensing Application Status to the City of Chicago Small Business Consultants, Zoning and Licensing Inspectors, and Respective Small Business Licensing Applicants. Automation of Business Applicant’s pertinent data with various HTML Email Templates (CLOB) in order to expedite communications required in the workflow process for Small Business Licensing in the City of Chicago.

Chicago Stock Exchange Chicago, IL 05/20/2015 – 08/21/2015 (Full Term Contract)

Oracle 11g Senior Database Developer

Oracle 11g PL/SQL Developer of custom highly tuned real-time, complex and modular stored procedures/packages to populate and maintain a new in-house developed SNAP™ Auction Trading Database and On-line Application for Regulatory Monitoring and Enforcement as mandated by the Securities and Exchange Commission.

Develop processes to regulate specific business rules used to identify illegal trading by firms and brokers. These procedures were used to maintain the database, gather statistics, and pass data to a Java based Web Application (PL/SQL Stored Procedures, XML, and VAX). Toad, SQL*Plus.

JPM CHASE Chicago, IL 09/18/2013 – 09/17/2014 (Contract Fully Extended)

Teradata Database Developer/Modeler – Data Warehouse

Developed Teradata Tables, Views, and Stored Procedures for ETL Processing within Global Commercial Card Data Management. Merchant Card Acquiring Bank Transactions, and related Data Stores housed in a Teradata Data Warehouse Environment (CCDW) viewed through a Business Objects Universe.

User Defined Business Application conversion project to transform Business Analyst Desktop Applications to a Production Level Environment. Business Applications: Master Card Fraud Events and respective transactions, HR Employee and Department Hierarchy.

The Northern Trust Chicago, IL 01/30/2012 – 7/31/2013 (Contract Fully Extended)

Oracle-DB2 Senior Database Developer

Responsible for Enhancements/Modifications to Unix-Linux (KSH) Oracle, Mainframe COBOL II /DB2 and JCL of Internal and External Data Feeds Populating Oracle Databases (ETL: SQL*Loader/External Tables) for Client Portfolio Portal Applications: Wealth Passport and Private Passport.

Data Integrity Project resolved Data Discrepancies on disparate Relational Database Systems and latency issues observed between Monthly Reports and their Portal Applications employing Composite Virtual/Federated Database.

Linux and Oracle 11g Upgrades.

Allstate Insurance Company Northbrook, IL 10/08/2002 – 08/01/2011 (Employee RIF after 9 Years)

02/17/2000 – 10/07/2002 (Contract to Employment)

Oracle-DB2-SQL Server Application DBA/Senior Developer/Modeler

Agency Applications DBA, Business Analyst, Technical Lead, Database Developer/Modeler providing software solutions for a myriad of Applications, most notably all Oracle Objects (Tables, Views, Triggers, Procedures, and Functions), for Exclusive Agent’s Incentive Program (Bonus and Travel) since inception in 2005. Agents Interactive Web Application Dynamically Projecting Bonus and Incentives on Business Sales Metrics. Sales Metrics Ranking Report.

Agent’s Interactive Web Application was originally developed in Microsoft.Net and replatformed on IBM Portal J2EE. Redesigned and created new Oracle Objects for a Service Oriented Architecture (Web Services) in less than 3 months.

Collaborate with Business Clients during Requirement Gathering, Data Definition, Defining Business Rules, and Use Case Specification (UML Diagramming).

Modeled and Developed Oracle Transactional, Analytical, Authorization, and Look-Up Tables.

Designed and Developed Agency Distribution Oracle Backend Processing for Web Applications.

Bonus and Incentive Publication Application releasing Agents Monthly YTD Actuals as Authorized by Business Clients.

Designed Agent Incentive Interpolation Tables. Proposed Quality Assurance Backend Interpolation Testing, avoiding clicking through Interactive Web Application to test formulas for all possible values, as a repeatable cost saving testing methodology.

Leveraged Oracle’s Analytical Ranking Function to Validate Proper Range Values in Agency Distribution Incentive Metric Tables.

Export/Import, SQL*Loader, and Scripting were utilized for Data Migration and population efforts.

Designed and Developed Quality Assurance Test Data Environments Currency Process (ETL). I mentored the newly created Agency Environments Team to accept this responsibility. Mentored Agency Environments Team on Oracle Production Installation Scripting.

Engaged Enterprise Level Data and Domain Architecture Groups to address performance issues experienced in Service Oriented Architecture based on Project Schema Boundaries.

Oracle Gateway leveraged to Materialize View of DB2 Region, Territory, and Market Agent Structure.

Oracle Stored Procedures and Functions Tested utilizing Toad, SQL Developer, and SQL*Plus Scripting.

Visual Explain utilized to tune Queries.

Erwin leveraged to explore existing schemas.

SQL Server Data Modeling and T-SQL Code Reviews.

Extensive DB2 Utilities Experience including Image Copy, DSN1COPY, Recovery, Reorg, Repair, Runstats, Check Data/LOB, and FASTLOAD.

Designed and authored .Net Services to Publish and Subscribe Messages from Seebeyond/TIBCO and XCOMNT for Windows Server Solutions.

Proprietary Knowledge transitioned to Onshore and Offshore Resources in an effort to reduce Payroll Expense.

Allstate International Hoffman Estates, IL 09/21/1998 - 10/08/1999 (Contract)

Oracle-DB2 Developer/Modeler – Data Warehouse

Allstate International: (Automobile Data Warehouse): Business Actuarial Consultant and Database Developer/Modeler, exclusively responsible for the Oracle Pricing Data Mart for Germany (“HURON” 3.6) and Japan (“HURON” 4.0.2). “HURON” is a fully integrated International Insurance operational system (DB2/CICS).

DB2 Operational system analysis was performed writing SQL (QMF) to identify data source attributes.

DB2 Extraction-Transfer-Load (ETL) was accomplished via Legacy Data Mover (LDM) and SQL*Loader to populate Oracle atomic tables via XCOM.

Oracle Packages, Stored Procedures, and Functions (SQL*Plus Scripting) were created and invoked by Korn Shells using XCOM on the HOST in the Production Environment.

Actuaries utilized BrioQuery to establish the Earned Premium formula. Actuaries performed analysis writing BrioQueies, utilizing the Pricing Marts and Claim Marts.

Developed the relationship between the Pricing Data Mart and Claim Data Mart for current rate level analysis, establishing loss ratios.

Business Analyst performing HUON Data Analysis in the creation of the Pricing, Finance, and Marketing Data Marts.

Trustmark Companies Lake Forest, IL 03/30/1998 - 09/13/1998 (Contract)

DB2 Database Developer

Trustmark Companies (Treasury): Year 2000 conversion/upgrade of the GEAC (formerly known as McCormack and Dodge) General Ledger package (CICS).

Analysis along with programming, JCL, and utility modifications concluded with implementation. Installation of package upgrade required enhancements/modifications to the client’s customized General Ledger software.

Software languages/utilities: CICS, DB2, QMF, SPUFI, COBOL II, Easytrieve Plus and IDMS.

Novus Services, Inc. (Discover Card) Riverwoods, IL 11/21/1997 - 03/27/1998 (Contract)

Oracle Database Developer

Novus Services, Inc. (Credit): Employing MFCOBOL/Oracle under UNIX, enhancements were made to the Private Issue brand of the “Card Member Posting and Billing System”.

New contract terms level activated provisional rate for delinquent accounts. Cash Back Bonus option was capped by restructuring incentive tiers.

Analysis, design, detail specifications, programming, testing, and implementation were performed for those enhancements.

Production problem analysis and resolution was also performed.

SEARS Hoffman Estates, IL 07/09/1997 - 11/20/1997 (Contract)

DB2 Database Developer and CICS

Sears Merchandising Group (Credit Card): Utilizing APS in an Real-time environment (CICS), developed, maintained, tested, and implemented a major enhancement to the Customer Credit Information System (“FOCIS”). This promotional program known as "REWARDS" allows Sears marketing department to analyze a customer incentive program based on various point tiers in five different U.S. markets.

Software languages/utilities: CICS, DB2, QMF, SPUFI, COBOL II.

Abbott Laboratories Abbott Park, IL 04/12/1993 - 06/25/1997 (Employee 4 Years)

Oracle-DB2 Database Developer/Modeler and CICS

Abbott Laboratories (CMIS): Authored SQLWindows/Oracle Direct Marketing Application of Pharmaceutical Sampling to Physicians.

Authored SQLWindows/Oracle Promotional Budget Tracking Application of Pharmaceuticals to Physicians. Designed and created Oracle Data Stores. Oracle PL/SQL Tuning.

Authored an application ("GVR") employing APS/DB2, both Real-time and batch, establishing pharmaceutical prices and government reporting.

Authored CICS/DB2 applications and DB2 stored procedures (COBOL II) for (“IPA”) rebates to managed health care groups. DB2 Utilities developed for various Application Systems.

Created database structures (DB2) for multiple application systems.

Kemper Insurance Company Long Grove, IL 03/02/1987 - 04/09/1993 (Employee 7 Years)

DB2 Database Developer/Modeler and CICS

Kemper Insurance Company Management Information System (MIS): Authored CSP/DB2 - CICS (Real-time) applications for the "Consumer Complaint System" and the "Germ Producer Experience" project.

Designed and created production database structures for “Consumer Complaint System”. Supervised 3 programmers as technical lead, providing clients with personal lines insurance exposure information in report and record format.

Designed systems and authored applications involving auditing and accounting functions. DB2 Ad hoc Reporting on Massachusetts Personal Lines Business for divestiture purposes to Company Officers.

Automated Reinsurance and Ocean Marine accounts receivable loss information systems for the financial accounting department.

RACF Coordinator, authorizing and auditing MIS Application Access.

Microfiche Report Programming of MIS Master Kind Controls for Underwriting Exposure and Actuarial Analysis.

Sather Insurance Marketeers Palatine, IL 05/12/1977 - 02/27/1987 (Contract)

Application Designer/Developer/Modeler, Insurance Broker

Designed and authored an Independent Insurance Agency Information System written in Basic 1.0 on an IBM PC XT: Accounts receivable and payable, Escrow Account management, invoicing, premium trust credit reporting, account current discrepancies, comparing earned premium against premium paid, renewals and suspense items.

Illinois Insurance Producer Licensed in 1980 (Property/Casualty, Life/Health), lapsing in 1991.

EDUCATION:

William Rainey Harper College Palatine, IL

Completed 36 hours in Computer Science

Marquette University Milwaukee, WI

Degree: Bachelor of Art - Major: History

Contact this candidate