PROFILE

Conscientious, results-oriented senior information technology professional with a unique combination of skills and strong knowledge of management information systems. Able to manage several complex projects simultaneously and work with fluctuating volumes with excellent leadership, administrative skills and quantitative abilities.

AREAS OF EXPERTISE AND EXPERIENCE

• Project Management Integration/Testing Operations Management
• Systems Analysis Quality Engineering Services
• Structured Programming Methods Project Lifecycle Methodology
• Object Oriented Programming Methods Database Management
• Accounting/Financial Background Audit and EDP Experience
• Operations Research Management Supply Chain Logistics Management

DEMONSTRATED CAPABILITIES for Process Improvement and Cost Savings

ANALYZED and DESIGNED new systems for many financial, manufacturing, insurance, banking, state government, federal government and military projects. Produced cost efficient computer systems and subsystems. Eliminated the need for more expensive consulting services and reduced company processing and expenditures by 50 annually.

PRODUCED and EVALUATED Cost Benefit Analysis on Hardware and Software and recommended compatible and affordable changes to the system saving 30 on payback period.

TRAINED and SUPERVISED personnel who would support the new and completed applications which were scheduled and fully automated. Improved performance by 25 with changes.

SCHEDULED project completion times based on priority workloads and used workarounds when the manpower was limited using PERT and Critical Path Method. Saved 40 in timeline.

RECOMMENDED establishing internal controls in the audit trail of various systems to comply with generally accepted accounting procedures, satisfying CPA requirements. Saved owners accounting service fees of 150K annually.

EMPLOYMENT HISTORY

Confidential

Senior IT Consultant

Supported Mainframe batch and CICS healthcare systems. Worked on mainframe Cobol programming, DB/2, IMS, JCL, VSAM, Endeavor, infopac, IBM utilities, MQ series and client server SQL applications with MS SQL Server 2005/2008 and .Net. Also worked on Web development using .Net Technology, C .Net. Used IBM Lotus Notes and IBM office suite, sharepoint, and Wellpoint software. Used BI Tool, OLAP, ETL, MDX and Informatica working with Cube Databases.

Confidential

Senior IT Consultant

• Working full time at home telework on a software engineering project to reverse engineer
• Micro Focus Cobol and Mainframe Cobol II programs and documenting them using MS Office, MS Visio Diagrams and storing the documentation up on Sharepoint. Reprogramming the source code, compiling them, unit testing, debugging and using Source Safe and Endeavor.
• Using accepted methodologies for process improvement. Working also with JCL, TSO, CICS, VSAM, ISAM, Atlas B-Tree, DB/2 and other mainframe utilities. The system interfaces with
• Unix and MS windows using calls to C and Java programs, and with email messages being
• sent to the users. Also working with 2007 and 2010 MS Office versions. The current system is a medical health claims adjudication system using large Databases and complex file structures. There are web servers and SQL servers being used after the calls are executed
• via the Micro Focus Cobol programs with embedded mixed language code in the linked object modules which are C programs. Worked on VI editor, Unix, MS SQL Server 2005/2008 and Oracle. Used BI Tool, OLAP, ETL, MDX and Informatica working with cube Databases.

Confidential

Senior IT Consultant

Worked full time on-site and some telework part time on projects with IBM Tivoli Suite of Products with mainframe Programming and client server SQL applications. Also worked on Web development using ASP,ASP.Net, VB.Net, C .Net. Used JCL, TSO, CICS, VSAM, ISAM, DB/2, CA-ADSO, IMS, CA-IDMS and other mainframe utilities. Worked on VI editor, Unix, MS SQL Server 2005/2008 and Oracle. Used BI Tool, OLAP, ETL, MDX and Informatica working with

Confidential

