Mark Rea Email & Phone Number

Brentwood, Tennessee, US

• Participate in transition from on premises SQL Server based data warehouse to Azure cloud-based data warehouse. Write SQL and T-SQL code. Maintain and enhance database objects including SSIS packages.
• Analyze and transform data for business users
• Learning Azure Data Factory in preparation for migration to cloud-based Azure data warehouse.

Indianapolis, Indiana, US

• Delivered strategy for data architecture for 3 new mobile applications. Administered SQL Server instance housing data supporting mobile application for animal healthcare.
• Enabled development of analytics featured in mobile pet health applications by creating cloud-based data repository.
• Contributed to machine learning strategy and programming relative to consuming short video clips of pet behavior and translating those into known health problems for animals related to the behavior captured in the.
• Mentored team comprised of only interns that had little-to-no professional experience, offering consulting and evaluating status of projects, and collaborating to modify approach or intended solution / method to devise.

• Developed analytic mechanisms for WatchGuard staff to glean insights from video metadata uploaded by law enforcement agency clients' body and dash cameras.
• Created Entity Relationship Diagram (ERD) and internal Wiki pages to document software systems and improve system knowledge of both new and long-tenured employees, generating quicker ways to answer questions through.

• Supported wife’s international posting, living in Europe with inability to work due to visa restrictions.

Hanover, MD, US

• Administered SQL Server database instance for CRM department used for ad-hoc ETL and data analysis. Performed ETL and conducted data investigation using data from vendor and internal data sources.
• Improved closed trouble ticket percentage by more than 50% after training customer service staff and explaining basic functions of CRM system.

Chicago, IL, US

• Administered SQL Server 2008 databases that supported variety of insurance sales, enrollment, and renewal systems and developed T-SQL code in support of websites for insurance sales.
• Developed and enhanced SSIS packages used to catalog development, testing, and production database for configuration management.
• Reduced failed deployment percentage from 70% to 10% for system assigned by replacing previous coder and using a more detail-focused and careful approach.

Hanover, MD, US

• Supported and enhanced vendor-purchased software as well as SSIS packages within vendor-purchased software.
• Wrote PL / SQL and T-SQL code that enhanced purchased vendor software by providing functionality that was missing from software but not addressed in vendor’s offering.
• Gained extensive knowledge of Crystal Reports and SQL Server after being self-teaching to enhance skills.

New York City, NY, US

• Facilitated ETL of client-delivered data by providing SQL and PL / SQL programming and data analysis for web-based predictive analytics software.
• Performed production application support and troubleshot production issues. Directed work activities of contractor and junior staff and mentored on policies, procedures, and development methodology.
• Served as junior member of team that recovered from losing 25% of data in primary production database for largest product offering of company.

Master Of Science - Ms, Data Analytics

Mba, Marketing Management

Bachelor Of Science - Bs, Commerce