SUMMARY OF QUALIFICATIONS:

• Data Architect, ETL Architect, Data Analyst, Data Modeler, Database Designer and Team Lead, Database Back-End Professional.
• Extensive database system analysis, design, and implementation experience.
• Proficient in business analysis, end-user analytics, development lifecycle, ETL, QA and testing, production support, performance tuning.
• Conceptual thinker, results oriented, creative, thorough, initiative, technical, pragmatic, analytic/systematic thinking, great problem-solving skills, able to identify and justify the optimum solution
• Able to participate in multiple projects simultaneously and to prioritize tasks

TECHNICAL SKILLS:

DATABASES: Oracle, Oracle Designer, SQL, PL/SQL, SQL*Plus, SQL*Net and Net8, SQL*Loader, SQL*Forms, Pro*C, IBM DB2/UDB EEE, MS SQL Server 7 and 2005, T-SQL.
DATA MANIPULATION TOOLS: from UNIX shells (ksh, bash, csh) and various scripting languages (Perl, awk) to high-end (Ab Initio) and low-end (MS SSIS) ETL tools, Oracle DBA Console, Enterprise Manager, TOAD, AQT, SS2005 Management Studio, BIDS, IBM Control Center.
CASE/DATA MODELING TOOLS: CA ERwin, Oracle Designer, ER/Studio, Power Designer.
VERSION CONTROL/ TRACKING SYSTEMS: PVCS, SourceSafe, Ab Initio EME, Rational ClearQuest, Subversion.
OPERATING SYSTEMS: UNIX systems like SunOS, Solaris, HP-UX, AIX; Novell Netware, MS DOS, Windows, old IBM OS, HP MPE/iX, some VAX/VMS.
INTERNET TOOLS AND PROTOCOLS: Oracle Application Server, Oracle web gateway, PSP, Apache, HTML, CGI, NDM, some Java and Javascript.
BI TOOLS: Oracle Discoverer, Seagate Analysis, and Cognos Powerplay.
LANGUAGES: C, C++, Pascal, Basic, FORTRAN, PL/1, JCL, various script languages,FoxPro/Clipper/dBase, Speedware 4GL.

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX September 2009 – December 2009
Data/ETL Architect

• Working on Oracle ODS to Hyperion Essbase cube load process. SQL prototype has been designed, built and validated, after that Datastage 7.5.2 parallel ETL processes were created.
• Various analysis/design/architecture tasks performed. Documentation prepared.

Confidential, Boston, MA May 2008 – August 2009
ETL Architect

• Working on various data feeds for the asset management DW and other system. Ab Initio 1.14/2.14, Eagle PACE, SQL Server 2000 and 2005, Oracle 10g, ESP, Subversion, Remedy.
• Improving current architecture, design, delivery and support model, and helping in related areas.
• Coaching and mentoring staff developers.

Confidential, Toronto, ON October 2007 – April 2008
ETL Architect

• For a marketing/customer relationship management DW creating new data architecture, designing and implementing new ETL process to replace existing mainly ELT routines. SSIS, SQL Server 2005.
• Helping with data modeling, new QA subsystem design and other project tasks

Confidential, Istanbul, Turkey April 2007 – September 2007
Ab Initio ETL Lead Specialist

• Data transformation process for Turkcell DW. Built common components and graph templates. Designed and created subject area processes.
• Helped with data architecture, data modeling and environment setting.
• Mentored and coached staff developers and consultants.
• Developed project related documentation, participated in business meetings and other activities as required by projects.

Environment: Ab Initio 2.14, Oracle 10g and lower, Solaris.

Confidential, New York, NY December 2005 – March 2007
Ab Initio ETL Lead Specialist

• Data transformation and verification for various projects. Designed and implemented the most complex data transformation processes and algorithms. Created regression tests architecture and process. Handled multiple inputs and outputs from Cobol copybooks to XML.
• Developed project related documentation, participated in testing, performance tuning, business meetings and other activities as required by the projects.

Environment: Ab Initio, DB2/UDB, AIX.

Confidential, Toronto, ON February 2004 – December 2005
Ab Initio ETL specialist

• Data transformation and verification for Basel II Accord and Anti-Money Laundering projects. Wrote specifications, system design documents, unit and system test plans. Led and coordinated development and testing efforts, investigated and resolved production issues. Developed and deployed Ab Initio graphs, reusable components, functions, reusable UNIX scripts. Worked with ascii and ebcdic files, with Cobol copybooks and SAS, variable record formats, complex transforms, serial and multifiles, lookups, normalized and denormalized designs, slowly changing dimensions and fact tables.
• Developed and deployed regression testing mechanism for Ab Initio based ETL jobs.
• Developed and deployed various AIX shell scripts.
• Developed project related documentation, participated in testing, performance tuning, business meetings and other activities as required by project.

Environment: MVS/TSO, FileAid, InSync, JCL, UNIX AIX, ksh, DB2/UDB EEE, AQT, Ab Initio, EME, Windows, MS Office, Visio, ERwin, ClearQuest.

