resume

Resume of Lev Selector

Tel: 212-795-3979 home (New York),
Email: selector AT pipeline.com
Web: www.selectorweb.com

SUMMARY:

* Hands-on Programmer-Architect / Database Architect / System Integrator / Project Leader.
* Extensive financial industry background (on both Fixed Income and Equity sides, Internet/database applications, data warehousing, database architecture, ETL, data migration and cleaning, trading systems, server-side processing).
* Ph.D. - mathematical modeling and computer simulations.

COMPUTER SKILLS:

LANGUAGE - Perl (also Actionscript/Flash, C/C++, Java, JavaScript, VBA, Visual Basic).
DATABASES - Sybase, DB2, Oracle, Microsoft SQL Server, MySQL, Berkley DB, MS Access
PLATFORMS: Unix (Solaris, Linux, BSD, Mac OS), MS Windows
TECHNOLOGIES:
* Perl (CGI, ETL, feeds, reporting, administration and maintenance)
* DB (DBArtisan, SQL Navigator, Erwin, Ab Initio (ETL), Informatica (ETL))
* Actionscript (Flash CS3, Flex 3)
* Web (Apache/mod_perl, CGI, HTML, CSS, JavaScript, Dreamweaver, Adobe PhotoShop)
* Java (Sun Certified), JDBC, Java Servlets, JSP, WebLogic, Eclipse
* SVN, CVS, GNU Make, XML/XSL, IBM MQSeries, Tibco Rendezvous
* ASP, InterDev, and Front Page, IIS

OTHER SKILLS:

* Advanced analytical skills (Ph.D. in Mathematical Modeling).
* Excellent Technical Architect and Database Architect. Analysis of customer environments, design of strategies and technical architectures. Projects' implementations. Excellent in documenting projects.
* Project Leader and Lead Tech. Excellent communication skills.
* Many years of teaching experience (computers, programming, sales/marketing).
* Real life sales and business experience.
* Financial industry experience.

PROFESSIONAL EXPERIENCE:

Over the last 10 years I worked mostly as an IT Consultant (current employer - Nerox Consulting).
Participated in projects for many leading Wall Street firms (Goldman Sachs, Morgan Stanley, JPMorgan Chase, Merrill Lynch, HSBC).

-------------------------------------------------------------------
2005 - 2008 - Nerox Consulting, Inc. Consultant.
-------------------------------------------------------------------

2008-2009 - Bank Of America. Equity, Operations. Miscellaneous projects: upgrade and migration of multiple big MySQL databases (on Linux), web application perl programming for RT (Request Tracker - perl cgi, javascript, css, RT::*, Linux), custom monitoring reports using perl to scrape information from various web pages and send it using TIBCO Rendezvous messaging, log files' monitoring scripts.

2008 - Estee Lauder. Web application review (Perl, Apache/mod_perl, Javascript, json, Oracle, Linux/Solaris). Reviewed architecture for the redesign of one of e-commerce sites. Proposed an enhancement which should increase web site conversion by at least 10% (very conservatively) - thus bringing extra millions of dollars monthly.

2007-2008 - HSBC. Asset Management Group. Fixed Income and Equities. Designed and implemented a framework for multiple data feeds and reports, including ETL (scripts and SQL) for data warehouse. Worked directly with business analysts and traders. Wrote ~100 scripts, deployed ~40 jobs. Some of these jobs are being used to move billions of dollars over a period of just few months. Some specific projects: Trade Feeds, Credit Risk Reports, Compliance & Audit Reports, Data Warehouse Loaders. Technologies: ActiveState Perl, Sybase 12.5, Oracle 9, Windows Server 2003, Control-M, Subversion (SVN), VBA (Visual Basic for Applications), VB (Visual Basic). The framework have utilities to do basic database work, ETL work (Extract, Transform, Load) including bulk loads/extracts, filewatcher (on local network or via FTP), file parsing (Excel files, CSV split and join, delimited files, Bloomberg trade files and reports), working with dates, calculating business days using 2 or more different holiday calendars simultaneously in the same script, sending emails with attached data, logging, email alerts, scripts for recursive search and maintenance, generation of MS Office documents (Excel spreadsheets, MS Word documents). I have also configured all environments (PROD, DR, TEST), wrote multiple maintenance scripts (mirroring from PROD to DR using robocopy utility, removing old data files and logs, making backup copies of SVN repository, monitoring, etc.), documented architecture, deployment and DR procedures, as well as specific scripts, tested DR failover.

