Michael Lowery Email & Phone Number

Chicago, Illinois, Us

* Data Strategy Development - Define vision, goals, and roadmap for data driven initiatives* Data Governance, Management, privacy, and Compliance - Establish practices, policies and standards, and ensure compliance with data regulations and industry standards* Data Analysis and Insights - Identify trends, patterns, and opportunities to drive business growth* Technology and Tools Evaluation - Evaluate and recommend technology

* IT Help Desk & Support - We provide managed services to support your hardware and software needs.* Software - We will recommend or fully develop custom software.* Business Intelligence & Data Management - We will help collect, catalog, cleanse, and manage your business data. We will also help you clearly define the business questions you want answered, and then determine the best method to present the data in a visually intuitive way.* Personnel Staffing - We will work with you to determine the technical resources needed. Our service will help you staff the resources needed, whether it is part-time or full-time, onsite, remote or offshore.

Rosemont , Il, Us

* Functioned as a integration architect, moving data from source systems via Azure Data Factory into a Snowflake data warehouse.* Architected dimensional models for various subject areas within Snowflake environment.* Lead and managed external consultants creating areas within data warehouse, which included data mappings, technical development, and implementation.* Lead and managed projects with various departments, including technical designs, discussions, and communication to other teams.

Chicago, Illinois, Us

* Functioned as database subject matter expert for the firm in the areas of database development, administration, business intelligence, and cloud infrastructure.* Lead and managed external consultants creating a data warehouse and Power BI reporting infrastructure, which included data mappings, technical development, and implementation.* Lead and managed projects with various departments, including the project management, technical designs and discussions, training, and communication to other teams.* Architected and developed data transfers between vendors and company.* Functioned as Microsoft Azure administrator, setting up security, applications, and business intelligence.* Architected and administered SQL Server environment.

New York, Ny, Us

* Functioned as database subject matter expert (SME) for the Alternative Investment Services (AIS) real estate technology group.* Lead and managed projects, including the project management, technical designs and discussions, training, and communication to other teams.* Lead and managed resources (on-shore and off-shore) to create a data warehouse, which included data mappings, technical development, and implementation.* Developed dashboards and reports for analytic and static reporting.* Architected data transfers between vendors and company, which included hardware specifications for servers and storage.

Chicago, Illinois, Us

* Functioned as database subject matter expert (SME) for the firm in the areas of database development, administration, business intelligence, and reporting.* Lead and managed projects, including the project management, technical designs and discussions, training, and communication to other teams.* Lead and managed external consultants creating an Enterprise Information Management system, which included data mappings, technical development, and implementation.* Developed Power BI dashboards and reports for analytic reporting and SQL Server Reporting Services 2016 for paginated reports, mobile reports, and KPI’s.* Setup Windows Azure for business intelligence deployments and applications.* Architected SQL Server 2014 server environment, which included hardware specifications for servers and storage.* Monitored over 40+ SQL Servers and 400+ databases daily for problems and issues.* Maintained DBA maintenance tasks for all databases in the environment, which includes backups, optimizations, and integrity checks.* Administered SQL Servers using Powershell scripts and other custom T-SQL development.* Developed and maintained integration packages using Integration Services (SSIS).* Created custom DBA application, which documents, monitors, and records relationships between SQL Servers, databases, and jobs.* Troubleshoot application and performance problems using Performance Monitor, SQL Server Profiler, and Dynamic Management Views.* Implemented SQL Server high availability options, such as AlwaysOn and replication.* Proficient in using 3rd party database tools, such as Idera and Red Gate.* Administered Reporting Services and Analysis Services instances.* Created and managed multiple data warehouses, dimensional and relational, and cubes.

Chicago, Il, Us

* Lead DBA team, including project management, technical designs and discussions, training, and communication to other teams.* Monitored over 75+ SQL Servers and 10,000+ databases daily for problems and issues, with some being over 6 TB in size.* Provided 24x7 on call support for key systems.* Maintained DBA maintenance tasks for all databases in the environment, which includes backups, optimizations, and integrity checks.* Administered SQL Servers using Powershell scripts and other custom T-SQL development.* Developed and maintained integration packages using Integration Services (SSIS).* Designed, constructed, and implemented custom database applications, including all of the SQL objects (tables, views, stored procedures, triggers, and functions). * Created custom DBA application which documents, monitors, and records relationships between SQL Servers, databases, and jobs.* Troubleshoot application and performance problems using Performance Monitor, SQL Server Profiler, and Dynamic Management Views.* Implemented SQL Server high availability options, such as server clustering and replication.* Proficient in using 3rd party database tools, such as Idera, Red Gate, SQL Sentry, and Quest.* Administered Reporting Services and Analysis Services instances.* Created reports using SQL Server Reporting Services. * Created documentation for DBA team regarding server maintenance, monitoring, and setup.* Provided developers with best practices and deployment strategies for database applications.* Provided hardware recommendations for SQL Servers.* Architected SQL Server 2012 server environment and coordinated upgrades.

Chicago, Illinois, Us

* Monitored over 70+ SQL Servers and applications daily for problems and issues.* Provided 24x7 on call support for key systems.* Maintained DBA maintenance tasks for over 1,000 databases in the environment, which includes backups and indexing.* Administered SQL Servers using Powershell scripts and other custom T-SQL development.* Developed and maintained integration packages using Integration Services (SSIS), which provide integrations to 3rd party software and in-house development.* Designed and constructed company’s data repository, using custom ETL processes.* Designed, constructed, and implemented custom database applications, including all of the SQL objects (tables, views, stored procedures, triggers, and functions). * Architected and constructed relational data warehouse for various departments within firm.* Created custom DBA application which documents, monitors, and records relationships between SQL Servers, databases, and jobs.* Troubleshoot application and performance problems using Performance Monitor, SQL Server Profiler, and Dynamic Management Views.* Implemented SQL Server high availability options, such as server clustering, database mirroring, log shipping, and replication.* Proficient in using 3rd party database tools, such as Idera, Red Gate, and SQL Sentry.* Coordinated upgrades to SQL Server 2005.* Architected SQL Server 2008 R2 server environment and coordinated upgrades.* Administered Reporting Services and Analysis Services instances.* Created reports using SQL Server Reporting Services and Report Builder.

* Worked part-time (20-25 hours per week) for this non-profit organization that is primarily used by other non-profit organizations for building construction, remodeling, and disaster relief work.* Managed data entry staff of 50 people, interview staff of 40 people, and technology staff of 5 people.* Created applications and implemented workflows for data entry staff.* Trained interview staff how to handle large career fair events, where 80+ individuals would be interviewed in less than 4 hours.* Communicated with over 50 construction departments regarding staffing requests.* Responsible for placement decisions within various departments.* Created and maintained SharePoint website and database applications (SQL Server 2005 and MS Access). * Created and delivered custom reports to over 90 external organizations and over 1,000 individual workers.* Responsible for onboarding process for new workers, which included initial orientation, safety training, and identification cards.

Reston, Va, Us

* Functioned as a database administrator (DBA) to care for over 30+ SQL Servers.* Provided 24x7 on call support for production databases, with some being over 1 TB in size.* Monitored applications daily for problems and issues.* Troubleshoot application and performance problems using Performance Monitor, SQL Server Profiler, and Dynamic Management Views.* Maintained DBA maintenance tasks for over 4,000 databases in the environment, which includes backups and indexing.* Designed, constructed, and implemented custom database applications, including all of the SQL objects (tables, views, stored procedures, triggers, and functions). * Designed and constructed data mart from enterprise data warehouse.* Developed T-SQL scripts and reports for internal and external (client) supported applications.* Developed and maintained ETL packages, using both Integration Services (SSIS) and DTS, moving data between various datasources, such as SQL Server, Sybase, MySQL, and file servers.* Created documentation for DBA team regarding server maintenance, monitoring, and setup.* Created reports using SQL Server Reporting Services.* Consulted with developers and end users regarding requirements for database applications.* Coordinated upgrading database environment to SQL Server 2005 and then to SQL Server 2008. * Implemented database mirroring and a custom log shipping solution to ensure high availability of databases and user applications.* Implemented SQL Server 2005 features, such as partitioned tables, to increase performance.* Provided hardware and software recommendations for SQL Servers.* Implemented third party database tools, such as Red Gate SQL Compare, SQL Data Compare, and SQL Backup, which helped to increase the DBA team’s efficiency.

Tuxedo Park, New York, Us

* Managed team of web and application developers. * Created project plans, designs, and schedules for team.* Discussed and documented requirements with end users and other non-technical personnel.* Provided technical support to team members in database and application development.* Designed, constructed, implemented, and supported global database systems used in over 50 countries, which support multiple languages.* Coordinated and handled upgrades to SQL Server 2005 from SQL Server 2000. * Maintained and converted older database systems, such as FoxPro and MS Access to SQL Server.* Administered and monitored over 100 production SQL Server 2000/2005 databases. * Created, implemented, and enforced policies and procedures dealing with security. * Designed and implemented a custom database maintenance system, which included backups, indexing, and other integrity and performance checking.* Provided training and consultation for developers on database design and programming principles.* Designed and implemented web and database applications using SQL Server 2000, MS Access, VB6, HTML, XML, and ASP. * Developed DTS and DTSX packages to move data between various database systems, including FoxPro, MS Access, and SQL Server 2000 and 2005. * Designed and built large relational databases, including all of the SQL objects (tables, views, stored procedures, triggers, and functions).* Developed custom applications using scanning (Teleform) and mapping (Mapinfo) software.

Espoo, Southern Finland, Fi

* Designed circuit boards.* Worked with FPGAs, to reduce size of circuitry.

Bachelor Of Science, Computer Engineering

Education record