EMPLOYMENT HISTORY:

Confidential, DC

Sr. GIS Application Developer

Responsibilities:

• Developed web and mobile map apps to support DPW field operations like bulk collection, street alley cleaning, leaf collection and other high priority projects.
• Maintained DPW operational spatial database
• Developed and enhanced DPW web and map services to support mobile and web apps

Confidential

Sr. GIS Solution Architect

Responsibilities:

• Developed and enhanced web services to support Fair Lending and CHAT Mapping Modules for 12 Federal Reserve Bank inspectors.
• Provided web, app, database and service tiers support.
• Constructing geo - stats web apps to do surface modeling, hot and cold-spot analysis to ensure over 30 million mortgage loans meeting the federal banking regulations.

Confidential

Sr. IT Specialist

Responsibilities:

• Developed Geospatial web services for 311 call center operations using ESRI’s .net Web ADF:
• 4 modules: street address validation, intersection, highway exit and point of interests (PLOI) the web services will drill through 40 polygon and 20 line feature classes and search over 30 point layers.
• The web services got 2010 NACO Achievement Award
• The technical paper was accepted by WMSCI 2011 (World Multiconference on Systemics, Cybernetics and Informatics) for presentation.
• Developed 5 major web mapping applications using ESRI’s Flex API 1.3 and 2.1
• Direct invitation by Esri CEO to write an article on our ways of “constructing snow apps” for ArcNews.
• Developed .net-based web application (DataMCMD) to allow public developers to consume our GIS web services, also can search for downloadable datasets. Those datasets can be viewed in Google Map and Google Earth. DataMCMD also provided app showcases on desktop, web and mobile aspects.
• Developed extensive map services, geoprocessing services, globe services, geocode services and KML capacities & map caching capacities of ArcGIS Server.
• Developed iPhone-based property locator using ESRI’s iPhone SDK.
• Developed ArcGIS and SQL based stored procedures to QA 62 feature classes to ensure data meet spatial and business standards.
• Ensured the map display correctly in Altaris View (CAD application used by Public Safety).
• Maintained 8 ArcSDE instances to serve county-wide Geodatabase services.
• Developed Web services of locating ADC Map grid by given addresses and street-intersections by given a street, those services are currently used by MC-DHCA and MCPD.
• Developed the police event application using ESRI’s ArcGIS server templates and non-ESRI web controls, this is used by mobile units by MCPD to locate real-time crime events by Police Beat/PRA/District.
• Interviewed and screened GIS professionals for other departments within Confidential, MD

Confidential, Richmond, Virginia

Spatial Technology Services Manager

Responsibilities:

• Developing the Enterprise-GIS system architecture and implementation: Clustered/Redundant Web, Application and Database Servers; SAN for central storage
• Developing server-side based GIS Applications for intranet and internet use using ESRI’s ArcIMS, ArcSDE 9 and Oracle’s Oracle 9i/10g database system and Real Application Cluster (RAC).
• Performance tuning the repository database - 4 TB in size
• Performance tuning ArcIMS Map Services
• Developed spatial (mainly imagery) data loading store procedures
• Performed system, database and application level Stress Test on Web and ArcIMS Servers; provided recommendations to resolve system and application performance limitations.
• Implemented State-Wide Geospatial Data warehouse using ArcSDE 9, Oracle 10g database system and Go Sync to provide reliable and secure enterprise data management by updating multiple SDE’s and Personal geodatabase with update packets containing only changes.
• Providing technical directions and procedures on Virginia State-Wide Road Center Line (RCL) Project:
• Developing QA/QC procedures to validate the Locality Source Spatial Files
• Developing Geodatabase QA/QC Procedures to QA the conflation process
• Developing the automated routines to export the conflation results to Locality and VDOT versions
• Providing technical support to state GIS vendors and state agencies in major aspects of Arc/Info, ArcGIS, ArcSDE and Geodatabase implementations.

Confidential, Washington, DC

Sr. Spatial Database Engineer

Responsibilities:

• Supported DC Citywide Geodatabase Operations for the following District-Wide Intranet and Internet
• Performed a Leading Role as Senior Spatial Database/Oracle Database Administrator:
• Collecting, organizing and structuring information contained within a variety of formats (e.g. shapefiles, flat files, comma delimited files, data tables, etc.) for inclusion in the database design.
• Designed/implemented/managed A Multidimensional Spatial GeoDatabase for OCTO using ESRI’s ArcSDE 8.3 and Oracle 9i Enterprise Edition.
• Designed, developed and implemented data structures/geodatabases within an ESRI ArcGIS and ArcSDE environment.
• Supported Oracle developers/other application users, performed database tuning, created database reorganization procedures, database alert scripts, monitoring scripts and backup procedures.
• Managed user accounts and conducted database backups/restores ; used DBMS diagnostic tools and wrote code (scripts and triggers) for active control and Q/A of database.
• Created and maintained development, staging and production environment to support various stages of new application development in need of Geodatabase/Database Support.
• Provided Geodatabase support for the Agencies within District of Columbia Government

