Post Job Free

Resume

Sign in

Data Analyst

Location:
Toronto, ON, Canada
Posted:
June 19, 2014

Contact this candidate

Resume:

Liviu CUCIUREANU

acemud@r.postjobfree.com

** *********** ***, ***

Toronto, ON, M2J2C5

416-***-****

To Whom It May Concern:

This letter is to express my interest in bringing my years of experience in

Data Analysis.

My background includes more than 10 years of service with significant

experience in:

. Manipulating and processing data with high accuracy using relational

database languages

. Applying a variety of mathematical and statistical functions in order

to optimize outcomes

. Familiar with Software Development Life Cycle (SDLC)

In addition to the above skills, I can also offer to a team:

. Perfect relationship with any team player

. Being a thoughtful mind and hard worker - the ship will float in any

conditions

. Promoting a good level of harmonious spirit as well as encouraging

personal and professional development

Thank you for taking the time to review my r sum . I look forward to

speaking with you soon about how I can contribute to the positive and

exciting environment at your company.

Yours Sincerely,

Liviu Cuciureanu

Legally entitled to work in Canada and willing to participate in a thorough

Background Check and Security Clearance if required.

LIVIU CUCIUREANU

(416) 229 - 0736

acemud@r.postjobfree.com

ca.linkedin.com/pub/liviu-cuciureanu/22/aa8/385

PROFILE

Highly skilled and dedicated individual ready to be part of a data analyst

professional team and working with the latest technologies (SAS, R, SQL

Server).

SOFT SKILLS

. Over +10 years of experience in Relational Database Management Systems

(SQL Server)

. Hands-on experience and efficient with reporting tools

. Proficient in writing SQL queries and scripts to updated and manipulate

large data

. Enthusiastic about working in challenging and collaborative environments

. Excellent organizational and time management skills with the ability to

follow-up independently

. Strong background in processes and analysis as well as reporting aspect

presenting the data to stakeholders

HARD SKILLS

. Databases: Microsoft SQL Server, Access, Visual Studio, SSRS, SSAS, SSIS

. Languages & applications: SQL, SAS, Crystal Reports, R, Visual Basic.

PROFESSIONAL EXPERIENCE

Data Analyst Mar 2013 - Jan 2014

CORNERSTONE Group of Companies, Toronto

Department: List Management Services (LMS)

. In charge of updating and modifying SQL scripts to align and optimize

data collection as per client's request in a fast paced environment

. Created reports and improved acquisition lists using SQL server for use

by stakeholders (mainly account managers) to discover data variances and

also improve data quality using Excel pivot tables or custom macros.

. Identified and pulled efficient leads from the Universe Canada by

creating different SQL scripts to match the client's requests

. Improved and updated scripts using dynamic queries for flexibility and

future use by the team members and other stakeholders

Data Analyst May 2011 - Mar 2013

CORNERSTONE Group of Companies, Toronto

Department: Customer Fundraising Services (CFS)

. Designed and executed regular and customized Direct Mailing,

TeleMarketing and e-mail campaigns to qualify leads based on analyses of

profiles; some variables include: postal code, income, job title,

department function, company size, industry, online activities

. Segmented data based on one-time or pre-authorized payment gifts criteria

using RFM (Recency Frequency Monetary) method for the fundraising

organization

. Profiled customers to identify potential leads to create brand awareness

in the long-run using different SAS techniques such as principal

components and clustering analysis

. Created and updated codes to increase the number of new donors or winback

lapsed donors, to optimize the suppression files for our fundraising

companies

. Ensured criteria and processes for that industry are meeting best

practices in the financial data (eg. validation gifts by credit card,

uploading financial securities)

. Created and provided ongoing reports/management dashboards using Crystal

Reports for our clients

Data Analyst/Modeler (SAS) Jan 2010 - May 2011

Data Leverage Consulting, Toronto

. Applied logistic regression models using SAS to establish relationship

between target rates and independent variables, such as credit bureau,

demographics and bank internal transaction records to help determine

leads for Client's acquisition requests of new customers

. Developed model validation using deciles pattern charts, gain charts,

lift charts, miss-classification tables and ROC curves to validate models

and determine suitable cutoffs

. Applied models to predict score ranges for each potential customer, at

the same time, human intervention and business reasoning are used to

adjust scoring results, which lead to final scoring reports

. Involved in customer Life Stage and Life Style segmentation analyses

using principal components and cluster analyses to create useful profiles

for future selections

Data Analyst Nov 2007 - Jan 2010

CORNERSTONE Group of Companies, Toronto

Department: List Processing Services (LPS)

. Consolidated data from different source systems to our destination

database using Excel, VisualFox, SQL Server

. Parsed, cleansed and formatted data; mandatory steps to improve data

quality and utilized applications such as: AA (Address Accuracy - 95%

standard) via Street Sweeper or QCode; NCOA(National Change of Address);

National Do Not Call (NDNC)

. Ensured relation was accurate for all client lists by encoding free-form

and translating coded values, selecting only certain columns to load, and

creating rules to match codes

. Transposing, pivoting and splitting columns to meet the business and

technical needs of the target database from our small to large clients

such as: Dell, CIBC, MBNA, CapitalONE etc.

Superintendent Jul 2005 - Nov 2007

Colonia Treuhand Limited - Group, Toronto

. Created applications using MS Excel to keep materials inventory

. Collected and classified various resources of data (payments, headcount,

orders etc.) to create weekly and monthly reports for management

. Monitored expenditures and income from Property Operations and submitted

regular expense reports to senior property manager/owner

Reporting Analyst Oct 2004 - Feb 2005

Advanced Software Consulting, Richmond Hill

. worked for a Client (financial institution) on understanding the business

requirements

. Developed extract, transform and load scripts to extract and clean data

from SQL database

. Maintained data-backup and recovery

Programmer Analyst Sep 1992 - Jan 2001

Transport & Transit Commission - Suceava, Romania

. Designed and implemented the Infrastructure application - client/server

application - for technical Department using Visual FoxPro 6.0 as the

front-end

. Analyzed the matrices, setting up on processing platforms for all buses

in traffic

. Developed full application lifecycle of Financial Management System using

FoxPro, Access 97

. Managed multiple, concurrent activities and a complex and detailed nature

under tight timelines

. Initiated and created a daily task status report to expedite the process

for monitoring and analyzing services to identify opportunities for

improvement and recommended solutions

. Implemented the connection of the county's cities at the Infrastructure

database via dial-up, for query

. Designed and developed reports, gathered, validated and documented

business requirements

. Trained staff in using the Accounting and Budgeting application

EDUCATION

2011 - Statistical modeling using SAS (level 2 & 3) - Metro College,

Toronto

2010 - SAS 9 Programming 1: Essentials Metro College, Toronto

2010 - Trading Stock & Currency - Online Trading Academy, Toronto

2009 - SQL Server 2005 - Ryerson University, Toronto

2006 - 2007 Statistics and Mathematics of Business in Finance - Seneca

College, Toronto

Bachelor's Degree in Engineering, University of Bucharest

INTERESTS

Off work - Day Trader (Self-employed) Jan 2010 - present

OANDA Platform

Practice FX day trading to be familiar with technical indicators and time

series data

. Trading philosophy is to focus on short to medium term trade cycles

employing a wide set of technical studies and wave theory practice to

capture frequent trading pip moves from 15 to 60. Experienced with

different pairs of currencies; however EUR/USD most frequently used

. Analyze economic trends and financial markets in North America, Europe,

and Asia

Other interests include: tennis, art painting and travelling.



Contact this candidate