Richard Fleischmann, Database Developer in Toronto, ON, Canada
Richard Fleischmann

Database Developer in Toronto, ON, Canada

Member since July 3, 2020
With over 30 years of experience in database architecture and development, Rick has worked on data systems from a wide range of industries. From system migration and integration to full ERP development, Rick excels at researching and delivering the best buy/build solution for the client's needs.
Richard is now available for hire

Portfolio

Experience

Location

Toronto, ON, Canada

Availability

Part-time

Preferred Environment

Salesforce, SQL Server Integration Services (SSIS), Microsoft SQL Server

The most amazing...

...full data warehouse I've built integrated HEAP, Salesforce, and client SaaS app data into the Salesforce Einstein Analytics platform for stakeholder delivery.

Employment

  • Senior Database Developer and Analyst

    2015 - 2020
    Xello, Ltd.
    • Integrated SQL Server databases with Salesforce, whereby SQL was used to perform Opportunity upserts, report data generation, NetSuite integration, and an internal SaaS application integration; DBAmp was the third-party connector used.
    • Migrated two companies' CRMs into Salesforce (from MS dynamics and Salelogix respectively).
    • Migrated two companies' accounting systems into NetSuite (from Great Plains and Sage respectively).
    • Developed a data warehouse and integrated Salesforce and the company‚Äôs SaaS applications with it.
    • Developed SSIS procedures to ETL data from HEAP (via Snowflake), Pardot, and the data warehouse into Salesforce Einstein Analytics.
    • Developed NetSuite SuiteScript routines and C#.NET REST calls to retrieve NetSuite data into SQL and ultimately Salesforce.
    • Administered SQL Server instance containing multiple databases.
    • Performed extensive Salesforce development, including both declarative and code-based activities (Process Builder, Flows, Validations, Apex code including triggers, Lightning components, and some LWC development).
    • Created advanced T-SQL procedures, functions, views, triggers for OLTP, ETL, and reporting purposes.
    Technologies: KingswaySoft, JavaScript, Angular, C#, NetSuite, Salesforce, SQL Server Integration Services (SSIS), Microsoft SQL Server
  • Database Developer

    1995 - 2020
    Vince Giordano and the Nighthawks
    • Designed a database system to catalog a large collection of paper orchestrations, sheet music, and other music-related media. The database has been referred to in articles about the band in the New York Times.
    • Created a simple website for querying the database (including the IIS hosting platform); see Vince.zapto.org.
    • Performed ongoing remote system and network maintenance.
    Technologies: Visual Basic for Applications (VBA), Microsoft Excel, Microsoft Word, Microsoft Access, Clipper
  • Report Developer

    2007 - 2015
    MTS Allstream
    • Provided timely, sophisticated reporting solutions to various departments including finance, marketing, and operations.
    • Designed and maintained a key revenue, cost, and margin reporting SQL Server data mart responsible for the consolidation of tens of millions of dollars of financial information each month.
    • Contributed to enterprise data warehouse development, including reconciliation and testing.
    Technologies: Visual Basic for Applications (VBA), VB.NET, Microsoft Access, SSRS, SQL Server Integration Services (SSIS), Microsoft SQL Server
  • Database Developer

    2007 - 2007
    Oasis Employment
    • Improved the client experience and data maintainability by merging two Microsoft Access databases into one, along with all functionality and user interfaces.
    • Improved ease of use and flexibility without sacrificing data validation routines.
    • Implemented client-customizable security features and reporting capabilities.
    Technologies: Microsoft Access

Experience

  • Migration of Two Accounting Systems (Development)

    I migrated two companies' accounting systems to NetSuite: one from Sage and one from Great Plains. This work included A/R and A/P clients, vendors, and their outstanding items as well as the consolidation of their GL trial balances.

  • Migration of Two CRMs (Development)

    I migrated two companies' CRMs to Salesforce: one from Microsoft Dynamics and one from Saleslogix. SSIS and the SQL server were used as ETL and staging tools. Opportunities, invoices, accounts, leads, contacts, and tasks were among the objects migrated. In addition to tricky field mapping (the Dynamics data was very convoluted, with hundreds of extra fields that I had to determine were no longer used), business processes in Dynamics that didn't match the target Salesforce organization's needs.

  • Data Warehouse Architecture and Development (Development)

    I developed a data warehouse in SQL server that accumulated and consolidated data from HEAP (app login data), Salesforce, NetSuite, and two native SaaS applications. This was then used for nightly updates of a Salesforce Einstein Analytics installation.

  • SSIS ETL Development (Development)

    I created multiple complex packages using native as well as third-party tools (KingswaySoft). This included pulling from Snowflake, Salesforce, SQL server, NetSuite, and Pardot and sending it to Salesforce and Einstein Analytics.

  • Salesforce and SQL Server Development (Development)

    I developed the production organization, including custom objects, layouts (Lightning), processes, flows, Lightning components, and Apex code. I made extensive use of the connection of Salesforce data to the SQL server (via third-party software) to enable complex data manipulation and report creation, which was then fed back to Salesforce.

Skills

  • Languages

    Visual Basic for Applications (VBA), SQL, APEX Code, JavaScript, C#, VB.NET, Clipper
  • Tools

    Microsoft Access, Salesforce Einstein, SSRS, Microsoft Word, Microsoft Excel
  • Paradigms

    ETL
  • Platforms

    Salesforce
  • Storage

    SQL Server Integration Services (SSIS), SQL Server 2014, Microsoft SQL Server
  • Other

    Financial and Management Accounting Principles, Data Warehouse Design, Data Migration, Data Aggregation, Data Engineering, Data Analysis, Data Warehousing, NetSuite, KingswaySoft
  • Frameworks

    Lightning Components, Angular

Education

  • Bachelor of Business Administration degree in Finance, Accounting
    1981 - 1985
    York University - Toronto, ON, Canada

Certifications

  • Options Attorney
    JULY 1987 - PRESENT
    Toronto Stock Exchange

To view more profiles

Join Toptal
Share it with others