| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate1 of 3Candidate's Name
NC, Street Address USATel.: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEPROFILE 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 EXPERIENCEYear08/2020 09/2024CompanySkillsPositionLuxoft USA (DXC group), USAGoogle Cloud DWH, Oracle, PL/SQL.Senior Technical Expert/ Software DeveloperResponsibilitiesWorking 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 improvement2 of 3Cloudstore migration and performance improvementYear04/2012 08/2020CompanySkillsPositionLuxoft Professional LLC, RussiaPostgreSQL, Oracle, PL/SQL.Senior Technical Expert/ Software DeveloperResponsibilitiesWorking 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 improvementCloud store/data-lake infrastructure migration and performance improvement Financial EU-audit standards IFRS9, OATS, EinSigYearCompanySkillsPosition04/2018 05/2019PAO Rostelecom, RussiaHadoop(Hive), GreenPlum, OracleData model architect / Team LeadResponsibilitiesWorked 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 improvementData reporting for Business Intelligence solutions, Tableau, SAP HANA integration Year 08/2011 - 06/2012CompanySkillsPositionGlowByte Consulting, RussiaInformatica PC, Oracle, MS-SQLSenior consultant/ ETL-developerResponsibilitiesETL 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 3Year 03/2004 - 08/2011CompanySkillsPositionOOO Temp Auto K, Russia - automobile market distributor Oracle DB, Oracle Forms, Oracle ReportSenior Software developerResponsibilitiesSoftware 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 DesignerUI & 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 servletsTECHNOLOGIES USEDLanguages:Data Formats:Databases:Tools: aaaaaaaaaaaaabbbbRepositories:Operating Systems:SQL, PL/SQL, TR/SQL, SQL PL, Java, JSP, XSLTHTML, 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. SolarMicrosoft Windows, Unix, Linux.EDUCATION1996 - 2002 Tomsk State University of Control Systems and Radioelectronics Software of computer engineering and automated systems CERTIFICATIONS20112009zzzzzzzzzzzzzzzzzzzzzz200820082006Oracle 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 CertifiedIBM Certified Database Associate (DB2 Universal Database V8.1 Family) |
