Kamil Bartosik

Curriculum Vitae Kamil Bartosik PERSONAL INFORMATION Kamil Bartosik Strażacka 114/32, 04-455 Warsaw, Poland - -Sex male | Date of birth 26/04/1988 | Nationality Poland WORK EXPERIENCE -– Present) Eviden/Atos Client Name- Ooredoo Algieria Function: Data Engineer GCP Scope of responsibilities: • Move ETL mappings from Informatica Power Center to Airflow with Python: Analysis of existing mappings in Informatica PowerCenter, identifying their functions, dependencies and parameters. Wroted Python scripts that implemented mapping functionalities from PowerCenter in the Apache Airflow environment. Using the airflow.models library to create DAGs and airflow.operators to define individual tasks. Testing and debugging new Airflow jobs Data loaded into Azure Databricks: After processing the data with Airflow jobs, used the Azure Databricks API to load the processed data into the appropriate tables or data stores. Technologies: Pyhon, Airflow, Git Bash, MySql Server, Azure -– Present) Eviden Atos Client Name- Allianz De Function: Data Engineer GCP Scope of responsibilities: • Builded ETL pipline which can normalize the CMDB data, harmonize it, reduce the redundancy and verify the NULLs • Smooth flow of Data From Mongo DB to Postgres • Data Analysis to understand the repetition reasons and which data to keep. • Analysis of the data structure in MongoDB and identified differences in the data schema between MongoDB and PostgreSQL • Builded a Python script that will connect to the MongoDB database using pymongo, download the data, transform it to a PostgreSQL compatible format and insert it into the database using psycopg2 Technologies: PostgreSQL, Git Bash, Airflow, Jenkins, Python -) Eviden/Atos Client Name- Vodafone Germany Function: Data Engineer GCP Scope of responsibilities: • Developing process to onboard data source (transfer SFTP file, JDBC database, tpt Teradata, REST) to the Google Cloud Platform • Analyzing client requirements related to new data sources, propose solution and work closely with Data domain experts: Data scientists, Data Owners and Data Lake team. • Solving of big data and specific problems (time/load/volume) • Working with of data flows and server connectivity (databases, data flow, data structures, databases connectivity) • Programming knowledge with: Sql, Pl/Sql, Python, Linux bash scripting, HCL (basic), Json • Designing, writing, and maintaining Apache Airflow jobs that coordinate between multiple technologies. • Developing ETL/ELT solutions and automating data flows • Designing and implementing the data migration process using Apache Spark and ensuring that the data was transferred accurately and efficiently to Google BigQuery • Calling existing PL/SQL procedures and functions, efficient data processing in PL/SQL • Using cx_Oracle library in Python to invoke PL/SQL procedures, retrieve results, and transfer data to GCP Technologies: GCP, Teradata SQL, Oracle PL/SQL, MySql Server, Git Bash, Git Hub, Jenkins, NiFi, Airflow, Python, Spark -) Eviden/Atos Client Name- Copernicus Project for equensWorldline SE Germany Function: BI Developer Scope of responsibilities: Curriculum Vitae • • • • • Data modeling, database design Programming in SQL / PLSQL, MySql Server technologies Creation, development and optimization of ETL processes Creating accurate reports with WebFOCUS and SAP BI technologies Shell programming Technologies: Informatica PowerCenter, Toad for Oracle 12.10, MySql Server, Sap Business Objects, Sap Crystal Clear, Sap Crystal Reports for Enterprise -) Eviden/Atos Client Name- BMW Group Function: BI Developer Scope of responsibilities: • Service user problems as the 3rd line support • Maintaining Systems • ETL process -Mapping, Transformation, Task, Workflow Technologies: Informatica PowerCenter, MySql Server, BMC Remdy -) Eviden/Atos Client Name – Nestlé (German market) Function: BI Developer Scope of responsibilities: • Planning, monitoring and implementation of batch jobs Facilities • Configuring, starting and stopping servers in real time • Configure the server Access Server • Set up and manage mappings • Set up and management tools Technologies: MySql Server, Aix, SQL Server 2014, BODS SAP, SAP Management Console -) Eviden/Atos Client Name- NOKIA /Project Nokia Application Monitoring Function: BI Developer Scope of responsibilities: • • • Business Monitoring Developer Maintenance Development Technologies: Business Bridge 5.5, SQL,Aix, Eclipse, Oracle, Java Servlets and Server Pages (JSP) in web container Tomcat 7.0 -) Eviden/Atos Client Name- Axa Polska S.A, Poland/Project NDWH Function: BI Developer Scope of responsibilities: • Design and implementation ETL layer of new DWH. Technologies: Oracle PL/SQL and SQL, MySql Server, Unix, Aix Kamil Bartosik Curriculum Vitae -) Client Name- PKO Bank Polski, Poland/Project Nordea Function: System Analyst Scope of responsibilities: • • • • • • • Support in testing, error analysis and preparation of data testing Monitoring systems for banking transactions flow both national and international Supporting the creation of documentation and specifications for changes of Centralized Settlement System Support in testing, error analysis and preparation of data testing Monitoring systems for banking transactions flow both national and international Participation in business meetings with IT solutions provider Using PL/SQL in ETL processes: integration with the database, writing procedures and functions and data processing Technologies: Oracle PL/SQL and SQL,MySql Server, Unix, Aix -) Client Name- CGI Information Systems and Management Consultants (Poland) Sp. z o.o.. , Poland/Project PTK Centertel Function: Database Administrator Scope of responsibilities: • • • • • • Advanced maintenance of systems CRM PTK Centertel Monitoring including the development of a system monitoring with Zabbix Programming in SQL, Pl/Sql technology Teamwork in the development of management systems Management and administrations of application servers: configuration, optimization, monitoring, analyzing of the system situations, locating errors, diagnosis of the errors and removing from the system Supervision of the IT system security Technologies: Oracle PL/SQL and SQL, MySql Server, Unix, Aix, Windows Server, Java -) Client Name- PTK Centertel, Poland Function: System Analyst Scope of responsibilities: • Analyzing and solving problems and incidents • Participation in IT projects Implementation of new functionalities Analysis of business requirements • Programming in SQL,T-SQL, Pl/SQL technology • Optimization of the questions and attention to the transparency of the source codes • Issuing Administration, operation, maintenance and development of the SAS systems • Monitoring of processes, information security control • Creation of technical and project documentation Technologies: Oracle PL/SQL and SQL, Unix, Aix, SAS 4GL -) Client Name- PTK Centertel, Poland Function: SQL Analyst Scope of responsibilities: • Creation, modification, optimization, implementation of SQL reports • Creation of project documentation • Completing and updating existing documentation • Participation in projects as an databases analyst • Valuation of business contracts, contact with business customer • Feasibility analysis Technologies: Oracle SQL, Unix Kamil Bartosik Curriculum Vitae Kamil Bartosik EDUCATION AND TRAINING • • • • • Warsaw University of Technology /Faculty of Environmental Engineering Google Associate Cloud Engineer (ACE) Certificate Google Cloud Certified - Professional Data Engineer Cloud Digital Leader Agile Project Management® Foundation Certificate PERSONAL SKILLS • • • Mother tongue(s)- Poland Other language(s)- English- Conversational Other language(s)- German- Elementary proficiency COMMUNICATION SKILLS • Good communication skills gained through my experience as BI Developer and Data Engineer JOB-RELATED SKILLS • Valuation of business contracts, contact with business customer. Participation in business meetings with IT solutions provider DRIVING LICENCE • Replace with driving licence Category/-ies: B Skills • • • • • • • • • • • • • • • Data analysis Programming/software development Systems integration Business Intelligence (BI) Bank Payments Data Warehousing PeopleSoft Campus Solutions Oracle PL/SQL Oracle SQL MySQL Server 2012 Oracle SQL Developer Data Modeler Oracle Developer Information Systems JavaScript BusinessBridge5.5 Proficiency Medior Medior Senior Medior Novice Medior Medior Senior Senior Medior Medior Medior Medior Novice Novice Curriculum Vitae • • • • • • • • • • • Apache Tomcat Eclipse IDE Talend - A Cloud Data Integration SAP Business intelligence: Sap Business Objects, Sap Crystal Clear, Sap Crystal Reports for Enterprise Microsoft Business Intelligence PowerCenter Informatica SAP BODS Novice GCP, Teradata SQL, Git Bash, Git Hub, Jenkins, NiFi, Airflow Python Scala, Spark Kamil Bartosik Novice Novice Novice Medior Medior Novice Medior Medior Medior