Michael Albers, Software Developer in Phoenix, AZ, United States
Michael Albers

Software Developer in Phoenix, AZ, United States

Member since August 8, 2019
With a bachelor's degree from DeVry University in 2003 and more than 17 years of professional development experience, Michael has all the technical and communication skills needed to complete projects both efficiently and effectively.
Michael is now available for hire

Portfolio

Location

Phoenix, AZ, United States

Availability

Part-time

Preferred Environment

SQL, Android, PHP, Angular, Material Design

The most amazing...

...thing was winning the 2nd prize runner up in the Google Fit Android Developer contest.

Employment

  • Senior Developer

    2010 - PRESENT
    Superior Court of Arizona (via Sogeti)
    • Acted as the head data architect and head database developer for all team projects.
    • Coordinated all database promotions using Red Gate Source Control and SQL Compare.
    • Migrated databases from SQL Server 2000 to 2008; also handling the in-progress migration to 2016.
    • Designed maintenance plans, configured database mail, operators, jobs, and alerts.
    • Rewrote existing DTS packages in SSIS.
    • Provided SSRS support to team members.
    • Created ad-hoc SQL queries and optimized databases.
    • Implemented table partitioning and replication.
    • Supported existing websites, AngularJS, Angular 7, and TypeScript.
    Technologies: SQL Server, SSMS, Red Gate, SSMS, SSRS, Visual Studio, .NET
  • Senior Developer

    2007 - 2010
    Medical Data Express
    • Designed and developed normalized databases using scripts, stored procedures, triggers, user-defined functions, tables, indexes, and views.
    • Created complex and efficient ad-hoc SQL queries using T-SQL DDL/DML (using SQL profiler, database engine tuning advisor) and reviewed execution plans to achieve peak optimization.
    • Provided database administrative support backup/restore, security, and DBCC statements.
    • Designed and developed complex SSIS packages utilizing extract transform load (ETL) practices interacting with SQL Server 2000/2005/2008, Oracle, Sybase, and various file structures.
    • Designed, developed, and supported VB.NET and ASP.NET applications used to manipulate databases, import/export files, and provide end-users with an easy-to-use interface.
    • Designed and developed efficient and professional SSRS Reports and Crystal Reports.
    • Successfully designed, developed, and supported many ETL processes using SSIS to extract data from eleven different client’s claims payment systems including QNXT, FACETS, AMISYS, MHC, and EDINet (healthcare related).
    • Gained experience with AHCCCS—encountering files including 837, 277, 824, 820, NCPDP, and pend files.
    Technologies: T-SQL, VB.NET, ETL, SSIS, SSRS, SQL Server 2000/2005/2008, Oracle 9i/10g/11g, Sybase, ASP.NET, HTML, JavaScript, CSS, Microsoft Visual Studio, Team Foundation Server
  • Developer

    2004 - 2007
    MSA Solutions
    • Designed, developed, and administered SQL Server databases, stored procedures, DTS packages, jobs, and Microsoft Access databases.
    • Created complex ad-hoc SQL queries using T-SQL DDL/DML.
    • Converted existing VB6 applications into object-oriented VB.NET applications.
    • Designed and developed Crystal Reports and SSRS Reports.
    • Developed partner websites using PHP, CSS, and MySQL.
    • Created and maintained web applications using HTML, CSS, ASP, VB Script, JavaScript, and SQL Server.
    Technologies: SQL Server 2000/2005, T-SQL, DTS, SSRS, VB.NET, ASP.NET, VB6, ASP Classic, HTML, CSS, VB Script, JavaScript, PHP, MySQL, Microsoft Visual Studio, Visual Source Safe
  • Business Support Analyst

    2003 - 2004
    Pegasus Solutions
    • Designed and developed custom ad-hoc SQL queries.
    • Recommended, designed, and developed new ideas within Access and Excel through VBA (macros) to automate tasks.
    • Performed QA on new products.
    • Optimized images with Adobe Photoshop.
    • Facilitated daily communication between business and technical teams.
    Technologies: T-SQL, VBA (Macros), Microsoft Office, Photoshop

Experience

  • Court Health Mobile Dashboard (Android and iOS) (Development)

    I recommended, designed, and developed a data warehouse mobile reporting solution. I implemented SSIS to load data into cubes and dimensions nightly and used Power BI Mobile to create mobile reports which were housed in SQL Server reporting services.

Skills

  • Languages

    SQL, SQL DDL, SQL DML, T-SQL, HTML, JavaScript, Java, PHP, CSS, TypeScript, Visual Basic .NET (VB.NET), Visual Basic 6 (VB6)
  • Tools

    Redgate SQL Compare, Android Studio, SQL Server Profiler, Crystal Reports
  • Paradigms

    Agile Software Development, Android Material Design
  • Platforms

    Windows, Android
  • Storage

    Redgate SQL Toolbelt, SQL Server 2000, SQL Server 2008, SQL Server 2016, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Configuration Manager, MySQL, SQL Server Analysis Services (SSAS), SQL CLR
  • Frameworks

    Angular, .NET, ASP, AngularJS
  • Other

    Material Design, Google Material Design
  • Libraries/APIs

    TensorFlow

Education

  • Bachelor of Science (BSc) degree in Computer Information Systems
    2000 - 2003
    DeVry University - Phoenix, AZ, USA

Certifications

  • Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Database Development
    OCTOBER 2011 - PRESENT
    Interface Technical Training

To view more profiles

Join Toptal
Share it with others