Ravikiran Nersu
Marketing Manager
Pflugerville,TX
Summary
Over 12+ years of experienced with Campaign Execution for spearheading Credit Card Acquisition campaigns from concept to completion. Skilled in leveraging SAS, Unica, and Oracle SQL for in-depth statistical analysis, I excel in creating targeted campaigns based on solid data insights. My proficiency spans audience segmentation, promotional strategy creation, and performance evaluation, enabling well-informed decision-making. Proficient in Machine Learning and Data Science, I excel at driving stakeholder value via predictive analytics and optimization. My broad experience across the communications, healthcare, and financial services industries underscores my adaptability and innovative approach. With a background as a Sr. Programmer Analyst and Sr. Reporting Analyst, I've refined my expertise in data analysis, campaign strategy, and promoting cross-functional collaboration to achieve growth objectives.
Overview
13
13
years of professional experience
6
6
years of post-secondary education
Work History
Acquisition Campaign Manager
Mercury Financial LLC
06.2022 - Current
- Perform statistical analysis to drive Credit Card Acquisition campaign initiatives from inception to implementation using SAS, Unica and Oracle SQL
- Develop and execute end-to-end campaigns by analyzing data, identifying campaign objectives, segmenting, and targeting audiences, creating key messages, and developing promotional offers
- Use SAS data analysis tools to evaluate campaign performance, identify areas for improvement, and provide recommendations for future campaigns
- Collaborate with senior management to develop tactical campaign plans that support annual business objectives and account goals for credit card members or acquisitions
- Perform auditing, Organize documentation and procedures in a database using Oracle SQL and relational database principles
- Integrate internal and external data to provide a complete view of the business, driving marketing efficiencies and uncovering new opportunities for growth.
Strategic Reporting and Analytics Manager
Mercury Financial LLC
11.2019 - 05.2022
- Established performance metrics to track progress towards organizational goals, promoting accountability and continuous improvement.
- Conducted ad-hoc analysis for senior leadership, providing critical insights during key decision-making processes.
- Developed customized analytics solutions for various business units, leading to improved decision-making and strategic planning.
- Assisted in budget planning and resource allocation for the reporting department, ensuring optimal utilization of available resources.
Sr Programmer Analyst
Barclaycard
05.2017 - 11.2019
- Working as a part of DataOPS Engineering team job duties involved developing marketing campaigns and conducting data analysis for both consumer and commercial accounts
- Gathering and validating data for direct mail, social media, and email marketing channels
- Collaborating with stakeholders to gather requirements for reporting deliverables
- Providing business intelligence reports and dashboards to drive insights about our card campaigns and inform future strategies
- Participating in acquisition, upgrade, and service campaigns and all stages of the software development life cycle (SDLC) from planning to deployment
- Cleaning up and auditing MasterCard and Visa products data from vendors to Tsys to internal data
- Automating and scheduling SAS jobs and supporting KPMG auditing processes.
Sr Reporting Analyst
Well Care
06.2016 - 05.2017
- Worked in regulatory reporting team
- Created regulatory reports by identifying patient benefits and sending them communication as per state requirements
- Analyzed Plan recommendations for additional quality programs and analytics
- Prepared detail and summary level reports including written interpretation of analytic result
- Documenting development requirements, reviewing specifications, creating test plans, process flow charts and reviewing the user-acceptance test data
Sr Programmer
Wells Fargo
11.2014 - 05.2016
- Developed SAS programs to create a customer mailing list for debit and prepaid card analytics for conducting marketing campaigns and data analysis
- Collected data to create produce and validate direct mail, online ATM and email marketing channels
- Created and maintained dashboards that summarize Debit card issuance, engagement, and store level performance metrics
- Interacted with stakeholders and product managers to gather requirements for reporting deliverables
- Leverage these dashboards to drive insights about our card activation campaigns and inform future strategies.
Sr Programmer
Cisco
03.2014 - 10.2014
- Providing Business intelligence for global business services to target companies for sales
- By conducting extensive data analysis and by pulling data from internal models and from external data sources, estimating size of opportunity for products for different levels
- Cleaned Duns and Bradstreet data with billions of records Standardized and validated, and develop data quality metrics
- Mapped data using fuzzy logic to compare and standardize unformatted data
- Providing on going production support by monitoring productions jobs and providing ad hoc as per the requirements and presenting in pivot tables.
SAS Programmer
RBS Citizens
11.2012 - 02.2014
- Worked with strategy and analytics team on campaign data management for RBS citizen’s financial group, providing banking and product marketing analysis
- Extensively worked on credit bureau data to look for opportunities to cross sell or upsell products to customers
- Conducted daily evaluation and verification activities designed to improve customer satisfaction and business performance
- Developed marketing campaigns for consumer & Business banking products, upgrades and promotional offers.
SAS Programmer/Analyst
Capital One
02.2012 - 10.2012
- Responsible for extracting data from multiple sources, merging, cleaning, creating variables and from scoring cards for PD, LGD and EAD for RWA calculations for Basel-lI framework
- Worked on statistical models obtaining measures and conducting statistical tests of model performance.
SAS Programmer
JPMorgan Chase
10.2011 - 01.2012
- Developed SAS Macro programs to gathering data based on marketing campaigns for various card products
- These datasets were directed towards being used for capturing new customers through direct mail and telemarketing
- Credit card representatives used it for giving specifically directed offers to various sects of new and existing card members
Education
Masters in Engineering -
Bradley University
Peoria, IL 01.2009 - 05.2011
Bachelor in Engineering - undefined
JNTUniversity
Hyderabad, India 09.2003 - 05.2007
Skills
Python
www.linkedin.com/in/ravikiran-n-6a3a45259
Timeline
Acquisition Campaign Manager
Mercury Financial LLC
06.2022 - Current
Strategic Reporting and Analytics Manager
Mercury Financial LLC
11.2019 - 05.2022
Sr Programmer Analyst
Barclaycard
05.2017 - 11.2019
Sr Reporting Analyst
Well Care
06.2016 - 05.2017
Sr Programmer
Wells Fargo
11.2014 - 05.2016
Sr Programmer
Cisco
03.2014 - 10.2014
SAS Programmer
RBS Citizens
11.2012 - 02.2014
SAS Programmer/Analyst
Capital One
02.2012 - 10.2012
SAS Programmer
JPMorgan Chase
10.2011 - 01.2012
Masters in Engineering -
Bradley University
01.2009 - 05.2011
Bachelor in Engineering - undefined
JNTUniversity
09.2003 - 05.2007
Similar Profiles
ZaNesha JacksonZaNesha Jackson
1st Party Resolution Agent at Mercury Financial1st Party Resolution Agent at Mercury Financial
Noah OchoaNoah Ochoa
Delivery Associate at Mercury in Motion .LLCDelivery Associate at Mercury in Motion .LLC
Ashley PlummerAshley Plummer
Certified Nursing Assistant at Mercury Healthcare LLCCertified Nursing Assistant at Mercury Healthcare LLC
Paris JacksonParis Jackson
Registered Nurse at Dell ChildrensRegistered Nurse at Dell Childrens
Logan WaltersLogan Walters
Warehouse Worker at TeslaWarehouse Worker at Tesla