JAYSHREE WASNIK

Phone: 510-***-**** Skype: j.wj.w818 Email: ac7yzd@r.postjobfree.com

LinkedIn: linkedin.com/in/jwasnik GitHub: github.com/jayshreeuw

PROFESSIONAL SUMMARY

Data Analyst with 3+ years of professional experience in interpreting and analyzing the data for driving business solutions using SQL, R-studio, Python, VBA macros, Advanced Excel, Tableau, Power Query, Power Pivot, Domo

Extensive knowledge in writing T-SQL (DDL and DML) Queries to improve the database performance and availability; meet reporting requirements using Joins, Sub-queries, Nested queries, Window functions, Aggregate functions, Pivots, case statements etc.

Rich Experience in managing entire data analysis project life cycle and involved in all phases, including data extraction, data cleaning, data visualization and data analysis with large datasets of structured and unstructured data

Strong experience in using Excel, Power Pivot and VBA macros to dump the data and analyze the data for various business cases

Expertise with Advanced Excel and Power Query, including experience with arrays, nested formulae, index/match, v-lookups, and pivot tables

Expertise on Tableau Desktop to design and deploy rich graphic visualizations with Drill down and Drop-down menu option by using Parameters

Hands-on experience with creating solution driven dashboards by developing different chart types including Heat Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Line Charts, Area charts, Scatter Plots, Box plots and Histograms in Tableau Desktop

Working knowledge on business intelligence technologies tools such as SSIS, SSRS, reporting and querying tools, Data mining and Spreadsheets

Working experience in Statistical analysis and Hypothesis testing, Anova, Regression Analysis, Cluster Analysis, Sample Determination and A/B test

Excellent presentation skills, including the use of meaningful charts, graphs, or other data visualizations to convey information and results clearly and concisely

Passionate about explaining data science and statistics to non-technical audiences and developing stories around data

Strong analytical, problem troubleshooting/solving skills, self-starter, good team player, highly self-motivated and quick learner

Excellent ability to perform checks on data quality for sense, consistency and accuracy

TECHNICAL PROFICIENCY

Database : SQL Server, Oracle SQL, SQLite

Operating Systems : MS Windows 7/8/10, MacOS

Languages : R-studio, SQL, Python, SAS Base

BI Tools : Tableau, Domo, SPSS, Power BI, Power Query, Power Pivot

Other Packages : MS Word, MS Excel, VB Macros, PowerPoint, Google Docs/Spreadsheets

PROFESSIONAL EXPERIENCE

Business Analyst at FIRST ASSOCIATES LOAN SERVICING LLC, San Diego CA

Concentration (BI, ETL, Data Analysis, Reporting & Automation) Apr 2018 – Present

Projects:

1) Automation of monthly Invoices generation and dashboard reporting

2) Database development and maintenance of data from heterogeneous sources

3) Metrics development and maintenance of analytical reports to address specific business

questions

Responsibilities:

Collect and organize the data coming in encrypted (pgp) format from FTP location; raw data files are received in txt, csv, xml formats, manage the daily size of data around 80-90 GB

Decrypt the data files into csv format and recommend the suitable tools and methodologies to analyze the data

Responsible for loading, extracting and validation of client data; write SQL queries to clean and manipulate data for data loads and extracts

Drill down and deep dive into data to find root causes of trends, identify the KPIs, etc. used to drive strategic improvements

Develop analytical databases from complex financial source data; create dynamic reports and dashboards using advanced excel and DOMO

Perform ETL operations using Domo and Power Query such as validate fields, convert null values, perform joins, generate aggregates, sorting, derive new calculated fields, concatenate columns etc

Automate the invoices generation, monthly flow of data, organize and maintain the data pipeline

Analyze the use of alternative data to enhance existing processes, monitor the automated loading processes

Analyze raw data, perform preliminary analysis and develop recommendations

Monitor the data for accuracy levels, conduct data audits and create data reports

Carry out specified data processing and statistical techniques to meet the client requirements

Research, define and deploy BI improvement opportunities and streamline the business intelligence processes; Analyze and implement better performance strategies

Data Analyst (SQL/Tableau) at ZILLIONIX LLC, Fremont CA Sep 2017 – Mar 2018

Projects:

1)Data Analysis, Dashboard development and Reporting analysis

2)Metrics development for different functions of business and Data visualization for decision making

Responsibilities:

Extract the information from databases in a variety of different formats such as csv, txt, .xls etc.

Convert and store data from these sources into back end databases such as SQL and write queries to retrieve the data

Collaborate with end user to understand their data reporting needs and dashboard requirements and use Tableau to develop reports, dashboards and compelling data stories

Create pivot tables and charts, clean the data and perform exploratory analysis

Research, compile, analyze and report various operational data from multiple sources

Meet with the user of the report, determine the requirements, understand where the data is located and design the process to retrieve the data

Create and maintain databases using data from multiple sources, Built dashboards for measures with forecast, trend line and reference lines

Interface between raw data sources and front-end reporting services using table linking, embedding, import/export and file conversion techniques

