SUMMARY:

• Strong Programming and Analytical skills in a high paced IT environment of Client and Account systems for Investment Bank using DB2, SQL, COBOL and DB2 Utilities.
• Sr. Programmer Analyst/ETL Developer in enhancement and support of a Data Warehouse application for Claims Department using DB2 and Informatica.
• Analyzed detailed systems requirements and provided detailed functional specifications to team members. Also ensure the systems continue to meet user needs after implementation into production.
• Extensive knowledge in all stages of SDLC, including gathering business requirements, analysis, designing, coding, and providing QA test support.
• Meet with users to define and evaluate their business needs which were resolved through IT development. Explore alternative methods of problem resolution including the use or modification to outside packages.
• Over 18+ years of solid application development experience using DB2, SQL, COBOL and DB2 Utilities.

TECHNICAL SKILLS:

PLATFORMS: IBM ZOS, IBM 3090, IBM 3380, IBM MVS/TSO, IBM VM/370, DEC VAX 11/785, 11/750, Windows 95/98/NT/XP, UNIX

LANGUAGES: COBOL, COBOLII, MVS COBOL, LE/EC COBOL, Visual Basic, Java, HTML, DHTML, ASP & VBSCRIPT

SOFTWARES: DB2, SQL, IBM Cobol Stored Procedure, QMF for Windows, IBM Data Studio, WINSQL, ChangeMan, Trace Master & IBM Debugger, Informatica, Xpeditor, MFExpress, ORACLE 10g & 8i, IMS DB/DC, TSO/ISPF, JCL,VSAM, IBM/DB2 UTILITIES, File Aid/DB2 FileAid, Panvalet, Endevor, CICS, BMC, MF Workbench, XDB, Sql/Server, Sybase, Microsoft Office, PC Tools, Visio, DSS Agent Quest, Lotus Notes, JDA/MTM Client Application

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• As a Mainframe Developer at Confidential Food Corp, worked on Wholesale IT system in providing Item detail information to our 15 + wholesale customers. This included pricing, invoice file and order confirmation related information. Recently was involved in a JDA/MTM Transportation System. This system is a Client based application providing our Transportation Department with Invoicing, Freight movements, Orders Validation and Rerating Costs for the Carriers. In addition provided Production to our RAPID System. This systems consists of Purchase Order, Inventory Control, Item Maintenance, Invoicing, Warehousing and Order management. Additionally worked on rewriting of their Label System which uses flat files and VSAM technology. Replaced the usage of flat files and VSAM data structures with DB2 tables and IBM Stored Procedures. The main objective is to streamline and rewrite their critical weekly batch processes that provided the label files to VestCom (outside vendor). The files are FTP on weekly basis for items that will be on sale, are new or going off promotion. Vestcom then ships printed labels for those items directly to each of Shoprite stores. Further worked on taking most of the background functionality out of Vestcom’s hands and have it incorporated into our newly developed system. This process saved Confidential a considerable amount of cost associated with producing labels incase in the future they decide to go with different vendor.

Confidential

Responsibilities:

• As a Consultant worked on De - conversion project at Confidential in their Cash Management/RMA group. Confidential has sold approx. 50+ branches to Stifel Nicolaus Investment Bank and this project involved modifying key mainframe components to de-convert Confidential to Stifel Accounts. The ultimate goal was to successfully de-convert all Accounts under branches that were sold to Stifel along with their account holding balance and prevent them from going to downstream systems.

Confidential

Responsibilities:

