Bogdan I.

DATA ENGINEER

293 euro
Freelancer
11 years
Bucharest, ROMANIA

My experience

Ing TechApril 2019 - Present

More

INGJune 2017 - March 2019

Data Analytics (Mid-Corporate Division)

• Mine and manipulate structured, semi-structured and unstructured data from the enterprise data warehouse, along with other disparate sources
• Structure data and prepare weekly reports
•    Provide monthly reports (Mid Corporate Banking) & monitor performance indicators using visual dashboards
•    Analyze data and discover insights that would empower management to make strategic decisions and address business challenges
•    Analyze marketing campaign performance to realize actionable insights
• Assist with preparation and automation of recurring / ad hoc reporting assignments
• Create forecasts, business intelligence analysis, funnel and user value analysis
•    Manage Key Performance Indicators designing & automation;
•    Work with others in the development of data warehouses and other data sources
•    Support relationship with the DWH IT team including managing and providing requirements/feedback and UAT
• Create and maintain documentation including Business Requirement
•    Innovate new ways to improve existing reports
• Troubleshoot and reconcile data issues and potential impacts
• Drive design and creation of innovative visual analytics dashboards to help aid with the identification of patterns and trends
• Organize excel training sessions;

Experience working in Agile Methodology with SQL Server, Excel, Power Pivot, PowerShell
More

VodafoneOctober 2016 - June 2017

Enterprise Business Unit - CVM Campaign Management & Analysis

The CVM Lead Management Specialist sustains marketing strategic objectives by Developing, implementing and improving direct marketing campaigns (by setting customer base that will be contacted, selection of proper optimization, analysis and reporting results) that target audience Vodafone Romania customer base or its partners.


⦁ Worked together with Data Miner and campaigns stakeholders in order to centralize all the requests for campaigns and define selection criteria
⦁ Managed selection of eligible customers considering campaigns requirements and applied the accurate criteria and successful execution using SAS and PL/SQL
⦁ Troubleshot and settled any issue related to the process of campaign execution
⦁ Measured the results of campaigns constantly in order to provide proof of the effectiveness of marketing decisions
⦁ Developed campaign analysis dashboards
⦁ Analyzed data and generated insights in order to understand customer behavior
⦁ Analyzed other business issues and generated detailed analysis in order to identify possible solutions
⦁ Optimized campaigns results and improved the effectiveness of extraction process.
⦁ Generated recurrent reports/forecasts or ad-hoc analysis
⦁ Offered support in terms of campaign data architecture & process logic to business teams and ensure they understand the impact of any technical issue

Experience working in telecom industry using tools like SAS, PL/Sql, Excel
More

INGFebruary 2012 - October 2016

B2B2C - Advisory Channel Management

⦁ Supported the entire business workflow: from problem definition to requirements specifications
⦁ Reviewed and analysed the effectiveness and efficiency of existing business processes related to salary agreements
⦁ Created project documentation
⦁ Ensured that requirements documentation was accurate, accepted by business stakeholders, and fully understood by the technical team before solutions was designed and implemented
⦁ Analysed and optimized the process of signing and implementing salary agreements; participated at development process, testing and offered training if necessary. (migrated the process from excel to ING systems and continued to improve and automate it).
⦁ Designed and developed weekly, monthly, and quarterly dashboards and reports
⦁ Analyzed and measured marketing/telesales campaigns using visual dashboards
⦁ Developed and managed discount Matrix approval
⦁ Invented and innovated new ways of promoting ING Offer (create a microsite in collaboration with Marketing and IT teams, in order to promote ING products directly to company employees and generate product leads)
⦁ Performed other ad-hoc analysis in order to support business decisions


Experience working with SQL, Excel

B2B2C - Advisory Channel Management


⦁ Managed and optimized the salary agreements offer template. Worked closer with marketing and sales teams and ensured the template was well designed, information was accurate and the content was original
⦁ Managed the process of signing and implementing salary agreements using Excel and ING systems
⦁ Troubleshot and solved any technical issues related to the process of signing salary agreements
⦁ Supported ING Branches/Offices in signing/implementing salary agreements and solved any issue generated
⦁ Managed salary agreements performance report - dedicated to ING Branches, sales force, other stakeholders
⦁ Generated ad-hoc analysis in order to improve the process of signing and implementing salary agreements
⦁ Analyzed the process and reduced the implementation timeline of salary agreements in ING systems
⦁ Designed and maintained WSM intranet page, dedicated to support ING Branches and ensure that all the information is accurate and updated
⦁ Offered training and enabled sales and partner teams to understand the process of signing and implementing salary agreements
⦁ Participated at UAT and tested all developments which affected our processes

Operations - Post disbursement and collection services





Post disbursement loan administration

Mortgage loan administration

Retail Accounts Support

My stack

Teamwork, Statistica, SQL, SPSS, SAS, Python, PL/SQL, MS Office, Microsoft SQL Server, Marketing Strategy, Management, HTML, Data analysis, Business Strategy, Business Analysis, Analysis, Agile