Sales Project

Swaraj Mandla

**********@*****.***

Ph.no: +91-807*******, 879*******

OBJECTIVE

To put forth my strenuous efforts for a reputed IT firm, where in I could bring out my maximum potential that caters to the Customer’s business needs and to deliver maximum value through quality technology solutions

Professional Summary

4.5 years of experience in Web analytics, Adobe Analytics, Adobe Experience cloud, Alteryx,Advanced Excel and VBA macros, Google Analytics, Google AdWords, Tableau,, SAS, SQL Server, linear regression, Dynamic Tag Management, Adhoc Analysis, JavaScript, JQuery, HTML 5, CSS 3.

Reporting using Report Builder, Built multiple integrated digital dashboards on Tableau using Alteryx.

Delivered National level Brand insights In Current organization which positively increase the revenue of the Brand.

Created SDR’s As per the business requirement, site audit and testing also created site health reports

Currently part of the Technical Interview panel for digital analytics & tableau profiles.

Worked on Alteryx designed workflows and connecting to them tableau & Qlik.

Domain Expertise in both Core analytics and Digital Analytics.

Certified in Google Analytics and AdWords.

Fine Understanding of Search Engine Marketing

Worked in Cognizant analytics in Design and Implementation of Business Applications in the Life Sciences, Ecommerce, Investment Banking and Financial Services.

Creating Reports using Discover (ADHOC Analysis), for the news releases and creating campaigns on social networking sites and tracking visits and visitors from that campaign.

Creating Audit reports and technical specifications documents and based on that recommending client to make basic changes in the portals.

Worked on Google Analytics and Worked on Site Catalyst.

Proficient in SQL Server, Base SAS, R, Analytics, Statistics, PowerPoint.

Data Extraction and updating in the database using SQL server

Very good hands on experience in analytics domain.

Strengths:

Flexible and Versatile to adapt to any new environment and work on any project.

Good Communication, interpersonal and problem solving skills.

Good Team player, able to work independently with minimal supervision and work under tight deadlines.

Committed to quality work.

Education Qualifications:

Qualification

Institution

Percentage

B.Tech (E.C.E)

Kakatiya University College of Engineering and technology

75.64%

Intermediate

Sri Vikas junior college

93.4%

SSC

Century High School

88%

Achievements:

Won Tata Motors limited Nano Genext Achiever’s Award 2014

Shortlisted for Young India fellowship.

Won inter college cricket tournament as a captain.

Organized paper presentation in kleio (2012) National level technical Symposium.

Certifications:

Google Analytics Certified Professional.

Alteryx Certified Professional

Employment History:

Cognizant technology Solutions– Programmer Analyst (Developer) –January2014 –January 2016

Deloitte Support Services- Analyst- February2016-June2017’

Novartis Health Care Pvt Ltd.- Business Analyst- July’17-Present

Projects:

Digital analytics:

Customer: Novartis Oncology

Role: Digital Business Analyst

Responsibilities:

Campaign Implementation and Reporting in Omniture.

Oncology sites Adobe Analytics Implementation and Reporting.

Defining the KPI’s for each website and designing the Tech spec document based on the KPI’s

Designing SDR.

Dashboard creation in Tableau, Qlik and power point for brand (stake Holders).

Requirement gathering and testing of Tagging on websites.

Knowledge Services Metrics:

Customer: Global Knowledge Services (Deloitte)

Role: Analyst

Responsibilities:

Site catalyst Implementation & Report generation.

Dashboard Creation on Tableau and PowerPoint on a monthly and Adhoc basis.

Metrics support for all the Deloitte internal services websites.

Campaign Creation and tracking for all the sites.

Report generation using report builder and data analysis and insight presentation in tableau.

Linear regression and Moving average methods to forecast usage.

S&P INDICES:

Customer: S&P (standard and poor’s Indices (McGraw Hill Financial))

Role& Technologies used: Site Catalyst implementation and Reporting and Google analytics Implementation and Reporting, Site Auditing, Adhoc (Discover) analysis, SEO.

Domain: Banking and financial Services

Responsibilities:

Site catalyst & Google Analytics implementation on the website.

Report Generation from and dashboard preparation.

Suggesting changes based on the data insights.

Reducing the bounce rate of the site.

SEM Optimization and Keyword Optimization (Google Ad Words).

Cognizant.Com:

Customer: Cognizant.com

Role: Preparing Weekly Reports from Google Analytics.

Technologies used: Google analytics, Adobe Site Catalyst Advanced Excel, VBA, Macros, JavaScript, Adhoc analysis.

Domain: IT Services

Responsibilities:

Importing Data from Google analytics.

Creating Traffic and conversion variables and monitoring tag firing in the site.

Event Creation and linking it with analytics tool and event testing.

Weekly, Monthly & Quarterly report Creation about the visitors and investors visiting the site.

Implementation and Reporting on Adobe site catalyst.

Automated Excel Reports Using VBA

Creating Dash Boards and Data Tables for the datasets extracted

GlaxoSmithKline: Incentive Compensation

Customer : GSK

Period : April2014-July2104

Project : GSK NAC IC Steady State

Project Type : Development

Company : Cognizant technology solutions

Description: GSK IC project mainly deals with providing an E2E Solution for providing Incentive Compensation for the GSK Sales Representatives. It includes loading the data pertaining to Sales representatives into the database and setting up a workflow based on the role hierarchy of the Sales persons in GSK.

Technologies Used: SQL server, Excel, VBA Macros

Responsibilities:

Involved in the Gathering of Requirements from the Functional Architect.

Customized the front end according to client requirement

Automated Compensation based on the Monthly payout factor in VBA.

Used- JQUERY, JavaScript for front end validation.

Created Tables and join them using the primary key and pull data from database

Creating Module Wise Tasks and implementing.

Creating a Universe based on the data files received from the Client say for E.g.: Data files include Territory, Job Code, and Test Id etc.

Creating an E2E for sales representatives based on territory, job code, division etc.

Opserve:

Customer : Cognizant Technology solutions

Period : July 2014-present

Project Name : CA INVESTMENTS (Opserve)

Project Type : Development

Environnent : HTML, JavaScript, CSS

Company : Cognizant Technology Solutions

Description: Opserve is a new tool Targeted to automate the sales planning and the call planning of the pharma companies. It is a prestigious development cum enhancement project intended to automate the IC compensation and SC compensations. One instead of manual calculation using various tools like excel.

Technologies Used: JavaScript, JQuery, HTML.

Responsibilities:

Involved in development environment.

Worked on the core java and jsp front end and the database back end both sides.

Understanding the business side of the tool.

Maintaining the product and checking flaws.

Handled Part of Sales Planning.

Used JavaScript for Session Tracking,

Developed front end screen for Message Communication using– HTML 5,CSS – Grid view

Preparing the Weekly status Report pertaining to the Project.

MFRP IN COGNIZANT:

PROJECT NAME: PHARMA IC COMPUTATION

Role: Team lead

My mfrp in cognizant me along with 2 of my colleague’s worked on the project.

The project was regarding the ic computations of employees of a ABC pharmaceutical’s which have three categories of employees i.e., rep, manager, area director .this company has three products they are dalrev, trolensa, geprevo which had various weights and territories assigned to various reps

Based on the payout factor we have calculated the earnings & payout of the reps managers and the area director in excel.

Personal Details

Nationality: Indian

Date of Birth: May 18, 1992

Current Location: Hyderabad

Contact this candidate