Dan Marius A.

Business Intelligence Developer

Outsourcing
17 years
Brasov, ROMANIA
Contact us for this profile

My experience

More

A leader in the Pool and Spa industryMay 2021 - Present

Data Engineer / Developer.
  • Assisting the client on developing a data driven environment to cover his business needs.
  • Data integration from multiple applications (CRM, ERP, CPM, customer portal) via Datahub (Azure SQL Database).
  • Developing complex ETL processes via Talend.
  • Database modelling and performance solutions.
  • Providing reporting expertise on multiple platforms: MS SSRS, Tableau, PowerBI.
  • Migration of certain small applications towards PowerApps framework.
  • Providing documentation for the implemented solutions.
  • Assisting the team with expertise on analyzing the requirements and providing proper solutions.

TECHNICAL STACK:
Database: SQL Server, Azure Database for SQL Server
ETL: Talend Open Studio, MS SSIS
Integration: Talend, API
Tool: MS SQL Management Studio, MS Visual Studio, Azure Data Studio, MS Reporting Services, PowerApps, GitHub, Postman, HeidiSQL, DBeaver
Reporting: SSRS, Tableau, PowerBI
Languages: T-SQL/SQL, JavaScript, Python
Other environments: Salesforce dev/admin environment

SKILLS
SQL Server, Azure Database, Talend Open Studio, MS SSIS, Talend, API, MS SQL Management Studio, MS Visual Studio, Azure Data Studio, MS Reporting Services, PowerApps, GitHub, Postman, HeidiSQL, DBeaver, SSRS, Tableau, PowerBI, T-SQL/SQL, JavaScript, Python, Salesforce
More

Groupe Renault RomaniaOctober 2017 - April 2021

Senior BI Developer / BI Administrator within a company specialized in the automotive industry.
  • Development and administration of SAP BO Universe and Spotfire data related to ITSM activity within Renault-Nissan group.
  • Development of custom reports or data extractions, complex dashboards.
  • User management and security, BO repository management.
  • Management of planned / automated reports.
  • Apps & Tools: HP Service Manager, ServiceNow, SQL Developer, SharePoint, BO Central Management Console, MS Excel, MS Access, MS Sharepoint.
  • BI & ETL: SAP Business Objects SP5, SAP BO Universe Designer, Tibco SpotFire, IBM Websphere Datastage.
  • Database: Oracle, Postgres SQL, MySQL, Access.
More

InfrasoftNovember 2016 - March 2017

Business Analyst / Project Manager for a digital solutions provider for the banking and financial sector.
  • Providing documented analysis and expertise on customer's business requirements and technical resources for DMS (Document Management System) implementation.
  • Coordinating the allocated team members for the project (developers, testers, system admin) - in charge with the project's deliverables (analysis, documentation/specifications, configuration, test cases, user manuals, go live).
  • Proof of concept definitions and configuration, presentation of the DMS products.
  • Participating in crucial meetings with the customer representatives (for presentations, analysis, project milestones definition: dead lines, deliverables, training).
  • In charge with post-implementation support as a liasion between the customers and developers.
  • Troubleshoot misconfigurations, debug malfunctions, develop reports and functionalities using SQL language and in-house development tools.
  • In charge for the tasks assignation to the team members as per the weekly sprint plans.
  • Technologies: SQL, PL/SQL, HTML, Java Script, Java.
  • Databases: Oracle, MySQL.
  • Web server: Tomcat.
  • Virtualization: VMWare, Oracle VirtualBox, Citrix.
  • Project methodology: Agile.
  • Development process: Kanban.
  • Task management and tracking: in-house Kanban platform - development tools: Idea Intelij, Oracle Sql Developer, PL/SQL Developer.
More

ArtSoft ConsultNovember 2014 - July 2016

Software Developer / ERP and SCM Solutions within a dynamic custom software development company.
  • Development of new features and functionalities for ERP and SCM solutions supplied by two major french vendors.
  • Analysis over the provided specification, document and implement the new functionalities.
  • Part of a multicultural offshore team of developers and consultants (mainly french speakers).
  • Participation in daily Scrum discussions (English and French) and analysis for the project's tasks with the project and delivery managers, also with all team members.
  • Participation in meetings, training / formation and presentations (onsite or via web conferencing) of tools and technologies related to the projects.
  • Project setup and deployment for UAT and pre-production environments.
  • Technologies languages: HTML, CSS, JavaScript, XSL, XSLT, XPath, XML, Ajax, SQL, PL/SQL, Progress (OpenEdge) 4GL, Progress Adm2.
  • Databases: Progress , Oracle 11g.
  • Application Server and Web Servers: Progress AppServer, Tomcat, Weblogic.
  • Virtualization: Amazon, Citrix, VMWare.
  • Projects methodology: Agile.
  • Development process: Scrum, Kanban.
  • Task management and tracking: Jira, Mantis, SalesForce.
  • Development tools: Eclipse, SVN, SQL Developer, Progress Dev Studio.
More

Oscar DownstreamApril 2014 - July 2014

