SUMMARY

• I have 18 years of diverse progressive experience in Information Technology, with emphasis on Business Analysis and technical knowledge. Expertise in working with Data/Business Analysis, Business Processes, Data Process Models, Data Flow Diagrams and Business Requirement Documents (BRD’s, FRD’s and TRD’s).
• Data Analyst while performing SQL Queries within a SQL Server 2008 and in a Mainframe environment (z/OS MVS, AS400) which utilizing FTP/SFTP, NDM, ETL, Teradata, Metadata, DataStage, EXCEL, and I have written over 10,000 SQL Queries.
• Expertise in Data/Business Systems Analysis and Requirements Management.
• Strong analytical, problem - solving and communication skills with particular emphasis on clear, detailed Business Requirements and Functional Specifications, as well as reports for management.
• Team player, result-oriented, fast learner, excellent communication skills with strong research capability.
• Direct responsibilities include experience with requirements gathering, planning, organizing, and Change Management/Request.
• Experience in all phases of Software Development Life Cycle (SDLC) aspects.
• Experience in creating business process flow diagrams.
• Experience in developing and writing functional business requirements and process flows.
• Experience in participating JAD sessions for project definition involving analyzing requirements, creating prototypes, user interface.
• Experience in Business Process definition, Risk Analysis, and Use case Analysis.
• Developed design and functional specifications and produced deliverables related to the projects assigned.
• Experience in Business Analysis using tools such as Functional Flow charts, Check sheets, Use Case diagrams, Workshops and Brainstorming Sessions.
• Extensive exposure to Rational Unified Process (RUP) methodology including UML.
• Experience in creating test cases.
• Experience with User Acceptance Testing (UAT) & release skill sets
• Developed use case diagrams, sequence diagrams, state diagrams and activity diagrams using UML to make users and developers understand the system.
• Was also responsible for point-to-point testing with outside clients. In part was also responsible for functional specifications, mapping requirements, business rules, Boundary value analysis, technical specifications, Black box testing, Cross functional testing, Pair wise testing, Decision table testing, Use case testing, Clear test, SMARTTEST, test scripts, system testing, intersystem testing, user acceptance testing, and implementation, while acting as Project Leader on many assignments, utilizing OS/390, z/OS, MVS, COBOL, DB2, SQL, QMF, XML, Oracle, Sybase, SPUFI, VSAM, BMS, CICS, INSTALL 1, JCL, DataStage, MQ Series, MQSI, EDI X12, and Stored Procedures

TECHNICAL SKILLS

SOFTWARE: JCL, VM/CMS, XPEDITER, INTERTEST, ENDEVOR, FILE-AID, TSO/ISPF, FTP, DITTI, SMARTTEST, MMIS, RAMIS, EASYTRIEVE PLUS ROSCOE, SMS/DMI, CA7, ABEND-AID, CICS, VSAM, INFOHUB, MQ SERIES, EDI, ETL, JRun, Panvalet, GRAPEVINE, DB2 CONNECT, SAP, DB2, SPUFI, QMF, STORED PROCEDURES, UML, XML, UAT, Net Express, PVCS, Oracle 8i, SQL Plus, RUP, VMS, Open VMS, Changeman, DML, DOS, MS Word, Excel, PowerPoint, Access, Visio, and Data Modeling.

HARDWARE: IBM 3090 OS/390, MVS, z-OS, HP, UNIX, VAX 11/410/6000/750 and DATAPOINT

LANGUAGES: VS/COBOL/COBOL II/MVS COBOL (LE)/390, dBASE IV, CICS, SAS, RAMIS, MICRO FOCUS COBOL, C++, and JAVA Script.

PROFESSIONAL EXPERIENCE

Confidential, NY

Business Analyst/Data Analyst

Responsibilities:

• Responsible for the development and maintaining of the New York State Medicaid System (EMEDNY) utilizing ETL DataStage 8.5, Teradata SQL/Assistant, Metadata, Stored Procedures, Teradata RDBMS architecture, FastLoad, Fast Export, Multiload utilities, COBOL, DB2, ETL, CICS, JCL, Snagit, Cognos and BI-Query in a Data Warehouse environment.
• Responsible for EMEDNY Data Marks fixes that transfer control from CSC to CMA for (834/835/837/270/271/276/277/278/997/999/5010/ ICD-9/10 HIPAA PHI) Teradata, MQ messages from the Data Warehouse to all downstream systems.
• Responsible for creating detail Functional and Technical requirements/specifications for programs of low to high complexity utilizing Trace Analysis, Impact Analysis, Data Gathering, Time Estimates and Erwin data modeling 4.0/4.5 which ensures SOA standards for delivery.

Confidential, Columbus, GA

Business Analyst/Data Analyst

Responsibilities:

• Responsible for the development of Functional and Technical specifications for the Mainframe Element Elevation system (MEE) that transfers 834/837 (MCS Claims processing) MQ messages from CASE/Lotus Notes to the Mainframe and updates ENDEVOR functions via an API, utilizing COBOL, CICS, SQL, DB2, ETL, EDI X12, DataStage, MQ Series, Lotus Notes, RUP, MS Word, MS Excel, MS Access, CASE, and ENDEVOR.
• Serving as a mentor and Project Leader on all Mainframe and SDLC initiatives, utilizing z/OS/MVS, COBOL, CICS, DB2, QMF, SPUFI, UML, VSAM, MQ Series, XPEDITER, Stored Procedures, Power Point, and Gantt Charts.
• Responsible for enabling developers to maximize speed, flexibility and effectiveness in building, deploying, updating and managing their data integration infrastructure thru DataStage.
• Responsible for migrating data from one database to another to form data marts in data warehouses and I was also responsible for converting databases from one format or type to another utilizing ETL.
• Responsible for the development of claims management solutions to insurance companies and self-insured entities, with a global network of more than 700 offices. Major service lines include property and casualty claims management, legal settlement administration, including class action and warranty inspections, Reinsurance, and risk management information services. Confidential offers a broad array of customized casualty, contract management, medical management, and vendor management, integrated disability management.
• Worked with business owners, developers and project stakeholders to gather requirements, write both high-level and detailed-level requirements.
• Responsible for requirements elicitation via research, workshop facilitation, survey design and execution; statistical analysis; requirements determination using structured techniques for documentation, analysis, evaluation/validation; decomposition of high-level information into details; abstracting low-level information; distinguishing requests vs needs; distinguishing requirements vs solutions; classifying/prioritizing requirements.

Confidential, Raleigh, NC

Business Analyst/Data Analyst

Responsibilities:

• Responsible for the enhancement of the Job Connector Job Matching/Data Mapping System (NCJC), which is an internet/intranet based application that will allow employers with a North Carolina Tax Id Number or Federal Employer Identification Number (FEIN) and ESC/Job Link personnel to job orders or security information, which present a single point of access to the public and staff. It supports integration of legacy mainframe data with other enterprise data - consolidating, collecting, and centralizing information from various systems and mainframes.
• Responsible for the functional support of legacy data with other enterprise data for the need of collecting, consolidating, transforming, validating, loading and centralizing information from multiple sources thru DataSatge.
• Serving as a mentor and Project Leader on all Mainframe and SDLC initiatives, utilizing z/OS/MVS, COBOL, CICS, SQL, ETL, DataStage, DB2, QMF, SPUFI, UML, RUP, VSAM, MQ Series, XPEDITER, Stored Procedures, Power Point, MS Word, MS Excel, MS Access, UAT, and Gantt Charts.
• Responsible for creating State Diagrams, Traceability Matrix, and Impact Analysis to describe all of the possible states of an object as events occur.

Confidential, Orlando, FL

Business Analyst/Data Analyst

Responsibilities:

• Responsible for the enhancement of the COPS international partner purchasing system, utilizing z/OS/MVS, COBOL II/COBOL LE/COBOL 390, MVS, TSO/ISPF, CICS, RUP, ETL, SQL, DB2, QMF, SPUFI, ENDEVOR, UML, MS Word, MS Excel, MS Access, MQ Series, INTERTEST, INSTALL 1, and EASYTRIEVE PLUS (includes all levels of testing up to implementation ).
• Responsible for maintaining an encrypted audit stamp (footprint) in the output source (target data), this provided an integrity check between the source of an element and its executable in ENDEVOR (over 10,000 elements).
• Served as a mentor and advisor to other Software Analysts, Business Analysts, Requirement Analysts, and Subject Matter Experts.
• Implemented the companywide invoice delivery system, which incorporated the new ISBN-13 expansion and the vendor management system.

Confidential, Orlando, FL

Business Analyst/Data Analyst

Responsibilities:

• Responsible for designing, developing and enhancing vendor / partner programs for international banks, while utilizing z/OS/MVS, COBOL II/COBOL LE/COBOL 390, MVS, TSO/ISPF, CICS, VSAM, QSAM, JCL, MQ Series, DIT MS Word, MS Excel, UAT, SMARTTEST, and EASYTRIEVE PLUS.
• Served as a mentor and advisor to other Software Analysts/Programmers on our support and development team.
• Developed and maintained strict quality control standards. Worked with project members to develop business plans, functional and technical specifications, and vendor management system while interacting with international suppliers.

Confidential, Wilkesboro, NC

Business Analyst/Data Analyst

Responsibilities:

