Mallesham Anumula

Email: adjmkm@r.postjobfree.com Contact: +1-925-***-****

Summary:

GIS Professional with Masters in Civil Engineering, Full stack GIS software engineer/Lead/Architect with over 14+ years of experience including 6 years of leadership experience in Data Engineer, Development, Technical Lead/Architect, APIs, Geospatial technology and web services. Experienced in implementing great user experiences, managing server-side scalability and concurrency, designing database schemas and batch processing jobs, and deploying and administering servers. Advanced proficiency in building sophisticated distributed systems using REST/ web APIs. Product focused and deeply passionate about solving interesting problems. Have experience with open source, and object-oriented programming.

14+ Years of experience working in ESRI technology that includes ArcGIS Server, ArcGIS Objects, ArcGIS runtime, ArcSDE and scripting

8+ Years of experience in Utility GIS data and network models. 8 Years of experience within PG&E GISCOE projects and worked in various roles from GIS Analyst, GIS Developer, Electric Service Lead, Lead Developer and Technical Lead

12+ Years of experience in hands-on full stack application development using Python, Flask, JavaScript, dojo, CSS, REST APIs, ReactJS, ArcGIS Runtime, Silverlight, Flex, ArcGIS API, ArcGIS/ArcFM objects and SumoLogic

10+ Years of experience in Geodatabase performance tuning, enterprise geodatabase replication, infrastructure planning, software deployment automation, and GIS Roadmap preparation.

14+ Years of experience in Software Development Life cycle process and quality assurance practices for developing software applications

Good proficiency in configuring Windows servers and database servers for ESRI software and ESRI licenses

Gas and Electric Utility, Hydro, Urban/Planning, Transportation business/domain knowledge

Excellent planning and organizational skills; detail and process-oriented; able to juggle multiple priorities in a fast-paced environment

Experience in managing technical delivery of contractor teams

Experience in developing applications using Agile methodology

Mentoring and training experience of GIS technology teams in a larger organization

Strong teamwork and interpersonal skills at all levels

Knowledge in developing applications in AWS

Knowledge in deploying applications using CI/CD

Performed various roles in the course of career viz. GIS Developer, GIS Analyst, Business Analyst, Leader Developer, Service Lead, Technical Lead, Solution Architect, and GIS Consultant for various national and international GIS projects Award: PG&E Courage award for completing successfully end-end DR exercise for EDGIS application from GIS COE Operations.

Education:

Master of Technology – Civil Engineering specialized in Geotechnical Engineering from Indian Institute of Technology Kharagpur, India.

Bachelor of Technology – Civil Engineering from Osmania University from Hyderabad, India.

Employment Summary:

Organization Duration

TATA Consultancy Services Since Jan 2010

Satyam Computer Services Limited Jun 2007 to Jan 2010 Speck Spatial Tech Limited June 2006 to June 2007

Domain and Technical Skills:

Domain/Business

Functions

Utilities – Electric, Gas, Hydro and Telecom

Insurance– Market Research & Analysis

Urban/Rural Planning & Transportation

Technical Roles Technical Lead/Service Lead/Lead Developer/GIS Analyst for various GIS projects in PG&E GIS COE,

Walnut Creek, CA

Technical Lead / Lead Developer – Telenor MPOS & Radiolinjeplan Project, Oslo, Norway

Lead Developer - Enterprise GIS implementation for RAPDRP program

Project Lead / Lead Developer / Developer in various project in Singapore

GIS Software ESRI Server Products: ArcGIS Server, ArcFM Server, ArcSDE Server, ArcGIS Online, and spatial extensions ESRI Desktop Products: ArcGIS Pro, ArcEngine,

ArcCatalog, ArcMap – ArcInfo, ArcView, ArcFM, GDBM, Business Analyst, and extensions

Other GIS Products: AutoCAD Map, FME Server &

Workbench, Mobile Apps (iOS)

Languages / Tools Python, JavaScript API, Silverlight API, Couchbase, HTML5, CSS3, ReactJS, dojo, Flask, VB.Net, C#.Net ASP.Net, VB/Windows Scripting, Flex, PL/SQL, ArcObjects

Database Oracle, SQL Server, PostgreSQL

