SUMMARY:

• Overall 10+ years of experience in Data Analytics and 4+ years of building Big Data data - intense applications and products using open source frameworks like Hadoop, PIG, HIVE, Sqoop, Apache Spark, Apache Kafka, Storm, Apache Mahout, Revolution R Software
• Worked closely with marketing, risk management and operations business teams to build large scale analytical applications and products
• Experience in Designing digital marketing campaigns using A/B testing methodology
• Hands-on-Experience in measuring marketing campaigns performance based on business KPIs
• Developed predictive models, targeting and segmentation models based on consumer behavior data, transactional data, campaigns data to improve the future campaigns performance
• Hands-on-Experience in using Analytical tools like SAS, R, RStudio, Python
• Used variety of data sources from of Big Data platforms to mine and analyze massive amounts of data for identifying consumer trends and patterns and brining real-time insights, created dashboards for management
• Experience in designing and developing data pipelines to load production data into AWS S3, AWS EMR and AWS Redshift and creating analytical datamarts and using PIG, Hive for reporting

TECHNICAL SKILLS:

Analytics & Machine Leaning: Predictive modeling, targeting and segmentation, forecasting, Recommendation Systems, Regression, Regularization, Neural Networks, Clustering, Collaborative Filtering, Decision Trees, Bootstrapping, Fuzzy Logic

Big Data Frameworks: Hadoop, Hive, PIG, Sqoop, AWS, Apache Spark, Apache Kafka, Storm

Analytics Tools: Base SAS 9.2, SAS/Macros, SAS/STAT, SAS EG, SAS DI Studio, R software, RStudio, Revolution R, MATLAB, Tableau V8 and V9, VBA

Technology Stack: JAVA, Python, Teradata Tools, Oracle, MySQL, AWS S3, EC2, EMR, Redshift

EXPERIENCE:

Confidential, San Francisco, CA

Data Scientist

• Building Payments application which consolidates across all payment types and creating relationship among different payer & payee and payment types
• Wrote Hive UDFs and Tableau to query data and creating dash boards
• Used Sqoop to import and export data into Hadoop cluster from/to RDBMS which includes Teradata and MySQL and Oracle DBs
• Used Neo4J, D3.js to create payer & payee relationships and visualizations using payment transactions
• Used JAVA to write map reduce jobs to process & clean 8 billion payment transactions
• Used Fuzzy matching and text mining algorithms to match the Payee names to Dun & Brad street business names
• Worked on R & D projects from POC to inception of the business problems and across the teams to gather data required for the projects

Confidential, San Jose, CA

Big Data Analytics Consultant

• Designing IM Loyalty channel campaigns and measure the performance using A/B testing methodology, measuring campaign performance on important KPIs - #Buyers, #Bought Items, GMB, #New and Reactivated buyers
• Designing & Measuring the A/B tests for eBay Seller campaign programs and recommending the strategy based on incrementality in GMV, SI, ASP and other financial KPIs
• Tracking and measuring Click-through rate, view-trough rates and other conversion metrics
• Creating Tableau dash boards for visualization of data and metrics and refreshing the metrics on daily and weekly basis
• Worked on Seller acquisition campaigns to target the Large merchants, regular merchants and occasional merchants based on GMV and volume of selling
• Applying bootstrapping methodology to find the proper and robust control groups to compare the performance with test groups of campaign
• Identifying the best B2C and C2C segments to target based on Open Rate and Click Rate
• Providing the bench mark and base line metrics for site emails and marketing emails
• Used PIG and Hive to query the events data from Hadoop platform and wrote ETL custom scripts using Teradata tools like BTEQ, FastExport, FastLoad etc., for automating the daily jobs.

Confidential, San Jose, CA

Data Scientist

• Experience as Web Analytics Instrumentation Analyst to test and validate website traffic post-instrumentation and creating quality scores of instrumentation for PayPal products
• Used Big Data platforms to mine and identify the outliers and anomalies in the data
• Created dashboards using Tableau to communicate trends in major KPIs including page views, page impressions, clicks and other web KPIs
• Creating dashboards to management using Tableau with metrics containing spend, clicks, 24hr click GMB, iGMB, iRev, ROI, etc.,
• Identifying the top performing publishers based on GMB, Bought Items and other metrics for optimizing spend and display advertising operations
• Finding the difference in site visits between test/control groups throughout the campaign
• Working with directly with BU for identifying the analytical solutions for business needs
• Automating and Scheduling the Billing and Payment Reports including ETL processes using Base SAS, SAS/Connect, and SAS/Access, and Scripting, SQL scripting

Confidential, Redwood City, CA

Big Data consultant

• Designing marketing campaigns and measuring campaign performance on important KPIs - Response Rate, #Buyers, #Bought Items, Revenues for Shutterfly family brands
• Providing campaign datasets to Unica operations team for execution of email campaigns - batch email, trigger email, holiday email campaigns
• Developed data pipeline processes to load production data into AWS and created datamarts in Redshift using PIG, Hive and used Tableau to create dashboards
• Used A/B testing methodology to understand the which creative, email best based on the Response Rate, Revenue
• Used SAS, MySQL, Oracle DB data sources to build predictive models based on customer data, transactional, historical and campaigns data
• Used Hadoop, Hive, PIG along with SAS and R analytical software for creating summarized data marts for statistical modeling and customer segments

Confidential, San Francisco, CA

Big Data Consultant

• Designing and developing weekly and monthly reports to find trends and patterns in the client’s data using advanced mathematical and statistical techniques.
• Continually scrub data as new information becomes available (e.g. no PPM or other required documents).
• Produce ongoing customized reports as requested by respective businesses.
• Deliver reports and ad-hoc analysis focused in the area of client behavior and profiling using SAS, SQL and Excel.
• Conducting statistical analysis and building models related to client attrition and assets attrition.
• Build Linear Regression models to estimate the Retirement return for those cohorts who left money in their 401(K) plan.
• Conducting statistical inference tests on marketing and promotional offer clients to check the performance of promotions and effect to overall business.
• Build Look-A-Like models (clone models) to identify the control group cohorts and then evaluating and comparing these groups with test cohorts groups to find the effect in Attrition Rate and Statement Balances mortgages.
• Build Logistic Regression models to identify the control group cohorts using SAS/STAT and other SAS modules.
• Slicing and dicing internal, external data sources like Acxiom, IXI and mortgage data from CoreLogic to better understand client behavior and segments.
• Build time series models using ARIMA techniques for cash optimization for HYIC, HYIS using market variables, internal data and external data.