Programmer/Analyst resume Rochester, NY - Hire IT People

Consultant / Programmer/Analyst
Confidential, Rochester, NY 11/2010 Present

Research and perform daily support for counter issues from third parties vendors.
Dealing with daily productions and business testing issues in a timely matter.
Testing and writing shell scripts code on a Unix platform accessing an Oracle 11 database.
Maintaining Visual Basic Excel macros for a check reconciliation reports.

Consultant / Programmer/Analyst
Confidential,Glen Burnie, MD 10/2009 10/2010

Designing and write test plans for the migrate of Check book and Check letter system to migrate from an HP3000 environment to Windows platform.
Review functional specification and create Test Scenarios
Execute test scenarios, interpret test results and generate test problem reports when necessary
Verify screen layouts, output records and other special processing as dictated by requirement documents
Testing and writing ACU COBOL code on a windows platform accessing a SQL 2008 database.

Consultant / Program Specialist
Confidential, Care Quincy, MA 11/2008 5/2009

Plan, design and developed a Fraud and Abuse system for a Health Care system.
Worked directly with the business and the third party software vendor in the designing and implementation of a database to reconcile claims processed by Ingenix.

Programmer /Analyst
Confidential, VA 4/2001 8/2008

Plan, design, and implement application database code objects, such as stored procedures and views.
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Work with business, application developers, and production teams and across functional units to identify business needs and discuss solution options. I have worked extensively on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
Developed and supported Extraction, Transformation and Load process (ETL) using Informatica Power Center to update tables in Oracle and SQL SERVER.
Extracted and transferred source data from different databases like Oracle, SQL SERVER and IMAGE into a flat file. I developed complex mappings in Informatica to update data from various sources into the SQL SERVER and Oracle. I have created stored procedures inside of SQL SERVER for the claims load process into FACETS and AMISYS.
Responsible for EDI and MACESS claims load into a Health Care Insurance system (AMISYS).
Built Tidal jobs to execute Informatica maps, encrypt and ftp files to vendors.
Created reports and data extracts for reports for users using Microsoft Reporting Services, HP3000 COBOL, Image and Suprtool.

Programmer/Analyst
Confidential, Chapel Hill, NC 9/2000 - 4/2001

Responsible for open enrollment of membership into a Health Care system.
Created reports and data extracts for reports for users using HP3000 COBOL, Image, Suprtool and COGNOS (Quiz).

Programmer/Analyst
Confidential,Rockville, MD 6/1996 - 8/2000

I worked as a conversion project team member to convert data from a HP3000 to an IBM 3090 and back to a HP3000.
I supported a Health Care system by doing maintenance and writing new programs using HP3000 COBOL, Image and COGNOS (Quick).

Programmer
Confidential,Washington D.C. 2/1995 - 5/1996

Assisted in developing and maintaining programs that were part of the U.S. Navy\'s personnel tracking system. Jobs included coding, testing and implementing into production COBOL on a HP3000 system. Programs included code accessing IMAGE.
Developed and executed software test plans involving system enhancements and program modifications

Volunteer/Programmer
Confidential,Vienna, VA 6/1994 - 1/1995

Developed and maintained programs as part of a marketing promotion tracking system. Jobs include coding, documenting, testing and implementing into production COBOL II and Easytrieve Plus on an IBM 3090. Programs include code accessing both VSAM files and SQL/DS.

SKILLS:

EDUCATION: