Data Analyst

An energetic professional with exceptional Project Management and Analysis Skills

Database: SQL Server 2008/2012, Oracle9.x, MS Access

Database Tools: Developer 6i, SQL*Plus, Toad, SQL Box, Teradata, Aprimo, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Languages: PL/SQL, Visual Basic 6.0

Applications: Tableau 7.0, SAS 8.2, System Dynamics, Cognos 7.0, PeopleSoft Financial 9.0, Helix, SAP CRM, Meditech 5.5, MS Office, MS SharePoint

+10 years of experience spanning various Industries (IT, Banking, Telecommunications, B2B, Healthcare, Online Publishing, Automotive)

Strong technical skills, business acumen & analytical expertise

Experience with CRM & ERP systems

Working towards PMP

Project Coordinator / Business Analyst Consultant

Jun 2014 – March 2020

RBC Royal Bank

Working with RBC Telecom team on a large telephone system migration project from Centrex to IP solution. Retail Branch Voice Program (RBVP) is a $200 million collaboration between RBC, Bell, Telus & Cisco spanning over 1300 transits across Canada including Personal & Commercial Banking, Insurance and Wealth Management.

Worked on key project deliverables. Organized discussions with stakeholders, collected project requirements, and created requirements documentation. Defined project scope and identified required work assets. Worked with sr. project manager and team managers on WBS documentation. Coordinated project execution. Involved in Control Scope, monitoring work progress and creating change requests.

Extracting and consolidating information from various feeds (contacts, billings, transits)

Designed and implemented process checks and coordinated all aspects of tasks completion, assigning work to the resources and tracking completion

Created work frame for vendor SLAs (Bell, Rogers).

Created and monitored KPIs, and advocated procedures to optimize process efficiency.

Provided daily and monthly project updates to customers (P&CB, DS senior management).

Identify the discrepancies in address, EID, phone number, correct before creating the migration data files

Created status reports for Sr. Management using data extracted from Telemanager (ERP Inventory Management)

Collaborating with program leaders and telecommunication analysts to ensure deliverables, dependencies and audits are executed as per the schedule baseline, tracking open tickets in Jira

Created processes and trained a team of 10 people

Developed tailored Excel VBA macros & pivot tables to analyze project data

Maintained and controlled RBVP’s centralized database and monitored Bell’s project dashboard to ensure success of daily planned migrations and escalating issues

Coordinated processing of 6-12 site migrations per day

Created periodic risk reports, and shared them across teams

Managed daily post-migration defect reports

Managed expectations from stakeholders and engaged vendors for deadlines acceptance

Tools used: Telemanager, SQL Server 2005, advanced MS Excel (pivot tables, v-lookups, macros), MS Access, SharePoint, MS Project, Jira (Kanban projects for tickets)

Business Advisory Manager

Jun 2013 -- May 2014

Moneris Solutions

Provided analytical support on business performance, revenue, net revenue, interchange, operational efficiency, churn and attrition to Finance Sr. Management and CFO

Monitored credit and debit card clients portfolio providing solutions for seamless integration into their ERP or accounting system

Worked with Order Management on adding/maintaining customers, price/fees changes

Monthly maintained and monitored credit data and identified risk

Master data design and reporting

Performed data segmentation by client

Provided data analysis supporting client centric decisions through leveraging common CRM expertise, knowledge, processes, information, and technology

Created various ad-hoc reports using SQL Server and MS Excel (pivot tables, v-lookups, macros)

Data hygiene to ensure integrity and accuracy (identify the discrepancies and correct the data)

Coordinated various projects and managed implementation

Maintained a daily tracker for the ad-hoc requests using MS SharePoint to illustrate the changes

Tools used: SQL Server 2012, Advanced MS Excel (pivot tables, v-lookups, macros)

Database Analyst Consultant

Feb 2012 – May 2013

Pitney Bowes/ Digital Cement Inc.

