Hi,

One sec...

Enter

Collaborated on an asynchronous ETL application (Extract Transform Load) to routinely migrate financial transactions for a government entity handling statewide financial data

Features:

  • Orchestrated multiple SSIS packages to asynchronously migrate ~1M financial and transactional records daily
  • Indexed relevant columns and followed best practices in table normalization to optimize query performance
  • Configured Change-Data-Capture (CDC) to monitor data changes and replace existing triggers impacting performance
  • Created user functions and staging tables to accommodate time zone differences in UTC and to track changes
  • Collaborated with Database Administrators to implement High Availability and Disaster Recovery (HADR) redundancy

Implemented multiple Dynamics CRM instances with Office 365 application integration across five departments including SSRS reports and Javascript to synchronize mapping API

Features:

  • Developed custom plugins, web resources, and SSRS-embedded dashboards to handle business logic beyond default
    capability of CRM instance
  • Leveraged Javascript Es6 syntax to write maintainable and concise scripts to calculate time zones dynamically utilizing
    Bing Maps API
  • Consulted on the pros and cons of implementing a custom versus default solution in areas such as Microsoft Flow and
    Power BI instead of standard workflows and charts
  • Integrated external Dynamics applications including SharePoint, OneDrive and Voice-of-the-Customer

Configured Power BI dashboard for a youth empowerment nonprofit to showcase data patterns in student performance, demographics, and volunteer retention

Features:

  • Implemented ESRI location mapping tool to pinpoint target neighborhoods that were not served
  • Created training program for application use and user buy-in
  • Consulted in payment plans and best practices in embedding maps for public use
  • Facilitated migration from storing data in excel to storing in Salesforce for eventual connection to Power BI

Collaborated on a .NET Core application to assist an investment company in showcasing their members.

Features:

  • Utilized Razor views and JQuery Datatables for user interaction
  • Implemented ‘Repository Pattern’ architecture
  • Utilized Entity Framework Core as ORM
  • Maintained deployment cycle leveraging Visual Studio with Azure deployment tools
  • Maintained ongoing updates and service requests