Other Softwares Jenkins, Chef, Sumologic, UC4, HP QTP Testing Automation, HP Quality Center, Citrix 6.0, Oracle ESSO, System Monitor, System Test

Professional Work Experience:

EDGIS Infrastructure Upgrade and Application

Re-Architecture

Duration: Since June 2020

Customer Name: Pacific Gas & Electric, Walnut Creek, CA Project Description: The purpose of this project is to develop and implement the re- architected EDGIS and LBGIS leveraging advanced technologies in order to meet current and future needs of EDGIS and LBGIS.

• Upgrade to new hardware and latest GIS platform will enhance the overall system stability and performance.

• Retiring unsupported deprecated technologies.

• Refined and improved system interfaces will increase overall system stability and reliability.

• Improved data integrity by re-designing of Interfaces.

• CI/CD pipeline implementation will improve code deployment process.

• Database server consolidation will help the organization to reduce some of IT overhead.

• Improved user experience & WEBR performance and stability Role/Responsibility: As Technical Lead / Lead Developer

• Design and development of WebGIS components in ReactJS and ArcGIS API

• Design and development of backend services using Python – Flask Framework.

• Lead and collaborating with Application Developers to implement database design, and review developer’s works.

• Code Review for various GIS components of developers

• Work with CI/CD team for automation deployment using Chef & Jenkins

• Work with Testing team on automating unit test cases

• Coordinate with offshore team on technical deliverables

• Setting up Sumologic and Beyond Trust Vault for security management

• Prepare the application component delivery plan

• Help team in Solution Blueprint and Capacity planning

• Conduct technical workshops and review technical design with PG&E IT

• Review existing system and identify the pain area along with the solution

• Low-level design for the implementation. Answer queries related to technical design Architecture and its implementation methodology.

• Participate various technical meetings and help/guide developer in technical issue

• Collaboratively work with the PG&E Technical Team, to develop the deployment strategy, deployment plan, and manage the deployment activities to a successful completion

• Work collaboratively to provide the technical training and knowledge transfer to the PG&E Technical Team

Technology Stack: ReactJS, Flask, JavaScript API, Python, HTML5, CSS, Jenkins, Chef, Sumologic, PostGresSQL, Oracle 19c, Ping Access, Beyond Trust, Git, JIRA, ArcGIS Desktop 10.8.1, ArcGIS Server 10.8.1, ArcSDE 10.8.1, ArcFM 10.8.1, FME Server 2020 Maps+ Mobile application Duration: May 2018 to May 2020 Customer Name: Pacific Gas & Electric, San Francisco, CA Project Description: The Maps+ Mobile App is an app that can be used to access GIS maps and asset data across all lines of business. The app is designed to help PG&E field workers find gas, electric, fiber and hydro assets and view their characteristics from a mobile device, in order to assist them with their daily job duties, while reducing reliance on paper maps. Maps+ application helps business in various business process such as Asset Inspection, field survey and emergency response during PSPS event Role/Responsibility: As Lead Developer / Technical Lead,

• Develop data pipeline for Mobile device in the format of SQLite

• Enhance API services to download the data into iOS device

• Develop tools to process the data and build the Maps/SQLite files for iOS devices

• Develop Data Sync mechanism in Mobile Device

• Evaluate and setup 3rd party commercial and publicly available geospatial data in PG&E and available in Maps+ for emergency response

• Have monthly cadence meeting with product vendor and review issues/product releases. Understanding latest product changes and application component accordingly

• Supporting team members in technical questions

• Code review and deployment

Technology Stack: Agile, iOS Swift, ASP Web API, C#, Python, ArcGIS Runtime 100.3.1, REST API, Couchbase, Jenkins, PostGresSQL, Oracle, F5, Git, JIRA, ArcGIS Desktop 10.5.1, ArcGIS Server 10.5.1, ArcSDE 10.2.1, FME, QGIS EDAM GIS / ETAM GIS applications Duration: May 2013 to May 2018 Customer Name: Pacific Gas & Electric, San Francisco, CA Project Description: PG&E provides natural gas and electric service to northern and central California. In support of electric service, PG&E has embarked on a three-year project to implement ArcGIS technology for Electrical Distribution (ED) & Electrical Transmission (ET) for four service territories while migrating and conflating data.

