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

Material Design, Angular, PHP, Android, SQL

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: .NET, Visual Studio, SSRS, Redgate SQL Toolbelt, SQL Server Management Studio, Microsoft SQL Server
  • 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: TFS, Microsoft Visual Studio, CSS, JavaScript, HTML, ASP.NET, Sybase, Oracle 11g, Oracle 10g, Oracle 9i, SQL Server 2008, SQL Server 2005, SQL Server 2000, SSRS, SQL Server Integration Services (SSIS), ETL, VB.NET, T-SQL
  • 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: Visual SourceSafe, Microsoft Visual Studio, MySQL, PHP, JavaScript, VB, CSS, HTML, ASP, Visual Basic (VB), ASP.NET, VB.NET, SSRS, DTS, T-SQL, SQL Server 2005, SQL Server 2000
  • 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: Adobe Photoshop, Microsoft Office, Visual Basic for Applications (VBA), T-SQL

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, VB.NET, VB, Visual Basic for Applications (VBA), PHP, CSS, TypeScript, Visual Basic .NET (VB.NET), Visual Basic 6 (VB6)
  • Tools

    Redgate SQL Compare, Android Studio, SQL Server Profiler, SSRS, Visual Studio, Microsoft Visual Studio, TFS, DTS, Visual SourceSafe, Microsoft Office, Adobe Photoshop, Crystal Reports
  • Paradigms

    Agile Software Development, Android Material Design, ETL
  • 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, Microsoft SQL Server, SQL Server 2005, Oracle 9i, Oracle 10g, Oracle 11g, Sybase, SQL Server Analysis Services (SSAS), SQL CLR
  • Frameworks

    Angular, ASP.NET, .NET, ASP, AngularJS
  • Other

    Material Design, Google Material Design, Visual Basic (VB)
  • 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