Alex Vilner Primary
phone: (401) 480-1521
alex@sinoma.com Secondary
phone: (401) 334-9539
BACKGROUND:
Senior software engineer/architect with over 17 years
experience in business analysis and modeling, databases, data warehousing,
network and Web technologies, SDLC, GUI design and project management. Entrepreneur, skilled at defining strategic
vision and thinking out-of-the-box in various business environments.
INDUSTRY EXPERIENCE:
|
§
Financial/Banking/Mutual
Funds |
§
Education |
|
§
Manufacturing |
§
Healthcare/Medical |
|
§
Products/Services |
§
Consulting |
CERTIFICATIONS:
|
§
RDBMS
Developer (specialization in Oracle) |
§
PowerBuilder
Developer (Master Level) |
|
§
Object-Oriented
Developer |
§
High IT
Aptitude Certification |
TECHNICAL EXPERTISE:
Methodologies: OOA/OOD,
Extreme Programming (XP), ETL, RAD, JAD, DESIGN/1, METHOD/1.
Languages: SQL
(PL/SQL, T-SQL), PowerBuilder/PFC (3/4/5/6/6.5/7/8), Java, COM/DCOM, ASP, HTML,
XML, Visual Basic, C/C++, FoxPro, ObjectView, dBase, Pascal, Basic, Lisp,
Prolog, FoxBASE+/Mac, Assembler.
Tools: TOAD,
Informatica, ERwin, DBArtisan, S-Designor, PowerDesigner, Rational (ClearCase,
ClearQuest), InfoPump, CVS, PVCS, Visual SourceSafe (VSS), MS Office,
Databases: Oracle
(7,8i,9i,10g), MS SQL Server (6/7/2000), Sybase (4/10/11/12/12.5), DB/2, MS
Access, Lotus Notes.
Operating
Systems: Win 95/98/NT/2000/XP, OS/2, DOS, UNIX (IBM
AIX, HP-UX, SunOS/Solaris, Linux), Mac OS, NetWare.
PROFESSIONAL
EXPERIENCE:
Database conversion, design, and development.
(Oracle 9i/10g, SQL Loader, Informatica, ETL,
Rational ClearQuest, TOAD, Erwin, stored procedures, packages, Perl, UNIX
scripts).
§
Responsible
for developing conversion strategy from Sybase to Oracle 10g. Migrated database
schemas, procedural code and data. Automated most of the migration process,
using PL/SQL scripts, SQLPlus, SQLLdr, UNIX shell and Sybase utilities.
§
Designed and
developed Informatica transformations for daily and monthly data loads from
various external and internal financial feeds.
§
Developed scripts,
procedures and packages to handle business logic and utility functions.
§
Responsible
for defining Oracle application development standards (coding, architectural,
migration).
§
Perform
extensive performance tuning of migrated code.
§
Database design, performance tuning and development.
(Oracle 8i/9i, SQL Loader, ETL, Rational
ClearQuest, StarTEAM, eRooms, TOAD, Erwin, stored procedures, packages).
§
Design and
develop ETL scripts/packages, using SQL Loader, Excel/macros, command-line
scripts (DOS/UNIX).
§
Optimize/tune
complex database processes.
§
Develop
procedural logic; manage and maintain source in multiple environments.
§
Diagnose,
troubleshoot and maintain core database logic; create/deploy database rollout
packages for client distribution.
§
Provide
database support and assist with integration of Oracle with front-end Java
applications.
Management of Software Engineering Department (Developers,
DBAs, QA and Technical Writers).
(MS
SQL Server 2000,
§
Short- and
long-term strategic planning (including customer service, budgets, technical
direction and business development/marketing) for the organization.
§
Department
budgeting, performance reviews, project planning/management, task coordination
and resource allocation.
§
Architectural
design and modeling (front-/back-end), normalization, database
development/performance tuning in VLDB transaction-intensive environment.
§
Work with DBAs
on implementing backup/recovery architecture; define data security requirements.
§
Participate in
business needs analysis and implementation of the Microsoft CRM solution.
Responsible for architectural design, development, project management, and production support of mission-critical financial applications (Automated Trade Instruction, ETF, Cash/Asset Management) in the data warehouse environment.
(Oracle
7/8i/9i, MS SQL Server 2000, ETL, UNIX shell scripts, SunOS, FTP, XML, Cron,
Argent, Crystal Reports, Rational ClearCase, Rational ClearQuest, TOAD, Erwin,
Oracle AQ, Oracle collections, stored packages, object types, Weblogic).
§
Developed complex data-mining/replication/ETL
mechanisms in the data-warehouse environment, using SQL Loader, UNIX shell
scripts, flat file transformations, Oracle and MS SQL Server procedural
logic/objects.
§
Responsible for the database design, data modeling,
normalization and architectural reviews.
§
Implemented performance improvements using shell
scripts and SQL/PLSQL rewrites for various database components, including
Advanced Queues, object views and legacy procedural code.
§
Designed and
developed trading applications, using PowerBuilder/PFC; Created
organization-wide object framework.
§
Coordinated
interfacing/integration of back-end code with Java/Weblogic development team.
Senior Consultant/Database Architect (2000 – 2002)
Responsible for architectural design,
development and performance tuning of a Global Financial Messaging System.
(Oracle 9i,
Sybase 11.9.2/12, UNIX shell scripts, FIX, Weblogic, ErWin, Financial Fusion,
XML, CVS, PowerDesignor)
§
Responsible for database design, modeling,
development, optimization/performance
tuning.
§
Integration of
database components with Java/WebLogic and Financial Fusion servers.
§
Development of
various trade-, ioi- and system- reports, integration with reporting tools.
§
Architectural
design, modeling, and development to support database migration from Sybase to
Oracle; replacement of Financial Fusion databases with in-house custom
solution.
§
Prepared
Business Requirements, System Requirements and Functional Specifications
documents.
Executive management for the startup consulting company: HR,
planning, projections, financial aspects, etc. Project engagement/initiation
and management, generation of business and systems requirements documents,
database design, creation and development (Sybase, Oracle, MS SQL Server), GUI
design, usability studies, etc. Projects included:
Technical Lead/Senior Consultant/Architect (1998 – 2000)
As part of software development team performed analysis,
design and development of commercial Lease Tracking Application.
(PowerBuilder,
Oracle 7/8/8i, ErWin, IBT AIX, HP-UX, NT, shell scripts, MS SourceSafe, MS
MTS/IIS, COM/DCOM, ASP, JavaScript, VBScript, Crystal Reports, ActiveX, OLE, MS
Visual C/C++, MS Access)
§
Supervised and
coordinated development efforts for several product lines.
§
DBA for Oracle
Server (7/8) on IBM AIX, HP-UX and NT (database design, administration,
configuration, maintenance, installation, performance tuning, query
optimization, etc.).
§
Developed
COM/DCOM components for complex business logic, deployed to the MTS/IIS.
§
Developed ASP,
JavaScript and VBScript application to handle internet-based Customer Issue
Tracking.
§
Responsible
for preparation and installation of client/server releases, version control,
generation and maintenance of installation scripts (UNIX, Oracle, Windows).
§
Configured and
administered Microsoft IIS and Exchange Servers; monitored load and activity.
§
Developed
complex reports for Lease Tracking, using VB, PowerBuilder, Crystal Reports and
a variety of 3rd-party components.
Senior Developer/Architect (1997 – 1998)
Architect/developer in the large-scale software development
project for the Distributed
(PowerBuilder
5/6, SQL Server, Sybase 11, Oracle 8,
§
Developed
custom application framework using PowerBuilder/PFC and database objects
(Oracle, Sybase and SQL Server).
§
Responsible
for database design and modeling.
§
Participated
in developing and documenting of use cases.
§
Development of
complex reporting logic, using back-end objects, Crystal Reports and
PowerBuilder.
§
Supervised a
team of junior to intermediate developers.
As a senior consultant, participated in a variety of
projects for company's clients.
(PowerBuilder,
Oracle, SQL Server, Sybase, UNIX, shell scripts, PVCS, SourceSafe, Novell,
FoxPro, SQR)
§
Coordinated
work of the company Education Committee. Responsible for scheduling and course
development.
§
Analysis, design
and development of the On-Line Customer Service Application for a RI-based
student loan brokerage firm. Part of the focus team for Business Process
Reengineering.
§
Development of
Management Decision Support/Reporting System, using PowerBuilder, Sybase, SQR,
and UNIX scripts.
§
Responsible
for optimization of Sybase queries, stored procedures and triggers (performance
improvements for some of the processes from several hours to several seconds)
As
a senior consultant, participated in a variety of projects for company's
clients.
(PowerBuilder, MS Visual C/C++,
MS Access, Oracle, Sybase, DB/2, Informix, MS SQL Server, ODBC,
Data Warehousing Project (
§
Design and development
of the database-independent Data Warehouse Management System, including Logical
and Physical Browsers, DataMart definition, DataMart Load and Reporting
modules.
§
Developed
application modules to support ETL – source data extraction, mapping, transformations,
loads.
Order Entry/Pricing Application (
§
Project Lead
for the Real Time Order Entry and Pricing Application for a precious metals
manufacturer. Involved in research and documentation of business processes.
§
Designed,
developed, documented functional requirements and conducted end-user training.
Phone Tracking Application (
§
Designed and
developed commercial Phone Tracking application, to track organizational phone
usage.
§
Developed a
variety of reports for incoming/outgoing calls, performed system maintenance,
etc.
(Sybase, Oracle, OLTP, UNIX,
DESIGN/1, METHOD/1)
§
DBA for an
On-Line Provisioning System Project for NYNEX (
§
Performed
logical and physical database design, database tuning, and performance
optimization.
(MS SQL Server,
§
Designed and
developed ETL scripts/interfaces, using InfoPump for data migration/replication
between MS SQL Servers and Lotus Notes databases.
§
MS SQL Server
DBA, InfoPump Administrator, Lotus Notes Servers Admin.
§
Performed
logical and physical database design, database tuning, and performance
optimization.
§
Designed and
developed PowerBuilder and ObjectView client-server applications, using MS SQL
Server and Lotus Notes.
§
Responsible
for customizing and internationalizing applications for the needs of foreign
offices (
(FoxPro, MUSE, FoxBASE/MAC,
MacOS, Novell)
§
Designed and
developed a variety of database applications in the multi-user environment.
§
Beta-tested
FoxPro 2.0 for Fox Software, reported issues, verified fixes, provided direct
input on product improvement.
(FoxPro,
DBASE, C/C++, Pascal)
§
Designed and
developed a number of PC database applications.
TEACHING
EXPERIENCE:
Taught Introduction to Oracle 9i PL/SQL and DBA 3: Performance Tuning courses for Oracle 9i Certification
Program.
Active participant in business activities, including:
presentations, scheduling, speaker and venue negotiations, coordination.
Instructor for Introduction
to PowerBuilder, Intermediate PowerBuilder, Advanced PowerBuilder, Client-Server Technology, Client-Server Relational Databases, and Object-Oriented Technology courses.
Taught Oracle SQL,
Oracle Database Administration and Oracle ToolSet courses.
ACADEMIC BACKGROUND:
1993 B.Sc., Computer Sciences,
1996 Practice of Management,
FOREIGN LANGUAGES:
§
Russian/Belorussian
(Native Speaker)
§
French
(conversational)
§
Italian (conversational)
Software engineering process expert
Software architecture and design expert
Software integration and QA expert
Database: architecture and design expert
Database: data modeling expert
Database: performance tuning expert
Database: data warehousing expert
OOA/OOD/OOP expert
Oracle - development expert
Oracle - DBA intermediate
MS SQL Server - development expert
MS SQL Server - DBA intermediate
Sybase - development expert
SQL (all dialects [T-SQL, PL/SQL]) expert
XML intermediate
Html intermediate
Erwin expert
TOAD expert
PowerBuilder expert
UNIX/Shell scripting expert
Windows (all flavors) expert
Project Management expert
Team Leadership expert