SUMMARY

• Around 8 years of experience in analyzing ecommerce, digital, telecom, finance and healthcare data, creating tables, listing and generating reports using various tools.
• Hands on experience in utilizing a variety of data sources and software tools such as SQL, Tableau, SAS, R, Python and Excel to help develop low to medium complexity analyses and campaigning reports to advise our clients regarding sound business decisions.
• Developed reports and custom analysis based on specifications provided by the client or the client analytical lead, document new and existing reporting processes.
• Supported with FTP, ETL process on a variety of ad - hoc analyses along with preparing analysis datasets from SQL server, Oracle, DB06, Teradata and Hadoop databases.
• Supported business team and clients with efficient reporting with scheduling and configuring CRON jobs and dashboards by data mining, data discovery, and quality control tasks.
• Utilized knowledge and experience in B2B, e-commerce or digital marketing (Includes various channels like email, mail, display, direct, paid search and social); SQL, SAS, Tableau and R program or similar programming languages.
• Followed System Development Life Cycle (SDLC) (Waterfall and Agile) methodology for the design, development, testing, and implementation of various analytical programs and modules.
• Extracted site data from Adobe (Omniture), Webtrends, Localytics and other analytics tools to provide context to digital online performance and to depict the KPI reports.
• Worked effectively with Credit and finance data and ensured data integrity. Provided support in the design and implementation of ad hoc requests for Credit-Related Portfolio Data.
• Managed and prioritized incoming ad-hoc requests, analyzed the available data and translated results into actionable dashboards to uncover insights around digital initiatives and to help improve effective decisions.
• Experienced in working with Extracts, live data, using action filter, user filters and Level-of-Detail (LOD) expressions. Developed customized reports using various chart types.
• Followed standard guidelines of Identity access management to secure sensitive PBM data.
• Developed numerous Teradata SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins, Using Date Function, String Function and Advanced techniques like RANK and ROW NUMBER functions.
• Developed programs and achieved competency in statistical data analysis with R and Python programming using various libraries (e.g. RCurl, Rsitecatalyst, httr, jsonlite, plyr, RODBC, and Pandas).
• Proficient in SAS/BASE, SAS/MACRO, SAS/SQL and many other SAS procedures like report, means, freq, tabulate, regression in Windows and UNIX environment with desktop and server version.
• BuiltTableauVisualizations with single, multiple tables, stories using custom SQL with interactive drill downs options and parameters by connecting to various Data Sources; Relational Databases.
• Strong Experience in programming, debugging, analysis, validating SAS/R/Python codes/data (e.g. Transactional, customer, demographic data), report automation and report generation in SAS, SQL and R programming environment to streamline the report creation process.
• Helped in building or facilitate statistical models that will enhance our customer strategy using SAS (9.3/9.4), proprietary Data integration (DI) and data mining tools.
• Developed and delivered written reports of the analytic findings in a variety of formats (PDF, RTF, PPT, including visualization of data and findings), formulated recommendations, and effectively presented the results to potential non-analytic audiences.

TECHNICAL SKILLS

Databases: Oracle, DB06, EDW, Teradata, MS Access, Hadoop, SQL, Flat files, Citrix- Oasis and Velos.

Business Tools: Tableau, SAS, SQL Assistant, R programming, Python, SAS Enterprise Guide/Studio, Apache Hive, BI Reporting tools (Net Acumen, SAP Crystal Reports and Business Objects, OBIEE and MicroStrategy); Web analytics tool (Webtrends, Adobe Omniture, Coremetrics, Google Analytics); Proprietary CRM tool Klondike; Acclaim. Microsoft Office (Access, Excel, Visio, Word, PowerPoint, Access and Outlook), and Filezilla, Secured shell SSH.

Operating Systems: Windows, UNIX, Mainframe DOS, Mac.

PROFFESIONAL EXPERIENCE

Confidential, Woonsocket, RI

Sr. Data Analyst/ Tableau Developer

Responsibilities:

• Performed in-depth analysis for the front store team from end-to-end which includes understanding the business needs and translating to analytic requests, extracting data from a variety of sources like Teradata, oracle, manipulate and analyze using quantitative, statistical, and visualization using tools like Tableau, SQL assistance, SAS programming and other statistical and web analytics tools
• Built, published customized interactive reports and Tableau dashboards, report scheduling using Tableau server. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• MTS (Mind the store): Under this project, worked extensively in creating many automated Tableau dashboards like Extracare Send to card, Weekly Ad, Digital circular, which essentially reported Sessions, Users, Page views of different traffic sources like Paid search, Email campaigns and social for various platforms which included Desktop Web, Mobile web and app by comparing year over year data.
• Developed Key Front Store KPI dashboard of various platforms including Desktop, Mobile Web & App traffic on a weekly basis for this year Vs last year.
• Digital Flash Sales Report: Created weekly, monthly and yearly report for Actual Vs Forecast data for the following Outcomes, KPI’s and Ecommerce metrics- visits, conversion rate, orders and sales.
• Involved in automation of creating Tableau dashboard throughout the project by writing R script to pull the API data, SAS and R script to populate the data in Teradata and finally developed a custom SQL and essential visualization in Tableau.
• Developed Tableau workbooks from multiple data sources using data blending and interactive views, trends and drill downs.
• Involved in data collection methods, data mining, data discovery, creating instruction manual, document design or development procedure and quality control tasks for making business decisions and resolving analytical problems using R programming, Adobe(Omniture), SAS and Webtrends.
• Prepared analysis datasets from Teradata/Oracle database by writing SQL codes to present statistical and non-statistical results using charts, bullets, and graphs in meetings to audiences such as clients and business stake holders.
• As an end consumer of the data, evaluated the statistical methods and procedures used to obtain data to ensure validity, applicability, efficiency, and accuracy that is necessary to enable the analytics by working closely with the product team and the development team.
• Established and automated post deployment reporting and analysis based on the success metrics. Created reports for business and product teams with insights for post deployment performance.

