Functional Analyst Resume
NY
SUMMARY:
Progressive, high energy, and empowering team leader/player with over twenty years of strong knowledge in system analysis, design, development, implementation and documentation of financial applications. User focused with extensive technical knowledge and expertise coupled with creative ideas. Successful history of large scale IT projects with passion for turning obstacles into opportunities.
TECHNICAL SKILLS:
Cobol - II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, JCL, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
PROFESSIONAL EXPERIENCE
Confidential, NY
Functional Analyst
Responsibilities:
- Evaluated and designed Business and Organizational process flows to align with end user roles, and system response for their enterprise wide application systems to create a documentation for Web Development E commerce project.
- Recognized business system requirements needed to meet business transformation goals.
- Created meeting agenda, briefings, research papers, and data analysis needed to support the Client.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, JCL, HIPAA X12, EDW, TERADATA.
Confidential, NJ
Developer/Analyst
Responsibilities:
- Performed mainframe /DB2/TERADATA software development, enhancements and maintenance for ADJUSTMENT system for new SUBROGATION subsystem, including DLD and full QA and production support for mainframe and TERADATA Data Warehouse.
- Performed mainframe software development, enhancements and maintenance for NRX system to provide benefits for new DOD client
- Created FRD and DLD for Replenishment project to provide functional methods of online model stock calculation replenishment at Item/Pharmacy level by designing specifications for the new batch programs, reports.
- System written on Cobol II/ Confidential /DB2/MQ/TERADATA under OS/MVS/XA operating system.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, JCL, HIPAA X12, EDW, TERADATA.
Confidential, NJ
Developer/Analyst
Responsibilities:
- Performed mainframe software development, enhancements, and maintenance for various pharmaceutical clients ( Confidential .
- Was a technical lead and for VSAM and COBOL to DB2 and COBOL data conversion projects for Pharmacy Benefits Management (PBM) which has object oriented architecture with as many as 10 levels deep of COBOL calls, including documentation of BRD and TRD.
- Was instrumental in SQL tuning, development of portioned tables for support across multiple time zones.
- Provided work coordination between client side (RxClaim, QL, RECAP), on-shore core team and off-shore team.
- Used Informatica Power Center client for creating, mapping and run workflows.
- System written on Cobol II/ Confidential /DB2/MQ under OS/MVS/XA operating system and IMS DB/DC on AS400.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), JCL, MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
Confidential, NYC
Developer/Analyst
Responsibilities:
- Involved in design and development of a new transaction for Claims system to process inpatient and outpatient hospital claims for city of NY workers based on information from Subscribers
- Filed and collected all co-payments for family/individual plans.
- Assist in translating business requirements and assist IT with the development of technical specifications
- System written on Cobol II/ Confidential under OS/MVS/XA operating system.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), JCL, MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
Confidential, NYC
Developer/Analyst
Responsibilities:
- Involved in development and support of LOI fulfillment/ROA processes Application used to communicate between Morcom trading system and MFRS and Charles Schwab investment.
- Project developing and implementation involved utilizing Confidential Web Services, Cobol/DB2 SPs, Batch/DB2 programs and streams.
- Responsibilities included communication with the business users, gathering the business requirements, performing the analyses, creating the functional specifications and test cases, unit and QA testing with other business
- System written on under OS/MVS/XA operating system.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), JCL, MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
Confidential, Weehawken, NJ
Developer/Analyst
Responsibilities:
- Designed, developed, and implemented the Investment Solution Toolset Application. The system’s intent is to unify the way various related data i.e. Security, Trade, Account est., is stored, maintained and presented.
- Developed the Cash Management Subsystem which let the user identify all cash positions for the client as a feeds coming from different subsystem and reflect it on trading screen.
- Development included Confidential /DB2 modules, Cobol SPs, Batch/DB2 programs and streams.
- Responsibilities included the interface with the Business Unit, writing functional specifications and programs, UAT and QA testing utilizing business applications on different platforms.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), JCL, MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
Confidential, NYC
Lead Consultant
Responsibilities:
- Involved in enhancement and support of Commission/Accounting Transaction Processing System and Licensing System for BackOffice operations.
- Responsible for data transition project from UNIX/IBM S-36 to MS SQL Server from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
- Developed adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
- Programs were written in Micro Focus Cobol / Confidential /XDB as a developing tool.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), JCL, MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
Confidential, Montvale, NJ
Mainframe Developer
Responsibilities:
- Involved in enhancement and support of Claims Reconciliation System, designed to reconcile any existing claim which had been initially sent in and adjusted any initially payment which had been made.
- Was heavily involved in conversion to make this system compliant with HIPAA standard, to be able to process HIPAA compliant EDI 834 data input from clients.
- System written on Cobol II/ Confidential /DB2/MQ Series
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), JCL, MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
Confidential, Boston, NYC
Mainframe Developer
Responsibilities:
- Involved in enhancement and support of Monthly Option Expiration system, to move it from Monday after the expiration processing to Friday
- Developed process for all exercise and expires of long Equity and Index options actions taken on the last trading day of the month for both customer and firm positions.
- Provided the Listed options Clearance Group with the categorized option positions through the MES (Monthly Expiration System)
- System written on Cobol II/HPS/ Confidential /DB2 under MVS operating system.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
Confidential, New York, NY/Whippany, NJ
Mainframe Developer
Responsibilities:
- Involved in development and support of Confidential system, designed to upload daily trades to trade repository and allows user to work with new type of security - Mortgage Backed Security (MBS).
- Involved into conversion of a GOTS VSAM files into new security database Called FIPR (Fixed Income Products DB) and conversion existing program to access new database using DB2 stored procedure.
- System written on Cobol II/ Confidential /DB2 under OS/MVS/XA operating system.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), JCL, MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
Confidential, New York, NY
Mainframe Developer
Responsibilities:
- Involved in development, support and migration of Customer Profile System Confidential Real-Time environment to a Visual Basic front-end
- CPS provides comprehensive service for all brokers in all offices with on-line name and address system.
- System utilize Microsoft Visual Basic 5.0 as a front end and Confidential /DB2 under OS/MVS/XA operating system for back-end and Grapevine Tool as a middleware.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), JCL, MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
Confidential, Roseland, NJ
Mainframe Developer
Responsibilities:
- Engaged in support and enchantment of Confidential (Activity Control Environment) system which provided comprehensive service for Life Administration areas and Fields associates to track customer requests through each step from receipt to completion.
- Developed new transaction AEMN to allow for customized views for sales managers and general managers.
- Responsibility included administrate Micro Focus system network installation and setup PVSC as a version control tool
- Programs were written in Micro Focus Cobol / Confidential /XDB as a developing tool.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
Confidential, Livingston NJ
Consultant
Responsibilities:
- Developed programming interface for AUTO insurance between COBOL backend (Micro Focus COBOL) running on 32-bit environment OS/2 WARP / Windows/NT and Sybase System 11 through named pipes utilizing OS/2 - Windows API calls.
- Participated in development and implementation of ALPS-MARS interface. The functions of the system allow transfer MARS requests to ALPS requests with translation MARS products, Sections, Risks and Coverages to ALPS based on Alps producer for any lines of businesses as endorsement, or renewal.
- System is written in Cobol/DB2 under OS/MVS/XA operating system and Micro Focus Cobol/SQL Server for back-end and Microsoft Visual Basic/SQL Server for front end.
Environment: Cobol-II, Confidential, DB2/SQL, MS SQL Server 2005/2008(SSIS), JCL, MS SQL Server 2005/2008 Reporting Services (SSRS), PVCS, File-Aid, Change man, Endevor, AFP, EDI, MQ Series, XML, TSO/ISPF, XPediter, VSAM, Intertest, Micro Focus Cobol/ Confidential, XDB, Sybase DB, VB.Net, IBM WebSphere Application Server, HIPAA X12, EDW, TERADATA.
