Resume: Alla Gribov, DB Architect

ALLA GRIBOV

9 Anita Circle

Newton MA 02468

alla@sergey.com

(617) 797 - 9476

OBJECTIVE:

To obtain a challenging position as a Database Architect/Developer to utilize my skills in building complex software systems

SUMMARY:

A specialist in database design and development, with extensive experience in analyzing user requirements, data modeling, database design/development, tuning, testing and troubleshooting with experience in web and network programming. Highly motivated with excellent organization and analytical skills. Detail-oriented and capable of handling multiple assignments efficiently. Works well under pressure, independently and within a cohesive team.

SOFTWARE:

Programming Languages: SQL, TSQL, PL/SQL, Perl, C, Pro*C, Unix Shells, Embedded SQL

Databases: MS SQL Server, Oracle, PostgreSQL, Sybase

Operating Systems: Linux, Solaris, Windows

Development Tools: ERwin, Oracle Designer, Oracle Forms, Oracle Reports, ODBC

Technologies: Database Design and Development, Database Performance Tuning, Database Administration, Web Programming, Network Programming

EXPERIENCE:

2/2006-present Avalere, Inc., Framingham, MA

Database Architect

Participated in design and development of the new Avalere product “Avalere Information Assurance Manager” – product, which allows companies to identify and secure information on laptops and desktops

Designed and developed all database-related pieces of the product – ErWin diagrams, DDL scripts, stored procedures, install/upgrade methodologies (MS SQL Server 2005, Windows)
Designed and developed Client database, that gathers data about information stored on the PC as well as Server database – central repository of the data coming from all Client databases
Designed and developed real-time transfer sub-system to move data from Client databases into the Server database
Designed and developed stored procedures for Reporting sub-system
Designed and developed data-driven rule-based Policy Engine, built upon a set of components, utilizing complex logic
Developed procedures for the database release engineering

1/2005-12/2005 IntelliReach, Inc., Dedham, MA

Database Architect

Participated in design and development of the new IntelliReach product, called mx2020. mx2020 is a complex email lifecycle management solution

Designed and developed all database-related pieces of the Platform – ErWin diagrams, DDL scripts, stored procedures, install/upgrade methodologies (PostgreSQL, Linux)
Participated in development and maintenance of the existing products (SQL Server, Windows)
Build database support for very-generic mx2020 rule-based Policy Engine, built upon a set of components and driven by the database
Developed procedures for the database release engineering

2/2004-12/2004 OpenPages, Inc., Waltham, MA

Senior Database Engineer

Participated in design and development of the OpenPages databases (Oracle, PL/SQL) to support the main product – Sarbanes-Oxley compliance software called SOX Express.

Participated in the re-design of the main database supporting SOX Express to improve performance: migrated data from the graph representation into trees, moved meta-data into attribute tables
Participated in design of the DataMart to be used with 3^rd party reporting tools. Designed data warehouse schema to have data readily available for reporting and developed set of packages and stored procedures to move application data into the DataMart data
Designed sub-system to perform Sarbanes Compliance Objects Reset (SCOR) to start new Reporting Period - participated in the overall system design and implemented design of DB tables and stored procedures to support this project. This sub-system allows users to do massive data changes across all the Compliance Objects in the system. Also, SCOR dramatically improved performance of the system, by eliminating other means of massive Objects Reset (using XML files)
Performed miscellaneous DBA tasks, such as Oracle installation, physical tuning, SQL tuning etc

1/2003-12/2003 SAG Development, Inc., Newton MA

Senior Oracle Consultant for Fidelity Investments, Inc.

Participated in design and development of the eReporting system – internal reporting system for business users. Provided consulting services on improving database performance. Designed and implemented procedures for the database-related release engineering. Converted several reports from being run using Essbase Hyperion product to be run directly from the relational Data Warehouse, which drastically improved performance

Senior Oracle Consultant for CVS

Participated in development of multiple back-end applications to support CVS’s Xtra Card Services (Oracle 8i, Pro*C). Provided client with the source code, documentation and testing plan.

Designed and developed testing tool to drive testing of the above mentioned applications (Java, network programming)

Senior Oracle Consultant for Massachusetts Department of Revenue

Participated in design and development of Local Aid System – Oracle application to support Local Services for Cities and Towns of Massachusetts.

