Software Developer Engineer

RESUME

Roman Asadovsky Address: ***** NW **TH CT

e-mail: **********@*****.*** Plantation, FL

Phone: (508) 685 - 2837 33323

Objective

I am looking to secure a position of Data Architect with hands-on SQL

development or Sr. SQL developer in a challenging environment (either start-

up or well-established corporation) to utilize my expert skills of over 20

years seasoned DB Engineer and Data Architect with deep passion to SQL

language.

I have designed lots of OLTP databases and Data Warehouse/Data Mart

solutions, so I am intimate with OLAP DB design principles, including Inmon

EDW, Kimball Star schemas with different types of dimensional models (Type

I, II, III and combinations), and Dan Linstedt Data Vault.

I am skilled with translation of business requirements to DB models and

able to "think out of the box".

I have also experience of leading a team of 5 developers (4 SQL developers

and a DBA).

Right now I live in South Florida and not willing to relocate, although I

am open for remote opportunities with light travel schedule.

Summary of Qualifications and Skills

o Over twenty years in total of hands-on experience with database

architecting, data mining, large-scale data modelling, and

gathering/analysis of business requirements

o Expert knowledge of relational data structures, theories, principles, and

practices

o Expert knowledge of SQL (my favourite language!)

o Experience with various Business Intelligence solutions

o Outstanding ability to gain new knowledge within a short time frame

o Excellent team player, highly responsible, resourceful, flexible and

reliable

o Excellent client/user interaction skills

o Experience in litigation support (aka e-Discovery), financial, banking,

insurance and education industries

o Experience with organizing SME interviews and translate the requirements

to efficient Data Models

o Ability to "think out of the box"

o Design experience of DW/Data Marts (Kimball model). Star schema,

dimensions of type I, II III and combinations

o BI development experience

o ETL design/development experience

o Experience working in Agile/SCRUM development model

o Deep understanding of object-oriented methodologies

Software, Technologies and Platforms

o Languages: T-SQL, PL/SQL, FOCUS, Delphi, Pascal, Perl, C++

o Operating Systems: MS Windows, UNIX (AIX, Linux), MS DOS

o Technologies: OLTP, OLAP, Client/Server, XML, OOD

o RDBMS: MS SQL Server 2012/2008/2005/2000/7/6.5, Oracle,

SYBASE, MS Access

o Tools: ERwin, Power Designer, SSRS, SSIS, BISM Tabular,

Assential DataStage,

RedGate Toolbelt, TFS, WebFOCUS

US Patents (pending)

PUB. APP. NO: 200********. "Systems and methods automatically classifying

electronic data" September 15, 2005

URL: http://appft1.uspto.gov/netacgi/nph-

Parser?Sect1=PTO1&Sect2=HITOFF&d=PG01&p=1&u=%2Fnetahtml%2FPTO%2Fsrchnum.html

&r=1&f=G&l=50&s1=%2220050204191%22

Employment History

Anthem Education - Ft. Lauderdale, FL

07/2012 - Current

Data Architect

o Designed integrated solution of inter-operation between company's

home-grown student management system and various 3rd party

solutions. Used Erwin as main application for Database design.

o Designed several OLTP databases for different aspects of student

management and reporting for executives.

o Designed and developed Campaign management database and worked in

close collaborations with leading company's Application developers

to deliver turn-key solution.

o Developed complex T-SQL code (Stored Procedures, Functions) to

implement business logic of various student and loan management

business requirements.

o Some projects were done using SCRUM Agile methodology, and some

were done using waterfall development.

o Reviewed SQL code, written by other team members and mentored non-

senior peers.

o Worked closely with different departments and business users to fix

or optimize their workflow, minimize time and efforts in day-to-day

operations.

AIR Worldwide, Inc. - Boston, MA 06/2010

- 07/2012

Senior Database Engineer

o Designed parts of several databases for company's NGP (Next

Generation Platform) using Sybase Power Designer (Design was mostly

done when I have joined the company).

o Developed complex T-SQL code (Stored Procedures, Functions, Views)

to implement business logic of various insurance-industry

calculations like Loss, Marginal Impact, Exposure Concentration

analyses and more.

o Worked within Agile teams with SCRUM development methodology.

o Participated in SQL code-reviews of the other team members.

Citizens bank. - Providence, RI

10/2009 - 06/2010

Data Architect

o Responsible for business analysis and design of the Logical and

Physical Data Models for numerous projects, for both OLTP and OLAP

applications using CA ERwin.

