Data Analyst Entry

RITU GOTHWAL

***********@*****.*** 646-***-**** Issaquah, WA

CAREER OBJECTIVE:

Enthusiastic data analyst with a PhD degree in Mathematical Environmental modeling. Earned a certificate from UC Berkeley’s Data Analytics and Visualization course. Intellectual curiosity and analytical skills to find patterns within large sets of structured, semi-structured, and raw data. Finds great satisfaction in coding, mathematical/statistical modeling and problem solving. Meticulous, creative and an effective team player. PROFESSIONAL SUMMARY:

• Technical expertise for data models, monitor key metrics, intuitive dashboards, data mining and segmentation techniques and apply to concrete technical outcomes.

• Responsible for detail architectural design and data wrangling, data profiling to ensure data quality of vendor data, Source to target mapping.

• Expertise in feature engineering, feature selection, EDA using NumPy, Pandas, matplotlib, seaborn, scikit-learn in Python.

• Well versed with SQL DML & DDL queries, Views, Stored Procedures, Aggregated functions. Can create a pipeline, ETL process for SQL database.

• Experienced in Data loading using SQL Scripts.

• Experience in Data transformation and Data mapping from source to target database schemas & data cleansing.

• Skilled in System Analysis, E-R/Dimensional Data Modeling, Database Design and implementing RDBMS specific features.

• Technical expertise designing intuitive dashboards in Tableau with pie-chart, Heat maps, dual axis, waterfall chart, publishing and presenting dashboards on web and desktop platforms.

• Familiar with AWS Services, power BI, SAS.

• Hand on working experience in machine learning and statistics to draw meaningful insights from data.

• Hands on experience in Machine learning algorithms such as Linear, Logistic Regression, Decision Tree, K-means, clustering, Time series analysis, A/B Testing.

• Excellent communication skills for storytelling to key stakeholders, problem-solving skills, High attention to detail.

• Excel Analytical skills with V-looks ups & pivot tables, Power point presentations.

• Interacted with several Stakeholders, Clients, and Vendors from different regions around the world over the years for better understanding of the processes and expertise in gathering technical requirements.

• Worked on generating ad hoc report and analyzing the data for fixing the errors and expert taking initiatives in taking technical decisions.

• Highly analytical and process-oriented analyst with in-depth knowledge of database. Furnish insights, analytics and intelligence used to advance opportunity identification, process reengineering and growth of the organization.

• Experience in using Tableau for the data visualization by connecting it various database like MySQL, MS Excel, etc.

• Proven track record of creating highly effective, dynamic and data- driven solutions.

• Expertise in analyzing and querying large and complex data sets using MySQL.

• Capable of working independently or in a team with the ability to use sound judgment balanced with unmatched integrity, and professionalism.

• Expertise in analyzing large and complex data sets using SQL, Tableau, and other quantitative and statistical modeling technologies and tools.

• Proficient in designing interactive dashboards and analytical reports using Tableau, MS-Excel.

• Handling complete range of project: Data collection, research on the subject,reporting, analysis, dashboards.

TECHNICAL SKILLS:

Data Science Tools: Pandas, Exploratory Data Analysis, NumPy, Jupyter Notebook, VS Code, RStudio Data Visualization: Tableau, Matplotlib, Seaborn, multivariate test, Scikit-learn, Excel, Plotly Statistical Methods: Predictive Analysis, Hypothesis Testing, Statistical Inferences, Descriptive Statistics Languages: SQL, Python, MATLAB, HTML, CSS, SQL, R, C++, JavaScript Building Data Science Models: Machine Learning, Neural Network, Time-Series Forecasting, Data Preprocessing, Linear & Logistic Regression, Decision Trees, Model Performance, Anomaly Detection, K Means Clustering, A/B Testing

Applications: GitHub, MongoDB, MySQL, PostgreSQL, GIT, Tableau, Excel, Big Data, Hadoop, Spark, Web Scraping, Natural Language Processing

EXPERIENCE

International Water Management Institute (IWMI) (August 2021 – December 2021) Role: Consultant/Research Analyst

Research Project: Modeling Antimicrobial Resistance in Water Phase 2 (CGIAR AMR Hub-IWMI) Roles and Responsibilities

