Akhil

acyebi@r.postjobfree.com

732-***-****

Professional Summary:

. Marketing analyst with up to 7 years in SQL, R and SAS both with Base and

EG platforms.

. Experience in Marketing role spanning from creating lists for marketing

functions like campaigns, events, whitespace identification etc and

running campaigns in ELOQUA and building dashboards in VA for the

marketing functions as well as other business functions.

. Experience in utilizing SAS Procedures (PROC REPORT, PROC FREQ, PROC

TABULATE, PROC MEANS, PROC SUMMARY, PROC APPEND, PROC TRANSPOSE, PROC

EXPORT, PROC IMPORT, PROC FORMAT, PROC UNIVARIATE, MERGE and SET

statements.)

. Advanced Modelling experience with marketing Data sourced from Sales Data, Customer intelligence data and other response and purchased Data.

. Extensively used Macro programming in SAS/MACRO for creating macro

variable and to automate the repetitive task using macro programming

language, and to modify existing SAS program for ease of modification

using the debugging tools like MPRINT,MLOGIC, SYMBOLGEN while maintaining

consistency of results.

. Involved in coding and pulling data from various oracle tables using

Unions and Joins.

. Calculate the one-way frequencies, multi-way frequencies for counts of

variables and table analysis using PROC FREQ with LIST, OUT, MISSING

options.

. Marketing analytics, Customer Intelligence, Market research and Campaign

management

. Great interpersonal skills, the knack of communicating effectively, the

ability to present in any sort of forums and the capacity to lead in

crunch situations with the flexibility to be a team player in any role.

. Experience with SAS MA and CRM framework with knowledge in Automation in

and outside the SAS platform suite.

. SAS/ Base, SAS VA and SAS EG, Proc SQL, Excel, Excel VBA, Excel macros

and the rest of the Microsoft suite towards great programming coupled

with presentation skills.

Computer Skills

Languages and R,SAS, SAS EG,SAS VA, Proc SQL, Macros, SQL, Python,

tools: Matlab

MS Office suite: Word, Project, PowerPoint, Excel and Visio

Databases: Teradata13.0/12.0/V2R6.2/V2R5, Oracle 10g, DB2, MS-SQL

Server 2000/05/08, MS Access

Operating Windows and UNIX

Systems:

Professional Experience:

SAS Marketing Analyst, CISCO, NC

May 15 - Till

Now

. Worked with Marketing managers for defining privacy policies inside and

outside the country,

. list generation for Eloqua email campaigning, dashboards of opportunity

identification and performance tracking in a production environment.

. These Dashboards Consisted of multiple Complex Visualizations, Custom

Categories, Calculated items, complex interactions and so on.

. Developed Best practices and standardization documentation for the VA

Reports across the acquisition project and the marketing team .

. Ran analytics function such as Contact profile building, clustering,

segmentation, scoring models, behavior forecasting as well as business

level objectives such as ROI, spend forecasting, service touchpoints

forecasting and so on.

. Developed BIC, Adjusted Wallet, P2B and other models .

. Generated lists for Marketing groups based on Campaign responses, social

handles, event attendees, Database customer segmentation etc.

. Designed CI strategy to enhance customer experience as a whole.

. Acquiring contacts from different vendors like DnB, Avention and other

vendors based on the strategy.

. Developed customer Personas based on various contact information.

. Built Dashboards in SAS VA to visualize the performance and function of

this strategy.

. Built Dashboards for individual groups to help visualize opportunity,

performance and other analytics for individual marketing groups as well

as the organizations.

. Worked on using multiple data sources ranging from oracle, TerraData and

Hadoop Data source to build recurring code to implement in Dashboards .

. Set File triggers on the LASR server along with loading acquired data

from remote SAS engines to the LASR server and the HDFS systems.

. Worked with marketing groups to integrate and consolidate the content

based on the strategy.

. Managed Campaigns in Eloqua for various campaigns and identified touch

point opportunities to optimize customer life cycle value as they moved

along the various journeys.

SAS Data/scientist Merchandising/Marketing Office Depot,OfficeMax, FL

Jan' 13 - May 15

. Ran extensive and Ad-hoc analyses using R, Tableau and SAS EG and EM.

. Extracted and reported data using Cognos report studio and query studio

while exercising my SQL skills on a Teradata DBMS.

. Worked with Multi channel marketing Data from Google analytics,twitter,

Eloqua etc

. Setting up Goals and creating Google analytics reports for tracking

customer behavior on retail website.

. Trained and assisted business users, merchants and vendors on the newly

developed Data and setting up documentation and Data dictionaries.

. Built processes using enterprise minor with response models and bursting

reports with the gained knowledge though the process.

. Integrated and set up automated analytics and reports from parallel

legacy data systems (OfficeMax and Office Depot).

