Ms. Dhruv is an experienced Management Information Systems (MIS) analyst skilled in interpreting and analyzing data to identify trends and support decisions. She has experience with analyzing financial data to aid in price projection analysis. Her experience covers qualitative intelligence and knowledge management with a background in geographic information systems. She performs detailed analysis, investigations, engineering calculations, field inspection reports and develops technical reports for a variety of projects. She assisted in verifying code compliance, quality checks, meeting project schedules and budget as well as coordinating the engineering work with other disciplines. She assists with the preparation of planning and design deliverables, preparing and monitoring pilot and bench testing schedules.

SKILLS

Statistics and Probability Data Visualization

Python R-Programming SQL Ms Office Power BI

ACCOMPLISHMENTS

A created a tool to record real-time sampling Water quality Parameters. KIT – NAP (Nitrification Action Plan)

DETAILED EXPERIENCE

WATER

Drinking Water Treatment and Distribution Technical Sustainability, City of Houston, Texas.

She analyzed sampling results, and developed a memo summarizing the study’s findings and next steps for additional monitoring. Participated in sample collecting for maintenance of and improvements to distribution system water quality. She performed field sampling to locate potential disinfectant blending zones and distribution system nitrification. She created and prepared maps to outline the potentially impacted sites using ArcGIS and its tools. Performed chlorination capacity assessments for five of the City’s seven repump stations and developed documentation summarizing findings.

Bridgeland Water Quality & Support Services, Bridgeland Management Development Company, LLC, Cypress, Texas.

Ms. Dhruv helped in monitoring, assessing and identifying source water and distribution system water quality data for a large master-planned community. She identified quality data gaps and made recommendations regarding additional sampling to fully assess system water quality.

Water Quality Study, West Harris County Regional Water Authority, Houston, Texas.

Acquired, processed, and categorized water quality data from Municipal Utility Districts (MUDs) and the Texas Water Development Board. She refined the collected information to assess the impacts of surface water blending with existing MUD groundwater supplies. She processed the MUD water quality data to channel the information for forecasting of the water blending and emerging blending issues. She manipulates tables within relational databases, employs query language for data mining activities and appropriately applies statistical models for trend analysis. She is responsible for interpreting data trends and conveying findings to a variety of stakeholders. She implements the analyzed data in visualization format to provide real-time knowledge and decision-making process.

Reclaimed Water Supply Study, City of Sugar Land, Texas.

She is a support in analyzing data of onsite reuse, direct/indirect potable reuse, expanded wastewater treatment plant reclaimed water production. She processed the data to help in making decision for the various planning-level alternatives.

Northeast Water Purification Plant Expansion, Backoffice Permitting Support Services, Texas.

She acts as a coordinator to support with field engineers to address comments on any given updates and summarize the comments using Excel and Bluebeam files.

Long Term Water Demand Projections, City of Richmond, Texas.

She analyzed and forecasted water demand projections for the City of Richmond, Texas. She mined the data from the HGAC to forecast the future water demand. She worked on GIS to reflect the prospective uses of water around the City. She defined a methodology for forecasting the future water demand. City’s demographic details were considered while projecting the water demand. Finally, she examined the impacts of several demographic variables such as price and population, as well as those that account for conservation efforts and inflation using principles set forth. This project encompasses a variety of techniques, simple time trend, exponential smoothing. She assessed Land Use Equivalents (LUE) per acre.

Coastal Water Authority, Houston, Texas.

She performed data extraction from USGS and TCEQ for Water Quality Project for Lake Houston. She processed and formatted water quality data and performed regression analysis using USGS LOADEST software. LOADEST outputs were processed to develop inputs for three-dimensional water quality modeling.

Water Master Plan, City of Pearland, Texas.

She is responsible for converting, analyzing, and reporting of GIS data; preparing and updating maps and exhibits with GIS data sets; maintaining utility asset records; and using GIS data, applications, and tools to identify and solve problems for the engineering and operations departments.

Integrated Utility Master Planning and Financial Planning, City of Richmond, Texas.

She participated in overseeing and analyzing to water, wastewater, and reclaimed water master planning data for the City. This project sought to plan future population and water demand for the City’s rapidly developing service area. In the next phase of the project, the team will develop capital improvement projects that will economically meet the City’s water, wastewater, and reclaimed water demands, while complying with subsidence district groundwater reduction mandates. Provided alternatives for growth rates, water conservation, nontraditional pollutants, future regulatory requirements, pollution reduction. Defined minimum process requirements to meet business demands. Assessed and incorporated ongoing business transformation initiatives.

Corrosion Control Study Update, City of Rosenberg, Texas.

Ms. Dhruv monitored analytics and metrics results to develop guided resource regarding customer complaints documentation and a customer notification regarding the City’s conversion from free chlorine to chloramine disinfection. Implemented new data analysis methodologies to report quality assurance and quality control. She formulated a strategy for assessing the required data.

Distribution System Blending and Water Quality Management, North Harris County Regional Water Authority, Houston, Texas.

As part of this multi-faceted water quality management study, she assisted in documenting existing and planned system operations and associated impacts on water quality, conducted a detailed water quality assessment for two future whole customers, and developed guidance for future wholesale customers regarding preparation of their distribution systems to receive surface water, customer complaint documentation, and optimized corrosion control. She prepared project submittals, compiled the final project report, and performed quality assurance reviews.

BAWA Surface Water Treatment Plant Chemical Feed Improvements City of Baytown, Baytown, Texas.

She aided in the development of a report cataloguing condition assessment of the various chemical feed systems at the 26 million gallon per day surface water treatment plant and recommendations for improvements. Additionally, helped in developing a sampling plan to assess the origin, fate, and transport of metals through the City’s water and wastewater systems. Her responsibility included to monitor water temperature and quality change. She builds the time-series and other plots to aid in decision-making process with the collected water turbidity and organized the data to its appropriate relationships.

