ARKADIY KRIVOVYAZ

**** ***** *******

Brooklyn, NY 11235

718-***-**** or Cell: 347-***-****

acd7he@r.postjobfree.com, acd7he@r.postjobfree.com

SUMMARY

Data processing professional experienced in Business Intelligence

Enterprise cloud solutions, installation, configuration and support of SAP

Business Objects Business Intelligence platforms, using entire suite of SAP

Business Objects tools for administration, version upgrade, promotion

management and monitoring, creating and administrating highly customized

reporting environments (SAP Business Objects, Java and .Net SDK),

integrating different software products with third-party reporting tools,

developing Business Objects universes, reports, and dashboards (Business

Objects Web Intelligence, Crystal Reports, Xcelsius, Oracle Reports, SSRS,

Access), Data Warehousing and Data marts, software development (.Net C#,

Java, Visual Basic, Oracle Forms, ASP, JSP), software development

methodologies (SDLC, Agile), software tools for revision control (GitHub,

VSS), database design, development, support and administration (MS SQL

Server, Oracle, MySQL), creating stored procedures, triggers, packages

(SQL*Plus, PL/SQL, T-SQL), clinical trials software (Medidata Rave),

scripting (Power Shell, VB Script, Bash Shell), ETL tools (Data Junction,

SSIS, SQL*Loader, shell scripts), system troubleshooting

Platforms: Windows 7/XP/2003/2008, Linux Red Hat 6

RDBMS: MS SQL Server, MySQL, ORACLE

Languages: C#, Java, Power Shell, Bash Shell, SQL, T-SQL, PL/SQL,

Visual Basic, VBA, VBScript, JavaScript, HTML/DHTML, XML

Other: Business Objects 4/XI/6.5/5.1, Crystal Reports

Enterprise/2011/10/XI, SAP Business Objects Dashboards 4.0

(Xcelsius), Visual Studio 2012/2010/2003, SSRS, SSIS,

Medidata Rave, Amazon Elastic MapReduce and Hadoop, Apache

Tomcat, GitHub, JIRA, Spotfire, Oracle Forms, Oracle

Reports, SQL*Plus, SQL*Loader, Data Junction, ERWIN,

ER/Studio 6.0, SQL Navigator, Microsoft Office 2010, IIS

PROFESSIONAL EXPERIENCE

MEDIDATA SOLUTIONS, New York, NY 2004-presen

t

Team Lead (Mar 2012 - present), Senior Software Engineer (Sep

2009 - Mar 2012), Senior Reporting Specialist (Jun 2004- Sep

2009)

Medidata Solutions is a leading global provider of SaaS, cloud-based

clinical development solutions that enhance the efficiency of customers'

clinical trials.

As a SAP Business Objects Administrator, supported 35 BOXI production

clusters with separated App and Web tiers. Developed scripts for

installation BOXI App and Web tiers and procedures for their

configurations. Was in charge of monitoring different versions of

Business Objects platforms (5.1/6.5/BOXI/BO4), supporting,

troubleshooting and resolving system issues.

Created BOXI VM images. Developed automated procedure for installation

BOXI from images, which significantly simplified installation process

and improved entire system reliability by eliminating many error-prone

manual steps of cluster configurations and applying both SAP and

internal patches.

Developed BOXI monitoring solution (using VBScript) utilizing SAP

SDK-based and own probes.

Developed backup and recovery strategy and disaster recovery processes

for BO Platforms.

Developed security models for BO Platforms integrated with different

Medidata applications.

Developed procedures for migration "Medidata Rave" client installations

(Business Objects reports, universes, connections, scheduled jobs,

users, user groups, etc.): BO 5.1/6.5 to BOXI, BOXI to BO4.

Designed automated installation of SAP BO4 fault-tolerant and

load-balanced cluster (Windows, Linux) in AWS and own data center.

Implemented load balancing Tomcat web application servers with Apache

web server and F5 LB. Developed a number of SDK based utilities (.Net

and Java) for configuring reporting platforms and supporting automated

deployment.

ARKADIY KRIVOVYAZ Page 2

Developed scripts for deploying basic security settings, reports and

universes, deploying and undeploying Business Objects web applications

for fully automated SAP BO4 installation procedure.

Developed a number of auxiliary utilities for Business Objects (.Net

and Java SDK) for diagnostics and fixing issues in Business Objects

platforms, deleting unneeded or corrupted objects and entire

installations, changing universe properties, moving "Medidata Rave"

installations from one BO server to another.

Led the design, development, and deployment of SAP Business Objects

Business Intelligence Platform 4 (BO4) as an enterprise-class platform

integrated with different Medidata products. As a leader, coordinated a

team of developers working on automation (using Opscode Chef),

continuous integration (using Jenkins and GitHub), and validation of BO4

platforms. As an Agile scrum master, created backlog user stories, drove

daily scrums, grooming and planning sessions.

Developed few hundred standard and custom Business Objects Web

Intelligence (WebI), Crystal, and Rich-client reports and dashboards

based on complex T-SQL stored procedures, free-hand SQL, and Business

Objects universes. Assisted in writing and gathering the functional

requirements for reports. Reports were created for operational or

