Michael Taylor
Apopka,FL
Summary
Results-oriented IT professional with 27 years of experience in database administration, query tuning, and server performance monitoring. Skilled in SQL Server job automation, database schema development, and SSRS reports administration. Proficient in Microsoft Azure databases and data integration services. Strong organizational and project management skills, with a focus on problem-solving and prioritization. Excellent communication abilities and a commitment to handling confidential information with integrity. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Overview
27
27
years of professional experience
Work History
Data Analyst
CMC Energy Services
Remote VPN
11.2021 - 02.2024
- Developed ETL Integration Between Configured Azure SQL Server Database And On-Premise SQL Server Database Using Azure Data Factory And Runtime Services Integration With Azure.
- Developed And Managed New And Existing 1100 SSRS Reports For End Users As Well As Performed Enhancements And/Or Fixes On Existing SSRS Reports.
- Automated The Emailing And Snail-mailing Of Parameterized SSRS Reports with Custom Recipients And Subject Line Information using Custom Developed SQL Server Code That Replaced Existing DDS Based Stored Procedures By Manipulating Extension Settings In Report Server Subscription(s).
- Stood Up New Test SSRS Reporting Server Instance and Migrated SSRS Reports To This Server.
- SQL Server 2016 Database Administration Tasks And Duties
- SQL Server 2016 Database Developer Tasks And Duties
- Managed/Enhanced Microsoft Access Custom Built VBA Application which managed And performed Quality Assurance on Work Order Inspections, Performed Invoicing, Rebates To Vendors And Utility Companies While Transitioning To Salesforce.
- Performed Disaster Recovery Operations For SQL Servers And SQL Databases When Needed.
- Wrote SQL Server Merge Replication Scripting To Automate ETL Processes.
- Performed Graphical Logo And Header Changes To PECO Energy SSRS Cost Estimate Reports Using Gimp (Photoshop Similar Application).
Contract - Database Administrator/BI Developer
Beacon Hill Staffing Group, Inc. (For Southmill Champs Mushrooms, Inc.)
Kennett Square
07.2021 - 09.2021
- Designed Power BI reports to support employee headcount, retention levels, and employee turnover analytics for the company’s back-office initiatives
- Performed general practice database administration tasks, including transactional troubleshooting and performance tuning recommendations
- Made SQL Server recommendations to address practical resource utilization problems across servers
- Provided consulting services for the company’s technical and architectural initiatives
- Developed SQL scripting automation for REST API connectivity, importing and transforming JSON files into SQL Server for reporting purposes
- Quickly learned Power BI within a span of 2 months to deliver reporting, ETL development, and dashboard design requirements.
BI Developer
European Metal Recycling, Inc. (EMRgroup.com)
Camden New Jersey
01.2019 - 08.2020
- Designed and maintained Autoparts-based Grafana BI Dashboards, integrating data from multiple database sources and Grafana plugins
- Developed dashboards for Sales projections, Daily QA Analytics, Part Photo Analytics, and Dismantling Line analytics
- Automated ETL jobs using SQL Server User-Defined Table Types between an Azure database and Cosmos via Azure Data Factory pipelines
- Created a new MAS (My Auto Store) Autoparts-based OLTP Data Warehouse, scripting and automating SQL jobs for hourly ETL processing
- Constructed parameterized BI reports using SSRS for on-demand access and automated subscriptions with email data exports
- Generated ad-hoc SQL Server data exports from the data warehouse to external database sources in desired formats
- Demonstrated daily SQL scripting expertise, including designing, building, and maintaining SQL tables, stored procedures, triggers, views, user-defined functions, indexes, keys, constraints, linked servers, and dynamic SQL
- Actively participated in Weekly Scrums to ensure data quality and alignment with company and departmental goals.
Database Administrator
American Association for Cancer Research (AACR.org)
Philadelphia PA
01.2016 - 01.2019
- Provided professional database development and coding following industry best practices while incorporating innovative methodologies
- Conducted daily SQL scripting tasks, including designing, building, and maintaining SQL tables, stored procedures, triggers, views, user-defined functions, indexes, keys, constraints, linked servers, and dynamic SQL
- Performed database performance tuning using tools such as SQL Tuning Advisor and SQL Profiler
- Demonstrated expert knowledge of database architecture and best practices for new solutions
- Designed and maintained reports and Business Intelligence solutions, including SQL data warehousing, Data Marts, Data Cubes, and self-service BI solutions via ETL methodologies
- Ensured database software, operating system, and network compliance during upgrades, migrations, and integrations
- Resolved SQL Server database interruptions or outages through troubleshooting and research
- Acknowledged and resolved Interdepartmental Helpdesk Support requests related to database technology and data services
- Collaborated effectively in a team environment and worked independently with minimal supervision
- Adhered to best practices for executing production, development, and test environmental code and server change management protocols.
Database Manager
Philadelphia Youth Network
Philadelphia PA
09.2011 - 01.2016
- Built, managed, and designed SQL Server 2008 R2 databases
- Conducted data mining of Oracle 11g databases using Toad 2.7
- Developed business analytics and business intelligence solutions using QlikView 11, SSRS, and SSAS reporting tools
- Created a star schema Data Warehouse using ETL methodologies
- Designed a QlikView dashboard to illustrate trends in student enrollment, placement, and payroll across time sheets, jobs, work sites, and contracts
- Ensured database tuning, disaster recovery, and maintenance of all database systems
- Possessed advanced knowledge of SQL, dynamic SQL, and scripting (including merge statements, triggers, stored procedures, views, UDFs, table data modeling, database/server security management, constraints, linked servers, and SQL transactions)
- Implemented database practices to meet data governance procedures and ISO standards
- Collaborated directly with the CIO and clients to gather functional, data, and business requirements
- Received formal training in QlikView 11 development, data modeling, data warehousing, and ETL processes
- Developed and monitored SQL Server jobs and tracked user and server activity using SSMS and SSIS automation tasks
- Deployed SSRS reports to provide parameterized canned reports to users.
Database Contractor
Philadelphia Youth Network
Philadelphia PA
06.2011 - 09.2011
- Contracted to provide database expertise and support for the Philadelphia Youth Network
- Collaborated with stakeholders to understand business requirements and design effective database solutions
- Managed and maintained Microsoft Access 2010 and SQL Server 2005 databases
- Ensured data integrity and security
- Supported stock and securities data management.
Database Developer
Bank of New York
King Of Prussia PA
09.2010 - 06.2011
- Designed, built, and managed databases using Microsoft Access 2010 and SQL Server 2005
- Focused on creating efficient and reliable systems
- Specialized in stock and securities data management.
SQL Database Application Developer
Dorman Products
Colmar PA
01.2010 - 09.2010
- Developed a database for creating design specifications for automotive parts
- Utilized SQL Server 2005 and Access 2010
- Played a key role in migrating legacy Access 97 databases to Access 2010 company-wide.
Senior Programmer/Contractor
University Physicians
Baltimore MD
02.2009 - 12.2009
- Developed SQL Server 2005 databases
- Managed outages, repairs, and prioritized reporting using a new Microsoft Access database project queue management system.
Database Application Developer
Title Resource Group
Washington D.C.
06.2007 - 06.2008
- Administered report request processes company-wide through the TRACE (Title Reporting Administration Cataloging Entity) database application initiative
- Provided consulting support to the Service Analytics Department
- Developed and administered dashboard applications in a Citrix Server environment.
Software Engineer/Consultant
Bearing Point
Washington DC
02.2006 - 06.2007
- Designed, developed, documented, tested, and implemented the Pre-E.R.P
- Procurement tracking and management system called PARTS (Procurement and Accounts Reporting and Tracking System) for the Navy’s NCIS organization
- Collaborated with stakeholders to ensure successful deployment
- Provided project management support in the Census Bureau’s Blade Server Migration Project Initiative.
Access Developer
Comdata Corporation
08.2000 - 02.2006
- Documented functional data requirements, business requirements, system design, user acceptance testing, deployment plan, user’s guide, and administration guide
- Supported end users within the organization by providing technical assistance, training, and database/application support using a ticketing system.
Education
High School Diploma -
05.1991
Skills
- ETL SQL Merge Functions Scripting
- SQL Server Instance Setup And Configuration
- DOS 60 And Some Powershell Development
- Enterprise Application Integration
- Optimization Techniques
- SQL Servers, Databases, Database Schemas, Functions Stored Procedures, Triggers And SQL Job Automation Design
- Software Development Life Cycle (SDLC)
- Microsoft Access Development
- Database Administration Experience
- Computer Server Management
- SSMS SQL Server Tools
- Business Intelligence Systems
- Data and Analytics
- Data Cleaning
- SQL Server ETL processes
- SSRS, Qlikview, Grafana, Power BI Reporting Tools
- Data Integrity Validation
- Microsoft Visio
- Jira Project, Stories, Epics & Scrum Management
- Technical Design Documentation
Timeline
Data Analyst - CMC Energy Services
11.2021 - 02.2024
Contract - Database Administrator/BI Developer - Beacon Hill Staffing Group, Inc. (For Southmill Champs Mushrooms, Inc.)
07.2021 - 09.2021
BI Developer - European Metal Recycling, Inc. (EMRgroup.com)
01.2019 - 08.2020
Database Administrator - American Association for Cancer Research (AACR.org)
01.2016 - 01.2019
Database Manager - Philadelphia Youth Network
09.2011 - 01.2016
Database Contractor - Philadelphia Youth Network
06.2011 - 09.2011
Database Developer - Bank of New York
09.2010 - 06.2011
SQL Database Application Developer - Dorman Products
01.2010 - 09.2010
Senior Programmer/Contractor - University Physicians
02.2009 - 12.2009
Database Application Developer - Title Resource Group
06.2007 - 06.2008
Software Engineer/Consultant - Bearing Point
02.2006 - 06.2007
Access Developer - Comdata Corporation
08.2000 - 02.2006
Chopticon High School - High School Diploma,