Sandeep Desai

http://www.thedesai.net/sandeep

Summary

Over 12 years of experience in full life cycle of software development. I have been involved in the full life cycle of developing products, writing functional specifications, design specifications, architecting products, coding, delivering and supporting the product.

Languages: Java, XML, HTML, CSS, Javascript, SQL, Perl, C/C++

Development tools: Oracle JDeveloper, Visual C++, and Visual Basic

Databases: Oracle RDBMS, Oracle OLAP Option

Libraries (APIs): J2EE, Servlets, JSP, Hibernate, Java Swing

Platforms: Windows, Linux (UNIX)

Design and Development: UML, Design Patterns

Certifications: Sun Certified Java Programmer, Sun Certified Web Component Developer

Work Experience:

Principal Member of Technical Staff for Oracle Corporation: June 97 to date

I am the lead designer and developer, responsible for writing functional specifications, design documents, designing architecture, development and delivery of OLAP and Business Intelligence modeling software for Oracle Database OLAP option. The software allows you to model multi-dimensional objects such as dimensions, cubes, measures, calculations, aggregations, allocations and forecasts. Various time series based calculations were supported such as Prior Period, Future period etc. The dimension and cubes objects can be mapped and loaded from relational star or snowflake tables. The software also allowed the ability to query and view the cubes using the Business Intelligence Crosstab and QueryBuilder Beans. The software also allows you to save the model to XML files. The XML files could then be transported and imported into another database. The software also allows you to edit Business Intelligence Models generated from the ETL process by Oracle Warehouse Builder.

The data presentation was done using the OLAP Web Agent. The servlet, implements OLAP Server Pages, which is similar to Java Server Pages. It allows the user to author Web pages using the OLAP DML Language. The servlet takes OLAP DML requests, executes the OLAP DML, and returns the formatted HTML back to the Web Server. The software was developed using Java, Servlets, JSP, Swing, JDBC, XML and SQL

Senior Software Engineer for Unifi Inc. May 96 to May 97

I was involved in developing a Fax Broadcasting system. I developed a Windows based client using Visual Basic and Visual C++. I was also involved in the design of a Modem Server, which runs under Windows NT, which is implemented using Visual C++. The Broadcast client, allows the user to manage their phone book locally in a Microsoft Jet Database. The client allows the user to create Broadcast requests, which are then submitted to a Modem server using a point-to-point call or using X.25. A proprietary client/server protocol was devised to synchronize the local and remote databases. The client uses a Black Ice Print to Fax driver to convert documents to TIFF files which are uploaded to the Modem Server. I developed an automated testing tool to test the client/server protocol robustness. I also implemented an internal Web based system for accessing the bug database. The Web Server is hosted on Windows NT Server using Internet Information Server.

Siemens Hearing Instruments, Inc. (Contract for CCS Consulting) Mar 96 to May 96

I developed an application on Dynix/ptx (Sequent UNIX) to transfer data from Sybase SQL Server to MANMAN (an accounting package on VMS) using C, SQL Server db-library and the Expect (Tcl based language for driving interactive applications) C Interface. I also worked on developing a Stock backflsuhing system using Visual Basic, Sybase SQL Server db-library, MAPI, Spread/VBX and VBTools 5 VBX's.

Electronic Data Systems: (Contract for CCS Consulting) Sep 95 to Feb 96

I developed VBX's in Visual C++ for a Text Box and a Combo Box. I also developed an MFC Extension DLL in Visual C++, which replaces an ISAM database interface with an ODBC based database interface. I have also developed support routines in a DLL for Visual Basic applications using Visual C++. I also developed a application for viewing Transactions on an Oracle database, it consists of a visual query builder for fetching transaction data, the application was developed using Visual Basic and Visual C++ it utilizes the Access 2.0 database, Spread/VBX and VBTools 5 VBX's. The application included a visual query builder.

American International Group: Jan 95 to Sep 95

I was involved in developing and enhancing a Risk Management System consisting of a Report Distribution System, Claims Report generator and a Insurance Certificate creation module developed using Visual Basic, Visual C++, MS Access, SQL Server and OLE2.

Computervision (Contract for Patni Computer Systems): May 93 to December 94

I worked on EDM (Engineering Data Management). I was involved in the conceptualization, design, development and support of MS-Windows and Windows-NT based client GUI's developed using Visual C++ and Visual Basic. The socket API was used for networking UNIX and Windows-NT. I internationalized the software by developing tools to globalize the code and by creating language specific DLLs. I added features to the server using Pro*C (Oracle embedded SQL) and C. I created SQL scripts for accessing the Oracle database. I created automated testing tools for testing the servers on UNIX platforms and Windows-NT.

Patni Systems Aug 92 to May 93

At Patni Computer Systems, I worked on the development of Software tools such as SQL to awk translator on UNIX using sh, lex, yacc, (Compiler generator) and C. The translator was ported to DOS. The database was a flat file based RDBMS. I also developed a User Interface library in C. It consisted of a Dialog and Menu Definition Language, and a C code generator for scripts. I also developed a graph-plotting library, which could plot 3-D graphs using the Windows SDK and was ported to X-Window.

Indus Software Pvt. LTD: October 90 to April 92

As a programmer for a CASE tool vendor, I created a front end for a CASE tool using a window's interface that allowed users to draw diagrams such as Data Flow Diagrams, E-R diagrams, Structured Charts. I developed an import/export utility to allow import and export of screens, reports and 4GL scripts. I also created a copy protection scheme for the CASE tool. I also worked on a COBOL to C translator. The development was done using Microsoft C on MS-DOS.

Education:

Master in Computer Science, 1992 University of Poona

Bachelor in Computer Science, 1990 University of Poona