Developer Sql Server

Abel Querson Mineo de Lima

https://www.linkedin.com/in/abelquerson/

Rua Albatroz, 169 – Arapongas, Paraná – Brazil

Mobile: +55-43-9-992*-****, e-mail: *******@*****.***.**

Objectives

SQL Server Developer - TSQL Developer - SQL Database Developer - SQL Developer - Business Intelligence Developer (T-SQL) - Junior Data Scientist - System Analyst - Report Developer - SQL Server DBA - Junior .NET Developer - Data Analyst - Software Engineer – DataBase Administrator

Qualifications

More than 15 years of experience working in IT with extensive knowledge in systems analysis, database programming, systems implementation, maintenance and improvements, customizations and integrations to ERP Systems.

Large experience in analyzing and manipulating data using complex queries TSQL, procedures, functions of SQL SERVER. Broad knowledge in TOTVS RM ERP System, TOTVS RM Business Intelligence Tool, TOTVS RM Reports and SSRS Reporting Services, beyond the capacity to develop ASP.NET WEBFORMS systems

Creative, proactive, dynamic, recognized team player that also led independent activities when needed

Problem solver with business vision always focused on bringing financial results to the company

Creator and developer of “studyandremember” project based on effective technique of flashcards used for students with difficulty in memorizing studied contents.

Degree in computer engineering (Universidade Norte do Paraná) and master degree in mathematics (Universidade Tecnológica Federal do Paraná)

Proficient in three languages: English, Spanish and Portuguese

Professional Background

Nicioli Industria e Comércio de Móveis Ltda – Mar/2003 to Present

System Analyst– May/2004 to Current:

Responsible for development and maintenance of Company Reports, BI System, Dashboards, indicators and any necessary customization inside or outside ERP system. Sql Server database Schedules via Procedures, Functions, Views, Complex and Strong TSQL Queries. Analysis of database architecture and development in ASP.NET WEBFORMS using VB.Net and C # language.

Achievements:

Cloning of Products: after a deep and detailed study for ERP system, I created a routine in SQL SERVER to automate the cloning of more than 3000 products with new colors. Based on existing registered products the system created new products automatically, eliminating the slow and manual process that affected the company’s market competitiveness. Using the new routine, company was able to quickly launch new kitchen line products, improving time to market in 2 months, and consequently differentiating themselves in the Market. https://1drv.ms/u/s!Aul-L-ZCOLQ53gQrBI_WzLdEe52K

Client Credit Analysis: after studying the entire process for company's credit and collection department, I created an asp.net WebForm page using vb.net, which automated the collection of customer information in a faster and more effective way. The department increased its productivity by 4 hours a day and began to focus itself to other essential tasks of the company.

https://1drv.ms/u/s!Aul-L-ZCOLQ53gEfEvZNECVcon7s

Customized products Registration: I improved company's ERP system to automatically register the customized products to the database. Based on a sql server procedure the system collected the inputs of the product’s measurements, checked the existence of this product in the database, and as a result selected an existing code or registered the product using a new code. In the case of third party products, the request was viewed by our partners in a web portal created in asp.net webform, for immediate manufacturing. The new procedure reduced the company's operating costs, and expedited the deliveries in more than 4 days.

https://1drv.ms/u/s!Aul-L-ZCOLQ53gKwGC0F2eYqltTZ

Salesforce System: After a long review of the company's sales process, I developed a system from the scratch to automate the process for product order, service order and sales reporting. At the time, the systems available in the market required many customizations to meet company’s needs, making its implementation unaffordable in terms. I was able to customize a system that met all the needs of the company with low implementation costs. After implantation, the system brought a 50% reduction in the company's operational cost, besides increasing the satisfaction of our clients with the greater agility in the process

https://1drv.ms/u/s!Aul-L-ZCOLQ53gBZnHu7ztAnZs7U

Support – Mar/2003 to May/2004

Responsible for user computer maintenance, network cabling and Windows 2000 server’s active direct administration. Responsible for developing and presenting Microsoft Office basic trainings for internal users.

Achievements:

Proactively performed preventive maintenance of computers every 3 months, checking for updates and antivirus, increasing employee productivity by preventing problems.

Initiated the project of backup machines where users always have a computer available in critical cases.

I taught Windows, Word, Excel, Power Point for users with difficulties in these systems, improving company’s productivity.

Other Projects

A new way of studying: Mar / 2018 - Current – System Analyst and Tool Developer

I created the project "studyandremember" that is based on techniques of flashcards for students with difficulty in memorizing studied contents. www.fichando.com.br or www.studyandremember.com;

https://www.youtube.com/watch?v=YPdJS9l5Cwc&t=5s

Education

Computing Engineer UNOPAR – Universidade Norte do Paraná

Master degree in Mathtematics “Special Programo of Pedagogical Training”

UTFPR – Universidade Tecnológica Federal do Paraná

Courses

Programming and Administration - SQL SERVER 2005;

SQL Server 2016 Reporting Services SSRS;

Programming Web Applications with Visual Basic .Net 2005;

Programming Asp.Net with C#;

Reports and Business Intelligence TOTVS RM System;

ISO 9001 e ISO 14001:2004 – Quality and Environment auditor

Interbase database;

MySql database;

Programação ADVPL I Plus;

JSE M1 – Basic Java;

Contact this candidate