Technical Architect Sql Server

Mr. Amit Agarwal

***************@*****.***/+1-925-***-****

Technical Architect 15+ Years H1B

Walnut creek-94598, CA, USA

Career Objectives:-

Passionate GIS and IT professional want to build a dynamic career in the field of GIS domain with 15 years’ experience of delivering GIS based solutions for customers with various technologies.

Executive Summary

15 years professional with rich experience in implementing utility and telecom domain projects using GIS technology enabled products of ESRI and Arc FM. Major Activities are of Requirement analysis and gathering to define the specification, followed by design & development of system with set standards.

Demonstrated experience in analysing, designing, developing, and implementing enterprise GIS projects in Utility (Gas & Electric), Telecom, Urban/Rural Planning & Transportation domains, integration with external systems (SAP, CRM, Billing, DMS, Documented etc.).

Proven experience in service delivery management for large-scale Enterprise ESRI/Schneider-based GIS systems (Gas, Electric, Land base & Transport).

Skilled in implementing Web and Desktop GIS applications using ArcGIS Maps SDK for JavaScript/React, ArcGIS Maps SDK for Native Apps, and Arc Object

Proficient in JavaScript for ArcGIS, Python, C#, HTML/CSS, Oracle PL/SQL, and MS SQL Server.

Extensive experience in designing and implementing integration and Enterprise GIS solution that leverages AWS and Azure cloud platforms leveraging cloud components like

oAWS Lambda, EC2, ECS, EMR, Fargate as containers to execute scripts; S3 bucket for storing and retrieving file based data

oIdentity provider components like Ping Access, Ping Fed and Azure AD for authentication and authorization;

oCloud watch and Step Functions for logging and triggering scripts for sequential events

oDynamobDB, Oracle RDS and PostGreSQL as databases to store and retrieve data needed for business processes or solution component developed etc.

Worked on multiple aspects of project management across the software development lifecycle, including planning & estimation, configuration control and work distribution.

Arranging the workshops, conduction User Acceptance Testing and demonstrating the in progress GAS and Electric solution.

Performance tuning, bug tracking and configuration management of applications in GIS application.

Designing Business Processes for GIS in GAS and Electric Utilities for operational benefits and improving customer satisfaction.

Providing technical support to Business on ESRI Products.

Expertise in ArcGIS Desktop, ArcGIS Server & Arc SDE tools and concepts, Geo database versioning and replication.

Good exposure to implementation agile methodology in GIS project

Operational Support and Bug fixing.

Warranty support for production release for GIS project

Experience in Agile and DevOps. Excels in Project and Team Management

Engaged in pre-sales activities and contributed to multiple project wins for the organization.

Global work experience, including USA, Philippines, Dubai, and India.

Skill Details

Application Development

C#.net,Javascript,MVC framework,.Net framework 4/4.5,WCF & web services

RDBMS

Oracle 12/19c, SQL server 2005/2008/2012,Sybase ASE 15.0.2 & MySQL 5.0/7.0

Reporting Tool

Crystal Report and Sql server Reporting tool

GIS Technologies

ArcGIS server 10.2/10.6/10.8,ArcGIS Desktop 10.2/10.6/10.8,ArcSDE,Arc Object, Map object, miner &miner Arc FM 10.2/10.6/1.8

GIS Integration

SAP-GIS, Maximo-GIS

Cloud Technologies

Designing and implementing integration and Enterprise GIS solution that leverages AWS and Azure cloud platforms leveraging cloud components

Server

ArcGIS Server & IIS server

Third Party Tool

MS Visual Studio2010/2012/2015/2017, SQL Developer

Source Control

Microsoft TFS,VSS,SVN & Godthab

Software implementation process Model

Agile-Scrum, Water fall

Modeling tool

VISIO

Operating System

Windows XP/10, Windows server 2008/2012

Domain Expertise

Electric Distribution and Transmission, Gas Distribution and transmission, Telecom and Transportation domains

Professional Experience – 15 Years

Current Employer Name

Tata Consultancy services

Designation

Technical Architect

Duration

March 2017 to Till date

Previous Employer Name

IL&FS Technologies Ltd

Designation

Senior GIS Tech Lead

Duration

Nov 2015 to March 2017

Previous Employer Name

NIIT GIS Limited(ESRI India)

Designation

GIS Tech Lead

Duration

Dec 2013 to Nov 2015

Previous Employer Name

IL&FS Technologies Ltd

Designation

Senior GIS Engineer

Duration

Feb 2008 to Dec 2013

Previous Employer Name

Interaction IT Services Pvt. Ltd, New Delhi, India

Designation

GIS Engineer

Duration

01 Dec-06 – Feb 2008

Projects –

Gas & Electric Utility Customer in CA, USA

TCS – USA (6 month) TCS – India (~3 years)

Duration: 3+ years

Project: - Remote Grid Project

Role: Technical Architect

