Tony Winter Email & Phone Number

Topeka, Kansas, United States

System maintenance, enhancement and administration of data warehousing system with a mixture of mainframe and SQL Server based tech stacks. Additionally, Tableau Server administration.Technologies: SQL, COBOL, JCL, ISPF, DB2, IMS, SDSF, QMF, SDSF, EasyTrieve Plus, File-Aid, BMC Utilities, DB2 stored procedures, ChangeMan, SBM, Tableau Server, TSM, SQL Server, SSIS.

Lawrence, Kansas, United States

FileMaker Certified developer and consultant building apps that run on Mac, Windows, iPhone, iPad and on the web. A typical project may include maintenance and enhancement of existing database solutions, creation of brand new applications, consulting on database design, performance tuning and optimization or some combination of the above.Technologies: SQL, FileMaker Pro, FileMaker Server, API Integration, JavaScript, MySQL, PHP, HTML, data modeling, data conversions, relational data performance tuning, query optimization and more.

Topeka, Kansas Area

• Built an IMS to DB2 conversion process for group health insurance membership accounting system in support of the Affordable Care Act.• Mapped and built HIPAA EDI transactions, constructed DB2 stored procedures in both native DB2 SQL and COBOL for Java web service consumption, data integrity maintenance, production systems support.• Successfully built the first stored procedure in the history of Blue Cross Blue Shield Kansas that accesses both relational (DB2) and hierarchical (IMS) data in the same executable.• Designed and optimized data warehouse load processes. Technologies: SQL, COBOL, JCL, ISPF, DB2, IMS, SDSF, SPUFI, QMF, SDSF, EasyTrieve Plus, SyncSort, ADF, File-Aid, NDM, MQ Series, BMC Utilities, DB2 stored procedures, ChangeMan, TeamTrack.

Topeka, Kansas Area

• Lead development DBA for ETL team on large scale project to migrate the State’s unemployment system from a mainframe to Siebel environment utilizing SQL Server 2008 databases.• Involved in full life cycle of ETL development from requirements gathering to maintenance. Built ETL and DTS packages to load employment data from employers across Kansas into a Siebel environment on SQL Server 2008 as well as a mainframe environment consisting of both VSAM and DB2 data stores.• Supervised team of third party ETL developers (contractors). Technologies: SQL Server 2000/2005/2008, Management Studio, SSIS, SSRS, SSAS, SQL, T-SQL stored procedures, BizTalk, Cognos, COBOL, DB2, VSAM, JCL, ISPF, SPUFI, QMF.

Topeka, Kansas Area

• Systems development and maintenance of mainframe based group health insurance membership accounting system. Browser based enrollment processing system support and data analysis, performance tuning, reporting. Technologies: SQL, COBOL, JCL, ISPF, DB2, IMS, SDSF, SPUFI, QMF, SDSF, EasyTrieve Plus, SyncSort, ADF, File-Aid, SyncSort, NDM, MQ Series, BMC Utilities, DB2 stored procedures, ChangeMan, TeamTrack.

Topeka, Kansas Area

• Lead tech of development and maintenance team on COBOL/CICS and Natural online and batch social services systems running Adabas. DB2/Adabas administration. Technologies: COBOL, SQL, CICS, JCL, Natural, Adabas, VSAM, DB2, BMS-GT, Roscoe, ISPF, Predict, InSync, Librarian, Xpediter, Predict, InterTest for CICS.

Kansas City, Missouri Area

• Maintenance and development of industry leading mutual fund transfer agent processing system.• Built client specific job streams, report generation, system problem identification/resolution, purges, conversions and various maintenance and enhancement projects for mutual fund clients. Technologies: COBOL, SQL, JCL, ISPF, DB2, VSAM, SDSF, SPUFI, QMF, SAS, CA-DataCom, NLS, File-Aid, Inspector, Xpediter, Quick Start, Smart Edit, EasyTrieve Plus, SyncSort, Move for DB2, NDM, Crystal Reports, various IBM utilities (IEB functions, IDCAMS, etc), various in-house tools and utilities.

Bachelor Of Science In Business, Computer Information Systems

Activities and Societies: Named "Outstanding CIS Major for 1998" - Accounting and CIS Division faculty, Graduated Cum Laude

Education record