Senior Database Developer

PARISA GHAEMI

**** * ***** ******, **********, CO 80112

310-***-****, **************@*****.***

Education:

PhD in Computer Science, University of Southern California (USC) December 2012, GPA: 3.6

Master of Science in Computer Science, USC Sep 2008, GPA: 3.72

Masters in Computer Engineering, Sharif University of Technology Sep 1998, Tehran

Bachelors in Computer Engineering, Amirkabir University of Technology Sep 1996, Tehran

Skills:

Programming Languages: C/C#

Web technologies: Javascript, JSP, AJAX, Servlets, ASP.NET, PHP, XML, XSLT, REST

Relational Database design: SQL, ArcSDE, JDBC, ODBC, MYSQL, PostgreSQL, Access, XML

GIS Software and Programming Languages: ArcGIS Desktop, ArcGIS Server, ArcIMS, ArcObjects, ArcGIS Online, ArcGIS Web Mapping APIs (Adobe Flex)

Tools: Matlab

Environments: Windows, Linux

Experience:

Senior Database Developer, Consultant, Barco Uniforms Sep 2014- present

Senior Database Developer/ .Net Programmer, Barco Uniforms Jan 2014- May 2014

Writing T-SQL based queries and troubleshooting SQL code (stored procedures, functions, tables, views, triggers, indexes)

Using database tools (MS-SQL, SSIS, SSRS) to plan, design, and execute ETL of data and reports

Performance tuning especially tuning complex queries, stored procedures and indexing strategies

.Net programming to interact with Databases

Database Developer and Administrator, Consultant, Barco Uniforms July 2013- Dec 2013

Part Time Lecturer, Californian State University, Northridge September 2013- Dec 2013

Teaching “Geospatial Project Management” course at Department of Geography

Research Assistant, USC GIS Research Laboratory May 2005- December 2012

Generalized Optimal Location Planning (Spring 2009- October 2012): As the topic of PhD dissertation, studied and introduced efficient solutions for a variety of “optimal location queries” on very large and dynamic network datasets. An end-to-end testbed was developed in Visual C# for evaluation of the proposed solutions.

Development of a management system and geographic interface for biological resource data (Spring 2011): Developed a geographic data viewer capable of presenting information about the distribution of the sensitive biological resources on the property. The viewer also provides search for layers and works with standard XML metadata in addition to metadata provided in Ecological Metadata Language (EML). The data viewer was developed with ArcGIS Viewer for Flex 2.

Green Visions Plan for 21st Century Southern California (Fall 2006-2008): Developed a website to produce suites of GIS web-based planning tools to help guide future investments in land acquisition, habitat restoration, watershed protection, and park facilities in Southern California. The tool includes basic map tools and advanced geo-processing tools written as dynamic link libraries using VB6 and ArcObjects. The ArcIMS server serves as the map server and Green Visions data layers are stored in Microsoft SQL Server and accessed through ArcSDE gateway. The Green Visions web site implemented using ASP and Javascript.

Online Habitat Restoration Tools (Spring 2009- Summer 2009): Developed an online tool within the Green Vision Web Site to assist users in evaluating which target species would be provided habitat if an area were to be restored to native vegetation. The tool includes a map of the density of wildlife species of conservation interests and advanced geo-processing tools.

COSMOS/PEER-LL Geospatial Web service (Spring 2006): Implemented a web service to link multiple data sets of a Geotechnical Virtual Data Centers (GVDC) and query the databases and show the geotechnical data location on Google Maps. The web service is developed using Java API for XML web services, and Google Map API. The GVDC database is stored in PostgreSQL.

USC Library Digital Archive GeoBrowser (Summer 2005): Designed and implemented a GeoBrowser application to provide the USC Library Digital Archive Web site with advanced additional spatial search capabilities and includes an interactive map, a geocoder and a gazetteer. The Geobrowser is a custom-built ESRI ArcIMS map coded using Java, JavaServer Pages and JavaServer Faces (JSF).

Teaching Assistant/ Lab Instructor, USC GIS Research Laboratory Fall 2006 and Fall 2008

Instructed laboratory sessions for the Water Planet course and mentored undergraduate student

