Amar Ranjane
The Woodlands,TX
Summary
Skilled data analyst with more than 7+ years of industry experience in collecting, organizing, interpreting, and disseminating various types of statistical figures. Confident communicator with the ability to circulate information clearly, efficient, and beneficial for end users. Creative in finding solutions to problems and expert at providing realistic projections and establishing various scenarios to determine viable process strategies to utilize.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Sr. Data Analyst
Conns Home Plus
Houston, TX
08.2021 - Current
- Manage in-house direct mail acquisition campaigns for active and inactive customers and ad-hoc trigger campaigns
- Responsible for tracking, analyzing, and reporting of Direct Marketing campaigns and projects
- Create and maintain campaign-level reports, customer reports, dashboards, and financial results reports
- Designed and implemented customer acquisition campaign using life event data from Experian, increasing retail sales by 5%
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses
- Leveraged text, charts, and graphs to communicate findings in understandable format for weekly report
- Analyzed existing customer data and designed birthday postcard campaign, increasing application rate by 15% for existing customer
- Partner with external and internal clients to design new methods of testing and implement results into future campaigns
- Work closely with credit team to ensure alignment between pre-screen selection criteria and underwriting rules to consistently optimize approval rates
- Examine creative results to determine the most impactful messaging and develop ideas for maximizing volume on budget parameters
- Collaborate with team members to design an attribution methodology for tracking how often customers are being communicated to and the optimal path to purchase.
DATA ANALYST II
AAA The Auto Club Group
Tampa, Florida
03.2018 - 08.2021
- Collaborated with Product and Business Unit managers to identify, evaluate, and improve CRM opportunities for AAA Memberships/Insurance/Banking
- Mining into large-scale data of customer demographics and behaviors to discover potential new marketing opportunities for acquisition, retention, cross-selling, and profitability
- Successfully designed and programmed two new marketing campaigns, increasing response rates by 30%-40%
- Reduced cost by 30% on direct mails by performing A/B testing on Millennial's vs Boomer for membership retention
- Performed Funnel Analysis on various marketing channels to analyze conversion rate
- Performed user segmentation for MICHIGAN insurance reform to identify hot leads
- Improved quote rate by 9% by redirecting leads to call center agents using model to evaluate their performance
- Investigated multiple historical CRM metrics to analyze product penetration and customer engagement improve cross sell opportunity.
Data Analyst
SAKSOFT Private Limited
Mumbai, Maharashtra
06.2015 - 08.2016
- Worked closely with product credit risk teams, provided in-depth insight and analysis to evaluate portfolio to maintain acceptable overall risk levels
- Identified risks and analyzed portfolio based on debt to income, loan to value, credit scores and variety of other credit variables
- Developed early warning signals and risk models for Personal, Auto and business loan products.
BUSINESS DATA ANALYST
Reliance Communication
Mumbai, Maharashtra
06.2013 - 06.2015
- Gathered detailed business requirements and use cases and translate technical specifications into product requirements
- Collaborated with business analysts, developers, and technical support teams to define project requirements
- Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
Education
Master of Science - Management Information Systems
Florida International University
12.2017
Bachelor of Science - Information Technology
University of Mumbai
06.2012
Skills
- SAS
- Python
- SQL
- Tableau
- Google Big Query
- Google Cloud Platform
Websites
Certification
- SAS Certified Base Programmer
- Tableau 10 Essentials
Timeline
Sr. Data Analyst
Conns Home Plus
08.2021 - Current
DATA ANALYST II
AAA The Auto Club Group
03.2018 - 08.2021
Data Analyst
SAKSOFT Private Limited
06.2015 - 08.2016
BUSINESS DATA ANALYST
Reliance Communication
06.2013 - 06.2015
Master of Science - Management Information Systems
Florida International University
Bachelor of Science - Information Technology
University of Mumbai