Sas Developer Project Management
Resume:
James Covington
*********@*****.***
TECHNICAL SKILLS:
Database/File Management: DB2; VSAM; Oracle; Teradata; Netezza; SQL Server
Project Management/Quality: Workbench, MS Project, VISO, Quality Center, MS Office, Mainframe
Languages: COBOL/II, CICS, Easytrieve Plus, SQL, SAS, PC SAS, UNIX, Enterprise Guide
PROFESSIONAL EXPERIENCE:
USCG Aviation Logistics Center, Elizabeth City, NC/Remote Oct 2022 – June 2025
SAS Developer / Contractor
Key Achievements:
●Supported USCG including new development and maintenance.
●Supported asset management reporting including availability, repairs/downtime and location.
●Supported crew log transactions. Building payroll hours base upon mission type.
●Supported USCG over 100 Cognos reporting thru an ETL process to create input tables.
●Performed Ad hoc report requests.
Environment: SAS, SQL, Oracle SAS Studio running under Viya, TOAD
Citizens Bank and Trust, Remote Nov 2021 – Apr 2022
SAS Developer / Contractor
Key Achievements:
●Part of a Consumer Accounting Analysis Reporting Team supporting of credit card, revenue sharing and HSBC portfolio support.
●Resolved SAS Log issues with existing Production Code.
●Performed Ad Hoc requests.
Environment: SAS, SQL, SQL Server, SAS Enterprise Guide, PC SAS, Teradata
Bank of America, Remote Nov 2020 – Aug 2021
SAS Developer / Contractor
Key Achievements:
●Part of a Recovery Execution Team supporting placement of credit card, HELOC and Line of Credit accounts in different stages of account delinquency.
●Supported DSA system with enhancements and BAU processes.
●Performed peer review of existing processes.
●Performed Ad Hoc requests.
Environment: SAS, SQL, Teradata, SAS GRID, UNIX, SAS Enterprise Guide, TOAD
CVS, Northbrook, IL Mar 2020 – Jun 2020
SAS Developer / Contractor
Key Achievements:
●Supported a billing system for a diabetic care program. Tasks included validation of vendor data, ETL tasks for a Teradata database, creation of an internal billing files and reporting require
●Performed research on possible data issues with resolution for member enrollment.
●Performed Ad Hoc requests.
Environment: SAS, SQL, Teradata, SAS GRID, UNIX, SAS Enterprise Guide, PuTTy, SQL Developer.
JPM Chase, Wilmington, DE Jan 2019 – Dec 2019
SAS Developer / Contractor
Key Achievements:
●Developed and supported card portfolio control reports including gathering requirements, creating functional specifications, coding, testing and implementation.
●Performed research on possible data issues with resolution.
●Ad Hoc requests.
●Performed code peer reviews.
●Developed Business Requirement Documents with functional specifications for offshore developers.
Environment: SAS, SQL, Teradata, Oracle, UNIX, SAS Enterprise Guide, Mainframe SAS,
Wells Fargo, Charlotte, NC Sep 2018 – Jan 2019
SAS Developer / Contractor
Key Achievements:
●Part of a team to implement a new Detection and Alert platform system across banking applications. Specific programs developed include data enrichment, data deduping, KELS and volume threshold identification.
Environment: SAS, SQL, Teradata, Oracle, Postgres, SAS Studio, SAS Viya, SAS Enterprise Guide
JPM Chase, Wilmington, DE Jan 2017 – Jun 2018
SAS Developer / Contractor
Key Achievements:
●Developed and supported card portfolio control reports including gathering requirements, creating functional specifications, coding, testing and implementation.
●Performed research on possible data issues with resolution.
●Ad Hoc requests.
●Performed code peer reviews.
●Developed Business Requirement Documents with functional specifications for offshore developers.
Environment: SAS, SQL, Teradata, Oracle, UNIX,
Catalina Marketing, Schaumberg, IL May 2016 – Nov 2016
SAS Developer / Contractor
Key Achievements:
●Conversion of SAS programs to a Big Data Netezza database.
●Support of BAU processes.
●Perform testing and peer review for converted programs.
●Ad Hoc requests.
Environment: SAS, SQL, Oracle, UNIX, Enterprise Guide, Netezza
JPM Chase, Columbus, OH Sep 2015 – Mar 2016
SAS Developer / Contractor
Key Achievements:
Part of a team to complete firm wide password remediation project. Role included training, code review
●Debugging of code issues introduced by the new Cyber coding standards,
Responsibilities:
●Scheduling meeting with Business Partners and Senior Management.
●Ad Hoc requests.
●Support of BAU processes.
Environment: SAS, SQL, DB2, Teradata, Oracle, UNIX, Enterprise Guide
State of Wisconsin HEAB, Madison, WI Jun 2015 – Sep 2015
SAS Developer / Contractor
Key Achievements:
●Interim Information Technology Programmer responsible for all phases of IT.
●Jobs, development of Technical Excellence Grant program, enhancements to Academic Excellence Grant
●Program.
Responsibilities:
●Supporting BAU processes.
●Adding reporting to existing systems for audit purposes.
●Resolution of reported issues to existing systems.
●Ad Hoc requests.
Environment: COBOL, CICS, SAS, SQL, DB2, Mainframe, UNIX.
Discover Financial Services, Riverwoods, IL Ju 2014 – Mar 2015
SAS Developer / Contractor
Key Achievements:
●Lead on project to convert flat flies to Teradata database. Performed analysis on data variables to include, new derived and data type selection. Worked with data modelers, DBA and ETL teams on data validation, test plans and implementation. Scope included over 30 new tables.
●Supported recovery systems including bankruptcy and probate.
Responsibilities:
●Interacted with business partners form Risk management to gather requirements.
●Interacted with Senior Management regarding project status.
●Extracted data from Teradata using SAS/Access, SAS/SQL Pass thru facility and create SAS data sets.
●Worked independently on gathering requirements, data preparation, waterfall creation, and creating reports as requested.
●Extensive use of SAS Enterprise Guide for creating waterfall report and other Ad-hoc jobs.
●Wrote Ad-hoc programs to reconcile data between Mainframe and UNIX servers.
Environment: SAS, Enterprise Guide SAS Macros, SAS/Access, SQL, Teradata.
Capital One, Metawa, IL Aug 2012 – May 2014
SAS Developer / Contractor
Key Achievements:
●Implemented the reissue of card portfolios from the HSBC brand logos to CapitalOne logos.
●Implemented statement credits for credit score refunds programs that were cancelled due to rebranding.
●Implemented balance transfer marketing programs.
●Support BAU processes.
Responsibilities:
●Interacted with business partners from marketing management to gather requirements.
●Extracted data from DB2 warehouses, SAS data sets and SAS DataMart’s using SAS/Access, SAS/SQL Pass thru facility and create SAS data sets. Worked independently on data preparation, waterfall report creation,
●and test plans. Extracted data from mainframe flat files and creating SAS data sets on UNIX.
●Using Quality Center logged defects in a testing role. Used Quality Center as a developer to resolve issues during testing.
Environment: SAS, SAS Macros, SAS/Access, SQL, DB2, Mainframe, UNIX
EDUCATION:
●A.A.S. Oakton Community College, Data Processing
Contact this candidate