Business Analyst, Project manager, PeopleSoft Developer

SOWJANYA SUNKARA

**** ***** ***** ****, *** ****, San Diego, CA 92122

Phone: 405-***-****, Email: *******.***@*****.***

SUMMARY:

• 4 years of experience in Web applications design, development and implementation.

• Experience with .NET technologies such as C#, VB and ASP.NET and .NET framework 2.0 through 4.0

• Experienced in designing websites using HTML, DHTML, XML, CSS and scripting using JavaScript, Perl and Python. Possess good understanding of the HTML DOM.

• Developed backup routines using Python scripts and have working knowledge of Perl scripts

• Installed, configured and Administered Oracle database 9i/10g on windows platform. Database maintenance and development experience using SQL Server 2005.

• Strong hands on experience with Microsoft Visual Studio 2005/2008/2010, Team Foundation Server and IIS.

• Worked in a team to gather client requirements, technical systems design and documentation for various projects. Possess excellent written and oral communication skills.

EDUCATION:

Master of Science in Computer Science Dec 2006

Oklahoma State University, Stillwater, OK. GPA 3.88/ 4.0

Thesis: Indexing in Spatio-Temporal Databases for Space Time paths (Trajectories)

Certification in Geographical Information Systems (GIS)

Bachelor of Engineering in Computer Science May 2004

University of Madras, Chennai, India

SOFTWARE and GIS SKILLS:

Programming & Scripting Languages: C, C++, Visual Basic, ASP.NET(C# and VB), ASP

Other Languages: HTML, XML, CSS

Scripting Languages: Python, Javascript

Software Platforms and Applications: MS Visual Studio 2010/2008/2005, MS Team Foundation Server

Database: Oracle 9i/10G, MS SQL Server 2005, MS Access

Content Management Tool: Microsoft Sharepoint Portal Server 2003 and Windows Sharepoint Services

Web Server: Internet Information Services 5.0/6.0

PROFESSIONAL EXPERIENCE:

Senior Software Developer Mar 2010 – Present

Technisource, Inc San Diego CA

Client: Sempra Energy Utilities, San Diego, CA

Project: Development of a custom C#.NET 3.5 project with VS.NET 2008 called Assessor Map.

• Designed and developed an Assessor Map tool for searching Baker Parcels of California and returning the corresponding TIFF files. An ASP.NET page handler (.ashx) is used to build this tool.

• This tool takes the FIPS and APN as input an searches through the folders that hold the Parcels and returns the corresponding TIFF files that match the APN and FIPS

• The TIFF files are then converted to PDFs using the DLLs from the VeryPDF tool. The PDFs are stored on the server and can be accessed in another web application through a URL.

• The JSON output of the Assessor Map tool is used in a ArcGIS Silverlight web application to return the tax parcels.

Project: GEARS (Geospatial Environmental Analysis and Reporting System) PHASE 2 (Ongoing)

Design and Development of Microsoft Silverlight web application with Visual Studio 2010/.NET Framework 4.0

• Actively participated and co-ordinated with Clients and Business Analysts in gathering requirements for the second phase of the Project.

• Gathered inputs from Environmental Specialists about the changes to the Web interface and web tools functionalities.

• This application originally built in C#.NET /ArcGIS Server Web ADF is migrated to ArcGIS API for Microsoft Silverlight 4.0/.NET Framework 4.0

• Created Design documents on the modifications to the front end of the Silverlight application.

• Responsible for End-End testing, reporting and fixing bugs of the web application on all environments after the install.

• Created WCF (Windows Communication Foundation) services and hosted in IIS which in turn is used by the Silverlight application to connect and retrieve data from Oracle and SQL server databases.

Project: GEARS (Geospatial Environmental Analysis and Reporting System) PHASE 1

Maintenance and Enhancement of GEARS web application (Visual Studio 2008/C#.NET/ArcGIS Server 9.3.1 SP1 Web ADF/ArcFM Server)

• Developed new functionalities for the C#.NET web application.

• Analyzed existing Source documents and involved in troubleshooting /issue resolutions through out the Project.

• Responsible for modified Oracle Database tables schema based on the requirements of the Users.

• Performed eight outages in the PRODUCTION application to incorporate functional changes and enhancements to the custom ArcGIS Web ADF tools in C#.NET.

• Coordinated with Business Analysts on preparing new Data and using Spatial ETL tools to load new data into the database and updating old data.

GIS Applications Developer Feb 2007 – July 2009

PhotoScience, Inc St.Petersburg, FL

Project: .NET Framework 2.0/C#.NET /ArcGIS Server 9.3 Application for Floor Plans,

Client: MacDill Air Force Base, Florida. June 2009 – July 2009

Responsibilities:

• Designed and developed an ArcGIS Server 9.3 application using C#.NET to support the management of the Base Custodial Services Contract by maintaining an accurate status of building square footage, floor configuration, floor material, and room-level custodial level of service.

• Provided customized Search functionality for users to search by a Room ID, Building number or Floor ID or a combination of the three.

• Automated the generation of reports/map products for multiple rooms within a building, multiple floors with in a building, or multiple buildings.

• Involved in the Design, Implementation and testing phase of the application.

• ArcGIS Server is being used as the map serving technology. The map service is consumed by an ASP.NET application developed in C# with AJAX technologies.

Project: Automation of Backup Scripts for Oracle 10g Database

Client: MacDill Air Force Base, Florida, May 2009 – June 2009.

Responsibilities:

• Developed file system backup using Python scripts. This script creates a Personal Geodatabase of all the Feature datasets present in the Oracle database.

• Model Builder is used to test the geoprocessing script.

• This script is run at regular intervals to backup all data from the Oracle database.

• Implemented database backup and recovery routines using RMAN in Oracle 9i. The scripts are scheduled to run every night to take hot backups of the database.

• Modified ArcSDE compression script to include all existing layers. This script compresses all the layers (edited) which in turn help in fast database backup.

Project: ASP.NET/Migrating an ArcGIS Server Application Project, Jan 2009 – Apr 2009.

Client: Florida Department of Health (Hazard and Vulnerability Assessment)

Responsibilities:

• Migrate all the functionalities of an existing ArcGIS Server 9.2 written in VB.NET application to 9.3 version.

• A functionality that allows selection of Multiple Layers from an ASP.NET Dropdownbox when generating a buffer is implemented. The user will to be able to select more than one layer from a Drop down list and have the buffer select features contained in those layers falling within the buffer; when the content is displayed as a list of their attributes grouped by feature. This will cause an Export button to export one file per feature to a CSV format.

• Used Master Pages, themes, HTML and CSS for styling the web pages.

• Used Visual Studio .NET for developing components.

• Iteratively updated Training Manual with clear instructions on how to use the new capabilities in the application. Any changes in End User functionality that resulted from the upgrade are also updated.

Project: ASP.NET/ ArcGIS Server 9.2 Application Project, May 2008 – Aug 2008.

Client: Florida Department of Health (Environmental Health Water)

Responsibilities:

• Redesigned and migrated the existing FDOH’s ArcIMS application (Javascript) called EHWater (Environmental Health – Water) to ArcGIS Server 9.2 environment (VB.NET) according to the users’ requirements.

• Developed the user interface using ASP.NET Master Pages, HTML and CSS.

• In addition to out of the box ArcGIS Server tools, the new application includes Select tool, Buffer tool, a tool to export the user Query results from Selection and Buffering to an Excel spreadsheet.

• Designed and implemented components that convert disconnected record sets to valid XML that is transformed by XSL/XSLT files to HTML.

• The web application was developed in VB.NET with an Oracle database back-end.

Project: C#.NET/ArcGIS Server 9.2 Application Project, Jan 2008 – May 2008.

Client: Florida Department of Transportation

Responsibilities:

• The overall purpose of this application is to provide a browser-based spatial data access application. This is used to visualize and analyze GIS data that are maintained in the District 7 enterprise GIS database.

• Involved in the SRS Review / Update, Design, Implementation and testing phase of the application.

• Worked with AJAX panels and other controls to improve the look and feel of the application.

• Libraries are built to handle spatial selection tools like Select, Buffer, Create Area and multi layer Select, the results from which are shown in a DataGrid that can be exported to an Excel spreadsheet.

• Used ADO.NET for retrieving, querying, storage, and data manipulation for achieving continuous database connectivity.

• Involved in Documentation, Unit and Integration Testing and Debugging.

Project: CADD Interoperability ArcGIS 9.2 Application (CIA)

Client: Florida Department of Transportation

Responsibilities:

• Developed a Windows Console application that imports feature classes from source FPN folders containing different sets of CADD drawing files into the FDOT District 7 Geodatabase.

• Involved in the SRS Review / Update, Design, Implementation and testing phase of the application.

• This management console helps the Manager to list FPNs, select a list of FPNs, list/modify email addresses choose particular FPNs to read from a list.

• This process is performed using an automated extract-transform-load (ETL) model which is automated using ArcObjects DLLs (C++ Assemblies) and the results of this process are geographic features and attribution in the geodatabase.

• Used ADO.NET for retrieving, querying, storage, and data manipulation for achieving continuous database connectivity.

• C# was used for designing the GUI and also for event handling purposes in the win forms.

Project: South Carolina Coastal Waterbody Classification Project

Client: South Carolina Department of Health and Environmental Control (SCDHEC)

Responsibilities:

• Designed and developed a Desktop based GIS application that consists of a Query Interface in ArcMap to assist South Carolina Department of Health and Environmental Control (SCDHEC) in prioritizing coastal waterbodies for further planning assistance.

• This GIS-based analytical tool implementation is carried out using ArcObjects for VBA

• Some of the functionalities in the application include but not limited to designing and implementing the Query functionalities, showing results in a Datagrid, sorting in Datagrid, exporting results to Excel, showing selection results on ArcMap.

• This application gives options to the user to search/ query the database in three different ways which is provided at the start of the application Interface.

Project: Enterprise-wide geographic information system Administration via ArcIMS, ArcSDE and Oracle

Client: MacDill Air Force Base, Florida, Feb 2007 – Jan 2008,

Responsibilities:

• Installed, configured, upgraded and maintained ArcGIS Server 9.3 with Oracle 10g client.

• Created technical documentation to end users of the Enterprise system and also provided training manuals of the various applications developed using ArcGIS Server 9.3.

• Imported, analyzed and edited aerial photography in ArcGIS.

• Used Network analyst to create road networks and other ArcGIS tools to research analyze and compile data from a variety of sources.

• ArcIMS Website Maintenance and Creation of new customized map services for showing their architectural floor plans, emergency response system and other planning systems.

• Relational Database administration with ArcSDE for Oracle 9i/10G

• Successfully Upgraded Windows 2003 servers to ArcIMS 9.2, ArcSDE 9.2 and Oracle 9i to 10G.

• Headed efforts to migrate existing ArcIMS website and other applications using Oracle 9i database to ArcGIS Server 9.3 with Oracle 10G.

• Implemented backup and recovery routines in Oracle 9i using RMAN

• Automated data backup routines using Python scripts to read data from an Oracle database into a Personal geodatabase.

• ArcGIS Server 9.3 setup and migrating ArcIMS applications to ArcGIS Server 9.3

• Created multiple ArcSDE instances for vector and raster data to be pulled independently from the database.

INTERNSHIP:

Information Technology Intern Summer 2005

NASD, Rockville, Maryland

Project: Migration of “NASD Market Centers” and “OASIS” customization

Responsibilities:

• Designed User interfaces using ASP.Net 2.0 web forms and web based user controls.

• Responsible for the database design and for writing the stored procedures using MS SQL Server 2000 T-SQL

• Migrated an existing application from ASP and MS Access 2000 to .NET

• Prepared test cases and performed the unit testing for the Application.

• Customization of the corporate intranet (OASIS) powered by Microsoft’s Sharepoint Portal Server 2003 and Windows Sharepoint Services (with Microsoft SQL Server 2000 Enterprise)

• Assisted in content upkeep of the Intranet (Oasis) web site and applications.

• Also worked on linking new documents, transfers files to server, posts files in correct location, and edits current documents to link to new documents.

RELEVANT COURSEWORK:

Computer Science

Data Structures and Algorithms, Formal Language Theory, Computer Architecture and Organization, design and Implementation of Operating Systems, Advanced Database Management Systems, Advanced Technologies in E-Commerce, Enterprise Resource Planning

Geographical Information Systems

Introduction to GIS, Computer Cartography, Socio- Economic GIS, Advanced Socio – Economic GIS

RESEARCH & THESIS:

Indexing in Spatio-Temporal Databases for Space Time paths (Trajectories)

My graduate research aims at developing a spatiotemporal access method suitable for objects moving on fixed networks and also at efficient retrieval of line segments representing trajectories of moving objects. An indexing structure is proposed for trajectories to efficiently support spatiotemporal queries called the FNR-TB Tree. This indexing structure will help in analyzing space-time relationships among space-time paths, an example of spatio-temporal data, in a large dataset. This technique discriminates the space dimension from the time dimension for indexing and thus is expected to give better performance than the existing methods.

Contact this candidate