PERSONAL INFORMATION

BAKHYTBEK AKHMETOV

Senior Software Engineer

*** * **** ******, *** York, 10017, US

+1-646-***-****

adk5m3@r.postjobfree.com

skype: bakhitbek1980

Sex: Male DOB: 06/22/1980

SUMMARY

Experience in developing on: Oracle (PL/SQL, SQL, OeBS (OAF/ADF, Forms, XML/BI Publisher), Apex, OLAP DML) — 12 years, Borland Delphi - 10 years, Java, VB Script;

Experience in working with ERP tools: Oracle E-Business Suite (4 years);

Experience in working with ETL tools: SAP Data Services (5 years), IBM DataStage, Talend Open Studio, Informatica PowerCenter, Microsoft SSIS, Oracle Data Integrator;

Experience in working with BI tools: SAP BusinessObjects (8 years);

Experience in working with RDBMS: Oracle, SQL Server, Vertica, Teradata, Firebird;

Experience in working with CASE tools: ErWin, SQL Developer Data Modeler, PowerDesigner, Rational ClearCase, Rational ClearQuest, SVN, CVS, GIT;

Experience in working with server OS: Windows NT, Oracle Linux;

Ability to complete all assigned tasks fully and in a timely manner. Ability to fully integrate and communicate with other employees involved in project development. Fast learner. Mathematical mindset (winner if several regional math contests). Always determined to succeed.

Skills and Awards:

Business Intelligence: IBM: IBM DataStage;

Business Intelligence: Integration& ETL: MS SSIS;

Business Intelligence: Oracle: Oracle Data Integrator (ODI);

Business Intelligence: OLAP Software: Oracle OLAP;

Business Intelligence: DB Performance: Oracle Partitioning;

Business Intelligence: Oracle: Oracle RDBMS, Oracle Warehouse Builder (OWB);

Business Intelligence: Informatica: PowerCenter;

Business Intelligence: SAP: SAP Business Objects (BO);

Certificates: Oracle Forms Developer 10g;

Cloud & DevOps: ITIL: ITIL V3 Foundation Certificate in IT Service Management;

Content management: Platforms: XMLPublisher;

Enterprise Applications: SAP-NW-BI: Business Intelligence: ETL - BO Data Services, Reporting - BEx (SAP BW 7.x);

Enterprise Applications: Oracle: Oracle E-Business Suite;

Java: JEE Frameworks: Oracle Application Framework (OAF);

Java: Integrated Development Environments: Oracle JDeveloper;

Microsoft Technologies: RDBMS: Microsoft SQL Server;

Microsoft Technologies: Scripting Languages: VBScript;

Software Configuration Management: Version Control Systems: CVS, TortoiseSVN;

Software Construction: Other: Borland Delphi;

Software Construction: SQL Databases: Firebird, Teradata Database;

Software Construction: Oracle: Oracle;

Software Construction: Integrated Development Environments: Oracle Application Express (Oracle APEX), Oracle Developer, PL/SQL Developer;

Software Construction: Construction Languages: PL/SQL;

Software Construction: Integration Software: Talend Data Integration, Talend MDM;

Software Design: Software Design Tools: ERwin.

WORK EXPERIENCE

May-2017 - Mar-2021 - Senior Software Engineer, EPAM Systems, http://www.epam.com

Customer: One Call Care Management https://onecallcm.com/

Project: Oracle e-Business Suite development

Team Size: Dev Team: 8, QA Team: 3, BA Team: 3

Project Role: Key developer

Tasks performed:

Designing and developing Self–Service Applications using OA Framework (OAF), JDeveloper 10g/11g & Java & JS.

Designing and developing solutions to integrate Oracle EBS Suite with third party systems like ECHO Payment system, Collector Tool, AR Dashboard, CSRD system, EDI system and etc.

Oracle (Database and EBS Suite) performance tuning and optimization

Designing and developing web services to enable interactions between legacy systems and Oracle EBS Suite to facilitate real time syncing of Price Catalog, Customers, Customer Sites, Addresses and etc.

Designing and developing Oracle Forms and Reports using Forms Designer, XML/BI Publisher.

Environment:

Oracle Database 12.2 (2 node Exadata)

Oracle JDeveloper (OAF/ADF Frameworks), Oracle Forms Builder, Oracle Reports Builder, Oracle XML Publisher, SVN, GIT, FlexDeploy, PL/SQL Developer,

Oracle SQL, Oracle PL/SQL, Oracle JTF/JTT, Oracle OAF/ADF, Oracle Forms, Java 1.7, Java Script

Nov-2012 - Oct-2016 - Senior Software Engineer, Venicecom.KZ LLC

Customer: NCOC NV

