Работа в Европе |Европейская трудовая биржа
€2 500.00 В месяц
Опыт работы от 7 до 10 лет
* Around 7 years of experience in Application Development using Oracle SQL, PL/SQL and Oracle Application Express (APEX);
* Working well independently or as part of a team. Able to interact with people at all levels. Good communication and presentation skills;
* Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL;
* Proficiency in analysis, design, development, testing, implementation and maintenance of applications in client/server configurations;
* Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning;
* Experience in using several built-in database packages such as DBMS_JOB, DBMS_OUTPUT, UTL_FILE, DBMS_SCHEDULER, and DBMS_SQL to name a few;
* 2+ years of experience in design and deployment of Unix shell scripts;
* Around 1,5 yrs of strong ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter;
* Experience in writing Technical design documents and developing unit test documents;
* Ability to learn and adapt to new challenges. Detail oriented, with strong analytical and creative skills.
Certificates and courses:
* Systems development life cycle, internal course by GE Money Bank Russia, 2013, no certificate
* Oracle Advanced PL/SQL Developer Certified Professional (received 08.05.2018, no expiration): https://www.youracclaim.com/badges/635f4cbd-efad-453f-90a1-77a1a964f886/public_u rl
* Machine Learning course by Coursera (received 03.06.2018, license CWRRSEF3LAQH): https://www.coursera.org/account/accomplishments/certificate/CWRRSEF3LAQH
* Operating Systems: Windows, Unix/Linux (Suse, RedHat, AIX);
* DBMS: Oracle11g/12c (more than 10 TB space utilized), Microsoft SQL Server, PL/SQL Developer, SQLPlus, Toad;
* Methodologies: Scrum, Agile;
* Application Servers: Apache Tomcat, WebLogic, Oracle HTTP Server;
* Business analytics systems: SAP Business Objects, Qlik View/Sense, Power BI, Microsoft Analysis Services;
* Internet Technologies: JavaServer Pages, HTML, JSON, Web Services, REST, WebSockets;
* Technical documentation writing skills: User Manuals Writing, Developer Manual Writing, Analytics Writing, Performance Testing, Test Plans and Test Cases;
* Others: IntelliJ IDEA, Eclipse, Maven, TFS, JIRA, Git, SOAP, XML, JavaDOM, Delphi, Sybase PowerDesigner, Informatica PowerCenter.
Опыт работы подробно
Global Delivery Centre (GDC), RussiaSoftware and Solution Developer, апрель 01, 2016 — сейчас
ICL KME CSSenior Oracle database developer, Team leader, октябрь 01, 2014 — март 31, 2016
Responsibilities: * Managing of PL/SQL developers team: providing regular project level updates to stakeholders and ensure all developers stay on track toward delivering solid work on time; Oracle PL/SQL best practices implementation for team members; * Implementation of complex distributed ORM-system for the Government customer: developing Oracle PL/SQL stored procedures, functions, packages, triggers, complex types, SQL scripts; * Integration with third-party data sources of different Government Depts using encrypted communication channels. Key achievements: * Kernel of ORM-system was redesigned: all the logic was relocated from client side to database level - performance of the system was increased significantly; support for different time zones was added; security sub-system was upgraded by using RBAC-based authorization; * New modules were developed: performance testing module - simulation of simultaneous work of thousands of users to find out bottlenecks in the system; new releases deployment module (Edition-Based Redefinition as a core technology); universal module that allows to add new data sources through a graphical user interface.
Renaissance LifeOracle database, forms and BI developer, сентябрь 01, 2013 — сентябрь 30, 2014
Responsibilities: * Doing job cross-functionally with other team members: product owner, analysts team, testers, and customer support; * Optimization of existing processes and new functionality development for Borlas Insurance ERP System; * Integration of ERP system with third-party sources via JSON and XML; * Project activities to support the changes in business processes of the system. Key achievements: * New modules were developed (Oracle Forms 11.1.2): insurance products testing module, CRM module for the call center, CSV-files universal loader, barcode recognition module, B2B contracts maintenance module.
GE Money Bank RussiaTechnical Specialist 3rd Line Support, Data warehouse Analyst, декабрь 01, 2011 — август 31, 2013
Responsibilities: * 3rd line support of the data warehouse solution (Oracle DB 11g + SAP BusinessObjects XI + Informatica PowerCenter 9.1): solving technical incidents related to the data transfer, data marts and reporting; performance tuning mostly on ETL (mappings optimization) and data marts (SQL queries optimization, analyzing and computing table statistics) layers; business users support (business data correction, complex ad-hoc queries development using Oracle Analytic functions); * Data warehouse improvement: new releases deployment; disaster recovery site design and implementation; information lifecycle management project involvement - designed and implemented solutions to archive and purge data; * New data warehouse development: collecting and managing of business requirements; logical and physical data model design; coordinating tasks of analysts, developers and testing team; technical and users guides preparation. Key achievements: * Duration of the data marts processing was reduced from 12 hours to 5 hours; * LDAP-based authentication scheme for the APEX applications was introduced - users were able to use their domain password to access the applications; * New sub-modules were developed (Oracle APEX): routine-procedures automation module and notification module (by SMS and Email) - the overload of DWH support engineer was significantly reduced; * New data warehouse based on existing core was developed for the Sales and Risks departments (data transfer layer and data marts only) - manual routine job was automated, old disparate systems were replaced by a single repository; decision-making process improved.
LLC SibureauSenior IT-Specialist, август 01, 2009 — ноябрь 30, 2011
Key achievements: * Software developing (billing system in combination with a certified data collector) for the purposes of work processes automation for the telecommunications company (Borland Delphi 7 + MS SQL Server 2008).
Kazan National Research Technological Iniversity, Area of Study/Major: Automated information processing systemsДата окончания: июнь 30, 2007
Диплом: Bachelor's degree, Diploma with Honors
Coursera, Machine LearningДата окончания: июнь 03, 2018
Oracle, Oracle Advanced PL/SQL Developer Certified ProfessionalДата окончания: май 08, 2018
Диплом: https://www.youracclaim.com/badges/635f4cbd-efad-453f-90a1- 77a1a964f886/public_url
GE Money Bank Russia, Systems development life cycleДата окончания: июль 01, 2013
Диплом: internal course, no certificate
Вам понравилась эта страница?
Вы хотите поделиться страницей со своими друзьями?