FELIX K. ACHEAMPONG

**** ***** **** **. ************, MD 20879 301-***-**** (W) 301-***-**** ©

Email: ad30pg@r.postjobfree.com

Objective

Seeking entry into a world class, highly professional organization with a challenging and competitive environment, where I can use my knowledge base and personal attributes to achieve organizational goals.

Summary

Possess good understanding and in-depth knowledge of SAS/BASE, SAS/SQL, SAS/MACROs, and SAS/ODS.

Demonstrated expertise in problem solving and created Macros to improve the efficiency of report generation and automation of programs and data creation.

Accrued experience in using SAS to read, write, import and export to other data file formats, including delimited files, Microsoft Excel, PDF, and HTML.

Accrued experience in extracting data and creating SAS datasets from various sources, including Oracle database, Excel and flat files using import techniques.

Possess good working knowledge in ad-hoc programming for data management departments and project clients.

Employed ODS to display outputs in HTML, CSV, and other file formats.

Possess excellent organizational, motivational, and interpersonal skills.

Possess strong ability to adapt to new applications and platforms.

Demonstrated the ability to lead teams, through employing strong analytical and communication skills.

Employed effective communication to set clear expectations and smoothly resolve issues among subordinates, peers, and supervisors.

Possess creative thinking, problem solving, and decision-making skills.

Demonstrated self-starter, with the ability to adapt and learn new technologies quickly.

Capable of working independently.

Technical Skills:

Databases: Oracle 10g-12c, 2005-2019 SQL Server, Reflections (VAX).

SAS Skills: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ODS.

Operating Systems: Windows 98/2000/XP, Windows Vista, Windows 7.

Education:

Bachelor of Science in Computer Information Systems. (University of Maryland Baltimore County)

Masters – Information Systems and Technology Management (Capella University, MN)

Work Experience:

Westat Inc. Rockville, MD 20850 August 08, 2005 – Present

ROLE: SAS/Systems Analyst

DESCRIPTION

Westat Inc. is a research and analysis company, contributing to numerous advances in health, education, public policy, and the environment.

Responsibilities

Use SAS Macros and procedures, such as Proc SQL, Transpose, Univariate, Means, and Freq.

Formatted HTML, PDF, CSV and RTF reports, using SAS - Output Delivery System ODS.

Create automated daily, monthly, and quarterly reports to support requirements from business partners.

Upgrade SAS versions.

Coding SAS programs with the use of BASE SAS and SAS MACROS for ad-hoc reports.

Generate output files in the form of listing, HTML, RTF and PDF formats using SAS ODS.

Perform QC (Quality Check) extensively on tasks performed by other team members.

Extract data from various databases and create datasets through modifying pre-defined system level macros and using extracting techniques.

Demonstrate excellent team skills and accrued valuable experience working with others.

Extensively work on PROC REPORT to produce reports for the purpose of validation.

Develop programs using Base SAS & SAS/Macros to extract data from Oracle tables.

Validated the datasets and compared the results to source programmers’ output.

Perform data validation and quality control checks of the displays and datasets in accordance with different QC levels.

Extensively work on PROC REPORT and PROC TABULATE to produce reports for the purpose of validation.

Documented all SAS programs developed and wrote other documentation as needed. Identified and shared best practices for key topics.

SKILLS

Base SAS, SAS Data Sets, SAS Functions, SAS Programming, SAS System Reporting

SAS Training Awards

• SAS Report Writing 1: Using Procedures and ODS, July 14, 2010

• SAS Hash Object, June 27, 2013

• SAS Certified Base Programmer for SAS 9, July 11, 2014 (certificate No: BP041883v9)

Stata/SE 14.0

References

Available upon request

Contact this candidate