2007 - JPMorgan Chase - Architecture review of ETL processes (Extract-Transform-Load) and data flows in several data stores in Private Banking division. Fixed Income and Equities. Technologies: Sybase 12.5.3, Sybase Replication, Perl & Shell Scripts, XML Config Files, Ab Initio. The goal of the review was to recommend changes necessary to scale x5 and more. The system loads close to 100 million rows via hundreds of batch jobs. Various technologies are used to generate and process intermediate data files: Mainframe Cobol extracts, Informatica, Ab Initio, Syncsort, Perl scripts, shell scripts, bcp, Sybase bulk API, homegrown java applications, XML, Sybase stored procedures, Sybase subscription based replication, Sybase Warm Standby replication, SRDF (Symmetrix Remote Data Facility) for data files replication. The review has uncovered that current architecture doesn't scale as needed (x5 or more). Specific recommendations were made to the management: use parallel load instead of replication where possible, move calculations out of the database into the ETL layer, convert complex chain of data flows and multiple ETL layers into a singe ETL layer, upgrade to Sybase ver. 15.0.2 to take advantage of semantic partitioning to speed-up loads and processing, introduce run-Ids and snapshots to make ETL jobs rerunable and restartable, use Ab Initio for most of the ETL processes.

2006 – 2007 - Merrill Lynch - EFS (Enterprise File System). Technologies: Object-oriented Perl, Oracle 9, 10, Sybase 12.5, 15, NAS filers, Acopia switches, NFS, Unix (Solaris, Linux). Some projects: compiling and integrating packages and libraries into EFS (for example, Sybase Open Client v.12.5 and v.15 for Linux and Solaris, miscellaneous Perl modules and unix utilities), developing new code, testing deployment, creating development utilities, testing/tuning system performance on a Gigabit network in all 5 regions (US,UK,JP,HK,SG), training new developers in the group and in new client groups, working with Unix SAs and Storage teams in all regions to proper configure and maintain the system, working with Monitoring Group on setting up proper monitoring procedures, performing production releases, maintaining documentation and making reports (for example, created a web site using Apache / mod_perl and HTML::Mason, populated another web site using Confluence Enterprise Wiki software).

2005-2006 - JPMorgan Chase, Joint Distribution System (JDS). Technologies: Sybase 12.5, Perl 5.8, Solaris, Java (JSP), Excel, VBA (Visual Basic for Applications). Worked on database architecture. Designed and implemented an ETL (Extract - Transform - Load) perl framework. Wrote multiple perl scripts to FTP, transform/clean the data, bcp in/out, doing custom loads and updates, generating audit tables and triggers, performing database maintenance and log maintenance. Wrote many triggers and stored procedures. Wrote scripts for data distribution and regression testing. Some of the challenges included achieving good performance for Client Search screen and for multiple reports. The solutions included using stored procedures with dynamic SQL, using string-suffix tables, using "update-with-variables" method. Wrote intelligent scripts to monitor system health, report problems, and restart if needed. Tomcat is known for having periodic crashes, and these scripts have virtually eliminated their negative impact.

2005 - Alexandra Investment Management (www.alexandra.net) - Security Master database Architecture. Development of an ETL (Extract - Transform - Load) perl framework for S.M., documenting it, running test loads. Microsoft SQL Server, Perl, Excel, VBA (Visual Basic for Applications).

2005 - Morgan Stanley. Global Prime Brokerage. Developed a data-synchronization utility (Perl, Sybase, DB2) for big tables. Documented the Entitlements system (database jobs, scripts, interfaces).

-------------------------------------------------------------------
2004 - 2005 - CSFB, www.csfb.com, Prime Services, New York, Programmer.
-------------------------------------------------------------------
Development and support of an Operational Data Warehouse for Fixed Income and Equities' products and pricing. Technologies: Unix (Solaris), Windows (NT, 2000, & XP). Sybase (v.11.9.2, 12.5) - Transact SQL, stored procedures, triggers, import/export, real time feeds. DBArtisan, Informatica (ETL). Perl, Bash, Shell scripts, CGI, Java servlets (Weblogic), CVS version control, Control-M scheduler, Excel, VBA (Visual Basic for Applications).

