CAREER SUMMARY:

A seasoned data processing professional with over 20 years of experience in both mainframe and distributed application development. An innovative problem solver with solid analytical, and interpersonal skills. Experienced in all phases of the project life cycle, including user interface, business and systems analysis and design, development of programming specifications, codingunit and system testing, documentation and user training. In addition to technical skills other strengths include leadership, self direction, reliability, productivity and teamwork skills.

TECHNICAL SKILLS:

Hardware: All major IBM mainframe series, IBM PC's and Compatibles, Ultra Sparc, Power PC, HP3000/9000

Operating Systems: MVS/SP; XA; ESA; 390; z/OS; UNIX/AIX, HP - UX, Solaris; Windows NT/2000/XP/7

Network/Server(s): Windows 2000, 2003, 2005, 2008, 2012; JBOSS

Database: DB2; SQL; IDMS; VSAM; IMS DB; Sybase 10; MS Access Jet; Oracle 7, 8, 10, 11g; SQL Server 2003, 2005, 2008, 2012; UDB 9, Teradata, MySQL

Database Modeling: Advantage Gen; Cool Gen; IEF Composer; Erwin; MS Access, TOAD Modeler

Case Tools: Advantage Gen; Cool Gen; IEF Composer (BAA, BSD and Construction)

Online/Networking: CICS Command Level, IMS DC

Languages: z/OS COBOL; VS COBOL II; COBOL for OS/390; z/OS/JCL; MF COBOL/Server&Net Express; Easytrieve Plus; CLIST; REXX; ISPF Dialog, DOS & Unix Scripting, PowerShell, Ruby DSL

Client/Server: Micro Focus COBOL - Server Express; MS Access 97, 2000, 2003, 2010; Java; VBA; Visual Basic 6.0; ANSI C

Oracle: SQL Plus Command Line; PL/SQL; Forms 4.5; Reports 2.5; Discoverer; Stored Procedures, SQL Developer

SQL(*): Transact SQL(T-SQL), ANSI SQL, Stored Procedures, DTS

Storage: Confidential - OnCommand, SnapManager, SnapDrive, Workflow Automation (WFA)

DevOps: Chef. Ruby DSL, GIT CodeHub, Jenkins

Reporting Tools: Crystal Reports; Cognos 7, 8; MS Access

Desktop: Word; Excel; Powerpoint; Project; E-Mail; Schedule +;

Methodologies: Yourdon, IE - Information Engineering, Waterfall, Agile, CMMI, Agile

Productivity Tools: TSO/ISPF; Endevor; File-Aid; Comparex; Abend-Aid; Panvalet; Xpeditor; QMF; OLQ; SPUFI; Intertest; Syncsort; Iceman; SDF; NDM; AMS; BMC; AQTCA7; RMDS; Softcopy; SQL Programmer; ClearCase; RequisitePro; VI; DTS; SQL Compare; SQL Server Management Studio; Redgate SQL Compare 6; CRON; MS Scheduled Tasks; Serena Changeman; TOAD, CA-ESP

EXPERIENCE:

Confidential

DevOps Engineer/Architect/Project Manager

Responsibilities:

• Lead successful effort to certify chef-client cookbook along with enterprise specific wrapper cookbooks in preparation for enterprise rollout of every provisioned Unix and Windows servers.
• As a senior member on the DevOps Center of Excellence team we onboard teams with a baseline training environmentconsisting of Chef, Jenkins, Codehub, Git and other supporting technologies and documentation. Develop, test, document and demo recommended best practices for using DevOps and tools as they apply to Confidential ’s enterprise.
• Hands on experience building and managing the Database Virtualization team from the ground up to develop multiple requestable service offerings using products from Confidential /Enterprise Service Catalog and Confidential OnCommand storage virtualization suite of products including Workflow Automation (WFA).
• The efforts initially included product evaluation and selection with appropriate
• CBA’s to backup our findings. Several PoC and pilot efforts were initiated to confirm our selection.
• This effort continued into development and rollout to the enterprise.

Skills Utilized: Waterfall and Agile project methodologies, Rally, Oracle DB, MySQL, SQL Server 2005, 2008, 2012, Toad for OraclePowerShell, Ruby DSL, Bash, Chef, Jenkins, Git, Codehub, Artifactory, Office 2010, Win2008, Win2012RHEL6, RHEL7, Confidential, WFA-Workflow Automation

Confidential

Systems Analyst - Data Warehousing

Responsibilities:

• Responsible for systems analysis and quality assurance for new data integration projects.
• Objectives were to consume external/internal data sources into Confidential Oracle data warehouse. In addition to maintaining/enhancement of existing data sources.
• Primary responsibility for this role was data analysis and deciding how to bring the data into the warehouse and do the integrations.
• Utilize SQL to query the data for the data analysis. Write system design/functional specifications. Build data marts and analyze issues with data integrations.