Campus Water Quality Study, Sam Houston State University, Huntsville, Texas. Ms. Dhruv helped in developing a water quality sampling plan for several buildings on the client’s campus, analyzed sampling results, and developed a memo summarizing the study’s findings and next steps for additional monitoring.

Benchmarking Study, City of Pearland, Texas. She carried out research on similar cities, to identify the strength and opportunities for the city under benchmarking. A direct comparison of staffing for water utility and wastewater utility to assist and support the city for Surface water planning, as the city plans to build a surface water. She underwent a thorough research under the guidance of the Team and 2018 AWWA Utility Benchmarking. She was able to collect, analyze and review data on operations, water production, water distribution, pumping capacity, water quality data. Data were normalized to develop performance metrics to facilitate direct comparison of utility staffing levels.

WASTEWATER

Sugar Land North WWTP Evaluation, Sugar Land, Texas. This project calls for flow projections. Daily Monitoring reports was collected the effluent flow and 2-hour peak flows data was provided. Based on that clean the data, transforming the data to its needed form, she was able to identify the peak factor utilizing Data analysis under Microsoft Excel. A logical use of Rank and percentile analysis helped to classify the data range into categories. Ratios of effluent flow to peaking hour flow aided to extract factors for the further decision-making process. This project was under Keith O'Connor, a Project Manager.

PAVING AND DRAINAGE

Holderrieth Road Segment 3, Harris County Engineering Department, Texas.

She was involved in preparing, creating project exhibits in ArcGIS. Prepared documents (maps) proposed project drainage design for improvements. Performed storm sewer design for paving and drainage project. Convert gathered data into GIS database with proper and accurate spatial location. Assure consistency with company- wide standards and practices for data conversion, data maintenance and upgrades. Utilize GIS for analysis of spatial data, perform routine analyses optimizing use of various company data sets, and perform limited research using government or other outside sources as directed by supervisor to support engineering and operation needs. Present results through clear, concise thematic maps with well-documented sources and metadata.

Mason Creek Trail, EHRA, Texas.

Developed and created GIS maps as requested by implementing ArcMap and analyzing relevant data. Assisted in data management and organization, including vector and raster data. Maintained geospatial data and designed database structures in an SDE environment. Calculated delineation of drainage and peak flow to determine water balances in drainage areas. Generate and distribute timely standard reports, utility pipe network system and thematic maps. Maintain up-to-date asset data inventory and asset records for GIS-related assets and maintain linkages between databases for efficient and accurate reporting. Coordinate timing of updates and corrections with district personnel to ensure maps, databases and reports are accurate and up to date.

West Gulf Bank Road, Houston, Texas.

Developed and Created Exhibits, using Arc GIS. Maintained geospatial data and designed database structures in an SDE environment. Generate and distribute timely standard reports, utility pipe network system, connection system and thematic Exhibits. Named and renamed the storm sewer drainage areas. Designed ditches based on the models on the exhibits and data specifications. The project manager for this project is Srinivas Chintalapati and Giri Putcha. Addressed on the mark-ups on the exhibits for the final presentation of the report.

OTHER

Texas Southern University, Houston, Texas. Graduate Research Assistant for the Recruitment and Advisory Department. Researched and drafted grant proposals to establish a student organization focused on international cultural diversity. Coordinated marketing programs with prospective students to increase student enrollment.

Trans Globe – The Global Education Company, Rajkot, India. International Educational Consultant. Explored educational opportunities and processed enrollment requirements for undergraduate and graduate students pursuing education abroad.

Venus Enterprises, Rajkot, India. Assistant Financial Executive. Compiled bank and financial records for a manufacturing chemical company. Ms. Dhruv reconciled banking transactions for general ledger accounts and provided financial analysis for future business expansion.

Dhwaja Shares & Securities Pvt. Ltd., Mumbai, India. Assistant Relationship Manager. Researched stocks, making recommendations and maintaining client portfolios for a stock investment firm. Ms. Dhruv provided sales and marketing support for a diverse range of stocks. She created quarterly reports on stock return and investment (ROI). She is a Certified Capital Dealer of National Stock Exchange of India.

The Galaxy Education System, Rajkot, India. Human Representative Liaison for regional school district, coordinated activities among students, staff and teachers for internal programs. Provided support for all departments on developing communications platforms.

Station e Info Services Pvt. Ltd., Rajkot, India. Assistant Financial Executive. Reconciled accounting activities and banking transactions for a multi branch language lab. Managed financial transactions for five branches in different locations within and outside several cities. Prepared monthly and yearly business reports.

Years of Experience

10

Education

•Masters, Management Information Systems, 2017, Texas Southern University, Houston, Texas

•MBA, Finance, 2007, Saurashtra University, Rajkot, India

•Bachelor of Commerce Finance and Accounts, 2005, Saurashtra University, Rajkot, India

Licenses and Certifications

•Customer/Operational Analytics Certification, 2017, University of Philadelphia

•Certified Capital Dealer of National Stock Exchange of India, 2007

•Excel Advanced Certification 2020, University of Macquire University, Sydney Australia

•Certificate of Introduction to Python, 2018, Data Camp

•SQL Essential Training, 2018, LinkedIn Learning

•Pursuing Certification in Python for Everybody

Relevant Expertise

• Data Analysis

• Software Script Writing

• Reports Preparation

•Quality Control Check

•Compilation and Documentation of Reports

Management Skills

•Agile Development

•Project and Team Management

•Team-Player

•Ability to learn quickly and high attention to detail

•Passionate about project-based work

Contact this candidate