-------------------------------------------------------------------
April 2000 - 2003 - Selectorweb, Inc. Consultant.
-------------------------------------------------------------------

2000 - 2003 - Goldman Sachs (FICC - Fixed Income Currencies and Commodities) - Multiple financial applications, web applications and utilities: server-side, GUI, feeds/integration, reporting, documentation. Technologies: Unix (Solaris, Linux), Windows (NT & XP), Sybase, DB2. Stored procedures, triggers, import/export, real time feeds. DBArtisan, Informatica (ETL) for DB2 and Sybase. Perl, CGI, Java servlets (Weblogic), Jython, Shell scripts, Visual Basic, VBA (Visual Basic for Applications), Excel, CVS version control. HTML/DHTML, Javascript, Graphics (Adobe Photoshop). Siebel (v.6.3 and 7.5).

2000 - digiTRADE (Thomson Financial). Web applications - Java Servlets, EJB middleware (Netscape Application Server 4), unix (Solaris), XML, XSL, XSLT, Perl, Korn Shell, SQL, Unify database, Netegrity site management, HTML, DHTML, Javascript, Graphics (Adobe Photoshop).

2000 - Morgan Stanley. Web application with Java Servlets (using Web Sphere), Netscape web server, Sybase database. Unix (Solaris) and Windows NT platforms. Technologies: Java, Java Servlets (ServletExec, IBM WebSphere, VisualAge, Apache JServ), JDBC, Perl, Javascript, html/dhtml/xml/xsl, SQL, Sybase.

-------------------------------------------------------------------
Earlier jobs/projects
-------------------------------------------------------------------

1999 - 2000 - Cantor Fitzgerald / Espeed. Programmer.
Maintenance and redesign of DTS (Distributed Trading System). Unix (Sun OS) and Windows NT, Apache with mod_perl (CGI, Apache::Registry), Perl DBI, Sybase, SQL, html/dhtml, JavaScript, Java, graphics.

1998 - 1999 - Waterhouse Securities. Internet Programmer.
Design of enterprise size scalable web sites with load balancing, business applications and security. Windows NT and Unix (Solaris, BSDI) platforms. Technology includes web servers (Apache, Stronghold, Netscape Enterprise 3.6, IIS-4), Netscape Application Server, CGI scripts (Perl, C), HTML, JavaScript, VBScript, ASP, graphics, Oracle, SQL.

1994-1998 - Infolink International, Inc., New York, Project Leader.
Web design and promotion for business clients (HTML, Perl CGI, Adobe Photoshop). Database for Infolink to track orders, clients, agents, to do accounting. MS Access, Access Basic.

1991-1994 Columbia University, (www.columbia.edu , Prof. L.Liebovitch), New York. Staff Associate.
Mathematical modeling of dynamics of organic molecules. Calculations were programmed in C and performed on several unix computers in different buildings. Results were fed via FTP into a Mac, where they were processed using program written in C++ (Mac package), and using IGOR software.

1981-1991 National Cardiology Research Center, (www.telemed.ru/cardio, www.cardioweb.ru) Moscow, Russia.
- Project originator and lead developer - real time data acquisition and processing in neuro-physiological experiments. Hardware and software design of a portable myograph-neurograph for clinical use. (Big project. First version of software was ~25,000 lines of code, software technology used - Pascal, Assembler, C).
- Mathematical simulation of nerve impulse generation and propagation along C-fibers. Partial differential equations, Hodgkin-Huxley model, Crank-Nicolson method, modified Runge–Kutta method.
- Teaching programming and electronics to graduate students.

EDUCATION:

2007, 2008 Ab Initio Training
2002, 2004 Informatica Training
2002 Siebel Training
2002 Advanced Excel for Financial Calculations
1985-1988 Graduate School of Moscow Phys.-Tech. Institute Ph.D. in Biophysics (computer simulation of nervous coding).
1975-1981 Moscow Physics & Technology Institute.( www.mipt.ru ) MS in Electronics and Automation, Majors in computers, electronics and biophysics, Diploma - computer simulation of nerve activity.

REFERENCES:

Available upon request.