Confidential, Toronto, ON May 2003 – December 2003
ETL/ QA specialist

• Data transformation and verification for PeopleSoft EPM inbound data stream, Customer Value Management (CRM type project), Basel related project and others. Developed and deployed UNIX and SQL scripts, reusable components, Ab Initio graphs in highly parallelized environment. Worked with mainframe originated files (ebcdic coded, with or without Cobol copybooks), vectors and normalized records, variable record formats, complex transforms, serial and multifiles, lookups, normalized and denormalized designs, slowly changing dimensions and fact tables.
• Developed efficient modular approach to data transformation development process based on structured business specifications employing IBM DB2 and AIX tools and Microsoft Excel capabilities.
• Prepared presentations, coached team members.

Environment: Mainframes, AIX, DB2/UDB EEE, Ab Initio, PVCS, Win 2000, MS Office, Erwin, AQT.

Confidential, Toronto, ON June 2002 – October 2002
Dimensional Data Modeler

• Dimensional data modeling for the Marketing and Finance department of Card Products Division.
• Participated in: Conceptual and Logical data models development; Standards development including naming rules, classwords, domains; extending data dictionary to accommodate new DW contents; data mapping from existing and new systems to the datamart, planning of data transfer to ETL repository; performed regular data modeling tasks; performed data analysis and investigated performance problems on physical model level; participated in overall architecture development. Advices given, knowledge transferred, experience shared.

Environment: Erwin, ModelMart, DataStage, Oracle, Toad, Sun Solaris, Windows NT.

Confidential, Toronto, ON February 2002 – June 2002
ETL/ QA specialist

• Data transformation, validation, and verification for Customer Value Management component of CRM Data Warehouse. Developed and deployed UNIX and SQL scripts in Ab Initio environment.
• Proposed metrics and developed measuring procedures for data validation in staging-to-production data stream.

Environment: AIX, DB2/UDB EEE, Ab Initio, PVCS, Windows 2000.

Confidential, Toronto, ON June 2001 – October 2001
Performance tuning specialist

• Database tuning and performance specialist role. Improving SQL in PL/SQL routines within SQL*Plus and UNIX scripts with the main goal of speeding up long running jobs in multi-processor Sun environment, been achieved at 50% ratio.
• Some data and process modeling with Power Designer and Visio. Designed and developed generic solution for utilizing concurrent processing architecture for performing calculations and reporting.
• Helped with migration planning from Oracle 7.3.4 to 8i version.

Environment: Oracle 7 and 8i, Toad, Sun Solaris, SQL, SQL*Plus, PL/SQL, shell, Power Designer

Confidential, Toronto, ON February 2001 – June 2001
Data architect/modeler

• Data analyst/designer/ETL developer role. In 40 days the existing conceptual/logical data model prepared in ERwin was improved, instantiated, database created and prototype data extracted, validated, cleansed and loaded, design published. Then metadata was converted from ERwin to Designer 6i using Oracle Repository API, and new set of diagrams was created. Demo 3-tier intranet application generated (PL/SQL, Web Forms) from the model in Designer in form of web site with dynamic content and simple security model. Deliverables included data architecture and data load strategy for the Common Data Element Repository, ETL design and procedures, ER and physical database model.
• Further developed data model, identified public, internal and third-party proprietary data sources including those from other ministries, made selections, developed loading and transformation procedures. Worked, as a team member, on naming conventions, modeling standards and other documents based on Zachman framework approach. Some administration both for Oracle server and Designer.

Environment: Oracle 8i (8.1.7), SQL*Loader, PL/SQL, Designer 6i, ERwin, Oracle iAS, PSP, HTML,
Apache, Windows NT.

Confidential, Toronto, ON December 2000
Consultant

• Performance tuning of SQL in stored procedures with nested cursors.
• Data analysis for and development of data verification and database cleanup tool. Data modeling.

Environment: MS SQL Server 7, T-SQL.

Confidential, Toronto, ON May 2000 – August 2000
Database design and ETL consultant

• For a start-up B2C e-commerce Company designed and developed ETL policy and procedures using T-SQL and other MS SQL Server tools, and also performed data modeling using ERwin and some business analysis.
• Development and testing, performance tuning.

Environment: MS SQL Server 7, NT, ERwin, some Cognos Powerplay, Transformer.

Confidential, Toronto, ON October 1998 – May 2000
Consultant

• Database architecture for a datawarehouse. Based on existing Oracle application, a data architecture for newly designed datawarehouse created using ERwin. Also some business analysis, analysis of the existing report subsystem, object-to-relational data model conversion (Objectstore to Oracle 8i), participated in physical database design, capacity planning, tested reporting and BI tools. Oracle 8i, Toad, NT, AIX, ERwin, some ER/Studio and Discoverer.
• For another client: upgrade and refinement of their existing data structure and application written in PL/SQL and Java has been done. For database move from version 8 to 8i migration planning and executing. Documenting and incremental development of their core business system (commercial and consumer credit evaluation) for Newcourt Credit Group. Helped other teams with Oracle, setting up VCS based development environment.

