sas programmer

Jing (Flora) Meng

*** **** **** *****, #***, Arlington, VA 22202 • 417-***-**** • **********@*****.***

Objective Seeking a full time position in SAS Programming.

Certifications

SAS Certified Advanced Programmer for SAS 9. SAS Certified Base Programmer for SAS 9.

Summary

In-depth knowledge and experience with Base SAS, SAS Macro Facility, SAS SQL, SAS Procedures, SAS Functions, SAS Options, SAS Formats, SAS Looping and Array processing, and Output Delivery System.

Experience in cleaning and resolving data issues as well as merging and appending data from different sources into a single integrated dataset.

Expertise in using various SAS Procedures such as: Proc Print, Proc Report, Proc Tabulate, Proc Mean, Proc Freq, Proc Univariate, Proc Transpose, Proc SQL, Proc Import, Proc Compare, Proc Summary and Data NULL.

Experience in generating tables, graphs, summaries, and listings reports.

SAS Programming experience with healthcare informatics database.

Technical Skills

SAS Tools: SAS/Base,SAS/Graph, SAS/Macros, SAS/ODS, SAS/Reports, SAS/Access, SAS/Stat, SAS EG.

SAS Procs: Print, Means, Univariate, Regression, SQL, Tabulate, Freq, Sort, Summary, Format, Transpose.

Others: SPSS, Stata, MySQL, Oracle, Quickbooks, MS Office.

Professional Experience

SAS Programmer

Nutech Computer Systems Inc., Rockville, MD Jul 2016 - Present

Import and convert raw relational database sourcing from various channels (client assigned, online published, laboratory collected, self-simulated and etc.).

Validate and clean datasets to ensure data for accuracy and completion.

Use SAS Data Steps, Procedures Steps such as Proc SQL and Proc Sort, SAS functions and formats, and SAS Macro to manipulate, transpose, merge and combine data.

Create macro variables using Call Symput routine and build SAS Macros to help generate analysis data sets.

Generate customized reports as tables, graphs, summaries and listings in PDF, Excel, RTF and XML formats, using SAS Output Delivery System.

Support statisticians with statistical tests such as T-test, ANOVA, linear model regression and logistic regression.

Perform quality review of other programmer’s work, cross-validation of SAS programs.

International Operation Analyst

Caitec Co., Baltimore, MD Feb 2014 – Jun 2015

Interpreted internal and external purchase order requirements for Chinese vendors and partners and kept detailed records to ensure optimal flow of products and information.

Prepared and reviewed customs declaration documentation and collaborated with stakeholders throughout the supply chain to support successful delivery of products.

Collaborated with brokers to coordinate global distribution and logistics processes.

Analyzed and reviewed bird food inventory trends to generate forecasts and develop quarterly demand plan.

Generated quarterly and ad-hoc reports aggregating sales and inventory data to support sales planning team.

Market Research Analyst

Profusion Foods Inc., Chicago, IL Feb 2012 – Mar 2013

Measured the effectiveness marketing, advertising, and distribution strategies to support sales team.

Forecasted food-related seasonal sales trends and distribute 800 products to key accounts into Midwest market.

Collected and analyzed data on competitors, including pricing and distribution, to devise market strategies and determine market position.

Increased and developed new clientele by 10%, increasing potential revenue by $250,000.

Educations

Missouri State University, Springfield, MO Aug 2009 – Dec 2011

Master of Business Administration, MBA in Marketing

Shaoxing University, Zhejiang, China Aug 2004 – Jun 2008

Bachelor of Science, International Economics and Trade

Languages

Fluent in Mandarin and Cantonese

Contact this candidate