Project Manager Engineer

Irina Smirnova

E-mail: ********@*****.***

Cell phone: 646-***-****

Located in: Towaco NJ

SR. SOFTWARE ENGINEER

SUMMARY:

- 10+ years of professional career in Information technology.

- Last 3+ years - working as a senior ETL engineer in a successful

investment technology firm.

- Strong ETL background, solid data modelling/management skills using

relational and multi-dimensional concepts.

- expert in database/systems design, analysis and development; web

development and database administration expertise.

- Excellent communication and team leading skills.

- Degree in Computer Science.

TECHNICAL SUMMARY:

Databases:

- Oracle, Sybase, Interbase, MySQL, MS Access.

Programming languages, techniques and tools used:

- Oracle SQL, ANSI SQL, PL/SQL, HTML, XML, Java;

- INFORMATICA

- TOAD, SQL*Plus, SQL*Loader, SQL Navigator, Oracle JDeveloper;

- performance tuning, data migration from different platforms to Oracle

and vice versa.

Data modeling, design, architecture:

- Data Warehousing; Multidimensional, ER modeling; Data Staging&Mapping

(ETL); Distributed Databases;

- Conceptual, Logical and Physical data modeling;

- Data normalization and denormalization;

- ORACLE Designer, Oracle Warehouse Builder (ETL), ERWIN.

Operation systems and other tools:

- Windows, Unix, Linux, AIX;

- RATIONAL Rose; UML; OOAD; MS Office;

- MS project; Visual Source Safe; Lotus Notes, WinCVS.

PROFESSIONAL EXPERIENCE:

ITG, August 2005 - February 2009

As a senior software engineer - part of Transaction Cost Analysis team:

- Maintaining and supporting market data and retrieving it applications.

- Maintaining and supporting development and production environments for

Informatica based applications.

- Developing and maintaining Unix scripts, data transformation/cleaning

(Informatica) jobs.

- Working closely with DBAs (Sybase), Unix/Windows support teams.

- Taking on various tasks/responsibilities, overlooking project

consultants, striving to improve maintenance/support routines for

Production and Development environments.

- Maintaining/upgrading application software on Unix servers/client

machines.

- Ensuring environment structure and quality as well as being the main

person responsible for deployments in Production.

AIG, January 2005 - August 2005

As data architect supported multiple software projects on various database

platforms (Oracle, DB2, MS SQL)

- Analized existing or necessary data structures, requirements.

- Designed database models using ERWIN.

- Delivered DDL as a final product to be executed by the team of DBAs.

- Participated in projects' meetings helping define requirements based on

my experience, with a lookout for future changes and system development.

Freedom Institute, October 2004 - December 2004

- Donor and donation database transition from FileMaker to FoxPro

databases.

- Data analysis, transformation and clean up using MS Excel Macros,

Visual Basic.

Microlink Systems, August 2002 - August 2004

State Compulsory Health Insurance System project (with Data Warehouse for

Statistics and Reports)

As a database developer:

- Defined high standard Entity/Relationship and Design models (using

Oracle9i Designer).

- Assisted in design of ETL processes using Oracle Warehouse Builder

for Statistics and Reports module.

- Created and revised tables, triggers, types, objects, collections and

other database objects (Oracle Designer, TOAD).

- Manipulated data using complex Excel functions/formulas and SQL*Plus

for testing.

- Worked with user change requests.

- Coded and tested high difficulty financial calculation

procedures/functions/packages using PL/SQL and cost-effective SQL.

As a systems analyst and designer:

- Working directly with client, performed requirements analysis for

several subsystems.

- Designed application's business and technical levels.

- Led the team of programmers through the full development cycle.

- Assisted QA team and end users in testing; coached new team members.

University of New Mexico, January 2001 - August 2002

Computational Biology project (data warehouse design, administration and

maintenance)

As a database developer:

- Created and maintained data warehouse environment and architecture

(data files, tablespaces, user schemas, etc.).

- Created and tested STAR schemas (dimensions, facts) and assisted in

data exchange between Biology, Statistics and Computer Science researchers.

- Designed and developed ETL processes (Oracle Warehouse Builder, TOAD,

SQL*Plus, SQL*Loader).

As a database administrator:

- Installed Oracle Enterprise Edition Server and Clients on Linux and

Windows platforms.

- Created and maintained Oracle database, repository, tablespaces, user

schemas, managed data files, etc.

- Performed security audit on database server.

- Established and maintained replication and other distributed database

mechanisms between database servers.

As a systems analyst:

- Created analysis report for the Genomics Research environment,

existing Genomics data and research needs in order to build the Data

Warehouse specification.

- Presented data warehousing technology to different groups of

researchers.

DataPro Group, July 1999 - December 2001

Agriculture Ministry Rural Support Service project

As a database developer:

- Created database ER model and physical design.

- Prepared SQL statements for java programmers, designed and

implemented business logic using PL/SQL.

- Performed data migration from MS Access to Oracle.

As a team leader:

- Interviewing client and end-users defined overall application goals,

problem domain and web-application concept.

- Using Rational Rose defined functional requirements (use case

diagrams, problem-domain class diagrams, sequence diagrams).

- Managed team work and assisted project manager in planning and

scheduling tasks.

State Insurance Control Inspection project

As a programmer-analyst:

- Revised analysis documentation and specified database design using

Oracle Designer tools.

- Implemented SQL and PL/SQL code.

- Implemented/tested user interface components in Delphi.

- Consulted other developers on system design.

Latvia state official newspaper finance and client input system support

As a systems analyst:

- Revised design documents to meet change requests.

- Communicated necessary changes and improvements to end-users and

prepared tasks for programmers.

- Assisted project manager in project planning.

Other responsibilities

- Chaired workshop on object-oriented software development techniques.

Albuquerque public schools, February 1999 - June 1999

Year 2000 renovation project:

As a programmer-consultant worked on:

- Y2K compliance issues using Unisys LDA III for A-Series machines.

- Consulted clients and colleagues on various work aspects.

- Participated in systems migration from A-Series to Windows NT.

Riga Aviation University, 1994 - 1998

As a programmer worked on:

- accounting and student registration system development on Interbase

and Delphi.

- system analysis and requirements definition for Media Distribution

Company Produced internal system (using Use Case and other object oriented

techniques).

- Performed data migration from Clarion to MS Access and from Interbase

to MS Access.

EDUCATION:

M. Sc. Computer Science 1998 - 2000

University of Latvia

B. Sc. Computer Technology in Business 1994 - 1998

Riga Aviation University.

AWARDS:

- Awarded a prize for excellent Bachelor's thesis as well as multiple

fellowships for great progress and advancement studying in the

university.

LANGUAGES:

English, Russian, Latvian.

Contact this candidate