SUMMARY

• 7年以上财务数据分析经验, healthcare data analysis to compile and analyze large data sets including data step processing, 数据挖掘, 数据操作, 宏创建, 数据转换.
• Strong Experience in SAS Data warehouse, ETL, Business Analysis, SASAd - Hoc Reporting.
• 熟悉从甲骨文导入数据, DB2 and Teradata using SAS /访问 explicit SQL pass-through facility and Libname statement in both UNIX and windows environments.
• 丰富的使用经验, 更新, 修改和合并用于创建的语句, 排序, 更新和合并各种SAS数据集.
• 具有为大型处理数据集创建和使用可重用宏的经验.
• Strong hold on SQL queries especially in handling large data sets with SQL joins using PROC SQL.
• 具有创建和使用表查找的良好经验.
• 有编写复杂SQL子查询的丰富经验.
• 有使用UNIX crontab文件调度SAS作业的经验.
• 熟悉敏捷/Scrum方法.
• 在创建用于执行表查找的Hash对象方面有丰富的经验.
• 精通各种UNIX命令和使用VI编辑器编写shell脚本.
• 全面了解SAS程序, SAS功能, 情景应用程序语句, SAS格式, SAS备用, 和SAS数据集选项, SAS系统选项, SAS的报告, 和SAS接入.
• 熟练导入不同类型的外部文件(Excel, CSV, txt等.) into SAS libraries and exporting SAS data sets as external files using PROC IMPORT, PROC出口, 和SAS DATA步骤.
• 全面了解SAS程序，如PROC SORT, PROC附加, PROC内容, PROC数据集, PROC副本, PROC格式, PROC打印.
• 生成表的命令, 上市, 以及采用SAS程序步骤(如PROC REPORT)的报告, PROC意味着, PROC总结, PROC比较, PROC汇总, PROC频率.
• Experienced in using SAS ODS to create output data sets and RTF, HTML, PDF, CSV files.
• Proficient in creating and maintaining many datasets using ARRAY, MERGE, UPDATE, SET and PROC SQL.
• 业务和技术团队之间有效的沟通联络, 创意和足智多谋, 问题解决能力强，决策能力强.
• 上进心强，技术能力强 & 分析技巧. Always keen and eager to face up to challenges by means of novel and innovative ideas.

技术技能

操作系统: Windows、UNIX

统计软件: sas / macros, sas / sql, sas / access, sas / ods, sas / stat, sas / graphs

编程语言: C, Objective C，核心JAVA, SQL, UNIX脚本

数据库: ORACLE, DB2和Teradata

应用软件: 办公室女士 (Word, Excel, Power Point, Access和Visio)

专业经验

保密,圣. 路易斯,莫

Sr.SAS程序员/分析

职责:

• 根据可交付进度完成每日、每周、每月和临时报告.
• Used SQL pass through facility to connect to 甲骨文 tables and created datasets using various SQL joins.
• Experience in 数据操作s including the usage of basic standard SAS procedures such as Proc Freq, Proc格式, Proc排序, Proc SQL, and Proc Summary as well as traditional SAS data step programming in Unix Environment.
• Role involves liaising with the Business Planning Unit and with the Business Support Unit, to obtain requirements and data and segment customers to design and pitch specific financial products.
• Experience in bringing large data from SAS and non-SAS (Teradata or 甲骨文 or DB2 database) data sources into a SAS environment and performing SAS 数据操作s against the resulting sets. This includes ability to merge datasets and to write SAS Macros and generate list outputs/reports.
• 验证和测试所有代码的准确性和效率.
• Completing necessary documentation to evidence the code matches requirements and that it meets department’s quality standards.
• Providing good time line estimates for coding based on functional specifications and manages expectations with business partners.
• 必要时与356平台人沟通，以帮助解释结果.
• 创建用于组合SAS数据集和执行表查找的哈希对象.
• 使用UNIX crontab文件定时运行SAS作业.
• 编写shell脚本来自动执行日常任务.
• 参与SAS程序和UNIX shell脚本的代码修改.
• 为所有创建的数据集创建了分析报告，并完成了标准化.
• Implementing various performance improvement techniques to reduce I/O, CPU time and memory usage.
• 广泛使用SQL查询, 加入, 和合并, 连接不同的表，以便从不同的数据库中提取数据.
• Creating and maintaining SAS datasets that are extracted from ORACLE database tables and convert them to SAS data sets.
• 从不同格式的文件中提取原始数据(csv, 使用Proc导入和导入向导

环境: SAS /基地, SAS /宏, SAS /统计数据, SAS / SQL, SAS /访问, SAS / ODS,SAS企业指南, Teradata, 甲骨文, Db2,UNIX, MS Excel, Visio女士, 女士的项目.

机密，佛罗里达州坦帕市

SAS程序员/分析

职责:

• 为所有创建的数据集创建了分析报告，并完成了标准化.
• 负责将新的投资组合数据整合到报告中.
• 负责处理特别要求.
• Extracted event defining information from the 甲骨文 and Teradata using SAS /访问 implicit/ explicit SQL Pass through and ran 统计分析 using SAS/STAT.
• 处理从甲骨文和Teradata中提取数据时的数据异常.
• Coordination with onsite team for issue resolution and daily status tracking updates to project lead as well as to onsite team.
• 构建了一个使用SAS Base重新创建业务过程的批处理应用程序, SAS宏和SAS Access, SAS基本状态
• 广泛使用SAS /基地和SAS/STAT生成表格, 上市, 数据, 生成统计报告.
• Extensively worked on PROC CHART and GPLOT to produce visualization of data in the form of graphs.
• 使用Visio女士为SAS作业创建流程流并发送给测试团队.
• Provide day to day direction to the project team and regular project status to the customer.
• 使用Base SAS和Macro语言编写标准报告.
• 参与项目团队和客户之间的有效沟通.
• Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.
• 准备单位 & 系统测试用例.

环境: SAS /基地, SAS / SQL, SAS /宏, SAS/STAT, SAS /访问, MS EXCEL, ORACLE, Teradata.

机密，桥口，CT

情景应用程序的程序员

职责:

• Developed SAS programs to create a customer mailing list for Direct Mailing and Telemarketing.
• Extracted data from the database using SAS /访问, SAS SQL procedures and create SAS data sets.
• 进行数据分析, 广泛使用BASE SAS创建报告, 在默认过程的帮助下创建宏和SAS报告.
• 使用PROC SQL Pass through Facility与ORACLE和DB2一起工作.
• 创建新程序和修改现有程序.
• 使用SAS Report和SAS /GRAPH生成图形.
• Created reports using SAS /ODS and SAS /views from oracle database tables into different formats like HTML and RTF
• 处理大型客户反馈和销售数据集.
• 从平面文件创建SAS数据集并合并数据.
• 维护和增强现有的SAS市场活动报告程序.
• Data processing and validations were done extensively on the SAS datasets using edit check programs.
• 进行个人账户和家庭层面的分析.
• 进行显著性检验，研究不同报价的回复率.
• Analyzed response and sale results and write up monthly summary on campaign performance.
• 根据报告为不同层次的市场营销创建数据模型.
• 使用PROC REPORT创建报表, PROC汇总, ODS语句和PROC TEMPLATE生成HTML格式的输出.
• 使用PROC转置程序重组SAS数据集.

环境: SAS /基地, SAS /宏, SAS / SQL, SAS /访问, SAS企业指南, SAS / ODS, MS Excel, Visio女士, 女士的项目, 甲骨文, UNIX.

保密

情景应用程序的程序员

职责:

• 参与市场细分, channel management and customer credit groups to benchmark company’s requirements and expectations.
• 通过创建数据源创建元数据对象, 使用源的目标和数据转换, SAS数据集成工作室的目标和过程设计器.
• 创建查询, Fact and Dimension tables and Identifying the mapping data into specific domains as per the data model using SAS企业指南 by creating the DATA and PROC steps as process tasks.
• 参与用户身份验证的管理, 元数据存储库, 作业调度, 存储过程, 数据清理.
• Experience in creating OLAP cubes for reporting of pre-summarized large datasets and decision support systems using SAS数据集成工作室 and publish the same for business users.
• Extensively used DATA NULL, TRANSPOSE, UNIVARIATE, SUMMARY, MEANS, FREQ, SQL and GPLOT procedures.
• Created and extracted 甲骨文 tables from SAS and within 甲骨文 by using PL / SQL using SAS /访问 and SAS/CONNECT.
• 使用PROC/REPORT程序生成多维报告和表格, PROC /汇总, PROC/SQL和DATA为空 .
• Perform analysis of data for use in Cross-selling, created graphs using PROC GPLOT, GCHART. 为将来的分析和报告创建和更新永久SAS格式.
• 使用SAS/STAT程序分析市场特征，包括, Proc单变量, Proc Reg, Proc物流, Proc集群, 等.
• Developed and executed approaches regarding segment based analyses and customer value changes.

环境: SAS 9.1、SAS / ODS、SAS企业指南.2, SAS数据集成工作室, SAS /宏, SAS /图, SAS /访问, SAS /连接, SAS / Stat, PL / SQL, 甲骨文, UNIX, 办公室女士, 女士访问.

保密

临床SAS程序员

职责:

• 为临床研究提供SAS编程和统计支持.
• 进行数据分析, 统计分析, 生成的报告, 列表和图形使用SAS工具- SAS /基地, SAS /宏, SAS /图, SAS / SQL, SAS /连接和SAS /Access.
• Programmed custom analytic studies from definition of diseases or drug usage and appropriate outcomes through creation of a summary file to production of tables and graphs
• 广泛使用Base SAS参与药物数据分析报告, SAS /宏, SAS /图表和SAS /报告.e.) with the help of Default Procedures and also involved in Programming of SAS for Clinical Research data using load/access process for phase 1, 2, 3 & 4 .临床试验.
• 处理临床试验数据，如人口统计数据, 差异数据, 不良事件, 严重不良事件, 实验室数据, 身体和生命体征和审计试验.
• Developed data formatting and table generation programs necessary to support the reporting of the Clinical trial data to regulatory agencies.
• Written, tested and maintained programs used for reporting of data collected during Clinical trials.

环境: SAS 8, SAS /基地, SAS /宏, SAS / SQL, SAS /图, SAS / STAT, SAS /连接, 1期临床研究和5期临床研究, 3, 第四试验.