SUMMARY OF QUALIFICATIONS

• Over 20 years of IT experience encompassing various positions and industries
• 20 years of Mainframe Experience - Cobol and Associated Technologies
• 10 years of object oriented design and coding with C , VB.Net and Java Developer
• Strong Analytical and Documentation skills
• System and Program conversions
• Excellent Problem Solving and Debugging capabilities
• Sales and user inteface experience

POSITION OVERVIEWS

Project Leader

• Excellent organizational skills
• Ability to lead and take direction from superiors and piers
• Able to write user and technical documentation with attention to detail
• Familiar with FDLC, Agile, Scrum and UML Methodologies
• Able to handling diplomacy issues
• Solid communication skills in both oral and written capacities
• Completed Verbal Advantage Vocabulary course

Projects

• Developed Websites
• System Conversions
• Data Mapping
• Quality Assurance
• Developed CICS application Systems
• Program Language Coversions

.Net / Client Server

• C , VB.NET 2.0-4.5 , ASP, Entity Framework, MVC, WPF, XAML, Winforms, VBA, VB Script, Java not recent
• Client side programming Javascript, jQuery, CSS, HTML, DHTML
• Object-Oriented Programming Concepts and methodologies, Dependency Injection
• Test Driven Development TDD
• SQL Server 2005, 2008, MS Access Database, Oracle, MySQL, Visual Studio 2005, 2008, 2010
• Database Design and Normalization
• Web Services SOAP, SOA, XML, XSLT
• N-tier, AJAX technologies, Sharepoint
• Scripts: DOS Commands, Batch Files, Power Shell
• COBOL II, UDB / DB2, SQL, VSAM, CICS, MQ

TECHNICAL SKILLS AND CERTIFICATIONS

Hardware: IBM 3083, 3090, 3081, 360/370, 4300, IBM, PCs Compatibles, Hewlett-Packard 3000, Computer Telephony Voice Boards, Bar Coding

Software: OS/390 MVS/JCL AND IBM Utilities, Command Macro CICS 1.6 thru 4.1, CICS Forward recovery and Logging, INTERTEST, Expeditor, EZ-TEST, CEDF, UDB DB2/SQL Stored Procedures, DB2 Connect, QMF, Data Warehouse, ADABAS, MS Access, IMS, VSAM, TSO/ISPF, DOS/VSE, VM/CMS, SAS, MQ Series with Trigger Levels , VTAM, REXX, NDM, FTP, DIALOG MANAGER, CLIPPER, FILE-AID, SYNCSORT, FDLC, SDLC, Data Modeling, SOA, CMM framework

.NET / Client Server: IIS 7, ASP 3.0, ASP.NET 2.0, 3.5, 4.0, ADO.NET, C , VB.NET, VBA, VBscript, Java, J2EE, Javascript, jQuery, HTML, XML, XSLT, AJAX, CSS Cascading Style Sheets , OOP, OOAD, ORM, SOA, WCF, WPF, FTP, SQL, CMS, Java Applets, MS Office Excel, Word, Powerpoint, Access, Outlook , Visio, MS Project, Lotus Notes, Windows 95 , 98 2000, NT,Unix, Zenix

DataBase: UDB DB2/SQL, Stored Procedures, ADABASE, SQL Server 2005 / 2008, Transact SQL, T-SQL, MS Access, IMS, DL I, HP Image

Applications: Brokerage, Commercial Banking, DDA, Savings, Posting System, Vendor Securities Package, SAS, Debt Consolidation, Proxy Systems, Automated Voice Response, Credit Bureau reporting system, Accounting, AR, AP, Order Entry, Invoicing, Letter of Credit System, Magazine Billing System

Languages: ASSEMBLER OS/390, COBOL II, COBOL LE/390, PL/I, RPG III, JAVA 2, J2EE, Java Script, VBscript, Visual Basic, VB6, Classic ASP 3.0, C , VB.net, HTML

PROFESSIONAL EXPERIENCE

Confidential

Sr Programmer Analyst

• Modified programs using C , MVC 5 and Entity framework 6
• Re-wrote a VB6 Active Directory Maintenance Tool written in 2004 into a .net Windows Service in C
• The Windows Service monitors the environment and dispatches threads that update Active Directory on a periodic basis
• Created an as is document describing the current process from the current VB6 code
• Created new documentation for the .net Windows Service with new features
• The system is constantly be modified as per the user's request
• Advanced Queries are utilized for data analysis
• Currently coding the new tool in C using Visual Studio 2013, SQL Server 2012 R2 and Entity Framework 6
• All data is extracted from webpages using the XMLHttpRequest module and advanced screen scraping techniques
• All extracted data is mapped into the MS Access Database
• Excel VBA macros are used for program execution
• Forms are part of the User Interface
• Historical data is analyzed to derive user specified information
• Algorithms can be modified and then reanalyzed to obtain optimal results

Sr Programmer Analyst

• Project Overview: LIPA Long Island Power Association is moving their entire operations which is currently handled by Nation Grid to PSEG. Lockheed Martin took the lead in the entire transition process including hardware and network acquisition and migrate all software to the new data center and run their IT operations.
• Assisted in a transission project where LIPA Long Island Power Association operations with be operated and maintained by PSEG
• Developed applicaions using ASP.Net that interfaced with their legacy CAS Customer Accounting system on the mainframe
• Developed an application migration process
• Assisted in the Disaster Recovery process