Lead Application Developer, Sazeh Company, Tehran, Iran Feb 2001- Dec 2004

Lead team of software developers to design and develop a web-based Timesheet Management System to record the employees' timesheets and provide reports used for project scheduling and project management. Also, design, implementation and maintenance of databases (Microsoft SQL server) for Sazeh intranet applications.

Selected Publications:

2014. Banaei-Kashani, F., Ghaemi, P., Shahabi, and Wilson, J. P. http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6V9K-4WJG8GT-1&_user=1181656&_coverDate=11%2F30%2F2009&_rdoc=1&_fmt=high&_orig=search&_sort=d&_docanchor=&view=c&_searchStrId=119*******&_rerunOrigin=google&_acct=C000051901&_version=1&_urlVersion=0&_userid=1181656&md5=930497a46edc3ea99985641d8e9ae47dMaximal Reverse Skyline Query (short paper). ACM SIGSPATIAL GIS 2014.

2013. Ghaemi, P., Shahabi, K., Wilson, J. P., and Banaei-Kashani, F. A Comparative Study of Two Approaches for Supporting Optimal Network Location Queries, Geoinformatica, April 2013.

2012. Ghaemi, P., Shahabi, K., Wilson, J. P., and Banaei-Kashani, F. http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6V9K-4WJG8GT-1&_user=1181656&_coverDate=11%2F30%2F2009&_rdoc=1&_fmt=high&_orig=search&_sort=d&_docanchor=&view=c&_searchStrId=119*******&_rerunOrigin=google&_acct=C000051901&_version=1&_urlVersion=0&_userid=1181656&md5=930497a46edc3ea99985641d8e9ae47dContinuous Maximal Reverse Nearest Neighbor Query on Spatial Networks. In Proceedings of the 20th SIGSPATIAL International Conference on Advances in Geographic Information Systems, pages 61-70.

2010. Ghaemi, P., Shahabi, K., Wilson, J. P., and Banaei-Kashani, F. http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6V9K-4WJG8GT-1&_user=1181656&_coverDate=11%2F30%2F2009&_rdoc=1&_fmt=high&_orig=search&_sort=d&_docanchor=&view=c&_searchStrId=119*******&_rerunOrigin=google&_acct=C000051901&_version=1&_urlVersion=0&_userid=1181656&md5=930497a46edc3ea99985641d8e9ae47dOptimal Network Location Queries (short paper). ACM SIGSPATIAL GIS 2010.

2009. Ghaemi, P., Swift, J., Sister, C., Wilson, J. P., and Wolch, J. http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6V9K-4WJG8GT-1&_user=1181656&_coverDate=11%2F30%2F2009&_rdoc=1&_fmt=high&_orig=search&_sort=d&_docanchor=&view=c&_searchStrId=119*******&_rerunOrigin=google&_acct=C000051901&_version=1&_urlVersion=0&_userid=1181656&md5=930497a46edc3ea99985641d8e9ae47dDesign and implementation of a web-based platform to support interactive environmental planning. Computers, Environment and Urban Systems, Volume 33, Issue 6, November 2009, Pages 482-491.

2006. Ghaemi, P., Swift, J.N., Goldberg, D.W., and Wilson, J.P. Prototype Geographic Search and Query Tools for a Library Digital Archive. ArcUser 9(2): 30-32.

1999. Ghaemi, P., Firoozabadi, S.M.P, and Jamzad, M. Observing Late Components in Long Time Simulation of Single Fiber Action Potential. Medical and Biological Engineering and Computing 37(2): 1174-1175.

Relative Course Work

Advance Database Systems

Advanced Operating Systems

Information Integration on the Web

Web Technologies

Semantic Web

3D Graphics and Rendering

Multi-Media Systems Design

Professional Training Certification

Certificate of Completion of ArcIMS Administration, ESRI Redlands, CA, July 2005.

Certificate of Completion of Introduction to ArcGIS Server, ESRI Redlands, CA, Sep 2007.

Certificate of Completion of Developing Applications with ArcGIS Server Using the Microsoft .NET Framework, ESRI Redlands, CA, Sep 2007.

Awards and Honors

Outstanding Leadership Award, University of Southern California, 2005.

Contact this candidate