Dave Ramos Email & Phone Number

Irvine, California

Irvine, Ca

Irvine, Ca

Irvine, Ca

Rosemont, Illinois

Greater Nashville Area, Tn

Huntington Beach, Ca And Chicago, Illinois

Assisted client with management and execution of project involving migration of legacy SQL Server based reporting structure to Oracle/Business Objects XI structure.• Converted SQL Server stored procedure-based reports to Business Objects reports by translating legacy stored procedures to corresponding Business Objects universe queries.• Worked with business users to identify reporting requirements and business rules.• Provided ETL logic and rules for reporting fields not… Show more Assisted client with management and execution of project involving migration of legacy SQL Server based reporting structure to Oracle/Business Objects XI structure.• Converted SQL Server stored procedure-based reports to Business Objects reports by translating legacy stored procedures to corresponding Business Objects universe queries.• Worked with business users to identify reporting requirements and business rules.• Provided ETL logic and rules for reporting fields not currently in Data Warehouse.• Coordinated user acceptance testing efforts for reports. Show less

Used business knowledge and reporting/data management expertise to lead and develop projects supporting Triad’s Indirect Lending business.• Acted as Operations and Sales organization’s representative to company’s Enterprise Data Warehouse (EDW) team, acting in role to support company-wide effort to house all company data in one location. Provided business logic along with SQL code and source system mapping for all business metrics included within EDW.• Provided Operations… Show more Used business knowledge and reporting/data management expertise to lead and develop projects supporting Triad’s Indirect Lending business.• Acted as Operations and Sales organization’s representative to company’s Enterprise Data Warehouse (EDW) team, acting in role to support company-wide effort to house all company data in one location. Provided business logic along with SQL code and source system mapping for all business metrics included within EDW.• Provided Operations leadership team with analysis and recommendations to aid in management of $3.2 billion portfolio.• Implemented ad hoc and scheduled reporting solutions to manage monthly originations totaling $100 million on average and improve efficiencies of business.• Developed Incentive reporting tools and analysis to aid in allocation of $75,000 monthly incentive budget. Show less

• Responsible for development and tracking of sales incentive programs issue by MMNA to dealer body. • Analyze incentive plans against actual program performance to determine financial and market impact.• Analyze competitor incentive programs and report to management on MMNA’s current positioning and efficacy. • Manage and maintain incentives budget to ensure effective spending.• Work with credit company (MMCA) to ensure accurate subvention spending and program… Show more • Responsible for development and tracking of sales incentive programs issue by MMNA to dealer body. • Analyze incentive plans against actual program performance to determine financial and market impact.• Analyze competitor incentive programs and report to management on MMNA’s current positioning and efficacy. • Manage and maintain incentives budget to ensure effective spending.• Work with credit company (MMCA) to ensure accurate subvention spending and program development.• Provide incentive spending, product mix, and trend reports to senior management. Show less

Utilizing strong analytical skills and industry knowledge, priced and developed finance programs while assisting parent company in effective management of incentives budget. • Modified and maintained Excel-based pricing models used to determine rates and subvention pricing for consumer financial products (lease, conventional loan, and balloon loan). • Developed pricing model used in MMCA/HAF special APR programs that garnered $64.3 million in assets receivable per month.• Analyzed… Show more Utilizing strong analytical skills and industry knowledge, priced and developed finance programs while assisting parent company in effective management of incentives budget. • Modified and maintained Excel-based pricing models used to determine rates and subvention pricing for consumer financial products (lease, conventional loan, and balloon loan). • Developed pricing model used in MMCA/HAF special APR programs that garnered $64.3 million in assets receivable per month.• Analyzed competitor program offerings and reported to management on current MMCA program positioning. • Reported to senior management on impacts of pricing model assumption changes. Show less

Managed company’s communication efforts to Dealer body. Aided in implementation of key online communications initiatives, including revamped Extranet site and online Finance guides.• Created and distributed all written and online communications from MMCA to dealer body. • Developed MMCA marketing collateral material in collaboration with MMSA Marketing and ad agency. • Managed relationship with JD Power, Consumer Banker’s Association, and Association of Consumer Vehicle Lessors.… Show more Managed company’s communication efforts to Dealer body. Aided in implementation of key online communications initiatives, including revamped Extranet site and online Finance guides.• Created and distributed all written and online communications from MMCA to dealer body. • Developed MMCA marketing collateral material in collaboration with MMSA Marketing and ad agency. • Managed relationship with JD Power, Consumer Banker’s Association, and Association of Consumer Vehicle Lessors. Provided management with analysis of data provided by these companies.• Effectively managed $300,000+ marketing communications budget. Show less

Enhanced business acquisition by underwriting consumer loans and maintaining relationship with Dealer body.• Reviewed incoming retail, lease, and balloon credit applications for financing consideration by MMCA. Credit decisions resulted in $1 million assets receivable for MMCA daily. • Buying practices aided North Central region in maintaining lowest delinquency rate of company’s five regions.

• Reviewed incoming retail finance contracts for accuracy and completeness.• Assisted dealers in identifying and resolving funding deficiencies and held contracts.

Education record

B.A., Journalism

Activities and Societies: Western Courier (student newspaper) Sigma Nu Fraternity

Education record

Activities and Societies: Football, Basketball