Environment: Oracle 8 and 8i, SQL Navigator, PL/SQL, SQL*Loader, ERwin, OAS, HTML, Solaris, NT, 95, PVCS.

Confidential, Rotterdam, the Netherlands August 1998 – September 1998
Data Analyst
Y2K project for BP/Texaco joint venture involving analysis and update of Pro*FORTRAN sources both main programs and subroutines and user exits called from within SQL*Forms in VAX/VMS environment with Oracle Server as back end. OS level generic scripts to automate routine tasks developed.

Confidential, Atlanta, GA August 1997 – June 1998
Data Analyst, Consultant

• Data analysis and database support for Concert Communications Company: Documented existing database for inventory and provisioning for Concert (BT/MCI joint venture) worldwide network, created data models in Designer 2000, ER and Data Diagrams, consulted developers.
• Supported database related activities, developed PL/SQL procedures in SQL*Plus and UNIX scripts to perform functions not provided by the existing application such as database consistency check and support, special queries and ad-hoc reports, data cleansing tasks, generic tools to ease maintenance. Also some SQL performance tuning.
• Data interfaces project for Concert (BT and MCI): Evaluated existing solution, re-designed application architecture, discovered and discussed new business rules and brought different low-level designs in consistency with high-level goals and technical architecture. Extensive data verification for the outgoing datastreams.
• Redeveloped code using shell and SQL*Plus scripting and PL/SQL, prepared additional documentation, managed testing, production set-up and support of software components. The interfaces project was to extract data from inventory/provisioning system and send it over to other MCI and BT systems, total 6 including 3 billing, and ensure the data is clean, consistent and prepared according to target system rules and expectations.

Environment: UNIX (Sun OS, HP-UX, OSF/1) shell programming, PL/SQL, SQL*Plus, Designer/2000, NDM.

Confidential, Miami, FL January 1995 – August 1997
Developer-researcher

Database project for Everglades National Park Research Center
Responsibilities:

• Performed business analysis, conducted technical meetings to evaluate existing and discuss new applications, designed conceptual schemas, performed conversion to relational model, presented and discussed results.
• Developed and employed conversion tools from semantic to relational database model.
• Developed loading procedures for Physical Observations Subsystem, including transformation from different data representations by means of SQL functions and SQL*Loader advanced features, UNIX (Sun OS, Solaris) shell programming, PL/SQL and SQL*Plus.
• Developed UNIX scripts and procedures to automatically generate Oracle Forms using in-house developed CASE tool for the large amount of Oracle tables.
• Trained the team to apply procedures developed in other subsystems and phases of the project.

Semantic-to-Oracle CASE project

Responsible for architecture and further development and maintenance of semantic binary model CASE tool, including clarifying goals and tasks for other developers, development, technical support, troubleshooting. The tool employs UNIX scripts and utilities and C programs to perform conceptual and logical design, forward engineering of data model to Oracle, automatic preparation of Oracle forms and reports for large amount of sub-schemas. Further development included migrating from Forms 3.0 to Forms 4.5, extending original model to multi-account, multi-tablespace environment, developing mapping and translation procedures from semantic to relational model.

Responsibilities:

• Developed database schema for TPC-C benchmark.
• Consulted database design team for FIU President Research project.

Confidential, Moscow, Russia January 1992 – September 1994
Developer-manager

• Marketing, sales and support for bank information system in a region of Ukraine.
• Installation, data cleansing, conversion and upload from an existing system. Training and troubleshooting. Converting business rules and the whole system to comply with local government regulations.
• Custom development for national and foreign currency operations: business analysis, design, development, testing and deployment. Developed software and procedures to communicate with nationwide electronic transaction processing system on the bank level. Clipper, FoxPro, Novell Netware, MS DOS, MS Windows.

Confidential, Vienna, Austria October 1994 – December 1994
Maintenance and support specialist

• Support for small international bank information system written in C++ in Novell Netware and MS Windows environment.
• Developed procedures to provide fast and convenient real-time routines to operate with currency exchange rates.

Confidential, Moscow, Russia January 1991 – December 1991
Technical marketing specialist

Responsibilities:

• Technical marketing for Nantucket, later Computer Associates, line of Clipper and PC-based products. Communicated with users, prepared product reviews and presentations, developers conferences and workshops.

September 1974 – December 1990
Various IT, DP and MIS positions, research and teaching (detailed list available upon request).

EDUCATION:

School of Computer Science
MSc in Computer Science. Database semantics and model conversion.
State Scientific-research Institute of Automobile Transport
Researcher. Simulation with application to processes on cargo terminal.
Moscow Automobile and Road Institute
Degree in Automated Control Systems.
Qualification: Systems engineer.
Major: Software engineering, systems analysis and database design.

Available upon request