Varun Krishnaswamy
Chennai
Summary
15+ Years of expertise in all aspects of Campaign management, data analysis and reporting using SAS, Tableau, Unica, SQL, Teradata and Netezza. Experienced in requirement gathering, designing, executing, and testing for multi-channel campaigns. Managing team and assign work to the team, working in banking industry which has wide range of products like Mortgage, Credit card, insurance, cross sell, wholesale, etc. Supporting COO team for risk related activities. Excellent interpersonal, intuitive, technical, analysis and leadership skills. Thrive in both independent and collaborative work environments.
Overview
17
17
years of professional experience
Work History
Campaign Lead
BA continuum India Pvt. Ltd
06.2018 - Current
- Manage the marketing Campaign data file processing team
- Auditing campaign files and manage deliverables from end to end
- Project migration activities
- Hiring, arrange training and access setup
- Periodic access review, support COO and risk SPOC for the delivery head
- Collaborate with business partners on targeting strategy, segmentation, data privacy and governance
- Maintain processes and controls to ensure data accuracy and timeline of campaign files
- Reports developments, campaign analytics and data quality
- Customer complaint research and report creation for Risk and compliance process
- Automate, streamline and process improvement of projects, schedule execution in AutoSys
- Ensuring adherence to data management/data governance regulations and policies
- Collaborate with other teams for source data, post campaign analytics, contact history inserts
- Create reports of Campaign analysis and evaluating key performance indicator
- Develop campaign file for different channel with various output structure and format
- Create and maintain SAS program templates for BAU projects and maintain the suppression list
continuum India Pvt. Ltd
01.2014 - 06.2018
- Processing Campaign files in SAS and UNICA Campaign Management tool includes requirement gathering from multiple business partners for processing the campaign, designing and execution of campaigns from end to end
- Campaign performance tracking reports creation
- SAS program template creation, macro creation and maintenance
- Involved in preparing HLD (High Level Design) and LLD (Low Level Design) documents
- Offer templates and offer Creation, Flowchart creation and flowchart Process Configuration, Customer segmentation, Audience level creation and configuration, Global suppression segment creation
- Catalogue configuration and create joins with the tables
- Import table to SQL server and bring the tables as a base table, dimension, or fact as per the business specification
- Create de dup logic based on the business logic and apply the de dup
- Append seed list to the files created
continuum India Pvt. Ltd
10.2010 - 12.2013
- Develop Campaign flowcharts in Unica campaigns tool and create template flowcharts
- Administration of repository, maintenance, and security changes
- Resolving user issues
- Design intelligence dashboards and reports
- Process business requirements and convert to technical requirements for Unica flowchart and reporting
- Using SQL functions and calculating values for PAI, APR, Current PAI, etc, in Unica campaigns mail list as per business marketing team
- Joining the two sets of answers from different universe and doing calculations for business analysis
- Testing the calculations and formatting the output values as per the data type requested
- Migration of manual process from SQL to OBIEE
- Import different types of raw data, design tables with join and bring to presentation layer
Transworld software, BACI, BA continuum India Pvt. Ltd
01.2008 - 09.2010
- Working for market research and reports development using Siebel Analytics, Siebel Marketing application for WLD, CMD and CIS divisions and SQL server 2005
- Lead management and lead file creation as per the business requirement
- Creating list formats, filters with functions and common filters needed for the file
- Creating DNS scrubs for different channel of marketing and applying it in segments
- Modifying the output table, creating tables and merging splits by SQL
- Importing files from Siebel to SQL database
Education
MBA - Risk Management and Logistics & supply chain Management
NIBM Global
BE - Electrical & Electronics
Thirumalai Engineering College
Skills
- SAS
- TABLEAU
- UNIX
- SQL
- Teradata
- Netezza
Accomplishments
- Received different global awards like Mentorship, The brainiac, excellence in Organization, Best subcommittee contributor.
- Migrated 50+ projects from Unica to SAS within three weeks with parallel production projects delivery.
Languages
Tamil
English
Hindi
Timeline
Campaign Lead
BA continuum India Pvt. Ltd
06.2018 - Current
continuum India Pvt. Ltd
01.2014 - 06.2018
continuum India Pvt. Ltd
10.2010 - 12.2013
Transworld software, BACI, BA continuum India Pvt. Ltd
01.2008 - 09.2010
BE - Electrical & Electronics
Thirumalai Engineering College
MBA - Risk Management and Logistics & supply chain Management
NIBM Global
Similar Profiles
Shibashish RudraShibashish Rudra
Vice President – AML Operations at Bank of America (BA Continuum India Pvt Ltd)Vice President – AML Operations at Bank of America (BA Continuum India Pvt Ltd)
Ankush JoshiAnkush Joshi
Team Develpor (Wealth Manager) at BA Continuum India Pvt LtdTeam Develpor (Wealth Manager) at BA Continuum India Pvt Ltd
Pawan ThakurPawan Thakur
Team Leader at BA Continuum India PVT LTDTeam Leader at BA Continuum India PVT LTD
Shreya BhardwajShreya Bhardwaj
Senior Team Member (Global Procurement) at BA CONTINUUM INDIA PVT. LTD.Senior Team Member (Global Procurement) at BA CONTINUUM INDIA PVT. LTD.
Zaheer Syed.SZaheer Syed.S
Team Manager at GSR Global ServicesTeam Manager at GSR Global Services