Software:

Windows 2000,XP,7 , Microsoft Access, Excel '2000,2003,2007,VBA , HTML, Active Server Pages classic , SQL, FrontPage, SharePoint, Exposure to SSRS, COBOL, OS/JCL, TSO/SPF, VSAM, DUN BRADSTREET GEAC A/P 5.03 AND G/L 2.03, PWS, DOS .bat files, MCP Microsoft Certification Program SQL Server fundamentals certificate

Confidential

Programmer Analyst

Project at Travelers Insurance to Convert Access and Excel Desktop Tools to NGD compliance. Also, making enhancements to existing Access and Excel Tools using VBA.

Confidential

Programmer Analyst

Participated on a documentation conversion project to import data into Excel, creating pivot tables, vlookups and other metrics reporting. Also used VBA programming in both Excel and Access to automate imports and report generation. This was a temporary position, with an open ended contract at Pratt Whitney located in East Hartford.

Confidential

Reporting Analyst

• Responsible for ad hoc requests and automation of reports using .bat files and windows scheduler for the FSA/HRA Operations and Metrics Reporting team.
• Wrote access and Excel databases for users to automate manual processes.
• Automation of Membership stats metric reporting using .bat files. Automated cut and paste functions, subtotals, totals, sorting and creating Outlook e-mails using VBA.
• Automated Claims processing reports utilizing VBA for Excel including Vlookups and Pivot Tables.
• Initiated the use of Sharepoint as a reporting tool. Administrator of SharePoint website.
• Converted scheduled Excel reports to web based reports using SSRS and publishing to Sharepoint.

Confidential

Access Consultant

Created Access Databases for Sikorsky Aircraft

Confidential

Access Consultant

• Updated Access Database
• Kept track of initiating, documenting, and follow-ups of Clinical and Sensory studies using Access forms, subforms, queries, reports and VBA.

Confidential

Enhanced my technical capabilities by enrolling in online classes for MCSD and MCAD certification.

Confidential

Senior Programmer Analyst

• As an assistant Administrator, I was responsible for the support of Crystal Enterprise, User security, and the publishing of Crystal Reports.
• Assisted with creating various ad-hoc reports for various departments using Microsoft Access.
• Coordinated file transfers to vendors for various departments with follow-up procedures to verify receipt of files.

Confidential

Principal Consultant

• Another project involved a complete overhaul of the financial systems at Bridgeport Hospital as part of a Y2K project which included conversion to the Dun Bradstreet's latest versions of their financial systems, and a complete overhaul of the JCL to meet standards.
• Screen validations using vbscript on the corporate website.
• Created Drop-down menus for users.
• Validation of E-mail addresses
• Sending E-mail automatically to resolve issues using CDONTS, scripting, and HTML.
• Updating issues on a MS Access database
• One project involved creating a web page to simulate a help desk for one of our clients using a corporate Intranet which resolved issues more quickly.
• Assigned to various projects utilizing HTML, Microsoft Access, Active Server Pages, and scripting technologies.
• All instream procedures were converted to PROCS with appropriate 'symbolics'.
• GDG's were utilized.
• New request forms were created for Daily, Weekly, Monthly, Yearly, and on demand schedules.
• Procedures were put in place to secure the production JCL.
• New change procedures were developed.
• Documentation was developed using Microsoft Access so relationships between the old and new jobnames and dataset names DSN's could be reviewed easily.
• Another project consisted of a team effort to develop an Intranet website for Staff members of a Health care company. Specifically, I was responsible for developing the homepage and login process. This utilized an Access database for verification of user ID's and passwords and was incorporated into Active

Confidential

Senior Programmer Analyst

• for the support of Millennium A/P and G/L systems for Finance department. Contributed to a conversion From Millennium Mainframe systems to Client/Server platform using Smartstream financial software. Utilized MS Access for security reports and query purposes. This saved time in analyzing the conversion process. Another project involved converting General Ledger and Accounts Payable data to Dun Bradstreets Client server applications. This involved:
• Identifying the data needed for the new applications
• Converting all packed data to ASCII format
• Created file transfer total reports to insure that all critical data was captured correctly.
• Conversion process was completed using COBOL and VSAM in a TSO Mainframe environment.

Confidential

Senior Programmer Analyst

• Member of a technical team for A/P and G/L systems for all divisions of Dun Bradstreet. The team was responsible for:
• Resolving technical issues
• Developing reports per user requirements and assisting in conversions.
• Providing 24 hour on call assistance for restart/recovery and technical support.
• Developing report writers.
• Running jobstreams to creating online queries
• Assisting in conversions to new releases of software.