OBJECTIVE: SAS Programmer

QUALIFICATIONS
Extensive experience in Data Analysis and SAS Statistical Programming

• Using SAS to create Clinical Trail tables and graphs
• Using SAS data mining and analytical skills to increase business opportunity for life insurance company
• Coordinated requirements gathering and definition with business users and act as a liaison between business users and technical teams as well as dive into data analysis
• Provided corporate data information to Sales and Marketing, Finance, Operation staff with Dashboards, KPI Scorecards, multidimensional Cubes, and Reports
• Designed/Created dashboard and KPI (Key Performance Indicator) scorecard metrics for executive and sales team to monitor daily business activities
• Coordinated monthly forecast process and provided forecast variances analysis reports to executive team
• Coordinated annually/quarterly budget process and provided budget variance analysis to control company expenses
• Proficient with MS Access, MS Excel, SQL, SAS programming and statistical analysis as well as business acumen (SAS9 Base/Advanced Certified)

TECHNICAL SKILLS
Programming: SQL, SAS/Base, SAS/STAT, SAS Macro, SAS SQL, SPSS
Software Packages: IBM Cognos 8 BI, Cognos Enterprise Planning, BO Xcelsius
Microsoft Office: Excel (Pivot Table, Chart, Macro, Statistics, Solver), Access, PowerPoint, Project, Visio
SAS Base Programming for SAS9 Certified
SAS Advanced Programming for SAS9 Certified

PROFESSIONAL EXPERIENCE

Confidential Mountain View, CA 2011 – Present
Contract Consultant

• Using SAS to generate Clinical Trial Reports, Listings, and Graphs
• Importing source data into SAS data sets using Proc Import or Proc SQL
• Creating SAS macro variables using Data Step or Proc SQL
• Counting treatments using Data Step or Proc FREQ
• Creating report and Listing using Proc Report
• Creating graph using Proc GPLOT
• Output report/graph to rtf/pdf formats using ODS statements

Confidential Sunnyvale, CA 2007 – 2010
Sr. Data Analyst, Enterprise Information System
SST is the No. 1 embedded flash memory in semiconductor

• Responsible for company Business Intelligence strategy and roadmap
• Upgraded Cognos BI system from 7.3 to 8.3 and implemented Cognos Enterprise Planning
• Collaborate with executive and cross functional teams such as Sales, Marketing, Operation, and Finance to define business rules and transformations, and then convert them into actionable metrics for decision support
• Designed/Created dashboard and KPI (Key Performance Indicator) scorecard metrics for executive and sales team to monitor daily business activities
• Implemented Sales forecast system with SandM team using predictive models and visual charts, coordinated monthly forecast process as well as variances analysis for Units and Unit Price to executive team
• Implemented corporate budget system with finance group and coordinated annual/quarterly budget process, as well as budget variance analysis by department, account, and project to control company expenses
• Designed demand forecast dashboard to put demand and supply data together for operation demand planner to improve data accuracy
• Created sample and order trace system to customer services, which resulted in quicker response time and improved customer satisfaction
• Designed Sales execution plan system, which enable BU manager to trace shipment vs. sales plan, which increased demand forecast accuracy
• Supported BU and Finance staff using CAFÉ (Cognos Analysis for Excel), which enable them to create customized reports automatically
• Supervise and propose fixes on data quality issues and identify their root causes to ensure against problem recurrence

Confidential Taiwan 2003 - 2007
Sr. Data Analyst, Data Processing and Analysis

• Prepared Ad hoc SAS data sets to run life insurance modeling
• Created and maintained SAS macro programming to automate SAS jobs
• Designed and implemented a huge SAS datasets from DB2 databases to automated weekly refresh and maintenance, and automated multiple reports to support Operations and Sales.
• Segmented customers into meaningful and measurable groups based on needs, purchase behavior and demographics (Statistical methods: clustering, segment profiling)
• Used survival models to predict the life expectancy of terminal illness patients (Statistical methods and SAS procedures: lifetest)
• Applied quantitative analytical skills to analyze customer policy trend. Using SAS to process around 50,000 customers’ data file based on demographic info. and purchase history to build a predictive model to identify likely purchasers customers
• Designed competition scorecard for agent manager during the campaign period to reach the goal by 20% increase
• Successfully delivered the Sales Agent Management System / Dashboard using MS Access and Excel, which includes Agent Performance, Agent / Branch Contest, and List of agency leaders to be Repromoted / Demoted analyses

Confidential Sunnyvale, CA 2000 - 2003
Sr. Data Analyst, Enterprise Information System

• Responsible for company BI system infrastructure, application design and implementation project
• Conducted business/data analysis, defined business rules and transformations, converted requirements into subject areas/data marts, and sample review of ad hoc reports with customers
• Provided corporate data information to Sales and Marketing, Finance, Operation staff with Dashboard, multidimensional Cubes, and Reports
• Worked with DW team to develop the ETL processes by integrating data from Oracle ERP, e-Commerce, flat files and others
• Worked with BI developer to design a scalable reports, cubes and dashboard
• Streamlined IT business process and centralized documentation
• Successfully built Sales and Marketing and Finance modules which includes Booking, Debooking, Shipment, Backlog, Shipment plus Backlog, Book to Bill ratio, Sample Request, Design Win, Profit and Loss, Sales Plan/Target, Budget vs. Actual etc. for the reporting/DW solutions
• Coordinated with business owners to identify business opportunities

EDUCATION:
Cognos BI and Cognos Planning Training, Business Objects Training, SAS Training
Master in Statistics
Bachelor in Statistics