Summary
Work History
Education
Skills
Timeline
Overview

Daniel Ferreyra

SQL Developer - Software Engineer
Florida,Argentina

Summary

Thorough SQL Developer with expert grasp of SQL code generation, analytics, reporting and business intelligence. Diverse knowledge of complex T-SQL coding instances. Conversant in up-to-date and legacy programming languages, standards and tools. Adept in leading all stages of software development and troubleshooting. As Microstrategy certified developer I developed whole BI projects.


In addition to better understand the requirements and needs of customers, to design and develop more consistent and organic solutions, and to optimize tasks and processes, I studied Economics at the University of Buenos Aires, pursuing the degree program in Information Systems, attending courses such as Accounting, Costs, Management and Mathematics.

Keep on learning and up to date is always a huge motivation.



Work History

SQL Developer - Software Engineer

AMM CABA
CABA, CABA
02.2001 - Current
  • Created optimal technical solutions to user needs with in-depth system analysis.
  • (SSIS) Designed and developed customized extract, transform and load (ETL) to migrate old data from flat files (BTRIEVE) to MS-SQL Server designed database. +30.000 members, historical current accounts, products, membership status, payment methods, etc.
  • Design and implementation TSQL queries for reporting and complex solution development. Crystal reports and SSRS.
  • Design and implementation of DTS packages to handle incoming and outgoing data to and from the designed ERP. Stored procedures and T-SQL functions for correct automatic account assignment to the ERP system.
  • MySQL based web services to be consumed by third parties
  • Elections results processing, d'hondt calculator, winners lists, web publishing support, on public winners presentation in an auditorium.
  • Massive data processing that involves 9000 members at once (SSIS, TSQL - CURSOR, user defined functions, window Functions is Stored procedures).
  • Salary settlement software (TSQL based, VB in client side).
  • VB.NET projects.
  • Analyzed existing SQL queries to identify opportunities for improvements and implement SQL SERVER new features.
  • SQL Version:
    2016 in production
    2019 in testing and BI server.
  • Web API .php MySql
  • Web API .Net core 6 (c#)

LDG SA

LDG SA
02.2008 - 07.2014
  • Participated in team-building activities to enhance working relationships.
  • Increased customer satisfaction by resolving issues.
  • Documented effective and replicable methods for extracting data and organizing data sources.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • I became the Microstrategy Certified Developer (BI Full stack) title from Microstrategy University. Needed to work as Microstrategy official Partner.
  • Oracle database analysis for a Company's systems department, Lo jack.
  • Migration of insurance company billing software system from Access to MS SQL Server. Including Data import an export, data wrangling and business logic re-design.
  • Bi development. Architect, ETL development, OLAP cubes. metrics and facts definition, reports and dashboards. Multi source integration (SQL an flat files).


Software Developer

DS System's (owner)
01.1991 - 02.2008
  • Developed software for desktop and mobile operating systems
  • Translated customer requirements into written use cases.
  • Developed functional databases, applications and servers to support websites on back-end.
  • Participated in requirements gathering to solidify prerequisites and determine best technical solution to meet business needs.
  • Provided software application engineering and maintenance for development lifecycle.
  • Analyzed existing software implementations to identify areas requiring improvement.
  • PROJECTS
  • Aero Baires SACI. Beechcraft partner for LATAM. Develop for stock and Tracking parts software as FAA (Federal Aviation Administration) requirements. Approbed.
    Billing software for airships Repair and maintenance, from historical parts and equipment movements, stock and services. Interaction with gubernamental API and web services. ERP Software
  • Argentina Society of Ophthalmology: Software (web) to admission and administration of Annual Event (+- 2500 attendants). Organization Mobile App. Desktop ERP on cloud server
  • More than 20 customers from different industries. Finances, Health, Accounting, Aviation, Building, retail, among others. In all cases Full stack developments from customer or organization requirements to final product. Talking with all involved areas to better understand needs.



Education

On Process - Full Stack Web Developer

Udacity, Nanodegree Program
05.2022 - Current

Python, Flask, Postgres, Kubernetes, docker. bootstrap....

Certified - Data Engineering

Udacity , Nanodegree Program
09.2021 - 12.2021

Data modeling with Postgres and Apache Casandra

Cloud Data warehouse - AWS s3 and redshift.

Data lakes - spark

Data pipelines - Airflow

Https://confirm.udacity.com/23X2NAKW

Microstrategy Certified Developer 9.21

Microstrategy University, Web
11.2012 - 06.2013

Bachelor of Business Information Systems - Economics

UBA, (Universidad De Buenos Aires)
01.1985 - 07.1988

Skills

    SQL analytics

undefined

Timeline

Udacity - On Process, Full Stack Web Developer
05.2022 - Current

Data Engineering - Udacity

01-2022
Udacity - Certified, Data Engineering
09.2021 - 12.2021

Complete Flutter development Bootcamp Using - AppBrewery

08-2018

Microstrategy Certified Developer - Microstrategy University

11-2013
Microstrategy University - , Microstrategy Certified Developer 9.21
11.2012 - 06.2013
LDG SA - LDG SA
02.2008 - 07.2014

Microsoft Solution Developer - IT College

12-2003
SQL Developer - Software Engineer - AMM CABA
02.2001 - Current
Software Developer - DS System's (owner)
01.1991 - 02.2008
UBA - Bachelor of Business Information Systems, Economics
01.1985 - 07.1988

Overview

45
45
years of professional experience
5
5
years of post-secondary education

Similar Profiles

CREATE PROFILE
Daniel FerreyraSQL Developer - Software Engineer