Andrew Murphy, Business Intelligence Developer in Miamisburg, OH, United States
Andrew Murphy

Business Intelligence Developer in Miamisburg, OH, United States

Member since November 15, 2019
Andrew is a customer-focused developer with robust data skills, including database design, optimization, app development, ETL, data visualization, reporting, and cloud. He specializes in developing with .NET and custom Microsoft Outlook add-ins and has led teams successfully. With business acumen—gained from his MBA studies and multiple years spent working in corporate America—Andrew skilfully balances business and development goals with ease.
Andrew is now available for hire

Portfolio

  • Integrity Data Insights
    SQL Server, Microsoft .NET, C#, Tableau, Microsoft Power BI, Azure...
  • LexisNexis
    Microsoft SQL Server, SQL Server Integration Services, C#, ASP.NET...
  • LexisNexis
    Microsoft SQL Server, SQL Server Integration Services, C#, ASP.NET...

Experience

Location

Miamisburg, OH, United States

Availability

Part-time

Preferred Environment

Microsoft SQL Server, .NET, Tableau, PowerBI, SQL

The most amazing...

...thing was developing a system to manage the bidding process for a client. It saved hours of time for each rep and revolutionized their process.

Employment

  • Founder | Consultant

    2016 - PRESENT
    Integrity Data Insights
    • Developed a complete solution to automate project bidding for clients and sourcing for partners. This completely modernized their processes, reduced sales rep time, and captured critical data used for analysis and better decisions.
    • Designed and implemented a data warehouse to automatically capture critical business data all in a single location; used Tableau for data visualization and report automation—this allowed the client to easily see key metrics they needed real-time.
    • Automated the process to send NPS (net promoter score) surveys to clients based on Salesforce information.
    • Developed a unique solution to display Tableau reports on digital signage throughout the client's office, built a website to integrate with digital signage application, and enabled that new client opportunities are updated hourly on screens.
    • Assisted with a massive customer migration which moved thousands of customers from a legacy software platform to a more modern stack, implemented a critical data analysis and data retrieval in Teradata to support the efforts, and tracked the status of migrations.
    Technologies: SQL Server, Microsoft .NET, C#, Tableau, Microsoft Power BI, Azure, Salesforce, QuickBooks
  • Manager, Marketing Information Systems

    2010 - 2016
    LexisNexis
    • Managed a software development team for marketing and sales databases for three major business units with more than $1-billion in revenue.
    • Supervised the efforts to enhance database, fix issues, and communicate the progress on initiatives to key business unit leadership.
    • Gathered requirements for new features and provided technical guidance and problem-solving support to team members.
    • Coordinated software releases and quality assurance checks.
    • Managed the global software development team and provided data analyses.
    • Designed and implemented automated processes for performing and reporting on quality assurance checks.
    • Converted the team to agile methodology and worked with leadership on this transition.
    Technologies: Microsoft SQL Server, SQL Server Integration Services, C#, ASP.NET, DataFlux Data Management Studio
  • Senior Software Engineer

    2000 - 2010
    LexisNexis
    • Developed a customer insight website that averages over 200 users per month across all LexisNexis business units; it delivers key customer intelligence in an innovative, user-friendly interface.
    • Created a customer alert system featuring predictive analytics by partnering with team statistician in implementing a customer cancellation model and statistical confidence intervals to track customer behavior shifts and deliver results to end-users.
    • Built a sales territory management and forecasting tool that enabled sales reps to report predicted performance against goals.
    • Created the Murphy Report: the company's standard report providing customer profile data to the sales force (it produced over 39,000 reports in 15 years).
    Technologies: Microsoft SQL Server, SQL Server Integration Services, C#, ASP.NET, DataFlux Data Management Studio

Experience

  • Game-changing Sales Bid Tool (Development)

    I developed a game-changing solution to automate project bidding to clients and sourcing to partners done by a client. This completely modernized their processes, reduced sales rep time, and captured critical data that was used for analysis and better decisions going forward.

    This project combined a Microsoft Outlook add-in, a website written in MVC framework, C# console back-end processes to route emails between the client and their partners, and an integration with Salesforce using APIs to create opportunities and edit attributes.

    The solution also included a website to search projects utilizing Azure Search technology to deliver results in seconds against non-structured data

  • Complete Reporting System (Development)

    I developed a complete end-to-end solution to consolidate client's business data from multiple systems, loads them into a SQL database, and sets up Tableau reports to visualize and easily access them.

    The client was able to view their key business metrics easily and always have up-to-date information. The reports saved hours of manual effort by accounting and other teams.

    I used SQL Server Integration Systems, Salesforce Apex Loader, Tableau Online, and third-party software to integrate with QuickBooks.

  • Customer Classification System (Development)

    I developed a customer classification system that accurately classified the client's customer base into different segments as needed by the client based on the demographic data points available (company website, company name, NAICS, and so on).

    This rules-based system was implemented in SQL Server. It would capture and store the classification options available for a data record and ultimately pick a winner based on a scoring algorithm. This process was critical as it was used for prospect assignments across multiple business units.

Skills

  • Tools

    Tableau Desktop Pro, Azure Search, Microsoft Power BI, Jira
  • Storage

    Microsoft SQL Server, SQL Server Integration Services (SSIS)
  • Languages

    C#, SQL
  • Libraries/APIs

    Salesforce API, Microsoft Graph API
  • Platforms

    Azure
  • Other

    Outlook Add-ons, REST API Clients
  • Frameworks

    ASP.NET

Education

  • Master of Business Administration (in progress) degree in Business Administration
    2014 - 2020
    University of Dayton - Dayton, OH, USA
  • Bachelor's degree in Computer Information Science
    1996 - 2000
    Cleveland State University - Cleveland, OH, USA
Certifications
  • Yellowbelt in Process Improvement
    DECEMBER 2015 - PRESENT
    LexisNexis

To view more profiles

Join Toptal
I really like this profile
Share it with others