Name: SK

Contact: 703-***-**** Ext ***

E-mail: ad379e@r.postjobfree.com

Status: H1B

PROFESSIONAL SUMMARY:

Over 7 years of Experience in GIS Application Development, Analysis, Research and Development, utilizing ArcGIS, ArcGIS for Server, Big Data, Elasticsearch, Scala, Maven, Java, Query DSL, cURL, Kibana, Micro services, Web Adapter, ESRI products, Angular JS, REST Services, ENVI and ERDAS, .NET (VB, C#, and ASP), Oracle RDBMS, Spatial, PL/SQL, C, C++, JavaScript, I am seeking a position as a GIS Application Developer and providing leadership in areas of operation.

Development of REST micro services utilizing Java, Maven, Eclipse, Query DSL, Elasticsearch to query indices and attain json objects, utilize them in rendering mapping features on the ArcGIS for JS 4.3.

Development of Elasticsearch based BigData solution to retrieve data utilizing CURL search commands, and jQuery AJAX to retrieve data from indices and display map services layers on a map as images.

Development of Scala’s ArcGIS for Server Service Object Interceptor to intercept the service requests, direct the requests to Elastic Search index utilizing curl queries (and MemSQL), retrieve spatial data, aggregate to a hexagons, convert the vector geometries to an image and render it on the map. GIS development, analysis (spatial), map making, geostatistical analysis, geodatabases management and 3D analysis of vector GIS data.

Development of web GIS Single - Page Applications utilizing Angular JS, ArcGIS for JS 4.5, Java REST services, node.js, ArcGIS, HTML, etc.

Development of Big Data based tools to render high volumes of data on a web interface through condensed form utilizing Elasticsearch, MemSQL, Scala, cURL, Java, ArcGIS for Server interceptor, etc.

Development of geospatial tools to the ArcGIS 10.3 utilizing Arc Objects, C#, publishing those tools as web services through ArcGIS and their consumption through desktop client Arc Map 10.3, web interface that was developed utilizing ArcGIS online, and ArcGIS for JavaScript.

Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects, Tables, Views, Materialized Views, Synonyms, Sequences, Triggers, Database Links, and User Defined Data Types and utilization of Oracle Spatial procedures and functions.

Desktop software programming, backend and frontend (graphical user interface design) development, and testing of C, C++, .NET (VB and C#), Qt 4.5 (Cross platform application framework), PL/SQL, Oracle, and Python and web mapping using JavaScript and Google APIs.

Development of web based application with user interactive graphical user interface and map interface utilizing .NET (C#, and .NET), PL/SQL, Oracle, JavaScript, ArcGIS Silver light REST API, DOJO, ArcGIS API for JavaScript, HTML5, IIS, and Google Maps API with JavaScript.

Database creation, querying, update and management of Geo database, Oracle 11G Spatial, Spatiality and MySQL.

Utilization of Linear Reference System (LRS) and LRM and adding LRS to ArcGIS.

Intermediate Swift knowledge, automate iOS app regression using XCUITest Libraries.

Working experience with defect tracking tools like JIRA, Rally and HP Quality Center

Sound knowledge on Rest Assured Testing framework for Unit testing, Jenkins for Continuous Integration.

Good experience in testing both SOAP and REST web services using SOAP UI and Rest Assured and Tested both XML and JSON formats. Also Performed Web services API Testing.

Experience includes API - Web Services testing using POSTMAN, REST ASSURED, Gatling and SOAPUI XML.

Hands on Knowledge and good understanding of MongoDB NoSQL and Database automation experience with MongoDB.

Excellent knowledge and implementation skills in complete Software Development Life Cycle ( SDLC ) and Software Testing Life Cycle ( STLC )

Experience in developing test scripts in postman using java Scrip t and executed scripts using collection runner in postman.

Hands-on experience in designing and developing cloud solutions based on Microsoft Power Platform using Power Apps, Power Automate, Power BI, Power Apps Portal and Common Data Service (CDS).

Experience in Behavior Driven Development (BDD), Acceptance Test Driven Development (ATDD) using Cucumber.

Experience in automation testing using Selenium suite (WebDriver/WebDriverIO/RC/IDE/Grid), JUnit/TestNG, ANT, Cucumber and Maven.

Experience in designing customized hybrid framework, keyword driven & data driven using selenium WebDriver, Java, TestNG & apache POI .

Experience to build automation framework from scratch, used page object model in project level pattern, JUnit as a testing framework and JAVA.

Good experience in testing both Soap and REST services using Soap UI, Postman.

Performed the Cross Browser Testing using Browser stack.

Strong knowledge of SQL and NoSQL (Mark Logic and Mongo) database queries. Working knowledge of AMPQ messages (RabbitMQ).

Operating and customizing ENVI 4.8, ArcGIS, ERDAS, EXELIS IDL, and FUSION/LDV Remote Sensing and GIS software.

Streamlining routine geospatial and statistical operations through programming (C, C++, Python, and ArcGIS).

TECHNICAL SKILLS:

Web Technologies: JavaScript, Dojo Toolkit 1.10, HTML, Angular JS, Node.js, CSS, ArcGIS for JavaScript APIs, Google Maps APIs, cURL, WCF, SILVERLIGHT, HTML5, PHP, REST, AJAX, XML, Dreamweaver, Angular JS, Building nodejs, and IIS.

GIS Applications: ERDAS Imagine 9.1, ENVI 4.8, ESRI (v3.2, 9.1, 9.2, 10, 10.1 and 10.2), ArcGIS Desktop 10.5, ArcCatalog 10.5, ArcGIS Server 10.5, ArcGIS for JavaScript 4.3, Arc GIS REST SOAP Services, ArcFM, ArcFMObjects, Arc Explorer, Micro station Vi8, TopoDOT, RiPROCESS, FUSION/LDV, Open JUMP, and OSSIM.

Database Technologies: MongoDB, Oracle 10g, MS Access, MS SQL, Progress DB

Cloud Based Testing: SauceLabs, BrowserStack, OpenStack

Types of Testing: Functional, Integration, Regression, System, Negative, White-box, Black-box, Automation Testing, Load, Ad-hoc

Frameworks: Keyword Driven, Data Driven, Hybrid Driven, Page Object Model, BDD using cucumber

Test Management: Mercury Quality Center 10.0, Test Director, Rational Clear Quest, Test Complete, Jira, Rally, ALM

Programming Languages: SQL, JAVA, JavaScript, XML, JSON, C++, HTML, CSS

Methodologies: Agile(Scrum, Kanban, Safe), Waterfall.

Operating Systems: Windows 2003 /XP/2000/NT/Windows 7,8,10, Android, IOS and UNIX

Browsers: Firefox, Google Chrome, Internet Explorer and Safar

Defect Tracking Tools: JIRA, Quality Center, Bugzilla and HP ALM

WORK EXPERIENCE:

Bank of the West - San Francisco, CA January 2023 – Present

GIS QA Analyst

Responsibilities:

Tested REST services utilizing Java, Maven, Eclipse, Query DSL, and Elasticsearch to query indices and attain json objects, utilize them in rendering mapping features on the ArcGIS for JS 4.3.

Testing of Single-Page Applications for GIS based DMAT to visualize millions of data on the map utilizing Angular JS, ArcGIS for Server, ArcGIS for JS, Scala, Java, REST Services, and PostgreSQL.

Implemented of Elasticsearch based BigData solution to retrieve data utilizing CURL search commands, and jQuery AJAX to retrieve data from indices and display map services layers on a map as images.

Implemented of Scala’s ArcGIS for Server Service Object Interceptor to intercept the service requests, direct the requests to Elastic Search index utilizing curl queries (and MemSQL), retrieve spatial data, aggregate to a hexagons, convert the vector geometries to an image and render it on the map.

Established of web based projects module for the utility permit application utilizing .NET (ASP and C#), ArcGIS API for JavaScript, DOJO, REST, and HTML5. Release management of applications (upgradation) with server administration team and database administration team on the server utilizing IIS and other ancillary tools.

Established end to end ArcGIS infrastructure - setting up ArcGIS for Server, deploying services on it, load balancing services, utilizing ArcGIS for JS in .NET environment for web and mobile platforms.

Responsible of live tracking of display of mobile devices on the ArcGIS for JS web and mobile interface along with the signal variables of these mobile devices, etc.

Development of web based projects module for the utility permit application utilizing .NET (ASP and C#), ArcGIS API for JavaScript, DOJO, and REST.

Responsible of SQL SERVER procedures and jobs to automate massive volume spatial processing such as point to line, point density on millions of points collected across the United States and world.

Management of map and futures services for data display and upload on ArcGIS for server, Arc Catalog, Arc Map, and ArcGIS for Server Manager.

Published of feature and map services of key performance indicators of mobile devices for the points collected across the USA and visualization of them on the web application based utilizing ArcGIS for JavaScript map web interface.

Created of end to end infrastructure and development for displaying spatial layers such as call drop locations, call failure locations, line density spatial data on the map interface.

Troubleshooting issues occurred in web services and ArcGIS for Server, identifying and xing issues with glitches identified.

Clustered of ArcGIS feature services being served from multiple servers, working with the server team to attain load balancing of the services and utilizing the parent layer in the application for upload and data visualization of services.

Data creation, processing, validation and automation of tasks such as creation of heat map raster data for a variety of neighborhood techniques and automating it utilizing ESRI’s Arc Map, Catalog applications.

Created, publishing of image services utilizing Arc Map, Catalog and ArcGIS for Server applications and visualization of these layers on the ArcGIS for JS interface of our web application that signifies the point clusters and its diversity across the United States for the selected states.

Automation of publishing of services to over a dozen ArcGIS for Servers through ArcPY scripts.

Query MongoDB to verify the data in the database.

Automation project setup and deployment in Jenkins for continuous Integration.

Connected to database to Query the database using SQL for data verification and validation.

Performed back end testing on Oracle Database by writing SQL queries.

Created SQL views to aggregate data before moving to targeted database from legacy database to simulate results.

Introduced Kotlin coroutines in order to perform parallel processing on the Android side and utilizing Grand Central Dispatch for asynchronous tasks on the iOS.

Executed mobile test cases on mobile cloud based platforms (Device anywhere, perfecto mobile)

Efficient in the use of BrowserStack, software that provides the ability to test code using different browsers and versions IE, Firefox, Google Chrome and Safari .

Served as a DevOps and Automation evangelist providing thought leadership, participating in conferences, authoring white papers

Provided technical consultation and delivery services to customers for CI/CD and DevOps initiatives.

Fully automating the entire release process from build to test to configuration to deployment.

Enforced a TDD approach while utilizing native testing frameworks such as XCTest and XCUITest for iOS.

Adhered to Google standards Android testing pyramid with jUnit and Expresso for unit, integration, and end to end testing.

Worked on providing the efficient locators strategy like XPath and CSS to run WebDriver script in stable condition.

Performed Cross Browser Testing Using Sauce LABS Enterprise version and Automated that using Jenkins.

Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API.

Preparation and execution of test scripts using JUnit to perform regression testing.

Involved in writing unique XPath using firebug and fire path to identify web elements.

Performed system, functional, black box, UAT (user acceptance testing), and regression testing.

Performed UI and Functional testing on Android and iOS devices (smart phones, tablets) using Katalon Studio.

Tested applications in different types of browsers and versions, such as Internet Explorer, Firefox, Google Chrome to simulate production environment.

Performed Cross Browser Testing Using Sauce LABS Enterprise version and Automated that using Jenkins.

Responsible for overall designed and implementation of all technical solutions for Office 365 environment.

Responsible for Technical Specifications and Design, working with Microsoft for Office 365 implementations, operations, and support.

NCDOT– Charlotte, NC April 2020 – December 2022

GIS QA Analyst

Responsibilities:

Assisted in the entry of information into specific layers of the City's GIS system; performs document research in preparation for data entry using Coordinate Geometry (COGO); enters data through the use of COGO, digitizing or other data conversion methods; enters attribute data using database tools; assists users with the use of GIS products, GPS equipment, large format printers and scanners; and performs basic preventative maintenance on GPS equipment including cleaning and recalibration..

Web GIS interface for end user spatial construction of permit sites and locations utilizing ArcGIS API for JavaScript, DOJO, REST, HTML5, and .NET (ASP and C#).

Application development of add-in tools in creation of I Topological Operator, I Relational Operator for simplified selection of specific feature layers for spatial analysis applications on features such as hydrology, .NET (C#).

Developed of tools to optimally edit, updating, creating and deleting attribute and table data utilizing I Table, I Feature Class, Search Cursor, I Feature Cursor, Insert Cursor, and .NET (C#).

Developed of geospatial tools to the ArcGIS 10.3 utilizing Arc Objects, C#, publishing those tools as web services through ArcGIS and their consumption through desktop client Arc Map 10.3, web interface that was developed utilizing ArcGIS online, and ArcGIS for JavaScript.

Developed of PL/SQL procedures to compile road side features of road side control system application. Identifying non-redundant road sign data based on mile point (linear reference system), roadway ID and other ancillary data. Publishing the procedure online with an user interactive interface, for the internal users such as utility coordinators, utility technicians, to upload inventory data over a MS Excel, .CSV format, or manual entry to dynamically created tables and process and download the distilled data utilizing, PL/SQL, Oracle, .NET (ASP and C#) and deployment of the application on the server utilizing IIS and other ancillary tools.

Utilization of Oracle Spatial functions to convert state of Delaware sidewalk SDO GEOMETRY line string to an LRS geometric segment, splitting them that intersect its intersecting road way and assigning it to the sidewalk features.

Developed of PL/SQL procedures to enhance privileges of selected utility companies, users to a newly developed and embedded state module of the utility permit application and automating primary contact details assignment from existing database.

Upgrading new builds and database schema on the server for test and production application utilizing IIS and other ancillary tools. Maintaining the applications, acting as a point of contact, among external application user, internal application user, application coordinators, clients, developers and architects.

Initiated meetings and holding training sessions for user and coordinator education and exchange of viewpoints of the application.

Developed of add in tools to ArcGIS 10.1 software utilizing Arc Object Model Diagrams, Arc Objects, interface based programming, abstract, concrete and general classes.

Developed of add-in to ArcGIS 10.1 the custom bases selection based on query and spatial location through a simplified dialog box utilizing Feature layers, I Raster layer, I Selection Set,

I Feature Cursor, I Cursor, Search Cursor Table Layers, I Query Filter, I Spatial Filter utilizing .NET (C#).

Development add-in tool to create polygon (multi-part, and ) layer from user created points and points shape le or geodatabases, in addition to capturing user based events utilizing I Geometry, I Point, I Point Collection, I Geometry Collection, .NET (C#), etc.

Trained, guided and educated peers in ArcGIS, Arc Objects, and their geospatial analysis components utilization in .NET (C#) and development and customization of add-in to ArcGIS 10.1. Troubleshooting glitches, bugs and errors from the software developed by peers encountered from miscoding in implementations of Arc Objects interfaces, and classes.

Developed of a GIS workflow in Model Builder that create a Kernel-Density map and clips to a specified geometry layer, ring buyers (using geo processor object with IGeoprocessor2), spatial joins and KML model outputs and embed the models in Add-in button components utilizing Arc Objects, ArcGIS 10.2 and .NET (C#).

Deployed, upgraded, settings updating, and software configuration of Mobile Work order System software on Motorola MC65 devices and its communication using windows mobile application.

Prepared weekly productivity reports and submitted test metrics to the management.

Attended day-to-day meetings for providing regression status of existing functionality.

Application onboarding and maintenance on the CI/CD platform.

Installed, administered and maintained of CI/CD applications: Jenkins, Artifactory, SonarQube, Stash and Docker.

Integrated Appium with Sauce labs for distributing tests on the cloud and integrated Appium with continuous integration tool Jenkins.

Experience in Selenium Robot Framework (Keywords, test suit, test cases and python script creation) for automation testing of BO reports.

Implemented simulator for Mobile App Testing in Android Platform using Appium.

Implemented SOAP UI for Webservices Testing.

Responsible for documenting the Automated Test results using SOAP UI.

Cucumber is a tool based on Behavior Driven Development (BDD) framework which is used to write acceptance tests for wed applications

Implemented a practice of cross-browser testing via automation ( Selenium Webdriver ) and introduced the use of tools such as Ghost Labs and Browserstack for cross-browser and cross-platform testing (tablet and mobile) and automation

Performed API testing (SOAP and REST) using Parasoft SOA and Postman and SoapUI.

Performed web Service performance testing using JMeter for Restful web services

Implemented end-to-end Angular-JS application testing using Protractor, typescript with cucumber framework

Ensuring smooth execution of GUI testing using various tools : BrowserStack, JIRA

Designed and developed internal quality control system in different environment : Windows, Linux, Mac,IE, Firefox, Safari, Chrome

Prepared Test Cases with the complete description of requirements, uploaded test cases and report results into Jira.

Worked with a variety of programming languages including but not limited to Java, Kotlin, Objective-C, Swift, and JavaScript.

Writing unit tests with XCTest and jUnit focusing on delivering 80% code coverage across platforms.

Identified the defects and worked with the development team to fix the defects.

Illinois Department of Natural Resources- Springfield, IL January 2018 – March 2020

QA Tester

Responsibilities:

Review product requirement documents, functional specifications, and involved in developing test strategy, test plan and test case documents.

Worked with NoSQL databases like Hbase in creating Hbase tables to load large sets of semi structured data coming from various sources.

Provided technical consultation and delivery services to customers for CI/CD and DevOps initiatives.

Perform automated testing of a web-based application using Selenium WebDriver.

Involved in development of Hybrid Test Framework using Selenium WebDriver, Maven and JUnit.

Developed and Executed JUnit Test Cases using Eclipse IDE.

Used confluence to document CI/CD process for automation and tracked any changes in existing automation spaces within confluence

Storage, access and management of cleaned up data in Oracle RDBMS and visualize it using ArcGIS 10.1.

Customization, application development, extension and testing of ArcGIS functionality utilizing Arc Objects 10.2, .NET (C#), and Oracle RDBMS (and Oracle Spatial) for visualization of LiDAR mobile truck visibility angle windows of cameras from four sides although the data acquisition of road networks of sign extraction.

Development of number of complex PL/SQL procedures, functions, triggers, and packages for efficient archival and retrieval in situ acquired road signs data (Camden county, NJ) extracted from mobile LiDAR data point clouds and its associated imagery.

Used Selenium Webdriver with TESTNG and sauce labs for frontend automated Testing and cross browser testing. In terms of backend Used Ready API (licensed version of SOAP UI).

Created test cases, test plans, tested API’s, wrote JUnit test cases, executed code coverage, wrote automation scripts using Selenium, executed database queries for testing purposes and led different projects in the shipping and checkout domain.

Implemented Selenium WebDriver and executed tests in parallel that helped reduce the execution times significantly.

Hands on Experience in testing the Mobile applications, Unit testing using Espresso library for Android and XCTest for iOS.

Experience in automating the chase freedom mobile application and chase pay mobile application by writing the feature files and step definitions using Java and Cucumber framework .

Integrated Selenium WebDriver with JUnit Framework and selenium remote control using Java Driver.

Implemented and worked on Acceptance Test Driven Development (ATDD) agile methodologies completing releases ahead of schedule.

Participated in daily SCRUM meetings and testing each SPRINT deliverables.

Closely involved with development team, maintenance team and business team regarding changing requirements, builds and releases.

New project onboarding on the CI/CD platform.

Maintenance, taking backup and recovery of CI/CD tools, jobs and scripts.

Started integrating Kotlin into the Android mobile application moving the application forward.

Using DevOps (Jenkins) for continuous integration and development.

Maintained and executed test cases using HP Application Lifecycle Management (ALM).

Enhance script on Unified Functional Testing (UFT) by adding Reusable Actions, various types of checkpoints, Synchronization points, parameterization and Modular tests.

Tested the data mining from the back end and wrote simple & complex SQL quarries in Oracle and Sybase to ensure data integrity, validity and scalability.

Worked with a variety of programming languages including but not limited to Java, Kotlin, Objective-C, Swift, and JavaScript.

Writing unit tests with XCTest and jUnit focusing on delivering 80% code coverage across platforms.

Occasionally assisting backend team with bug fixing in JavaScript.

Ran Sanity Tests once the code is deployed to any new environments to verify whether any codes are breaking in new environments.

Used confluence to document CI/CD process for automation and tracked any changes in existing automation spaces within confluence

Agile/Scrum methodology with two-week sprints and a monthly release cycle.

Github and Source Tree for source control, JIRA for task management, and Confluence for documentation.

Performed Backend testing for data validation using complex SQL quires by joining multiple tables.

Prepared weekly status report. Participated in daily Scrum meeting and all Sprint meetings.

Performed defect reporting and bug tracking using JIRA and also followed up with development team to verify bug fixes, and update bug status.

Participated in all meetings held during the project, and actively co-ordinates with developers and business team.

Citibank - New York, NY July 2016 to December 2017

QA Tester

Responsibilities:

Involved in different phases of Software Testing Life Cycle like Requirement Analyzing Phase, Test Design, Test Execution, and also proficient in documentation.

Conducted Manual Testing to check Rate Quote System which is a web-based application.

Analyzed requirements designed and developed Manual test plans, test designs, test cases and test scripts used in system integration, acceptance, and regression testing.

Performed Manual Testing on different Modules of the Application.

Performed Manual Testing of the application as well as identified the critical test scripts to be automated.

Executing Test Cases manually and to check the functionality of application and reporting Bugs using bug tracking tool.

Used Quality Center for tracking the defects.

Updated QA status report and application database for management reporting purpose.

Created error/ defect reports and communicated with developers, scripter and application owners for application defect tracking & resolution.

Experience in Software Verification, Validation and Testing Methodology.

Expertise in Posting Defects in Bug Tracking Tools.

Evaluated existing quality assurance methods and implemented cost-effective upgrades.

Worked on System testing, User acceptance testing (UAT) for a responsive design of the interface.

Involved in various phases of SDLC such as Design, Development and Testing.

Participated in process design / modification meetings which helped to later define various Testing scenarios and Test Cases.

Prepared detailed Test Plan and Test scenarios for manual and automated testing.

Involved in all stages of testing process including development of Test procedures, Test cases based upon requirements and performing functional test, regression test, integration test and end user tests.

Summarize test results in formal test analysis reports according to the Documentation standard.

Involved in writing SQL queries for validation of data from source to target table.

Familiar with all testing cycles.(Functional, System, Regression and UAT)

Created and enhanced automated scripts using various advanced features offered by QTP.

Developed the test automation scripts for automated testing of the application by using Quick Test Pro.

Updated existing test cases and wrote new test cases as per the requirement.

Supporting the lead in terms of Review of Test Cases and Business scenarios.

Contact this candidate