Produce and distribute monthly, quarterly, and annual reports, etc. and prepare ad-hoc analysis as requested

Prepare reports, analysis and presentations, update existing tableau dashboards

Intern (Data Analyst - Sustainability Office)

California State University East Bay, Hayward, CA, USA Sep 2016 – Jun 2017

Projects: Data Collection and Reporting Analysis on STARS (AASHE project)

Organize and consolidate the data from existing databases, design new methods for data collection

Perform data cleaning and manipulations; prepare the data for final analysis

Create and maintain Sustainability Purchase database for campus using SQL queries, building and updating tables

Create highlight tables, visualizations and dashboards for campus sustainability data on Tableau

Data collection and analysis on STARS (Sustainability Tracking Assessment Rating System) project which is a framework for measuring sustainability performance of campuses and universities

Predictive modeling on Sustainability scores of research universities and campuses: Developed a multiple regression model for Sustainability scores of Universities in USA, Canada and Mexico

Successfully reduced the model error by 20% and improved the model’s predictive power by explicitly including additional independent variables

Statistical Analyst / Instructor

Sydenham Institute of Management Studies (University of Mumbai), India Aug 2010 – Aug 2015

Queried, cleaned, updated, organized the raw data files and made them ready for analysis

Devised methods for identifying data patterns, trends in available data and create tables from structured data sources by querying data repositories

Created multiple visualization dashboards using Histograms, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.

Designed survey research studies including questionnaire development, sample selection, checking survey results, conducted statistical analyses and data reporting

Additional duties included writing technical reports and making presentations based on survey data, survey development and implementation, monitoring of data collection, and sample management

Applied statistical techniques to analyze large amounts of data, and prepare reports of their results; Prepared conclusions and predictions based on data summaries

Extracted, cleansed, manipulated, and prepared data for analysis, Provided insight into data presented and offered suggestions on possible improvements

Coded and analyzed data, generated the output and presented final report. Statistical packages used: R-studio, SAS, SPSS, Used SQL and Excel for data cleaning

Statistical techniques used: t-test, Chi-square test, Regression models, Cluster Analysis, ANOVA

Executive Research Analyst

Feedback Business Consulting Pvt. Ltd., Mumbai, India Aug 2008 – Nov 2009

Conducted exploratory and diagnostic analysis to study patterns and demographics for customer satisfaction studies

Developed questionnaire, suggested data collection strategies to the field team and monitored the data quality and checks at every stage

Analyzed, interpreted and converted statistics into charts and graph reports to present findings at client meetings

Analyzed results of customer satisfaction surveys and presented reports to the management

Utilized spreadsheets and statistics to analyze significant patterns within clients' customer bases

Presented the results of complex analysis in easily understandable Excel and PowerPoint documents, allowing clients to quickly engage with the findings

Monitored the field work team, also conducted phone interviews and face-to-face interviews with respondents to ensure data consistency and data integrity

Analyzed data on SPSS using various statistical tools: Descriptive statistics, Cluster Analysis, Simple linear regression, Chi-square tests & cross-tabulations, T-test, ANOVA and Factor analysis

Prepared final reports and power-point presentations, made recommendations based on the statistical findings and present it to the clients

Reduced 60% customer complaints and improved customer satisfaction levels to 5/5 by resolving issues and concerns.

EDUCATION

California State University East Bay (California) (June 2017): Masters in Statistics

Concentration – Computational Statistics

University of Mumbai (India) (June 2006): Master of Management Studies (Marketing)

Amravati University (India) (June 2003): Bachelor of Engineering

PROJECTS

Model Building for Housing Prices in Boston: Performed regression Analysis and assumptions to analyze the dataset using PROC REG and built a linear regression model for housing prices as dependent variable.(https://github.com/jayshreeuw/Model-building-for-housing-price-using-SAS)

Tests performed: Linear regression, Normality, Linearity, Breusch-pagan, Forward selection (SAS)

Exploratory analysis of Bay Area Bike share data: Coded and performed exploratory analysis on Bay area bike share dataset to study the riding behaviors of bikers such as duration of trips on different days and hours during the day.(https://github.com/jayshreeuw/Exploratory-Analysis-on-Bay-Area-Bike-Share-Data)

Visualizations performed on Matplotlib library on Jupyter notebook (Python)

Prediction of survival of passengers on Titanic: Conducted exploratory analysis, created visualizations, coded, analyzed and predicted which passengers were likely to survive this tragedy.

(https://github.com/jayshreeuw/Prediction-of-Survival-of-passengers-on-Titanic)

Tests performed: Logistic regression using SKlearn library, Descriptive statistics tools (Python)

Prediction of Prices for Toyota Corolla: Prepared the data for analysis, created visualizations, coded, analyzed and predicted the prices for Toyota corolla cars based on the independent variables such as; age of car, horsepower, number of doors, color, features etc. (https://github.com/jayshreeuw/Prediction-of-prices-for-Toyota-Corolla)Tests performed: Linear regression using SKlearn library, Descriptive statistics tools (Python)

Contact this candidate