8/8/2019 Campaign Analyst

1/3

ObjectivesI am looking forward to working with an entrepreneurship fostering organization where I can harness as well

as improve my Analytics domain ability, experience & Industry insights to shape the top & bottomline

paradigms.Summaryy I have 2+ years of hands on Rich Experience in Marketing Analytics including Secondary Research,Statistical Analysis, Predictive Modeling and Direct Marketing Campaign Management.y I have successfully experienced in Leading and Mentoring Analytical Team Membersy I have trained and mentored team Members on Base SAS, SAS Macro, SAS/STAT, Teradata, SQL, Affiniumand business related issues.y I have stabilized processes by applying strong organizational, technical and interpersonal skills to producequality results.y Extensive Exposure to US Consumer & Retail Banking, US energy and utilities market and US Pharmaindustries.y Trained from SAS Institute India Pvt Ltdy Trained from UNICA on Affinium Campaign Management Tool.y Trained from NIIT on C++, Java, VB.Net, TeradataEducationM.A in Applied & Analytical Economics from Utkal Universityy Major Papers: Econometric Methods, Mathematical Economics.y Got nd rank in the Entrance Exam for M.A in Applied & Analytical Economics.B.A in Economics fromB.J.B. College, Utkal Universityy Major Papers: Econometric Methods, Mathematical Economics.experienceASSISTANT MANAGER|GENPACTAugust, till dateCurrently as a part of Advanced Analytics Team the responsibility is to lead TRC ARC Reporting team to

generate adhoc reports and analyze the reports for effectiveness of various Therapeutic Resource CentersTRC of Medco. Earlier I was involved in the execution and tracking of direct marketing campaigns for the

Medco Marketing Campaign Management Team to provide actionable customer intelligence. Summary of

responsibilities taken at GENAPCT are:y Taking Transition from US team.y Designing and maintaining comprehensive campaign management data mart that provides a completeview of all customer.y Developing ETL in SAS, Teradata and SQL to load the campaign management data mart from differentbusiness sources.y Designing personalized customer communication strategies and deliver offers at the most appropriatetime based on actionable customer intelligence using various channels like Direct Mail, Email and OST Onsite

Targeting.y Implementing the change controls for various campaigns.y Monitoring the campaigns to understand the effectiveness of the campaignsy Building response models to identify the high responding costumersy Debugging SAS and Teradata Macros to improve report generationy Mentoring New Team Members on campaign execution, SAS, Teradata, Campaign Management Toolsy Reviewing and writing appraisals for the team membersTill now I have served two big clients of GENPACT. Theyare:y Medco Analytics Assistant Manager from May, to till date.

8/8/2019 Campaign Analyst

2/3

y WellsWachovia Analytics Senior Business Analyst from August to MayAchievements:y Completed internal transition from the transition manager in one month while this was expected to becomplete in two months. This helped the team to go live on project and stabilize the process sooner than

expected.y Trained new resource on the process and helped him to come up to speed on the process.y Decoded complex SAS code used in the campaign execution process to help the team gain anunderstanding of the code. E.g. SQL and MACRO commands used in the SAS program templates.y Helped the team to gain understanding in UNICAs Affinium campaign management tool, which helpedthe process to speed up.y For Excellent performance I was rated top performer of my team in last appraisal.y I have been elevated to a Team lead for consistent delivery with efficiency.SENIOR ASSOCIATE|KNOWLEDGESERVICESINFOSYSBPO LTDJUNE, AUG,As a Senior Associate the responsibility involves creating different business rules to reduce the repeat errors

for the Customer Services team of a major British Telecom client.Key Responsibilities were:y

Identify the attributes responsible for the repeat errors.

y Predict the chances of repeat error using logistic regression.y Create set of business rules using CHAID analysis.CAMPAIGN ANALYST|KNOWLEDGESERVICESINFOSYSBPO LTDMAY, JUNE,As a campaign Analyst the responsibility involves supporting the execution of direct marketing campaigns for

the Customer Information Group CIG of the client which is a major US Bank. These campaigns support key

relationship marketing business objectives for the bank across multiple channels including but not limited to

direct mail, telemarketing and email. Key responsibilities are:y Design marketing campaigns using UNICA Affinium Campaign System.y Identify all necessary data elements for selection from appropriate tables and data sources.y Work with marketing partners to achieve desired campaign results and present the results in an executivesummary report including waterfall analysis, segmentation analysis, etc to the Marketing Team.y Work with technology partners to ensure campaigns are executed efficiently and accurately.y Validate results to ensure accurate campaign execution.Achievements:y Went for taking international transition of the new process which helped the team to go live on projectand stabilize the process sooner than expected.SENIOR ASSOCIATE|KNOWLEDGESERVICESINFOSYSBPO LTDAPRIL, MAY,Built a Churn and Chargeoff models for a major US utility. Churn model was built to identify the customers

with maximum risk of attrition. Charge off model was built to identify the default customers. The project

involved:y Identifying input data and sampling from the larger datasety Exploring the data graphically and statisticallyy Preparing the data for analysis which involves outlier, missing value treatment, transformation of variablesy Fitting and validating the logistic regression modely Comparing the predictive modelsy Scoring the modelANALYST| GLOBAL ENERGY PRACTICE PA CONSULTING GROUPJune, April,

8/8/2019 Campaign Analyst

3/3

I was responsible for Secondary Research on Global Energy Industry by analyzing and understanding client

requirements through and accountable for crafting effective strategies within timelines and quality

parameters thru:y Tracking relevant news stories for the Energy practice.y Maintaining backfilling and updating Database.y Summarizing Reports Annual, Quarterly, Investors Presentation, and Analyst Call.y Research on individual companies, technologies, legislations etc.y Preparing Presentations for different companies.y Preparing graphs for different NERC regions.Professional Trainingsy SAS Programming I: Essentials SAS Institute India Pvt. Ltd.y SAS Programming II: Manipulating Data with the DATA Step SAS Institute India Pvt. Ltd.y SAS Enterprise Guide: ANOVA, Regression & Logistical Regression SAS Institute India Pvt. Ltd.y Applying Data Mining Techniques using Enterprise Miner SAS Institute India Pvt. Ltd.y SAS Macro Language SAS Institute India Pvt. Ltd.y Affinium Campaign Management Tool Unica, Boston, USAy Teradata NIIT, Bangalore, IndiaTECHNICAL SKILLSy Predictive Modeling Linear Regression and Logistic Regression other Multivariate Techniques.y Campaign Management Affinium Campaign tool, SQL and Access Database on Teradata RDBMSy Modeling/Datamining Tools SAS., SAS Enterprise Miner, SPSS, Knowledge Seekery RDBMS: Oracle i, PL/SQL, SQL Server , MS Accessy Exposure to Programming Languages: C++, Java, VB.Nety General Proficiency: Ms Office, Windows, UnixEXTRACURRICULAR ACTIVITIES AND HOBBIESy Organized many cocurricular activities at Utkal University.y Member of Utkal University Syndicate for the year .y Represents university cricket team in the inter college tournament for the year .y Led the Economics Department cricket team during M.A. for the year .y Led the cricket team of B.J.B. College in inter college tournament for the year .y Held the role of seminar secretary of the Economics Dept in B.J.B. College for the year