Mainframe Developer Resume
Baltimore, MD
SUMMARY:
To obtain a position as a Software Developer, working as a team member to accomplish the needs and goals of the organization in an efficient and professional manner. Overall 10 years of extensive experience with Microsoft .Net Including ASP.NET, VB.NET and C#.NET. Have over 3 years of experience in VB.NET and 9 years of experience with Oracle PL/SQL. Plus over 15 years in mainframe development.
TECHNICAL SKILLS:
.Net, ASP.NET, C#, VB.Net, SQL Server 2008, 2010, 2012, 2104, 2106 Visual Studio 2005, 2010, 2012, 2015 TFS, Telerick, Infragistics, Adobe Photo Shop InfoView (for Business Objects), XML, VBScript, JAVASCRIPT, CSS HTML, Visual Basic, SQL, ACCESS XLS, PL/SQL, Natural/AdabasCOBOL, CICS, DB2, VSAM, OS/MVS JCL
WORK EXPERIENCE:
Confidential, Baltimore, MD
Mainframe Developer
Responsibilities:
- Help with maintenance of many large - scale COBOL applications.
- Worked on a Batch COBOL program to help capture the new Philadelphia Sweetened Tax Rate on Sweetened products sold in are Stores in the Philly Area. Program will also apply new tax to sweetened drinks transferred to stores in Philly and deduct new tax from those sweetened drinks transferred to non-Philly stores. This program uses serval DB2 tables, New program has its own ProcLib member and will be ran as a separate step in an existing Batch JCL job
- Worked on New Project to Convent the Current COBOL/CICS RX Inventory Management System Programs to a VB.Net Portal application. This project required understanding about 9 to 12 COBOL/CICS programs and then work to convert them to VB.Net but continue to use the existing DB2 tables that are being used by the COBOL/CICS programs as to creating new tables in SQL Server 2016.
- Created a new Beauty Care Application (App) for the Rite Aid Beauty Advisor’s iPads. I have been involved in the full life cycle on this project. From initial requirement needs to Application design, Database design, Application coding using Visual Studio 2105 and C#, Database Creation with MS SQL Server 2106, and User Acceptance testing. Currently New Beauty Advisor iPad App is in Beta testing in about 8 different Rite Aid stores.
- Have been involved with helping to convert both VB.Net Portal Applications and COBOL programs for the possibility that some of our store will be sold off to allow for us to merge with Walgreens.
- The coding changes have required us to be able to determine if a user that logs on to the system is a Rite Aid user or a user from one of the diversified stores that we are still supporting.
- This project has required me to make changes DB2 table queries and procedure. Then VB.Net applications being modified are using the OleDBConnection so that the portal applications can connect to the DB2 database and not to a SQL Server database.
Confidential, Washington, DC
Senior System Analyst
Responsibilities:
- I supported applications written in VB.Net also with applications written in Django.
- This project had me working with SQL server 2012 and 2104 as well as the versioning tool GIT and GITHUB.
- I worked to get programs that were stored is SourceSafe converted to using the GIT versioning Software, which required me to work with about 800 programs that had to be converted to using GIT tools and being able to access them through the GIT repository.
- I also supported jobs that were involved with getting documents scanned and entered for the 2016 election. I had to make sure scanning programs where functioning correctly and scanning the proper fields that need to be scanned for each member running for the Senate.
- Scanning software was written using VB.net and had to be updated for new printers that would all office of public records to scan more pages per hour. Each election package contained about 300 pages that had be scanned. Documents also had be created after scanning to show that the packet did get received on time and that all pages where scanned. The document then had to be e-mailed to the person running or re-running for the senate and a copy also had to be sent to the DOJ for legal reason. To record that the person running did get their documents in during the time frame require.
Environment: VB.Net, SQL Server 2012,2014, Django, GIT, Python
Confidential, Washington, DC
Senior System Analyst
Responsibilities:
- Worked with Members of Purisolve to help create a new import/upload process for the SWETRS (Service Wide Employment Tax Research System) as part of their Remote Data Entry (RDE) system.
- I have worked very closely with members of the SWETRS team to do upfront analysis needed to understand what their needs were for the Import Upload process, including what types of forms they wanted to import and have uploaded to their oracle SWETRS database. I order to help create a while working Import/Upload application, several weeks of analysis meetings with their users were required to research and learn about the Employment applications process and about how tips must be reported to the IRS by Employers and Employees.
- Worked with the Purisolve team members to help write the requirements document and help make needed changes to current Consolidated Design Document(CCD) to include all changes that were going to be made by our team including new applications being added to their RDE system as well as changes to the existing applications new stored procedures and changes to existing stored procedures.
- Worked to create new .Net C# modules that would become part of the existing RDE to allow the IRS users to Import several types of excel files. The new process will allow user to select which type of excel file they which to import then allow to view the import file. Once the import is complete and user have viewed the imported version of the excel file the user can then upload the file. This will then update several different tables in the Oracle SWETRS database. The upload process required the creation of several new stored procedures using Oracle PA/SQL code
- Worked to update existing RDE programs to accommodate the new fields that would now be modifiable due to the users being able to upload excel data to the SWETRS Database tables.
- Helped to develop needed requirements for this new project by working with the IRS SWETRS business Team members.
- Helped to develop the system test plans that would be used to test all of the changes made by our team.
- Started new project to help get IRS SWETRS team over to SharePoint 2013. During the first phase of this project I worked mainly on requirements gathering at this point.
Environment: Visual Studio 2012, ASP.Net 4.5 with C#, Oracle 11g and Oracle 12g
Confidential, Harrisburg, PA
Software Developer
Responsibilities:
- The SQL is needed so that each license type can get their own version of professional and legal questions created for that specific licenses type, which is then used once that license type goes live on the PA state licensing website.
- This job requires working closely with the end users, those being the members of the different licensing boards from Health Care, Business, Real Estate and Motor Vehicles, and the Nursing to help them make sure that they get all the important information from their paper application to their new web version of that licensing application.
- The goal of this current project is to have all 300 of the States Paper Applications on-line by December 31st. As of August 1st, our team had brought 135 of the 275 licenses on-line. With a goal to bring another 41 on-line by September 5th
- This Job also requires writing the User Acceptance test scripts that are used by the different Licensing Boards when completing their user testing of the new on-line versions of their board licenses.
Environment: HTML, SQL
Confidential, Washington, DC
Senior Software Developer
Responsibilities:
- As a Senior Software Developer worked on contract for Subsystems.
- Technologies on their FAA (Real Estate Management System).
- Completed work to redesign the REMS Website Home page and the REMS website landing page which users are directed to after logging into REMS from the home page.
- Worked to make home page and landing page both be more 508 compliant.
- Both the home page and landing page were rewritten using ASP.Net 4.5 with C# used for the code behind and for the data access layer pages;
- Also worked with Adobe Photoshop to create all new images and buttons for the website redesign.
- Worked to help convert the REMS existing web pages from classic asp to Dot Net. Conversion involved a complete write of their classic asp pages to 4.5 ASP.Net with C# being used for the code behind and data access layer pages.
- Rewrite also required me to help to write some new oracle data queries for each new ASP .Net application being converted using oracle 11g.
Environment: Visual Studio 2010, 2012, ASP.Net 4.5 with C#, Oracle 11g
Confidential, Harrisburg, PA
Senior Systems Analyst
Responsibilities:
- As a VB .Net Developer of the Actuarial team my responsibilities include maintaining the companies Debit Tool windows software which is used to determine underwriting factors for new and existing lines of business.
- The Debit Tool is used by Aetna’s Marketers, Medical Underwriting, and Financial Underwriting staff in helping to determining the risk and cost of insuring individual or small/large groups.
- As the solo developer on the Debit Tool project my duties have included gathering new requirements from the Medical Underwriters and Actuarial team members for enhancements to the existing Debit Tool software.
- Along with requirement gathering and Design Specification Writing, also handled all of the coding modifications to the Debit Tool using VB .Net and SQL Server 2008, 2012 and LINQ.
- Worked on major modifications to the Debit Tool. Modifications required me to create addition Windows forms and additional Telerick reports for the Finical and Medical underwriters. These changes to the Debit Tool went live in December 2012.
- Completed requirements gathering and Design Specification writing for the next Debit Tool project.
- New project required additional changes be made to the Debit Tool for a new line of business which allows Confidential to write health insurance for individual and groups in the state of Texas. This change went live in February 2013.
Environment: VB .Net, SQL Server 2008, 2012 and LINQ
Confidential, Rockville, MD
Senior Application Programmer
Responsibilities:
- Involved in ASP.Net and C# maintenance programming on the new RFS (reporting and Feedback System) for Confidential that went into production January of 2010.
- Did ASP.Net and C# maintenance programming on the new RFS (reporting and Feedback System) for Confidential that went into production January of 2010.
- My role as a .Net developer was helping to resolve defects that were found in the new web applications via C# and ASPX pages, I was also required to make C# coding fixes to the data access layer and help with SQL fixes to the oracle stored procedure.
- My role as a .Net developer was helping to resolve defects that were found in the new web applications via C# and ASPX pages.
- I was also required to make C# coding fixes to the data access layer and help with PL/SQL fixes to the oracle stored procedure.
- Was involved with making sure that unit and system testing of all fixes was completed prior to the .net coding changes going back into production
Environment: ASP.Net 4.0, 4.5 and C# Oracle PL/SQL
Confidential, Rockville, MD
Senior Application Programmer
Responsibilities:
- Redesign was done using ASP.Net and C# along with using ASPX.net for the new screen development work. C# was used to write the applications Data Access layer and Business layer objects, C# was also used to write the ASPX code behind pages.
- One of my other roles was involved with making sure that unit and system testing of all fixes was completed prior to the .net coding changes going back into production.
- Helped to create new web application for Confidential by converting their old Issuer Information System from a Clipper/Dbase to a VB Web based application.
- New VB Web based system was used by Confidential Issuers to enter their Monthly Reporting data and their Soldiers and Sailors Civil Relief Act data.
- Was involved in creating using Visual Basic, VBScript, ASP, and JavaScript on the development of a new web site for Confidential called Your Path to Homeownership using HTML 4.0 and JavaScript.
Environment: Visual Studio2005, ASP.Net 2.0 and C# Oracle PL/SQL
Confidential, Rockville, MD
Senior Application Programmer
Responsibilities:
- Worked with Adabas DBA using Software AGs EntireX Broker products to web enable several of Confidential 's Natural Applications. This project required us to first install EntireX Broker on UNIX and on our Web Server. Once this was completed new Natural applications were written to pass data from Adabas to EntireX. On the web side new data entry screens were created using ASP and XML. By web enabling many of Confidential 's core applications Confidential was able to move away from having to using the Application Gateway software to access these applications in UNIX.
- Helped to create new web application for Confidential by converting their old Issuer Information System from a Clipper/Dbase to a VB Web based application. New VB Web based system was used by Confidential Issuers to enter their Monthly Reporting data and their Soldiers and Sailors Civil Relief Act data. New web-based system was created using Visual Basic, VBScript, ASP, and JavaScript
- Performed maintenance and development on the Mortgage Back Securities System, this system was written in Natural/ADABASE. Development was for Loan Level Processing and Soldiers and Sailors Civil Relief Act Processing.
- Created a new Installation version of Confidential 's “Issuer Information System” which at the time was written in Clipper/ DBASE, Installshield was used to create the Executable for the PC software.
- Worked on the development of a new web site for Confidential called Your Path to Homeownership using HTML 4.0 and JavaScript. This new Confidential web site was used to help inform First Time Homebuyers with what all is involved when purchasing a new or used home.
- Performed maintenance to the Confidential web site and helped to make web site ADA compliant. Help to create a new download page for the Confidential website. New page will allow Confidential Issuers to download software from the website to their own PC.
- Performed modifications and maintenance to five clipper/DBASE systems, the Issuer Information System, Custodian Account Verification System, Loan Level Error Reporting System, and Issuer Exception Display System.
- Performed Y2K modifications and testing to the Issuer Information System which was a Clipper /DBASE application
- Helped to design the MSA and Financial Data Warehouse Systems. HUD's Home Equity Conversion Mortgage System department will use the two new systems. Performed modifications to other HECM programs for Y2K enhancements using COBOL II, MVS/JCL, and VSAM.
- Performed modifications to programs in the Data Collection Account Management System using EZTRIVE, COBOL II, MVS/JCL, and VSAM.
Environment: Natural/Adabas, XML, Clipper/Dbase, COBOL II, MVS/JC
Confidential, Baltimore, MD
Application Programmer
Responsibilities:
- Performed modifications to Medicare's Common Working File Computer System.
- Made Modifications to Medicare Part A, Part B applications, which handle Inpatient, Outpatient, Home Health, and Hospice claims
- Wrote Several New On-Line and batch COBOL applications for Home Health claims Processing Modified Inpatient processing to handle Direct/Indirect Graduate Medical Education Refunds to Hospitals with HMO Medicare Entitled Patients.
- This project required modifying fourteen applications, plus it required getting a full understanding of Inpatient claims processing.
- This project required over four hundred man-hours but was not started until the middle of February. Code had to be in BETA by April 22. This deadline was met, and the modification went into production on June 1 1998.
Environment: COBOL II, MVS/JCL
Confidential, Baltimore, MD
Programmer
Responsibilities:
- Performed modifications to Clinical and Pharmacy Systems.
- Wrote several new on-line and batch applications for both systems using ADS, COBOL/CICS, and PC Mainframe.
- Developed new function for Medical Records.
- New function was designed to allow users to request medical records on-line using the Clinical System. If the request for a medical record is 24 hours or less the user can now request the record STAT and a STAT Requisition will be produced in Medical Records for processing.
- All other request are processed during normal nightly batch processing, whereby a medical record routing card is generated and sent to Medical Records for Processing.
- Performed coding and testing for New Pharmacy Satellite in Pediatrics.
- This project required modifying three different Pharmacy applications Unit Dose IV, and Labeling system.
- Developed new on-line function on Clinical System for scheduling of patients to on-site clinics. This new function will be used by the Emergency Department and several other selected Units to schedule patients for clinics.
Environment: COBOL II, MVS/JCL