Rajesh Gandavalla

Professional Experience

Business Analyst Genpact, Bengaluru, India (Remote)
December 2021 – Present

• Lead marketing operations for Synchrony Financial (SYF), specifically focusing on the CareCredit portfolio.
• Developed and executed data-driven marketing campaigns targeting B2C credit card holders in verticals like Audiology, Dental, Veterinary, Vision, and more.
• Created and maintained campaign workbooks containing Waterfall, Audit Reports, Segmentation files, and Output files to ensure compliance and quality.
• Automated CareCredit master file generation, which reduced processing time from 16 hours to 30 minutes, improving accuracy and freeing up resources for further analysis.
• Collaborated closely with business stakeholders to align campaign requirements, ensuring efficient execution of marketing strategies.
• Utilized SAS, SAS SQL, SAS Macro, and SAS EG for customer segmentation, targeting, and reporting.
• Coordinated weekly and monthly reporting trackers, providing valuable insights to stakeholders on campaign performance.

Tools Used: SAS, SAS SQL, SAS EG, SAS CI, WinSCP, Epsilon, Excel

MIS Executive Intelliswift Software, Bengaluru, India
February 2018 – November 2021

• Worked extensively on data extraction, data cleansing, and report generation using SAS 9.3, Excel, and VBA for multiple clients.
• Designed and implemented MIS reports and dashboards for high-profile clients, including Samsung, Amazon, Adobe, and Equinix, providing comprehensive insights on talent and recruitment operations.
• Developed and optimized SAS code for reporting, leveraging Base SAS and Macros to streamline the report generation process.
• Supported data mining and data extraction from various sources (including Oracle databases and raw file types) to create structured SAS datasets.
• Managed dashboard updates, including job creation, interviews, offers, onboarding, and other operational aspects.
• Led data transformation processes and performed data manipulation tasks to prepare data for reporting and analysis.

Tools Used: SAS 9.3, VBA, Excel, Oracle, Base SAS, SAS Macros

Projects

Project: Workfront (Genpact – Synchrony Financial)

Environment: SAS EG, SAS CI, WinSCP, Epsilon, Excel
Duration: December 2021 – Present

• Led the automation of bi-monthly marketing campaigns for CareCredit cardholders, focusing on verticals like Audiology, Dental, and Veterinary.
• Transformed a manual process that took 16 hours per campaign into an automated solution using SAS Centralized Automation (CA), cutting processing time to just 30 minutes.
• Automated data extraction, segmentation, and output file generation, ensuring accurate and timely delivery of campaign results.
• Improved operational efficiency, consistency, and data accuracy, allowing analysts to focus on higher-level tasks.

Project: JobDiva (Intelliswift Software)

Environment: SAS 9.3, VBA, Excel
Duration: February 2018 – November 2021

• Developed SAS datasets from Oracle databases and raw file formats, ensuring clean, structured data for analysis and reporting.
• Created and maintained MIS reports for talent management and recruitment processes, delivering insights to clients like Samsung, Amazon, and Equinix.
• Leveraged Excel Pivot Tables, Proc SQL, and Proc Freq for data manipulation and report generation.
• Managed dashboard updates related to recruitment activities (job postings, interviews, offers, and onboarding).