John Quintana Email & Phone Number

Denver, Co, Us

𝐂𝐡𝐚𝐫𝐭𝐞𝐫 𝐂𝐨𝐦𝐦𝐮𝐧𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬:• Spearheaded product development and migration initiatives to enhance customers' decision-making capabilities, reducing dataset delivery time by 93%.• Developed and implemented SQL Server stored procedures, bridging cross-team communication gaps and fostering a collaborative environment across departments.• Partnered with internal teams to understand and address customer needs, delivering effective data solutions through advanced SQL development and optimization.• Delivered scalable technical solutions aligned with PMO customer requirements, addressing constraints and ensuring alignment between business needs and data capabilities.• Conducted thorough data audits to identify and correct inconsistencies, resulting in a 90%+ improvement in data accuracy and enhancing internal data trust.𝐍𝐮𝐕𝐢𝐞𝐰 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬:• Developed and delivered executive decision-making dashboards for workforce management, leveraging SQL and Tableau to meet enterprise-wide requirements.• Documented and understood complex requirements, ensuring alignment between business needs and technical solutions.𝐆𝐞𝐧𝐰𝐨𝐫𝐭𝐡 𝐅𝐢𝐧𝐚𝐧𝐜𝐢𝐚𝐥:• Automated third-party data ingestion through new SQL development and process optimization, reducing manual effort by approximately 75%.• Provided fresh data solutions to internal teams, enhancing data accessibility and streamlining workflows.𝐁𝐨𝐬𝐜𝐡:• Created SQL queries to integrate external and internal datasets, maintaining a consistent Forecast vs. Delivery delta with less than a 9% variance month over month.• Supported internal customers with accurate and timely data analytics, enabling informed decision-making.𝐅𝐞𝐝𝐞𝐫𝐚𝐥 𝐑𝐞𝐬𝐞𝐫𝐯𝐞:• Facilitated data validation and developed 'Score Card' reporting post-datamart completion, identifying and rectifying data gaps across branches for national datamart integration.• Ensured data integrity and consistency in national reporting.

Mclean, Va, Us

• Led migration of debt settlement LOB from Teradata to Snowflake, resulting in a 300%+ revenue increase YTD.• Managed daily customer data intake, reducing turnaround time for settlement offer letters by an average of 97%.• Automated manual processes, cutting offer processing time by 80%.• Modernized platform to eliminate manual steps allowing for an increase in phone agent productivity.• Developed and optimized SQL queries for ETL enhancing accuracy while decreasing runtimes by 57%-98%.• Created a user-friendly central data repository for efficient customer and settlement inquiries.• Collaborated with business units to design and develop metrics and dashboards.• Acted as a liaison between tech and business teams, ensuring seamless delivery and meeting sprint deadlines.• Facilitated clear communication between tech and business to achieve project goals and improve reporting.

Philadelphia, Pa, Us

• With Tableau development and data manipulation using SQL, delivered the ability for leadership to more clearly and accurately analyze revenue and pacing models for company merger increasing post-merger revenue by ~63%.• Developed and managed sales performance reporting dashboards, allowing for sales to achieve a consistent 2-3% monthly revenue increase across markets.• Developed and optimized ETLs housed in Alteryx workflows and SQL queries, enhancing reporting accuracy and business insights.• Through data deep dives and trend analysis using SQL, Alteryx, and Tableau, generated business reports and recommendations based on forecasted and historical financial data.

Carlsbad, Ca, Us

• Developed, automated, and maintained Tableau dashboards for subscriber and revenue data, enhancing executive decision-making and reducing forecast delivery time by 82%.• Through in-depth data analysis using SQL and Alteryx processes, developed and delivered churn reduction model resulting in an average 35% reduction month over month.• Optimized ETL processes, ensuring accurate and error-free subscriber and payment data reporting.• Through SQL development and Alteryx workflow construction, cleaned and blended diverse data sources for comprehensive reporting, supporting various business initiatives.

Indianapolis, In, Us

• Calculate, monitor and maintain profitable margins in affiliate channel.• Generate and deliver monthly performance reports outlining affiliate revenue, cost of marketing, coupon redemption and profitability.• Coordinate and mange all affiliate publisher placements.• Monitor and maintain Finish Line brand image and voice as a premium retailer in affiliate channel.• Manage overall relationship with agency and publishers.• Communicate and meet creative needs for sales and promotions.• Monitor and optimize daily web and sales performance using LinkShare and Omniture.

Tel Aviv, Il

• Upload marketing campaigns through custom and third party programs.• Implement, optimize and maintain accurate campaign and conversion tracking.• Troubleshoot and solve campaign tracking issues, and communicate to advertisers and affiliate publishers. • Generate, place and troubleshoot tracking pixels for advertisers and affiliate publishers.• Create, edit and optimize HTML for email creatives.• Analyze campaign profitability and ROI to advertisers and publishers.

Denver, Colorado, Us

• Consult small business and franchise owners on marketing decisions for the growth of their company.• Assist clients with identifying markets to penetrate and grow in.• Manage, maintain and adapt current online marketing resources.• Utilize quantitative decision-making skills to make most profitable recommendations.• Build and optimize paid search campaigns.