Fullerton - Data Analyst

6+ years of experience in CRM and Business Intelligence implementation, data analysis, visualization and data driven reporting for the management. Exceptional understanding of business operations and analytics tools for agile problem solving. I have a passion for troubleshooting complex issues by applying my analytical approach.

STRENGTHS AND EXPERTISE
Tools/Languages: SQL, Python, Tableau, Oracle SQL, MySQL, PL/SQL, SOAP UI, Shell script, Oracle Siebel
CRM, R, ForecastPro, Oracle BI, Oracle People Soft, Connect CRM, Excel, Access, Visio

* Automated email campaigns through the Connect CRM system for international admissions process.
* Configured import jobs for file-based integration, and prepared SQL queries for ad hoc reports.
* Automated reports, built dashboards, and implemented integration for processing admissions data.
* Utilized Excel tools such as pivot table, slicers, macros, charts to create dashboards for the management.
* Used Google analytics for tracking survey and campaign data to generate leads for recruitment prospects.
* Used R programming for data analysis, processing, cleaning, reporting and creating visualization.

* Designed an SDLC for a mobility iOS application integrated with Oracle Siebel CRM and Tableau.
* Developed data models, KPI's and created interactive BI dashboards for the global level stakeholders.
* Created and executed SQL queries to ensure adequate expertise and data quality of the key deliverables.
* Successfully executed A/B testing to compare the performance of the new version of the application.
* Conducted gap analysis of the deliverables and communicated with the respective stakeholders.
* Analyzed transaction logs to fine-tune the SQL queries which improved the system response by 25%.

Subject Matter Expert

* Delivered development and production support for Oracle Siebel CRM by implementing the requirements and solving critical issues in Production to improve the performance of the SLA by 30%.
* Maintained an Oracle RDMS by writing complex SQL, stored procedures and business service scripts.
* Gathered and analyzed existing data, enterprise server logs, third party logs, DB logs for complex RCA.
* Gathered data from multiple sources using XML, flat files, csv for examination to discover key insights.
* Proposed strategies to improve the business by adopting best practices and data driven decision making.
* Implemented workflows, created web services, and business objects to integrate with external systems.
* Managed meetings with cross functional teams to discuss the critical challenges and resolution strategies.
* Created upsert/query XML requests in SOAP UI to investigate problems in the web service response.
* Extracted and analyzed big data from over 40 countries to discover the top data issues and their impact.
* Implemented solutions to reduce the overall issues by 25%; documented them in a gap analysis report.
* Analyzed trends in sales transactions and recommended business solutions to improve the sales by 15%.
* Improved business relations with the priority 5 customers by reducing their issue resolution time by 50%.

COURSE PROJECT
* Created a regression model using Python to create a prediction model that helps to control the energy consumption by sending the daily 24-hour consumption forecasts.
* Used Python for data preprocessing, aggregation, testing accuracy and implementing prediction.
* Created Tableau visualizations to detect outliers, linearity checking and diagnosis of the ML model.
* Analyzed data by using visualizations created using Matplotlib, Seaborn libraries of Python.
* Manipulated data using NumPy, pandas, stats model libraries to get the data ready for the processing.
* Interacted with a relational database from within Python to perform ETL using SQL.

CRM/BI Developer

Find out detailed information about Abhinay Sariswal, Fullerton - Data Analyst 

Abhinay Sariswal: Fullerton - Data Analyst

Abhinay Sariswal

California State University

Tata Consultancy Services

Tata Consultancy Services

California State University Fullerton