SUMMARY:
| Design Methodologies: |
|
Expert
level: ER and Dimensional Modeling; |
|
Advanced
knowledge: OOA&D; UML techniques, J2EE/design
patterns. |
| Programming Languages: |
|
Expert
level: SQL, Oracle PL/SQL, Pascal/Object Pascal (Delphi),
Oracle Java Stored Procedures, JavaServlets, JDBC; |
|
Advanced
knowledge: Java and Java APIs (EJB, EJB 2.0, JSP, XML,
JMS), XML, HTML, Oracle AQ, CDO/MAPI, T-SQL, LDIF, JavaScript, ASP,
ISAPI, BREW. |
|
Familiar
with: C++/C, VB, Perl, XSLT, ASP.NET, C#, Droplets, JAAS,
SSL, HTTPS, SOAP, WSDL. |
| RDBMS and Development Tools: |
|
RDBMS &
AS: Oracle (7 - 9i), MS SQL Server 2000, BEA WebLogic
5/6, SAP J2EE, Tomcat, Sun ONE J2EE; |
|
Design Tools
and IDE: Rational Rose, Oracle Designer, ERWin, Delphi
(1-6), XML Spy; |
|
Reporting and
BI: Oracle Report, Oracle Discoverer, Cognos Impromptu
and PowerPlay; |
|
DBA
Tools: Oracle DBA Tools, Quest SQL Navigator, and Quest
Schema Manager; |
| Professional Domains of Expertise:
|
|
|
Database Architecture, Design, Programming and Administration;
Reporting, Data Warehousing and OLAP; Data Acquisition and
Transformation (ETL), Enterprise Application Integration (EAI);
|
|
|
Application Architecture, Design and Programming; Component
Design; C/S and Multi-Tier Computing; Windows and Web GUI design.
|
| Associated Domains of Expertise: |
|
Networking and Media Streaming; Bio-Informatics,
AI and LIS; Genetics and Drug Testing; Marketing and Customer
Information solutions; E-Commerce, Application Hosting, Portals;
Career Solutions; Banking and Credit Cards solutions;
Software/Hardware Engineering, Version Control and Configuration
Management solutions, Portals and Knowledge management; |
| Systems and Software: |
|
Windows NT/2000, Linux, Windows9x, Sun Solaris, IBM-AIX, MS IIS,
Netscape LDAP, MS Exchange Server, Novell E-Directory, SAP
Enterprise Portal; |
| Platforms: |
|
PC, Sun and RS-6000. | |
EXPERIENCE:
April 2003 - present, PPD Inc. (Menlo Park, CA)
Bio-Marker
Division (former SurroMed Inc.)
IS Architect
|
|
|
Data architect and database analyst – Oracle 8i, Oracle
9i, MS SQL Server, PL/SQL, Partitions, Relational and
dimensional design, Java Stored Procedures. Unix and
Windows.
Reviewed, evaluated, designed and built
relational and dimensional databases for Cytometry, GC/LC
Mass-spectrometry and Clinical biomarker discovery analytical
platforms. Developed strategies for acquisition of very large
(hundreds of millions rows) datasets. Implemented data
intensive ETL routines. Designed and implemented multi-layer,
cross-database, cross-platform integration between third party
LIMS (Laboratory Information and Management System) and
in-house bio-informatics database platform. Supported
scientists and statisticians in data extraction and data
mining tasks. Tuned legacy production databases, solved
numerous performance and bottleneck problems |
|
|
Application Architect – Java, J2EE (JDBC, JMS, MDB,
JNDI, Servlets/JSP, JDOM, XML), C#.NET, ClealCase and UCM,
UML. Unix and Windows , Sun ONE, WebLogic and
Tomcat.
Directed (not a manager) team of 5 to 7
developers, DBAs and QAEs. Conducted requirement, design and
code reviews for Java and .NET projects. Guided team members
in use of J2EE, Java APIs, UML and SQL. Developed strategies
and guidelines for software configuration management and
version control. Designed and developed analytical workflow
automation system (based on J2EE) – integration between
in-house bio-informatics database platform and third party
statistical analysis tools such as SAS and S+AS (S Plus
Analytical Server) and data visualization tools such as
Spotfire and Excel. | |
January 2002 - March 2003, SAP (Palo Alto,
CA)
IS/Technical Services
IS Architect
|
|
|
Guided team of J2EE/Portal developers: created guidelines,
example and reference implementations. Conducted code and
design reviews, enforced development standards. Problem
resolution, performance optimization for all Java and Delphi
related issues. Utilized UML, J2EE and design patterns, Java
APIs (JDBC, JNDI, JavaServlets/JSP), SAP J2EE Engine,
Tomcat. |
|
|
Conducted performance and throughput analysis of
Enterprise Portal components. Drafted recommendations and best
practices documents for field consultants. Provided feedback
and usability studies for product developers. Optimized
performance of SAP J2EE engine, LDAP server and other
components of corporate portal. |
|
|
Designed and developed modules for data acquisition and
integration for corporate portal utilizing MS SQL Server,
Oracle, Netscape LDAP server, Novel e-Directory, SAP
Enterprise Portal 5.0, XML, T-SQL, SQL, LDIF, Java, Perl,
Delphi, ISAPI, CDO/MAPI, MS Exchange
Server. | |
2001 - 2002 iBeam Broadcasting (Sunnyvale, CA)
Network
Platform Engineering department
Senior Database
Architect, System Architect, Principal
Engineer
Assumed full responsibility for complete
design and implementation of database layer of the company core
technology - "Media On Demand" - platform for the whole iBeam
intelligent media streaming and distribution network. Led the effort
of creating an architecture and prototype for a new high volume (2
million records/h) "real-time" data acquisition and analysis system.
Was a major contributor to the research and design of architecture
for universal "middleware" solution for consolidating of on-line
services, provided by the company, into a homogeneous platform based
on Web Services concept. |
|
|
Conducted full cycle of database design (ER
and dimensional) and implementation through logical and
physical models to the actual implementation (Oracle 8i EE) of
all database objects and stored logic. Utilized UML, Rational
Rose Data Modeler (for the design phase), PL/SQL and Java for
stored procedures and triggers; |
|
|
Conducted extensive performance oriented
prototyping and research for "near real-time" ETL system
utilizing Oracle 9i and Oracle 8i on Windows 2000 and Linux,
Oracle Java Stored procedures, Oracle AQ, JMS, Web Logic, Java
Servlets, Java multi-threading, XML and JDOM. |
|
|
Researched Web services concept and created
prototypes utilizing WebLogic 6.1, EJB 2.0, JMS, SOAP, XML,
Oracle 9i and Linux. |
|
|
Drafted guidelines for J2EE design
methodology, established database design standards and
methodology, as well as database implementation
standards. |
|
|
Guided team in problem resolutions in J2EE,
Java programming (WebLogic 5.1 - EJB, JavaServlet, JSP, JMS,
security, multi-threading etc.) and database access (JDBC),
SQL programming and performance tuning. Played role of
development DBA. Installed and maintained development and
testing database environments - Oracle 8i/9i (8.1.7 and 9.0.1)
EE on Windows NT/2000/Linux/Sun. |
|
|
Consulted Operation and QA regarding
production database server configuration, maintenance and
performance and reliability issues. Worked with senior
management team on assessing overall cost of database
component of the system, provided analysis and recommendations
regarding Oracle licensing
policy. | |
1999 - 2001 ViroLogic Inc., (South San Francisco,
CA)
IS/Software Engineering
Senior Database
Architect, Project/Technical Lead
Utilized Oracle,
WebLogic, SQL, PL/SQL, Delphi, Java and XML tools, Oracle Report,
Crystal Report, Oracle Designer, MS Project, MS Access, Visio, MS
Excel, various DBA tools etc. at biotechnology drug resistance
testing company. |
|
|
Designed the database, implemented
algorithms and supervised implementation of the UI for Drug
Suite Management, Data Analysis and Reporting; designed XML
DTD and provided application for interfacing of robotic lab
systems and Data Analysis module - for the state of the art
phenotypic drug resistance assessment system.
Designed
database, implemented algorithms and provided interface for
capturing and reusing unique knowledge accumulated by
Scientific and Clinical Research team; designed and
implemented database and designed XML DTD for capturing
information of virus genetic sequences and mutations -
genotypic drug resistance prediction system. |
|
|
Planed and designed database for EAI
projects: integration between LIS (Ultra - Unify database),
ERP (PeopleSoft HR and Financial modules - Oracle Database),
Drug Suite, Data Analysis, Customer Information and Reporting
systems (proprietary applications - Oracle Database). Utilized
messaging and queuing technology by STC, HL7 interfaces and
Oracle Replication. |
|
|
Developed all commercial reports (key
company products) and the electronic data reporting and
delivery system. Designed and developed number of the key
applications those form the foundation of all data reporting
functions at the company. Oversaw development of the operation
report libraries. |
|
|
Developed framework and implemented
infrastructure for data warehousing solutions and implemented
number of data marts for Scientific Research and Clinical
Research teams. Assisted in implementing AI solutions for Data
Analysis team. |
|
|
Guided team in problem resolutions in J2EE,
Java programming (WebLogic 5.1 - EJB, JavaServlet, JSP, JMS,
security, multi-threading etc.) and database access (JDBC),
SQL programming and performance tuning. Played role of
development DBA. Installed and maintained development and
testing database environments - Oracle 8i/9i (8.1.7 and 9.0.1)
EE on Windows NT/2000/Linux/Sun. |
|
|
Led the effort of establishing next
generation of development and deployment environment by
pioneering the implementation of Java, J2EE and XML
technology. Provided technical support and guided project team
members in J2EE programming (EJB, JSP, Java Servlet and
overall system architecture) and using WebLogic 5.1. Led the
first project in which J2EE solutions were applied. Designed
and developed new generation of data acquisition system based
on XML format and Java XML APIs (Sun Jaxp/Apache Xerces for
Java). | |
1995 - 1999 RAD Data Communications Ltd. (Tel-Aviv,
Israel)
IS/Software Engineering
Project/Technical Lead,
Database Designer, Oracle DBA |
|
|
Led the creation of the
component/library/template framework for Multi-Tier, Intranet
and C/S applications, using Delphi 3; Database/Application
design review and code review of all IT projects. |
|
|
Provided training in Delphi and Oracle for
IT developers; installing, configuring and administrating of
Oracle 7 and Oracle 8 servers and clients. Implementing
snapshots and replication between different
servers. |
|
|
Led the system analysis, database design and
development of enterprise information system
modules. |
|
|
Designed and deployed Datamart solution for
sales/marketing teams, utilized Oracle and Cognos PowerPlay:
designed ETL module (PL/SQL), star-schema (Oracle) and
configuration of dimentions (PowerPlay), tuned load
performance and guided report design team in creating end-user
PowerPlay reports. |
|
|
Created Development Standards guidelines for
IT developer's team, defined methodology and writed guidelines
for Multi-Tier and C/S application
development. | |
1991 - 1995 Mainor ELT Ltd. (Tallinn,
Estonia)
Engineering
Project Lead, System
Analyst and Application programmer
Project leading, development and implementation of the
Information Clearing and Information Security modules of the Smart
Card payment system; training and Support of the processing center
managers and bank analysts; Developed the bank software modules and
applications. | |