Liviu CUCIUREANU
acemud@r.postjobfree.com
Toronto, ON, M2J2C5
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.