Sql Developer Software Development

* ** *

Natalia Rozhkova

NC, ***** USA

Tel.: +1-919-***-**-**

Email: ********.********@*****.***

PROFILE

• Oracle Advanced PL/SQL Developer Certified Professional (OCP)

• IBM Certified Database Associate DB2 Universal Database V8.1

• More than 18 years of professional programming experience with responsibilities and deep knowledge in database design for software development of the commercial applications on different platforms and environments;

• Strong knowledge of business specific for following finance domains : Accounting, Banking retail, Credit risk and insurances

• Experience and knowledge in Telecommunication business area, Automotive retail and service

• WDH design and development from scratch using parallel multiprocessing and distributed data storage

• Practical experience of applying various architectural approaches (R. Kimball/B. Inmon) to data organization implemented as relational and non-relational storage structures, used various types of data life cycles and versioning;

• MDM systems design used Data Vault technology, Anchor model, and master owner rules for Gold Record attributes

• ETL development

• Ability to learn new technologies quickly and independently. TECHNICAL SKILLS

● Data base design and programming on Oracle, PL/SQL, SQL-PL, Oracle Forms

● Development team management;

● Data bases: Oracle 8 .. 19, Exadata ; IBM DB2; MongoDB; Hadoop (Hive); PostgreSQL; GreenPlum; MS-SQL; Sybase; SQL-Lite; SAP HANA;

● Data base designing and developing for service-oriented applications: user authentication, communication channels, transfer protocols, message encryption and data contracts.

● DWH developing, Google Cloud Solutions

● Development/deployment collaboration using: Jira, CVS, GIT, Sonar, TeamCity, Luiquibase PROFESSIONAL EXPERIENCE

Year

08/2020 – 09/2024

Company

Skills

Position

Luxoft USA (DXC group), USA

Google Cloud DWH, Oracle, PL/SQL.

Senior Technical Expert/ Software Developer

Responsibilities

Working of Finance banking domain area at projects for strategic Luxoft customer in USA. Taking a part in development of integration processes between huge banking CRMs, trading and data processing systems and DWH, creating integration layer and implement transformation mechanism for data presentation and export. Designing and developing database structures and objects (Oracle Exadata) for the real time banking analytics systems and credit scoring in data warehouse systems (Oracle, Google Cloud solutions, Hadoop). Agile methodology and Scrum framework for customer project side

(Jira/Confluence), writing DWH unit-tests according customer development process, using development control system Jira for task tracking, using version control systems (CVS, GIT), code-review (Sonar) Using TeamCity, Liquibase for software release deployment Main developing technologies:

PL/SQL, unix-shell for data transformation engine and server side services; Oracle database scripts, packages, tables and etc. Oracle Exadata query performance improvement

2 of 3

Cloudstore migration and performance improvement

Year

04/2012 – 08/2020

Company

Skills

Position

Luxoft Professional LLC, Russia

PostgreSQL, Oracle, PL/SQL.

Senior Technical Expert/ Software Developer

Responsibilities

Working of Finance banking domain area at projects for strategic Luxoft customers in Russia. Taking a part in implementation of Banking system for automated processing of loan applications, Data Warehouse system implementation of financial data for consolidated analytical reporting (EinSig, IFRS 9 reporting, FOWs). Defining data store models, data placement, stored data-types for different application designs – solid/enterprise and microservice architecture. Writing migration and transformation scripts for huge data volume between databases Oracle and IBM DB2

(Windows/ z/OS ) using transactional data change model and directly load and update data (IBM Z/os) algorithm . Develop finance data adjustment (FOWs, HYPERSTAR) for internal banking report analytic Implementation data base code for payroll card processing, process of issuing for cards MasterCard/Visa, writing algorithmic code for card security information protection and attributes generations (BIN, number, CSV). Writing SQL queries and stored procedures/functions. Troubleshooting of SQL performance issues, DWH unit-tests writhing; CVS, GIT, TeamCity, Liquibase for software release deployment Main developing technologies:

PL/SQL, unix-shell; Oracle/PostreSQL/IBM DB2 database scripts, packages, tables and etc. Oracle Exadata query performance improvement

Cloud store/data-lake infrastructure migration and performance improvement Financial EU-audit standards IFRS9, OATS, EinSig

Year

Company

Skills

Position

04/2018– 05/2019

PAO Rostelecom, Russia

Hadoop(Hive), GreenPlum, Oracle

Data model architect / Team Lead

Responsibilities

Worked on the key elements of the development strategy of the biggest Russian national telecommunication company. Participation in creation of a unified marketing information system (corporative data warehouse) using open source technologies. Architecture of data warehouse layers (Hadoop, GreenPlum, Oracle) - ODS, DDS, ADS Analysis and arrange requirements. Defining data transformation streams, defining data store models, data placement, stored data-types (MDM glossary). Writing SQL for stored functions and data base objects.

Main developing technologies:

PL/SQL, Oracle, GreenPlum, Hadoop (Hive) database scripts, packages, tables and etc. Data-lake store performance improvement

Data reporting for Business Intelligence solutions, Tableau, SAP HANA integration Year 08/2011 - 06/2012

Company

Skills

Position

GlowByte Consulting, Russia

Informatica PC, Oracle, MS-SQL

Senior consultant/ ETL-developer

Responsibilities

ETL processes and workflow development of Data Warehouses at the banking sector. Data cleansing/conversion from payment processing (WAY4) and retail banking systems to corporate warehouses with using Informatica PC.

3 of 3

Year 03/2004 - 08/2011

Company

Skills

Position

OOO “Temp Auto K”, Russia - automobile market distributor Oracle DB, Oracle Forms, Oracle Report

Senior Software developer

Responsibilities

Software development and application designing, business logic design, database design and work Integration with others systems : bookkeeping and International documents circulation systems for brands KIA, Hyundai, Ford, Citroen, GA. import -export data. The adaptation of server part software for Oracle 10g RAC. Creating the tracking subsystem of supplies and booking; the subsystem of flexible payroll staff considering quantity and complexity of time working bonuses & fines; CRM modules; documents store subsystem.

Creating of time-management system for automobile service stations with labor time standards support of service dictionary for brands KIA, Hyundai, Ford, Daewoo, Citroen, GAZ etc. and also real-time reproducing all working processes on client automobile.

Main developing technologies:

Data base design : Oracle Designer

UI & reporting development - Oracle Forms/Reports 6i, Java JSP, Oracle OWA Data transformation development: Oracle loader, SQL, PL/SQL; XML, XLS, DBF, CSV; OWA, JSP, Java servlets

TECHNOLOGIES USED

Languages:

Data Formats:

Databases:

Tools: aaaaaaaaaaaaa

bbbb

Repositories:

Operating Systems:

SQL, PL/SQL, TR/SQL, SQL PL, Java, JSP, XSLT

HTML, XML, JSON.

Oracle, Microsoft SQL, PostreSQL, GreenPlum, MongoDB, Hadoop, Essbase, SAP Sybase Power Designer, Oracle Designer, Oracle Forms, Oracle Reports, Oracle SQL Developer, JIRA, Confluence, TeamCity, Liquibase, Bugzilla. GIT, GitLab, SVN, GitHub. Solar

Microsoft Windows, Unix, Linux.

EDUCATION

1996 - 2002 Tomsk State University of Control Systems and Radioelectronics Software of computer engineering and automated systems CERTIFICATIONS

2011

2009

zzzzzzzzzzzzzzzzzzzzzz

2008

2008

2006

Oracle Database 11g: Advanced PL/SQL (Oracle Certified Professional) Oracle ISV Days "Software Development Methodology" Software Development Life Cycle (SDLC)

Oracle course "Real Application Clusters for developers" Oracle Pl/SQL OCA Certified

IBM Certified Database Associate (DB2 Universal Database V8.1 Family)

Contact this candidate