Coordinated communication between data, QA, campaign management and implementation teams

Participated in Aprimo (Marketing Resource Management ERP) implementation to support marketing campaigns

Created control processes and identified gaps (risk analysis)

DQA daily loads from SQL Server into Teradata (data warehouse) and Aprimo (master data) to ensure integrity and accuracy

Prepare the data files for email/DM campaigns\22 files per campaign containing 3.5mil records

Identify the files that did not contain clean data a/p the campaign architecture document and communicate to the client

Document discrepancies and design processes for better capture of discrepancies

Daily monitoring the data in SQL Server. Teradata and Aprimo to identify discrepancies and correct them

Sample data to ensure it is consistent with the data warehouse requirements

Performing data segmentation for various CRM campaigns (USPS, Timothy)

Participated in the execution and DQA of the mail files by applying the most recent opt-outs from Privacy Office, bounces, suppression lists and Nixie files

Data activities for marketing programs (email campaigns, web, DM)

Marketing campaign reports and analysis, identifying discrepancies in reporting

Data cleansing initiatives to identify inaccurate, missing or redundant information from different sources

Direct mail address validation using NCOA

Responsible for post campaign email reporting: 3,5,7,10,14 days

Tools used: SQL Server 2008, SSIS, Teradata, Aprimo, Advanced MS Excel (pivot tables, v-lookups, macros), MS Access, Tableau 7.0, Google Analytics, Silverpop, SharePoint

Business Analyst

Jun 2011 – Feb 2012

Bank of Montreal

Participated in development, implementation and facilitation of data quality processes, data quality metrics and data quality controls for existing and new applications

Identified, created and monitored metrics reports and KPI Indicators (active and dormant accounts, attrition, clients age, DOB)

Consulted with departments to understand business objectives, translated business requirements into development tasks and ensured alignment of priorities to identify risk, so that overall Bank objectives and priorities are realized

Assured the definition of business data is complete

Master data reporting Identified and ensured the resolution of data quality issues, such as uniqueness, integrity, accuracy, consistency and completeness in a cost-effective and timely fashion

Performed periodic data quality profiling - based on the business rules

Supported CI&DS operations in assuring the development and maintenance of metadata

Assisted Technology and Architecture teams in implementing data quality processes

Identified areas for data quality improvement and helped resolve the problems

Created the business rules for CAD using DataFox Tool

Specialist Business Intelligence

May 2011 - Oct 2011

MTS Allstream

Provided tailored analytics, expert data leadership, marketing intelligence and actionable analysis to marketing and other departments

Created reports measuring customer satisfaction

Defined data requirements, determined the best sources for the data, ensured data integrity, developed database queries, troubleshooting and liaised with key contacts in other departments

Advanced Customer and Prospect Base analysis and list generation using advanced analytics to support demand generation, acquisition, and cross-sell programs through expert data manipulation from various internal and external sources such as Common Customer View, Allstream Financial data, Allstream Data warehouse, Master Customer and Prospect data mapped to Allstream footprint (SAS), Sale funnel data, D&B Market data

Used expert analytical and technical skills to produce in-depth master and transactional data analyses in very short timeframes without neglecting data integrity and the analysis’ objectives

Advised business managers on the availability and accuracy of customer data to fulfill objectives

Online Marketing Analyst

Sep 2010 – Apr 2011

Trader Corporation

Master data reporting & analysis to understand customer behaviors, site usage, and trend tracking

Data extract using Helix ERP and perform data profiling and recommendations for Sales and Marketing

Data analysis to identify customer needs and at risk dealer groups (create complete dealer profile by identifying and measuring the key metrics - make, model, lot size, region)

Identified churn risk for dealers

Actionable insights to Sales Executives, to support Sales Retention Strategies

Data segmentation by geographic area, size, type, and product to understand each group's unique needs, and translated findings into areas of opportunity (i.e. upsells, cross-sell, churn, etc.)

