SUMMARY:

• Systems Analyst with Applications Developer experienced working with new development and enhancement for multi platforms systems.
• Working experiences with Traditional and Variable Life and Annuities Insurance, Health Insurance and Manufacturing Industry including Financial Applications.
• Productive and efficient in gathering business requirements and creating and maintaining Project Preparing documentation for new development and systems enhancement experience as well as preparing test scenarios and cases. Preparing software implementation and providing production support. Extensive experience in data analysis and data modeling, infrastructure architecture.
• Experienced in SDLC methodology, Waterfall and Agile developing methodology and Used Cases testing methodology.

TECHNICAL SKILLS:

Programming Languages & Mainframe Software: COBOL, PL/1, Easytrieve, ASM, FOCUS,SQL, QMF, BMS, MFS, QMS, DMS, TSO/ISPF, CLIST, CICS, JCL, OS Utilities, Websphere/MQ Series, FTP

Midrange: UNIX/AIX, Shell Script, PL SQL

Database Structures: DB2, IMS (DB/DC), RDBMS/ORACLE, ACCESS

Debug, Inquiry & Reporting Tools: Xpeditor, IBM dBug, Abend AID, File AID, SPUFI SQL, MS Query, SAP BOAssets ManagersEndevor,Changeman, PVCS

Services & Tools: OPC, ESP, Tivoli, CA - 7/CA-11, SAP, ETL, EDI SDLC, CMMi, SOX

Vendor Software: Vantage One, Cyber Life, Unified Climes System, Trilogy Producer Compensation System, MetaVance Administration & Finance Applications/Health Care, Clarity CA Portfolio Management

Desktop/ Server/Distributed Services: Microsoft Office Product Suite, MS Project, MS Visio, PL SQL, C ++, J2EE, Java, XML, HTML, .NET,Citrix SharePoint, Caliber RM, HPQuality Center, Test Director, Cloud Computing

PROFESSIONAL EXPERIENCE:

Confidential

Consultant - Systems Analyst

Responsibilities:

• Worked on the legacy system conversion to Oracle DB and Documentum DB tables project at UTC/ Pratt & Whitney, East Hartford location. Provided analyses and technical solutions for the applications and IMS DB legacy systems conversion. Developed project BRD, SRS and presentations. Worked with the users and CSC vendors on developing Data Base and applications conversion process.
• Prepared data mapping for data extracts and loads. Presented data mapping and flows using MS Visio.
• Coded, tested and prepared processes for transfer and storing data from the Mainframe to Oracle DB tables using FTP and ACIF. Wrote queries tested and verified conversion process and applications tests results.

Software: COBOL, Easytrieve, CICS, TSO/ISPF, CLIST, JCL, Endevor, FileAid, OS/zOS, FTP, ACIF.

Confidential, Newton, MA

Consultant - Systems Analyst

Responsibilities:

• Worked on the legacy files conversion to Oracle DB tables project at Boston College as a liaison between the business users and vendors. Planed and provided analyses and technical solutions for the ITS files conversion. Developed project BRD, SRS and presentations. Worked with the team members and vendors on development data base conversion process and infrastructure architecture. Builded Oracle DB tables mapping and loaded data processes. Prepared and confirmed test cases and acceptance tests results verification process. Tested and verified conversion process and tests results.

Software: COBOL, PL/1, Easytrieve, SQL, MFS, QMS, TSO/ISPF, CLIST, CICS, JCL, Endevor, OS Utilities, Websphere/MQ Series, FTP

Confidential, Waltham, MA

Consultant - Solutions Architect/Developer

Responsibilities:

• Business SME Interviews Facilitating - Knowledge Transfer. Analysis and BR and TS gathering. Systems Requirements Documentation for new development.Data mapping, data flows.
• Conversion and Integration Data Analysis, Data Conversion and Data Modeling. Coding testing and implementing new applications, reports and interfaces. Planning Source Promotion and Implementation and post-implementation actions.
• Providing production support as an application SME.

Software: COBOL, PL/1, Easytrieve,ASM, CICS, PL SQL, QMF, BMS, MFS, QMS, DMS, TSO/ISPF, CICS, CLIST, JCL, CA-7, OS Utilities, Endevor, Websphere/MQ Series, FTP

Confidential, Bloomfield, CT

Process Engineer

Responsibilities:

