Mark M. Email & Phone Number

Bozeman, Montana, US

California, 94086, US

San Jose, California, US

• Immediately uncovered database design flaws affecting data quality and reporting (as I was hired to). Eventually graduated to a new team. Learned a new and different environment for SQL and business intelligence by.
• Uncovered data quality issues on the newer Big Data platform from SQL Server, and communicated them to the data engineering party, along with a technical solution thereby eliminating roughly 90% of ETL failures both.
• Migrated reports from Microsoft SQL Server to a Hadoop Big Data backend using Looker (enterprise visualization tool learned on the spot) to literally code (JSON like pattern) dashboards and user interfaces saving.
• Helped in analyzing architectural proposals and offered design feedback
• Drove the standardization of key metrics across various business units to improve data governance, by naming of KPIs

New York, NY, US

• Through the use of data warehousing and T-SQL development (w/ SQL Server) Iengineered difficult to create financial calculations (dealing with trusts and IRS law). Here I engineered complex T-SQL code modules, and.
• Engineered multiple financial calculations through T-SQL coding on the SQL Server platform, including mentoring team members on Enterprise Data Warehouse (EDW) design best practices and techniques
• Initiated the documentation of deliverables and development using SharePoint
• Introduced to the team the use of SVN (versioning control) for enhanced team software development efforts, along with a workflow diagram for creating team builds
• Designed and built a robust database of deliverables that generates automatic schedules so as to enable department heads to connect here with self service reporting (regarding) a deliverables' status
• Implemented and mentored ETL and warehousing techniques along with team development best practices (revising the existing Systems Development Life Cycle (SDLC) for ETL), to the delight of the team and especially my.

Oakland, CA, US

Consultant engaged in projects to migrate data from legacy stove pipes to a consolidated master data source enterprise warehouse. This involves defining MDS naming standards and ETL development from the operational sources. Critical items addressed are schema design, identifying exisintg data duplication, data profiling, data sharpening, rules dealing with.

Joined a start up to help develop automated computer systems to help and/or replace manual tasks using the SQL Server and Business Intelligence Development Studio (BIDS) platform. This includes a robust automated monthly procedure for finance that calculates royalties based on business agreements in contracts (that are subject to change) joined to.

Roseland, New Jersey, US

Responsible for the day to day heavy reporting needs of the company. After replacing two people, I managed to effectively become familiar with and maintain an extensive production database system that had no documentation or expert knowledge outside of the former employees. This includes a huge operational data store (includes web data points), and the.

Volunteer

Mathematics, Economics

Certification, Management Information Systems