Description: - Each Remote Grid contains a set of PG&E electric customers who are permanently isolated from the traditional electric distribution system and connected instead to a generating facility called a Standalone Power System (SPS). Each Standalone Power System includes some distributed renewable generation (solar PV) and stationary storage (lithium-ion batteries) and may additionally include a firm generation source like a propane generator. Each Remote Grid site consists of a Standalone Power System (SPS) and a circuit connecting customersEDGIS will be enhanced to accommodate the new Remote Grid network. This is required to ensure traceable, verifiable, accurate and complete documentation in support of managing electric asset registry data for Remote Grid assets.

In the interim, the existing EDGIS features will be used to map a Standalone Power System.

This interim approach uses substation and service transformer asset types as a proxy for the required Standalone Power System asset types.

This SPS feature class will be communicated with different system SAP, DMS, CC&B and PSPS interface.

Responsibility: Primary responsibility to ensure design the proposed architecture that covers the various aspects like Non Functional requirements of systems like capacity, retention of data, security, high availability, disaster recovery etc.; this while ensuring functional requirements are met including integration requirements. These all while ensuring proposed solution aligns IT standards followed by organization. This includes upgrade of complex business and integration process to align with Remote grid business. Role in this project is to drive the solution architect and design efforts while guiding team for development and testing activities.

Technologies: Python, ArcGIS Desktop, ArcGIS Server, ArcGIS Enterprise Arc FM, FME,Oracle

Project: - ET Assets Enhancements (Underbuilds) on prim/Cloud

Role: Technical Architect

Description:- There are approximately 60,000 transmission structures that have distribution underbuilds. These ~60,000 assets are shared by distribution and transmission but currently show up as separate assets in SAP, ETGIS and EDGIS, without an indication they are the same structure. This allows for inconsistencies with distribution and transmission potentially working on the same asset without knowledge of the other. We design the system for keeping the information updated when there are any updates made to a underbuild including updating or removing a underbuild as well as adding a new underbuild

This solution implementation delivered on AWS Cloud platform to integrate between ETGIS and Grid Search to provide delta updates to the Grid Search solution on daily basis. The solution proposes to track changes to the following ETGIS datasets (tables) and provide list of delta updates to be placed in dynamo db. Dynamo DB table would be referred by Grid Search to read delta updates and export the assets (and relevant details) associated with the updates.

Responsibility: Responsibilities include design the solution, coordinate with Design Authority or IT Stakeholders for approval followed by delivery of solution. Activities include coordinating within (Scrum) team comprise of developers, testers, Product Owner and Scrum master for building the solution and ensure different stages of System testing, system integration testing, UAT and production deployment followed by warranty support of solution and handover to operations team are completed within stipulated time and minimal post-delivery defects.

Technologies: AWS Cloud, Python, ArcGIS Desktop, ArcGIS Server, ArcGIS Enterprise Arc FM, Oracle

Project: - ED Enhancements ADMS on prim/Cloud

Role: Technical Lead

Description:- The ADMS CD (Change Detection) solution (a batch job) being implemented at PG&E includes an integration between EDGIS and ADMS to provide updates to the individual CircuitIds to the ADMS solution on daily basis.

Automated a process for exporting data from different data source

Automated a process of publishing (WMS enabled) Map services for ADMS solution on Enterprise GIS platform on cloud

Responsibility: Design and developed a solution that implements that triggered via Cloud watch events and AWS lambda combination to execute on AWS EC2 container. Scripts developed fetches database and enterprise GIS credentials from AWS Secret manager, replace source for layers of map document and publishes on Enterprise GIS. Responsibilities building the solution and ensure different stages of System testing, system integration testing, UAT and production deployment followed by warranty support of solution and handover to operations team are completed within stipulated time and minimal post-delivery defects.

Technologies: AWS Cloud, Python, ArcGIS Desktop, ArcGIS Server, ArcGIS Enterprise Arc FM, Oracle

Project: - ET Enhancements TSS (Transmission support system)

Role: Technical Lead

Description:- TSS will seamlessly integrate the workflow between project initiation, engineering in PLS, and development of construction drawings, FAA screens and automatically funnel data created into the appropriate data systems such as Joint Pole, SAP, FAA screens and ETGIS. This will be reduced manual entry of data multiple times into multiple systems we are integrated and synced TLDB system and electric transmission system in GIS side. ETGIS service will be invoked to push all the changes committed from Grid Search system into ETGIS system. All assets information will be populated in from Grid Search system to ETGIS system. After populating tool will be provided to mappers to perform mapping job in ETGIS desktop.

Responsibility: Responsible for coordinate for the requirements for the solution needed for various business groups in GIS technology landscape which includes business groups like Field Engineers, Outage Management teams (TSS users), Asset Management, Design Engineers etc., For the requirements received from end-users, design the solution and coordinate for Design Authority approval followed by implementation. Coordinate within agile team developers and testers for building the solution and taking through stages System testing, system integration testing, UAT and production deployment followed by warranty support of solution and handover to operations team.

Technologies: C#.Net, VB.Net, Arc FM Desktop, Python, ArcGIS Desktop, ArcGIS Server, ArcGIS Enterprise, Oracle

Enbridge Gas Customer in Ontario, Canada

Duration: 2+ years

Project: - EGIS Gas Storage

Role: Technical Lead

Description: - The EGIS Gas Storage program is a strategic initiative taken by Enbridge Gas Storage team to design, develop, and implement an ESRI based Enterprise GIS which replaces their legacy Manifold GIS application for pipeline mapping and landowner information. This project is now in the second phase which involves enhancements, 10.6.1 upgrade and Integration of GIS with new Work and Asset Management system. This phase consists of developing a number of specialized applications for different business units so that they can start leveraging the capabilities offered by the new system. Some of the key applications currently in progress are – Work and Asset Management, 10.6.1 upgrade, Gas Storage, Maximum Operating Pressure etc. This project will help the client to leverage the latest tools and techniques available in 10.6.1 version especially for generating reports after the analysis of the data such as leak incidents, pipe replacements etc. Also, the 10.6.1 version will provide a number of analysis tools by default and will help the client in analyzing the data by combining multiple scenarios. This project is based on offshore model where requirement validation, design and implementation are done at offshore and activities like GIS environment set-up, User Acceptance and Warranty Support will be done at onsite.

Responsibility: Responsible for leading the project team to upgrade the existing GIS landscape at Enbridge Gas from ArcGIS 10.2.1 to ArcGIS 10.6.1 platform. Coordinate with the customer for project related activities which includes requirements gathering, design solution, build infra, SIT, UAT, Roll-out and post roll-out handover. Mentor the team of enthusiastic individuals to deliver the quality solution on-time and within budget. Apart from leading the team, also shouldering the responsibility of designing the solution to define the GIS landscape for to-be GIS product platform while ensuring scope for further expansion to build robust GIS solution.

Technologies: C#.Net, VB.Net, Arc FM Desktop, Python, ArcGIS Desktop, ArcGIS Server, ArcGIS Enterprise, Oracle

Dubai Electric and Water in Dubai, UAE

Duration: 1+ years

Project: - Upgrade 9.3 to 10.8.1 and convert non Arc FM to Arc FM system

Role: Technical Lead

Description: - We have migrated DEWA (Dubai Electricity and Water Authority) utilities to ArcGIS 9. 2 to 10 and integrated Arc FM desktop 10.6 in DEWA utilities. We have configuration Arc FM Desktop 10.6 in Dewa utilities like Session manger, store display, system favorites, and composite favorites and tracing and customization many Arc FM Desktop tool like PX Tools, subtask, Auto Updater Arc FM login, Validation rule, ArcFMFieldEditor Display Names etc.

Responsibility: Responsible for delivering the Upgrade of GIS Landscape to latest version of Arc FM 10.6.1 which was warranted to address the organization risk identified with one of the Arc FM product features. Played a key role in coordinating project related activities, designing the solution, vetted with the customer to confirm that solution addresses the risk identified, testing and delivery of the solution followed by successful handover of the solution. Whole program was delivered by the team of self-driven individuals and fortunate that I was entrusted with the responsibility of leading the team from onsite.

Technologies: ESRI Arc Objects, Miner & Miner Arc FM Desktop10.6,ESRI Arc Catalog,ESRI ARC Map Visual studio 2017 and ESRI GEODATABASE using ARCSDE for Oracle 12 C

Airport Authority (India), New Delhi India

Duration: 2+ years

Project: - NO Objection Certificate Application System (NOCAS)

Role: Technical Lead

Description: - Web based GIS application is provide is given facility to an apply online "No Objection Certificate Application System" for Building / Chimney / Transmission lines/ Masts & Structures Height clearances for submission of NOC applications online. Monitoring - AAI designated officers to be able to monitor the pending and process NOCs status graphically.

Responsibility: Responsible for delivering the Web GIS solution Design, Develop, Test and Roll-out in UAT environment. It includes coordinate with Product Vendor, SW Design Approval Board, Stake holder, Test Management Team to obtain Sign-off on Design and Test Strategies with multiple Test Gateway documents. Responsibilities include leading a team to achieve common goal of defect free delivery and effective as well as efficient rollout of solution. Technical Lead for Geo database design and developed SOE to integrate in Map service.

Technologies: Desktop & Internet GIS applications using ASP.NET 4.5, ESRI ArcGIS Server 10.3, JavaScript API, ESRI Arc Objects, ESRI Arc Catalog,ESRI ARC Map Visual studio 2013 and ESRI GEODATABASE using ARCSDE for MS SQLSERVER 2012

Educational Details

Degree/Certificate

Name of the Institute

MCA-Computer Science

Dr. B.R Ambedkar University, Agra (Formerly Agra University)

B.Sc.(PCM)

Dr. B.R Ambedkar University, Agra (Formerly Agra University)

Contact this candidate