PROFESSIONAL SUMMARY:

• More than 17 years in Information Technology. COBOL, CICS, DB2 (Stored procedures), IMS Datacom DB/DC, IDMS, SQL Server, Cross Platform, .Net and Data Warehouse Technologies; Delivering IT Projects through the entire SDLC. Process reengineering, Multi - Tasking, Troubleshooting, Problem Solving Abilities with Systems/Applications/Data Conversions, New Design/Development, and Enhancement/Maintenance.
• Performed Business and Systems Analyst Roles, from Requirements Gathering process thru creation/completion of SRS &Technical Design Documents (TDD).
• Pseudo Coding and conversion of main-programs and sub-routines written in COBOL, Assembler, REXX/CLIST/Unix Scripts and others complete with document artifacts and project plans.
• Interaction such as JAD session, Status and Agile/Scrum type meetings with stakeholders, and all interdependent resources (internal/external third party affiliates etc.).
• Setup, Monitored, and Managed Project Issue Logs as necessary. Worked to Identify, Prioritize, and Resolve Issues.
• As a Team Lead, Created Change Management, Communication, Procurement, Quality, and Final Project Plans for numerous projects.
• Versatility in using client’s SDLC/Testing methodology/approach, Analyzing Functional, Business, and Technical specifications producing Artifacts such as: Project, Communication, Risk, QA, Test Plans, Use/Test Cases/Scripts, Traceability Matrices, Test Summary, Auditing/Reporting, KPI’s, Pareto, Swim-Lane, Fishbone, Wire framing, Burn-down, Field Mappings, ERD’s, Flowcharting and numerous other charts/documents/reports.
• Worked with various API’s/Network Files Systems.
• Experience with mainframe DB2 CICS/COBOL/SQL Stored Procedure back-end with .Net front-end wrapping SOA Web-Services such as MQ Series/Message Broker/XML EDI into certain portions of various applications.
• More than 6 years of Financial industry experience, delivering projects within the Consumer Loan, Deposit Pricing, Portfolio Accounting Systems, PCI and other areas for companies .
• Performed Legacy Infrastructure Analysis (Hardware & Software) and Created an Overall Elimination/Conversion Project Plan. The overall Plan consisted of several Smaller Plans providing for a Prioritized, Organized, and Streamlined Cutover. Each plan contained a Timeline, Task, Estimate, Risk Evaluation and Management Plan, Communication, and QA Plans, Dependencies, Transition States, Milestones, Expected Number of Resources, and a Critical Path Analysis.
• Completed several Application Migration Projects from Legacy OS/390, IMS, DB2 Mainframe and OS2/2, Databases, to/from RS/6000, UNIX, DB2, MS-SQL Server, INFORMIX Databases as a Project Leader with 7-12 direct reports.

TECHNICAL SKILLS:

Databases: DB2, IMS, Datacom/DB, IDMS, SQL Server 2000-08, INFORMIX Star/Snowflake Schemas, ACCESS, and Redbrick.

Data Warehousing/Architecture: Performed Process and Data Modeling and have an in-depth knowledge of Relational Database Theory and Concepts. Use of ETL tools (when available) and or have had to write in-house tools to accomplish the same things. Experience with Unix (AIX), SQL Server 2000-8, DB2, IMS and INFORMIX, Built Star and Snowflake Dimension based DW’s for POS, Sales, Forecasting, Customer Relationship Management (CRM), Retail, and Production Planning applications, I understand the differences between Primitive and Derived Data with an emphasis on the Architectural Data-Driven Environment or CLDS vs. SDLC.

Tools: Microsoft Project, FileAid, JCL, SyncSort, SPUFI, QMF, EzTrieve, DYL260/DYL280, xPeditor, Changeman, ISPF, SDSF, WorkLoad Manager, Endever, Brio/SQR, Visual Database Tools (i.e. Database and Query Designer, DTS, T-SQL, SSIS, SSRS, BIDS, Analysis Services, Source Code Editor), Crystal Reports, Query Analyzer, WebSphere Msg Broker, File-Aid, xPeditor, VISO, EXCEL, WORD, I Have Written a fair number of In-House Tools for Performance Measurement, Resource Productivity, and Reporting.

Software, Com, Objects & Design, Operating Systems, & Hardware: SOAP/SOA, Web-Services: MQ Series/Message Broker 6, VB 6, HTML, JavaScript, Centura Windows, Embedded C, Brio/SQR, Crystal Reports Access, MS Project 98/2000, SQL, VB Script, UNIX SHELL Scripting, ASP, MQSeries, WebSphere Msg Broker 6, REXX, COBOL I/II, CICS, Assembler, TSO/ISPF, ADO, ADO.NET, OLE, OOAD, OOP, UML, MTS, SOA, OLAP, Reuse, RAD, UNIX (AIX), OS/2, Windows 95/2000 thru Vista, IBM RISC 6000, PC (Client, Database, and File Servers), IBM AS/400, and IBM 3090’s.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Software Consultant

Responsibilities:

• Analyzing, and documentation of Data Elements in COBOL, Assembler, and Web Service Modules within the Customer/Account Information, Consumer Loan, Time, Deposit, and Trans24 application areas.
• Linking Data Migration Elements in Rational for Release 3 as well as writing
• De-conversion programs for Release 1 for Consumer Loans.
• Web Service API’s, MQ, DB2, Excel, Agile, Waterfall, SharePoint and Rational/Jazz Team Server.

Confidential. Burbank, California

Sr. Software Engineer/Consultant

Responsibilities:

