SAS Programmer

PROFESSIONAL SUMMARY

I have spent the last ** years ensuring that data has been properly transformed into information for business use. Whether the business unit is conducting an internal audit, remediating issues with a system of record or meeting a compliance regulator’s requirements for business conduct, the data provided had to be in a format that they can utilize and explain what has happened with client data. I am familiar with finance concepts regarding mortgages, credit cards, life insurance, securities, and real-estate management as well as IT support role.

To complete my work I have had to accomplish the following:

1) Gather data requirements from the business unit or regulator

2) Establish a link to the system of record and extract the raw data

3) Before approaching my clients with results I would attempt to validate the data based on expected volumes or expected values as described by a project document, which may include verification within the system of record

4) Validated that the data pulled is correctly formatted and meets the business unit, SME or regulator’s requirements by holding meetings with them to verify the data for accuracy and completeness

5) Once the data has been confirmed, I have had to put it into a format that my client can best use.

CORE COMPETENCIES

Business Domain Banking: Credit Cards, Mortgage Risk

Databases Oracle

Tools SAS, SQL, Unix

WORK HISTORY

Capgemini (Mar 2018 – Feb 2021)

Citibank – Remediation Project

In this project, I was required to pull data from extracts utilizing SAS EG programs that I created. I then had to create additional code to manipulate that data through the remediation process in order to determine final harms and remuneration actions. This included creating text files to upload to the Unix server to be handed off to other teams for further processing. I also created a SAS tool that other team members could utilize to complete their projects. Within the team we utilized Agile concepts to iterate on the same process and looked for improvements over each project. As part of this improvement process I used PROC SQL predominately when extracting the data as they were large data sets. SAS macros were also used extensively to automate data pulls as much as possible.

HSBC Mortgage Services (Sep 2004 – Dec 2017)

Pulled data from system of record and transformed it for further use utilizing PC SAS/EG SAS

Validated the data pulled in the SOR for accuracy and completeness

Coordinated and worked with SMEs to validate data requirements and during use testing

Wrote PC SAS/SAS EG code to generate production reports and ad-hoc reports

Developed MS-Access databases/applications to supplement SOR processes, and used output from these systems to feedback into the SOR

Conducted audits, when on the auditing team, on consumer mortgages

Participated in a data mapping project led by the ETL team that was part of a move from one data hierarchy to another and insured that the data would flow appropriately to end production reports within Cognos

Financial Temps (Jul 2002 - Sep 2004)

Pulled physical files

Conducted basic audit on files pulled for data accuracy and generated reports from this effort

Fell Real Estate Services/Scribcor Lease Administration (Apr 1998 - Jun 2001)

IT Manager that evaluated, purchased equipment and installed it. This included PCs, network pieces and phone systems

Setup Novel network and created the network infrastructure and security elements

Setup Lotus Notes database server and mail server, and assisted in development of databases

Manpower (Aug 1997 - Mar 1998)

White Cap (Jan 1997 - Apr 1997)

State Of Kansas – Social & Rehabilitation Services (Aug 1993 - Dec 1996)

Northwest Missouri Community College (Sep 1992 - Aug 1993)

CERTIFICATIONS

ITIL Foundation Certification IIBA ECBA

EDUCATION

B.S., Computer Science – Management Information Systems, Sterling College, Sterling, KS (May 1992)

Master’s Certificate in Information Technology Project Management, George Washington University School of Business (October 2006)

Contact this candidate