PROVIDER OF SOLUTIONS FOR THE LOGISTICS AND TRANSPORTATION INDUSTRYJanuary 2019 - March 2019
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.
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.
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).
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.
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.
Administration of the company's website through Drupal CMS.
Search Engine Optimization (SEO); use of Google Analytics tools.
Stay in the know with Pentalog tech & business updates
WHAT WE'RE ABOUT
Pentalog is a digital services platform dedicated to helping companies access world-class software engineering and product talent. With a global workforce spanning more than 16 locations, our staffing solutions and digital services power client success.