. Used SAS PROC SQL pass through facility to connect to tables and created

SAS datasets using various SQL joins such as left join, right join, inner

join and full join.

. Report generation on providers using VBA, Proc Tabulate, Proc UNIVARIATE,

Proc MEANS and Proc REPORT.

. Once the Dataset is clean, Applied Proc survey select to separate certain

records from the Main dataset for Training and Testing purpose.

. Using system options and system Debugging options while crating macros.

. Designed Surveys for conjoint analysis; handled NPD data for private

brand analysis.

. Tactical analytics to resolve dollar impacts of circulation, digital

media promos and other channels and study impacts of events on sales

using various regression models.

. Digital attributes marketing based on a conjoint analysis.

. Vendor incentive models using supply / demand tables and sales

prediction models.

. Digital and promotional marketing analytics experience with building

response models for email circulation, digital advertising and

promotional circulation effectiveness with CRM modules.

SAS Marketing Analyst, Comcast, PA

Feb'12 -

Jan' 13

. Collaborated with multiple departments for their analytical needs in

multi production environment in areas such as Database Marketing,

Segmented Pricing and Attrition Prediction.

. Customer Intelligence, Market research, Campaign management, Consumer

trends, product segmentation, ROI study and other marketing analytics to

support complete product lifecycle.

. Lead Campaigns and automated marketing functions based on Customer

Intelligence Data.

. Further, developed BI reports that provided predictive analytics &

Reporting with dashboards on analyst performance, client activity, future

workload & anomalies based on data collected from discrete applications.

. Data extraction and integration from different sources, used R and SAS

SQL procedures

. Performed data preparation and transformation using SAS procedures to

ensure data quality Used SAS and SQL to perform ETL from Oracle and

Teradata databases and created SAS datasets, SAS macros, Proc/data steps

and SAS formats as required.

. Data processing and validations extensively on the SAS datasets in EG

using edit check programs.

. Dealing datasets using SQL joins and unions for the scenarios raised with

the project.

. Finding the duplicate records from the large volumes of data using

'Distinct' keyword and assigning indexes for the Key variables using SQL.

.

Developed reports as per business requirements and created various reports

like summary reports, tabular reports, excel reports etc.

. Converted programs from Teradata SQL to SAS to automate the monthly

production processes.

. Developed macros for report generation using SAS/Macros as per business

requirements.

. Developed programs for statistical analysis and data displays.

SAS Developer Analyst, Travelers Insurance Companies CT

Sept'10 - Feb'12

. Developed predictive models and conducted statistical analysis using SAS.

Applied Proc Means, Proc Freq, logistics, summary, transpose, univariate

and compare.

. Worked with data step options: INFILE, MISSOVER, TRUNCOVER, FIRSTOBS,

WHERE, IF, THEN, ELSE, KEEP, DROP, and RENAME amongst other for importing

and modifying raw data files.

. Created SQL views for retrieving dynamically changing data and to save

system storage space.

. Built summary reports after identifying the customers, their occupancy

period and the revenue generated using PROC SUMMARY, PROC MEANS and PROC

FREQ.

. Worked on existing SAS/Macros for data validation by checking data

distribution & comparing to standard data. Developed SAS programs for

several verticals including risk & marketing teams.

. Accumulate, decipher and present models and data to senior management

conclusively.

. Lead Analyst in overseeing certain products from reviewing project

requirements and submitting measurable work efforts, conducting research

and analysis, to writing technical documentation for Web Developers.

. Work with multiple users for collaboration and deployment of new

environments.

. Collaborate with multiple users in the company for SAS programming

documentation.

. Coordinate with EIT department and internal users for successful

deployment of new process.

. Identify problems & maintain log to rectify them in consultation with

implementation partners.

Quality Engineer, SMR Automotive, Marysville, MI

May'09 -

Aug'10

. Set component production targets to minimize inventory and diminish down

times and better implement 'Just In Time' manufacturing and distribution

using SAS SQL

. Failure prediction and production design for six sigma quality.

. FMEA analysis and Design of experiments to understand statistical

significance of different modes and the Resulting analytics for ROI

decisions.

. Built logistic decision trees and applied neural networks to optimize

decision making in the global supply chain department.

. Used SAS Macros and Excel Macros to standardize inventory control

decisions and procurement decisions (Supply Chain Management).

. Developed customer segmentation for company marketing using cluster

analysis.

. Developed SAS programming tool on raw data for use in reporting and

analysis. Cleaned, Integrated and Built model based on this Data.

. Evaluated the results and worked with IT to implement the reporting in

production systems.

. Developed programming using SAS ODS to produce XML reports for the web

reporting.

Education

MS Analytics, Harrisburg University of Science and Technology

BE Mechanical Engineering, Anna University

Contact this candidate