Data warehouse engineer

Denis Rozhkov

Phone: 732-***-****

Highland Park, NJ (available to relocate) Email: *******@*****.***

Senior Data Integration Engineer

Demonstrated professional with extensive experience working as an analyst. Strong interpersonal and listening skills that help to facilitate productive interactions with others in the industry. Exceptional attention to detail, results-driven and hard-working. Extremely analytical, dynamic, motivated, adaptable, self-sufficient individual who is able to think outside of the box. Searching for an opportunity where the extensive experience and expertise can be put to use further growing the business and propelling continual self-development and growth.

Core Competencies

More than 10 years of experience working in the IT industry handling data integration and database development.

Extensive experience in data warehousing via Oracle and Informatica.

Superior knowledge of SQL and a proven ability to write complex queries.

Proficient in BI tools like Microstrategy and Oracle BI.

In-depth hands-on experience with managing multi-terabyte data warehouses and data marts.

Designed OLAP and OLTP databases and software applications.

Test software, including developing testing requirements, test scenarios and test cases.

Install and tune system software and applications.

Work Experience

Alfa Bank JSC, Moscow, Russia 2007 – 2015

Data Integration Team Lead (2008 – 2015)

Senior Data Integration Engineer (2007 – 2008)

Maintained functionality of a large multi-terabyte enterprise data warehouse, including management and IAS reporting, analytical CRM and a debt tracking system.

Supported the ETL platform (PC) and reporting tools (Microstrategy, Oracle BI); implemented batch scripts that performed automatic backups of repositories.

Troubleshot software issues, including the implementation of workarounds/hotfixes in ETL code for production systems to be used until a patch is delivered.

Collaborated with developers during migration DWH DB2 to Oracle platform.

Achieved 25% time reduction of everyday data load into the data warehouse by optimizing software performance.

Reengineered ETL software code for preparing monthly financial reporting and reduced delivery time of enterprise P&L reports by 2 business days.

Maintained testing environments for developers and analysts teams; installed software and synchronized data with a production environment.

NIX Trading Company, Moscow, Russia 2004 – 2007

Software Engineer

Developed multiple applications for sales automation, warehouse management, HR management and food services support (VBA, MS Access).

Designed and developed databases (MS Access and MS SQL Server 2000) for storing sales information, merchandise data and HR data.

Converted applications from MS Access 97/2000 platform to the MS SQL Server platform; average delay for food services applications were reduced by 40%.

Performed business analysis; gathered business requirements; tested applications by team members; supported legacy code; provided technical support to end users.

Education and Certification

Oracle Essbase 11.1.1 Training – RDTex, LLC, Moscow, Russia (2010)

Informatica Data Quality 8.6 Training – Data Integration Software, LLC, Moscow, Russia (2009)

Oracle 10g Data Warehousing Fundamentals Training – RTDex, LLC, Moscow, Russia (2008)

MS in Applied Mathematics – Moscow Institute of Physics and Technology, Russia (2002)

Contact this candidate