SUMMARY

• Over 6 years of successful Business/Data analyst career in domains of CRM/Banking/Loyalty/Retail.
• Experience in analyzing Customer data/campaign data/feedback data and text analytics data for customer/business insights for decision making.
• Mastered in identifying/analyzing demographics vs measures analysis of data and road map to insights identification.
• Extensive experience in implementing descriptive statistics like mean/median/mode/variance/standard deviation/ dispersion for very good understanding of data.
• Implementation of advanced statistical methods like regression (linear/logistic), clustering (K - means/hierarchal), decision tress and time series forecasting techniques using RealStats-2007 in Excel and using SAS/R/Rapid miner.
• Good in importing data into excel from various sources like MS Access/SQL Server/Text Delimited Files/Hive/From API’s.
• Very good experience in data base design, data pipelining, data preparation for greater response of data.
• Extensive experience in cleansing data in excel and formatting data to structured data by analyzing at row/column level.
• Strong in building relations ships between data and building summarized data using business logics and data manipulation.
• Mastered in excel in writing simple to complex formulas using lookup’s, advanced if conditions etc...
• Very strong in building and analyzing of reports in excel using pivot/power pivot tables and building reports/dashboards using linked sheets formulas.
• Strong in depth experience in finding the insights and identifying win/loss analysis by applying business logics and visualizing using conditional formatting.
• Created/automated drill down/drill up reports using linked formulas and subtotals in Excel & Tableau.
• Very good in creating visual reports along with charts like histograms, pie charts, box plots and line charts.
• Good in creating interactive reports by using data validations and lookup’s.
• Good in making bench marks for data for understanding and cross validation of reports/insights.
• Exposure in writing basic VBA programs for most commonly used repetitive works.
• A can do nature attitude towards work and take initiatives in completing things.

TECHNICAL SKILLS

ETL Tools: SQL Server Integration Service (SSIS), SAS

Database: MS SQL Server 2012/2008R 2/2008/2005/2000 , MS Access, Oracle

Reporting Tools: SQL SERVER REPORTING SERVICES, Tableau, Alterian and Excel

Languages: SQL, T-SQL, PL/SQL, VBA and R

OLAP Tools: SQL SERVER ANALYSIS SERVICES

Other Tools: Visual Studio, SQL Server Management Studio, Rapid miner, Hadoop hive, PIG, Sqoop, Base SAS and Advanced SAS

Dimensional Modeling: Kimball & Inmon

Predictive Modeling: Regression, Clustering and Time series

Digital Marketing: List extraction, A/B testing, Email Marketing, ROI calculation, Lift

Operating Systems: Windows XP, Windows Vista, Windows 7 & UNIX

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst

Responsibilities:

• Interaction with technical teams and pulling up camapigns data into Excel.
• Involved Analyzing of target vs control groups for camapigns success rate.
• Creating incremental revenue and incremantal customes of each camapign.
• Performing exploratory data analysis with various demographical data and facts.
• Created various reports like non-performing/performing camapigns with charts.
• Created Google fusion tables for geographical analysis of success rate and measures to be takes.
• Analysis of feedback data from various sources and validating each customer data by going back to his/her transaction history.

Environment: Excel-2013, SQL Server 2012, MSBI (SSIS, SSRS & SSAS), Dot net, IBM Unica.

Confidential

Senior Data Analyst

Responsibilities:

• Performing ETL jobs by pulling data from SQL server into Alterian tool.
• Validating of customer master and transaction master data for accurate data load.
• Played majot role in creation of very frequently used variables by writing complex macros using Alterian Iloader.
• Involved exporting customer data/camapign data for analysis in Excel for reporting.
• Automated incremental revenue calculation of individual camapigns.
• Written VBA scripts for data gather and report generations.
• Took part in advanced machine learning tecniques for data scientists by performing Exploratory data analysis(EDA).

Confidential

Business Analyst

Responsibilities:

• Importing data from SAP CRM into FTP on weekly basis as delimited text files.
• Loading of incremnetal Transaction data into SAS environment using macros.
• Validating of ETL process and cration of temporary/permanent tables by executing macros.
• Creation of weekly/monthly reports channel wise.
• Frequently checking CRM health by applying discriptive statistics and customer base.
• Major role in automation of monthly/weekly list of campaign lists as tables for effectiveness calculation.
• Autoamtion of reports using SAS report procedures like Proc report, Proc Tabulate, Proc Frequency and Proc Means.
• Automation of more than 200 reports monthly.
• Model building for crunching the customers into segments using clustering techniques.

Environment: SAS 9, SAP CRM, Excel, Zeta Interact, Filezilla, Windows 7. s & s:

Confidential

Responsibilities:

• Importing data from SQL DB into FTP on weekly basis as delimited text files by deploying SSIS packages.
• Loading of incremnetal Transaction data into SAS environment using macros.
• Validating of ETL process and cration of temporary/permanent tables by executing macros.
• Creation of weekly/monthly reports channel wise.
• Frequently checking CRM health by applying discriptive statistics and customer base.
• Major role in automation of monthly/weekly list of campaign lists as tables for effectiveness calculation.
• Autoamtion of reports usinf SAS report procedures like Proc report, Proc Tabulate, Proc Frequency and Proc Means.
• Automation of reports like store/region/city/fraud/products.
• Model building for crunching the customers into segments using clustering techniques.

Environment: SAS 9, SAP CRM, Excel, Zeta Interact, Filezilla, Windows 7. s & s:

Software Engineer

Confidential

Responsibilities:

• Created tables, indexes, constraints, views, materialized views, procedures, Cursors and functions etc for data base accessing.
• Developed and deployed various SQL server Integration services packages for Data base pulling using techniques like Blk copy and Bulk insert.
• Deployed various packages to subset data branch wise and region wise for faster access.
• Created offline and online data marts for each department to access data.
• Automation of monthly/quarterly reports with multi dimensional views by qrtirng SQL server reporting services.

Environment: SAS 9, SAP CRM, Excel, Zeta Interact, Filezilla, Windows 7.