Project: Developing and maintaining the Enterprise data warehause for Assets company, a single Operator under the North Caspian Sea Production Sharing Agreement.

Team Size: 1 PM, 4 developers, 2 testers

Project Role: Key developer

Tasks performed:

Migrated ETL jobs from Microsoft SSIS/MS SQL Server to SAP Data Services/RDBMS Oracle

Created ETL jobs on SAP Data Services

Developed on Oracle PL/SQL, SQL (packages, types, triggers, tables, indexes, views, snapshots)

Created BusinessObjects universes (*.unv - Universe Designer, *.unx - Information Design Tool)

Created BusinessObjects dashboards/reports/publications (BO Web Intelligence, BO Dashboards, BO Live Office) based on DW DataMart’s data

Created BusinessObjects reports based on live data (SAP ERP data through SAP JCo connection, SAP BW data through BICS connection)

Administered SAP BusinessObjects, SAP Data Services, Oracle RDBMS

Environment:

Oracle RDBMS, Microsoft SQL Server

SAP BusinessObjects 4.x • BO Desktop Intelligence • BO Web Intelligence • BO Universe Designer • BO Information Design Tool • BO Dashboards (Xcelsius) • BO Live Office SAP Data Services 4.x SAP BW BEx Query Designer 7.x PL/SQL Developer, TOAD for Oracle, Microsoft SSIS, SVN

ETL, DW/BI, Data Modeling, DBMS Engineering, Version Controlling

Aug-2011 - Nov-2012 - Senior Software Engineer, Venicecom.KZ LLC

Customer: Agip KCO

Project: Developing and maintaining of Agip KCO BI System (Enterprise data warehouse)

Team Size: 1 PM, 4 developers, 2 testers

Project Role: Key developer

Tasks performed:

Migrated RDBMS from Oracle 9.2 (File System, RAID 5) to Oracle 11.2 (ASM, RAID 1+0)

Migrated BI platform from SAP BusinessObjects 3.1 to SAP Business Objects 4.1

Migrated ETL platform from BO Data Integrator to SAP Data Services 4.1

Developed on Oracle PL/SQL, SQL (packages, types, triggers, tables, indexes, views, snapshots)

Created ETL jobs on SAP Data Services

Created BI reports/dashboards/publications on BusinessObjects (BO Web Intelligence, BO Dashboards, BO Live Office)

Administered SAP BusinessObjects, SAP Data Services, Oracle RDBMS

Environment:

Oracle RDBMS

SAP BusinessObjects 4.x • BO Desktop Intelligence • BO Web Intelligence • BO Universe Designer • BO Information Design Tool • BO Dashboards (Xcelsius) • BO Live Office SAP Data Services 4.x PL/SQL Developer, TOAD for Oracle, SVN

ETL, DW/BI, Data Modeling, DBMS Engineering, Version Controlling

Jun-2008 - Aug-2011 - Software Engineer, Realsoft LLC

Customer: JSC Kazakhtelecom

Project: Developing and maintaining of Information-Analytical Decision Support System (DW/BI system)

Team Size: 1 PM, 4 developers, 3 testers

Project Role: Key developer

Tasks performed:

Created E-R diagrams (logical and physical data models)

Created/maintained/optimized ETL jobs

Created/maintained/optimized Oracle database objects (packages, types, tables, indexes, views, triggers, sequences, materialized views (for datamarts))

Created BusinessObjects (XI R2, XI R3) dashboards/reports/publications

Environment:

Oracle RDBMS

IBM DataStage, SAP BusinessObjects, SAP XCelsius, ERwin, PL/SQL Developer, SVN, Rational ClearQuest, Microsoft Project

ETL, DW/BI, Data Modeling, Bug Tracking, Version Controlling

Mar-2002 - Sep-2007 - Software Engineer, Realsoft LLC

Customer: JSC Kazakhtelecom

Project: BiTTL v1.3 and v1.3.5 billing system

Team Size: 1 PM, 15 developers, 3 testers

Project Role: Key developer

Tasks performed:

There are more than 10 applications in the BiTTL billing system. I was a key developer of two of them: TManager (Tariff Plan Manager, MDM application) and MonRep (Monitoring and Reporting application).

Environment:

Oracle RDBMS

Borland Delphi, PL/SQL Developer, ErWin, Rational Rose, Rational ClearQuest, Rational ClearCase, PVCS version manager, Microsoft Project

Object-oriented programming, Data Modeling, Business Process Modeling, RAD (Rapid Application Development), Bug Tracking, Version Controlling

EDUCATION

Name of the Education Establishment: Kazakh National Technical University

Faculty/College: Institute of information and telecommunication technologies

Degree (diploma): Specialist

Specialty: Computing and Software

Contact this candidate