• Collaborated with cross functional team in support of identifying appropriate data and models to predict the antibiotic resistance in water environment.

• Performed research to summarize the state of art knowledge in the field of environmental modeling.

• Determined the proper research methods for the implementation of conducted research.

• Performed statistical and analytical methodologies to solve the environmental problems within specific areas of expertise.

• Collected, combined, cleaned and organized data from multiple sources in relational database then delivered information as per requirements.

• Provisioned data to external team, enabling collaboration between different research teams for developing methodologies and models on the subject.

• Produced high quality reports and presentations.

• Written and published highly technical research articles. University of Washington (August 2021 – November 2021) Role: Lab Assistant/Volunteer

Roles and Responsibilities

• Data entry for the chemicals and instruments consumables.

• Managed the environmental laboratory, ordering, negotiating, and dealing with the vendor,

• Assisted research students with their experiments, calibrated and troubleshooted the analytical instruments in laboratory.

Indian Institute of Technology Hyderabad (January 2012 –November 2017) Role: Doctoral Researcher

Roles and Responsibilities

• Planned and executed independent research through design, data collection, analysis and dissemination.

• Performed vast literature survey and extensive research and data collection.

• Created, collected cleaned, and analyzed data set.

• Determined research methods which included the implementation studies, qualitative research, secondary data-analysis, design of the experimental studies, and randomized the controlled trials.

• Developed, evaluated and integrated the environmental datasets.

• Worked on data profiling and data validation to ensure the accuracy of the data between the source systems.

Vitya Consultants Pvt. Ltd, (August 2010 – January 2012) Role: Design Engineer

Roles and Responsibilities

• The project followed the Agile methodology.

• Participated in brainstorming sessions with the government officials in all phases of the project to understand the requirements to design and purpose of the project.

• Collaborated with end users, project stakeholders and support partners to identify needs, goals, and models.

• Carried out research to designed water supply pipeline for the eight towns in India with environmental and technical knowledge.

• Prepared initial screening reports, authored detailed technical reports.

• Performed detailed Financial Analysis based on the Cost estimation. EDUCATION

• Data Analytics and Visualizations Certificate, (May 2022 – November 2022), University of California Berkeley Extensions

• Doctoral Research (PhD), (January 2012 – August 2018), Indian Institute of Technology Hyderabad

• M.Tech, (May 2009 – August 2010), Indian Institute of Technology Delhi PROJECTS

• Water Quality Forecasting

Created a tool to forecast the water quality index of lakes of King County, WA. Employed time series analysis using ML.

GitHub: https://github.com/gothwalritu/Water-qualtiy-predictor-with-time-sereis-forecasting Role: data analyst and Machine Learning model developer; Tools: Python, Machine learning models like Neural Network regression and time series forecasting model using Scikit-Learn, Skforecast, Statsmodel, Tableau, R, applied statistics.

• Webpage Application

Created a webpage to display the results of a research project. Created an interactive dashboard which could display information on any selected sample.

GitHub: https://github.com/gothwalritu/gothwalritu.github.io Role: Sole author; Tools: JavaScript, CSS, HTML, Github

• Talent Retaining at Pewlett-Hackard-Analysis

Developed an entity-relationship diagram (ERD) and Schema, identified the employee who will be retiring and the number of employees who are eligible for mentorship. GitHub: https://github.com/gothwalritu/Pewlett-Hackard-Analysis Role: Sole author; Tools: QuickDBD, PostgreSQL, pgAdmin, SQL

• Bike Sharing Data Analysis and Visualization

Citibike NYC Bikesharing data analysis to make a case to convince investors that bike sharing business in Des Moines is a lucrative proposition.

GitHub: https://github.com/gothwalritu/bikesharing Role: Sole author; Tools: Tableau, Power BI, Pandas, Python

• Statistical Study of Automotive Parts with R

Performed multiple linear regression analysis to identify which variables in the dataset predict the mpg of prototypes. Collected summary statistics on the suspension coils from the manufacturing lots. t-tests to decide if the manufacturing lots are statistically different from the mean population. Designed a statistical study to compare vehicle performance of the vehicles against vehicles from each manufacturer. GitHub: https://github.com/gothwalritu/MechaCar_Statistical_Analysis Role: Sole author; Tools: R, Statistical analysis

Contact this candidate