Sr Programmer Analyst

• Examined their current legacy LAN based VBA / MS Access applications
• Designed specs for an asp.net solution
• Converted their MS Access database to SQL Server
• Converting existing transactions to asp.net using C

Sr Programmer Analyst

• Worked on a moderization project to convert mainframe applications to .net
• Project was suspended due to budget cuts
• User data was entered into Excel speadsheets
• Designed and wrote a VBA system in which PowerPoint charts were dynamically updated
• Used ASP.Net databinding to replace the existing static page labels with dynamic functions to populate verbiage from the specified language
• Wrote a VBA macro program to generate XML, containing verbiage for each language from Excel
• Wrote a C class to dynamically populate verbiage depending upon the user selected language
• Redesigned an existing website to add multiple language capabilities
• Created technical specifications that were utilized by the other two members of the team
• Designed and wrote a Trading Specialists sub system utilizing ASP.Net in C
• Part of the Broadcort Institutional trading development team. Our current major responsibilities dealt with integrating the Merrill Lynch systems with the Bank of America systems.
• Each Excel worksheet would coresspond to a PowerPoint chart
• A PowerPoint Presentation would be generated for each Excel row
• VBA Macros would dynamically updates the PowerPoint chart objects via the Excel data
• Analyzed Cobol code and created specs for .net C programs / classes
• Created .NET dll components which services all SQL Server IO requests as part of a n-tier infrastructure
• Developed with user CMS Content Management System capabilities
• Developed the user interface based on client input
• Developed a series of web sites for a Home Owner Association with user CMS Content Management System capabilities.
• Maintained and modified various mainframe batch and online Cobol programs
• Designed specs for the Specialists Table
• Determining SQL Server Table requirements
• Designed and implemented the SQL Server Database via SQL Server Management Studio
• Created a Skin System enabling the look and feel of the website to be dynamically changed
• Maintained and deployed all web sites

Project Leader / Senior Programmer Analyst

• Lead project to convert a static web site into an automated e-business site
• Employed Paypal's payment gateway to process credit card payments
• Amazon's SOA SOAP API server was used to retrieve textbook information
• Wrote interfaces to transmits SQL Server data to a MySQL database
• Wrote a C SOAP web app that would accept SQL requests and return the corresponding data as an xml stream
• Assisted in various projects conducted by Rockland Web Design
• Full project life cycle
• Was involved in creating user documentation and training
• Wrote and modified programs Cobol and Assembler to export data from NUHRS to Workbrain
• Monitored DASD Disk space
• Developed the system specs to determine the data flow and program requirements
• Coordinated the mainframe to client server interfaces between the current Nassau County payroll / human resource software NUHRS and the newly implemented Workbrain software package.
• Supported both development and production sites
• Validated all the user entered data via Javascript on a field by field basis
• Maintained C ASP.NET programs
• Wrote a SOAP interface in C that generated messages to communicate between the .net front end and the mainframe back end via MQ and CICS
• TLE supported securities, bonds, mortgages, equities and mutual funds in various capacities
• Worked on the Tax Lot Engine TLE which serviced a multitude of ADP/Broadridge brokerage clients.
• Converted VB .Net programs to C programs
• Wrote a WPF application that could access Web SQL Server data via the web app
• Created a SQL class which handled all the Database access
• XML was used for data transmissions
• Created automated server side transactions to backup current Database Tables and FTP them to a backup site
• Created an Excel application to maintain and document the TLE DB2 tables structures
• Client data was exported to Excel via the SQL Server Import Export Wizard
• VBA macros and Excel formulas were utilized to format data for statistical analysis using Excel
• Data mining techniques were implemented to cull data for reporting and graphing purposes

Mainframe:

• Transactions are downloaded from the web and converted into Quicken QIF format
• Designed and wrote a C application system utilizing Windows Form designer
• SDLC Software Development Life Cycle
• Monitored region activity load balancing reports and adjusted as necessary
• Was responsible for maintaining table entries for the Medco MEDM cross region/LPAR routing programs
• Modified programs for governmental Medicare Part D regulations
• Was involved in the Colombia Data Center Consolidation Project
• Colombia Data Center Consolidation Project:
• Was employed by IBM as a consultant at the A P Corporate site.
• VIAsoft SmartTest Debugger
• Data was imported into Quicken
• QIF Transactrions were stored in the SQL Server database
• Maintained JCL and procs
• Wrote Cobol CICS transactions which commuincated with the front end via MQ
• orked on the Medco healthcare claims system
• Documented existing Columbia jobs, JCL, files
• Created test scripts for Quality Assurance purposes

Mainframe Application Projects:

• Supported mainframe processing for A P Food Stores
• Responsible for problem tickets
• Transferred files to the test environment via NDM
• create trade conformations
• Processed transactions which initiated from MQ
• write CICS transactions that would parallel the batch system which updated DB2 Tables
• Executed all on-line trades for Merrill Lynch clients
• Worked for Global Trades and Clearing System department on the On-Line Trades Processing OLTP System.
• Brokerage Financial Services, Cobol II LE/390, Assembler OS/390, Command CICS 4.1, UDB
• Worked in conjunction with the DBAs in regaring DB2 Table construction and tuning
• Modified programs for Sox regulations
• Wrote SQL Stored Procedures
• On call 24/7 for production support