Anamaria A.

Business intelligence developer

Outsourcing
Senior
Brasov, ROMANIA
Contact us for this profile

My experience

More

PROVIDER OF SOLUTIONS FOR THE LOGISTICS AND TRANSPORTATION INDUSTRY01.01.2019 - Present

Development of a Data Quality Automate which consists of several treatments:
- address normalization using a free API;
- extract data from the database based on an exact match;
- extract data from the database based on a fuzzy match.

The automate is made of a Talend job and Python scripts which manage and process all the csv files and execute the treatments. The address normalization is done through a Python script which loads a csv file, calls the API for normalization and retains the response of the API in another csv file. Extracting the data for further use is about querying the database based on some input data. The fuzzy match treatment is made in Python using a built-in module csv match.

ETL Developer.
  • Development of File pocessing / Mappings / Transformation in Talend 6.4 (creation of mappings and execution of Python scripts using tMap, tReplicate, tUniqRow, tSortRow, tUnite, tAggregateRow, tSystem, tFileList, tFileCopy, tFileExist, tFileDelete, tFileInput/OutputDelimited, tSetGlobalVar, tBufferInput/Output, tHashInput/Output, tMySqlInput etc.).
  • Creation of Talend jobs.
  • Query optimization for a better performance.
  • Documentation and support for the client and fellow team members.

Python Developer.
  • Development of Python scripts (creation of Python scripts using a library: requests, collection, os and a csv match module, and creation of executable using pyinstaller).
More

Specialist in debt collection solutions01.08.2015 - 01.10.2016

ETL Developer.
  • Development of Mappings / Transformation / Joblets in Talend 6.3 (creation of mappings using tMap, tXMLMap, tReplicate, tUniqRow, tJava, tJavaFlex, tJavaRow, tAggregateRow, tRestClient, tRunJob, tSetGlobalVar, tExtractJSONField, etc.).
  • Analysis of the old database business model (Oracle) as well as the new one (PostgreSQL).
  • Creation of Talend jobs.
  • Query optimization for a better performance.
  • Interaction with Java developers team members to discuss about the ETL architecture and implementation of Java Services.
  • Documentation and support for other team members.
More

AB Groupe01.07.2014 - 01.08.2015

Developer.
  • Participation in the development of Delphi XE6 desktop applications using an SQL Server 2014 database and in the development of reports with SQL Server 2014 Reporting Services.
  • Analysis and development of the tasks according to project specifications.
  • Communication with the customer.
More

Integrator Soft01.03.2013 - 01.07.2014

Software Developer within a company specialized in the development and implementation of software solutions according to the needs of every client and of complex ERP, CRM, SCM, HR, Business Intelligence information systems.

Development and maintenance of the new and existent projects based on Delphi 5, SQL Server 2008 and ASP.NET.
  • Development of the new customer requirements for an existing ERP project.
  • Development of the new customer requirements and changes regarding the Romanian laws for a Human Resources management application.
  • Creation of a new module integrated with the HR system.
More

Integrator Soft01.10.2008 - 01.03.2013

Software Implementation Engineer within a company specialized in the development and implementation of software solutions according to the needs of every client and of complex ERP, CRM, SCM, HR, Business Intelligence information systems.

Software implementation.

  • Company software implementation (installation, configuration, data import, and training).
  • User support during the system startup and maintenance.
  • Client's requirements analysis and solution offering.
  • Identification, specification and facilities implementation in terms of software functionality.
  • Customer relationship management.
  • Software application tests in terms of functionality and possible error identification.
  • Collaboration with the programming team and reporting to the Team Leader.

Database and server responsibilities.

  • Installation of SQL Server 2008 to the customer's server.
  • Installation of the BDE (Borland Database Engine) and creation of a database alias on the user’s computers.
  • Creation and configuration of the database and the user accounts.
  • Creation of relevant scripts in SQL for data import.
  • Data import/export into/from the database.
  • Creation of backup, shrink and other jobs through the Maintenance Plan.
  • Database interrogation using T-SQL.

Business Intelligence activities and responsibilities.

  • Creation/modification of views for OLAP cubes and stored procedures for Reporting Services.
  • Development of cubes and reports in SQL Server Business Intelligence Development Studio 2008.

Programming activities and responsibilities.
  • Development of company software through SQL and Delphi.

Website maintenance.
  • Administration of the company's website through Drupal CMS.
  • Search Engine Optimization (SEO); use of Google Analytics tools.

My stack

Spoken languages

FRENCH: Average
ENGLISH: Advanced
ROMANIAN: Native speaker

Networks and systems

Windows

Languages

SQL, T-SQL, Delphi, Python

Web technologies

ASP.NET

DBMS

Microsoft SQL Server, Oracle, PostgreSQL

Business Intelligence / ETL

SQL Server Business Intelligence Development Studio 2008, SS Reporting Services, OLAP, Talend

Open Source solutions

Drupal

Miscellaneous

Agile, Scrum

Web Analysis and Statistics

Google Analytics, SEO

My education and trainings

Master's Degree in Integrated Business Information Systems, Faculty of Economic Sciences and Business Administration - "Transilvania" University, Brasov.2011-2013

Bachelor's Degree in Computer Science, Faculty of Mathematics and Computer Science - "Transilvania" University, Brasov.2004-2008