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, 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 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 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 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 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.

ConfidentialON 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 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 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 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 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.

EDUCATION:

Confidential School 
MSc in Computer Science. Database semantics and model conversion.
Confidential Institute 
Researcher. Simulation with application to processes on cargo terminal.
Confidential Institute 
Degree in Automated Control Systems.
Qualification: Systems engineer. 
Major: Software engineering, systems analysis and database design.