Working in Network Big Data for GIS and Topology department at Bell Canada includes technology such as ArcGIS, PostgreSQL and Hadoop Impala, S3(datasci). Major duties are python coding and analysis on parcel, address, and building data of Wireless Home Internet.
Geocoding, Toolbox building for Quality control, Python automation for address locator generation and SQL scripting for data extraction and uploading in Hadoop, AWS S3 and PostgreSQL as well as ArcGIS Server.
Using DB visualizer, WinSCP, Putty, Linux shell scripting and Esri ArcGIS online. Designed a pythons script for quality checks and data accuracy. Developed an Atlantic locator with the accuracy and matching rate increased by more than 1% for 1.6 millions records.
Produced high quality geodatabases of designed and constructed networks relating tables and accuracy assessment. Tracking demand and supply with the help of GIS by data collection and cartography from several resources over platforms to extract knowledge for project expansion or business needs. Implementing geospatial analysis on data from RDBMS for OSP infrastructure and asset management.
Boosted the project proposal submissions by 30% in design and prepared 5 current projects over 2 years. Performed major database migration to PostgreSQL and Data studio used for automation of Google products.
Won 5 financial funding bids in SWIFT, UBF, ICON and ISED with budget estimation and Prediction of those are used to calculate year-wise inventory. Analyze patterns, proximity, utilities Network to decide Region of interest.
Other duties such as documentation on WIKI and One Call permit submissions, collecting spatial and non- spatial data for insights. Constant communication with On-Field team, Support team, Inventory, over Slack, Web server for web maps also visualizing data on Google Products (Google, Sheets, Calendar, maps and Google earth) and OpenStreetMap. Terrain, profile and 3D analysis for checking the strength of signal and River crossing in QGIS.
Automating with Scripts on databases, sheets, shell/ terminal and programs. Used for automation on Google Scripts extract customer appointments from calendar to distribute technician over the geographic areas each day. Initiated Smartsheet workflow management for tickets status tracking Tech Support and Construction and auto-transfer. Distributing duct and fiber colors for premises and foreseeing the capacity of the network.
Major achievements such as developing and deploying Postgres-QGIS-Geoserver infrastructure from scratch and upgrading Tomcat apache server as well as Postgres & PostGIS. Batch data insertion and cron jobs with bash scripting for auto-backups along with sql scripting on database for cleaning. Created a DEM from google earth to use it a terrain model development for underground information and River depth analysis for fiber.
Documented process flows and developed requirements for functional improvements and enhancements.
Achieved 98% data accuracy in Server with python scripting and spatial tools.
Developed a web app with ArcGIS Online and Spatial Network analysis features. Learn More
Performed Image processing using .NET C# in Visual Studio EMGU package for live attendance system.
Programming, Database and Team management with project documents were the responsibilities. Applying OO modelling and concepts in programming languages. Learn More
Data Mined of the medical entries from a government hospital with MSBI and online climate analysis for prediction of medicines consumption and types of medicines needed within few months to reduce wastage. Learn More
GIS Application Specialist - Post Graduate Certificate from Sir Sandford Fleming College, Lindsay, Ontario
Project Management - Post Graduate Certificate from Sir Sandford Fleming College, Peterborough, Ontario
Computer Engineering - Bachelor’s Engineering Degree from Gujarat Technical University, Ahmedabad, Gujarat, India