Ryan Snyder Email & Phone Number

Denver, Colorado, United States

Aurora, Co, United States

Aurora, Colorado

Working in Reporting & Analytics at Wells Fargo. Recognized as an expert and visionary in providing strategic business solutions to enterprise-wide technology initiatives. Acts as a liaison between client area and technical organization by planning, conducting, and directing the analysis of the most complex, strategic, corporate-wide business problems to be solved with automated systems.Provides technical expertise in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements. Applies knowledge of industry trends and technology to drive organizational change and position Wells Fargo for the future. Works with user groups to provide training, resolve questions, assess user needs, and recommend changes. Participates in transforming strategic enterprise architecture and design principles into specific system requirements and specifications. Recommends and initiates systems testing. Acts as the highest-level internal consultant within technology and business groups by re-engineering technical processes for greater efficiencies with significant impact to the business. Directs and serves as a mentor to less experienced staff.

Signature Consultants Charlotte, North Carolina (Wells Fargo & Co)Consultant - Database Analyst 6 & Reporting Developer/Architect• Design and develop database tracking and reporting for quarterly data lineage attestation. Enable timely and accurate reporting of required and regulated processes. • Design and develop management reporting for multiple large scale projects to communicate status and progress to management and leadership stakeholders. Expand requirements as requested and needed, to meet leadership demands and requests for more detail.• Design and develop a database to store data lineage data that is currently housed in excel documents. Develop and refine the code that enabled the loading of the data from excel to the database. Develop and enhance the code to “stitch” the data together to articulate an end to end process flow from the data lineage.• Review and provide requirements and feedback during the development of the Wholesale Integrated Metadata Platform (IMP), identifying critical requirements and opportunities for improvement.• Developing a data lineage tracker to streamline the QA process and provide reporting around SLA’s within Wells Fargo & Co.

Aurora, Co

• Use Teradata SQL to maintain the entire Medical analysis including all dashboards and scorecards for each area VP to present to National. I setup these reports to show the key metrics and also show historical trends for each specialty over time, so they can setup staffing and understand the expected volume for upcoming months.• Automate and create batches to speed up the process of SQL reports and enable more automation of reporting in the area. With the automation, our group gained efficiency to take on more operational reports and help to drive organizational efficiency and provide our members a better experience during visits.• Gather requirements for dashboard and other reporting and involve key stakeholders to ensure all of the needs were met.• Create documentation on reports and dashboards to ensure others would know how reports were built and the sources of data were clearly defined along with any metrics being reported.• Use SQL to build complex reports joining multiple databases and data sources to summarize and report as needed.• Leading the implementation of Cognos 10.2 to streamline our reporting and help leverage newer technologies for reporting and executive dashboards. • The increase of efficiency of reporting went from 3 individuals down to myself creating a large savings for the non-profit. It also enabled our area to use our standardized process in other specialties thus providing them more insight into what type of members were coming in and how best to serve them within our clinics.

Aurora, Colorado

• Developed multiple Microsoft Access databases to automate BCT processes; this helped eliminate 80% of an FTE and was part of the reason for a nomination for the Eagle Award in 2013-2014. Taking codes that were two to four characters long and translating them into verbiage that would be fed into the contracts with the members. • Developed a zip code database to extract data from USPS files and took data against our regulatory requirements to determine if the new zip code was part of our service area or outside of our service area. This process was critical during DOI audits as well as enabling us to capture new members in zip codes that were new to our organization.• Gathered requirements for dashboard and other reporting and involved key stakeholders to ensure all of the needs were met.• Created documentation on reports and dashboards to ensure others would know how reports were built and the sources of data were clearly defined along with any metrics being reported.• Used SQL to build complex reports joining multiple databases and data sources to summarize and report as needed. • Managed the task of getting all of the regions EOC’s in a standardized format and also rearranged them to meet new DOI requirements for each book. These contracts were critical to Kaiser as they were the agreement between the member and Kaiser Permanente.• Assisted managers and coworkers with data pull from CM using SQL to enable them to isolate and identify groups and members who potentially needed mailings due to incorrect EOC’s sent in 2012.

Englewood, Colorado