• PG&E ED Asset Management (AM)/GIS project is to implement a GIS mapping system that integrates with SAP Asset Management system. This project is designed to handle GIS Desktop operations for Mapping Editors and Web Application for Estimators & Operation engineers

• Electric Transmission GIS Asset Management (ETGIS AM) project is to make spatially accurate data readily available to support the key activities that affect reliability; maintenance and inspection, system infrastructure assessment, system planning, and vegetation management

Role/Responsibility: Service Lead / Sr. Developer / Technical Lead / GIS Analyst. Prepared Solution Architecture, effort estimation, designed critical components, reviewed application components design, and Lead for GIS and Integrations. Operations

& Maintenance Lead post project implementation. For new enhancements - reviewed application architecture/design changes and provided impact analysis

• Responsible for successful delivery of code components of project/s

• Responsible for technical delivery of major/minor enhancements

• Participating in business users workshops validating requirements and creating specifications

• Responsible for Change and release management of the application component changes

• Contributes and drives towards technology standards set by GIS COE

• Prepare and update application status report in Technology weekly and months status meetings

• Develops relationship across IT partners and line of business clients.

• Work with different IT stake holders which are integrated with EDGIS/ETGIS/LBGIS applications

• Conduct and Supervise DR Exercise for EDGIS/ETGIS/LBGIS

• Analysis of requirements and undertaking technical feasibility

• User interface design and data flow diagrams

• Working with business users for approvals of specifications

• Application programming and development as per approved specifications

• Preparing the various software environments like development, testing and production

• Development, testing and deployment of the customized application and interact with the client to make sure that the product is aligned as per the functional needs

• Develop and establish procedures for maintaining ArcSDE database security

• Troubleshooting ArcSDE for connectivity, access, performance and other issues

• Support versioning, compression, reconciliation and replication

• Manage Geometric Networks, Relationship classes and Indexes Technology Stack: ET Project – ArcGIS Server 10.2, ArcSDE 10.2, ArcGIS Desktop 10.2, ArcObjects, C#.NET, JavaScript API. ED Project – ArcGIS Server 10.2, ArcFM Server 10.2, ArcSDE 10.2.1, ArcGIS Desktop 10.2 SP5, ArcFM 10.0.3, Silverlight API, ArcObjects, C#.NET, Python, Web API, UC4, Unix Shell Script, Windows Batch Script, Share Point, Citrix 6.0, Oracle ESSO.

MPOS & Radiolinjeplan, Telenor Duration: Aug 2012 to May 2013 Customer Name: Telenor, Norway

Project Description: Telenor intends to develop an enhanced version of the existing stand-alone Mobile Positioning System to improvise the business process and services for internal and external users using state of art technologies such as HTML5, Dot NET and ESRI based ArcGIS Server platform using JavaScript API. This solution would facilitate to find out the missing person by delivering the geographical positions of the subscribers displayed on the map in the rescue operation centers. With the proposed solution, the Police Response Center at Telenor would assist Police and Rescue Coordination System in the Emergencies by locating the missing person through the associated Mobile number.

Radiolinjeplan system is an inventory management and planning system for radio link communication networks. It maintains information about radio links and their frequency usage along with related physical installations. As part of inventory management, information about radio links, sites, paths, equipment, antennas, reflectors, waveguides, manufacturers and frequencies are maintained. In Radio link planning perspective, system is used to decide best path for establishing a new radio link. Radiolinjeplan also contains programs for calculations of needed antenna heights, attenuation and signal quality. In this system, maps play a key role in planning radio links. Maps are used to present radio links and radio link sites, to execute spatial analysis and to give new radio links sites with their exact geographic position. It allows generating terrain profiles to assist the user when planning the position of new radio link sites and the path of new radio links. Radiolinjeplan also facilitates WiMax planning and coverage data. The Radiolinjeplan system is loosely coupled with KOG, Nitra and Gunda systems at Telenor and has external interface Geodata cloud services. Role/Responsibility: Lead Developer / Technical Lead.

• Technical Design for both projects

• Analysis of requirements and undertaking technical feasibility

• User interface design and data flow diagrams

• Design and Develop WebGIS application JavaScript API

• Design and Develop WebAPI using .NET WCF

• Unit Testing and deployment

