Suavi Ali Demir 2210 La Terrace Cir Phone: 510-579-2958 mobile San Jose, CA 95123, USA 408-463-2935 day E-mail: demir9@gmail.com OBJECTIVE A Senior Software Engineer Position to develop Server Side or GUI code using Java, C++ or C#.NET. WORK EXPERIENCE Skills: Java, WebSphere, Swing, XML, XSLT, JDBC, ODBC, ADO, SQL, ISAPI, IIS, CGI, Delphi, C++, COM, ActiveX, Windows, Linux, AIX, CVS, SVN, Perforce, ClearCase, Eclipse/RAD, JBuilder, Visual Studio, DB2, Oracle, Informix, SQL Server. 8/2006- present Staff Software Engineer –IBM, San Jose, California, USA * Worked on pureQuery Java Database Access API. pureQuery sits on top of JDBC and provides shorter syntax and returns SQL results as List of Objects using basic ORM mapping capabilities with room for DB2 specific extensions for batching, static SQL execution. * Implemented capability to SELECT dept FROM List (Using a storeless Derby). * Worked on code generator (Using Eclipse JDT - AST), StaticBinder, Runtime. * Implemented Oracle support in code generator, runtime APIs, client optimizer. Client optimizer intercepts JDBC calls to enable static SQL execution. * Improved code generator architecture (Headless Eclipse, Jetty, Servlet) for 10 times speed gain. * Found novel solution to invoke DB2 specific JDBC Driver APIs regardless of Connection wrappers in App Servers, JPA. (Patent pending) * Created Build/Test execution and reporting infrastructure (ClearCase, ClearQuest, Ant/Junit, VMWare, PHP, Perl) and helped develop test cases to run against all popular databases. Provided Code Coverage support in tests. Provided AspectJ support to inject extra tracing for troubleshooting. Implemented infrastructure to enable testing within WebSphere. * Served as a liaison between other teams to utilize pureQuery to implement static execution capability for WebSphere’s JPA implementation, Hibernate, iBatis and for DB2 Data WebServices. Worked with FVT and SVT teams. Provided examples, initial training, troubleshooting, test samples. * Helped development and test teams to migrate to ClearCase / ClearQuest. * QA's champion award - voted by the test teams as the most helpful developer among hundreds of developers. 6/2005- 8/2006 Staff Software Engineer –IBM, San Jose, California, USA * FVT Testing of DB2 Native XML Store, XML Schema support using Xquery, Java, ESQL, CLI, Perl. * FVT for DB2 ADO.NET Driver. * Prototyped WebService extension for DB2 to expose database artifacts as WebServices using Java, WebSphere, WASCE (Geronimo), Tomcat, Axis, PHP (Patent pending). 7/2001- 6/2005 Staff Software Engineer –IBM, San Jose, California, USA * Worked closely in a team for development of DB2 Everyplace Sync Server using Java. DB2e Sync Server synchronizes data between mobile devices and enterprise databases. Technology involves replicating a source database with a mirror (DB2) and devices sync with the mirror through HTTP Servlets. Metadata is maintained in a Control Database (DB2) in 30 tables. * Designed and developed DB2 Everyplace Sync Server Admin XML scripting tool using JDBC, XML (JAXP, Xerces, XPath, XSLT), SQL, JUnit, Eclipse. Created XML syntax, documentation for fully scriptable, programmable admin capability covering all administrative aspects of the Sync Server product. Implemented XML script interpreter using DOM (Prototyped SAX version). Provided public API to build future admin tools (GUI/Non-GUI) on top of XML Tool. Ported existing admin tools to use the well tested XML Tool to reduce testing effort. * Designed and developed server side object model/database metadata layer with improved performance for higher concurrency, scalability and speed with a diligent implementation based on OO principles using Java technologies on top of DB2 UDB for high performance server cluster. Enabled code reuse between admin tools and the server with clear GUI/Server separation. * Architected OO Polymorphic Layers to handle implementation differences with regard to user-group information storage and retrieval (LDAP-No LDAP), third party databases such as IBM DB2 versions, Informix, Oracle, SQL Server, Sybase, Lotus Domino (syntax, case sensitivity, transaction semantics, connection properties differences, overall capabilities), replication layer (IBM DpropR versus homegrown JDBC replication). * Worked closely with another product group to integrate their IBM Data Propagator replication product admin capabilities with the XML Tool. Modified DPropR ASNCLP command line interpreter to allow polymorphic extensibility with minimal effort and risk to their approaching release. Convinced DPropR team members to adopt the new idea. Implemented XML Tool OO classes to use the new DPropR code. Introduced other IBM groups to the new and easy way of extending DPropR admin capabilities. * Modified entire server/admin/replication code to prototype the use of Cloudscape as Mirror and Control databases. Successfully found alternatives to 50+ kinds of technical challenges. * Helped regression team to integrate their test automation tool with the XML tool. * Pioneered XSLT solution to have one set of regression test cases cover all configurations. * Helped install team to use the XML tool for product setup/migration. * Enhanced customer support by providing features to extract extra diagnostics information to recreate customer system including the source database, the mirror database and the control database (Extra XML + XSLT capability to generate SQL DDL). * Enhanced Swing Admin GUI of Sync Server (Integrated with DB2 Control Center), provided new Panels, Dialogs for new features. Modified old code to use the new metadata layer. * Designed and developed diagnostics GUI tool (Swing) to monitor real time server/user status. * Designed and implemented scalable and fast algorithm to detect and propagate schema changes of subscriptions to mobile databases using Java, DB2 triggers and recursive SQL which scaled independent of the number of devices. * Investigated Web Services/SOAP/REST for inter-server and admin-server communications as an alternative to RMI for admin friendly server cluster setup and .NET interoperability. * Investigated Oracle, SQL Server, AS/400, OS/390 options (DDL Triggers, System tables) to detect source database schema changes as the sync server runs. * Enhanced/Maintained Control database DDL (tables, triggers) with backward compatibility. * Developed diagnostic tools to check system health for customer support, tools to easily create bulky test environments with mock objects, JUnit OO framework to easily derive new unit test cases with ability to break code in odd places, wrote JUnit test cases utilizing code coverage tools. 6/2000- 6/2001 Software Engineer 3 –INFORMIX Software, Inc., Oakland, California, USA * Java GUI Cloudview versions 4, 5 for Cloudscape (aka Apache Derby) ORDBMS (www.cloudscape.com): Wrote Functional Specs, Designed, Developed, Tested, Maintained the Cloudscape Database Admin Tool -Cloudview- (~75K lines) using Java, Swing, JDBC, SQL. * Developed thin client prototype of the administration tool using JSP on Tomcat. * Enhanced Import/Export Utilities, pioneered the work on capability to import schema/data from other databases into Cloudscape. * Tested our JDBC, RmiJDBC, ODBC Drivers and Weblogic frameworks. * Helped new hires get to speed. * Cloudscape was the award winning 100% Java Database with built in synchronization capability. 10/1996-6/2000 Research Assistant at the Engineering Research Center, Columbus, Ohio, USA * Designed and developed manufacturing decision support programs and database system (Oracle) for forging, tube hydro-forming and machining processes and parts using proprietary engineering algorithms and well known numerical methods (Simplex, Newton-Raphson) backed by user friendly graphical user interfaces incorporating latest GUI metaphors and elements for easy user input, monitoring, data store, retrieval, charting and reporting, as well as installers for all products. Provided CGI access to underlying databases and algorithms for online demo purposes. (Visual C++, ODBC, Win32 API, CGI-ISAPI, Install Shield). * Developed ~150 page database driven web site (SQL Server, ASP, ADO, CGI, ISAPI, IIS, JavaScript, NT4) to implement database driven abilities in order to automate the administrative, communication and advertisement work (http://nsm.eng.ohio-state.edu). * Developed user friendly GUI application to control a forging press (Win32, C++, MFC) providing hardware control capabilities with sophisticated mathematical modeling of punch velocity, motion profile, and punch pressure to enable repeatable and reliable trials of forging experiments with precise control of the hardware through software using RS232 and port I/O. * Lead multimedia project with NSF grant of $400K/3 years [1998-2000], Integrated the knowledge of Manufacturing, Cognitive Sciences and best Software Engineering practices to train team members (team of 5-10) to build workshops and multimedia based education software for the education of manufacturing engineers. * Drafted proposals with Director to attract continued membership of tens of industry companies and to form new alliances with other organizations for the above mentioned software projects. * Successfully marketed the decision support programs developed in ERC/NSM along with their cost estimation. EDUCATION 1997-2000 - Ohio State University, Columbus, Ohio M.S. in Industrial & Systems Engineering, June 2000, GPA 3.27 Employed as a Graduate Research Assistant (covering 100% college expenses). 1992-96 - Istanbul Technical University, Istanbul, Turkey B.S. in Management Engineering/Business Speaks: English, Turkish INTERESTS & ACTIVITIES Chess (National Title in High School, Covered travel expenses winning tournaments in USA and Canada 1997-2000), Painting Pictures, Programming (Active since 1992, Delphi/C#/COM Components, ISAPI Development, GUI code since Windows 3.1, Borland Pascal, C++, OWL, Learning C#, PHP now)