IT Manager within a company specialized in the oil & energy industry.
  • IT activities coordination.
  • Management for new projects implementations (Active Directory, Sharepoint, Software Asset Management).
  • ERP SoftOne administration.
  • Managing relationships with IT suppliers / vendors for services and equipment (agreements, SLAs, on-demand and hotfix interventions, contracts, orders).
More

Point LogistixJuly 2013 - March 2014

IT Consultant for a developer and integrator of customized solutions SCM (Supply Chain Management), covering all related fields.
  • Implementation of the WMS solution Cross Point -provide analysis on clients resources and requests.
  • Participating in meetings with decisional factors within the companies in order to determine and establish the best working procedures in warehouses.
  • Defining the workflow and operations within the warehouses.
  • Databases configuration and management.
  • SQL Server test, back-up, production environment.
  • Modifying and developing new functionalities using SQL and C#.
  • Application servers configuration - IIS / SQL Server / Reporting Server / Maintenance Plans.
  • Databases compare and synchronization.
  • SQL development: procedures, views, functions, complex queries and scripts.
  • Developing, testing and managing ETL, EDI solutions for interfacing with other applications (mainly ERP systems - SAP, Atlantis, RVX Manager and SFA systems).
  • Reporting development using MS Reporting Services.
  • Configuration of industrial barcode printers, label templates definition (SATO, Zebra, Intermec, Godex).
  • Intermec mobile terminals configuration.
  • Providing training and documentation.
  • Providing consultancy and technical support (remote and on-site).
More

ConfidentialJuly 2012 - June 2013

IT Business Analyst.
  • Conducting software licensing audits for Progress Software, Oracle and Dolby Laboratories on selected customers from EMEA an US.
  • Creating in-depth customer profiling.
  • Assisting customers to submit the data needed to prepare the audit reports (scripts, logs, database files, high-level diagrams, configuration files, agreements).
  • Technical analysis on the submitted data.
  • Gathering additional information from the customer via conference calls and email.
  • Providing technical expertise on complex IT environments (large databases, data warehouses, application servers, disaster recovery infrastructures) from the licensing point of view.
  • Creating and delivering documented audit reports.
  • Conducting conference calls to support the conclusions from the reports in the presence of customer's decisional personnel (CIO, CFO) and vendor's representatives (Sales Executives, SAM Managers).
  • Delivering proper suggestions to the customer in order to resolve the non-compliance issues.
More

ACP - Air Conditioning ProductsAugust 2010 - April 2012

IT System Analyst / ERP Manager within a company providing various services and solutions.
  • Configuring and managing the IT&C infrastructure (WizPro - ERP System, databases server, mail server, workstations, printers, router, network, electronic time attendance system, WizSalary - payroll application).
  • Development of procedures and functionalities for ERP Production module implementation.
  • Development and implementation of algorithms to generate bill of materials for all finished goods, in order to obtain real time cost prices and stock control.
  • Establishing the proper working procedure for Production process (from order and work order to packing and delivery) into the ERP system.
  • MRP analysis and Production control process.
  • Stock evolution and inventory control, production costs calculation, managing the supply orders for raw materials, price list configuration and management of customer's price policies.
  • Creating custom and complex reports using ERP system reporting interface, SQL, and MS Excel features for Sales, Production, Supply, Financial and Stocks departments.
  • Database management (Microsoft SQL Server 2005 R2).
  • Security policies, back-up.
  • Data analysis (MSSQL, MS Excel).
  • Software asset management.
More

VIAMI SOFTWAREJanuary 2007 - July 2010

Junior Programmer / Project Manager within a company providing various software services and solutions.
  • Implementation of ERP systems VIP Professional and RVX Manager (web-based ERP).
  • Developing custom procedures and functionalities using SQL, Delphi, HTML, PHP programming languages.
  • Specialized in Production, CRM, Sales, Stocks (supplies, sales, delivery), Decision (OLAP Cube, Analysis, Reporting), Barcodes, Database Administration, Accounting/Finance modules.
  • Presentations and sales of the ERP products, management of implementation process.
  • Analyzing customer's resources and needs, developing proper solutions and procedures, business optimization, training, coordinator of implementation process and post-implementation support process.
  • Hardware / Software configuration: workstations, servers, networks, routers, printers, barcode and thermal printers.
  • Client interfacing via e-mail, phone, online ticketing platform, on-site interventions.
  • Hot fix interventions (both on client's site or using remote support tools).
  • Developing documentations on client's custom procedures.
  • Databases administration and analysis.
  • Development and implementation of custom reports on customer's requests.
  • Data conversion and migration.
More

METROULApril 2003 - January 2007

IT Support Technician within a company providing various services and solutions.
Data centralization and reporting based on engineers activity on the field.
  • Data operating in project management software Primavera, Microsoft Project.
  • Creating documentation for construction consultancy bidding process (bill of quantities, personnel list and qualification, graphics).
  • Taking photos and notes on physical stages of the projects on the field.
  • Delivering monthly or weekly project reports to the clients and department manager.
  • Responsible with the IT&C department's equipment and offering assistance / training on software products.

My education and trainings

Faculty of Installations - Technical University of Civil Engineering of Bucharest.2000 - 2005