Robert Ellsworth, Project Management Professional (PMP) Developer in Markham, ON, Canada
Robert Ellsworth

Project Management Professional (PMP) Developer in Markham, ON, Canada

Member since June 20, 2018
Robert brings technical and business expertise that he's developed during his two decades of consultant work for major institutions, where hundreds of projects have been completed to the clients’ full satisfaction. He excels at architecting solutions with complex requirements that may cross disparate types of technologies. He's also quick to assimilate information for high productivity and quality outcomes within an intense high-tech environment.
Robert is now available for hire

Portfolio

Experience

  • Unix, 20 years
  • SQL, 20 years
  • IBM DB2, 20 years
  • SAS, 20 years
  • SharePoint, 9 years
  • Project Management Professional (PMP), 7 years
  • MicroStrategy, 4 years

Location

Markham, ON, Canada

Availability

Part-time

Preferred Environment

SQL Server with Gitlib for source control.

The most amazing...

...thing I've created was a customer profitability model that include the current and future value.

Employment

  • SharePoint Developer

    2018 - 2018
    Johnson & Johnson
    • Designed a SharePoint site with embedded Tableau reports, which captures report commentary, and allows historical viewing of reports and commentary.
    • Trained staff on maintenance and use of the site.
    Technologies: SharePoint, Tableau
  • Process Architect

    2014 - 2018
    TD Canada Trust
    • Designed a holistic reporting suite for personal business lines.
    • Mentored staff on best practices for report production.
    • Designed automated processes for business reporting.
    • Designed interfaces and distribution process for data and reports.
    • Built a customer contribution model for present and future value.
    Technologies: Windows, SAS, SQL, DB2, SQL Server, MS Office, SharePoint, Tableau
  • Data Warehouse Architect

    2017 - 2017
    CGI
    • Designed an “analytic ready layer” that embeds business logic and standard reporting templates into the data warehouse and reporting environment.
    • Consulted on SAS installations to maximize data privacy protection and environment functionality.
    Technologies: Windows, SAS, SQL, Oracle, MS Office
  • Data Warehouse Architect

    2013 - 2014
    Aimia
    • Designed and built a transactional datamart and reporting suite.
    • Mentored staff on best practices for report production.
    • Designed interfaces and distribution process for data and reports.
    Technologies: Windows, ParAccel, SAS, SQL, DB2, MS Office, SharePoint
  • Data Warehouse Architect

    2011 - 2013
    The Bank of Nova Scotia
    • Designed and built a datamart and reporting suite, working with a cross-functional team.
    • Investigated and obtained product data across a variety of legacy systems.
    • Constructed a data repository to facilitate both ad-hoc and periodic reporting requirements.
    • Designed interfaces and distribution process for data and reports.
    Technologies: Windows, AS400, SAS, SQL, SQL Server, MS Office, SharePoint
  • Senior Systems Consultant

    2010 - 2011
    Bell
    • Worked with a widely distributed team to port a mission-critical application to a new environment.
    • Developed the project plan and managed the project to completion.
    • Coordinated changes in connectivity and data resourcing.
    • Provided training to support staff.
    • Executed, tested, and validated results with a cross functional team.
    • Provided post implementation support.
    Technologies: Windows, AIX, SAS, SQL, Platform Computing Scheduler, MS Office
  • Data Warehouse Architect

    2006 - 2010
    The Bank of Nova Scotia
    • Designed and constructed a process, data repository, portal for automated credit card campaign reporting.
    • Designed and built a retention offer management application. The application provides specific offers for inbound calls, tracks the results of the calls, provides fulfillment capabilities, and results reporting.
    • Constructed a portal that allows the distribution of reports to widely distributed user base without emailing the reports. The solution was constructed based on requirements gathered from the diverse user group.
    Technologies: Windows, AS400, SAS, SQL, DB2, MS Office, SharePoint
  • Senior System Consultant

    2005 - 2006
    RBC Capital Markets
    • Designed and built a robust solution that can load data files of varying structures into Teradata tables. The process constructed a table on Teradata then verifies and loads the data.
    Technologies: Windows, AIX, SAS, SAS Enterprise Guide, SQL, Teradata, MS Office
  • Data Warehouse Architect

    2005 - 2005
    The Bank of Nova Scotia
    • Designed and built a datamart and reporting suite, working with a cross-functional team.
    • Investigated and obtained credit card data across a variety of legacy systems.
    • Constructed a data repository to facilitate both ad hoc and periodic reporting requirements.
    • Designed interfaces and distribution process for data and reports.
    Technologies: Windows, AIX, SAS, SQL, SQL Server, MS Office
  • Senior System Consultant

    2004 - 2005
    Loyalty Group
    • Designed and constructed a micro-strategy solution that can report on product interaction in the food sector.
    • Constructed schema and metrics to facilitate the user requirements.
    • Trained users in understanding and executing the reports.
    Technologies: Windows, AIX, SAS, SQL, MicroStrategy 7i, DB2, MS Office
  • Senior System Consultant

    2004 - 2004
    TD Financial Group
    • Constructed an automated process to sample data to match their campaign models.
    • Trained the systems personnel to run the process.
    • Performed post implementation support.
    Technologies: Windows, SP2, AIX, SAS, SQL, DB2, MS Office
  • Senior System Consultant

    2003 - 2004
    Alberta Municipal Affairs
    • Developed assessment reporting and analysis.
    • Constructed a process to update the Oracle database with change records based on requirements obtained from the business users.
    • Designed and built a process to produce PDF statements for property holders.
    Technologies: Windows, SAS, SQL, Oracle, MS Office
  • Senior System Consultant

    2003 - 2004
    The Bank of Nova Scotia
    • Designed and executed marketing campaigns.
    • Worked with the business user to obtain campaign requirements.
    • Built the campaigns customer selection in Affinium environment.
    • Provided mail files to the mail house.
    • Interfaced with systems to report on results.
    Technologies: Windows, SP2, AIX, SAS, SQL, Affinium, DB2, MS Office
  • Senior System Consultant

    1998 - 2003
    The Royal Bank
    • Designed and built a reporting suite, working with a cross functional team.
    • Investigated and obtain credit card data.
    • Constructed periodic reports.
    • Designed and developed a user interface to a data warehouse using SAS.
    Technologies: Windows, SP2, AIX, SAS, SQL, MicroStrategy 7i, DB2, MS Office
  • Senior System Consultant

    1996 - 1998
    The Bank of Nova Scotia
    • Evaluated and tested a data warehouse design and composition.
    • Designed and developed a user interface for a data warehouse using SAS and VB.
    • Investigated sourcing for the data warehouse load.
    Technologies: Windows, SP2, AIX, SAS, SQL, MicroStrategy 7i, DB2, MS Office, Visual Basic
  • Senior System Consultant

    1993 - 1996
    AXA Insurance
    • Designed and programmed enhancements to the billing and rating subsystem.
    • Designed and programmed the enhancements to underwriting decision subsystem.
    Technologies: IBM 3090, TSO/ISPF, CICS, Cobol, SAS, PMS
  • Senior System Consultant

    1993 - 1993
    Bell Sigma
    • Designed and programmed a large customer billing system.
    Technologies: OS2, SAS

Skills

  • Languages

    T-SQL, SAS, SQL, Visual Basic for Applications (VBA), Java SE, C, VBScript, Excel VBA, HTML
  • Other

    SAS Macros, Project Management Professional (PMP), MicroStrategy
  • Frameworks

    ASP
  • Tools

    Tableau
  • Paradigms

    Iterative Development, Agile Software Development
  • Platforms

    Windows, SharePoint, AIX, Unix, ParAccel, Oracle
  • Storage

    SQL Server 2014, SQL Server 2010, IBM DB2

Education

  • Bachelor of Science (BSc) degree in Computer Science
    1980 - 1985
    University of Toronto - Toronto, Canada
Certifications
  • Project Management Professional (PMP)®
    MAY 2012 - PRESENT
    PMI | Project Management Institute

To view more profiles

Join Toptal
I really like this profile
Share it with others