SUMMARY

• An adroit analytical professional with 8+ years of experience in Data Analysis, Digital Marketing, Email marketing, Campaign analysis, Campaign history management, Data extraction, Data management & BI solutions.
• Good in understanding business requirement & implementing Database solutions & Database marketing.
• Extensive knowledge in Banking/Retail/E - commerce/CRM/Loyalty Program domains.
• Experience in designing BI solutions and customer analytics using machine learning algorithms.
• Strong knowledge in identifying fraud transactions by conducting advanced analytical techniques.
• Good in calculating repeat rate/churn rate/win back/profiling analysis.
• Very good in implementing up sell/Cross sell campaigns and automation of campaign process.
• Love to work on customer analytics to increase client ROI and Brand Name.
• Experience in analyzing customer product journey by evaluating series of products purchased.
• Good in creating new variables and KPI’s.
• Expertise in using Alterian DDV/Alterian Iloader, KXEN, Advanced SAS, R, MSBI, SQL 2008 R2-2012, Tableau& Advanced Excel with VBA.
• Automation of campaign list extraction and validation and campaign response (lift/incremental revenue) using Alterian Iloader/SAS Macros.
• Fine experience in building advanced reports/dashboards in Excel using Power Pivot and lookup formulas, with Tableau using Data blending and quick filters, with Alterian DDV using Cross tabs, with SAS using PROC’s and with MSBI-SSRS using wizards.
• Good understanding in Data Warehouse concepts such as Star Schema, Snowflake Schema, OLTP,OLAP and Multi-dimensional Models for query and analysis
• Good in building advanced reports using linked sheets in Excel, Tableau & SSRS with colorful charts.
• Expertise in writing complex SQL queries using multiple join conditions/store procedures/sub queries.
• Strong in data architecture for quick access of data and in writing query optimization and performance tuning.
• Good in importing data from multiple sources such as Flat files/CSV/Excel, ODS/ODBC connections & Web applications.
• Exposure to IBM Unica & MS CRM
• Very good in data cleansing with MS-Excel with VBA & Documentation.
• Big data analytics with Apache Hadoop & R by using various R packages.

TECHNICAL SKILLS

NoSQL Databases: Hbase

Statistics: Descriptive Statistics, Probability distributions, Statistical Inference and Hypothesis testing

Visualization: Tableau & Excel

Machine Learning Algorithms: Classification, Clustering, Decision trees

Data mining & Business intelligence tools: Tableau, Rapid miner

Operating Systems: Microsoft Windows, Mac, Linux (Red Hat Ubuntu)/Unix

SDL Alterian: Alterian DDV/Iloader/KXEN.

SAS Programming: SAS9x, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ODS.

Programming: R, SQL,PL/SQL/VBA

Databases: Oracle, Microsoft SQL, MYSQL, MS Access, SQL Query Analyzer.

Big Data: Apache Hadoop - Map Reduce, Sqoop, Hive, PIG, Hbase, HDFS, Zookeeper, Flume, Oozie.

PROFESSIONAL EXPERIENCE

Confidential, Edison, NJ

Specialist Master

Responsibilities:

• Loading of data into SDL Alterian that is imported from text files using SDL Alterian Iloader by writing advanced Macros.
• Creating advanced Iloader scripts in creation of various pre-defined variables for and database links.
• Maintenance of customer information and incremental load from server.
• Automation of weekly/Monthly data load reports by usual data base checks.
• Designing Databases and table relations for the use of team.
• Performing database performance tuning by executing proper actions and query performance.
• Resolving data load issues by taking proper actions and reducing the percentage of performance.
• Automation of customer list extraction for campaigns based on medium of communications.
• Performing exploratory data analysis (EDA) to have proper understanding of data.
• Building KPI’s for cross verification, creating summarized data views for building reports/Dashboards using Alterian DDV.
• Performing traditional analysis like profiling of customers, segmentation of customers, favorite product, customer product journey, Drill down/drill up reports using profiling, Cross table cross tabs.
• Analyzing of top most performing cities & non performing cities based on population using Alterian cross table crosstabs.
• Automation of campaign response calculation like % response with Control base, lift and Incremental Revenue.
• Maintaining history campaign tables for frequency of contact analysis & distinct campaign responders.
• Identifying fraud transactions and extracting customer list for further actions.

Environment: SDL Alterian, R, SQL Server 2012, SAP CRM,MSBI-SSIS, SSRS, SSAS, MS-Office 2013, Filezilla & Windows 7

Confidential, New York, CA

Senior Data Analyst

Responsibilities:

• Weekly/monthly meeting for checkup of new campaigns/report design.
• Converting business requirement into technical requirement and building the solution.
• Data import from SQL server by executing designed/deployed SSIS package weekly.
• Performing Incremental data load using SAS macros with database skills.
• Automation of data loading/data load report using SAS Macros.
• Designing of regular reports to complex dashboards using SAS and Excel.
• Performing database tuning regularly by removing unwanted tables (temp tables) and variables.
• Designing of campaign execution process with specific format for campaign identification.
• Campaign history management for advanced customer analysis/campaign analysis.
• Automation of campaign list extraction with specified fields using SAS macros & response calculation.
• Analysis of customers for holding the control group for calculating the campaign effectiveness.
• Building variable creation for data modeling using advanced SAS.
• Building data model in SAS based on requirement.

Environment: Dot net, SQL Server 2012, SSIS, SSRS, SSAS, Filezilla, Secure-FTP, Base SAS 9.2, Advanced SAS

Confidential

Senior Data Analyst

Responsibilities:

• Requirement gathering from client.
• Conversion of business requirement into technical and validation.
• Weekly/Monthly meetings for CRM health and new campaign designs along with Hygiene campaigns.
• ETL automation and ETL report using Alterian Iloader Macros.
• Design & automation of Weekly/Monthly reports & dashboard.
• Store reports/fraud reports/enrolment reports/product level reports automation.
• Daily campaign response calculation report for campaign effectiveness.
• Updating of campaign tracker for no.of campaigns daily based on medium.
• Tracking the works done to client on daily basis by assigning JSR’s.
• Advanced analytics implementation for potential customers to do cross sell/upsell campaigns using “SAS”.

Environment: Alterian DDV, Alterian Iloader, Dot Net, SQL Server 2008 R2, SSIS, Filezilla, FTP, KXEN, MS-Excel.

Confidential

Business Analyst

Responsibilities:

• Advanced analytics implementation for potential customers to do cross sell/upsell campaigns.
• Creating recommendation engines for favorite places of booking tickets for journey.
• Data import/cleanse from text files from FTP to server and loading into SAS libraries.
• Performing incremental data load with SAS macros weekly.
• Designing reports/dashboards based on client requirement using SAS PROC statements.
• Automation of reports/dashboards using SAS Macros/linked sheets in Excel.
• Management of data and new variable creation scripts.
• Campaign history management and campaign effectiveness calculation.
• Adhoc analysis/reports for client.
• Point based analysis of customers to vary with front end points of customers.
• Analysis of feedback data of customers gathered by various sources like tele calling/direct talks/email.

Environment: SAS 9.2/SQL Server 2008 R2/FTP/Filezilla/Google Fusion tables/Java/MS-Excel