Technology Stack: Esri JavaScript API, dojo, Python, ArcGIS Server 10.2, ArcSDE 10.2.1, ArcGIS Desktop 10.2.1 SP5, Silverlight API, ArcObjects, C#.NET, Python, Web API

R-APDRP – Restructured Accelerated

Power Development & Reforms Program

Duration: Jan 2012 to Aug 2012

Customer Name: Hyderabad, India

Project Description: The R-APDRP reforms power distribution with – reduction of AT&C losses, bring about Commercial viability, reduce outages & interruptions and increase consumer satisfaction.

Establishment of reliable and automated systems for sustained collection of accurate base line data and the adoption of Information Technology in the areas of energy accounting will be essential before taking up the regular distribution strengthening projects.

Role/Responsibility: Lead Developer / Technical Lead.

• Technical Design for both projects

• Analysis of requirements and undertaking technical feasibility

• User interface design and data flow diagrams

• Design and Develop WebGIS application and desktop

• Design and Develop WebAPI using .NET WCF

• Unit Testing and deployment

Technology Stack: ArcGIS Server 9.3.1, ArcFM Server 9.3.1, ArcSDE 9.3.1, ArcInfo 9.3.1, Oracle 11g, ODI, Oracle Fusion, SAP, ArcObjects, C#.NET, ASP.NET, PL/SQL Geographical Data Management &Traffic

Accident Analysis & Management

Duration: Jan 2010 to Dec 2011

Customer Name: Land Transport Authority (LTA), Singapore Project Description: Land Transport Authority (LTA) was then using two systems for its enterprise wide GIS needs. Both the systems are built on older version of the technology and pose a challenge for future. Keeping the same in mind LTA decided to upgrade both the applications so that they can transform the existing Geographic Data Management (GDM) application into a versatile GIS infrastructure with segregated GIS viewing and authoring environments that have the capability to provide map services for the existing Traffic Accident Analysis Management (TAAM) application Role/Responsibility: Project Lead for upgrading existing infrastructure and application from ArcGIS 8.3 to ArcGIS 9.3.1.

Actively involved following project activities–

• Leading developers team onsite in Singapore

• Design, Development and Deployment of the Web-based applications

• Interaction and communication with client and TCS management.

• Application Support & Maintenance

• Responsible for Impact Analysis of new enhancements, Delivered 9 enhancements successfully during my stay in the project.

• Prepare and take approval from client of all of project documents including Impact Analysis document, Software Requirement Specification document and Technical Design Document etc.

• Identify the key improvement area in the applications initiatively and proposed process improvement solutions to customer to benefit the customer by reducing the cost.

• Setup of Integration environments for Production, Staging, Testing and application level user groups

• Root cause analysis of performance issue and suggestions to improve the performance of WebGIS applications

• Integration with other external systems i.e., HR & One.Login, Geospace & I- Transport.

• Use of TCS propertied tool Master Craft to carry out requirement analysis, design, development, and testing activities.

• UAT and Go-Live of application.

Technology Stack: Python, ArcObjects, ArcGIS Server 9.3.1, ArcSDE 9.3.1, ArcInfo 9.3.1, Oracle 11g, C#.NET, ASP.NET, PL/SQL

SG Space (GeoHub) Duration: Sep 2009 to Dec 2009

Customer Name: Singapore Land Authority (SLA), Singapore Project Description: The Singapore Geospatial Collaborative Environment (SG-SPACE) initiative is driven by the Singapore Land Authority (SLA) to promote and enable sharing of spatial data among government agencies. The key business outcome of SG-SPACE is

“a spatially enabled nation”, where geospatial information will be available and used effectively by citizens and businesses for better decision making. The underlying platform that facilitates the operations of SG-SPACE is called GeoSpace GeoSpace adopts Oracle Enterprise Service Bus (OSB) 11g to register and provide SOA capability for Geo-spatial services and API's. The OSB based architecture facilitated complex registration and access to several types of Open GIS Consortium (OGC) based data services (WMS, WFS, WCS etc) as well as several geo-processing tools and API’s in REST, Java Script and ESRI Web ADF formats. The architectural agility powered by OSB enabled integration of heterogeneous services in a seamless manner, apart from offering standard features such re usability, governance, monitoring, auditing and reporting of all data services and APIs

Role/Responsibility: Technical Lead –

