Ryan Mccauley

Ryan Mccauley Email and Phone Number

Senior Data Architect at American Express @ American Express
Ryan Mccauley's Location
Peoria, Arizona, United States, United States
Ryan Mccauley's Contact Details
About Ryan Mccauley

I enjoy taking care of data at every stage - making sure it's safe at rest; stable, available, and quick when it's needed; makes sense when it's retrieved and presented; and can be trended and aggregated to help the company make better decisions. I currently manage the team that's responsible for taking care of our database infrastructure and managing the reporting platform and data presentation.Specialties: SQL Server database development, Data stability, Database high availability/disaster recovery, Designing/Scoping software projects, Software lifecycles, Business impact analysis

Ryan Mccauley's Current Company Details
American Express

American Express

View
Senior Data Architect at American Express
Ryan Mccauley Work Experience Details
  • American Express
    Senior Data Architect
    American Express Jun 2019 - Present
    New York, Ny, Us
    - Design and use Python to create three-way data synchronization process between big data systems, reporting databases, and user input tools- Collect requirements, develop data models, and create BI reporting in Tableau and Power BI with executive visibility- Find and explore available datasets, integrating into new and existing reporting models as needed- Investigate and integrate new technologies to support data synchronization and reporting
  • Cable One
    Enterprise Analytics Manager
    Cable One May 2017 - Jun 2019
    Phoenix, Az, Us
    - Manage 3 data analysts and 4 data engineers to form dedicated Business Intelligence team, moving company from report management to a new Data Analysis center of excellence- Develop standards and ensure that enterprise reporting tools and visualizations are clear and effective- Create a monthly executive reporting package containing in-depth data analysis to identify customer trends/behavior and evaluate effectiveness of current offers/strategies- Make appropriate recommendations for business based on results of data analysis and output of enterprise reporting tools- Work with business to define appropriate KPIs for projects and ensure they can be captured and measured effectively- Develop data analyst team with appropriate training, mentoring, collaboration, and work assignment
  • Cable One
    Data Management And Reporting Manager
    Cable One Oct 2011 - May 2017
    Phoenix, Az, Us
    - Implement, transition production data to, and maintain multiple SQL Server Failover Clusters- Oversee and maintain critical data replication and warehousing of customer billing data- Design database operations for minimal downtime and ensure business continuity in the event of database failure- Coordinate projects and manage team of DBAs (both SQL Server and Oracle) and report design/development (both Crystal Reports and SQL Server Reporting Services)- Used knowledge of operations and data under management to design numerous reports clarifying customer behaviors and identifying opportunities to lower customer contacts and payment cost- Oversee and promote data warehousing and business intelligence initiatives- Design and manage data warehouses based on extensive OLTP databases under management- Assist in daily administration of SQL Server databases where necessary, including performance tuning and troubleshooting
  • Cable One
    Lead Programmer/Analyst
    Cable One Aug 2009 - Oct 2011
    Phoenix, Az, Us
    - Design high-availability data strategy using a mix of failover clustering and data replication- Implement, transition production data to, and maintain multiple SQL Server Failover Clusters- Oversee and maintain critical data replication of customer billing data- Help design and implement plan to create test lab with staged copies of production data, and promote changes into production from lab- Act as escalation point for IT Development group during after-hours critical issues- Train and mentor developers across teams- Coordinate projects and day-to-day efforts of others with DBA responsibilities, as well as consultant assigned to BI projects- Oversaw transition to new payment processor and designed all associated IT processes to support transition- Used knowledge of operations and data under management to design numerous reports clarifying customer behaviors and identifying opportunities to lower customer contacts and payment cost- Design data warehouses based on extensive OLTP databases under management- Anticipate business owner needs and proactively produced analytics reports and key indicators to multiple processes in advance of user requests- Assist in limited management of Oracle servers
  • Cable One
    Programmer/Analyst
    Cable One Jul 2005 - Aug 2009
    Phoenix, Az, Us
    I'm a software developer and database administrator for Cable One. I develop in Visual Studio .NET, and deal mostly with Microsoft products (SQL Server, BizTalk, etc). I'm also involved in system design and architecture, and spend most of my time designing and implementing software solutions.
  • Peter Piper, Inc.
    Business Systems Engineer
    Peter Piper, Inc. Jun 2003 - Jul 2005
    Phoenix, Arizona, Us
    Software designer and developer, using Visual Studio .NET and SQL Server.
  • Northern Arizona University
    Business Systems Engineer
    Northern Arizona University May 2001 - Dec 2002
    Flagstaff, Arizona, Us
    Database administrator - designed and maintained resident management database for on-campus housing

Ryan Mccauley Skills

Databases Microsoft Sql Server Business Intelligence Ssrs Troubleshooting Sql Crystal Reports Management .net T Sql Sdlc Visual Studio Servers Business Analysis Visual Basic Integration Testing Sharepoint Analytics Access Software Documentation Iis Agile Methodologies Visio Windows Server Requirements Analysis Requirements Gathering Sql Server Data Analysis Ssis Sql Server Reporting Services Business Impact Analysis Sql Server Failover Clustering Windows Clustering Data Warehousing Oracle

Ryan Mccauley Education Details

  • W. P. Carey School Of Business – Arizona State University
    W. P. Carey School Of Business – Arizona State University
    Business
  • Northern Arizona University-The W. A. Franke College Of Business
    Northern Arizona University-The W. A. Franke College Of Business
    Computer Information Systems

Frequently Asked Questions about Ryan Mccauley

What company does Ryan Mccauley work for?

Ryan Mccauley works for American Express

What is Ryan Mccauley's role at the current company?

Ryan Mccauley's current role is Senior Data Architect at American Express.

What is Ryan Mccauley's email address?

Ryan Mccauley's email address is ry****@****ley.com

What is Ryan Mccauley's direct phone number?

Ryan Mccauley's direct phone number is +160236*****

What schools did Ryan Mccauley attend?

Ryan Mccauley attended W. P. Carey School Of Business – Arizona State University, Northern Arizona University-The W. A. Franke College Of Business.

What skills is Ryan Mccauley known for?

Ryan Mccauley has skills like Databases, Microsoft Sql Server, Business Intelligence, Ssrs, Troubleshooting, Sql, Crystal Reports, Management, .net, T Sql, Sdlc, Visual Studio.

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.