Intelligence Consultant Warehouse Developer

Farrokh Zibakhsh Shabgahi

SENiOR DATA WAREHOUSE DEVELOPER · BUSiNESS INTELLiGENCE CONSULTANT · DATABASE ADMiNiSTRATOR

+98-912-***-**** *******.********@*****.*** farokh-zibakhsh-shabgahi-7526634b Summary

28 years of experience in the chain store, tele communication in many roles such as designer, programmer and damaged database recoverer. Extensive experience of leading developers in a team. Supporting implemented BI solutions by tuning queries and data loads in MTN IRANCEL. As a person outgoing, Reliable and responsible and easy to work with. Furthermore, I am analytical with attention to detail and have the ability to detect anomalies and lack of reasoning.

Education

University of Tehran Tehran, Iran

B.S. iN AGRiCULTURE ENGiNEERiNG 1988 1992

Skills

Programming PL/SQL (Pro), Spark (Intermediate), Python (Intermediate), Hadoop (Intermediate), Java (Intermediate), Shell Script (Pro) Technologies Big Data, Performance Tuning, Database Administration, APEX, Oracle Business Intelligence Databases Oracle (Pro), MongoDB (Beginner),

Business Telecom features and Petrochemical, Chain stores knowledge requirements. Operating Systems Linux(Ubuntu), Microsoft Windows Experience

Behpardaz Hamrah Sameneh Aval (BEHSA) Vanak, Tehran, Iran ORACLE DATABASE ADMiNiSTRATOR Feb 2017 Present

• Performance tuning of developers’ code and validating results with business representatives.

• Assist programming personnel and operations personnel with technical problems and their resolution. SAEI Co. (MTN Irancell Vendor) Tehran, Iran

SENiOR DATA WAREHOUSE DEVELOPER AND BUSiNESS INTELLiGENCE CONSULTANT Feb 2011 Feb 2017

• Assist programming personnel and operations personnel with technical problems and their resolution.

• Creating Star schema data models, performing ETLs and validating results with business representatives.

• Supporting implemented BI solution by tuning queries and data loads, addressing user questions concerning data integrity.

• Turn data marts into robust data warehouse own and build from ground up, a data infrastructure including end to end data flow and storage.

• Provide support as required by the Disaster Recovery Plan.

• Highly motivated Business Intelligence professional with experience of report development and analysis.

• Create Number of cubes, dimensions and business critical KPIs using Oracle data warehouse . Shazand Arak Petrochemical Co.

ORACLE DATABASE ADMiNiSTRATOR Mar 2010 Ongoing as Part time

• Configure and install WebLogic as a basement of installation of the oracle data grid to be able to manage other databases on separate servers.

• Maintain and support petrochemical databasemanagementsysteminaccordancewithuserrequirementsensuringoptimaldatabaseintegrity.

• Security of application with entrance of every user with own accessibility in different options tracking barcode system.

• Involve and use the ability of auditing features of oracle to trace just someone in suspicious mode. Iran Data System Co. (MTN Irancell Vendor)

ORACLE DATABASE ADMiNiSTRATOR Sep 2009 Jan 2011

• Maintain and support database management system in accordance with user requirements ensuring optimal database integrity.

• Determine the cause of database problems, arrive at solution and implement appropriate actions to correct.

• Install Oracle database software, upgrades, or new releases, utility software, and program temporaryfixes, in amannerthatwillnotcausemajor disruptions to the production environment.

• Configure and install WebLogic as a basement of installation of the oracle data grid to be able to manage other databases on separate servers.

• Involve and use the ability of auditing features of oracle to trace just someone in suspicious mode. FEBRUARY 16, 2023 FARROKH ZiBAKHSH SHABGAHi · RÉSUMÉ 1 SISTAS Co.

ORACLE DATABASE ADMiNiSTRATOR Feb 2006 Sep 2009

• Maintain and support database management system in accordance with user requirements ensuring optimal database integrity.

• Assist programming personnel and operations personnel with technical problems and their resolution.

• Maintain and use appropriate technical manuals and documentation for the computer hardware and software installed at Information Services.

• Write, debug test and document any specialized queryprograms.

• Write SQL stored procedures, functions, triggers.

• Create backup and restore strategy, test disaster recovery scenarios and backup integrity.

• Carry out performance tuning of SQL statements and database performance. Diagnosis locking/blocking issues and pro actively alert. Shahr Pardaz Co.

ORACLE DATABASE ADMiNiSTRATOR Mar 2004 Sep 2005

• Maintain and support database management system in accordance with user requirements ensuring optimal database integrity.

• Determine the cause of database problems, arrive at solution and implement appropriate actions to correct.

• Install database software, upgrades, or new releases, utility software, and program temporary fixes, in a manner that will not cause major dis ruptions to the production environment.

• Assist programming personnel and operations personnel with technical problems and their resolution.

• Maintain and use appropriate technical manuals and documentation for the computer hardware and software installed at Information Services. Maintain current information on recent trends of computer hardware and software.

• Write, debug test and document any specialized queryprograms.

• Maintain professional relationships with vendors, outside consultants, other parties and peers to facilitate a productive dialogue relative to the success of the services provided.

• Write SQL stored procedures, functions, triggers.

• Create backup and restore strategy, test disaster recovery scenarios and backup integrity.

• Carry out performance tuning of SQL statements and database performance. Diagnosis locking/blocking issues and pro actively alert. Yaran Shop

ORACLE DATABASE ADMiNiSTRATOR May 2002 Mar 2003

• Maintain and support database management system in accordance with user requirements ensuring optimal database integrity.

• Determine the cause of database problems, arrive at solution and implement appropriate actions to correct.

• Write, debug test and document any specialized queryprograms. SANA Co.

ORACLE DATABASE ADMiNiSTRATOR Sep 2000 Apr 2002

• Developing and designing the database strategy for example consideration of internal controls like foreign keys and primary keys.

• Maintain and support database management system in accordance with user requirements ensuring optimal database integrity.

• Monitoring and improving database performance and capacity. Shahrvand Chain Store

ORACLE DATABASE ADMiNiSTRATOR Sep 1995 Jan 2001

• Maintain and support database management system in accordance with user requirements ensuring optimal database integrity.

• Determine the cause of database problems, arrive at solution and implement appropriate actions to correct.

• Teaching Oracle PL/SQL and OCA course

Courses & Certifications

2008 Workshop 1 in Oracle Administration, OCA Oracle Certificate Assistance. 2008 Workshop 2 in Oracle Administration, OCA Oracle Certificate Assistance 2008 Oracle Performance,

1997 Introduction to Oracle SQL*Plus and PL/SQL,

1997 Oracle Forms, version 4

1997 Oracle Reports, version 4

Teaching

Shahrvand Chain Store

ORACLE PL/SQL AND OCA COURSE 1999 2001

• Teaching Oracle PL/SQL and OCA course.

SAEI Co.(MTN Irancell Vendor)

ORACLE PL/SQL AND OCA COURSE 1999 2001

• Teaching Oracle PL/SQL and OCA course.

FEBRUARY 16, 2023 FARROKH ZiBAKHSH SHABGAHi · RÉSUMÉ 2

Contact this candidate