SUMMARY

• 7+ years of Experience in financial data analysis, 医疗保健数据分析，编译和分析大型数据集，包括数据步骤处理, data mining, data manipulation, macro creation, data transformation.
• 在SAS数据仓库，ETL，业务分析，SASAd Hoc报告方面有丰富的经验.
• Good knowledge of importing data from Oracle, 在UNIX和windows环境中使用SAS/ACCESS显式SQL传递功能和Libname语句的DB2和Teradata.
• Extensive experience in using the Set, Update, Modify and Merge statements for Creating, Sorting, Updating and Merging various SAS datasets.
• Experience in creating and using reusable macros for large handling data sets.
• 强大的SQL查询，特别是在处理大型数据集与SQL连接使用PROC SQL.
• Good experience in creating and using table lookups.
• Strong experience in writing complex SQL sub queries.
• Experience in scheduling SAS jobs using UNIX crontab file.
• Sound knowledge of Agile/Scrum methodologies.
• Good experience in creating Hash objects for performing table lookups.
• Thorough knowledge of various UNIX commands and shell scripting using VI editor.
• Thorough knowledge in SAS Procedures, SAS Functions, SAS Statements, SAS Formats, SAS Informats, and SAS Dataset options, SAS System Options, SAS Reports, and SAS Access.
• Proficiency in importing different types of external files(Excel, CSV, txt, etc.)导入SAS库，并使用PROC IMPORT将SAS数据集导出为外部文件, PROC EXPORT, and SAS DATA steps.
• Thorough knowledge in SAS Procedures like PROC SORT, PROC APPEND, PROC CONTENTS, PROC DATASETS, PROC COPY, PROC FORMAT, PROC PRINT.
• Command in producing tables, listings, and reports employing SAS procedure steps such as PROC REPORT, PROC MEANS, PROC SUMMARY, PROC COMPARE, PROC TABULATE, PROC FREQ.
• 有使用SAS ODS创建输出数据集和RTF, HTML, PDF, CSV文件的经验.
• 熟练使用ARRAY, MERGE, UPDATE, SET和PROC SQL创建和维护多个数据集.
• Effective communications liaison between business and technical groups, creative and resourceful, problem solving with excellent decision-making capabilities.
• Self-motivated individual with strong technical & analytical skills. 总是敏锐和渴望面对挑战，以新颖和创新的想法.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Statistical Software: BASE SAS, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STAT, SAS/GRAPHS

Programming Languages: C, Objective C, Core JAVA, SQL, UNIX Scripting

Databases: ORACLE, DB2 and Teradata

Application Software: MS Office (Word, Excel, Power Point, Access and Visio)

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Sr.SAS Programmer / Analyst

Responsibilities:

• Performed daily, weekly, monthly and ad-hoc reports as per deliverable schedules.
• 使用SQL直通功能连接到Oracle表，并使用各种SQL连接创建数据集.
• 有数据操作经验，包括使用基本的标准SAS程序，如Proc Freq, Proc Format, Proc Sort, Proc SQL, 以及传统的SAS在Unix环境下的数据步进编程.
• 职责包括联络业务计划组和业务支持组, 获取需求和数据，细分客户，设计和推销特定的金融产品.
• 具有将来自SAS和非SAS (Teradata或Oracle或DB2数据库)数据源的大型数据带入SAS环境并对结果集执行SAS数据操作的经验. 这包括合并数据集、编写SAS宏和生成列表输出/报告的能力.
• Validating and testing all code for accuracy and efficiency.
• 完成必要的文件，以证明代码符合要求，并符合部门的质量标准.
• 为基于功能规范的编码提供良好的时间线估计，并管理与业务伙伴的期望.
• Communicate with business contacts as necessary to help explain results.
• Creating Hash objects for combining SAS datasets and performing table lookups.
• Scheduling SAS jobs to run on regular intervals using UNIX crontab file.
• Written shell scripts to automate daily tasks.
• Involved in code changes for SAS programs and UNIX shell scripts.
• Created profiling reports for all the datasets created and also done standardization.
• 实现各种性能改进技术以减少I/O、CPU时间和内存使用.
• Extensively use of SQL for Queries, Joining, and Merging, Concatenation of different tables for data extraction from different databases.
• 创建和维护从ORACLE数据库表中提取的SAS数据集，并将其转换为SAS数据集.
• Extract raw data from files of different formats (csv, flat file) using Proc import and import wizard

Environment: SAS/BASE, SAS/MACRO, SAS/STATS, SAS/SQL, SAS/ACCESS, SAS/ODS,SAS Enterprise Guide, Teradata, Oracle, Db2,UNIX, MS Excel, MS Visio, MS Project.

Confidential, Tampa, FL

SAS Programmer/ Analyst

Responsibilities:

• Created profiling reports for all the datasets created and also done standardization.
• Responsible to integrate the new portfolios data into the reports.
• Responsible to work on the Adhoc Requests.
• 使用SAS/ACCESS隐式/显式SQL从Oracle和Teradata中提取事件定义信息，并使用SAS/STAT进行统计分析.
• Handling data anomalies when pulling data from Oracle and Teradata.
• 与现场团队协调解决问题，并向项目主管和现场团队跟进每日状态更新.
• Built a batch application that recreates business procedures using SAS Base, SAS macro and SAS Access, basic SAS Stat
• Extensive use of SAS/BASE and SAS/STAT for producing tables, listings, figures, and generating statistical reports.
• 广泛使用PROC CHART和GPLOT，以图形的形式将数据可视化.
• Create process flow for the SAS jobs using MS Visio and send to testing team.
• 向项目团队提供日常指导，并向客户提供常规项目状态.
• Developed standard reports using Base SAS and Macro Language.
• Involved in effective communication between the project team and the customer.
• 使用SAS Macros, PROC SQL提取，排序匹配测试账户和ODS到HTML, PDF和RTF.
• Prepared Unit & System Test cases.

Environment: SAS/BASE, SAS/SQL, SAS/Macros, SAS/STAT, SAS/ACCESS, MS EXCEL, ORACLE, Teradata.

Confidential, Bridge Port, CT

SAS Programmer

Responsibilities:

• 开发SAS程序，为直销和电话营销创建客户邮件列表.
• 使用SAS/Access、SAS SQL程序从数据库中提取数据并创建SAS数据集.
• Performed data analysis, created reports with extensive use of BASE SAS, macro and SAS reports with the help of default procedures.
• Used PROC SQL Pass through Facility to work with ORACLE and DB2.
• Created new programs and modified existing programs.
• Generated graphs using SAS Report and SAS /GRAPH.
• 使用SAS /ODS和SAS /views从oracle数据库表创建不同格式的报表，如HTML和RTF
• Worked with large customer response and sales data sets.
• Worked on creating SAS Data sets from flat files and merging data.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• 使用编辑检查程序对SAS数据集进行了广泛的数据处理和验证.
• Conducted individual account and household level analysis.
• Conducted significance tests and study response rates for different offers.
• 分析响应和销售结果，并撰写月度活动绩效总结.
• Created Data Models for different level of Marketing based on the reports.
• Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML.
• Restructured SAS datasets using PROC TRANSPOSE procedure.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS Enterprise Guide, SAS/ODS, MS Excel, MS Visio, MS Project, Oracle, UNIX.

Confidential

SAS Programmer

Responsibilities:

• Worked with market segmentation, 渠道管理和客户信用组，以基准公司的要求和期望.
• Created metadata objects by creating the data sources, targets and data transformations using the source, target and process designer of the SAS Data Integration Studio.
• Created Lookup, 使用SAS Enterprise Guide创建data和PROC步骤作为流程任务，根据数据模型将数据映射到特定的域.
• Involved in the Administration of the user authentications, metadata repositories, job scheduling, stored processes, data cleansing.
• 有使用SAS Data Integration Studio创建OLAP多维数据集以报告预汇总的大型数据集和决策支持系统的经验，并为业务用户发布这些数据集.
• 广泛使用数据NULL，转置，单变量，汇总，均值，FREQ, SQL和GPLOT程序.
• 通过SAS/ACCESS和SAS/CONNECT使用PL/SQL从SAS和Oracle内部创建和提取Oracle表.
• Produced multi-dimensional reports and tables using procedures PROC/REPORT, PROC/TABULATE, PROC/SQL and DATA NULL .
• 对交叉销售数据进行分析，使用PROC、GPLOT、GCHART制作图表. Created and updated permanent SAS formats for future analysis and reports.
• Analyzed market characteristics using SAS/STAT procedures that include, Proc Univariate, Proc Reg, Proc Logistic, Proc Cluster, etc.
• 开发并执行基于细分市场分析和客户价值变化的方法.

Environment: SAS 9.1, SAS/ODS, SAS Enterprise Guide 4.2, SAS Data Integration Studio, SAS/Macros, SAS/Graph, SAS/Access, SAS/Connect, SAS/Stat, PL/SQL, Oracle, UNIX, MS Office, MS Access.

Confidential

Clinical SAS Programmer

Responsibilities:

• Provided SAS programming and statistical support to Clinical studies.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools- SAS /Base, SAS /Macros, SAS /Graph, SAS /SQL, SAS /Connect and SAS /Access.
• 程序化的定制分析研究，从疾病或药物使用的定义和适当的结果，通过创建摘要文件到生成表格和图表
• Involved in the Pharmaceutical Data Analysis Reports extensively using Base SAS, SAS /Macros, SAS /Graphs and SAS /Reports (i.e.)，并参与了第一阶段临床研究数据使用加载/访问过程的SAS编程, 2, 3 & 4 of Clinical Trials.
• Worked with Clinical Trials data like Demographic data, Discrepancy data, Adverse Events, Serious Adverse Events, Laboratory data, Physical and Vital Signs and Audit Trials.
• 开发必要的数据格式和表格生成程序，以支持向监管机构报告临床试验数据.
• 编写，测试和维护用于报告临床试验期间收集的数据的程序.

Environment: SAS 8, SAS /Base, SAS /Macro, SAS /SQL, SAS /Graphs, SAS /STAT, SAS /Connect, Clinical Studies in Phase I trial and 5 Clinical Studies in Phase II, III, IV trials.