SUMMARY:

Confidential has more than 25+ years of mainframe and Web experience as a Consultant, Project ManagerSenior Team Leader, Data Security Analyst, Senior Programmer/Analyst/Tester, QA/QC Analyst, Business Analyst and Reengineering Architect. Mainframe skills include application systems planning, architecture, design, development, testing, support, maintenance, data and applications conversion, IT auditing, reengineering, business intelligence/ETL, data security. Various web and server tools experience Analytics, Business Intelligence, Data SecurityHis primary expertise in mainframe activities is complemented with experience in Web and client server design and development. Experienced in site and application planning, design structure, content management, security, marketing and business analytics. Previous exposure to Hadoop and Big Data tools.

SKILLS:

Databases: DB2 / SQL / Oracle, PostGres RDBMS / DBMS, SQL Server, Platinum DB2 / DB Tools, Various Web DBMS, IBM OPTIM ( ETL - extract, convert, load, move, compare) MS SQL Server/Mainframe, CICSSmartTest, VSAM / IDCAMS, TELON / IMS / DB2, FileAid / DB2, TeraData DBMS/ETL. IDMS/DataCommLanguages/Tools IBM COBOL II, MICROFOCUS MME, JCL / Procs, HTML, DHTML, HTMLScript, Java, JSPJavaScript, Server Scripting, SAS, VBScript, ASP Software QMF / SPUFI, IMS DLI DB / DC, TSO / ISPF / SDSF, Mainframe Utilities, OS. MVS, JES2 / Z/OS-39,, Xpediter, IBM Debugger, NDM / DirectConnectSPLUNK, MQ Series, REGEX, Strobe, Librarian / PanValet, Endevor, Control-M, VISIO, FTP, ClistDFSORT/Syncsort, EDI, 834 XN12, HDIG, XML, WinSql, Cold-Fusion, UML tools, ChangeMan, Test Director, MSQL2012, Data Studio, Rumba.

Other Skills: Gap and Requirements Analysis, Fault identification, IT Auditor, Load and performance testing and monitoring, Disaster Recovery/Continuance, Dimensional Data Warehousing, Six Sigma training, Informatica review, CA7 Scheduler, Agile/Waterfall/Scrum methodology. Data Security Analyst. Web site/portal planning/design, SEO, Search engine positioning, Internet marketing /promotion, E-Commerce B2B / B2C, Arcplan, Essbase

WORK EXPERIENCE:

TDM/ETL OPTIM Consultant

Confidential, Minneapolis, MN

Responsibilities:

• I was part of a team at a major pharmaceuticals benefits management corporation to upgrade OPTIM from 9.1 to 11.3 on distributed servers with over 200+ tables.
• In addition to upgrade, numerous pending changes for special clients were implemented.
• Custom exits and procs were developed using C++ and LUA. I also developed/documented processes to optimize performance by running multiple converts both concurrent and in order to reduce run times.
• And reducing update processing by changing inserts to native loaders.
• Systems effected are RxClaims, online medical claims processing and RxClinical EMR,electronic clinical and medical records management.
• Optim tools used by team were Optim Designer, Optim Scheduler, Optim Connect, AQT Advanced Query Tool

Database Analyst

Confidential - Minneapolis, MN

Responsibilities:

• As DBA5, on the Enterprise Data Analytics Team, developing ETL scripts/processes for data masking of multiple table/file formats using IBM OPTIM on MS SQL Server.
• Tables are SQL Server, Teradata, Oracle, DB2. Custom exits were developed for corporate business rules.
• CMD and BAT files for users and automation. Coordination with business users/management for demos, tool capabilities, business requirements, platforms, environments, scheduling, and testing. Overall data sleuth.
• Additional task of deduplication of transactions in Customer and Account databases. Resolving issues and proposing solutions for data, security, processes, scheduling and resources.

Tools: are: ETL, Data Scrubbing/Masking/Privatization/Security using OPTIM Test Data Management Solution 11.3.0, Custom Exits/CMD/Bat, Teradata/Teradata SQL Assistant, IBM® InfoSphere™ Classic Federation Server, Oracle, Secure Remote Desktop Connection, NDM/Datamover.

Other tools: Optim Connect Studio, XML data manipulation/transfer, IBM Data Analyzer, Optim Discovery Powershell, Splunk, Unix scripts, Lua programming and functions, Hadoop/HIVE, HTML, Mainframe. Ab Initio.

BI Senior Reporting Solutions Analyst

Confidential - Franklin, TN

Responsibilities:

• Sr. BI Reporting Analyst leverages technical expertise to review, analyze, and evaluate data used in revenue cycle reporting solutions supported by the Business Intelligence team.
• Conduct data analysis to recommend technical approach to business report creation and modifications to support business strategies.
• Requires detailed knowledge of data warehouse, ETL, and cube development methodologies.
• Communicates requirements to technical resources and assures that the designed solution meet business and user needs as well as comply with system best practices.
• Works with business users to resolve conflicting data requirements and will also act as an intermediary between the business users and IT teams to ensure technology architecture and reporting solutions align to achieve mutual desired outcomes.
• Work with management to develop timelines and manage project risks, and develop data quality assurance test plans.
• Developed procedures for acquisition/data mining, securing and modifications of data for test scenarios.
• Support Business Solutions operations, gather and document technical requirements.
• Work with project team of data warehouse staff, ETL developers, Essbase cube developers, Business Objects developers, Microstrategy developers and Arcplan developers while defining and documenting data logic, enhancements, and fixes as required.
• Serve as 1st tier escalation point for data related issues reported and related to Executive Management reports.