o Reviewed and correct the Data Models, created by other teams to

enforce the standards.

o Performed complete compare and merge of the different versions of

the Data Models using CA ERwin.

Citizens bank. - Providence, RI

02/2009 - 08/2009

ETL Developer

o Analysed the Business requirements for the Data Warehouse, BI

reporting and offloading data from DW to OLTP DB for further

processing.

o Actively participated in design of Data Warehouse solution for

Regulatory, Risk and Compliance Management group based on Oracle

11g RDBMS, using JDeveloper.

o Developed parts of the Data Warehouse and Staging DB including the

database code (Stored Procedures, UDFs, Views).

o Design and development of complex multi-phase ETL process to

organize data flow to and from Data Warehouse database using

Ascential DataStage.

Fidelity Investments. - Boston, MA

03/2008 - 01/2009

Business Intelligence Developer, Consultant

o Design and implementation of various BI reports from several

databases, Data Marts and Data Warehouses, including complex self-

service reports using IBI WebFOCUS.

o Re-engineering existing Business Objects reports to WebFOCUS

environment.

o Development of the database code (Stored Procedures, Views) in

Oracle 10g & SYBASE.

o Business analysis of the requirements for the new BI reports.

o Intensive interaction with subject matter experts, providing

training, and consulting.

Pitney Bowes Legal Solutions (PBLS). - Providence, RI

06/1999 - 03/2008

(Before acquisition - Ibis Consulting, Inc.)

Database Architect - from December 2006

o Design of the OLTP databases and supervision of the team to follow

the standards in database implementation on MS SQL 2005 RDBMS.

o Architecting the conceptual, logical and physical models of OLTP

and OLAP databases.

o Hands-on implementation of the database code, (SPs, UDFs, Views,

Triggers)

o Analysing and resolving DB performance issues by analysing the

execution plans, creating indexes, de-normalising DB structure,

etc.

o Providing coaching, code review, training, and career development

to the staff

o Creating strategies and plans for data security, backup, disaster

recovery, and archiving.

Senior Software Developer/Analyst - till December 2006

o Database design and development including internal DB code

(business logic).

o Implementation of data warehouse and business intelligence

reporting solution.

o Client/Server and multi-tier applications.

Education History

IBM, Mainz, Germany 1998

o Training courses of ADSM Server database structure, ADSM Client

Structure and functioning, ADSM troubleshooting and customer support.

Belarusian State University of Informatics and Radioelectronics, Republic

of Belarus 09/1987 - 06/1992

o Equivalent of MS in electronics engineering, Belarusian State University

of Informatics and Radioelectronics, Department of Radio-Engineering and

Electronics. Courses of Calculus, Discrete Structures, Abstract Algebra,

Intel-processors Assembler, Object-Oriented Design, Data Structures,

Database Design, Microcomputer Programming, Operational Systems.

Research and Publications

Minsk, Belarus

o "LPCVD" - Low Pressure Chemical Vapour Deposition process modelling.

Belarusian State University of Informatics and Radioelectronics,

department of micro-electronics.

Foreign Employment History

IBA, an IBM alliance joint venture - Minsk (Belarus), Mainz (Germany)

08/1997 - 03/1999

Software engineer - IBM ADSM worldwide Level 2 Customer Support team

member.

Berlio, Ltd. - Minsk (Belarus)

08/1996 - 07/1997

Senior Database and Software Developer - DB design and development,

application development using Borland Delphi.

Reliable Software, Ltd. - Minsk (Belarus)

10/1994 - 03/1996

Software developer / Analyst - Database design and development and

application development using Watcom SQL (later SYBASE SQL Anywhere) and

Power Builder.

Belarusian Government Projects institute - Minsk (Belarus).

05/1994 - 10/1994

Software developer - Database design and development using Clipper (MS-DOS)

and driver development using MS MASM x86 assembler.

Heating and Mechanics institute - Minsk (Belarus)

07/1992 - 04/1994

Software developer - Development and support the Inventory Tracking

application for parts ordering for Russian nuclear plants using Clipper.

Inter Quattro, ltd. - Russian-French-Italian joint venture - Minsk

(Belarus) 10/1990 - 12/1992

Software developer - Development of a solution for optimization of truck

routs of company's truck fleet.

Micro-electronics Lab in Belarusian State University of Informatics and

Radioelectronics 09/1988 - 06/1991

Software developer - Development of an application to model "LPCVD" - Low

Pressure Chemical Vapour Deposition process.

Contact this candidate