• Prepared the Technical Design document for all the modules of Project by analyzing the existing system, hardware & software.

• Recommended the proper hardware for the load of all GIS applications which provided the expected performance even for the peak loads.

• Configured and tuned the servers for the optimal performance to handle the heavy loads of the applications.

• Provided the onsite consulting services with respect to implementation and customization of GIS system.

• Resolved many technical issues while integrating GIS system with other systems. Technology Stack: Python, ArcObjects, ArcGIS Server 9.3.1, ArcSDE 9.3.1, ArcInfo 9.3.1, Oracle 11g, C#.NET, ASP.NET, PL/SQL, FME

Consolidated GIS System (Singapore) Duration: Feb 2009 to Sep 2009 Customer Name: Singapore Land Authority (SLA), Singapore Project Description: Survey Services Department (SS) of Singapore Land Authority’s

(SLA) Land Services Division (LSD) is responsible for maintaining comprehensive records and precise definition of all land lots in Singapore. SS is also responsible for the inspection and registration of title plans carried out by private registered surveyors and assisting the government in compiling various maps and land records. As part of its continuous effort to achieve better productivity and administration, SLA has decided to consolidate various Geographic Information System (GIS) used within SLA by different departments. This would allow seamless sharing of spatial information between the departments and save system maintenance cost Role/Responsibility: As developer involved following activities

• Prepared the Impact Analysis and approach document for the Migration the application

• Implemented the all functions by the team member.

• Integration of all the migrated modules

• Onsite coordination for deployment and testing

• Data setup/ Application deployment, ArcSDE configuration and performance Technology Stack: ArcGIS 9.2, Arc Objects, ArcSDE and Oracle 10gR2 Land Data Hub (LandNet) Duration: Jan 2008 to Feb 2009 Customer Name: Singapore Land Authority (SLA), Singapore Project Description: This project is to consolidate various Geographic Information System (GIS) enabled spatial data used within SLA by different government and private agencies. LandNET allows seamless sharing of spatial information between the departments and save system maintenance cost. LandNet is all about Web based spatial data sharing system, which takes an advantage of recent development in Spatial Technology domain such as Spatial Data Warehousing, Spatial ETL (Extraction, Transformation and Loading) tools like FME, GML (Geographic Mark-up Language), ArcSDE 9.1 and ArcGIS Server 9.2 is used to display Singapore map, customizing map, perform spatial analysis, color rendering over web, integration with FME, admin modules and various other modules

Role/Responsibility: As Lead Programmer involved in preparing Technical and Functional Specification. Creation and configuration of data model and database. Designed and Developed the functionality of the web portal using the ArcGIS Server and ASP.Net.

Technology Stack: ArcGIS 9.2, Arc Objects, ArcSDE and Oracle 10gR2, FME Enhanced Road Information Management

System (eRIMS)

Duration: May 2007 to Jan 2008

Customer Name: Land Transportation Authority (LTA), Singapore Project Description: ERIMS is a seamless integration of a Client/Server GIS application and a web based module for job transacting. It comprises of the integration of three modules viz: GDM (Geographic Data Management), SPM (Submission Processing Module) and TAAM (Traffic Accident Analysis Module). The working of the three modules in sync with each other brings about an integration of workflow management and GIS which is made practical for the benefit of the transportation sector of LTA, Singapore Role/Responsibility: Designed and developed the various functionality of the Desktop and Web portal using ASP.Net technology. Involved in Testing of the Web application. Technology Stack: ArcGIS 8.3, Arc Objects, ArcSDE 8.3 and Oracle 9i Integrated Land Information System Duration: Jun 2006 to May 2007 Customer Name: Commissionerate of Survey, Settlements and Land Records, Government of Andhra Pradesh, India

Project Description: The vision of ILIS is to formulate a comprehensive, self- sustainable Integrated Land Information System, which shall serve as a record of the conclusive title of the land parcels and shall provide core services related to land administration in a unified, efficient and service oriented manner by leveraging on the latest technology and the appropriate legislation

Role/Responsibility: As Developer

• Client Interaction

• Requirement Analysis

• Design & Development

• Unit testing and deployment

Technology Stack: ArcGIS 9.1, Arc Objects, ArcGIS Server 9.1, ArcSDE 9.1, and Oracle 9i

Contact this candidate