Post Job Free

Resume

Sign in

Marketing Analyst Sql Developer

Location:
Vasant Nagar, Karnataka, India
Posted:
May 26, 2021

Contact this candidate

Resume:

KAVYASHREE VR Mobile:789-***-****

admpms@r.postjobfree.com

Objectives:

A challenging position with an expanding and dynamic company, where I can implement the skills that I have gained through my education and experience, as well as to enhance my knowledge by dedication and hard work.

Professional Summary:

An IT Professional with 1.3 years of experience.

Writing SQL scripts to pull high quality data as per given requirement.

Building PL/SQL package to feed the ongoing nurture campaigns.

Segmentations, Contact/Prospect Extractions for Nurture Campaigns / Batch and Blast campaigns.

Providing Pivots and preview reports to marketing managers and later process involves list imports and campaign loads for the qualified data in Eloqua/GCM for email/phone execution.

Competent in designing the flow of nurture campaign using Eloqua.

Reporting through Eloqua Insights

Reporting campaigns based on KPI’s (Open Rate, click through, and bounce back, Unsubscribes etc.) as per the client’s requirements.

Lead Generation Ads – Facebook and LinkedIn.

Technical Skills:

Database : Oracle 11g, 12c

Programming languages : SQL, PL/SQL

Applications : Eloqua Marketing Automation

Tools : SQL Developer, SQL*Plus

Operating Systems : Windows 10/NT/XP, UNIX

Professional Experience:

Working as a Marketing Analyst in PRIMUS Global Technologies, Pvt. Ltd Deputed to Oracle Solutions Services India, Bangalore Location from March-2020 to TillDate. Educational Qualification

B. E. (ISE) from BGS Institute of Technology, B.G Nagar with 60.17% in 2018.

12th from Vishwamanava PU College, Mandya with 66.33% in 2014.

10th from St.Ann’s High School, Maddur with 70.24% in 2012 Project #1:

Role : Marketing Analyst

Project Name : Oracle Global Marketing Operations & Shared Services (GMSS) Client : Oracle Solutions Services

Technology : Eloqua Marketing Automation Applications Duration : March-2020 to TillDate

Project Description:

The Global List Management team provides timely, high-quality internal and external lists to support Marketing and Sales initiatives-including e-mail, direct mail, and telemarketing campaigns. These lists align with the criteria and volume requirements set by the campaign managers to optimize audience targeting and revenue realization. List Management Process:

The Internal List Management team provides both data and lists to support Oracle Marketing and Sales in increasing penetration and visibility into customer and prospect organizations. The team supports these efforts through two primary functions:

• Data extracts (Email/ Phone/ Postal channels) list segmentation.

• Data uploads i.e. List imports & Load campaigns to Eloqua. RESPONSIBILITIES:

• Solving Service Requests (SRs) raised by the marketing campaign Managers.

• Eloqua Segmentation- Creating E-mail segments in Eloqua

• Loading marketing activities tied to programs or events to ensure data availability for sales follow-up and campaign analysis

• Proving pivots and preview lists to Campaign Managers

• Code level investigation of the jobs while pulling data from large database

• Data fixing involves writing PL/SQL Scripts and SQL, which would cater the needs of the businesses

• Data verification process involving contact, prospect verification which involves checking suppressions, o.com profile opt-outs, bounce and over target contacts. Marketing Automation:

As a member of Marketing Automation Team, responsible to build Eloqua campaign canvas flow for Nurture Campaigns and Multi-touch Campaigns.

Responsible to build PL/SQL package to pull targeted contacts from Oracle Marketing Database to auto-feed the ongoing Nurture Campaigns.

Responsible to check the data quality of email assets and enforce the standard naming convention.

Responsible to check and maintain the flow of contacts correctly through different stages of nurture life cycle.

Responsible for setting-up conference call to explain the design and flow of the Campaign Canvas to different stakeholders.

I here by declare that the above mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above mentioned particulars.

(Kavyashree VR)



Contact this candidate