analytical purposes and utilized variety of techniques: multiple queries

with merging results, regular or cross table blocks, using drill paths,

hierarchies and scopes of analysis, variables with changing calculation

context, etc. Reports were accessible by consumers either directly from

Business Objects portal (InfoView) or were published directly in

Medidata application.

Performed logical analysis, tuning and optimization for many WebI and

Crystal reports created by the clients. Assisted external clients in

resolving most difficult Business Objects reporting issues and apparent

discrepancies in some fact measures between different reporting tools

and Medidata applications. Provided Business Objects training for

external clients.

Developed complex BO Universes supporting company's main product

"Medidata Rave" for various pharmaceutical and biotech companies.

Universes support majority of Rave's modules and functionalities,

utilize multiple contexts, shortcut and self joins, row and object

restrictions, support different scopes of analysis, contain a number of

pre-built query filters compatible with Rave standard parameters which

allows embedding WebI reports directly in this application.

Developed .Net (C#) sync service utilizing BO SDK API for updating

"Medidata Rave" universes in real time, creating and updating BO

reporting infrastructure for each client's installation. This .Net

service created Business Objects user groups, report and universe

folders, copied universe from a template, changed universe connection,

assigned overloads to user groups (via additional Java SDK utility),

performed necessary changes in joins, universe class and object

definitions, assisted in resolving some complex Business Objects issues.

Developed Java servlet for Tomcat web application server which utilized

BO Java SDK for creating BO users and supporting single sign-on based on

trusted authentication. Servlet performed also mapping Medidata

application time zones to Business Objects time zones, supported user

localizations and Medidata application's security.

Developed a number of training materials, release and technical notes,

articles in supporting web sites, all aimed to clarify different aspects

of Medidata products and Business Objects reporting platform for end

users and internal supporting services.

Actively participated in reporting platform evaluation that examined

Tableau, Spotfire, Business Objects, Cognos, QlikView, LogiXML, Pentaho,

and Jaspersoft.

Designed and developed logical and physical model of a Data Mart (part

of Medidata Rave Data Warehouse) to track patients enrollment,

randomization, office visits, and other activities during lifetime of

the clinical trial. Model consisted of a number of conformed dimensions

and a fact table implemented as an accumulated snapshot. Multi-valued

dimensions were implemented by adding bridge tables. Developed entire

ETL process: set of scripts, scheduled jobs, T-SQL stored procedures,

functions, and views for Data Mart incremental update in real-time.

Design included a set of auxiliary monitoring tables and support for

alerting. Developed Business Objects universe which supported this Data

Mart and allowed end users easily develop various analytical ad-hoc

reports.

Participated in creating logical and physical model, ETL packages (using

SSIS) for Medidata Insights metrics Data Warehouse from which the

Insights Benchmarks are computed. Model included a number of slowly -

changing dimensions, additive, semi-additive and non-additive measures.

ARKADIY KRIVOVYAZ Page 3

SALVATORE FERRAGAMO USA, INC., New York, NY 2001-2004

Senior Programmer/Analyst (Apr 2001- Mar 2004)

Net Sales Data Warehouse: System for analyzing sales and orders by different

dimensions

Performed system analysis, designed and developed logical and physical

model of a data warehouse (ERWIN/ERX 3.5).

Developed scripts installing Oracle database.

Developed a set of stored procedures and functions used for data

extractions and transformations (Oracle SQL*Plus, PL/SQL).

Developed ETL process (using Data Junction tool) for uploading data

warehouse based on Oracle database from operational systems based on

AS400.

Created Business Objects 5.1 reporting platform to use for investigative

analysis.

Developed Business Objects universes and numerous ad-hoc reports for

analyzing data.

Assisted users in creating customized reports.

Bookings Application: application for presentations, pre-order processing,

and tracking orders (Access, Oracle Forms 6i, Oracle Reports 6i, Oracle 9i)

Performed system analysis, designed database structures, stored

procedures, triggers

Created a set of forms implementing necessary functionality, numerous

reports with different layouts showing images of available styles,

order's details grouped by different attributes

MARSTECH CONSULTING, INC., New York, NY 2000-2001

Software Developer/Analyst (May 2000- Apr 2001)

Property Insurance System: software system to process property insurance

applications which was implemented using 3-tier model (ASP3.0, IIS 5.0,

Windows2000, VBScript, JavaScript, HTML, SQL Server 7.0, Access).

Created logical and physical database models (ERWIN/ERX 3.5).

Developed multiple stored procedures for inserting, deleting, updating

tables, and performing different calculations (SQL Server Enterprise

Manager, Query Analyzer).

Designed, coded and performed detail functional testing of multiple forms

(Visual InterDev 6.0 and SQL Server 7.0). Forms developed as ASP using

HTML, VBScript for server side processing and JavaScript for client side

processing.

EDUCATION

Graduated with honor BS/MS 5-year program in Computer Science, Moscow State

University of Railway Engineering (MIIT), Moscow, Russia.

CERTIFICATION

Oracle Certified Professional, 2000

A Registered Business School Full Teacher License (Office Skills, General

Academic, Computer Applications, Computer Programming), 2002

Contact this candidate