Michael Albers
Verified Expert in Engineering
Data Architecture Developer
With a bachelor's degree from DeVry University in 2003 and more than 18 years of professional development experience, Michael has all the technical and communication skills needed to complete projects both efficiently and effectively. Michael enjoys Android development and his keen interest in the field has brought him a reward and experiences that have grown and proven his expertise and commitment to innovation.
Portfolio
Experience
Availability
Preferred Environment
SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Power BI, Data Architecture
The most amazing...
...thing I've done was become the 2nd prize runner-up in the Google Fit Android developer contest.
Work Experience
Senior Developer
Superior Court of Arizona (via Sogeti)
- Served as a 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 to 2019.
- Designed maintenance plans, configured database mail, operators, jobs, and alerts.
- Rewrote existing DTS packages in SSIS during the SQL 2000 - SQL 2008 upgrade.
- Provided SSRS support to all teams needing guidance.
- Created ad-hoc SQL queries and optimized databases.
- Implemented table partitioning and replication in SQL 2016.
- Supported existing websites, AngularJS, Angular 7, and TypeScript.
- Designed and created a data mart with cubes/dimensions and mobile reports.
Senior Developer
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.
Developer
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.
Business Support Analyst
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.
Experience
Court Health Mobile Dashboard (Android and iOS)
Skills
Languages
SQL, SQL DDL, SQL DML, T-SQL (Transact-SQL), HTML, JavaScript, Java, VB.NET, Visual Basic, VB, Visual Basic for Applications (VBA), PHP, CSS, TypeScript, Visual Basic .NET (VB.NET), Visual Basic 6 (VB6), Active Server Pages (ASP)
Tools
DTS, Redgate SQL Compare, Android Studio, SQL Server Profiler, Microsoft Power BI, Visual Studio, Microsoft Visual Studio, TFS, Visual SourceSafe, Adobe Photoshop, Crystal Reports
Paradigms
ETL, Agile Software Development, Android Material Design
Platforms
Windows, Android, Firebase
Storage
Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Redgate SQL Toolbelt, SQL Server 2000, SQL Server 2008, SQL Server 2016, SQL Server Management Studio (SSMS), Databases, SQL Server Configuration Manager, MySQL, Oracle9i, Oracle 10g, Oracle 11g, Sybase, SQL Server Analysis Services (SSAS), SQL CLR, Database Architecture
Other
SSRS Reports, Data Architecture, Data Engineering, Data Modeling, Material Design, Google Material Design, Microsoft 365
Frameworks
Angular, ASP.NET, .NET, AngularJS
Libraries/APIs
TensorFlow
Education
Bachelor of Science (BSc) Degree in Computer Information Systems
DeVry University - Phoenix, AZ, USA
Certifications
Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Database Development
Interface Technical Training
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring