EXECUTIVE SUMMARY:

• Confidential has extensive experience in all aspects of software development lifecycle.
• She is passionate about designing, developing and delivering solutions and products, identifying and solving issues.
• She is a team player with leadership and project management skills, with great ability to research, learn and apply.
• 15+ years Software/Web Development and Engineering, IT operations and maintenance
• 15+ years GIS development & Geospatial analysis
• 10+ years Data Warehouse, ETL, process automation and BI reporting;
• 10+ years exposure in healthcare and federal government sector
• 5+ years SQL Server database development & administration
• 5+ years Agile Scrum/Kanban development
• 5 years QA/QC automated testing

TECHNICAL SKILLS:

Programming Languages: ASP.NET, C#, Python, HTML, JavaScript, HTML5, CSS3, PowerShell, VB, VBA, Java, C

Web Development Technologies: ASP.Net, IIS server management, web deployment transformations; AJAX, Dojo, JQuery, Web Services, WCF, SOAP, REST, JSON, CSS, XML, XSLT, XSL - FO, Fo4Net PDF, SSRS Web Service API, SharePoint, Telerik, MVC, .NET Core, Angular;

Software and Tools: Microsoft Visual Studio, XMLSpy, Fiddler, FireBug, WebWave, Resharper, SilkTest, TestPro, Proof, SharePoint, SonarCube, HPFortify, Splunk, RoboHelp, Flex Builder, JBuilder, MS Visio

CM/Repository/Ticketing Tools: Atlassian JIRA, Bitbucket, Git, Bamboo, Source Tree, Confluence, Team Foundation Server (TFS), Visual Source Safe (VSS), Clear Case

Business Intelligence: SSRS reports, Corda Centerview charts, InstantAtlas dashboard, Google Charts, SSRS Charts; Hyperion reports; Tableau dashboard

Database Platforms: SQL Server, MS Access, ArcSDE, Oracle;

Data Warehouse & ETL Technologies: database design and data modeling

GIS Frameworks / Toolkits: ArcGIS Server, ArcSDE, ArcCatalog, ArcMap, ArcGIS Server Web Service APIs (JavaScript, Flex, WPF, Silverlight), Google Maps API, GDAL FWTools247, ArcObjects, ArcIMS, MapObjects Java

Processes / Compliances: Agile Scrum & Kanban Methodologies, CMMI Level 4 Processes, Section 508 Accessibility Compliance, HIPAA Compliance

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Data - driven design and test-drive approach;
• Varied Web applications using ASP.NET, C#, HTML, CSS, JavaScript, MVP, Entity Framework, LINQ, etc.;
• Locator and map tools using Google Maps API, AJAX, jQuery, ArcGIS JavaScript API, etc.;
• Web Service API using WCF, C#, JSON, GeoRSS, XML etc.;
• Intranet application using Active Directory;
• Configuration data encryption, decryption and transformation;
• Secured portal applications with password managements;
• Windows Service development and installation;

Confidential

Responsibilities:

• Locator and web map tools using varied technologies such as Google Maps API, AJAX, jQuery, ArcGIS JavaScript API, Dojo, etc.;
• GIS/map development using SDK framework such as ArcObjects, MapObjects Java, ArcGIS Javascript API, WPF API, GDAL, etc.;
• Spatial analysis and mapping tools using ArcGIS WPF API, Flex API, Java Script API;
• Geoprocessing workflows using ArcGIS Model Builder and Toolbox tools, to generalize, simply, Check and Repair Geometry, Spatial Join, Overlay, Fishnet, etc.
• Census administration boundary and demographic data download, processing, and loading;
• Geospatial boundary dataset generation and analysis, such as Rural Health Areas, Medical Underserved Areas, Heath Professional Shortage Areas, etc.;
• Python scripts for data processing, thumbnail image generation, ArcGIS server service publishing, administration and performance testing, etc.;
• Enterprise geodatabase ArcSDE administration and management;
• Spatial data manipulation and analysis on SQL Geometry columns;
• Map/ feature service design, development, optimization, administration, publishing etc.;
• ArcGIS for Server and Desktop installation and configuration; ArcGIS platform upgrades;
• ArcGIS license management and license server administration, ArcGIS Online credits managements etc.;
• ArcGIS Performance tuning and load balancing;
• Knowledge and light experience of Portal for ArcGIS, and ArcGIS Platform;

Confidential

Responsibilities:

