Mark Janecek

About Mark Janecek

Experienced Data Analyst with multiple years in 3 different industries both in the Public and Private sectors. Advanced SQL, MS Excel and Access, Pivot Table and Chart Creation knowledge. Working knowledge of Power Query and Power Pivot to synthesize data from multiple sources and analyze it with a Power Pivot table using the Excel Data Model Functionality. TRANSPORTATION | BANKINGEmail: d•••••@gmail.comProven ability to thrive while moving from one industry to another. Proven ability to learn new systems and technologies while on the job. Advanced ability to extract, analyze and validate large multi-faceted data sets using SQL in a Postgres Data Warehouse. Proven ability to perform front end research on support issues, determine the cause and the solution and escalate to Operations Manager and/or System Architect when appropriate.Demonstrated high level of Integrity. I was given Write Access to the Production Database after being employed at iStream for a year. Willingness to share knowledge by training other employees on critical platform processes.CORE COMPETENCIES: Analytical Abilities Technical Knowledge Report and Query Optimization Team Leadership Human Relations High Integrity Dependability Willingness to learn Technical WritingRELEVANT RECENT ACCOMPLISHMENTS:Re staged and simulated file production that had occurred on a Monday evening in a test environment prior to our Database Conversion to the AWS Cloud. Did all of that with SQL.Published multiple technical documents on the Company wiki concerning database flow of Check and ACH Item Processing and other critical functions.Built MS Excel Dashboard with dynamic charts and tables summarizing the entire transaction processing history of iStream.I\'m looking for a role that weights heavier on BI than Database Reporting, but will do both. Please contact me at 26••••••79 with opportunities of this nature.

Experience

1. Business Intelligence Analyst

   Amwins

   Sep 2022 — Present · Charlotte, NC, US

Education

• Milwaukee Area Technical College

  Visual Basic Programming

  2000 — 2002

• University of Wisconsin-Milwaukee

  BA, Geography / Geographic Info Systems

  1992 — 1997

Skills

• Supervisory Skills
• Advanced Ms Excel
• Vba
• Microstation
• Advanced User of Arcgis
• Process Improvement
• Project Management
• Databases
• Intermediate Power Point
• Testing
• Microsoft Excel
• Data Analysis
• Access
• Gis
• Sql
• Ssrs
• Beginning Ms Reporting Services
• Intermediate Vba Programming
• Intermediate Sql Query Writer
• Advanced Ms Access
• Customer Service
• Business Process Improvement
• Microsoft Office
• Leadership
• Management
• Project Planning