John Rowan

John Rowan Email and Phone Number

Solving Business Problems with Data & Software Solutions @ RhemaTech Solutions
John Rowan's Location
Magnolia, Texas, United States, United States
John Rowan's Contact Details
About John Rowan

I have spent the last 22 years working heavily with data and software systems. I began my career as a software developer and worked primarily on data layer coding and data exchanges/interfaces between systems. I quickly moved into more data-centric roles and have made a long-lasting career in working with data. I have worked on very complex software systems, built BI solutions from the ground up, built dozens of multi-dimensional SSAS cubes, developed custom ETL frameworks, built numerous service broker messaging implementations, and worked building new databases or models for both OLTP and OLAP systems. I've built 100's if not 1000's of tables and certainly thousands of functions, stored procedures, views, etc and countless (really!) ETL packages using SSIS. The roles I've held for the last few years have been a bit less hands on, but not much. I've focused more on architecture, strategy, vision and team building. Most recently, I worked on and strategy and planning for migrating applications, services and data to Microsoft Azure as part of my previous employer's modernization efforts. I am a life-long studier and learner. Learning new languages and skills never gets old for me. I enjoy teaching, mentoring, and coaching those around me and I have always found myself in either formal or informal leadership positions. My strengths are data architecture and optimization, database code tuning and analysis and ETL process design and automation. I have ample experience in ETL with DTS and SSIS as well as SSAS for cube development. My experience with database development includes both OLTP and OLAP systems. I have played the role of lead architect for both types of systems and I have successfully created robust database designs that are currently in use by my workplaces past and present and their clients. My latest endeavor has given me the opportunity to begin building up my Microsoft Azure experience. On the app-dev side, the vast majority of my experience has been with .net, specifically C#. I am currently working heavily in API development w/ C# and front-end coding with React. My current venture takes me out on my own, partnering up with my wife of 22 years, to start our own consulting practice. My goal is to build new business relationships whereby I am able to offer my vast experience in software and data as an asset to my clients while I build out my practice and scale up my team.

John Rowan's Current Company Details
RhemaTech Solutions

Rhematech Solutions

