Project Manager Data
Resume:
Leonard Metelitsa
Princeton Jct, NJ 08550 E-mail *.*********@*******.***
SUMMARY OF EXPERIENCE
Extensive experience in the following areas:
• Experienced hands-on project manager and BI system architect for medium to large-scale projects in Data
Warehousing (DW), Document Management, Decision Support Systems (DSS), Data Mining, Customer
Relationship Management (CRM), Database enabled WEB portals, Database development, modeling, and
support within PC/Mainframe/UNIX environments involving complex system integration issues, middleware,
and gateways . Experience with the Software Development Life Cycle (SDLC) methodologies and transforming
business requirements into technical specifications.
• Knowledge of potential pitfalls, ability to manage expectations, major organizational and cultural issues, the
strengths and weaknesses of a wide range of platforms, tools and applications, the skills and team structures
needed to ensure effective implementation and the techniques for maintaining development momentum and
retaining executive interest.
• Industries: Brokerage, Banking, Financial, Pharmaceutical, Insurance, Performing Arts, and Health.
• Extensive experience with multi-platform integration and architecture.
• Business requirements analysis, Dimensional (Informational) modeling, Data acquisition analysis and Design,
Data cleansing and transformation.
• Expert knowledge of Inmon and Kimball methodology, relational, multidimensional, and hybrid databases, as
well as DSS/DW/OLAP tools and packages, including Microstrategy, Cognos, Business Objects, Essbase
• MS SQL Server with SSAS & SSIS (Business Intelligence tools, Data Warehousing and ETL processes)
• Documentum Integration
• DBA level knowledge of Oracle(PL/SQL,DDL,DML etc), MS SQL Server, Sybase SQL Server, DB2. Logical
and Physical Database Design, performance tuning, troubleshooting, recovery, load, reorganization, utilities etc.
TECHNICAL EXPERTISE:
Relational databases: Oracle, Sybase Incl. Replication Server, MS SQL Server, DB2
Data Warehouse: Business Objects, MicroStrategy incl. Narrowcast, COGNOS, Essbase, Data Replication,
MS SQLServer SSAS & SSIS
Document Management: Documentum
Portals and Web Technology: JSP, XML/XSD, XML SPY, WebLogic, Eclipse, LDAP, WEB Services, Gemstone,
Ontology Tools
GUI’s: Visual Basic, PowerBilder
Languages: Java, C++, ASSEMBLER (BAL), COBOL II
CASE: ERWin, BPWin, Rational
Operating Systems: Windows, UNIX, Solaris, OS/MVS, CICS
Methodologies: Joint Application Development (JAD), Rapid Application Development (RAD), CRM
CRM: SalesForce, Siebel Tools
Methodologies: Rational Rose UML
Testing Tools: Mercury Quality Center, Mercury’s Test Director
EXPERIENCE:
11/2008 –Present. Intralinks, Inc. (http://www.intralinks.com/) Senior BI Architect
One of the most well known information-sharing and collaboration platform in the Financial Services and Insurance,
Energy and Utilities, Goverrnment, Life Sciences etc. space.
Managing, designing and developing an Enterprise Data Warehouse. Integrating previously disjointed financial and user
data sources in a single DW oriented environment, including ODS, repository, metadata, reporting and OLAP layer.
Dealing with a SaaS (Software as a Service) environment that presents new challenges from process of the financial data
point of view. Developing Executive Reporting and Dashboard.
Environment:
DB: SQLServe and Oracle
DW: Business Objects (WEBI, Universe Designer, Data Integrator)
OLAP layer: MS SSAS
Page 1 of 5
Leonard Metelitsa
34 Park Hill Terrace
Princeton Jct, NJ 08550 E-mail *.*********@*******.***
CRM/Accounting: SalesForce, Great Plains
8/2007 –6/2008. Citigroup. Vice President/Senior Architect
Senior Data Architect for the DDI – Financial Data repository application that allows integration of a variety of
factory/golden sources and distributing them to the subscribers in the form of XML messages or DB replication.
Responsible (hands-on as well as managing) for gathering requirements, XML/XSD hierarchical to relational data
conversion, conceptual and logical data modeling, physical database design, metadata management, changed data capture
(CDC) procedures, performance tuning, maintaining metadata repository and building DataMarts (as a part of DW
strategy based on the Kimball’s methodology).
Managed two offshore teams on a variety of projects.
Lead efforts with the best practices and implementing of the data aging processes and practices (as well as Oracle DB
partitioning).
Important objective was a seamless Integration of mortgage, trade, legal entity, financial instruments and external data via
ETL (Ab Initio) and middleware suite of tools (TIBCO). Coordination of TIBCO BW business processes with a variety
of components ( Oracle /Sybase databases) that performs data mapping and data manipulation.
The technical environment: Oracle 10I (PL/SQL, DDL,DML,procedures, triggers, tuning), XML/XSD, XML Spy, Erwin,
Java, TIBCO BW (Business Works), SQL Server, Documentum, Toad, Embarcadero, Business Objects
Types of financial data: mortgage, trade, rating, financial instruments, legal entity, position, Bloomberg etc.
Actively participated in the pilot and POC projects for GemStone (Cache DB) and Symantics Layer Ontology, Oracle in-
Memory option TimesTen.
The technical environment: Oracle 11 (RDFS), Oracle TimesTen, Ontology Tools (Protégé), GemFire, Documentum
2/2005 –8/2007. JPMorgan Chase. Vice President. Senior Systems Integrator.
Was leading efforts to integrate new sources of the financial data into JPMorgan Risk Management Systems.
Was heavily involved with the selection of the offshore development teams, technology and business issues,technical
architecture, integration with Client Reference Data Repositories, and day to day management.
Extensive DBA (Oracle) support and conceptual/logical/physical modeling.
The environment included wide set of tools, such as Oracle & Sybase ( DDL,DML,procedures, triggers, tuning), Erwin,
ETL tools, Java, Eclipse, JSP, Business Objects, Cognos, Documentum.
Implemented ETL related to forecasting information, including creating and manipulation of tables with raw SQL and
Integration Services (SSIS). Created related universe and reports. Gathered and staged source system data, and prepared
OLAP cubes for analysis by subject matter experts.
Was converting old DTS packages to SSIS solutions
Extensive Data Modeling and Cube development using Sybase as a persistent database layer
The following data sources are integrated: Thompson, Compustat, Capital IQ, BvD (European Financials)
Converted from consulting position to the full time position.
Major system development in the area of Credit Research & Review. Continued in the role of the architect of Credit
Review reporting system. Managed Document Repository Integration. Managed testing strategies.
Extensive experience with the offshore development.
From 9/95 – 2/2005 Consultant /System Integrator.
For JPMorganChase ( 11/00 – 2/2005):
Major tasks:
Developed and implemented DataMart strategy for the major Risk Management initiative. Integrate variety of tools for
reports generation and distribution. Define methodology for the appropriate use of the following products: Oracle, Sybase,
Cognos PowerPlay, Cognos Inpromptu,, Microstrategy, Microstrategy Broadcast/Narrowcast and BusinessObjects.
Incorporated Metadata Repository. Acted as an Application DBA for Oracle and Sybase with responsibilities
for creating and maintaining all DB objects, ETL, ODS, SQL/Plus and T-SQL, triggers, stored procedures, system
integrity.
Page 2 of 5
Leonard Metelitsa
34 Park Hill Terrace
Princeton Jct, NJ 08550 E-mail *.*********@*******.***
Acted as a Lead Architect (hands-on) for Portfolio Analysis & Research Outlook System that contains a variety of early
warning reports created by Market Based Tools (MBT). It is also used by Global Risk Assessment in its sampling
processes to evaluate the consistency of risk ratings on a firm-wide basis. The integrity and completeness of
this review is fundamental to the credibility of the firm's credit capital calculations. In conjunction with Industry and
Client Reviews was developing a Review and Research process that promotes consistency, forward looking reviews and
maximizes efficiency whilst minimizing credit losses and optimizing revenue generation throughout the credit cycle.
Required deep understanding of the complicated financial instruments, such as: EDF, Credit Default Swaps,
CreditGrades, External/internal ratings and grades, Compustat Financial Data etc. Among system highlights:
• Focus on developing insightful, forward looking and actionable credit views.
• Enable Corporate Bankers/ Credit Executives to analyze credit trends and credit “outliers” within a portfolio by
leveraging data and information sources efficiently.
• Apply and leverage risks and drivers identified in the Industry Reviews to assess exposure/capital trends and
concentration risks within a portfolio.
• Develop, record and store actionable strategies and recommendations that emerge from the Risk Review
discussions.
The benefits of this process include:
• Reduce credit losses while optimizing revenue generation throughout the credit cycle.
• Reduce time spent gathering data; increase focus on developing action-oriented recommendations.
• Satisfy external constituencies’ (e.g. regulators’) desires for a robust, well-documented risk review process.
Performed DBA and Data Architect Functions and was responsible for the metadata strategy.
The environment included tools, such as Oracle 9, Sybase (PL/SQL,ISQL, DDL,DML,procedures, triggers, tuning,),
Erwin, Java, Business Objects, Cognos, Microstrategy. DBA tools (Toad, DB Artisan)
For a major insurance company - (AIG 5/00 – 11/00):
Hands-on management of a large-scale data warehouse infrastructure redesign initiative. Major accomplishments include
deployment of multi-server mixed Unix/NT WEB enabled environment with elimination of single points of failure, built-
in scalability, and reliable centralized administration and security. This project is being done using the latest products
from Cognos Suite of tools as well as Java and XML. Migrated multiple systems from being Windows-based only to
being available via Web Portal. Provided interfaces to a variety of Data Marts initiatives within different business groups.
Designed and implemented ETL strategies for Data Marts data load, cleansing, and summarization.
The environment included tools, such as Oracle, Sybase (PL/SQL,ISQL, DDL,DML,procedures, triggers, tuning,),
Erwin, Cognos, DBA tools (Toad, DB Artisan)
Schwab - (12/97 – 5/00): Managed a major brokerage Data Warehouse initiative. This DW has been successfully
implemented in 1999 and produced significant advantages for analyzing customer relationships and internal indicators,
such as: Trader performance, Broker/correspondent profitability, Market Maker to Market Maker/correspondent
reciprocal analysis, P&L analysis etc. This system became foundation for the new Automated Trading System.
Responsibilities included full project lifecycle, overall business analysis and system architecture, data analysis and multi-
Dimensional modeling, design and development of multidimensional database (cubes), information operational data store
setup and maintenance, development of production process, development of front end using variety of front-end tools.
Development of Installation package for server and client, training of executives, analysts, and users.
Developed and administered several departmental (trading floor) DataMart implementations with Sybase 11 as backend
and Cognos tools and PB 6.0 as front end tools. Was fully responsible for the physical and logical database design,
Sybase installations, data acquisitions and cleansing, reports design and implementation. Developed multidimensional
models and their population procedures. Provided project management and coordination between developers and user
community.
Provided extensive DBA support for the BackOffice System including: resolution of performance and design issues and
on-going support for the front-end developers, backup and tuning strategies, disaster recovery scenarios using Sybase
Replication Server. Deployed and manage Replication Server and Sybase installations. Acquired extensive business
knowledge of backoffice and trading systems. Developed a system to comply with SEC-NASD rules & regulations. The
Page 3 of 5
Leonard Metelitsa
34 Park Hill Terrace
Princeton Jct, NJ 08550 E-mail *.*********@*******.***
application was supposed to generate reports, stock & broker transaction records, and present a GUI-Front End Interface
Compliance System for an SEC Audit. . Presentation Reports were developed using Cognos PowerPlay & PowerBuilder.
Backend was done with Sybase X.
For a major financial organization (Meyer & Schweitzer, NJ 9/97 - 12 /97) developed guidelines,
recommended tools, and conducted benchmark studies for development a DW solution. Implemented prototype Data Mart
solution using Oracle as a Data Store, IBM Visual Warehouse as a middleware/Data Mart repository/data acquisition
scheduler, Cognos tools as desktop datamarts
For a major pharmaceutical company (Warner Lambert, NJ 5/97 –9/97)
Senior Consultant for a Sales and Marketing DW project . Designed and implemented Data Mart solutions for several
departments. Used such tools as Oracle 7.5, Cognos PowerPlay and Impromptu, Oracle Express etc.
For an Internationally known Performing Arts Company (Metropolitan Opera Association,
NY 9/96 – 4/97) developed a full-blown Data Mart solution for all company’s Decision Support System needs. Acted
as a Project Manager and Architect with a full hands-on participation.
Data Warehouse Administrator for a major pharmaceutical company (BristolMyers Squibb
9/95 – 9/96)
This Data Warehousing initiative is one of the biggest attempted in the USA. It utilized integrated Oracle Warehouse
Software, HP hardware, HP Middleware, OLAP technology, Business Objects and Cognos interfaces
JPMorgan 03/1994 - 9/95 Associate (Senior Software Specialist)
Senior member of internal consulting group.
Develop Data Warehouse projects based on the Sybase/Red Brick Data Warehouse technology.
Among the most important tasks:
• Setting up data warehouse environment
• Setting data acquisition component for data warehouse environment
• Developing procedures for maintaining, managing and accessing warehouse data
Team leader for various client-server oriented projects. Full responsibility for many aspects of Sybase Replication
Server Development. This project involved over 200 tables replicating from primary site in NY to the client sites all
over world. Designed, coded, and implemented GUI based front end for the Replication Server. This system was
written in Visual Basic using ODBC and SYBASE SQL Server. The primary purpose of this system is to assist a
Replication Server Administrator in managing various objects of Replication Server.
Bankers Trust Co. 09/1987 - 03/1994 Assistant Vice President (Senior Systems Specialist)
Was a senior member of TRAC development team.
TRAC is a fully integrated on-line inquiry/update system for managing 401K savings and pension plans. This was one of
first ever major systems written using Visual Basic and PowerBuilder as a front end, SQL Server as main DBMS and
CICS/DB2 as a back end. Participated in all stages of the product development: from its conception, feasibility studies,
functional and design specifications and through the implementation and maintenance of several releases.
3/86 - 09/87 Republic National Bank of New York Senior Programmer Analyst
Acted as project leader for the development of Letter of Credit system. Work was done using CICS, COBOL, IMS,
BAL,VSAM. Because of strong BAL, CICS, and debugging skills, acted as a technical consultant to entire staff.
09/1981 - 3/1986 Computer Associates Software Designer
Designed, coded and implemented menu-based system for accessing and using RAMIS II on mainframe from PC
workstation. Wrote over 50 MICROSOFT C modules for PC Front End (PC RAMIS). Mainframe part was written in
BAL. Designed and developed protocol-independent interface to various terminals (BAL, IBM 3270 protocols). Acted as
a systems programmer with responsibility for CICS systems tables
Page 4 of 5
Leonard Metelitsa
34 Park Hill Terrace
Princeton Jct, NJ 08550 E-mail *.*********@*******.***
EDUCATION: M.S. Applied Mathematics Moscow Institute for Petrochemical and Gas Industry
Page 5 of 5
Contact this candidate