• As a Sr. Lead Associate/System Developer worked in maintenance, enhancement and production support of the CAI/CRDB system in Wealth Management Group. The CAI/CRDB is a primary point of entry of Client and Account Information used by Financial Advisors, Client Sales Assistants, and Branch Managers. The back end data is stored in DB2 database.
• Aside from supporting CAI/CRDB, I worked on a major project for our Client Verification Unit (CVU) to modify the daily feeds of client information to external Credit Bureaus. The original design fed Client information to 3 different vendors such as CDC, RDC and Confidential . After modifying the current process and supplying Client information to only 1 vendor ( Confidential ) saved Confidential a lot of expense. Additionally worked on assigned tasks that required modifications to our Online/Batch application based on requirement changes came from our business users. All modifications and changes to mainframe components followed strict SOX Compliance guidelines and adhere to our firm wide weekly Production release process. The last Major project completed at Confidential was to Decommission CDB application(M204) and converting to Cobol/DB2 which involved rewrite of over 45+ major mainframe components and downstream programs. This entire project took over 12 months of analysis, design and development with 5 FTE to complete.

Confidential

Responsibilities:

• As a Sr. Programmer Analyst/Technical Analyst had an opportunity to work on a very large scale development of replacing the Legacy Claims System. The entire project took approximately 2 1/2 years with 60 FTE to develop.
• I played a major role through out the project that interfaced with the mainframe applications. In this position, I had an excellent opportunity to work as Project Tech Lead in tracking the progress of system development tasks assigned to our group.
• Additionally I was the liaison between the DBA(s) and the software development team in enhancing and maintaining the changes that were required to the DB2 test databases during the construction and testing phase. One of my major s was to enhance our existing online payment process to prevent the payments to go through for invalid tax id(s). This required a major modification and enhancement to the online payment application. Instead of obtaining the TIN numbers from the old TMF source, the TIN numbers were now obtained from the DB2 source which is being utilized by 3 major systems. Aside from the main responsibilities, gave technical interviews to the applicants who applied for jobs with in the entire Claim IT division. My last project at Chubb, worked as an ETL Developer using Informatica on a Data Warehouse project for our CLAIMS Department. The Data Warehouse was developed to provide historical reports to Business partners/senior management group. The front-end tool used for reporting was Congnos / Report Net.

Confidential

Responsibilities:

• As a Lead Systems Analyst managed 2 - 4 consultants in supporting and making enhancements to the Doctor Utility System. This application provided the marketing sales group associates which medications in a given therapeutic class has what percentage of the market share. Heavy analysis was done for new requests which required development and enhancement to existing programs. DB2 / SQL, COBOL LE, MVS, JCL, FOCUS (ON LINE) and DSS Agent Quest (TOOL - To determine what medications fall under what therapeutic classes) were used in providing Market Share reports to upper management and enhancements to existing systems.

Confidential

Responsibilities:

• As a Project Manager managed a team of 4 - 6 in a successful completion of an Inventory System for Best Foods Inc. The Inventory Control System (ICONS) was created to improve Best Foods ability to locate all finished goods in the event of recall. Our team was contracted to produce a Requirement Document for the ICONS System and to implement a Pilot System between plant and distribution center. Additionally a Project Plan was developed to upgrade the Hardware System from 386 pc to Pentium server’s architecture. Technology / Software used were DB2, OS/2, IBM mainframe, COBOL 2. JCL, Telxon (R/F) and TCP/ IP.

Confidential

Responsibilities:

• As a Sr. Programmer Analyst, worked at a Merck Medco in their Information Management Group. My main responsibilities included to oversee various projects simultaneously and the whole life cycle of the projects from development to user acceptance. Addition to that assigned program requirements to the development team based on the outcome of the Business requirements and analysis. On monthly basis, provided the director of our department with monthly status report on status of projects and the number of projects delivered or completed.

Confidential

Responsibilities:

• As a Consultant, worked at Confidential on their SBMS (Stock Brokerage Management System) which supported EMS (Employee Management System). My responsibilities included to study and analyze the current system and provide data requirements, process requirements and design approach to the management. This was an existing system based on VSAM platform and was redeveloped on DB2 platform. I played a major role throughout all the phases of the project from design phase to system test. Additionally worked at Bristol-Myers Squibb on their Sales and Corp Territory systems. Responsibilities included major enhancements to existing systems, development of new applications, analysis, and design. In addition to that made requests to DBA & QA to modify Databases and system changes as needed for systems testing.