Resume

Sign in

Cobol Data Analyst

Location:
Washington, DC
Posted:
June 05, 2022

Contact this candidate

Resume:

Jeffrey Clendening

*** ******** ***

Langhorne PA 19047

Mobile Phone: 215-***-****

E-mail: adrauc@r.postjobfree.com

Career Highlights

Have been vaccinated against COVOD -19.Received second shot Pfizer vaccine on

4-20- 21.

Graduated Summa Cum Laude from Philadelphia University.

Successfully Used access, Oracle, Team Space and excel to perform quarterly Sox audits for all sox related systems accessed by CCM (Customer Contract Management) employees.

Successfully loaded customer rebate data into Oracle tables within the agreed upon time limit. Met all customer imposed deadlines, ensuring customer financial reward.

Successfully worked on server migration project as the UNIX batch tester. Tested over 130 PL/SQL batch scripts. Made corrections to failed scripts and Java programs so that they would pass in the new batch environment. Wrote UNIX shell scripts using awk and sed.

Active participant in a six year project involving the conversion from 370-Mainframe environment to a client server / UNIX environment. Project involved converting mainframe programs and JCL to run in a UNIX/Micro Focus COBOL environment culminating in successful go live in January of 2005.

Successfully created detailed monthly strength reports for both Congress and the Pentagon and met monthly congressionally mandated deadline 99% of the time.

PROFESSIONAL EXPERIENCE

Uber:

Driver

August 15 2016 to Present

Duties include:

Picks up customers and takes them to their destination of choice.

6,000 trips to date

Over 3,000 five star rated trips to date

Liberty News

Systems Analyst

Dec 28 2017 to Sept 21 2018

Duties Include:

Maintains Unix Shell Scripts, copybooks and data.

Write Cobol programs to address business needs.

Makes updates to Cobol programs.

Provides IT support to users of the AIX UNIX operating system.

Provide UNIX admin support with SMIT to staff.

Sylogent:

Data Analyst, Newtown, PA - Application & Client Support

February 2016 to July 2016

Duties included:

Successfully provided Tier 1 & 2 support to clients with problems encountered within Sylogent applications.

Successfully closed over 600 user management tickets in 6 months while working for Sylogent.

Successfully built application reports, custom and standard with Microsoft SQL Server and Logi Info Studio.

Successfully managed & processed support issues in Sylogent’s support ticketing system (zendesk)also used JIRA to record and process product defects.

Assisted in the testing of system before new releases or client instances went live.

Assisted with change management of existing applications.

Paragon:

Business Analyst WestPoint PA - Contracted to Merck

August 2012 to January 2015

Duties included:

Worked as Security Administrator for CCM(Customer Contract Management) Applications. Provided users front end access to CCAS (mainframe), Government Pricing, Gencord CM, RME (Model N) Payhub, GPAS, Documentum, and Team Space.

Successfully resolved issues related to security access. Successfully closed more than 500 Security related tickets over 12 month period.

Successfully added users to eContracts. A web based app used by Merck employees and customers.

Successfully conducted quarterly and semiannual Sox Identity audit for all users accessing CCM apps. Also Conducted eContracts Audits on a semiannual basis.

Used SQL, Access and excel to create audit.

Created and maintained Access databases to track new users, deactivations and account modifications.

Effectively wrote working instructions for eContracts, The Sox Security Audit and System Access.

Successfully created approval routes in RME for users and managers.

Satisfactorily Performed duties as Security Audit champion for CCM.

Randstad:

Systems Analyst Newark, DE - Contracted to HP(Delaware Medicaid)

August 2011 – April 2012

Duties included:

Effectively gathered requirements for enhancements and maintenance to MMIS(Delaware Medicaid Management information system).

Used requirements to write business and technical designs for enhancements and maintenance to MMIS system.

Used Technical design to write or update Cobol programs including embedded db2 code.

Successfully Wrote db2 cursors and fetch statements to import data into Cobol programs. Programs were run on the Solaris UNIX System V.

Wrote embedded DB2 statements within Cobol programs, including cursors and fetch statements to update db2 tables by daily, weekly, monthly or quarterly run batch jobs.