• Responsible for designing specifications, time estimates, creating validation data mapping, system testing, debugging, DB2 performance tuning, and implementation for a Solutions Delivery System with over 1200 locations which utilizes z/OS/MVS, COBOL II/COBOL LE/COBOL 390, MVS, TSO/ISPF, CICS, SQL, DB2, XML, ETL, UML, RUP, SPUFI, QMF, VSAM, QSAM, JCL, ENDEVOR, MQ Series, Stored Procedures, and EASYTRIEVE PLUS.
• Responsible for Functional Security which involved protecting Endevor inventory functions from unauthorized use. This function included but not limited to access to menu options and the ability to perform certain actions against certain inventory areas in Endevor Native Security tables.
• Responsible for creating the companys standards for MQ application processing such as supplier negotiations, Back-out Messages, Application Shut-down, API tracking, SYNCPOINT/Message Recovery, and Persistence/NON-Persistence messages and others.

Confidential, Hartford, CT

Business Analyst/Data Analyst

Responsibilities:

• Responsible for the development and design of a SDLC transformation of a MMIS medical claims system that will unify the companys transaction database which utilizes COBOL II/390, OS/390, z/OS, MVS, TSO/ISPF, CICS, DB2, UML, JCL, VSAM, Stored Procedures, EASYTRIEVE PLUS, ETL, Net Express, SQL Plus, PVCS, UNIX, RUP, MS Word, MS Excel, MS Access, HIPAA EDI X12 834/837, MCS and MQ Series.
• Create and implement Disaster Recovery guidelines, processes and standards.
• Develop and conduct on-going employee, management awareness and education initiatives of the IT Disaster Recovery program with an offsite vendor.
• Worked with vendors for DR services. Develops off site data and document repositories to be utilized.
• Created additional MQ Shell Services Applications that would be utilized by all departments that interfaced with the MQ business layer (API).
• Responsible for maintaining the MQ Service Directory.
• Responsible for training Sr. Developers to utilized PQEDIT to monitor MQ queues.

Confidential, Washington, DC

Business Analyst/Data Analyst

Responsibilities:

• Responsible for the development of new real time and batch MMIS medical claims system utilizing COBOL, CICS, MQ SERIES/MQSI, ETL, UML, SQL, DB2, QMF, SPUFI, VSAM, JCL and Stored Procedures for all claims processing which included the Federal Employee Program (FEP).
• Responsible for the development of the Mainframe Data Extraction and Entry/Exit Criteria of all phases of the SDLC FEPOC process that includes: Analysis, Design, Development, Testing, Implementation and Post Implementation which Connect Direct (NDM), FEPDirect, MQDirect and Blue Exchange.
• Responsible for monitoring claims activity, API Tracing and troubleshooting performance issues while tracking defects within the core process.
• Ensured adherence to EDI business requirements provided by internal auditing (HIPAA EDI 834/837).

Confidential, Hartford, CT

Data Analyst

Responsibilities:

• Managed and developed new functionality for eBusiness version 5.3 utilizing IBM COBOL II/LE, CICS, VSAM, JCL, ENDEVOR, SAP, SQL, DB2, QMF, SPUFI, OS/390, MVS, TSO/ISPF, EASYTRIEVE PLUS, MQ Series/MQSI, JRun, MS Word, MS Excel, DML, and Stored Procedures.
• Created the standard options for the application developers when coding MQ calls, commits, persistence, non-persistence messages, truncation, correlation ids, and others. Established the MQ Disaster Recovery procedures.
• Set up round trip queue messaging, definitions and requirements from the middle ware to the back-office new APIs, while setting the new requirements for the dead-letter queue.

Confidential, NYC, NY

SR. Developer/Data Analyst

Responsibilities:

• Designed, developed, and maintained online and batch systems from initial analysis through implementation, utilizing IBM COBOL II, TSO/SPF, Grapevine, Micro focus-COBOL, Net Express, Oracle SQL Plus, CICS, ETL, SQL, DB2, SPUFI, RUP, QMF, SAP, VSAM, DML, MS Word, MS Excel, MS Access, JCL, OS/390, MVS, ENDRVOR, TSO/ISPF, EASYTRIEVE PLUS, XML, MQ SERIES/MQSI, and Stored Procedures.
• Participated in the implementation of standard project methodologies defined by the PMO and leverage these methodologies for all DR projects and initiatives.
• Provided direction for individual team members on Disaster Recovery initiatives that related to suppliers and vendors.
• Responsible for developing and maintaining the Trading system that calculated Tax Lots to the Position level against the General bucket that created snapshot of all trades for portfolio managers.
• Responsible for Endevor Change Management movement throughout the software development life cycle, which drove the production turnover process and provided maximum application integrity through customizable controls and comprehensive audit trails, categorizes and protects software assets, and ensures a flexible implementation.
• Responsible for the timely replacement of all in-house messaging processes written in Grapevine, consisting of over 50 APIs (programs) that were rewritten in MQ Series, DB2, COBOL II, and CICS. Created multi-region, with multi-platform, for use with multi-threads while utilizing over 400 queues and 8 queue managers.
• Responsible for creating Stored Procedures that adhered to validation and edit routines utilizing Cobol II/LE.

