PERSONAL INFORMATION
BAKHYTBEK AKHMETOV
Senior Software Engineer
*** * **** ******, *** York, 10017, US
*********.********@*****.***
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