Skills Utilized: Oracle DB, Toad, Oracle SQL, Office 2010

Confidential

Business Systems - Data Analyst

Responsibilities:

• Daily duties will varied based on ever-changing needs but focused around a database transition, document migration and transition from Documentum to SharePoint.
• Evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs.
• Ran SQL queries on an adhoc basis identifying anomalies in the migrated documents and associated metadata.

Skills Utilized: Oracle SQL Developer, SQL Server, T-SQL, MS Access, MS Office 2010 products

Confidential

System Analyst - Developer

Responsibilities:

• Worked through daily logs and service requests tickets to analyze, modify, test and implement modifications to address these production support issues.
• Working as a team and individual contributor providing solutions to identified problems.
• Analyzed and created DML statements providing database data and referential integrity. Insuring that expected results are achieved through a formal testing strategy.
• Contributed in knowledge transfer sessions amongst technical and business communities sharing knowledge in the areas of data modeling and SQL DML statements

Skills Utilized: Oracle DB Objects via Toad Oracle SQL & Modeler, SQL Developer, Java, Scripts, Websphere MQ Explorer, CA-ESPLinux O/S, MS Access, WinSCP, JBOSS

Confidential

Software Engineer - Analyst - Developer

Responsibilities:

• Provided technical solutions for new and existing interfaces on varying platforms seeking best possible client solutions utilizing their existing platform requirements.
• Supported client ticket system issues related to implementations of EASYGroup and Confidential Advance suite of products.
• Maintained all Confidential Advance to EASYGroup interface modifications to dozens of external clients, providing technical solutions to Prospective Payment System - Confidential updates and configuration modifications.

Skills Utilized: MF COBOL/Server Express, Unix O/S, Unix Scripts, ANSI-C, SQL*Plus, EASYGroup - Confidential, Confidential Advance

Confidential

Systems Analyst - Developer

Responsibilities:

• Performed system level impact assessment for a systems conversion and sun setting.
• Analyzed, designed, coded and performed end to end systems testing for modified programs.
• Performed analysis, data modeled and provided development options with costs for a database conversion from IMS hierarchical database to a SQL Server relational database.
• Reconfigured ASG ViewDirect 4.2 document spooler and document server to accept text and postscript data sources.

Skills Utilized: T-SQL, SQL Stored Procedures, DOS Batch Scripts, COBOL, IMS, Eztrieve+, CA7, MS Access.

Confidential

Data Engineer - Database Developer

Responsibilities:

• Provided development support in a Mainframe, SQL Server and IBM UDB environment.
• Manipulating data, modifying databasesscripted batch files in support of the development teams objectives.
• In addition, ran daily and weekly Java, SQL and UDB applications in support of the organizations web applications and resolved data issues as they were identified.
• Provided technical support in the development of a metrics reporting system for management.
• This involved providing use case scenarios documentation and technical requirements for the development of this SQL Server stored procedure initiative.

Skills Utilized: T-SQL, SQL Stored Procedures, DTS, UDB 9.0, COBOL, Java, MVS DB2 8.0, VSAM, DOS Batch & Unix Scripts

Confidential

Information Engineer

Responsibilities:

• Participated in the high level design for MI BI applications including selection of data sources and determination of whether the application will become part of the PLW publishing layer.
• On a project basis performed source to target data mapping and gap analysis along with logical data modeling and publishing layer modeling.
• Access analysis and input into physical database and ETL design providing opportunities for seamless integration within existing data marts.
• Interface with business customers, S/A’s and MI design teams to gather and clarify data and usage requirements along with defining testing strategy, implementation approach and planning activities.

Skills Utilized: Teradata, Erwin, Cognos 7.4, 8, MS Access, SQL Server

Confidential

Systems Analyst - Senior Developer

Responsibilities:

• Elicited requirements from business users to compile functional specifications. Performed systems analysis, design and development of a data mart to support the MIS requirements. COBOL, DB2 SQL and utilities were used to accomplish these tasks.
• Maintained a full suite of project artifacts including business and functional requirements, systems analysis, peer code reviewsrequirements, creating test plans and writing/running automated test scripts to pinpoint software defects, track bugs, close open defects and validate functionality.
• Assisted in the development of Online and Batch procedures using Advantage Gen.
• Designed and developed a complex interest calculation program using COBOL/DB2 SQL, Several attempt were made to develop this process with several peers stating that it could not be done.
• Upgraded Filenet IDM and Capture desktop and server software to the newest versions, along with the daily maintenance and support of five (5) scanner workstations using Filenet with a custom VB UI.

Skills Utilized: DB2, QMF, SQL, COBOL, VSAM, IMS DB, TSO/ISPF, JCL, CA7, VB 6.0, Advantage:Gen, FileNet Capture