Experienced Data Analyst/Data Scientist with experience in Statistical data Analysis, modeling, data visualization and reporting of big data related to digital advertising Healthcare, manufacturing and energy industry verticals. Specialties : R, SAS, Tableau, Oracle (SQL, PL/SQL), PostgreSql, Pig, Informatica, Data Analysis, Performance tuning Currently pursuing Master's degree in Predictive Analytics from North Western University and Highly interested to work in Internet industry vertical.

Optimization Engineer/Data Scientist @ Statistical data Analysis, modeling, data visualization and reporting of big data related to digital advertising. Use of pig and hive to retrieve the data from Hadoop cluster, PostgreSql and Sql to retrieve data from Postgress,Oracle and Greenpulm distributed database. Use of Tableau and Microsoft Excel for reporting and data visualization of daily click trends, advertiser revenue, and user demographics. Use of R and SAS to do significance test, multivariate regression, time series analysis and cluster analysis. Analyze the email user click history and third party data for pattern recognition and to support targeting algorithms. Use of python,html,php for developing simple front end to help finance team to load budgeted and forescasted data into the database From May 2013 to Present (2 years 8 months) Kansas City, Missouri AreaETL/DwH Analyst Programmer @ Design, develop and maintenance of data warehouse. Analyze the health care data to identify and prioritize health care opportunities. Adhoc report generation using Sql queries, tableau and Microsoft excel to visualize the data. Use of Informatica and Cognos decision stream to load data into the data warehouse and use of Autosys and TWS to schedule the ETL's. Monitoring the data flow through Informatica monitor, resource consumption in HPPM tool and analyze session log to identify and the performance bottle necks in ETL mapping and PL/SQL queries. Use of indexing,parallelism,partitioning concepts and tuning queries for resolving performance bottle necks From March 2012 to May 2013 (1 year 3 months) ETL Analyst @ Design, develop and maintenance of data warehouse. Use of Informatica and Cognos decision stream to load data into the data warehouse. Use of Autosys and TWS to schedule the ETL's.Use of SQL/PLSQL queries for Data Quality Analysis. From August 2010 to March 2012 (1 year 8 months) Bengaluru Area, IndiaInformatica Developer @ Design and development of ETL mappings to load Energy, manufacturing and Aviation data to data warehouse using Informatica. Scheduling the ETL's using Informatica scheduler. Performance tuning and resolving performance Bottlenecks in PL\SQL queries, ETL mappings using Parallelism, hints, Partition, indexing, push down optimization concepts. From October 2008 to August 2010 (1 year 11 months)

Bachelors of Engineering @ Visvesvaraya Technological University From 2004 to 2008 Master's degree, Predictive Analytics @ Northwestern University Ashwin Rai is skilled in: ETL, Data Warehousing, Data Analysis, SQL, Oracle PL/SQL Development, Informatica, Performance Tuning, Autosys, Data Modeling, Unix Shell Scripting, Business Objects, Business Intelligence, SAS, Analytics, Oracle