Sercan Mertsöz Email & Phone Number

İstanbul, Türkiye

→ Created datawarehouse models in non relational databases. (Different ERP systems, EBa and Pratis, etc.)→ Created final report generation and visualization automations in Excel VBA, Knime, and Python.→ Developed a data analysis process business plan for SAP MM, FI, and CO modules. This involved identifying the data sources, data flows, and data processing steps required for the analysis. The plan was then approved by the stakeholders and organizational units.→ Created master data architecture for the relevant business plan in SAP server tables. This involved designing and implementing the data structures and relationships that would be used to store the data.→ Developed descriptive analysis and process model validation scripts in Python and SQL. These scripts were used to analyze the data and identify potential risks and areas for improvement.→ Automated scripts to run queries based on risk-defined periods to perform continuous audit. ETL Creation and execution.→ Purchase Order - Anomaly Detection machine Learning model creation and usage on continious monitoring process.→ Developed over 200+ validation / description scripts and 3 machine learning models in continious monitoring Used data analysis tools and languages : Python, SQL, ACL, Knime, Visual Basic, UiPath

→ Developed a data analysis process business plan for SAP MM, FI, and CO modules. This involved identifying the data sources, data flows, and data processing steps required for the analysis. The plan was then approved by the stakeholders and organizational units.→ Created master data architecture for the relevant business plan in SAP server tables. This involved designing and implementing the data structures and relationships that would be used to store the data.→ Developed descriptive analysis and process model validation scripts in Python and SQL. These scripts were used to analyze the data and identify potential risks and areas for improvement.→ Created final report generation and visualization automations in Excel VBA, Knime, and Python. These automations were used to generate reports and visualizations that could be used to communicate the findings of the analysis to stakeholders.→ Used SQL to query and analyze data in non relational databases.→ Automated scripts to run queries based on risk-defined periods to perform continuous audit.Used data analysis tools and languages : Python, SQL, Knime, Visual Basic

Istanbul, Turkey

→ Conducted contract compliance/requirements controls.→ Inspected invoices for quantity, deduction, and tax compliance.→ Compared and analyzed unit costs of similar work items.→ Evaluated planned budget and real budget, and reported deviations.→ Took an active role in financial and administrative audit.→ Semi-automated business processes developed with using SAP server tables and Microsoft Access instead of system standard transaction codes.→ Created VBA macros to automate the execution of repetitive tasks in Microsoft tools.Used data analysis tools and languages: SQL, Visual Basic, Microsoft Excel, and Microsoft Access.

Garipçe - İstanbul

( 37 culverts, 18 subways, 11 pedestrian bridges, 18 bridges, 2 tunnels. As all project 39+500 meters highway ) → Controlling projects with relative specifications before starting to build.→ Planning process during all constructing period. → Controlling progress of the each production according to project details and quality.→ Preparing progress reports and reporting progress with separating them according to item numbers in the contract. → Calculating and reporting the bill of quantities of construction field daily, weekly and monthly and submitting them as reports.

Gaziantep, Turkey

→ More than 10 projects including fabric systems, roofs, villas and cantilever building systems.→ Designing Fabric systems and roof system with using Sap2000→ Modeling each type of the steel structures and their parts with using Tekla XSteel and AutoCad programs.→ Submitting drawings as partly, montage list and general views.→ Preparing reports as total weight, part list, material list and total cost.→ Planning building schedules and visiting construction field at regular intervals to control.

Gaziantep, Turkey

→ Controlling the quality of building within all progress.→ Reporting daily and weekly progress of construction field.

Lisans Derecesi, Business Administration, Uzaktan Eğitim

Master Of Business

Bachelor'S Degree, Construction Engineer