Jose Harper

• Soaren is a financial technology company specializing in short-term loans, providing innovative lending solutions to consumers seeking quick and convenient access to funds.
• Soaren facilitates over $60 million in loans annually, serving a diverse customer base with flexible borrowing options tailored to their financial needs.
• I was responsible for conducting data analysis and providing insights to support Soaren's marketing efforts, collaborating closely with the paid and organic marketing teams to optimize campaigns, drive customer acquisition, and increase revenue for Soaren's loan products.
• Proficient in Python, Excel, Power BI, and SQL for data analysis
• Experienced in designing incentive programs to boost agent productivity 
• Collaborated closely with the paid marketing team to analyze advertising campaign performance, optimizing budget allocation and targeting strategies based on customer segmentation and ROI analysis.
• Implemented predictive modeling techniques to forecast short-term loan demand and customer acquisition trends, resulting in a 15% increase in annual sales compared to the industry average.
• Conducted A/B testing and conversion rate optimization initiatives in partnership with the organic marketing team, leading to a 20% improvement in website conversion rates and organic lead generation.
• Developed custom dashboards and reports to track key performance metrics such as eLTV, CAC, CLV, and churn rates, enabling data-driven decision-making and continuous improvement of marketing strategies.
• Acted as a liaison between the data analytics team and marketing departments, ensuring seamless communication and alignment of goals to drive sustainable growth and competitive advantage in the financial tech loan industry.
• adapting to dynamic changes in the business landscape
• Stay up-to-date with industry trends and best practices in marketing technology and digital experience, utilizing proficiency in tools such as JIRA, Confluence, Redshift and Microsoft Office Suite gained from my professional experience.

• Produced monthly reports using advanced Excel spreadsheet functions.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
• Utilized data visualization tools to effectively communicate business insights.
• Used statistical methods to analyze data and generate useful business reports.
• Generated ad-hoc reports to evaluate specific business requirements.
• Created data models to support decision-making processes.
• Optimized data access and storage to improve performance of analytics systems.
• Worked with stakeholders to develop quarterly roadmaps based on impact, effort and test coordinations.
• Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
• Assessed accuracy and effectiveness of new and existing data sources and data analysis techniques.
• Built company A/B testing frameworks to test model quality.
• Discovered stories told by data to present information to scientists and business managers.
• Created and implemented new forecasting models to increase company productivity.
• Coached and mentored junior data scientists on SAS and data mining techniques.

• Mars Petcare is a global leader in the petcare industry, offering a diverse portfolio of pet food, treats, and veterinary care products under popular brands such as Pedigree, Whiskas, and Royal Canin.
• Collaborated with the marketing team to optimize advertising campaigns, driving brand awareness, customer engagement, and sales growth for Mars Petcare products. Leveraged data-driven insights to maximize the impact of marketing investments.
• Utilized data analytics tools to track and measure key performance indicators (KPIs) such as click-through rates, conversion rates, and return on ad spend (ROAS) to evaluate the effectiveness of paid marketing campaigns.
• Wrote SQL queries, including requests, functions, and stored processes, to extract and analyze data efficiently. Created detailed accounts, charts, and graphs to support strategic decision-making using BI solutions and programming languages.
• Demonstrated proficiency in using MySQL, Oracle, and SQL Server for creating reports, charts, maps, and other data visualizations. Developed and maintained SQL stored procedures using PL/SQL and Transact-SQL.
• Conducted A/B testing and multivariate testing to optimize ad creatives, messaging, and targeting parameters, leveraging identified customer segments to deliver more relevant and impactful ad experiences.
• Worked closely with media buying agencies and advertising partners to negotiate favorable ad placements, optimize media spend allocation, and maximize the impact of paid marketing investments targeted at the identified customer segments.
• Provided actionable insights and recommendations to the paid marketing team based on data analysis, market research, and competitive intelligence, enabling data-driven decision-making and continuous improvement of paid marketing strategies targeted at the identified customer segments.
• Collaborated cross-functionally with departments such as product management, brand management, and sales to ensure alignment of paid marketing initiatives with overall business objectives and marketing goals for Mars Petcare products and brands, leveraging insights gained from the identified customer segments.
• Created ETL procedures using commercial toolsets and scripting languages to ensure data accuracy and integration across various marketing databases. Maintained data integrity by ensuring that data content was current and correctly validated.
• Provided technical assistance to internal stakeholders via phone, email, and in small group settings. Communicated complex data insights and technical concepts effectively to non-technical team members.
• Managed multiple projects aimed at improving data accuracy and validity, ensuring timely and accurate reporting of marketing KPIs. Demonstrated exceptional time management skills and the ability to prioritize tasks effectively.
• Stayed updated with the latest technology trends and user applications relevant to the petcare industry. Continuously learned and utilized policies and procedures related to all assignments.
• Worked in partnership with various coordinators, analysts, database administrators, and other departments to ensure seamless data integration and alignment with overall business objectives.
• Performed data analysis using Databricks in an Azure environment to support marketing projects and initiatives at Mars Petcare.
• Developed and maintained Python scripts for data manipulation, analysis, and visualization to enhance campaign performance insights.
• Utilized APIs to extract and integrate data from various sources, improving data consistency and accessibility across marketing platforms.

Highlighted Projects:

• Customer Segmentation and Targeting: Conducted an in-depth analysis of customer data to identify a high-value segment, resulting in a 15% increase in engagement and a 10% boost in sales for targeted marketing campaigns.
• Veterinary Care Initiative: Analyzed monthly vet subscription data to develop a marketing strategy that reduced missed appointments by 20% and increased overall vet visits by 25%. This project demonstrated the value of data-driven insights in promoting pet wellness.
• A/B and Multivariate Testing: Managed multiple testing initiatives to optimize ad creatives, messaging, and targeting. The tests led to a 12% improvement in click-through rates and a 7% increase in conversion rates.
• Media Spend Optimization: Collaborated with media buying agencies to negotiate ad placements and optimize media spend. Achieved a 15% improvement in return on ad spend (ROAS) by reallocating budget based on performance data.
• BI Dashboard Development: Created interactive dashboards using Tableau to visualize key marketing metrics and trends. These dashboards enabled real-time monitoring and analysis, supporting data-driven decision-making across the marketing team.
• AWS Redshift: Integrated application data from multiple sources into a centralized Redshift warehouse, using AWS Glue for ETL automation, schema discovery, and data validation to ensure data integrity for bug identification and insights generation.
• Apache Airflow: Developed and automated ETL workflows with Airflow to orchestrate data ingestion, transformation, and validation across multiple applications, enabling efficient error tracking and performance insights.
• Databricks (Azure): Leveraged Databricks for scalable data processing and transformation, utilizing Spark for rapid analysis of large datasets, identifying bugs, and extracting actionable insights from integrated app data.

• Analyzed medical records and public health data to support research initiatives at Roseman School of Pharmacy.
• Extracted and cleaned data from medical record systems and public health data warehouses (e.g., CDC, WHO).
• Utilized statistical analysis techniques to identify trends, patterns, and correlations.
• Contributed to the development of evidence-based research findings for academic and clinical research projects.