Engineer Service Representative

PROFILE

SAS Certified Professional in ****

A professional with more than 9 years of extensive, hand-on experience of programming, analytical and consulting experiences of using SAS,SQL and other advanced Tool to perform designing, coding debugging, documenting, and maintaining application on PC and Mainframe platform

Ability to interpret business requirements and translate them into technical solutions by SDLC/Agile

Specialized in data extraction, data multiplication and data presentation and database management

An organized team player with strong analytical abilities and problem-solving skills

PROFESSIONAL EXPERIENCE

TD Bank Jul. 2017 – Present

IT support Analyst III

Improve production environment stability by working with others to set up, maintain and monitor applications and systems, while meeting availability targets.

Obtain understanding of technical aspects of project and provide timely updates to other developers and solution designers.

Design, review and integrate application requirements (e.g. functional, security, integration, performance, quality, operations).

Deliver effective support (application, software and operations), research issues and identify causes, recommend changes and follow through the execution, update related process documentation.

Improve performance and resources utilization by assessing and analyzing opportunities for optimization.

Rogers Communication Inc. Sept. 2012 – May. 2016

Senior Business Analyst/Developer

Worked collaboratively with Finance, Marketing, Business Care and other assigned business areas, to develop specialized end-to-end reporting solutions and KPIs.

Used SAS or other programming tools to develop solutions for key projects, which includes reporting, dashboards, scorecards, data extracts and integration, analysis and acceptance testing.

Conducted ad-hoc analysis and developed reporting using various enterprise and localized data sources.

Reviewed, analyzed and understood data to ensure the reporting provided is accurate, timely and meeting the business requirements.

Implemented “Impact Custom Value” in-house application, which uses SQL scripting to manage customer analysis, and have assisted on internal and external CSR improvements.

Managed multiple projects simultaneously, to meet tight deadlines and to quickly adapt to the new applications/platforms.

Contributed to process improvement initiatives; shared technical aspect and best practice with the team.

Rogers Communication Inc. Sept. 2010 – Sept. 2012

Sr. Consultant/Developer

Interacted with the Marketing division by understanding their campaign data and conducting statistical analysis to support the decision-making process.

Worked with large data volumes (i.e. including millions of SAS observations and many variables), to produce regular and ad-hoc SAS reports as per the user requirements.

Developed new SAS programs and modified the existing ones.

Documented, archived, and maintained SAS programs and methodologies.

Assisted on automation process by utilizing VBS and VBA, in order to minimize turnaround time and maximize accuracy.

Genomics Inc. (China) Jan. 2009 – Aug. 2010

Offshore consultant

Provided support to a start-up clinical research company on statistical analysis and data management practice.

Participated in Statistical Analysis Plan (SAP) review and made recommendations on coding and programming methodology.

Conducted review on statistical programs and documented findings while provided recommendations on improving reporting efficiency (i.e. creation of macros, network folder structures…etc.).

Established Standard Operation Procedures (SOP) where necessary.

Adastra Canada (Toronto) Apr. – Nov. 2008

Consultant

Worked with client (BMO) to design and develop a web application to support its portfolio management reporting and to enable end-user request for financial reports from a DB2 database on mainframe.

Developed programs and reports in SAS/COBOL according to application and user specifications to generate data for portfolio management reporting and wholesale/retail customer database (DB2).

Allied Research International (Toronto) 2006 – 2008

SAS Programmer

Developed and revised programs and reports in SAS/COBOL according to Statistical Analysis Plan and system requirements to generate data for clinical studies.

Maintained and supported programs (SAS/COBOL) that run on a daily, weekly and monthly basis which created data file and reports that were required by the client research projects.

Worked collaboratively with data management team to analyze/extract required information from multiple datasets and produce various reports that meets study objectives.

Developed data validation checks to ensure data integrity and information accuracy.

Cancer International Research Group (Edmonton) 2004 – 2005

SAS Developer

Utilized SAS/COBOL to design/develop applications to support multiple multi-center Phase II and III clinical trials and development of clinical drugs and other biologic products.

Developed programs and reports in SAS/COBOL for cancer research and clinical trials.

Maintained and supported set of jobs (JCL) and programs (SAS/COBOL) that run on a regular basis which generated data, files and reports that were required by the system.

TeleSpectrum Canada (Toronto) 2001 – 2003

TeleTech Canada 1999 – 2000

Customer Service Representative

Bell Canada (Toronto) 1998

IS Support Specialist

Johnson & Johnson Corporate Engineering Services, China 1993 – 1998

Project Engineer

Shanghai No.7 Construction & Engineering Company, China 1988 - 1993

HVAC Engineer

EDUCATION

Advanced Network Security & Connectivity, postsecondary diploma 2001

Mohawk College, Ontario

Bachelor of Mechanical Engineering – Tong Ji University, China 1988

PROFESSIONAL DEVELOPMENT

Adobe Analytics 2014

Teradata development training 2012

Micro-strategy training 2008

SAS Enterprise Guide training – SAS Institution 2007

SAS Data Integration (hands-on workshop) – SAS Institution 2006

ETL and Data Warehouse Administration -- SAS Institution 2005

SAS Certified Professional 2002

Microsoft Certified Systems Engineer (MCSE) 1998

Master Certified NOVELL Engineer (MCNE) 1998

Contact this candidate