Senior Architect / Database Consultant Resume Kansas City, MO - Hire IT People

SUMMARY

Skilled IT professional with a passion for learning new systems and staying up - to-date with current technologies.
Core competencies include collaborating with cross-functional teams to deliver solutions, mentoring team members, presenting technical topics, and creative problem solving.
Experienced across a variety of industries including Financial, Manufacturing and Retail.
Recently completed certificate courses in web development and Big Data.

TECHNICAL SKILLS

Database: DB2 for z/OS, MySQL, Hadoop

Languages: SQL and SQL PL, JavaScript, HTML5, CSS, Python, COBOL, REXX, JCL

Development Libraries and Tools: Vue.js, Node.js, TSO, ISPF, CICS, Xpediter, Hive, PigIBM CICS VSAM Transparency, Microfocus COBOL

Hardware: Linux, IBM Mainframe using z/OS or MVS, Windows

PROFESSIONAL EXPERIENCE

Senior Architect / Database Consultant

Confidential

Responsibilities:

Completed JavaScript projects using Vue.js and Node.js frameworks with MySQL database. These projects ran through the entire life cycle from brainstorming ideas through server installation.
Used Agile methodology to complete projects and assignments throughout the Tallgrass School courses.
Learned basics of NoSQL technology using Hadoop and two interfaces, Hive and Pig.
Complete Python programming class through an on-line course.
Evaluated other relational databases through reading SQL for Smarties and MySQL documentation.

Senior Architect / Database Consultant

Confidential, Kansas City, MO

Responsibilities:

Proactively researched issues to improve COBOL program performance with DB2.
Led project teams enhancing processing on a mutual fund transfer agent system. Projects included splitting deposits according to customer direction and sending daily media to separate print vendors. The projects were coded with Enterprise COBOL using DB2 and included CICS programs.
Mentored project teams to develop advanced SQL for major projects including tracking mandatory cost basis and data propagation.
Led team charged with setting corporate standards for SQL development with DB2.

Senior Architect / Database Consultant

Confidential, Kansas City, MO

Responsibilities:

Wrote classes and presentations on DB2 development topics. The presentations were given to local DB2 user groups and the International DB2 Users Group.
Developed and maintained SQL PL stored procedures that install SQL PL to production.
Coded triggers and COBOL stored procedures to verify and enforce data integrity on routing tables.
Researched and tested features in the new releases of DB2. Identified program incompatibilities and initiated projects to correct issues. Mentored associates in ways to use the new features.
Coded triggers on DB2 tables to implement application designs. Wrote utility to generate draft triggers and COBOL macros.
Designed and customized programs generated with the IBM CICS VSAM Transparency tool to migrate business data into DB2 tables from VSAM files and Datacom tables.
Wrote REXX utility programs to enhance research and development processes.

Technical / Information Systems Consultant

Confidential, Kansas City, MO

Responsibilities:

Enhanced CICS COBOL programs to implement college savings plan transactions.
Developed programs to consolidate shareholder accounts held by the same person.
Enhanced COBOL programs using DB2 to track mutual fund purchase dates including a CICS screen to calculate costs with a hypothetical redemption. Batch programs were developed using Microfocus COBOL.