View
Solving Business Problems with Data & Software Solutions
John Rowan Work Experience Details
  • Rhematech Solutions
    Managing Partner
    Rhematech Solutions Mar 2022 - Present
    Magnolia, Tx, Us
  • Exxonmobil
    Data Architect
    Exxonmobil Oct 2019 - Mar 2022
    Us
    I am currently working in ExxonMobil's Identity & Access Management (IAM) program as a System's Architect with a focus on data. My main responsibilities are to guide & mentor our team's in the area of database design, coding, optimization, ETL design and ELT optimization. I am also responsible for playing a lead role in our data modernization efforts as we migrate our on-premise systems to Microsoft Azure.
  • Xto Energy
    Supervisor Data & Analytics
    Xto Energy Feb 2019 - Oct 2019
    Midland, Texas, Us
    As supervisor of data & analytics at XTO, I was responsible for guiding and directing priority and direction for 3 analytics products as well as our MDM project and our data warehouse team. My job was to align these team's efforts with the business priorities for ExxonMobil's unconventional drilling & production operations.
  • Xto Energy
    Team Lead Analytics
    Xto Energy Dec 2017 - Feb 2019
    Midland, Texas, Us
    XTO converted me from a contractor to full-time employee. As part of this role, I remained engaged in much of my previous duties in addition to taking on team lead roles for XTO's Spotfire team. My role as team lead was to mentor & develop my team as well as organize their work and guide team priorities and direction.
  • Xto Energy
    Sr Bi Consultant (Matrix Resources)
    Xto Energy Apr 2015 - Dec 2017
    Midland, Texas, Us
    I was brought in to assist on an internally developed software product for managing XTO's identity and access management (IAM) program. My primary role was to design and develop ELT processes to discover IAM data across the organization. I worked as a SME for SSIS, ETL, and database design & optimization for the project team. I was one of 2 that XTO decided to keep after the project to continue supporting & enhancing the product.
  • Paypal
    Business Intelligence Architect
    Paypal Mar 2009 - Apr 2015
    San Jose, Ca, Us
    My primary responsibility has been to work with our analysts and statisticians to define data requirements and build out an analytics environment in SQL Server 2008. This robust environment consists of several models representing many different, but related, subject matters, 18+ very large fact tables, dozens of shared dimensions, and thousands of lines of stored procedure code. The environment supports 20+ analysts and their data needs. Some highlights from my time here:* Developed a Teradata-to-SQL Server interface using SQL Server's SSIS, Service Broker and Teradata's BTEQ and Fast Export utilitites. This utility and all of the automation objects that make it up supports our teams overnight batch processing. * All requirements gathering and integration/impact analysis.* ETL coding to transform the raw, staged Teradata tables into our analytics physical models.* SSAS cube design, development, deployment, and support.* Database administration, maintenance, optimization, index analysis, query tuning.* Support/Upgrade all SQL Server instances including database engine, SSIS, SSAS, and SSRS instances.* Mentor/coach analysts on SQL code tuning, optimization, and methodology.* Created several flat file extracts using SSIS to support file feeds to our statistical analysis tools.* Design views in support of SPSS ODBC access.
  • Rowan Business Group
    Database Consultant
    Rowan Business Group 2006 - 2013
    Designed, implemented and maintained ETL processes for InTouch’s data warehouse utilizing SQL Server SSIS and DTS technologies. Delivered database solutions to streamline, automate and improve operations and business processes.* Developed a database centered solution that automated the load, scrub, and propagation of client data to multiple production servers.* Developed 12+ automated DTS solutions for client data imports; designed an e-mail import interface into InTouch’s production databases to allow for real-time client inserting of critical data.
  • Wausau Financial Systems
    Lead Dba
    Wausau Financial Systems Oct 2005 - Mar 2009
    Wausau, Wi, Us
    Contributed to the development of new databases throughout the entire development lifecycle and resolved critical systems performance problems for high-profile customers. Designed database systems architecture, troubleshot database system performance, optimized SQL code and data access and conducted index analysis/ tuning and data modeling.* Assisted in the maintenance and administration of 100 databases; deployed database code across Wausau’s customer base and enforced data access.* Mentored development staff on database programming and development including industry best practices, guidelines and standards; ensured the team adhered to proper coding standards resulting in reduced performance issues. * Led the architecture and design of Wausau’s newest IntegraPAY Online product which is an archive warehouse designed using dimensional data modeling techniques with a star-schema approach utilizing SQL Server table partitioning and data compression to ensure optimal performance against fact tables containing up to 7 trillion rows.* Designed a database solution for Wausau’s Optima Duplicate Detect sub-system to provide high-speed importing of data and to asynchronously trigger a duplicate matching process on incoming rows. * Optimized database performance by as much as 90% by developing and implementing multiple improvements and performance solutions..
  • Fiserv
    Database Analyst / Application Systems Programmer
    Fiserv 2000 - 2005
    Milwaukee, Wisconsin, Us
    Monitored, maintained and troubleshot multiple production and development Oracle, Progress, and SQL Server databases. Acted as an administrator for multiple HP 9000/Sun Ultra 450 UNIX servers and FilNet systems and provided maintenance and security hardening on all HP and Sun servers. * Designed database and ETL process to integrate an Internet-facing application interface into Fiserv’s mortgage servicing system.* Performed several Oracle installations and upgrades and created and deployed multiple Progress databases.* Developed and implemented database schema changes for multiple development projects.* Wrote several UNIX shell scripts to maintain and automate UNIX and database administration tasks.Assisted in the design, development and maintenance of Fiserv’s UniFi PRO Mortgage loan origination system supporting the needs of Commercial Federal Bank’s multi-state mortgage lending operations and web clients.* Instrumental member in the analysis, redesign and integration of Fiserv’s PRO Link Plus broker/correspondent lender interface into the UniFi PRO system using XML messaging and Java message queues.* Developed numerous system changes, customizations and process improvements; created a process that delivered real-time automated underwriting, allowing mortgage loan officers to interface with Freddie Mac’s Loan Prospector system.

John Rowan Skills

Etl Ssrs Data Modeling Microsoft Sql Server Sql Ssis Databases Virtualization Database Design Linux Sql Tuning Requirements Analysis Teradata Requirements Gathering Business Intelligence Oracle Performance Tuning Olap Database Administration Unix Software Development Analysis Services

John Rowan Education Details

  • University Of Nebraska At Omaha
    University Of Nebraska At Omaha
    General Studies
  • Metropolitan Community College
    Metropolitan Community College
    Technical Computer Courses
  • Bellevue University
    Bellevue University
    Mis

Frequently Asked Questions about John Rowan

What company does John Rowan work for?

John Rowan works for Rhematech Solutions

What is John Rowan's role at the current company?

John Rowan's current role is Solving Business Problems with Data & Software Solutions.

What is John Rowan's email address?

John Rowan's email address is jr****@****ail.com

What is John Rowan's direct phone number?

John Rowan's direct phone number is +140232*****

What schools did John Rowan attend?

John Rowan attended University Of Nebraska At Omaha, Metropolitan Community College, Bellevue University.

What skills is John Rowan known for?

John Rowan has skills like Etl, Ssrs, Data Modeling, Microsoft Sql Server, Sql, Ssis, Databases, Virtualization, Database Design, Linux, Sql Tuning, Requirements Analysis.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.