Experience

Fix.com

• Canada
• Consumer Goods
• 1 - 100 Employee

• SQL Server Senior Developer

  • Nov 2020 - Present

  - Perform data loads and routine updates on an ongoing basis. - Cleansing the Data, Ensuring Data Consistency, Analyzing the Data. - Identifying issues with the database and resolving them. - Created Views with business logics to reduce database complexities. - Created Database objects including Tables, Views, Stored Procedures. - Closely worked with QA team to verify the results moved to Test servers from the development servers. - Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues. - Design and Deploy SSIS Packages. Show less



Aegis Company

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• SQL Server Senior Developer

  • Aug 2020 - Oct 2020

  - Developed Advanced SQL queries and stored procedures to generate data reports. - Performed SQL query performance tuning by creating/modifying indexes, setting transaction isolation levels, and changing query structures (used CASE to reduce table scans/seeks; used CTE and inline calculation to replace sub-query-involved functions; used temp tables to reduce repeating retrieving, etc, ). - Built extract, transform, and load (ETL) process to migrate data from multiple types of data sources (SQL Server, Excel, Flat files) to destination database server by using SSIS packages, VBA, and Export/ Import wizard. - Prepared and updated documentations to ensure all procedures and knowledge are traceable in future cycles. - Presented excellent work attitude and communication skills with multiple teams/ departments. - Tools: MS SQL Server, Visual Studio, Visual Studio Code, Power BI and Azure DevOps. - Using DevOps to manage both development and implementation tasks. Show less



INCEDO IT & MKT Solutions and Services

• Argentina
• IT Services and IT Consulting
• 1 - 100 Employee

• Business Intelligence Lead

  • Jan 2018 - Jul 2020

  - Development and Management of Implementation Projects and Commissioning of the Loyalty System. - Monthly-based management, development and control of different processes. - Project Manager. Training to End Users. - Development of Informative Reports, Monitoring and Statistics. - Use of the .Net Platform, development in Reporting Services, Visual Studio, SQL Server. - Development and Management of Implementation Projects and Commissioning of the Loyalty System. - Monthly-based management, development and control of different processes. - Project Manager. Training to End Users. - Development of Informative Reports, Monitoring and Statistics. - Use of the .Net Platform, development in Reporting Services, Visual Studio, SQL Server.



Close-Up International

• Argentina
• Information Services
• 300 - 400 Employee

• Business Intelligence Lead

  • Dec 2014 - Dec 2017

  - Responsible for the BI Area of the Peru central. Task organizer, as well as leader of client’s meetings, locals and foreigners clients. I succeeded in fulfilling the deadlines of the projects that were holding at the time. - Preparation of several reports through the MicroStrategy tool for both, external and internal clients. These reports provide strategic data to the Marketing Department. - Generation of ETL’s in Pentaho tool according to the input files sent by customers and suppliers. - Unit and first level testing of the correct loading of the data to the Base. Control by means of the use of the Toad tool for Oracle Data Base considering the consistency of the same. - Analysis and exploitation of various databases, both Oracle and SQL Server. - Reduction of data processing by 40% of the time. Show less



CDT Soluciones Tecnológicas

• Argentina
• IT Services and IT Consulting
• 1 - 100 Employee

• Functional Technical Analyst (Senior)

  • Dec 2013 - Dec 2014

  - Evaluation of improvements / requirements requested by users. Determination of feasibility and purpose thereof. Then analysis and survey of said requirements or improvements. Documentation to transmit the user's needs to the provider. - Weekly-based management meetings were hold with the clients to provide the best service and improve the system for their needs. -Statistics database reports according to the requests of the departments of the company: Department of Treasury, Accountant, Payment to Suppliers. All of them are generated through the creation of queries, SP and finally job’s update and installation of the report on the PC of the end user. - Successful implementation of 80% of the requirements, within the required period. Show less



Émerix

• Argentina
• IT Services and IT Consulting
• 100 - 200 Employee

• Functional Analyst

  • Jun 2012 - Dec 2013

  -Frist Data: On-site support of the Emerix Tandem application. Incident Solution, development of new requirements in the database, derivation of errors from the website to the development area. Survey and control of all issues and incidents to supply the best solution to the client. Monthly incidents were reduced by 40%. - SIAP Implementation Project: configuration of the system and necessary adjustments to it to induce our client to incorporate another portfolio or to induce our client to incorporate new portfolio. - Bank Macro: development of performance improvements, new requirements. Support to the project area. Results: 75% reduction in data processing time. - Bank Comafi: testing and implementation of the refinancing module according to the specific requirements of the client. Setting in Store Procedures of the database and display settings and calculations of the web. - Bank Galicia: Store Procedures settings for receiving external system interfaces. Testing and optimization survey in account analysis and balance calculation processes. - Bank Credicop: Adaptation of the report module for migration to a new version of the application according to what was configured in advance to the particular client. - Bank Patagonia: Testing and generation of test cases of a new debt recovery management strategy. New creative and development of different strategies that would lead to new recovery management strategy, including test-cases. In addition, showing this benefit, so clients would appreciate, through workflow. Show less



Lagash

• Argentina
• IT Services and IT Consulting
• 1 - 100 Employee

• Functional Technical Analyst

  • Sep 2010 - Jun 2012

  - SigProv Project Documentation of processes, use of cases and required documentation complements. Testing of the application regarding the functional as well as the usability of the system. Collaboration in project management with the Share Point tool. The project was carried out with the agile SCRUM methodology with two-week sprints. - Ante-Project SigProv Functional Analysis for the estimation and sizing of the project. Survey with users of the functionalities that the system must support. Breakdown in cases of more specific uses and processes of the functionalities detected with their respective sizing of effort in hours required to complete the analysis. - ALOAS Project Web page development for the launch of the association and the future management and organization of its events. Analysis of requirements. Participation in the development in C # under Share Point platform. Installation and Configuration Documentation. - Master Time Project Functional analysis for the construction and development of a control system for hours worked by call center employees. Requirements survey with their respective documentation. Realization of the corresponding use cases, user manual and installation manual. Functional testing of the application. Planning tasks projects through the SCRUM Methodology. Show less



INCEDO IT & MKT Solutions and Services

• Argentina
• IT Services and IT Consulting
• 1 - 100 Employee

• Functional Technical Analyst

  • Sep 2009 - Sep 2010

  - Requirements analysis to adapt the product to the customer. Report development with SQL Reporting Services. - Development of import and export processes data with the use of Integration Services. - Monitoring of updates processes to the database. - Analysis for the incorporation of functionality in the clients’ web pages, which offer information on the product that they sell it. Then development and testing of the incorporated features. - Requirements analysis to adapt the product to the customer. Report development with SQL Reporting Services. - Development of import and export processes data with the use of Integration Services. - Monitoring of updates processes to the database. - Analysis for the incorporation of functionality in the clients’ web pages, which offer information on the product that they sell it. Then development and testing of the incorporated features.