Designed and implemented logical and physical schema (Oracle Designer), wrote a set of stored procedures to support business logic of the application – producing of Cherry Sheets, uploading data for Actual Assessments and Distributions, calculating Actual Distributions etc (Oracle 8i, PL/SQL). Developed a number of front-end screens and reports to support Local Aid application (Oracle Forms 6i, Oracle Reports 6i)

8/1999 – 1/2003 eDial, Inc., Waltham, MA

Senior software engineer

Responsibilities included design, development and administration of all databases to support eDial’s products and services.

Designed and implemented 24x7 Oracle database to support all aspects of eDial’s telephone-related services. Performed logical and physical design of the database, designed and implemented all necessary packages and procedures (Oracle, PL/SQL, C, Pro*C)
Provided full administration of all eDial databases. Developed a set of scripts to monitor 24x7 production system, designed to support thousands of users. Performed all DB installations and software upgrades, database tuning on a logical and physical levels. Planned and executed DB back-ups and recovery procedures (Oracle, Shells).
Designed and implemented a solution to keep communications between the DB and all other parts of the system asynchronous – utilizing Oracle library executing C-based reporte procedure calls (Oracle, C, TCP/IP)
Designed and developed a billing system for eDial’s phone services – credit cards charge, fraud detection (Oracle, PL/SQL, C, Pro*C)
Designed and implemented set of management reports to provide management group with all kind of statistics of the eDial’s. Reports were ran daily, weekly and on demand, also implemented a web interface for this reporting system (Oracle, PL/SQL, Shells, Perl).
Designed and implemented a web-interface for system administration of eDial product (Oracle, Apache, Perl, DBI/DBD, C).
Performed total re-write of the database from Oracle to PostgreSQL for “eDial-in-the-box” product (versus the services model) (PostgreSQL, PlPgSql, Embedded SQL, C)

4/1995 – 7/1999 UpTick Technologies, Inc., New York, N.Y.

Senior programmer/analyst

Responsibilities include design and developing of new systems and maintaining and tuning existing applications. Performed database design and development, on-site installation and customer technical support, troubleshooting and administration of Oracle, MS SQL Server and Sybase databases as well as Windows NT administration.

· Designed and implemented a service bureau independent system for brokerage industry back-office support, that consists of Customer Ledger, General Ledger, Commission and Correspondent Ledgers. Performed logical and physical design of the database. Designed and implemented a set of packages to load data from service bureau files, propagate real-time updates of customer and general ledger accounts’ balances and positions based on incoming trade and not-trade related information, post information between different ledgers, calculate trade related charges for correspondents and payout amounts for sales representatives (Oracle 7.x, Oracle 8i, ERwin 3.5, PL/SQL).

· Designed and implemented Trading P&L System. The system calculates profit and loss for each trade based on different business rules and accounting methods, such as FIFO, LIFO and Average Cost using stored procedures called form C program. Designed several screens allowing user to overview Borrowing Rates, Cost of Carry Rates. etc (Oracle 7.3, PL/SQL, Pro*C, PowerBuilder 5.0)

· Designed and implemented back-end for General Ledger System. Real time balances were maintained using triggers and stored procedures. Also developed several applications for daily processing of trades related information such as accounts’ balances, securities positions and general journal entries. The data was loaded from flat files into multiple database tables (MS SQL Server 6.5, Transact SQL, ODBC).

· Designed and implemented back-end for Sales Compensation System. The system was designed to calculate salespersons’ payouts according to complicated rules of compensation schedule and implemented using triggers and stored procedures, launched from C program (Sybase 11, Transact SQL, Embedded SQL)

· Performed Oracle, MS SQL Server and Sybase installation and different administration tasks.

· Life-cycle support of these projects through Alpha, Beta and commercial tests.

1993 - 1995 Fortham House Realty Corp. New York, N.Y.

Part-time position as programmer-analyst

Participated in design and development of Real Property Management System.

Responsibilities included schema and integrity constraints design, development of accessories. Participated in implementation of various numbers of data loading applications and reports. (Oracle 6.0, Pro*C)

EDUCATION:

1997 - M.Sc in C.S. at Polytechnic University, Brooklyn, N.Y.

1991 - B.Sc in C.S. at Polytechnic University, St. Petersburg, Russia.