Quantify benefits for new business initiatives thorough in depth understanding of online customer behavior (i.e. leads, traffic)

Ad-hoc SQL queries to support new and existing marketing and business initiatives

Data quality processes are followed and dynamically updated

Data quality audits

User acceptance testing for online data collection

Tools used: Helix ERP (end-to-end solution designed to manage core business processes, sales, purchasing, accounting, inventory), SQL Server, SSIS, MS Excel (pivot tables, v-lookups, macros), MS Access, SharePoint

Marketing Analyst

Feb 2009 – Sep 2010

Sears Canada

Business reports, advanced pricing analysis and data modeling for Marketing Department

Report build, validation and update to ensure precision and integrity of data collection

Supported ERP modules (Product Listing, Inventory, Suppliers Management, Reports and Analytics)

Pull reports from all ERP modules and conduct weekly meetings to verify and cross connect the accuracy of the data and promote marketing suggestions

Forecasted number of transactions based on existing historical data using PeopleSoft Financial Control and Reporting

Identified KPI Indicators for various promotions and built metrics reports

Regression analysis and sales forecasting for Retail Sales Balanced Scorecard (sales controller, cost of goods sold (COGS), sales capacity)

Built database for regression models

Point of contact for data quality issues and troubleshooting

Risk analysis in terms of sales and profitability

Data quality activities focused on offers and promotions, ad-hoc queries

Database Administrator

Apr 2008 - Oct 2008

Giffels/ The Ingenium Group

Databases maintenance and Intranet / MS Access applications support

Database monitoring (dead locks or blockages) and performance troubleshooting

Databases design, table, views and stored procedures creation

In-house applications support

Ad-hoc queries and reports for Accounting and Cost Control departments

SQL jobs creation to automate repetitive tasks

Tools used: SQL Server, MS Access, MS Excel, Jira (tracking tickets)

Data Analyst Operations

Jan 2008 - Apr 2008

Pitney Bowes/ Digital Cement Inc.

Data activities for marketing programs (email campaigns, web, DM)

Data segmentation for various CRM campaigns (FedEx, FedEx -NFL, Kraft, General Mills, Astra Zeneca, John Hancock, Bell clients)

Reporting & Analytics prime to define Measurement Plans and reporting requirements

Additional insights to supplement existing reporting and analysis findings for cross-functional teams

Marketing campaign reports and analysis - actionable recommendations and results

Data cleansing initiatives to identify inaccurate, missing or redundant information from the systems

Marketing Database Analyst / CRM Data Analyst

Jan 2007 - Dec 2007

SAP Canada Inc.

Developed and implemented data initiatives between Canadian and International IT departments to support CRM and ERP modules

Master data activities (uploading and maintaining contacts), built various reports and analyzed data

Data quality and system synchronization responsibilities for Marketing and Sales databases

New SQL and Access reports; developed request tracker (using Report Tracker)

Time savings (75% reduction) through report automation and standardization

Project management activities, from timelines to budgets to risks

Quality assurance testing on data and new modules

Access rights management for test and production systems using Virsa Access Enforcer

Accounting Assistant

Apr 2005 – Dec 2006

Bloorview Kids Rehab

Master Vendor list set up and maintenance for company’s internal ERP system (Meditech)

Accounting prime in ERP software upgrade initiative (Meditech 5.3 to 5.5)

Report creation for Executive and Senior Leadership teams (23 reports/ week) using Cognos 7.0

Reported directly to Director of Finance

EDUCATION & TRAINING

Microsoft SQL Server 2005 - Implementation and Maintenance - Nexient – 2008

Project Management - University of Toronto – 2008

Software Quality Assurance - Innovative Technologies Alliance – 2001

Oracle Developer - DEEDS Project - University of Toronto – 2001

B.Sc. / M.Sc. Industrial Chemistry - University of Bucharest – Romania -1994

Contact this candidate