Radu Gopsa

Responsibilities:
- Manage a remote team of 5 junior database engineers distributed across 4 countries;
- Analyze and understand data sources and end-user requirements to deliver data integration solutions;
- Provide 2nd level support for data pipeline (MySQL/Data Bricks, Pentaho, Run Deck, Bash, Spark) production incidents;
- Identify the ETL production incidents root cause and deploy hot fixes for remediation;
- Provide technical database support to implementation engineers during development and testing phases;
- Prepare and test new production releases to ensure successfully go live deployment (git/bitbucket/Jira );
- Continuous ETL improvement for performance.

Achievements:
- Designed and developed several end to end data transfer automation that replaces manual data processing;
- Ongoing monitoring of MySQL slow running code and optimizing them to not exceed 3 minutes using either index strategy or sql rework;
- Reduce Spark processing time by 50% after optimizing Spark parallelism execution;
- Define and coordinate a new release management process that allowed us to deploy new data pipeline changes during the week with no service disruption.

Responsibilities:
- Collect business reporting requirements from the main stakeholders;
- Develop the ETL solution (SSIS packages) to integrate internal and external data in reporting;
- Create and maintain visualization dashboards (Tableau, Power BI);
- Provide ad-hoc reports and analysis to the business. (T-SQL);

Achievements:
- Create and maintain a data mart reporting solution from scratch for sales organization on MSSQL technology.
- Build Tableau data visualization tool on top of the sales data mart;
- Support Tableau solution adoption for end-users with ongoing support provided to them;

Responsibilities:
- Application Service provider for finance , human resources , legal and corporate affairs departments;
- Manage IT projects across multiple countries from the South East Europe cluster.

Achievements:
- Coordinated implementation of the Time & Attendance system with
Integration to the local payroll system for the Philip Morris factory in Romania
- Coordinated deployment of the new Philip Morris Intranet across 10 different
Markets part of the SEE cluster;
- Coordinated deployment of the payroll slip delivery in Philip Morris Bulgaria;
- Run & support contract negotiation for the payroll system used in Serbia;

Responsibilities:
- Conduct IS\IT budget interviews with the main stakeholders from business departments for OB\LRP budget preparation;
- Prepared IS\IT financial reports for OB and LRP;
- Supported IS\IT Head of Function during all OB&LRP budget meeting review;
- Engaged central team for planning local\global projects;
- Support finance department in understanding variation off actuals vs budget..

Responsibilities:
- Application Service provider for finance , human resources , legal and corporate affairs departments;

Achievements:
- Coordinate implementation of the bank statement loading into SAP Accounting module and Charisma payroll system;
- Coordinated SAP implementation that calculates the customer penalty for delayed payments.

Responsibilities:
- Application Service provider for sales department

Achievements:
- Part of the SAP project team implementation responsible with data extraction;
from various systems and prepare them for uploading to SAP system;
- Build and maintain sales reporting solution based on Business Objects platform;
- Build and maintained the SALES OLAP cube.

• In charge of administer SQL databases and providing optimized T-SQL code to the development team:
• - built stored procedure/views/functions
• - built .dtx packages and use them as VBA module by the development team for optimized upload data

• Prepare materials and responsible to deliver the following trainings:
• Administer MS SQL Server 2000; Programming in T-SQL; Microsoft Access; Microsoft Office