MICHAEL SECORD

(616) 284-1820 • michael@gizmokid2005.com • LinkedIn

SQL DEVELOPER
Analytical, detail-oriented business professional with demonstrated success in identifying, designing, and implementing internal process improvements and optimizing data delivery. Understands data flow, troubleshoots data issues and responds to requests for data in a timely manner. Knowledge of data integration, SQL programming, ETL and data warehouse concepts and processes. Key competencies:

  • SQL Server Developer
  • Data Sharing / Warehousing
  • Data Analysis
  • Quality / Continuous Improvement
  • Enterprise Software Implementation
  • Data Conversion
  • Project Implementations
  • Leadership / Training / Collaborator

EXPERIENCE
Epiq Systems, LLC -- Remote
Senior SQL Developer
02/2022 - Present
  • Developed and maintained ETL procedures according to client specifications and within defined technical standards.
  • Developed and maintained database stored procedures, user-defined functions, views, triggers, and other common database objects.
  • Wrote custom and ad-hoc SQL queries.
  • Used prescribed software development standards, processes, and procedures according to department policies and conventions.
  • Supported team as part of escalation path and as expert resource as needed to solve complex issues and requests.
Modis -- Remote
SQL Developer
12/2020 - 02/2022
  • Developed and maintained ETL procedures according to client specifications and within defined technical standards.
  • Developed and maintained database stored procedures, user-defined functions, views, triggers, and other common database objects.
  • Wrote custom and ad-hoc SQL queries.
  • Used prescribed software development standards, processes, and procedures according to department policies and conventions.
Boot Barn -- Irvine, CA
CRM Data Analyst
08/2018 – 06/2020
  • Responsible for managing direct mail lists, analyzing ROI, segmentation and making recommendations.
  • Performed as-needed on-going data analysis to support ad-hoc and standard business requests while maintaining data integrity.
  • Developed and maintained SQL infrastructure (tables, stored procedures, functions, views, indexes) to managed processes for reporting and analysis.
  • Managed ETL processes as needed for data sharing between services and systems for analysis and integration.
  • Worked to provide continuous improvement in CRM data quality and infrastructure.
Secord Labs -- Long Beach, CA
Owner
10/2016 - 08/2018
  • Served as part of the implementation and project teams, participating in client contact, configuration, data migration, development, professional services.
  • Participated in on-site analysis and trainings with clients; member of internal teams during the implementation process.
  • Assisted in creating/executing test plans for workflow and data validation.
  • Managed and created reports using in-house reporting tools & SQL queries in MSSQL.
  • Created ETL data migration plans and scripts to migrate from old systems & flat files to MSSQL databases utilizing SQL Server tools, Excel and CRUD methodologies as needed.
BKD, LLP -- Kansas City, MO
Senior Consultant
03/2015 - 10/2016
  • Worked closely with all project leads as well as the entire project team to ensure all deliverables were completed and delivered on time, in scope and in their entirety.
  • Assisted in creating/executing test plans for workflow and data validation.
  • Performed ETL operations on flat file extracted data, including cleansing and data mapping, implementing CRUD as needed via SQL Server tools, Excel, Access, and other tools.
  • Supported multiple concurrent implementations.
Crystal Flash -- Lowell, MI
SQL DBA
08/2014 - 02/2015
  • Managed SQL Server infrastructure, performance, and maintenance.
  • Created reports using in-house reporting tools & SQL queries in MSSQL.
  • Converted current Access databases/programs to MSSQL Server using ETL and CRUD methodologies utilizing SQL Server SSIS and import tools.
Rutherford & Associates -- Holland, MI
Business Support Analyst
11/2011 - 08/2014
  • Supported business-critical Route Accounting Software for diverse companies ranging from small pizza distributors to major beer/wine distributors and Coca-Cola bottlers.
  • Created reports using in-house reporting tools & SQL queries in MSSQL.
  • Performed data extraction, validation, and conversions utilizing ETL and CRUD processes using SQL Server built-in tools, Monarch Pro, Excel, Access and other tools as needed.
  • Conducted on-site and remote software training and support for both new and existing customers.
  • Trained internal employees on new software features.
  • Consultation on business processes relating to route accounting.
Summit Training Source -- Grand Rapids, MI
Technical Specialist/QA Specialist
06/2011 - 11/2011
  • Provided hardware and software support for internal users.
  • Supported internally-developed web application over the phone, by email & by remote assistance.
  • Assisted in creating QA guidelines and policies for ensuring consistent testing of software.
  • Designed and implemented automation of repetitive tasks leading to a 25% increase in efficiency.
  • Ran ad-hoc SQL scripts and queries to support clients, internal and external, as well as the internal development team.
The Iserv Company -- Grand Rapids, MI
IMS Assistant
03/2008 - 06/2011
  • Ensured integrity of data warehouse (Oracle DB) and SQL/ETL scripts/crons on a daily basis.
  • Performed monthly test billing & audit and monitored & completed monthly production billing.
  • Support data warehouse client application (Crystal Reports 7).
  • Created and ran various SQL queries and scripts.
Data Analyst
06/2007 - 03/2008
  • Performed analysis, cleansing, and loading (ETL) of acquired companies' billing systems upping efficiency in the process by 20%.
Customer Support
03/2006 - 01/2009
  • Efficiently handled billing/technical issues and internal order processing for new/existing customers.

PROFESSIONAL DEVELOPMENT
Accounting/CIS Courses completed. (Baker College)

TECHNICAL
T-SQL (Business Intelligence and ETL/CRUD operations in MSSQL, MySQL, Oracle & SQLite)
Web/web application development with HTML, CSS, & Ruby on Rails using SVN & GIT; shell scripting


Resume in PDF