Candidate Information Title Data Analyst Target Location US-PA-Wayne Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes

Page 1 of 2Payal Bordia 606 Mountainview Drive, Wayne, PA 19087 EMAIL AVAILABLE PHONE NUMBER AVAILABLE Professional SummaryAnalytics 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 skillsRelational Database: Oracle SQL Developer 4.1.4, MySQL 8.0 Data analysis in IBM SPSS Statistics 25Statistical modeling using Python 3.7.0, R 3.4.0Python libraries: Pandas, NumPy, Scikit-learn, Matplotlib Statistical methods: Predictive analytics, Hypothesis testing, Unsupervised & Supervised Machine Learning Algorithms Data visualization: Tableau 10.5Proficient in MS Excel: Pivot tables, Lookups, Macros, Dashboard Geospatial technology skills: ArcGIS Desktop 10.5, ENVI 5.2 Reference management: Mendeley, EndNoteEducation QualificationsMaster 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 ProjectCertificate 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 FrameworkMaster 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 SystemsBachelor of Science (Zoology) April 1997 St. Xaviers College, Ahmedabad, India [GPA: 3.14/4.00] Professional ExperienceANALYST & DATA SCIENTIST (Freelancing), WAYNE, PA, AUGUST 2019  PRESENTKnowledge & skill enhancement: Enrolled in DataCamp Track  Data Scientist with Python and RCreating Machine Learning models for predictive analytics using open source datasetsEmploying 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 setupApplied concepts & knowledge of business workflow, survey data analytics, client servicing for data profiling, data mapping and data validation to setup new dashboardsInvolved in the teams Status Reporting, Issue and Change managementDeveloped best practices documentation and standards Environment: SQL, Tableau, Qualtrics, Confirmit, MS Excel VBA Page 2 of 2DATA 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 forecastingDatabase modelling for SQL & NoSQL projectsEnvironment: SQL, Tableau, Python, R, SPSS, MS Excel GRADUATE RESEARCH ASSISTANT, UNIVERSITY OF NORTH CAROLINA, CHARLOTTE, OCTOBER 2015  MAY 2018Executed 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 changePerformed 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 studyExploratory data analysis of 5-minute interval stream discharge data of three years, paving way to Data Modeling & Big Data AnalyticsEmployed 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 ConstituentsEmployed remotely sensed data, such as, Digital Elevation Models (DEM), high-resolution imagery, geospatial database to analyze landscape metrics using ENVI and ArcGISEnvironment: 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 skillsProject: 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, Tukeys 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 TableauObjective: 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 2013Skills 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 skillsTeam-building of students for Water resources project and taught laboratory research course in Physical Geography to 75 Bachelor of Science students at UNCCParticipated in the 3MT ((3-Minute Thesis presentation) on November 10th, 2017 at UNCCPresented 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]