OBJECTIVE: Data Analyst/SAS Programmer Open to Relocation

SUMMARY:

• Over 7 years of experience in IT Industry. Data Analyst with advanced SAS SQL programming skills and Bachelor's degree in Actuarial Mathematics.
• Has extensive experience in direct/database marketing, customer segmentation, reporting, regression analysis/modeling, big data, CRM, SAS/SQL coding and SAS/Macro coding.
• 4 years data analysis experience in retail, mining, insurance and consulting industries
• 2 years campaign analysis experience including pre-campaign analysis to identify best customers for campaign, A/B tests to improve campaign efficiency, list selection for test and control groups, post-campaign analysis to evaluate campaign performance and make recommendations
• 2 years reporting expertise for on-going and ad-hoc sales, flyer promotion and other business report design, implementation, automation, maintenance and documentation
• 4 years experience in data extraction, cleansing, validation, quality assurance, analysis and interpretation in order to deliver insights to support business decision making
• 4 years experience with SAS: SAS SQL/Macro/Base/Stat/Graph PC SAS, SAS Enterprise Guide
• SAS Certified Base Programmer SAS Certified Advanced Programmer
• 4 experience with MS SQL Server, experience with other relational databases: Oracle and DB2
• Hands on skills in MS Excel pivot table, vlookup, etc. and PowerPoint
• Solid knowledge of predictive modeling, linear regression, logistic regression, forecasting, time series, cluster and basket analysis, RFM, ROI, LTV and NPV analysis

EXPERIENCE:

Confidenital

• Worked with food retail clients on understanding and clarifying marketing initiatives objective, timeline, budget, and channel direct mail, email and online and translating business requirements into measurable technical solutions
• Integrated big data millions of data records from SQL Server CRM data warehouse and marketing data marts based on specific business requests, while maintaining integrity
• Identified most valuable potential customers pre-campaign analysis for promoted products such as yogurt and organic food, through a series of consumer behavior analyses: RFM analysis, basket and clustering analysis, market research, and customer segmentation and profiling, for increasing response rate, sales and profits
• Developed solutions to optimize loyalty/retention campaigns, by applying customer behavior consistency and designing sequential offers to attract customers to higher levels of segments
• Documented List Management form, containing best customers definition, size of test and control groups, estimated offer costs and estimated response rates
• Fulfilled A/B tests to further improve marketing campaign response rate and effectiveness
• Evaluated overall marketing campaign performance and success in short/long term periods post-campaign analysis . Created campaign report by comparing test and control groups' Key Performance Indicators KPIs such as Average Sales, Response Rate, Success Rate and ROI. Recommended solutions to improve future campaign performance
• Automated processes by using SAS Macros, SAS SQL and other modules to enhance effectiveness and efficiency of SAS and SQL coding and analytics deliveries
• Utilized logistic regression and other statistical techniques to oversample and clean modeling data sets, derive and reduce modeling variables, transform and develop linear predictors
• Assisted in decile analysis, gain/lift table and chart creation to develop and validate response and activation models, through applying initial acquisition campaign results and available data
• Technical skills utilized: SAS SQL, Base SAS, SAS Macro, SAS Stat, SAS Graph, SAS ODS various SAS procedures including Proc SQL, Proc Sort/Import/Export/Tabulate/Freq/Means/Univariate/Power/Gplot/ Report/Reg/Logistic/ Score/Forecast, Macro Statements, and Data Steps SAS/Access ODBC Libname Statement, Proc SQL Pass-through Facility PC SAS, SAS Enterprise Guide 4.1 MS Excel and PowerPoint

Confidenital

Reporting Analyst

• Gathered and documented timely reporting and data requirements for product flyer promotion, sales and specific business projects, driving consumer spend and identifying key products
• Designed SAS queries to access multiple databases and extract geo-demographic data from customer, transaction, customer value segment, product, customer campaign history tables
• Manipulated data by validating, cleansing and/or imputing errors, missing values and outliers, ensuring accuracy, completeness and consistency for analysis and reporting purpose
• Fulfilled descriptive/inferential statistical analyses on targeted data, developed, tested and implemented ad-hoc, weekly and monthly transaction-based or customer-based reports
• Report metrics including KPIs: Total Customers/Sales/Cost/Number of Basket, Weekly Spend/ Basket Size/Retail Margin, Monthly Spend/Basket Size
• Presented reports and analytics in colorful charts and graphs in Excel or PowerPoint format to non-technical and technical clients and stakeholders
• Maintained and enhanced existing queries and reports to meet new business requirements
• Pulled campaign lists for test and control groups of campaign. Uploaded leads with fitted data structure into campaign data marts. Created new data sources for marketing databases
• Technical skills: SAS SQL, Base SAS, SAS Macro/Stat/Graph PC SAS, SAS EG 4.1 SQL Server, Oracle, DB2 Excel and PowerPoint

Confidenital

Business Analyst/Partner

• Performed weekly, monthly and quarterly production and sales reports using SAS and Excel, enabling owner to understand business performance and make marketing strategies accordingly
• Made market research on raw copper ore transactions and prices and costs of labor, equipment and materials, providing clear picture of raw copper ore market
• Managed sales on local level and regional level and increased sales up to 40

Confidenital

New Business Issue Administrator

• Redesigned spreadsheet for compiling team's daily workload data and report into a one page summary, reducing daily reporting time from 40 minutes to 20 and increasing efficiency 50
• Reviewed and analyzed life insurance application and certificate information/data in the administrative system, creating and supporting data elements of underwriting databases
• Accessed and entered medical information into Medical Information Bureau, sharing information with all life insurers operating in USA