Environment: Tableau 10, SQL Assistance, Adobe, R programming, SAS, Webtrends, BI tools, Teradata/EDW.

Confidential, Irving, TX

Sr. Technical Data Analyst/ Tableau Developer

Responsibilities:

• Served as the primary point of contact for the VDSI employees for the Mass Markets platform, provided insights and recommendations as to get specific data for analysis.
• Involved in campaign planning, contributed by determining the technical feasibility and analyzed the data availability for the segmentation of the specified targeting, using SAS and SQL assistance.
• Conceptualized and developed direct marketing strategies and reports using Tableau that addressed the ever changing industry dynamics of the wireless market.
• Modified SAS and Shell scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata. Involved in troubleshooting the production issues and providing production support.
• Supported identification and prioritization of additional data needs beyond what was currently available. Created requests for data expansion within standard warehousing and refined BI tools to make maximum use of available data.
• Developed qualitative and quantitative analysis by synthesizing data from multiple sources to identify trends in overall performance in various multi-channel environment and implementation partners.
• Modified existing SAS macros, SQL procedures and report logics to suite changes in requirement and addressing ad-hoc requests using SAS, Tableau and R programming.
• Generated and studied reports for the lead lists created and the codes used for the campaign using SAS procedures and SAS Macros along with using Ultra Edit, F- Secure SSH Client to support list requests.
• Times Contacted - Analyzed how certain customers behave depending on the times they were sent promotions in a given time frame.
• Created Multiset, temporary, derived and volatile tables in Teradata database. Implemented Indexes, Collecting Statistics, and Constraints while creating tables.
• Developed and maintained the Crontab Entries for scheduling the daily, weekly, monthly jobs
• Worked on Unix Shell Scripting for automating logs, for user created table backups and for checking daily log. Created pivot tables and queries in Excel by getting data from Text files and Teradata.
• Developed SAS programs to extract data from various data sources, cleansing, analyzing and reporting of data, including sophisticated data manipulation for ad-hoc requirements and for creating customized listings.

Environment: SQL Assistance, Tableau 9, R programming, Hadoop Hive, SAS 9.3/Unix, TRM, Secured shell SSH, MARS, MS-Excel, MS-Access, BI tools, Teradata/ Flat files/EDW.

Confidential, Menomonee Falls, WI

Sr. Technical Analyst

Responsibilities:

• Developed reporting that can track portfolio performance across all stages of the account lifecycle e.g. credit lines, collections, over limit authorizations, fraud etc.
• Created reports for the measurement of campaigns executed through direct mail, email, mobile, and all new customer-addressable communication channels.
• In conjunction with strategy team, developed reports to inform future test plans and identify new campaign opportunities. Performed pre-campaign analytics for planned campaigns which identifies opportunities for campaign development through customer lifecycle analytics.
• Assisted in expanding credit card customer base and revenue streams as well as capital investment initiatives by performing ROI analyses.
• Responsible for the preparation of month-end reports (scheduling those using CRON commands), reconciliation of accounts, and communication of variances to various strategic teams as appropriate.
• Involved in creating Tableau reports for various teams like compliance, fraud, program development and legal to define targeted customer segmentsbased on age range, cycles and various variables associated with different projects.
• Involved in forecasting the internal statement Inserts/gift card Statements in order to track the potential lift in customers purchasing and improving the revenue.
• MVC (Most Valued Customers) report: Analyzed the customer behavior over a particular period of time in various aspects like amount spent and time frame.
• Auto Pay Customer Detail: Developed an analytical report on the Auto Pay Customers to see the profitability based the customer behavior before and after their in enrollment of Auto Pay.
• Developed and implemented SAS scripts to perform End-to-End testing for transferring the data files from one source to another source in secured and encrypted format.
• Autopay enrollment/de-enrollment report: Prepared and analyzed the data which was used to complete the monitoring event to track the credit impact related to the AutoPay product implementation.

Environment: SAS 9.3 Windows/Unix, Tableau 8.1, Python, MS-Excel, MS-Access, BI tool, Oracle/ Flat files/EDW.

Confidential, King Of Prussia, PA

SAS Programmer/ Tableau Developer

Responsibilities:

• Monthly Benchmarking Reporting for the client - These reports helps identify how the Client’s customer database is performing and trending over time. Refreshed the SAS data marts on weekly basis for different brands. Scheduling different process using crontab scheduler.
• Weekly Data Capture Reports - Prepared reports that identify how brick and mortar locations are performing in regards to name/address/email capture.
• Campaign Reporting - Measured sales and response of clients marketing promotions (Direct and Email), which the client can use to measure effectiveness of their campaigns and ROI. Assisted in developing ongoing mailing strategies to increase response and revenue.
• Created Web and Customer Dashboards - Created report which provides the web and Customer Key performance indicators, segmented by new and repeat visitors (Web) and new and repeat customers. It gives insight to the clients to improve marketing tactics.
• Marketing Acquisition and Customer Churn Reporting - Prepared reports to show new and repeat customer breakdown by Channel for report month, year over year. Also, prepared summarized report to provide year to date customer counts to calculate the churn along with standard KPI’s.
• Cross Purchasing Reporting - Examined which merchandise categories associate with purchasing in other categories, increase cross-sell and up-sell rates and maximize store/catalog/web site layouts.
• Attrition Reporting - Segmented customers based on buying trends, also by focusing on the number of customers being acquired and lost annually to develop strategies to reduce attrition and increase customer retention.
• Incremental Profit Score Model- Incremental Profit score represents the expected contribution of a customer after receiving a promotion versus that individual’s expected value in the absence of a promotion. This allows for the optimization of promotion ROI, by isolating only those customers that are predicted to provide incremental sales.
• Conducted research in consumer - In retail landscape evaluation and in market studies, to develop predictive models improve customer reach and product placement. Created a model incorporating social media data into customer analytics. Developed a market test to determine pricing elasticity of various product offerings.
• Best Customer Score Model- the Best Customer Score is a forecast of a new customers future value, using attributes captured on that customer’s initial visit to the brand. This provided a marketer with a tool that can be used to cultivate high value customers through targeted promotions, rewards and loyalty initiatives.
• Assisted in developing response models & profitability models to score and rank customer data for Direct Marketing Projects using SAS based Multivariate Statistical Techniques.
• To perform the aforementioned specific project tasks, I utilized knowledge of SQL querying, Statistical analytical system (SAS) Programming and proprietary Confidential database tools, and data manipulation along with the knowledge and experience with building SAS datasets, data management, data analysis, and statistical and regression methods.

Environment: Tableau, SAS 9.4 Windows/Unix, Python, Confidential Proprietary tools: Klondike, Acclaim, BI tool, Toad, MS-Excel, MS-Access, Oracle/ DB06/Teradata.

Confidential, Farmington Hills, MI

Data Analyst /Programmer

Responsibilities:

• Developed performance report, looking at approval rate, booking rate, bad rate as per tiers assigned, comparing expected versus actuals.
• Identification of any credit policy or regulatory exception and making changes to the automation code as required.
• Developed analytics and predictive scoring models to optimize credit operations. Created impactful business rules and KPIs through classification, regression testing, demand forecasting and anomaly detection analytics.
• Ran monthly, quarterly application and acquisition cube, denovo datasets, loss reports.
• Transformed and scored datasets for monthly reports as required for scorecard monitoring.
• Validated and Monitored risk model performance and collection model performance and determined factors for better performance of the business.
• Reinforced the analytical foundation by creating various reports which involved: Population Stability Report (PSI), K-S Statistic, Performance Reporting (beta), Cures by Scorecard, Characteristic Analysis Report
• Worked with statisticians in generating SAS analysis datasets, production of data listings, summary tables, and statistical analyses.
• Extracted required data from various data sources to local SAS Environment by SAS FTP and sync sort.
• Insight analysis based on the results generated from reports and providing solutions.
• Cleaned and validated data warehouse datasets used for scorecard development. Created new datasets, variables, dropping unwanted variables as required as per discrepancies found during validation.
• Verified fraud indicators with the ACE System for the most severe fraud value assigned to the applicants.
• Quality control and assurance including running datasets/files through programs.

Environment: SAS 9.2 Windows, Tableau, SAS/base/macros/sql/access/stat/graph, MS-Excel, MS-Access, Oracle, Teradata.

Confidential

SAS programmer

Responsibilities:

• Modified/developed SAS codes for data cleaning and Reporting and to support routing processing.
• Involved in Performance Reports, Capacity planning and generated reports for online and batch applications for various servers.
• Developed data tables and reports results on accounts or household values and customer profiles are obtained by merging and summarizing data using SAS.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Maintained the client’s income and expenditure details and also generates detailed reports regarding financial transactions, sales details, and purchase details, operating costs.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Provided all data analysis, ad-hoc and custom reporting of customer data. This involved extracting data from an Oracle database, XML files, and Flat files data used as input for SAS programs to create Excel spreadsheets, Access databases, and hard copy reports.
• Performed Statistical Analysis with Statistical procedures and Univariate procedures from Base SAS and SAS/STAT.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analysis.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.

Environment: SAS/BASE, SAS/SQL, SAS/ACCESS, MS Excel, MS Power Point, Window, Oracle, DB2, UNIX, SAS Enterprise Guide.