SAS, SQL

Alex Min Certified SAS Base/Advanced Programmer 905-***-**** ***********@*****.***

OBJECTIVE: SAS Developer/Data Analyst

QUALIFICATIONS:

• 7+ years of experience of being database programmer/SAS developer working in telecom, financial services,

insurance and retail industries with focus on data processing, analysis and data mining.

• Sound ability of understanding business process, analyzing requirements and designing technology solutions.

• Involved in projects regarding customer segmentation/retention analysis, campaign analysis, reporting design.

• SAS coding to retrieve data from/export to different sources like raw data files (.txt and .dat), PC files (Excel,

CSV and Access) or database systems providers: MS SQL Server, DB2, Oracle, Teradata or MySQL.

• Exceptional in SAS programming with tools of SAS V9, SAS/BASE, SAS/ACCESS, SAS/SQL,

SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/STAT, SAS/EG, SAS/DI STUDIO.

• Developing high quality SAS MACRO for automation procedures and code maintenance.

• Working experience of both UNIX and Windows environments to perform SAS programming.

• Deep understanding of relational database principles and its practice in data mining.

• Proficient in coding with SQL language, created Stored Procedures and Triggers with T-SQL.

• Ability to prioritize and handle multiple tasks in a fast-pace working environment.

• Skillful in critical thinking, problem solving and strong attention paying to details.

Professional Experience:

SAS Developer/Marketing Analytics Specialist, Bell Mobility, Mississauga, ON. 2014.4 – 2015.3

Bell Mobility is Canada's largest mobile service provider, supplying a comprehensive and innovative suite of

broadband communication services to residential and business customers in Canada

Achievements:

Developed SAS/MACRO library for Data cleansing, validation, analysis and report generation to improve the

code reusability, saved coding efficiency.

Conducted complex data analysis from multiple sources and systems with large data structures, and

effectively merges data to create new datasets using SAS programming.

Responsibilities:

• SAS coding to automate data importing/exporting processes and increase code reusability and efficiency.

• Preformed data quality control and data management by periodically optimizing SAS codes and updating data

mart tables for analytics and reporting.

• Performed data ETL by loading raw data and database files into SAS, generating new variables, performing

data cleansing, validation, dealing with missing values, table merging and then outputting formatted files.

• Utilized SAS/ACCESS to create connection to remote and local servers (SQL, Oracle and Teradata) for data

backup and large data repository maintenance.

• Applied SAS programming to business analysis projects with multi channels (TM, eDM, DM), i.e. customer

segmentation in multiple levels (Consumer, SMB and Prospect), post campaign performance analysis.

• Preformed SQL programming in SQL server/Teradata environments to generated campaign list and reports.

• Interpreted business requirements into technical needs and reported project implementation progress to

project manager simultaneously.

SAS Programmer/Data Analyst, Greatstone International Ltd., Hamilton, ON. 2011.11 – 2014.2

945 DARYL DR. BURLINGTON, ON 1 REFERENCE AVAILABLE UPON

REQUEST

Alex Min Certified SAS Base/Advanced Programmer 905-***-**** ***********@*****.***

A global HVACR industry company founded by a group of HVAC engineers with more than 60 years and a

distributor with an international network in wholesales and retails across Canada, America and Asia

Achievements:

Successfully integrated and formalized data from multiple data suppliers into Enterprise Data Warehouse

(EDW) and maintained high quality of data services for customers within the corporate.

Performed segmentation and retention analysis, developed campaign build and execution, leveraged

operational effectiveness and efficiency by 10% through client treatment and direct marketing activities.

Responsibilities:

• Extracted data from raw data files (flat or delimited text files) into SAS systems to create SAS data sets.

• Performed data cleansing, validating, processing, manipulating in SAS systems using SAS Base, Proc

Freq/Means, Proc SQL and removed duplicate records as per business request of projects.

• Documented business requirement changes, tested business logic process periodically to meet needs.

• Provided post-campaign performance analysis including response rate (KPI), ROI, profitability.

• Developed frequency and relational reports (churn rate and segmentation parameters) in the form of HTML,

PDF and Excel to be presented to the clients/stakeholders with PROC REPORT/GPLOT/GCHART.

• Provided segmentation analysis of clients based on multiple metrics, including business scale, product

categories, location, and frequency.

• Conducted statistical analysis and generated tables, listings and graphs by employing SAS/ODS, PROC

MEANS, PROC UNIVARIATE, PROC FREQ, PROC REPORT, PROC TABULATE, and PROC GPLOT.

• Developed SAS MACROS to create dynamic SAS jobs and support routine operations, ensuring effectiveness

and efficiency of job delivery.

SAS Programmer/Data Analyst, MPR Consulting Inc., Toronto, ON. 2008.12 –2011.10

A global management consulting company specialized in IT consulting services and business analysis projects

implementation. Business partners include financial, insurance and retail industries.

Achievements:

Developed SAS/MACRO library for Data cleansing, validation, analysis and report generation to improve the

code reusability and facilitate code automation.

Customized graphic monthly and quarterly reports by using PROC GPLOT, PROC GCHART and PROC

GBARLINE and supported ad-hoc business reports for stakeholders, business partners and clients.

Responsibilities:

• Designed technical solution to assignment, starting from project brief writing and scoping of the project to

delivery of final product. Generated criteria to leverage data to implement business analysis.

• Extracted external data from various raw data formats including text files, Excel spreadsheet, Access, CSV,

Flat files, legacy systems and various kinds of DB tables, transformed and loaded them into SAS systems

with SAS coding and SAS DI Studio utility.

• Implemented data cleansing, validation, reconciliation, transformation and quality assurance, data sets

manipulation and integration and report generation.

• Maintained large data sets, integrated data from various sources-SQL server, Oracle, DB2 using LIBNAME

engine, Pass Through facility in Mainframe, UNIX and PC environments.

• Developed, improved efficient and reusable SAS/Macro processes and automations to meet business goals.

• Completed ad hoc assignments as per statistician, data asset manager and client’s requirements on-time.

945 DARYL DR. BURLINGTON, ON 2 REFERENCE AVAILABLE UPON

REQUEST

Alex Min Certified SAS Base/Advanced Programmer 905-***-**** ***********@*****.***

Software/Database Programmer, Carelynx Corporation, Hamilton ON 2006.7 – 2008.11

As a subsidiary of SteelCare, Carelynx is an information technology consulting company focused on software

development, data warehouse maintenance, networking services and automation design.

Achievements:

Provided technical support in developing and maintaining database applications that were focused on data

conversion and data integration supporting back-end warehouse inventory management processes.

Assisted with administrative maintenance of relational databases including backup/recovery, schedule jobs,

problem diagnosis and performance tuning.

Responsibilities:

• Involved in developing database projects including inventory control & reporting, retail distribution and

ordering, enterprise reporting system.

• Responsible for client’s data input/extract from raw data files, dealing with Excel sheets, Access database,

SQL server, DB2, Oracle database and flat files.

• Performed database instance setup, configuration, and migration between different servers.

EDUCATION & PROFESSIONAL DEVELOPMENT

Bachelor of Science in Computer Engineering, McMaster University 2006.04

SAS Base, SAS Advanced Training

SQL Server Administration Training, T-SQL programming Training

945 DARYL DR. BURLINGTON, ON 3 REFERENCE AVAILABLE UPON

REQUEST

Contact this candidate