• High Level Business Requirements
• Detailed Business Requirements
• Technical Solutions
• Assumptions and Impacts
• Coded, tested and executed ad-hock reports and PL SQL queries by the end-user requests.
• Prepared QA and UAT Test Cases and participated in testing and results analyses. Prepared work flows and data mapping using MS Visio.

Confidential

IT Systems Analyst/Consultant

Responsibilities:

• Developed Architectural Models and Data Models for Enterprise Applications Integration (EAI). Fulfilled Business and Systems Analyses. Gathered Business Requirements. Prepared SRS for Interfaces. Prepared data flows and mapping using MS Visio. Coded, tested and implemented interfaces and reports, according to SRS. Prepared Interfaces UAT Test Plans, and Test Cases. Executed Test Plans and analyzing results and QA.

Software: COBOL, PL/1, PL SQL, QMF, QMS, DMS, TSO/ISPF, CLIST, CICS, JCL, OS Utilities, Websphere/MQ Series, FTP

Confidential, Bloomfield, CT

Sr. Systems Analyst/Applications Developer

Responsibilities:

• Provided Business and Systems analyses, Data Analysis, validated clients requests, gathered Business and created Functional and Technical Specifications, UAT Test Plans, and Test Cases for Universal Life, Variable Life and Annuities products.
• Performed coding, testing, preparing Development Releases and Project Documentation, and provided production support for IB IT core platform and distributed services applications.
• Confidential
• Fulfill analysis and development requirements in support of Individual Life Insurance/Reinsurance Administrative Systems projects:
• Organization Systems Integration Project Funds Enhancement Tired Mortality and Expenses Charges by Duration Subsidiary Company’s Merger Project Funds Replacement Project Sales Illustration - Proactive Reproposals Project.
• Prepared and implementing Administrative System Enhancements, based on Quality Center’s defects addressed to the UL Systems by business users.
• Performed ongoing responsibilities as Version Release review coordinator.
• Fulfill analysis, development and production support requirements for USC and Dental Group Insurance Systems. Performed on-call USC production support, defect’s fixing and customer requests analyses. Worked with the production support to review production errors reports, recommended solutions, monitoring fixing progress.
• Analyses and development includes long-term projects:
• Provider Interface Updates. Integrating Base and Outsourcing Producers’ Support System Project. SMTP2.
• Performed Business and Systems analyses and provides project documentation for projects:
• Claims in Hold Queues Processing Enhancement Project. Anesthesia Options Project.

Software: COBOL, PL/1, Easytrieve, FOCUS,SQL, QMF, BMS, MFS, QMS, DMS, TSO/ISPF, CLIST, CICS, JCL, Endevor, OS Utilities, Websphere/MQ Series, FTP, Vantage One, Cyber Life

Confidential, Springfield, MA

Sr. Systems Analyst/Applications Developer

Responsibilities:

• As a member of Producers Support Systems team performed applications development and production support functions for Mainframe, and MS SQL Servers. Participated and lead in Development Projects for the Benefits Management and Retirement Services Departments, Universal Life, Variable Life and Annuities products:
• Data Exchange between Retirement Services and Producers Support Services Database Corporate Agents Cash BalancePension Equivalency Payment for non-qualified Agents.
• Participated in short-time projects with responsibilities for Compensation and Benefits Applications development.
• Participated in Agents Business Continuation project.

Software: COBOL, PL/1, Easytrieve,SQL, QMF, BMS, MFS, QMS, DMS, TSO/ISPF, CLIST, CICS, JCL, Endevor, OS Utilities, FTP, Vantage One

Confidential, Rocky Hill, CT

Senior Consultant/Applications Developer

Responsibilities:

• Participated in Confidential Data Base Merge project at MassMutual.Participated as Systems Analyst in Database Data Conversion project.
• Participated in Health Vendors Fee Reimbursement Applications Development Project and Production Support. Participated in the Personal Applications Development Project adding new Health Insurance Data Base tables.
• Participated in Health Insurance Claims Processing (HIPPA, TPS, NPS, RTMS) production support. Analyzed error reports and queries by request from business groups. Prepared source or data fixes, tested and prepared production releases.
• Analyzed daily claims processing results and investigated climes rejection or hold status reasons on assigned claims. Proposed work around or reported systems or data errors. Worked with business owners, end-users and systems to solve issues.

Software: COBOL, PL/1, TSO/ISPF, CLIST, CICS, JCL, OS Utilities, FTP