Simone B
BI & Reporting Analyst
  • Calgary,
  • Canada
Member Since: 2003/05/16
Industry: Accounting/Finance
Top Skills:
Tech Certifications:

BI Analyst, Data Analyst, Report Developer with over 20 years' experience using MS SQL tools

More bio
Points this month0
Total points281,250
Questions: 5
Solutions: 222
Group Discussions: 3
Professional Background
BI & Reporting Analyst
ATB Financial
September 2016 – Present
Edmonton, AB
Data Remediation (Contract)
Alberta Pension Services
March 2015 – July 2015
Senior E-Commerce Analyst
SMS Equipment
July 2011 – May 2015
•      Project Manager in the implementation of an online customer portal. Developed and maintained project schedule. Built a project team including developers, business users, infrastructure support, marketing. Successfully implemented online parts ordering for 30 branches across Canada.
•      Managed team of developers in implementing BI functionality for overseas and Canadian branches, using the Microsoft SQL BI suite: SQL Server, Analysis Services, Integration Services and Reporting Services. Designed and implemented key additions to framework, including implementation of security model. Mentored developers, developed and maintained project schedule. Focused team on rapid troubleshooting and resolution of issues. Assisted with staffing of BI Team. Managed conversion of existing reports to standardized system. Worked with overseas vendor to troubleshoot issues and maintain product delivery schedule.
Business Data Analyst, Database Administrator, Report Developer
Design Group Staffing Inc.
February 1997 – June 2011
Designed ETL packages using MS SQL Server Integration Services 2005, for a variety of applications:
Used SSIS to synchronize user data between Active Directory and other user databases (Payroll system, PAM, front office)
Used SSIS to import contractor timesheet data into PAM system
Used SSIS to integrate timesheet data between 2 different systems, for reporting purposes
Designed packages for a variety of database maintenance tasks
Collaborated with a colleague to introduce a Business Intelligence dashboard for both internal users and external customers. The dashboard was built using Intrexx Xtreme portal software, SSIS 2005, and reporting tool iReports.
Worked with Accounting staff to customize "out of the box" OLAP Analysis cubes using MS SQL Server Analysis Services 2005.
Designed custom objects using T-SQL, such as tables, views, stored procedures, functions, for the migration of data from legacy front-office solution to new software.
Key technical representative on project team for implementation of Great Plains & PAM software (accounting package and staffing agency add-in, respectively)
Designed DTS packages for moving data between Great Plains/PAM and legacy payroll system
Designed custom objects such as views, functions, stored procedures in SQL
Designed and deployed custom financial reports using a variety of reporting tools:
Crystal Reports 11.0 Developer
Great Plains Report Writer
Great Plains/ PAM SmartList Builder
Maintained close working relationship with Executive and Branch Managers
Provided support to operations and administrative groups
Created SQL databases for tracking critical operations information
Documented operational procedures and practices
Designed, developed and implemented KPI reports using Crystal Reports 11.0 Developer, Crystal Enterprise 9.0, Transact SQL, SQL Server 2000
Business needs analysis
Design report layouts
Develop database objects including views, tables, stored procedures, trig
Recruitment Consultant
Design Group Staffing Inc
February 1997 – February 2001
Located suitable candidates using several methods including database search, internet sites, networking and cold calling.
Prepared advertising.
Screened candidates, conducted interviews and completed reference checks.
Edited, updated and rewrote candidate resumes as necessary.
Prepared client proposals.
Followed up with client and scheduled client/candidate interviews.
Arranged travel and accommodation for successful candidates when required.
Remained in regular contact with all contractors.
University of Alberta
Science; Mathematics
1990 – 1995
Austin O'Brien
1978 – 1981
Full Biography


Business Intelligence Professional experienced in successful management of diverse groups of people. Able to lead others in high demand situations. Proven leadership and organizational abilities. Strongly committed to team-building and staff development. Excellent written and verbal communication skills. Confident, articulate, and professional speaking abilities and experience. Empathetic listener and persuasive speaker. Creative and factual writing skills. Excellent presentation and negotiation skills. Dynamic, results-oriented problem solver. Easily understand and solve technical problems. Skilled at evaluating options and generating solutions. Strong problem-solving and analytical skills.

No Languages shown

Level Progress

Current: Level 11
Simone needs 6,750 points to level up.
LVL 12
  • Overall
  • Microsoft SQL Server 2005
  • Microsoft SQL Server
  • Microsoft SQL Server 2008
  • SSRS
  • SQL
  • Microsoft Development
  • Crystal Reports
  • .NET Programming
  • Microsoft Excel
  • SSIS
  • Databases
  • SSAS
  • ASP
  • Microsoft Office
  • Microsoft SharePoint
  • Remote Access
  • SBS
  • VPN
  • Web Languages and Standards
  • Windows Server 2008