Brian Kissler

Phoenix, Arizona · briankissler@gmail.com

I am a Senior Data Analyst who is adept at developing event-driven solutions to maintain real-time connectivity and data integrity between systems. Instrumental in executing various projects simultaneously and within strict timelines; ability to anticipate needs, multi-task, and prioritize duties efficiently and effectively. Able to quickly analyze empirical and anecdotal data to inform decision-making and organizational strategy development. Proactively develops constructive relationships with a broad group of stakeholders, experts, and corporate leaders to cultivate a cooperative climate to create unique, creative concepts that deliver strategic objectives. A firm believer that data-driven decisions drive the best decisions.

Visitors:

Experience

Data Lake - Area Product Owner - Information One

J.P Morgan Chase
  • Collaborate closely with Application Owners on the commitment of downstream applications to support Data Center Migration Verification pre-prod environment testing during the coordinated testing sync events.
  • Function effectively as the Information Owner for Info1(Oracle multi-tenant database) application, responsible for database role management through RSAM approvals to guarantee the proper controls for protection group classes complied with risk standards.
  • Spearheaded the development of testing plans, performed informational user sessions, documented and assisted in client tools/Kerberos authentication setup to confirm connectivity to the pre-prod/prod data center environment.
  • Prioritize four agile teams’ backlogs; utilize and assist application residing on Info1(Oracle multi-tenant database) on the decommission path or with low/no consumption to move another target database, archive the schema, or decommission entirely.
  • Successfully developed a Python script for large-scale table/data column value comparison between Info1 Production vs. Verification/Prod-Parallel database environments.
November 2020 - Current

Auto Data Delivery - Data Architect Manager

J.P Morgan Chase
  • Supported all data analytic needs, prioritized backlog and sprints using JIRA, and documented business definitions metadata by collecting data requirements from business partners.
  • Scoped and prioritized activities based on business and customer impact and provided hands-on leadership, methodology, structure, and information necessary to coordinate decision-making and development critically.
  • Worked closely, effectively, and harmoniously with Data Ecosystem IT partners to successfully design and develop dimensional data models for data analytics.
  • Interviewed users, conducted gap analysis, documented system of record to presentation layer mapping, identified business logic, and modeled required attributes.
  • Responsible for the effective and successful management of data migration of business users from legacy Oracle data schema to Teradata target state.
March 2019 - October 2020

Auto - Business Analysis Manager

J.P Morgan Chase
  • Managed Oracle database schema, developed and tested Oracle PL/SQL packages procedures/functions, managed change control using BitBucket, and communicated releases to the user community.
  • Proactively participated and contributed to project teams for origination system releases. Provided professional insight/ understanding of potential issues and advised actionable solutions.
  • Provided support and assistance to business partners by assembling requirements and leveraging Oracle Apex, Tableau, and Excel VBA to develop automated production reports.
February 2016 - February 2019

Home Lending - Data Warehouse Development Manager

J.P Morgan Chase
  • Recruited, developed, and managed the ETL and reporting (ICDW-Teradata and Info1-Oracle) development group through the use of Teradata, Informatica, PL/SQL, and Oracle Reports.
  • Ensured the group consisted of full-time and contract resources located nationwide and offshore to support a new mortgage origination system to support business intelligence.
  • Handled project and capacity planning, including forecasting, work estimations, collecting project scope documentation, outlining project timelines, and providing project status reports to the management team.
  • Employed Informatica to accurately design and develop load and transformation mappings, including Slowly Changing Dimension – Type 2 in Teradata (ICDW) layered architecture.
  • Actively participated in project teams, facilitated communication with business key stakeholders and analysts to gather and document requirements, negotiated timelines, and ensured complete data and report requirements were provided and captured.
  • Facilitated sessions with business users to socialize mortgage banking origination data warehouse model and provided level 1 support for user questions, ensuring all end-user documentation was maintained.
  • Performed in collaboration with data modelers on the design of complex dimension data models and developed business logic.
  • Utilized Oracle PL/SQL packages, procedures, and functions for batch loading in successfully designing and developing data transformation logic.
February 2012 - January 2016

Senior Staff, MIS

Charles Schwab
  • Spearheaded and managed multiple project teams in meeting with business stakeholders, gathering business requirements, and setting project timelines.
  • Successfully developed and maintained automated reporting using PL/SQL, SQL (Oracle and Teradata), Unix, and Business Objects.
  • Carefully analyzed existing data sources to identify gaps for enhanced reporting metrics.
  • Carried out code review exercises, confirmed coding standards were followed, recognized data integrity issues, and suggested changes for optimization.
May 2011 - February 2012

Home Lending - Report Development Group Manager

J.P. Morgan Chase
  • Took accountability for Home Lending production data and reporting to effectively support all operation sites, call centers, sales force, and executive management.
  • Responsible for managing incoming customer requests and issues and delegating to team members; managed, mentored, and conducted reviews for a team of eight developers.
  • Developed custom dynamic reports using Oracle Report Developer, SQL, PL/SQL, and Toad. Developed reporting user interface using Oracle APEX, ASP, HTML, JavaScript, and Delphi.
  • Established and maintained data structures, PL/SQL packages, procedures, and functions for a daily load of origination data in which business logic and reporting identifiers were applied. Consistently on-call to ensure service level was met.
  • Served as a vital resource in designing and implementing the conversion of an SAS and Actuate reporting infrastructure to Oracle database and Oracle Reports while ensuring data integrity.
  • Collaborated directly with internal customers on reporting and data requirements while providing guidance.
  • Contributed to project teams through active participation in origination system releases, provided insight on potential issues, and advised on possible solutions.
May 2011 - February 2012

Personal Projects

AWS Resume Challenge

This site is built and hosted on AWS using S3, Cloudfront, API Gateway, Lambda, DynomoDB and TerraForm. I started this project to gain hands-on experience with AWS as I worked toward my AWS Solutions Architect Certification.

GitHub Repo
Twitter Bot

This project utilized Python to capture sports game data from REST APIs from an ESPN endpoint and post a tweet for scores during games.

GitHub Repo

Skills

Core Competencies
  • Data Architecture
  • Workflow Coordination
  • Data Management
  • Planning & Implementation
  • Data Product Initiatives
  • Analytical Thinking
  • Compliance Analytics
  • Automation
  • Multitasking & Prioritizing
  • Strategic Planning
  • Cross-Functional Collaboration
  • Business Analysis
  • Data Integration Workflow

Programming Languages & Tools
  • Oracle, Teradata, PL/SQL, SQL
  • Python
  • /i> GitHub, GIT, Bitbucket
  • JavaScript
  • HTML
  • Tableau, Alteryx, Oracle Reports, Excel VBA/VBScript
  • Agile, JIRA
  • Confluence

Certifications

Education

ARIZONA STATE UNIVERSITY

Bachelor of Science
Bachelor of Science Computer Information Systems

Magna cum laude

December 1999

Military Service

United States Army

December 1993 - July 1996