Payal Bordia *** Mountainview Drive, Wayne, PA 19087 adbk5v@r.postjobfree.com 704-***-**** Professional Summary
Analytics professional with a Master in Earth Sciences and educational training in Business Administration and Life Sciences. Skilled in quantitative techniques for research & analytics, statistical modeling, management information systems, market research and project development. A quick learner of domain technicalities and possess well-developed communication, planning, critical thinking, and problem-solving skills. A team player as well as a strong individual contributor seeking to work on intellectually challenging projects.
Technical skills
Relational Database: Oracle SQL Developer 4.1.4, MySQL 8.0 Data analysis in IBM SPSS Statistics 25
Statistical modeling using Python 3.7.0, R 3.4.0
Python libraries: Pandas, NumPy, Scikit-learn, Matplotlib Statistical methods: Predictive analytics, Hypothesis testing, Unsupervised & Supervised Machine Learning Algorithms Data visualization: Tableau 10.5
Proficient in MS Excel: Pivot tables, Lookups, Macros, Dashboard Geospatial technology skills: ArcGIS Desktop 10.5, ENVI 5.2 Reference management: Mendeley, EndNote
Education Qualifications
Master of Science (Earth Sciences) May 2018 University of North Carolina, Charlotte (UNCC) [GPA: 3.48/4.00] Related coursework: Fluvial Geomorphology, Hydrologic Processes, Isotope Tracers in Contaminant Hydrology, Ecological Engineering, Environmental Laws & Business of Restoration, Geographical Information System (GIS), Remote Sensing, Spatial Statistics using R Programming, Earth Sciences Research Project
Certificate in Environment Planning & Management December 2012 Center for Environment Planning & Technology
(CEPT), Ahmedabad, India [GPA: 3.00/4.00]
Related coursework: Environmental Impact Assessment, Environmental Risk Assessment, Environmental & Social Management Framework
Master of Business Administration April 1999 Tolani Institute of Management Studies, Adipur, Gujarat, India [GPA: 3.30/4.00]
Related coursework: Organizational Development, Research Methodology, Quantitative Techniques & Operational Research, Financial Management, Marketing Management, Marketing Research & Information Systems
Bachelor of Science (Zoology) April 1997 St. Xavier’s College, Ahmedabad, India [GPA: 3.14/4.00] Professional Experience
ANALYST & DATA SCIENTIST (Freelancing), WAYNE, PA, AUGUST 2019 – PRESENT
Knowledge & skill enhancement: Enrolled in DataCamp Track – ‘Data Scientist with Python and R’
Creating Machine Learning models for predictive analytics using open source datasets
Employing parametric models, ensemble learning techniques for optimal accuracy Environment: Python, Numpy, Pandas, Matplotlib, Scikit-learn DATA MIGRATION ANALYST, PRESS GANEY, CHARLOTTE, NC, FEBRUARY 2019 – JUNE 2019 Press Ganey Associates Inc. support health care providers in understanding and improving the entire patient experience by delivering secured survey analytics to different stakeholders of the healthcare organizations.
Worked on an organization wide data migration project (Qualtrics to Confirmit): data extraction, data auditing, reconciliation and exception reporting, optimal system planning for new system setup, dashboard setup
Applied concepts & knowledge of business workflow, survey data analytics, client servicing for data profiling, data mapping and data validation to setup new dashboards
Involved in the teams Status Reporting, Issue and Change management
Developed best practices documentation and standards Environment: SQL, Tableau, Qualtrics, Confirmit, MS Excel VBA Page 2 of 2
DATA ANALYST, RANG TECHNOLOGIES, JUNE 2018 – JANUARY 2019 Rang Technologies Inc. is into IT Consulting & Staffing. I contributed in developing case studies in the area of data analytics & machine learning.
Exploratory data analysis using Python libraries (Pandas, Matplotlib, Seaborn) and creation of supervised machine learning algorithms (using TensorFlow, Keras) on different open source data sets to understand optimal data modeling and forecasting
Database modelling for SQL & NoSQL projects
Environment: SQL, Tableau, Python, R, SPSS, MS Excel GRADUATE RESEARCH ASSISTANT, UNIVERSITY OF NORTH CAROLINA, CHARLOTTE, OCTOBER 2015 – MAY 2018
Executed the first phase of a high temporal resolution Urban Water Resources research project of Mecklenburg County, North Carolina aimed to access the impact of Green Infrastructure Practices [Low Impact Development (LID), Storm Water Best Management Practices (BMPs)] during different phases of landuse change
Performed quantitative research with extensive Literature review, Data Collection, Student training, Geospatial and Statistical Analysis leading to benchmark findings from the first phase feeding into the 10 yearlong study
Exploratory data analysis of 5-minute interval stream discharge data of three years, paving way to Data Modeling & Big Data Analytics
Employed Water Balance Analysis, Groundwater Level and Soil Moisture Data Analysis, Flow Duration Analysis, Statistical modeling of Hydrological Transport, and Mass Balance Analysis of 27 Water Quality Constituents
Employed remotely sensed data, such as, Digital Elevation Models (DEM), high-resolution imagery, geospatial database to analyze landscape metrics using ENVI and ArcGIS
Environment: SPSS, Python, R, SAS, MS Excel, ArcGIS, ENVI, Mendeley, Endnote, Grapher (GoldenSoftware) MANAGEMENT CONSULTANT, INDIAN PRIVATE SECTOR COMPANIES, 2000-2006 Worked in the areas of Management Information System, Client servicing, Market research, Corporate training. Environment: SAP Crystal Reports, MS Access, MS Excel, SPSS Research skills
Project: Hydrology and hydrological transport in a sub-urbanizing Piedmont watershed Supported by: Charlotte-Mecklenburg Storm Water Services Statistical methods: Hypothesis testing, Shapiro-Wilk Normality test, Log transformation, Kruskal-Wallis H test, Tukey’s range test (post hoc analysis), One-way Analysis of Variance, Uncertainty analysis, Regression analysis Deliverable: Creation of hydrology and hydrological transport profile of a representative Piedmont watershed for time-series and comparative analysis to ascertain the impact of low-impact development practices in urban-planning Link: https://github.com/PayalBordia/Water-Quality.git Data Visualization Project in Tableau
Objective: Distribution of American Universities across the geographies as per Funding source, Institution type, Urbanization, Degrees provided, Average tuition & Total Enrollment Tableau Public dataset: American University 2013
Skills employed: Calculated fields & Parameters, Aggregation & Granularity, Hierarchies, Joining & Blending, Clustering Deliverables: Interactive & Insightful Dashboards, K-mean cluster analysis to derive University Ranking as per Total Enrollment & Funding Sources; Average Tuition & Funding across the different geographies of America Link: https://public.tableau.com/profile/payal.bordia Communication & Leadership skills
Team-building of students for Water resources project and taught laboratory research course in Physical Geography to 75 Bachelor of Science students at UNCC
Participated in the 3MT ((3-Minute Thesis presentation) on November 10th, 2017 at UNCC
Presented the Graduate Research Project at:
20th Annual Conference of NC Water Resources Research Institute (WRRI) at Raleigh on March 14, 2018
[Presentation title: Impact of Urbanization on Water Quantity and Quality – A live case study]
UNCC 18th Annual Graduate Research Symposium (GRS) on April 6, 2018 [Presentation title: Impact of Urbanization on Water Quantity and Quality – A Watershed Management approach]