Data analysis and visualization

ABHINAY SARISWAL

*****************@*****.*** +1-657-***-**** https://www.linkedin.com/in/abhinay17 Fremont, CA MS in Information Systems graduate with 6+ years of experience in implementation of CRM, Business Intelligence, data analysis, visualization, and business reporting. Exceptional understanding of business processes, operations, and analytics tools for problem-solving. Passion for leading cross-functional discussions with multiple vendors and analyzing large datasets. EDUCATION

Master of Science in Management Information Systems and Decision Sciences Aug 2017 – May 2019 California State University, Fullerton, CA

Bachelor of Technology in Electrical and Electronics Engineering Jul 2008 – Jun 2012 Sikkim Manipal University, India

STRENGTHS AND EXPERTISE

Core Skills: Data Cleaning, Visualization, Problem solving, Automation, Change Management, Complex Issue troubleshooting Tools/Languages: Python, R, Tableau, IBM SPSS, Oracle SQL, MySQL, PL/SQL, SOAP UI, Shell script, Hobsons CRM, Oracle Siebel CRM, ForecastPro, Oracle BI, Oracle People Soft, Microsoft Excel, Microsoft Office, Microsoft Visio PROFESSIONAL EXPERIENCE

ERP/IT Analyst Intern - Cal/Amp Wireless Network Corporation, Irvine, CA. Feb 2019 – May 2019

Legacy data extraction through SQL server, and supporting in go-live coordination of ORACLE Cloud for SCM.

Testing and developing of supply chain management and financial BI reports, dashboards, and technical writing.

Technical activities involving ERP application integration through SOA Cloud service, and master data management. Data Analyst - California State University, Fullerton, CA. Oct 2017 – May 2019

Automated email campaigns and generated leads through the Hobsons CRM system for international admissions process.

Configured import jobs for file-based integration and prepared SQL Database queries for setting alerts and ad hoc reports.

Built reports, dashboards for expediting business decisions and documented them in BPGs.

Analyzed historical data to create data strategies for improving the business by conducting location-based marketing fairs.

Extracted data from ORACLE PeopleSoft and used R programming for data cleaning and visualization to get data insights. Subject Matter Expert - Tata Consultancy Services –– Bengaluru, India. Nov 2015 - Jun 2017

Managed an IT team to provide business solutions to Novo Nordisk, a world leading pharmaceutical company.

Designed an SDLC comprising of an iOS application integrated with ORACLE Siebel CRM and Data Warehouse.

Developed KPIs and created interactive BI dashboards that provided actionable insights to the global level stakeholders.

Developed a road map and deployed a new ERP system in 15 countries within 8 months using agile and scrum frameworks. CRM/BI Developer/Support Executive - Tata Consultancy Services – Bengaluru, India. Jun 2012 – Oct 2015

Solved critical issues in production using ORACLE CRM and improved the SLA performance by 30%.

Improved login transaction processing time by 60% by performing complex RCA and implementing configuration changes.

Analyzed the business requirements, developed and deployed them within SLA to provide effective ERP/BI solutions.

Maintained dashboards and ORACLE RDMS by writing complex SQL, stored procedures and business service scripts.

Created update/query XML requests in SOAP UI to investigate problems in the web service response.

Served as the primary point of contact for the critical 5 customers and successfully revived the business relations by ensuring data quality of exports, efficient issue resolutions and zero escalations. Academic Research Projects - California State University, Fullerton, CA Household Appliance Energy Consumption Feb 2018 – May 2018

Implemented a predictive regression model using Python to control the weekly household appliance energy consumption.

Used R programming for data preprocessing, aggregation, transformation, testing accuracy and implementing prediction.

Created Tableau dashboards and visualizations to detect outliers, and diagnosis of the regression model. Titan Beer Inventory Purchase and Transportation Proposal Sep 2018 – Nov 2018

Created ARIMA forecast models by examining the seasonality, trend, and autocorrelation of 50 months of beer sales data.

Selected the best forecast model by evaluating MAPE and RMSE accuracy measures and proposed the next 12 months inventory purchase plan to handle the supply and demand to manage limited warehouse storage capacity. Teen Drug Usage Control Jan 2018 – May 2018

Cleaned data using R, created Tableau charts to see the factors effecting drug usage of eighth and tenth grade students.

Used IBM SPSS for merging multiple files and creating classification model to predict the likelihood of quitting drug use.

Contact this candidate