CV: Data engineer, Data Analyst, SQL Developer, Analyst , SQL Server Developer, Technical Support Analyst
только зарегистрированным пользователям.
Perform troubleshooting, analysis and provide resolution on Oracle DB with regressed performance or database wide performance issues on Oracle DB & a variety of other performance related issues and questions and not only like:
Database performance, Query Performance Regression, Optimizer Statistics,
Wrong Results, ORA-7445/ORA-600/ORA-4020, Blocks and Locks issues, others
Tools AWR/ASH/ADDM issues, SYSAUX space usage issues and others.
Gathering stats issues - auto and custom.
Latches/Mutex/Concurrency issues
SPM/Profiles/Baselines 10046/10053 trace files
Make use of SQLT, Hang Analyze, SSD, 10046 / 10053 trace files, AWR/ADDM/ASH for analysis of customer incidents.
Used Technologies and Tools: Oracle PL/SQL, SQL Server 2012, PostgreSQL,SQL Reporting Services, Elasticsearch, SQL Query Analyze, SQL Tuning, SQL Profiler.
Implementations of more functionalities using Oracle PL/SQL and SQL Server 2012, 2014, 2016 - procedures, functions, views, SQL queries, triggers, types, table variable and over sql objects, regarding Business specifications. Experience on Agile developing teams according to SCRUM in Sprint Development. Analyze data, process data according to certain algorithms regarding tasks specifications, improve database performance, tuning and execution time of functionalities.
Developing on Accounting Software and Accounting, Financial Reporting using SQL Server 2008 for DB, Transact SQL (DDL, DML, procedures, functions, tabular functions). Collecting and analyzing required business information, SSRS report designing, Creation of database queries (T-SQL) and reports based on MS SQL Reporting Services. SQL Reporting Services 2008.
Developing a local module in Bank Core Software - Temenos T24, using DataBase - JBase:
1. Worked in various projects of software integration (e.g. integration of electronic
channels) and developed of interfaces for T24 (Internet Banking, POS Payd).
2. Export data for external systems in different formats - ASCII, xml, OFS messages.
3. Use the Java WS Axis to integrate a lot of Temons T24 functionality and the external collection system
4. Developing on Banking and Financial Reporting
Experience in T24 template programming, T24 customization (VERSION, ENQUIRY, OFS.SOURCE parametrization, online communication), COB and multi-threads processing (SELECT routine, LOAD routine, main processing routine) . Knowledge of TAFC/jBASE, InfoBasic (jBC), jQL, OFS.
Technologies used:Temenos T24, JBase. Java, Axis WS, java programing using the T24 Java VM.
Good understanding of the following T24 Business modules - Funds Transfer, Loan and Deposits, Payment Due, Customer, Account, local modules and applications, Debit Collector, etc.
Developing the Software in house:
1. Developing interface between banking Equation and payment system utilities
2. Developing of Core Banking application import (Equation) SWIFT messages
3. Analysis and Application Development miniCRM.
4. Developing banking application filing boxes and leases
5. Develop interface check tax codes
Technologies used: Delphi 7, SQL Server 2000, API connection DB2, Web Services, XML
Developing programs in Bank - Desktop Forms regarding the inserting data in DataBase, import and export data from/to ASCII (read, write).
Technical Skills: Delphi, BD - Foxpro, Paradox
Специальность: Banking and Stock Exchanges.
Специальность: Master in Informatics.
Специальность: Applied Matemathics.
Oracle PL/SQL, SQL Server 2008/2016, JSON, Elastic Search, SQL Reporting 2008. Sprint Agile, Team spirit, coordination of work skills, attention to detail, hard working, industrious, professional guidance to achieve planned results. Planning skills to work and working time used. Multi-tasking, Oracle Database Support Engineer
I like read books, watch movies like law, historical.