John Rowan Email and Phone Number
John Rowan work email
- Valid
- Valid
- Valid
John Rowan personal email
- Valid
John Rowan phone numbers
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.
-
Managing PartnerRhematech Solutions Mar 2022 - PresentMagnolia, Tx, Us -
Data ArchitectExxonmobil Oct 2019 - Mar 2022UsI 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. -
Supervisor Data & AnalyticsXto Energy Feb 2019 - Oct 2019Midland, Texas, UsAs 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. -
Team Lead AnalyticsXto Energy Dec 2017 - Feb 2019Midland, Texas, UsXTO 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. -
Sr Bi Consultant (Matrix Resources)Xto Energy Apr 2015 - Dec 2017Midland, Texas, UsI 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. -
Business Intelligence ArchitectPaypal Mar 2009 - Apr 2015San Jose, Ca, UsMy 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. -
Database ConsultantRowan Business Group 2006 - 2013Designed, 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.
-
Lead DbaWausau Financial Systems Oct 2005 - Mar 2009Wausau, Wi, UsContributed 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.. -
Database Analyst / Application Systems ProgrammerFiserv 2000 - 2005Milwaukee, Wisconsin, UsMonitored, 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
John Rowan Education Details
-
University Of Nebraska At OmahaGeneral Studies -
Metropolitan Community CollegeTechnical Computer Courses -
Bellevue UniversityMis
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial