Mark Bock
Phoenix,AZ
Summary
Strategic Information Technology Manager skilled in guiding navigation of modern technology. Accustomed to driving efficiency and effectiveness by developing, delivering and supporting strategic plans. Demonstrated skill in translating technical requirements to business solutions. Successful 20+ year record of building positive relationships with internal and external stakeholders.
Overview
22
22
years of professional experience
Work History
Information Technology, I.T. Manager – Cloud Services
Fujifilm
Mesa, AZ
06.2022 - Current
- Senior manager for the Data Analytics tranche of the $700M Merger & Acquisition of KMG Materials. Managed two separate consulting teams for a successful transition of the KMG servers, reports, ELT processes, & data.
- Mentored .Net developers on coding practices, deployments, and the SDLC. Gave guidance in the development of an app that helped the labs streamline their antiquated processes.
- Worked closely with the CFO gathering requirements and developing the monthly Expense PowerBI Dashboard for Finance.
- Corrected Fujifilm’s Active Directory reporting hierarchy and employee data utilizing LDAP, SQL, & PowerShell for over 1,000 employees.
- Owner of two dozen Azure and on-prem SQL Servers. Responsible for backups, cluster failovers, & data integrity.
- Originated and centralized Fujifilm’s Power BI environment with department workspaces & Azure security groups.
- Worked with consultants to draft Statement of Works, Request for Quotations, & Capital Acquisition Requests.
- Managed the upgrade for outdated Linux Red hat Operating Systems for Dev, UAT, & Prod to the most recent versions.
Security Benefit Corporation, Data Warehouse Engineer
System One Consulting, Inc.
Phoenix, AZ
01.2022 - 06.2022
- Developed several TimeXtender ETL processes for the various Lines of Business. This entailed creating and testing the table loads in the lower environments and pushing them to the upper environments after the data was approved.
- Created over a dozen SSIS packages for the Pricing and Performance project for the Quality Assurance team so that the data could be tested and reconciled.
Global Applications, I.T. Architect
Carlisle Companies Incorporated
Scottsdale, AZ
01.2020 - 12.2021
- Worked closely with consultants to develop the Financial Data Lake in Azure to report on CIT, CSL, & CBF divisions.
- Set up daily Pipelines to pull in data from multiple database systems with Logic Apps email notifications.
- The different source systems that we pulled from were SAP, SAP by Design, B1, BAAN, King Dee, SAGE, Expendables, M2M, Epicor, & IQMS. The data included General Ledger, Cost Centers, Company Codes, Products, Profit Centers, & Accounts for all the different factories for Carlisle Interconnect Technologies.
- Created an ADP fact constellation cube for Business Analysts to create BI reports.
Platforms and Applications, Programmer Analyst II
Sprouts Farmers Market Corporate
Desert Ridge, AZ
11.2018 - 11.2019
- Developer for the Inventory Roll process in SSIS and SSRS. The process monitored variances in gross sales, labor costs, and shrink losses within a selectable inventory period for all stores nationwide.
Wells Fargo, Business Systems Consultant
Apex Consulting
Phoenix, AZ
05.2018 - 11.2018
- Developed the remediation process for violation errors occurring on database servers for Wells Fargo in SSIS.
Global Technology & Operations, Vice President – Applications Programmer
Bank of America
Simi Valley, CA
02.2015 - 05.2018
- Project Manager for the Automation of Servicing FIV project for Flood Reporting. This was a major release that included updating/creating 24 iSeries and ALS tables. I was responsible for gathering requirements, creating test scripts, coordinating, and tracking testing of the developers, and submitting the test results. The project automated a major part of the flood waterfall LOB process.
- Created several Free Form SQL cubes in MicroStrategy and created a dozen reports from that cube for the Global SQL to Oracle transition project.
B.I. Manager
Short Sale/Deed in Lieu Reporting, VP
10.2012 - 02.2015
- Managed a team of six Business Intelligence Developers to automate the Short Sale/Deed in Lieu Reporting and ETL processes.
- Lead the team from 23% to 89% in report automation for over 300 reports in less than one year.
Process Design Consultant
Investor Relations Technical Group
09.2010 - 10.2012
Consultant – Database Admin & Analysis
MST Solutions Architecture
09.2008 - 09.2010
Business Systems Analyst II
Investor Accounting
07.2006 - 09.2008
Business Analyst I
Data Integrity
06.2004 - 07.2006
Education
High School Diploma - N.Y.
Cazenovia Central High
Meyers Briggs – INTJ
Volunteer – Angel Tree program
Salvation Army
01-2024
Green Belt, Six Sigma
01-2010
Honorable Discharge
United States Navy
01-2000
Delhi
Business Management, S.U.N.Y.
01-1997
Skills
- Mentoring Engineers
- Azure Architecture
- Azure Data Factory
- DevOps
- PBI Developer
- SQL Developer
- SSIS/SSRS/SSAS
- Data Modeling
- PowerShell
- C#, VB, ASPNET
- Six Sigma - Green Belt
- Oracle PL/SQL
- LDAP Query
- TimeXtender
- MicroStrategy
- Teradata
- Query 400
- ERP experience SAP Hana/ECC6
Timeline
Information Technology, I.T. Manager – Cloud Services
Fujifilm
06.2022 - Current
Security Benefit Corporation, Data Warehouse Engineer
System One Consulting, Inc.
01.2022 - 06.2022
Global Applications, I.T. Architect
Carlisle Companies Incorporated
01.2020 - 12.2021
Platforms and Applications, Programmer Analyst II
Sprouts Farmers Market Corporate
11.2018 - 11.2019
Wells Fargo, Business Systems Consultant
Apex Consulting
05.2018 - 11.2018
Global Technology & Operations, Vice President – Applications Programmer
Bank of America
02.2015 - 05.2018
B.I. Manager
Short Sale/Deed in Lieu Reporting, VP
10.2012 - 02.2015
Process Design Consultant
Investor Relations Technical Group
09.2010 - 10.2012
Consultant – Database Admin & Analysis
MST Solutions Architecture
09.2008 - 09.2010
Business Systems Analyst II
Investor Accounting
07.2006 - 09.2008
Business Analyst I
Data Integrity
06.2004 - 07.2006
Meyers Briggs – INTJ
Volunteer – Angel Tree program
Salvation Army
Green Belt, Six Sigma
Honorable Discharge
United States Navy
Delhi
Business Management, S.U.N.Y.
High School Diploma - N.Y.
Cazenovia Central High