spintreebob
Since Mar 26, 2001
|
|
spintreebob
Since Mar 26, 2001
| |||||
|
| ||||||
Objective: Use business skills in insurance, credit, financial services, retail, wholesale, distribution, transportation, telephony, manufacturing and government and technical skills in data modeling, data administration, analysis, design, performance tuning, relational database, DB2, SQL, SQLPL (some Oracle, XML, MQ, Websphere, Java) to maximize growth and profitability of the enterprise.
Business Analysis Experience:
Lead analyst Robert Schmidt has analyzed business processes; designed and built rule based, data driven and traditional OLTP and OLAP systems. He has worked closely with OO designers on the data-design and data access end. He has re-engineered and enhanced existing systems. He has interviewed executives and participated with business partners in all phases of the life cycle. He has 18 years in IT and MIS. Prior to that he successfully supervised 15 business consultants to re-engineer business operations.
Pro-Active Performance Engineer - Host and DB2 2003-2007 for State Farm Insurance:
-As the person on the several Data teams who was actively involved in ALL of the legacy silos, Robert Schmidt led the effort to develop a single consistent view of data and to define data element datatype, length, allowed values and description to meet functional requirements and non-functional requirements, especially performance.
-Improved database and index design for performance, integrity and functionality
-Improved SQL syntax. Trained developers in powerful full function SQL
-Improved locking strategy to reduce contention and improve availability
-Improved Stored Procedure performance, reusability and functionality
-Improved network performance through redesign of applications and entire systems
-Improved program design and code for performance, reusability and functionality
-Improved JDBC, SQLJ, ODBC, ADO, Websphere, IMS and DB2 Connect access to Stored Procedures, mainframe components and database server.
-Reduced 200+ transactions from 1 to 5 minutes to all under 3 seconds, most under 1 second; mainframe times under .3 second; most under .1 second
Prior to 2003:
-Analyzed and compressed batch from 14 to 2 hours by all types of efficiencies
-Improved procedure logic, data handling and thus response time of batch and online programs
-Redesigned databases, tables, indexes and referential integrity for efficiency and response time
-Trained others in best design and coding of systems, programs, COBOL and SQL
Data Warehouse Experience:
-Designed and implemented data warehouses and legacy data extraction systems for data warehouse; datamart; decision support systems
-Developed business requirements; business domains, data classes and process methods
-Normalized data into atomic objects. Identified independent, dependent and interdependent attributes
-De-Normalized data for performance and for the convenience of shop traditions and requirements
-Re-Defined object and class data types for consistency and performance
-Designed and re-designed relational tables, partitions and indexes to meet business and technical requirements
-Determined which referential integrity was to be maintained internally, and which by external utilities
-Wrote SQL DDL to build, alter and populate relational tables, indexes, procedures and databases
-Trained programmers and technical staff in the best use of SQL, DB2, COBOL II and utilities
-Trained business partners and non-technical staff in QMF, user screens, QA, testing tools and methods
-Converted DB2 databases and SQL to the newest version of DB2. Currently preparing for conversions to DB2 V 9
-Converted IMS, VSAM and flat file to relational DataBase systems
-Converted manufacturing, distribution, insurance, credit, telephony and retail systems
-Analyzed old systems for missing and poor original design that created the need for conversion
-Developed USE CASE situations. Normalized and de-normalized data and relationships
-Designed new systems. Mapped old fields to new fields with methods to insure data accuracy and integrity
-Consolidated large systems from several data centers into one data center with no interruption of business
-Re-engineered programs for business functionality and performance to enable the success of larger projects
TECHNICAL:
-SQL, DB2, COBOL II, TSO, JCL, Strobe, iStrobe, Mainview, Apptune, SMF, DB2-PM, SPUFI, QMF, Fileaid, Xpert, Xpediter, SAS, IDCAMS/VSAM, IMS, MFS, BMP, CICS, and many other mainframe tools and utilities
-MS XP, Explorer, Outlook, Word, Excel, Powerpoint, Visio, Access, XML, HTML, and other workstations tools
Companies
State Farm Insurance. PPE Application Performance - Host and DB2. Write standards and training documents. Consult designers, developers, DBAs in relational database, SQL, DB2, mainframe and gateways to the mainframe. References on request.
Blue Cross Blue Shield Association. Change Control. Advise developers and QA on improvements to meet promotable standards. Compile, Link, promote components to levels of test and production. Chicago. Vy Jackson 312 7/02 to 4/03
International Truck and Engine. Design and implement system testing for existing system of over 50 DB2 tables, hundreds of files, jobs and programs. Warrenville. Bob Koschnitzke 630 753-5580 2/02 to 7/02
Family Taxpayer Network and MITS. Server based relational database. Oracle, SQL*, PL/SQL, DB4, Data integrity. Jack Roeser, Joe Wiegand, Lidia Downs. 847 428-0363. 10/01 - Present. Continuing as volunteer to Family Taxpayer Network.
Conseco medical Insurance. Write specs, re-engineer, install and maintain systems to improve busness functionality and technical accuracy and performance. Interface with business users. Analyze, design, code, test Finalist, LIDP, LFCM, COBOL II, JCL, BAL, SAS, CICS, Strobe, Fileaid, Intertest, respond, Mainframe tools, MS Project, Word, Excel, Powerpoint, Outlook. Support production. Train offshore personnel. Candy Preban. 8/00-10/01.
Kemper Insurance. Analyze, design, write specs, code and test interface from HUON insurance package to statistics system and data warehouse. COBOL II, DB2, Endevor, JCL, BAL, SQL, QMF, SPUFI, Platinum, mainframe tools. Sr DB2 Analyst. Mentored others in DB2. MS Word, Excel, Notes, Powerpoint, Workbench. 4/9-7/00. Steve Gregg 847 320-7502. Karen Wilberg 847 320-3565.
Allstate Insurance. Analyze, design, write specs, code, test new programs, enhance existing programs. Customize HUON insurance package using COBOL II, DB2, Endevor, JCL, CICS, SQL, QMF, SPUFI, Xpert, Fileaid, Intertest, Smartest. Reengineer DB2 table design and COBOL DB2 programs for performance. Sr DB2 Analyst and mentored others in DB2. Excel, Word, Powerpoint, Access. 8/98-4/99. Sam Majeed, Brian Dianis 847 551-2654, Pete Voss 551-2333.
Allstate. For data warehouse metrics system, design a plan to collect statistics and summary data. Design, write specs and implement technical and business solutions. COBOL II, DB2, Endevor, JCL, BAL, PL1, SQL, Fileaid, Xpert, Method1, Toolbox, mainframe tools, Word, Powerpoint. Tain staff in best use of COBOL II, DB2, SQL. Sr DB2 analyst mentored others in DB2, SQL. Trained QA users in QMF, ISPF, testing strategy and test plan development. Although new warehouse and statistics system, it required me to reengineer legacy systems for business functionality and technical performance. 2/97-7/98. Dave Parcels, Dan Joyce 847 667-4150.
Kraft Food. Design, write specs, code, test CICS maps and programs for plant scheduling and inventory management system using COBOL II, DB2, Endevor, JCL, CICS, APS, Intertest, Fileaid, mainframe tools. 11/96-2/97.
Spiegel Catalog. Design, write specs, code, test business solutions and technical efficiencies inCustomer Order Processing System using COBOL II, DB2, SQL, JCL, CICS, APS, Intertest, Fileaid, mainframe tools 5/96-11/96.
Northern Trust Bank. Write specs to reengineer system using COBOL, DB2, SQL, Fileaid, Strobe, Relational Tools, mainframe tools, Notes, Word, Powerpoint. 11/95-4/96.
City of Chicago. Find, fix and test bugs in jobs and programs using COBOL II, DB2, JCL, SQL. 11/95.
Allstate. Reengineer IMS commercial auto system for DB2, SQL, COBOL II, Endevor, JCL, BAL, Fileaid, Toolbox, Visio, WordPerfect. 6/95-11/95. Work closely with business users to design and implement QA system to measure conformanct to requirements, defect level and enhancements needed in XYCOR financial service insurance packages. 7/90-1/91
Illinois Dept of Employment Security. Analyze, write Design/1 specs, Bachman plan for DB2 tables. 5-6/95.
Sears. Analyze, write, install EDI purchase order and inventory management system using DB2, SQL, COBOL II, APS, CICS and mainframe tools. Connect data warehouse to suppliers, shippers, buyers, warehouse, stores, customers, delivery and installers. 5/94-5/95. Bill Kloska, Marjorie Kennedy, Doug Drayton
Discover Card. Reengineer DB2, SQL, COBOL II for performance. Analyze business and technical requirements. Analyze 60 million row tables. Present cost/benefit alternatives. Data model. Normalize, denormalize relations. Redesign tables and indexes. Standardize data types. Write Platinum, DDL, APS, test plans. Train in best use of SQL, DB2, COBOL II for ease of maintenance and performance. 5/93-5/94. Frank Mette.
Kemper. With business partners, design, write specs and code workers compensation audit system for Polaris/PMS. Customize insurance package using COBOL II, VSAM, JCL, Fileaid, Xpert and mainframe tools. 11/92-5/93.
Sprint/Centel. JCL, COBOL II, IMS, MFS screens and programs, Fileaid, mainframe tools. 7/92-11/92 and 7/87-10/89. Customer Service, Billing Systems. Fix, complete screens and programs others lacked skill to complete. Plan and execute data center consolidation with no disruption of production. Assess system needs. Standardize object names. Coordinate staff activity during move. Flawless execution. The allotted weekend disruption did not occur. Participate in team to improve database design and system design for performance and data integrity. Lead credit and collection team of CUBS billing system. Write test strategies, plans, cases and data. Execute tests. Track results. Enhance testing methods with metrics for cost of Conformance/Cost of Non-Conformance
United Insurance. Reengineer and modernize COBOL and JCL for many insurance lines. Designed simplification of the work process and simplification of the system redesign that saved many man hours and enabled the project ot complete on time and in budget. 7/91-11/91
Northwest Airlines. Redesign CICS, DB2 scheduling system for performance, response time. Plan, execute, evaluate QA on complex rules system. Train users and testers in QMF and CICS screens. 1/91-7/91
CNA Insurance. Write and test COBOL programs, IMS, PSBs, PSBGENs for reinsurance system 4/90-7-90. Accounts payable, check disbursement and audit trail system. 10/89-12/89
ASA. CICS, COBOL, VSAM, JCL for group life and health insurance packages and conversion projects. 7/85-7/87
Motorola. Reengineer COBOL, JCL, IMS to reduce nightly batch from 14 to 2 hrs. Analyze, write specs, CICS, IMS DB/DC/BMP systems. Present options to management. Implement chosen alternative. 1/90-3/90. Technical support. Maintain IMS data dictionary and IMS objects (PSB, PCB, ACB, etc.). Implement Change Control process. Enforce standards. Reengineer IMS, COBOL, JCL, sorts in metrics system Datamart for efficiency. Received 2 month Mainframe intensive training in IMS, JCL, mainframe tools. 7/83-7/85
Business experience: Prior to MIS, Robert Schmidt profitably managed credit reporting and insurance consulting offices providing risk management, marketing analysis, loss prevention, audits, investigations, subrogation and skip tracing services. he designed and implemented business process redesigns to improve both saftey and operating efficiency. He specialized in demographics, arson and commercial packages for construction, transportation, manufacturing, retail, hospitality and amusement industries. He hired, trained and profitably supervised 15 consultants and sold their services.
Robert Schmidt successfully managed real estate, construction and charitable groups that rehabilitated inner city housing. He sold businesses as a broker; software, electronics, advertising and consumer products retail and wholesale. He managed retail and wholesale inventories. US ARMY Personnel Specialist, Vietnam. 66-67.
Education
Active in both giving and receiving education.
THE COST TO FIX is a presentation made at professional associations and client QA training sessions at several shops to positive reviews and practical implementation.
Data Design for Performance is a class given to audiences of several technical levels with requests to repeat it.
SQL for Performance is a class given to both designers and developers to understand the power of SQL.
Tutored/mentored others successfully for positions in Data, Applications and QA.
Active participation in MWDUG - MidWest Data User Group and similar groups and in classes of Sheryl Larsen, Dave Buelke, Bonnie Baker, and data specialists from IBM, Compuware, BMC, Quest, CA/Platinum and many other software vendors.
MITS technical school. Oracle Forms and Reports, SQL Plus, PL/SQL
Harper College. Systems analysis and design, database design, operating systems, COBOL, BAL, JCL, accounting.
Motorola U, other employers and professional associations. DB2, SQL, COBOL II, IMS, JCL, tools, utilities, Project Management (Summit, PMH, Foundation(Method/1, Design/1), QA, Test design and methods, System analysis and design, data modeling, database design and implementation.
Roosevelt, U of C, UICC. Business, real estate, architecture, insurance, psychology
Wheaton College. Liberal Arts, political science. 61-64.
Personal References: George and Kristin Kocan, Unix engineer, 630 393-6401 geokcn@juno.com
Gary and Denise TenHoven, Pick engineer, 630 213-6761 gatenhoven@hotmail.com