Test Data Lead, Data Security Analyst

Confidential - Bloomington, IL - February 2013 to July 2015

Responsibilities:

• Customer Collaborations encompasses all the online and mobile presentations/displays of information to customers, telephony, text, and email communications.
• Also captures Agent and Customer Care Center representatives interactions with customers for analytics.
• Customer Collaborations platforms are mainframe DB2, Postgres, Oracle, MS Server and proprietary vendor repositories System interfaces are with all insurance Lines of Business systems, reporting and analytics applications.
• Project is one of many significant major enterprise projects to build, upgrade and enhance systems for leading digital presence in the insurance/financials marketplace.
• Developed procedures for acquisition/data mining, securing and modifications of data for test scenarios.
• Served as Level 2 Code Reviewer for COBOL II/DB2 programming and PostgGres/Java scripting to verify processing per requirements, identify defects/issues, root causes and provide mitigating solutions.
• Reviewed applications development for process flow, test cases, API simulation and performance.
• Performed data mapping, conversion and transition between legacy DB2 to PostGres platforms based onrequirements and enterprise reference codesets.
• Create reporting scripts via Rumba/IBM Data Studio, and PostGres/PgAdmin for testers, BA's, and users..
• Manage test ids for testers, UAX, onshore/offshore staff, users and test center staff.
• Security - Review scripts and REGEX(regular expressions) for data obfuscation and masking.
• Tools: TSO/ISPF IDE, RUMBA, SQL, DB2, SPUFI, Postgres PgAdmin, Oracle, MSQL2012, IBM OPTIMMove/Access/Compare for DB2, SPLUNK, SharePoint, SAS, Tortoise SVN, UNIX/LINUX, MS Office Suite. Exposure to Hadoop and Big Data environments and tools, exposure to Jenkins for HP ALM (Application Lifecycle Management) Automation.

Technical Analyst / Developer

Confidential - Madison, WI

Responsibilities:

• Systems were Customer Information, Reporting and Analytics. Applications were data driven based on user a authority and data entered.
• Develop PL/SQL programs and Procedures from requirements or based on COBOL II programs.
• Developed templates for use as development models.
• Testing interfaces with other applications
• MS Office used for project support, tracking and reporting (Project documentation and communication).
• Tools: PL/SQL, Tortoise SVN Sovereign, MF Mainframe Express, TSO/ISPF IDE editing.

Senior Programmer Analyst

Confidential - Minneapolis, MN

Responsibilities:

• BAI2, Balancing, Line of Credit, Sweeps and Cycled Balances, Commercial Loans, EDI.
• Develop, modify, test, and deploy COBOL DB2 programs, with extensive use of Stored Procedures.
• Used Endevor for source control, move source, copy members, DCLGEN's, JCL and programs thru the various test regions and into production.
• Use XPEDITOR to assist in testing and debugging of COBOL and Stored Procedures program. Used SPUFI to assist in DB2 data verification. And IBM Move for DB2 / Princeton Softech for DB2 tables replication across platforms.
• Sharepoint and MS Office Suite used for project support, tracking and reporting (Project documentation andcommunication).
• Tools: COBOL II, DB2, SQL and COBOL DB2 Stored Procedures, IMS DB/DC, TSO/ISPF IDE, OS/370/390JCL, Optim Move/Access/Compare for DB2, EDI/Financials, IBM File Manager, SAS, CICS SPLUNK, TMON, MQUT, ECLIPSE MQ Series, SPLUNK, TMON, MQUT, ECLIPSE

Senior Programmer Analyst

Confidential - Madison, WI

Responsibilities:

• Program and test batch COBOL programs using DB2 tables to meet Technical specifications.
• Used Endevor to move copy members, DCLGEN's, JCL and programs thru the various test regions and into production.
• Use XPEDITOR to assist in debugging of batch COBOL programs - Utilize SPUFI to assist in DB2 data verification
• MS Office Suit (Outlook and Excel) used for project support (communication & storing test cases for verification of accuracy by the clients).

Tools: COBOL II, DB2, Blobs/Clobs, SQL Stored Procedures, TSO/ISPF IDE, OS/370 JCL, ClearQuest, Optim Move/Access/Compare for DB2, SAS, CICS, MQ Series, WinSql, SPLUNK, TMON, MQUT

Technical Lead/BA

Confidential - Brookfield, WI

Responsibilities:

• Integrated Cardholder Systems is for mainframe, network, and web credit card systems for bank and branded card issuers.
• Member of the Solutions Definition and Consulting (SDC) team.
• Developed new applications and integration of enhancements to expanding systems including business requirements, project scope definition, and functional design, specifications, development, and test plans.
• Assignments included Credit Card Billing and Analysis, Online Account Decisioning, Risk Level Assessment, Transaction Level Pricing, Multifunctional Transaction Processing, Enhanced Rewards, Online Credit Card Applications, Cash Rebates and Rewards, Electronic statements and reporting options, and Manual Process Automation.

Tools: COBOL II, DB2, Blobs/Clobs, SQL Stored Procedures, TSO/ISPF IDE, OS/370 JCL, ClearQuest, CICS, MQ Series.

Project Lead, Technical Lead/QA, BA

Confidential - Plymouth, MN

Responsibilities:

• As project lead, was in involved in researching application processing functionality, identifying areas for improvement and proposing enhancements for performance, efficiencies, and reduction of operational runtimes.
• As technical lead, was the liaison between client support and application development. In this role, gave insight and advice to client support as to analysis and impact of requested changes and impact to industry security compliance. Interaction with development was to provide scope, detail, and direction.
• QA involvement was in proposing usability enhancements for multiple base and custom internet sites.
• As BA, analyzed new business requirements and developed detailed change requests with impacts, time, and cost estimates. Through multiple roles there was significant interaction with offsite technical staff.

Tools: Cobol II, DB2, SQL Stored Procedures, Oracle, SAS, ColdFusion, Interwoven TeamSite w/MVC (model/view/control) IDE, TSO/ISPF, OS/370 JCL, Control-M

Applications Analyst / DB2 Developer

Confidential - Brookfield, WI

Responsibilities:

• Worked on the APPIX project for enhanced mortgage backed securities processing.
• Roles included specifications analysis, development, testing, implementation, documentation, and support.
• Responsibilities included coordination of development and testing across multiple development groups.

Tools: IBM mainframes, Cobol II, DB2, Changeman, SAS, ITIL, TSO/ISPF, OS/370 JCL, IDMS

Specifications Analyst / IMS DB Developer

Confidential, Brown Deer, WI

Responsibilities:

• Worked on a New Account and Card processing project for Virtual Debit Card project.
• Roles included specifications analysis and documentation, business and process functionality and process flow, and IMS DB developer, testing, and support.
• Responsibilities included coordination of process logistics with outside service vendors.
• Served as support staff on credit card rewards programs development and modifications.

Tools: IBM mainframes, IMS/VS 390, COBOL II, IMS/DB, Endevor, Dumpmaster, TSO/ISPF, OS/370 JCL

Senior Analyst / Reengineering Architect - DB2 Developer

Confidential - Milwaukee, WI

Responsibilities:

• Worked on a Reinsurance Treaty ID Reengineering project for Policy and Treaty Identification.
• Roles included business analysis, architect and DB2 developer, operations logistics and support.
• Responsibilities included analysis, reengineering, and restructuring of legacy Reinsurance systems. Modifications, testing, staging, and implementation activities are in coordination with ongoing team modifications and maintenance.
• Also served as a Telon/CICS/DB2 support developer/tester for the FTP (Financial Transactions Processing) Convertible Coverage and Property Valuation applications.
• This was a highly visible online system requiring significant modifications to multiple (20+) screens and programs.
• Developed results and regression testing scenarios and scripts w/clients to assure integrity and quality.
• Modifications were implemented and ran with no defects.

Tools: IBM mainframes, IMS/VS 390, Cobol, DB2/SQL, DB2, IDCAMS, Abend-Aid, TSO/ISPF, OS/370 JCLSPUFI, DB2-to-DB2 copy/load utilities, Telon, CICS

Senior DB2 Architect/Analyst

Confidential, Madison, WI

Responsibilities:

• Roles included lead developer/consultant for DB2 application design and development techniques, table navigation, process logistics, maintenance, and all support.
• Responsibilities included design and development for conversions, loads, and extractions for 100+ production tables across eight table space regions, and coordination of related operational and scheduling logistics, serving as the clients' direct contact for all DB2 repository questions, issues, and resolution and of DB tables structure/design issues.
• Developed, documented, and taught users ad hoc queries using SPUFI.
• Implemented audit/QA processes and controls.
• Consulted w/DAs/DBAs on data integrity issues, RI faults, detection and identification of DB2 table orphans and dimensional data modeling methodologies and techniques for data warehouse projects.

Tools: IBM mainframes, IMS/VS 390, COBOL, DB2/SQL, DB2, DDL, DML, DCL, IDCAMS, Abend-Aid, QWIKREF

Consultant

Confidential - Overland Park, KS

Responsibilities:

• Planned, designed, developed, and supported multiple Web/Internet sites for clients in the financials arena.
• Responsibilities included site submissions to search engine/directory positioning on high-traffic portals, design and structure of HTML/ ASP/ SHTML/ leader pages.
• Responsible for secure E-commerce, e-mail marketing campaigns, contact management, news/press releases, forums/boards, and business strategies.

Tools: HTML, Javascript, Perl, JAVA, XML, UML