PROFILE

Systems Analyst with over 20 years of experience in development and maintenance of mainframe and AS/400 applications Very strong in the design and development of business applications, especially in the health insurance business. Has extensive background in COBOL, DLI, IMS DB/DC, SQL, DB2, DB2 Stored Procedures, CICS, JCL and AS/400 CL.

PROFESSIONAL EXPERIENCE

Confidential

Applications Developer III

• Worked on Health Care Code System HCCS DD Enablement Project implemented on July 12, 2013. Major accomplishments are -

Conversion and load process

• I got the most complicated part of the conversion and load process.
• I also took it upon myself to learn the database in order for me to get things done on my own and finish all my tasks correctly and on time.
• There were two DB2 programs originally for the procedure codes, ICD9 diagnosis codes and modifier codes. Revenue code was added later and I came up with a program to do the conversion and load for revenue codes in one day.
• The running of the test conversion and load process was assigned to someone else but I took it upon myself to troubleshoot any issues that came up almost every time we did the test conversion and load. Just to reiterate, it was not my job to do the troubleshooting.
• I put in a good amount of extra time were logged to get this project done.

Blue DEVEL Mass Update Project

• I did eight programs for this project. I took over the programs assigned to a co-worker in order to finish the project on time.
• I showed a co-worker 'the ropes' so he can code his Blue DEVEL programs and gave him the JCL to unit test them.

Batch jobs DD project

• I asked if I can help out with this project and worked on 4 jobs. Three of them worked without any problems and one had a JCL error but was fixed right away during the release. All file outputs from these jobs came out correct.
• Again, I took over a co-worker's jobs for this project. I originally was supposed to do two jobs but ended up with four.

Materialized Query Tables MQT

• I was assigned this project to me and I basically did almost everything. I did the testing, documentation, coordination with the DBAs and filling out the SARA requests. Also helped co-workers troubleshoot their testing.
• There were MQTs assigned to a co-worker but he had to work on the affiliation project so I took over those that were assigned to him.

Change Request Reissue/reinstated procedure code

• I was given a change request on 6/20 and had to finish by 6/21. Andy Back gave me a set of SQL codes which I tweaked and was able to get things done by end of day Friday, 6/20. We loaded the reissue procedure codes on 6/21 in test.
• There was a problem with the FTP to the production box but with Tracey Welch and Andy Back's help we were able to load to production the next Monday, 6/24. Randy Taylor confirmed that everything looked good. Alison Heibel thanked me profusely for the job well done.

Batch delete jobs DD project

• I basically took over this project from a co-worker. The requirements had to be revised to include checking for PRPD parentage and inheritance. This was not anticipated when the original requirements were written and was only discovered after the unit test I conducted.
• I am learning more about Blue DEVEL to come up with the right code to make sure the delete programs work.

July 12th Release

• I monitored the conversion and load part of the release. I have to again say here that this is not assigned to me. I did SPUFIs and checked the output from the load jobs to make sure the process worked correctly.
• I checked for any possible issues before the jobs ran and fixed them in order to move things along faster.
• I volunteered to be on call on Monday because there were daily jobs that were running for the first time that night. I was not required to be on call but because it was only Tracey Welch working that night, I went on call as well. There were issues with some of the jobs and I fixed one of the jobs.

Programmer/Analyst for Prodigy Staffing Solutions

Confidential

• markets they serve.
• Worked on TBS Membership/Enrollment Billing system, Marketing, Corporate Communications, Pharmacy, Provider, Claims, Finance and HIPAA related projects Completed more than a dozen projects in less than a year. Notable accomplishments are -
• Revamped a process called Flex Bridge that processes HRA and HSA members for BCBSDE. Streamlined the process and removed all the bugs in the system resulting in less manual work for the business users.
• Implemented the government mandated Civil Union project in the membership system. Same sex partners can now be enrolled with equal benefits as traditional couples. Due to lack of resources, this is a project for three persons that I worked on by myself.
• Created the Agent Broker reporting system to provide senior management the ability to review loss ratio reporting and analysis for individual business by Broker/Agent. With this reporting system in place, Actuarial is now able to gather this information.

Confidential

• Independence Blue Cross provides premium health insurance benefits in the greater Philadelphia area. With over three million members, it is the largest health insurance company in the area.

Confidential

• Built a new accumulator sharing system from the ground up using COBOL and DB2 stored procedure for Penn Behavioral adding 22,000 new members responsibilities included requirements gathering, design of the process, coding, testing and debugging. This new process also served as the template for at least 12 other behavioral health vendors that will bring in more business for the company.
• Developed a new system that processed pharmacy claims for Lincoln Financial, bringing in 10,000 new members.
• Other projects included development of process for Teleflex new business Age Band a process that saves money for IBC on claims payment for members with older spouses Magellan Autism government mandate project.