• on Aetna Financial, conversions, Claims, Marketing and Compensation systems using DB2 imbedded Batch into Cobol, SPUFI ,COBOL, CA-ADSO, IMS, CA-IDMS, Tandem Cobol, Guardian Pathway, Tacl, OS/JCL,TSO,CICS,EDI, ISAM, VSAM, DB/2, File Aid, Star Tool ,MQ Series for data, Changeman for moving software packages thru lifecycle, One Info for ,Opc Scheduler on batch and online systems. Wrote NDM/ConnectDirect scripts and
• used FTP, HTTPS and NDM/ConnectDirect plus other file transfer utilities. Used MS Office and Visio for presentations of high level and detail level systems from requirements and also flowcharted system in Visio. Many tables were DB/2 for Claims and some IMS besides. Programmed in Easytrieve, besides COBOL to retrieve fast data and information to be used later in reporting process via MQ Series and used EDI for electronic commerce transactions between companies that had financial information. Used Rexx and Clist and wrote, tested and debugged Cobol II programs in Batch and online mode. All programs were written with embedded SQL code to access the DB/2 tables. The AIS system on the Mainframe was complex with many financial routines with custom reporting. Worked in a senior level role with extensive communication, presentations with all levels of management and users in Application Development, QES and the Business areas. Worked in the QES labs overseeing the testing, scripts and Master test strategy plans in test manager in the rational suite of tools. Traveled to headquarters a number of times a year to the Middletown and Hartford CT Offices to work on major critical projects. Worked on Web projects such as DataDrill using .Net VB and older ASP programs on RAM QES Lab application. Worked on a Project Management application for all project Leaders and Managers in AIS. Provided Technical assistance plus creation of training manuals written in MS PowerPoint. Saved company 50 in Budgeted costs. Used MS SQL Server 2005/2008 and utilities in Sequel Enterprise version. Used BI Tool, OLAP, ETL, MDX and Informatica working with Cube Databases.
• The Aetna AIS Mainframe Claim systems had specific claim codes and help was available by the business analysts who reported to the project managers to give advice and consultation on the transactions which were Claims from all states which had to be processed in a timely manner to avoid government penalties. Leadership, management skills with the client business areas was practiced along with clear communication, teamwork to foster working relationships with the team and the client business departments. Worked on VI editor, Unix, SQL server 2000 and Oracle.

Hardware Platforms and Software

Mainframe Systems: IBM 3090, 370, 360, MVS IBM Mainframe, DEC VAX, PRIME, COBOL II,III, VS COBOL, CA-ADSO, IMS, CA-IDMS, VSAM, ISAM, JCL, TSO, CICS, DB/2, TANDEM Cobol, ISPF, JESS2,JESS3, File Aid, SQL, Endeavor, Model office, Zeeke, CA7 scheduler, Rexx, Web Sphere, FOCUS 4GL, ADABAS, NATURAL, FORTRAN, PASCAL, EASYTRIVE PLUS, RUMBA, IBM File Transfer system, IBM Utilities,

IBM MQ Series, DB2 imbedded Batch into Cobol, SPUFI , EDI, CHANGEMAN, ONE INFO, OPC SCHEDULER, MS OFFICE, VISIO, CLIST, Star tool.

PC, SQL Client Server and Web: Microfocus Cobol and it's utilities, other PC Cobol compilers, MS.Net VB and C and ASP.NET, Sybase Rapid query system, Oracle, Unix, IBM AIX Unix, Unix Shell scripting, MS Access, SQL, Microsoft Sequel Server 1995-2008, Oracle, DB/2 PC Universal, Visual Basic, VBA, ASP, JavaScript, VB script, MS Excel., some UNIX operating systems, MS VISTA, MS Office Outlook, Rumba, IBM and other connectivity software between PC and Mainframe. UNIX shell scripts, JAVA, C/C , CLIPPER, PC FOCUS, FTP SOFTWARE HTTPS and NDM/ConnectDirect etc. Wrote NDM/ConnectDirect scripts also. For Project Management worked on Microsoft project, timeline, Hourglass, Aetna's time reporting System on the internet, Pert Charts, Linear Programming and Planview reporting and resource management. Rational Clearquest tools, Quality Center Tool, VISIO, Sharepoint and IBM Rational Tools. Used BI Tool, OLAP, ETL, MDX and Informatica working with Cube Databases.