Confidential, NYC, NY

SR. Developer/Data Analyst

Responsibilities:

• Responsible for the development of a MQ Series messaging application that consisted of both batch and on-line programs to feed downstream systems utilizing OS/390, MVS, COBOLII/LE, CICS, JCL, ENDEVOR, MS Word, MS Excel, and MS Access, UML, ETL, SQL, DB2, and VSAM. Each local queue accepted clients and services based on service ids, utilizing MQ utilities such as Disabling and Enabling frozen queues, Queue Administration, Security Administration, Priority setting, Depth Triggering were used for setting the depth exceeded max in the Service Directory, Error reporting, and redirecting of fail messages to alternate queues.
• Responsible for developing and maintaining the Tax Lot system that created snapshot of all portfolios, that evaluated the current worth of all assets in hand and those on loan.
• Responsible for reporting systems that reported on stocks that were currently performing below par as part of Cost Basis.
• Responsible for ensuring critical rapid throughput of elements from one location in the lifecycle to the next while concurrently promoting Packages, which simplify application development by improving application movement in Endevor throughout the lifecycle.
• Responsible for the development and conversion of online and batch DDA/TDA transaction programs for Cash Management customers, while providing problem resolution and inquiry response. I was also responsible for producing various weekly, month-end, and quarterly reports of all DDA/TDA accounts outstanding, account open, account close, account payable, general ledger, productivity, volume, and losses/recoveries. Because of the merger between both banks (Chemical/Chase) I had to create a new account validation routine that would be use by all APIs.
• Responsible for functional specification, technical specifications, system testing, inter-system testing, user acceptance testing, and implementation.
• Responsible for Chase Custody systems Year 2000 compliance testing for DTC:
• Year 2000 point-to-point testing for connectivity.
• SIA Year 2000 Industry-wide testing for.
• NYSE Listed Equities Custodian Buyside.
• SIA Year 2000 Industry-wide testing for
• Custodian Corporate and Municipal Bonds
• Buy and Sellside.
• SIA Year 2000 Industry-wide testing for
• Securities Lending-Custodian-to-Broker
• SIA Year 2000 Validation testing for DOs, ID Affirmation, and SPOs.
• Responsible for point-to-point testing with outside clients.
• Handled Fixed Income and Global Securities programming/Contract management issues related to the merger between Chemical and Confidential .
• Responsible for the successful disaster recovery testing and planning of all custody and downstream systems.

Confidential, NYC, NY

SR. Programmer Analyst/Data Analyst

Responsibilities:

• Developed online/batch reporting and billing systems from initial analysis of functional and technical specifications through design and testing phase, regional user acceptance to implementation.
• Due to company acquisitions, responsible for the migration of the company-wide financial system, consisting of OS/390, MVS, COBOL II batch and CICS programs, utilizing VSAM, JCL, and MVS, TSO/ISPF.
• Spearheaded the development of an INFOHUB (OMNI) system, to allow portfolio managers the ability to take snapshots of data at a given time on a client server level, which eliminates the time-consuming process of file transfer programs (FTPs). This INFOHUB resides on CICS.

Confidential, NYC, NY

SR. Project Planner

Responsibilities:

• Designed, coded, and tested an online accountability system for the Citywide Central Insurance Program.
• Responsible for the IS reporting processes for all mayoral agencies for combined city and state services utilizing VS COBOL/COBOL II, RAMIS, CICS, DB2, QMF, SPUFI, INTERTEST/XPEDITER, SYNCSORT, OS/390, MVS, TSO/ISPF, and OS JCL with a strong focus on online and batch processing details by agency.
• Responsible for the design, development of a claims processing system, while maintaining an online and batch system that process members and subscribers for all mayoral agencies that combined 834/837 city, state and private services utilizing VS COBOL/COBOL II, CICS, VSAM, JCL. PROCS, DB2, QMF, SPUFI, INTERTEST/XPEDITER, SYNCSORT, OS/390, MVS, TSO/ISPF, and OS JCL with a strong focus on online and batch processing details by agency.
• Acted as project manager for the IS requirements for forecasting and budgeting for procurements and capital projects and formulated ad-hoc reporting for the purpose of detailing all capital expenditures arising from municipal emergencies.
• Utilized RAMIS software to extract data from parking meters for input to trend analysis reporting to determine revenue being generated for the city based on time of day and location. The information gathered will determine where parking meters should be located, how many resources to allocate to those areas, and forecasting future revenue for budgetary purposes.
• Lead the development of the IS disaster recovery plan by developing project plans, coordinating activities, monitoring progress, reporting status and presenting recommendations to management.