● Worked on data migration project to migrate data from APDM6 to PODS. Worked as ArcGIS database administrator to help store and maintain both spatial and attribute data for valve, meter, pipeline etc. in enterprise GeoDatabase. Leveraged enterprise hardware and software to support the evaluation of needs, licensing, and implementation for the efficient storage and delivery of geospatial data.● Created reports for PHMSA/NPMS, Public Awareness, Tax, Operations, Compliance, and Integrity for financial, risk analysis and regulation purpose. Provided proactive and effective communication and coordination with the Company’s Regulatory Compliance in regards to leveraging existing data sets.● Managed data migration project, pipeline editing tool testing project, data cleansing project and assist data editing. Led GeoDatabase health check project with ESRI.● Helped develop and implement QA/QC procedures including geospatial data management and metadata documentation. Implemented controls and compliance metrics to reduce data issues and improve data quality.● Worked on EMap project to publish pipeline data through GIS Portal. Worked on the Flex View GIS Web Application for internal stakeholder interaction. In charge of GIS reporting website development using ASP.net. Implemented data migration using C#.net.● Developed, documented and provided training to stakeholders and users of GIS. Design and document work process improvement initiatives, led discussion of process alternatives in order to arrive at best practices.

● Managed Parcel Data Analysis projects to add millions revenue each year to the bottom-line. Assisted customer analysis in a comprehensive residential marketing program designed to bring in new customers while achieving over $65 million in lifetime revenue in year one.● Created database protocol for building, maintaining, and mining of databases. Queried ArcSDE, Oracle, SQL Server, Access, IBM AS400 database for data mining.● Managed staff and coordinated with other work units; provided training and team building to less experienced team members; consulted and reviewed hardware, software and data needs to ensure system development; managed the design and implementation of production standards and procedures for development of associated databases and products.● Helped the business analysis, development and implementation of GIS applications for pricing and operations.● Provided professional GIS support to build, develop and implement business solution; customized and automated routine processes using Python, Model builder, C# and ArcObjects. Designed application to work with Access, Microsoft SQL Server 2008 database and procedures using TSQL, stored procedures, and C# programming; designed field audit tools using ArcPad, ArcGIS Mobile and ArcGIS Server.● Assisted financial reports using SQL Server, IBM AS400, Excel modeling etc.

● Supported the exploration activities of the Rovers on Mars using GIS tools and technology; Administrated ArcIMS.● Provided accurate and timely mapping products for NASA scientists to support the exploration activities on the Mars.● Worked as a TA for GS634, a course of GIS project development and implementation including designing geodatabase, digitizing, georeferencing, geocoding, linear referencing, dynamic segmentation, GIS system development using ArcObjects and Visual Basic. Designed web GIS development using Google Earth and Google Map API.

● Worked as project manager, analyzed the feasibility of Shanghai CBD underground complex construction.● Analyzed O-D distribution and pedestrian characteristics for Shanghai 2010 World EXPO Axis.

● Assessed transportation route choice, landscape view, and flood influence using ArcGIS and ERDAS IMAGINE.● Created maps, tables, and reports for planning projects using AutoCAD, Photoshop, Word, PowerPoint and Excel.● Conducted presentations for clients and public agencies using PowerPoint.