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.

TECHNICAL SKILLS:

Languages and tools: R,SAS, SAS EG,SAS VA, Proc SQL, Macros, SQL, Python, 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 Systems: Windows and UNIX

PROFESSIONAL EXPERIENCE:

SAS Marketing Analyst

Confidential, NC

Responsibilities:

• 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

Confidential, FL

• 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 ( Confidential 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

Confidential, PA

• 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

Confidential, CT

• 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

Confidential, Marysville, MI

• 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.