Patrick Ramos Email & Phone Number

Fort Mill, SC, US

San Francisco, California, US

• Provides up-front data discovery and analytics supporting Deposits and Cards lines of business, as well as defining and implementing data strategies for new remediations.
• Creates and contributes to the development of analytic strategies to address multiple impact scenarios, working independently to resolve data across complicated data sources.
• Provide end-to-end ownership of analysis efforts including requirements development, code development, documentation, and validation.
• Collaborate and consult with peers, colleagues, and more experienced managers to resolve issues and achieve goals.
• Mentor or manage less experienced staff, interns, and external contractors.

San Francisco, California, US

• Wrote SQL for Quality Assurance Error Rate metric after partnering with stakeholders across multiple levels in the Consumer Bank. This reporting is directed to hundreds of personnel in branch banking leadership and.
• Corrected defects and added enhancements to multiple Tableau dashboards which enable and inform front line risk owners and First Line of Defense partners to understand their risk management effectiveness across a.
• Researched existing SAS code in order to decide which tables I need for a new SQL query for a campaign report which required the use of a recursive loop.

San Francisco, California, US

• Using SAS and SQL, improved an existing program to assist our Commercial Quality Assurance (QA) Vice Presidents to review quarterly samples of jobs analyzed by our Commercial Appraisers
• Gathered requirements from Commercial QA Vice Presidents to build status reporting in Tableau which serves 2 purposes: allows the team to track incomplete reviews from the sample, and provides details on those reviews.
• Created a Commercial QA results reporting package in Tableau which replaced a manual process and includes a more in depth analysis of error rates
• Wrote hundreds of lines of code using SQL to gather data needed for a newly developed business unit and then built a Tableau report for Valuation Managers containing follow-up items and KPIs in table, combo and map.
• For the Real Estate Valuation Services Analytics team, created Visual Basic macros to automate daily manual processes

Basking Ridge, NJ, US

• Became Subject Matter Expert for the Internet of Things products and the Business Solution Store by understanding end-to-end data flow, analyzing previous reporting and then finally wrote SQL in order to report on.
• Created Enterprise segment Balanced Scorecards using Teradata which contain overall risk/ranking of our wireless activity on key metrics to provide scoring on our Accounts, their Client Partners and their Managing.
• Created Public Sector segment Scorecards using SQL which contain key performance indicators and their vertical targets
• Built a “Like Day” dashboard using Tableau for our Directors and their Vice Presidents which shows current month sales vs the same month sales last year; also wrote SQL from our EDW (Enterprise Data Warehouse) to.
• Project-managed a database clean-up initiative which included leading a team of 5 over several months where we converted several line level tables to profile level tables
• Researched data anomalies in complex business systems, developed audit reports and provided recommendations for correction of data

Basking Ridge, NJ, US

• Produced in-depth analyses of rate/volume variances of the Strategic Partnership Channel (SPC) to identify root cause business drivers to management and partner with the SPC on development of presentations and analyses
• Supported the monthly close process which includes financial and operating statistics reporting and analysis for the Headquarters Customer Service organization, which is comprised of: Budget vs. Actual financial.

Basking Ridge, NJ, US

• Provided reporting support which includes mining for data in the data-warehouse using Teradata SQL Assistant and other company data sources as needed for assigned initiative or business request
• Performed trend analysis, drew conclusions, served as subject matter expert for the data reported and presented the data and conclusions in comprehensive and level-appropriate presentations to management
• Business case support included: evaluate opportunities and /or proposals made by the business to drive efficiencies, determine supporting information needed and sourcing it and perform thorough analysis

Basking Ridge, NJ, US

• Consolidated actuals from SAP and tracked Forecast against the budget on monthly basis using Microsoft Access
• Managed and tracked invoices against purchase orders and communicate any mismatches and funding issues

New York, NY, US

Master Of Science - Ms, Data Science

Master Of Business Administration, Finance

Bachelor Of Science, Finance And Management