• Data modeling and database design for OLAP databases for data warehouse
• Data modeling and database design for OLTP databases for data transactional system
• T-SQL procedures, functions, triggers, computed fields design and development
• Spatial data manipulation and analysis on SQL Geometry columns
• Census administration boundary and demographic data loading and processing
• Geospatial boundary data generation, analysis such as Medical Underserved Areas, Heath Professional Shortage Areas, Rural Health Areas
• Data statistics and aggregation calculations,
• Data relationship and dependencies analysis for change
• Data marts design, development and maintenance
• Complex database queries or views for data analysis, validation, examination
• Data import, export through SSIS packages, bulk loading, with csv, txt, xml formats
• Generate and distribute daily refreshed JSON data file or csv downloadable files serving applications servers
• Data dictionary and metadata design and maintenance
• Database integrity and standards and conventions compliance
• Oracle PL/SQL development (long time ago)

Confidential

Technical Lead

Responsibilities:

• Database backup, restore and synchronization across development, test and production environments
• Database recovery
• Database compression for disk space management and growth management
• Linked server objects creations
• SQL Server installation, configurations, upgrade
• SQL Server Agent jobs to execute stored procedures or SSIS packages on nightly data refreshes for the data warehouse
• SQL Server Agent jobs to execute windows batches or python executables on task automation
• SQL Server database mail setup and notifications alerts configuration
• SQL Server maintenance plan to regularly purge processing logs
• SQL Server security compliance and access control
• Troubleshoot and resolve issues for the team

Confidential

Responsibilities:

• Key performance indicators design for reporting
• Designed and developed ETL workflow from OLTP source system into OLAP data marts designed for reporting;
• Numerous SSRS reports, linked reports design, development, deployment,
• SSRS reports with parameters and user interactions with filters
• SSRS reports on multi-level data grouping and aggregation
• SSRS Reports with embedded dynamic maps from scripting
• SSRS report server management, installation, administration, upgrades
• SSRS reports authentication and secured access from applications
• RS Scripter for SSRS reports migrations across servers
• Table pivoting for time series analysis and reporting
• Experience with InstantAtlas (a BI tool with interactions between map, charts and tables)
• Exposure and training on Tableau dashboard development and administration.
• Splunk training on data mining, searches & reporting, and knowledge objects creation

Confidential

Technical Lead

Responsibilities:

• Windows Server 2012 administration, user and groups, server shares and security policy configuration
• SSL certificates installation and websites HTTPS configuration
• IIS server and sites configuration export and import
• IIS server administration, admin commands scripting to automate IIS pools restarts and websites restarts
• Power Shell scripts or batches development for Windows scheduled task automations
• Windows services installation, maintenances and administration
• Monthly security patch identification and server patching

Confidential

SQL Server DBA

Responsibilities:

• As QA programmer d esigned and developed in-house test and diagnosis tools to help discover the GIS software performance problems ;
• D eveloped component test DLLs for ArcGIS Server for unit testing as QA programmer;
• Compiled test plans, prepared test data and programmed test scripts for automated testing of the ArcCatalog product using the SilkTest software ;
• Reviewed test plans, test cases and test scripts as Tech Lead;
• Coordinated functional testing and stress /performance testing as Tech Lead;

Tech Lead

Confidential

Responsibilities:

• Manage full software development life cycle (SDLC);
• Lead projects using Agile Scrum and Kanban methodologies following Capability Maturity Model Integration (CMMI) process;
• Meet with clients for requirements solicitation, definition and analysis;
• Collaborate with product owner on creating product and Sprint backlogs;
• Conduct project technical planning: identifying tasks, conducting Sprint capacity estimation and resource planning, prioritizing and tasks assigning;
• Lead the system design and reviews, oversee project development and track team progress, facilitate issue solving, monitor and mitigate risks, review and merge codes for release management;
• Hold periodic in-progress-review or demo meetings with the clients. Review and mitigate security risks;
• Compile deployment plan, coordinate or perform system deployment, compile release notes and other EPLC / SDLC documents. Prepare weekly & monthly status reports, contribute to performance metrics.
• Used Java frameworks and developed new features such as Image decoders to support different types of image formats as part of the ArcIMS Java toolkit software release. Analyzed and designed UI for an online image and metadata retrieval feature. Researched and implemented solutions for the image extraction and a statistics feature ;
• Designed and developed in-house test and diagnosis tools to help discover the product performance problems. D eveloped component test DLLs for ArcGIS Server for unit testing. Compiled test plans, prepared test data and developed test scripts using SilkTest Script for automated testing of the ArcCatalog product using the SilkTest software.
• D evelop customization samples in VB and VBA for products such as ArcCatalog, ArcMap and ArcObjects . D eveloped demo applications for the ESRI Internal User Conference and lab sessions for the technical workshops ; D eveloped tutorial samples of the toolkit for the Tutorial Book, developed Object Diagram Model, contributed to the Programmer’s Guide book ; Worked on Internationalization and Localization of the product.