Accenture ATS:

Systems Analyst, Wilmington, DE - Contracted to AstraZeneca

July 2006 - February 2010

Duties included:

Successfully loaded data into Oracle database using Ideal-ECP application. Met service levels every month.

Successfully wrote SQL scripts with SQL developer to add, delete, and update records in Oracle database.

Successfully performed back-end updates using Oracle SQL for over 400 different rebate customers on a quarterly basis

Created Unix shell program to automate claim loading verification process.

Used SQL to run ad hoc queries and create reports.

Effectively used Microsoft Access to create databases, including forms, tables, and reports.

Successfully Wrote and executed test scripts for Unix batch jobs and system testing. Wrote shell scripts in UNIX.

Converted Word documents to online wiki pages. Worked with xml formatted data. Tested data that was sent to us in XML format.

Orizon, INC:

Systems Analyst, Rockville MD - Contracted to US Army in Alexandria VA

April, 1999 - July 2006

Duties included:

Successfully created SQL ad hoc reports using oracle sql, DB2, Toad and UNIX .

Maintained, updated and fixed JCL and UNIX Shell Scipts.

Successfully analyzed client requirements in order to design write and execute Micro focus COBOL programs for HP UNIX system as well as creating The UNIX scripts that ran them.

Mainframe Cobol Programs were converted to Unix Micro-Focus Cobol and JCL Scripts were converted to Unix Shell scripts.

Successfully converted JCL scripts to Unix shell scripts as part of migration from mainframe to UNIX.

Successfully created flat files from oracle tables which were used to create reports that were sent to the Pentagon. Used PL/SQL, Toad, and shell scripts to complete this task.

Created manual files with CICS that were used in reports sent to congress.

Successfully wrote and executed test scripts for Y2K compliance.

Satisfactorily created and Maintained Flow Charts of all COBOL Jobs run on both Mainframe and UNIX systems for Government compliance

Used Secure FTP, FTP and WS_FTP to transfer file between UNIX and Mainframe and from both to PC.

Wrote FTP scripts and menus to automate FTP process on UNIX.

Automated Systems and Programming, Inc.

Junior Programmer, Greenbelt, MD - Contracted to Bureau of Engraving in Washington, D.C

September 1997 – March 1999.

.

Duties included:

Successfully wrote, compiled, and tested Mainframe COBOL programs for Y2K compliance.

Wrote and maintained JCL code.

Successfully converted dates in COBOL, Micro focus COBOL, and WANG COBOL programs to a 4-digit year.

Used TSO, and ISPF on daily basis to navigate Mainframe MVS/370

Successfully wrote Cobol programs to convert Employee payroll data to 4 digit year.

EDUCATION

Bachelor's Degree, Management Information systems

Philadelphia University Philadelphia PA,

Degree completed Nov, 2011 - Summa Cum Laude

Associate of Applied Science Degree in Computer Information Systems

Lord Fairfax Community College Middletown, VA

Degree completed – 1997 – Cum Laude

Information Technology certificate in Web Content Design

University of Virginia

Certificate completed - 2006

TECHNICAL Experience:

Experience in integration testing, test script writing, creating flow charts, batch testing, and creating autosys jar scripts. Experience writing HTML, HTML-5, CSS, bootstrap, Microsoft Web Matrix, Note ++ and JavaScript. Git-bash, sublime,

Extensive experience with Mainframe 370, HP-UNIX, AIX UNIX, Solaris UNIX System V.

Extensive experience using UX-HP tools such as VI, AWK,SED, Cut, head, grep fgrep, pipe sync-sort, ftp, borne shell, c shell and k shell. SMIT( System Management Interface Tool).

Current specialization is in User management, Microsoft SQL Server, Oracle-SQL, SQL Developer, SQL Plus, My-SQL, Access, Quest Software including Toad, Microsoft management Studio, and Logi Info Studio.

Experience using Microsoft Word, Access, PowerPoint, Excel, Microsoft Edge, Google Chrome, Firefox, and Microsoft Explorer 11, 10



Contact this candidate