• As a project lead with a team size of 4 Pa III’s Analyzed various application functionality and copybooks/copy-code, DB2 DCLGENS, DB2 Stored Procedures, CICS online, Batch and sub-routines for a 12-month flex/database conversion project expanding certain fields in size and/or type.
• Utilized COBOL, CICS, IMS, DB2, Stored-Procedures, XML, REXX, JCL, VSAM, Q/I/SAM, Assembler, Endevor, xPeditor, Workload Manager (WLM), TSO, ISPF, DB2, SPUFI, QMF, and Explain Facility.

Confidential, Covina, California

Sr. Software Consultant

Responsibilities:

• Created/modified CICS, COBOL programs with statistical and record counts to verify and report results with database control total/file updates.
• Maintenance and enhancements of tax settlement processes from desparate methods including Pre-auths/authorizations, Recon, POS/Credit Card Payments/Refunds etc.
• Modified stored-procedures on backend and .NET Front-end edits.
• Converted 123 SyncSort reports and File Transformations to EzTrieve as files were converted to DB2.
• Creation of test scripts and Performed Tests Verifications using formatted reports and available utilities creating, comparing/proofing Test Cases to Requirements/design and Results ensuring proper approvals through each testing phase (volume, regression, UAT etc.).
• Utilized COBOL, CICS, DB2/SQL/XML, Web Services, REXX, JCL, VSAM, Q/I/SAM Assembler, Changeman, xPeditor, Workload Manager, JCL, TSO/ISPF, DYL280, Eztrieve, QMF, SPUFI, SyncSort, ASP.NET on front-end edits.

Confidential, Burbank, California

Consultant

Responsibilities:

• I was brought into troubleshoot a problematic payroll application query problem working with COBOL, CICS, DB2, XML, REXX, JCL, VSAM, Q/I/SAM Endeavor, xPeditor, Workload Manager (WLM), TSO, ISPF, QMF, Librarian, DB2, Explain Facility, SQL Server 2008, SSIS, SSRS, SSAS.
• Optimized more than 800 queries cross platform/database queries and modified/tested 350 COBOL and CICS programs.
• Some queries were DB2 Stored procedures while others were SQL Server. EzTrieve, REXX, QMF, SPUFI were also used.
• Work performed from query identification, evaluation, remediation, testing and implementation phases.

Confidential, Jacksonville, Florida

Sr. Application Developer

Responsibilities:

• I came in as a developer to troubleshoot problems with secure transmissions as well as financial transactions that were coming in (external vendors) as one type of transaction, however was not reconciling to what the SEC was stating it was, Researched programs and applications to find out why transactions were not being reconciled, making appropriate recommendations to what programs needed to be changed and or re-written.
• I also served as a Project manager for Inventory Control Systems (House account reconciliation system of external 3rd party incoming SPAC files)
• Responsible for project tracking, schedule creation, timelines, deadlines, assignments, and daily support of the system, Troubleshooting (hardware/software, resource issues etc), SharePoint admin/power-user: configure, maintain, and post project content for Enterprise.
• Performed design requirements for DB2 Stored Procedure project. Using File-aid RDX setup test data subsets maintaining RI and AR relationships, and streamlining the migration test path process.
• Used SEI, and Six-Sigma, methodologies within a CMM level 3 shop. COBOL, DB2, CICS, IMS, ISPF, MVS TSO/JCL,VSAM, QSAM, EzTrieve, Assembler, Endeavor, Librarian, SPUFI, DFSORT, Workload Manager (WLM), RUP and SharePoint and Clear Case Tools, with Mainframe DB2 Stored-Procedures being called from a .NET Front-end, NDM and FTP for file transfers.

Confidential, Jacksonville, Florida

Sr. Software Engineer

Responsibilities:

• Performed Design, new enhancement and maintenance of Deposit Pricing, Operations & Promotions (DPOP) System.
• Responsible for creation of DB2 Stored Procedures, Batch file and email transmissions using NDM and or FTP and utilizing: COBOL, DB2, CICS, ISPF, MVSTSO/JCL, Assembler, Changeman, SPUFI, SYNCSORT, Workload Manager (WLM), RUP and Clear Case Tools, with Mainframe DB2 Stored-Procedures being called from a .NET Front-end.

Confidential, Jacksonville, Florida

Sr. Software Engineer

Responsibilities:

• Responsible for Requirements Gathering (for SRS & TDD), Design, and Build of new enhancement and maintenance of Regular Business Management System (RBMS), Managed Healthcare System (MHS) and Consumer Information Platform (CIP a Tier-1 application).
• Projects included Member Eligibility History, Contract Benefit Period, Medical Discount Card and maintenance of legacy Billing systems (insured, insurance company, and MCS/MPS CMS Claims Adjudication/Billing process systems) converting (ETL) of IMS database data to DB2 data; worked directly with correcting all types of rejected transactions due to eligibility issues, unauthorized services, provider credentials, and medical necessity issues and more).
• Created ad-hoc reports on Government/FEP programs such as: BCBS Blue-Vision, CM/CC, Medicare Advantage, recon reporting on Blue-Vision journal entries, FEP budget requests and business plan impacts. Update all documentation from the SRS/TDD thru Test-Cases/scripts, and implementation/turnover documents as needed.
• Creation of test scripts, conducted testing from regression thru UAT using HP Extreme Dialogue.
• COBOL, DB2/Stored-Procedures, IMS, ISPF, MVSTSO/JCL, Control-M, Endeavor, SPUFI, SYNCSORT, NDM/FTP, VSAM, Crystal Reports, SOAP/SOA, MQ Series, XML, RUP and Clear Case Tools, Clarity.