Martin Dudumi

Martin Dudumi

$25/hr
Senior Data Analyst
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
39 years old
Location:
Tirana, Albania, Albania
Experience:
14 years
MARTIN DUDUMI Highly skilled and accomplished data expert with over 14 years of experience in database creation, analysis tools development, and strategic decision-making. Proven track record of success, including playing a pivotal role in increasing production from 5000 to 20000 barrels of oil per day (bopd). Recognized as an expert witness in two successful arbitration cases. With a solid foundation in database management and analytics, I am a results-driven professional committed to delivering excellence in every project. I am seeking opportunities that allow me to leverage my expertise in data management, analytics, and strategic decision-making to drive business growth and innovation. I am eager to collaborate with like-minded professionals in dynamic environments where creativity and excellence are valued, and where I can continue to learn, grow, and make a positive impact. Personal Address Rr. Ali Demi, Kompleksi Mangalem, Hyrja 20, Ap- Tirane Phone number - Email-Date of birth- Place of birth Erseke Gender Male Nationality Albanian Marital status Married Driving license B LinkedIn https://www.linkedin.com/in/martindudumi-80550b65/ Interests Playing Guitar, Playing Soccer, Swimming, Creating Poetry Work experience Data Management and O/G Consultant Bankers Petroleum Albania Ltd., Tirana 1. Creating Descriptive analytics to summarize and describe the Companyʼs data using more advanced techniques like SQL Queries, Advanced Excel using VBA, Programming languages like Python and Visual Basic, and Power BI; 2. Performing Diagnostic analytics to identify trends, patterns, and anomalies and also Predictive analytics to forecast future trends based on historical data. 3. Creating visually appealing and informative charts, graphs, and dashboards; Interactive visualizations for better user engagement and understanding. 4. Ensuring data quality by cleaning and preprocessing raw data and handling missing values, outliers, and inconsistencies. 5. Helping the Company define the data strategy and goals, developing a roadmap for implementing data‑driven decision‑making processes. 6. Assisting with establishing policies and procedures for data management; Ensuring compliance with data privacy regulations. 7. Providing training sessions on data analysis tools and techniques and Conducting workshops to enhance data literacy within the organization. 8. Designing and implementing reporting systems for regular updates; Business intelligence solutions for data‑driven decision‑making; Support on getting weekly/monthly/quarterly/annual reports regarding Crude Oil, Diesel, Custom, Electricity, Propane, Diluent and Finance, Supply Chain, HSSE, HR; CAPEX and OPEX Transactions Validation; ‑ Support on Database Issues. Support on Data Management Issues; Support on Legal and Audit Cases; Support on Responding to Letters to the Government Authorities. Support on the Arbitration cases; Support on Historical data and Historical overview of processes. Senior Data Analyst Languages English Italian French Spanish German Feb 2024 - Present Freelancer.com, Tirana Jul 2019 - Present 1. With more than 60 Projects with a 5‑star review on all of them, you can find the profile and the reviews from several employees at https://www.freelancer.com/u/MartinDudumi. 2. Building Databases ‑ Automating Processes (Power BI, WordPress, Python, Excel, VBA, Word, Access, SQL) 3. Fixing Bugs ‑ Performing Data Analysis, Processing, Mining, Performing QA & QC 4. Creating Complex Queries Apply difficult formulas and functions etc. Virtual Assistance and Remote Analysis of Data External Lecturer Polytechnic University of Tirana, Tirana Apr 2014 - Present 1. Giving lessons to students of the Geology and Mining Faculty for a specific period of the year and mentoring the students on their diploma 2. Creating the proper communication between oil companies and the university Partnership on Job fairs Data Manager Bankers Petroleum Albania Ltd., Tirana Apr 2017 - Feb 2024 1. Creating the correct environment to manage the corporate data sets to ensure accuracy, integrity, and security as formulating techniques and algorithms SQL/Python based for quality data collection to ensure adequacy, accuracy, and legitimacy of data is one key skill. 2. Development of new gathering systems and visualizations for HR, Production, HSSE, Chemicals Supply Chain, and HSSE. using SQL Server, My SQL, Power BI, Advanced Excel, SQL, Visual Studio, and Python. 3. Because of the Big Data environment, the goal was always to implement efficient and secure procedures for data handling and analysis. 4. Enhancing the timing of reports, data extraction, database maintenance, and troubleshooting data problems was one critical milestone and I achieved that by reducing the time of these procedures in our corporation by more than 50%. 5. Developing and implementing databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality for all corporate teams was part of the daily routine and from an organization chart perspective supporting and instructing subordinate members of the Data Management team was always as a target. 6. Responding to legal Issues related to data, especially in government‑related issues. Part of the expert panel for arbitration court cases. 7. QA/QC of Proper Databases, and ETL Techniques, building proper ERD and DFD, and Creating Proper Data Marts for our DWH. 8. Financial Transaction Data Validation and Data Cleansing Achievements: a. 2023 CEO award for best employee b. Create standalone Software for official data records called ODR. c. Win the technical part of the arbitration case in April 2023 d. Finalizing standalone Software with front end done on Visual Studio and back end SSMS called Well Serv which was intended to analyze and collect information for well servicing. e. Saving more than 5 million $/year on financial errors, mismatches, miscalculations, validation data, decision‑making, legal cases won, and other related BI decisions. f. Creating hundreds of dashboards that help with BI decisions. Production Engineer Sherwood International Ltd., Kucove Sep 2021 - Feb 2024 1. Assist engineering and other personnel in solving operating problems. 2. Confer with scientific, engineering, and technical personnel to resolve design, research, and testing problems, 3. Direct and monitor the completion and evaluation of wells, well testing, or well surveys, 4. Monitor production rates, and plan rework processes to improve production. 5. Also analyze data to recommend placement of wells and supplementary processes to enhance production. 6. Interpret drilling and production rates, and plan rework processes to improve production. 7. Analyze data to recommend placement of wells and supplementary processes to enhance prod testing information for personnel. Write technical reports for engineering and management personnel. 8. Create AFEs through AFE Navigator. 9. Assess costs and estimate the production capabilities and economic value of oil and gas wells, to evaluate the economic viability of potential drilling sites. 10. Maintain records of drilling and production operations and use of main software for production and operation OFM, Prod view, Avocet Field view, SCADA, Echo meter, etc. 11. Take samples to assess the amount and quality of oil, the depth at which resources lie, and the equipment needed to properly extract them. 12. Inspect oil and gas wells to determine that installations are completed. Coordinate activities of workers engaged in research, planning, and development. 13. Coordinate and resolve issues with government authorities. Data Analyst Bankers Petroleum Albania Ltd., Tirana Jun 2012 - Apr 2024 1. Manipulating, cleansing & processing data using Power BI, Excel, Access, Visual Basic, and SQL, giving answers through querying and programming for every given question. 2. Because there was a lack of data‑collecting systems the role was focused also on developing data analytical databases, like the HR Database, HSSE Database, LAB Database, Well Serv Database, and Software, etc. 3. Performing daily, weekly, and monthly data checks and preparing Monthly, Weekly, and Daily Reports were always my top priorities but designing, developing, and implementing new functionality and carrying out specified data processing and statistical techniques were some of the skills that were always supplying qualitative and quantitative data to colleagues, especially to the engineering team. 4. Another key part of the role was to analyze the given data for further development on various criteria /filters depending upon the type of data to be analyzed and also make Data validation on the financial transactions, checking the AFE, the cost split CAPEX/OPEX, the Balance Usage/Supply and inventories, etc. When needed prepared forecast reports using hyperbolic and exponential curve lines and my goal was always to design programs. Achievements: a. Win of the 2013‑2017 arbitration case with more than 57 million $ cost b. Creation of the first DWH in place connecting 9 databases in a full Data Model c. Implementing Prod View System and upgrading from Avocet Schlumberger. Data Collection and Analysis Systems d. More than 10 million $ saved per year through validation data, decision‑making, legal cases won, and other related BI decisions. Production and Reservoir Engineer Bankers Petroleum Albania Ltd., Fier Jun 2010 - Jun 2012 1. Assist engineering and other personnel in solving operating problems. 2. Confer with scientific, engineering, and technical personnel to resolve design, research, and testing problems, 3. Direct and monitor the completion and evaluation of wells, well testing, or well surveys, 4. Monitor production rates, and plan rework processes to improve production. 5. Also analyze data to recommend placement of wells and supplementary processes to enhance production. 6. Interpret drilling and production rates, and plan rework processes to improve production. 7. Analyze data to recommend placement of wells and supplementary processes to enhance prod testing information for personnel. Write technical reports for engineering and management personnel. 8. Create AFEs through AFE Navigator. 9. Assess costs and estimate the production capabilities and economic value of oil and gas wells, to evaluate the economic viability of potential drilling sites. 10. Maintain records of drilling and production operations and use of main software for production and operation OFM, Prod view, Avocet Field view, SCADA, Echo meter, etc. 11. Specify and supervise well modification and stimulation programs to maximize oil and gas recovery. 12. Simulate reservoir performance for different recovery techniques, using computer models. 13. Take samples to assess the amount and quality of oil, the depth at which resources lie, and the equipment needed to properly extract them. 14. Inspect oil and gas wells to determine that installations are completed. Coordinate activities of workers engaged in research, planning, and development. IT Help Desk Tobacco Holding Group, Tirana May 2009 - Jun 2010 1. Provide help desk support and resolve problems to the end userʼs satisfaction, 2. Monitor and respond quickly and effectively to requests received through the IT help desk Monitor the Service Desk for tickets assigned to the queue and process first-in first-out based on priority, 3. Modify configurations, utilities, software default settings, etc. for the local workstation, 4. Document internal procedures and assist with onboarding of new users. 5. Ensure each workstation has a computer, monitor, keyboard, mouse, hard drive, and any additional specialized equipment, 6. Install, test, and configure new workstations, peripheral equipment and software, 7. Maintain inventory of all equipment, software, and software licenses 8. Report issues to the Service Desk for escalation, 9. Manage PC setup and deployment for new employees using standard hardware, images, and software, 10. Assign users and computers to proper groups in Active Directory, 11. Perform timely workstation hardware and software upgrades. Education and Qualifications M.Sc. on Water, Gas, Petroleum Engineering Polytechnic University of Tirana, Tirana Oct 2004 - Oct 2009 Degree in Water, Oil, and Gas Engineering with last average grade of 9.6 for a full 5 years and a Diploma in Infinite Elements with a grade of 10. Top student in 2007 decorated by the President of Albanian Republic and Pedrollo Inc. English Language Certificate British Council, Tirana Nov 2023 - Nov 2023 Achieved CEFR C1 in the English Score core skills test. Italian Language Certificate Universita per stranieri Perugia, Perugia 2003 - 2003 Certified on the knowledge of Italian Language References Kris Gustafsson -- Alex Hocking +44 -- Chris Thompson-- Nevton Kodhelaj -- Qing Fang -- Skills SQL MS-Excel Power BI Visual Basic C++ Python Ms-Access MS-Word Autocad MS-Power Point MS-Outlook Excel VBA Dashboards Databases Data Analysis Data Validation Data Modelling Bankers Petroleum Albania Curva Grande Bankers Petroleum Albania Ltd. Polytechnic University of Tirana Bankers Petroleum Albania Data Governance Data Management Prod View OFM Data Processing Statistics and Math Petroleum Engineering Courses Oracle SQL & PL/SQL Fundamentals Stay Ahead London Dec 2016 - Dec 2016 Writing and running PL/SQL programs from SQL*Plus or SQL Developer, Declaring and using variables and constants, Assigning and manipulating values. Project Management PMP Austrian Institute of Excellence Oct 2016 - Oct 2016 Work with project management processes. Initiate a project. Plan a project. Plan for project time management. Plan project budget, quality, and communications. Introduction to Data Management Petroskills Dec 2013 - Dec 2013 Common data management issues and challenges, and the impact on the business, The important components of a data management framework, How to map issues onto a data management framework Expanded Petroleum Economics Petroskills Jun 2013 - Jun 2013 How to evaluate the economic viability of a project, Cash flow techniques applicable in economic evaluations, Models to weigh risk and uncertainty, Techniques to determine expected value, The effect finance, budgeting, and contractual agreements have on a project, The basic principles of accounting. Forecasting oil production. Production Operations Petroskills Oct 2011 - Oct 2011 Understand key principles and parameters of well inflow and outflow, Build accurate nodal analysis models for tubing size selection and problem well review. Qualities Self‑Starter, Team Leader, Working on low supervision, Quick Learner, Problem solver, Organized, Dependable and trustworthy, flexible and open to change, Proactive and self‑driven, Honest and Ethic
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.