• Developed and implemented macro processes and tracking databases.• Created databases to track all configuration changes made to the billing system and to expedite audit processes on system modifications.• Gathered requirements for dashboard and other reporting and involved key stakeholders to ensure all of the needs were met.• Created documentation on reports and dashboards to ensure others would know how reports were built and the sources of data were clearly defined along with any metrics being reported.• Used SQL to build complex reports joining multiple databases and data sources to summarize and report as needed.• Led requirement gathering and documentation for the billing system conversion, so all other departments would know when configurations would be implemented so they could maintain fringe system stability during the billing system conversion.• Produced a defect ticket database and built multiple custom reports which enabled users to track the status of fixes and report issues with the billing system migration during the transition to the new billing platform.

Englewood, Colorado

• Managed reporting and metric reporting for regional management.• Gathered requirements for dashboard and other reporting and involved key stakeholders to ensure all of the needs were met.• Created documentation on reports and dashboards to ensure others would know how reports were built and the sources of data were clearly defined along with any metrics being reported.• Used SQL to build complex reports joining multiple databases and data sources to summarize and report as needed.• Created and developed commission models and forecasting models used to set monthly quotas.• Developed databases to manage reporting for daily analysis by senior management.• Compiled and analyzed data for corporate level reviews of the business and of all sales channels.• Used Business Objects to create production dashboards for C level executives, along with daily sales tracking reports built in Business Objects for frontline staff to know where they were in sales volume in the month.• Created Ad-hoc Business Objects reports around iPhone launches and sales by location along with other major reports.

Denver, Colorado

• Managed and compiled the monthly revenue analysis and prepared revenue notes for division conversations.• Built revenue models to gain insight into drivers of positive and negative revenue shifts.• Worked with all areas of Colorado region to assist in forecasting and budgeting.• Created databases to manage daily data, which output to pivot tables for a day- to- day view of the business.• Facilitated the expense and accrual process with the Marketing team to ensure accurate data.• Developed tools and resources used for the Senior Leadership Team and assisted them in the decision making process.• Assisted and trained New Mexico Financial Manager and Senior Director, how to leverage models during forecasting and budgeting periods.• Gathered requirements for dashboard and other reporting and involved key stakeholders to ensure all of the needs were met.• Created documentation on reports and dashboards to ensure others would know how reports were built and the sources of data were clearly defined along with any metrics being reported.• Used SQL to build complex reports joining multiple databases and data sources to summarize and report as needed.• Created ad hoc reports for Senior Financial Director and Senior Vice- President of Business Operations to evaluate business trends and changes.• Used Essbase daily during budget season to pull actual, budget, and forecast for P&L.• Monthly forecasts built out in models and loaded using Essbase• Created monthly Actual vs. Budget and Actual vs. Forecast using Essbase templates I designed to highlight overspend and under spend.

Denver, Colorado

• Analyzed and manipulated data to present it in a clear and concise manner.• Managed the data and reporting associated with strategic internal credit score moves.• Facilitated the completion and the migration of the Exception Report on a daily basis.• Gathered requirements for dashboard and other reporting and involved key stakeholders to ensure all of the needs were met.• Used SQL to build complex reports joining multiple databases and data sources to summarize and report as needed.• Worked with Supervisors and Managers in resolving Risk/Credit issues associated with their departments.• Streamlined data acquisition with the use of Microsoft Access to create logically summarized reports.

Greater Denver Area

• Provided statistical analysis and compiled reports for owners of companies such as freight analysis and dollars in pieces by warehouse utilizing Microsoft Excel.• Controlled collection activities.• Managed all activities associated with accounts payable.• Managed all activities for accounts receivable with approximately $30 million a year in sales.• Negotiated payment plans with customers and negotiated credit card processing fees with our vendor.• Determined billing for all customers including Electronic Data Interchange (EDI).• Directed EDI mapping and configuration while testing with trade partners.• Gathered requirements for dashboard and other reporting and involved key stakeholders to ensure all of the needs were met.• Used SQL to build complex reports joining multiple databases and data sources to summarize and report as needed.

Bsba, Business Administration And Management, General, 3.7

BSBA in Business Management with a minor in Finance

Business Management And Finance

High School/Secondary Diplomas And Certificates

Activities and Societies: Golf, Baseball & Skiing