Confidential, Washington, DC.

Sr. Spatial Database Administrator /Sr. GIS Application Programmer/ Team Lead

Responsibilities:

• Developed Intranet/Internet Web-based GIS applications - Resource/Business/Financial Locators using ESRI’s MapObjects /IMS Server technology, Microsoft’s IIS Server and SQL Server: built clients/servers using HTML, JavaScript, Active X, VB/MapObjects components and ASPimplemented client/server transactions, configured IMS/IIS servers, administrated multiple “stateless” map servers, conducted end-user training.
• Built high-end routing capabilities for MBDA’s Resource/Business Locators using
• MapQuest’s Locator APIs, the applications offer accurate geocoding, highlighted routes and drive time calculations.
• Developed Sagent-enabled address validation tool for MBDA’s Web Portal.
• Developed web-based GIS applications/tools for MBDA using ESRI’s ArcIMSColdFusion, Java, JavaScript, ArcSDE and Oracle Systems: registers minority businesssorts the database each nightrefers opportunities to the customers via email or fax automaticallyprovides the customers with the dollar amount of the contract, time, and place for delivery, contact information and bonding requirements when a match is made.
• The international Trade/Aquaculture/the Franchising Virtual Centers Online.
• The unique Internet software application allows the general public to search for specific resources that offer business-related assistance.
• Minority-owned business statistics.
• Minority population and other demographic information.
• Minority Business Development Agency funded centers and strategic partners.
• Business development and financial resources.
• Minority Business Development Agency program services and investments.
• Designed/implemented/managed A Multidimensional Spatial Data Warehouse for MBDA using ESRI’s ArcSDE and Oracle’s Oracle Spatial and Oracle Express Server-OLAP.
• Managed the distributed and networked N-tier Enterprise Geodatabase: integrated ArcSDE with Oracle Spatial. customized storage for ArcSDE vector, raster, and Oracle Spatial data. monitored and optimized data access. managed a multiversioned Geodatabase.
• Performed installation tasks for oracle8.0, and 8.1. Configured the OEM
• Management Servers, and other OEM tools, including the Intelligent Agent, and NET8 (tnsnames.ora, listener.ora and sql*net.ora) configuration.
• Performed database design, implementation, and the creation and tuning of data aggregation mechanisms.
• Handled extensively the Data Modeling, both Logical and Psychical.
• Designed and implemented logical and physical databases, optimized and tuned structure using Erwin.
• Conducted Server Programming using PL/SQL i.e. Stored Procedures and Triggers.
• Assisted Database Development team with daily tasks such as implementing changes to Database Schema.
• Performed Export/Import and load data using SQL*Loader
• Developed and maintained Backup and Recovery plan (recovery of database in case of media or instance crash), performed and monitored Performance Tuning for development, QA and 7x24 production databases.
• Developed a method for configuring EMC disk arrays for data warehouses and created a system for detecting I/O bottlenecks.
• Performed Query Optimization, SGA Sizing, maintaining Disk I/O & fragmentation. Involved in Performance Tuning, Tuning Memory Issues like SGA sizing by setting DB BLOCK BUFFERS, SORT AREA SIZE, DB BLOCK SIZE and other INIT.ORA Parameters.
• Wrote and maintained different scripts for Performance Tuning/Backup and analyzing the tables.
• Supported Oracle developers/other application users, performed database tuning, created database reorganization procedures, database alert scripts, monitoring scripts and backup procedures. Developed Web applications utilizing Oracle Developer 6.0 (Forms and Reports), PL/SQL cartridgesOracle (Web) Application Server, HTML, and JavaScript.

Confidential

Sr. GIS Systems Analyst/Project Lead

Responsibilities:

• Administration of Oracle databases for Confidential ’ Radarsat projects.
• GIS User-Requirement Analysis and Benchmarking for Providence Water Supply Board, Rhode Island.
• GIS implementation support for introducing GIS into the Ontario's Timber Management Planning Process.
• Merging of inventory data from various sources (e.g. field plots, large-scale photography and satellite imagery) onto various base maps.
• Development of various database management systems (forest inventory, soils).
• Down- and up-loading of data from various hardware/software combinations.
• Adaptation of GIS technology to forest management planning, habitat assessment, scheduling and wood supply projections for various clients across Canada.