Federico Iván Leone Email and Phone Number

Analysis, Reengineering and updating of the company's regional and local project for the Pharmaceutical Industry. Estimation and planning of projects. Responsible for redesign, preparation of reports and executive dashboards for the Finance and Sales Management Area using Microstrategy tool 11.0.Development. Oracle PL/SQL (Toad 12.8/SQL Developer) DBA & Maintenance and controlling of ETL processes using Pentaho Data Integration (v. 5.1 and 8.2) and Python.Survey and design of solutions and… Show more Analysis, Reengineering and updating of the company's regional and local project for the Pharmaceutical Industry. Estimation and planning of projects. Responsible for redesign, preparation of reports and executive dashboards for the Finance and Sales Management Area using Microstrategy tool 11.0.Development. Oracle PL/SQL (Toad 12.8/SQL Developer) DBA & Maintenance and controlling of ETL processes using Pentaho Data Integration (v. 5.1 and 8.2) and Python.Survey and design of solutions and implementations of the productive circuit necessary for the publication of reports, audits and Reports of the Prescriptive Market Close-Up for Laboratories and Pharmacies on the platforms QlikView and QlikSense. Active support in migration phases (both in conversion into environment of user tests, such as the production test and the final conversion into productive environment). Collaboration in preparation and review of work plans. Business trips (survey, visit to Laboratories / Pharmacies) and Trainings.Strong collaboration with Quality department through the analysis, development and implementation of management reports and dashboards using MS Power BI. Show less

Analysis and diagnosis of Stocks, Sales and other critical indicators throught the pharmaceutical business model. Development and testing of ETL processes through the QlikView script for corrective and evolutionary maintenance. Data collection, processing and analysis to identify patterns, trends and opportunities. Datawarehouse and DBA (MS SQL Server) maintenance. Modifications to the model (data flow, extractors), queries and reports. Development of new extractors, analysis and resolution of… Show more Analysis and diagnosis of Stocks, Sales and other critical indicators throught the pharmaceutical business model. Development and testing of ETL processes through the QlikView script for corrective and evolutionary maintenance. Data collection, processing and analysis to identify patterns, trends and opportunities. Datawarehouse and DBA (MS SQL Server) maintenance. Modifications to the model (data flow, extractors), queries and reports. Development of new extractors, analysis and resolution of data quality problems. Implementation of changes. Automation and optimization of processes on QlikView 11. QlikView Server Administration. Coordinator and responsible for daily and weekly operations of loading productive data. Administration of infrastructure, users, servers and virtual machines (Amazon EC2). Implementations management under SAP ECC 6.0 environment. Coaching and technical coordination of team members under the agile Scrum methodology. Show less

Development, Implementation and Maintenance of Reports / Dashboards in Microstrategy on the DataWarehouse of Tenaris. JOBS maintenance of daily and monthly data loading under the IBM Datastage tool.Stock Analysis and other key indicators of Sales: turnover, prices, distribution and inventories, as well as the behavior of promotions and launches of retail chains of different leading regional suppliers throughout the ETL process. Development and testing of ETL processes through the QlikView… Show more Development, Implementation and Maintenance of Reports / Dashboards in Microstrategy on the DataWarehouse of Tenaris. JOBS maintenance of daily and monthly data loading under the IBM Datastage tool.Stock Analysis and other key indicators of Sales: turnover, prices, distribution and inventories, as well as the behavior of promotions and launches of retail chains of different leading regional suppliers throughout the ETL process. Development and testing of ETL processes through the QlikView script for corrective and evolutionary maintenance. Implementation of new customers / suppliers to the productive environment. Development of new extractors, analysis and resolution of data quality problems. Automation and optimization of processes in QlikView 11 Show less

BI Consultant Analyst in Datawarehouse Project at TELEFÓNICA DE ARGENTINA S.A Work tools: TERADATA, MICROSOFT SQL SERVER, MAINFRAME, UNIX SHELL, JCL and SSIS. Administration and maintenance of one of the largest Datawarehouse in Argentina. Resolution of Requirements and Incidents. Estimation, Planning, Development and Start-up of applications on SQL (TERADATA and MS SQL Server/T-SQL) in Unix and Mainframe environments. Analysis and interpretation of execution plans, estimates, development… Show more BI Consultant Analyst in Datawarehouse Project at TELEFÓNICA DE ARGENTINA S.A Work tools: TERADATA, MICROSOFT SQL SERVER, MAINFRAME, UNIX SHELL, JCL and SSIS. Administration and maintenance of one of the largest Datawarehouse in Argentina. Resolution of Requirements and Incidents. Estimation, Planning, Development and Start-up of applications on SQL (TERADATA and MS SQL Server/T-SQL) in Unix and Mainframe environments. Analysis and interpretation of execution plans, estimates, development, implementation, testing and documentation of evolutionary and corrective requirements of Analysts. Permanent interaction with Telefónica Product Analysts. Maintenance and control of Datamarts, ETL processes and loading in Unix and Mainframe systems. Attention and resolution of incidents, process cancellations, tickets and daily CRQ on BMC Remedy. Show less

ETL Consultant and Reporting (Data Warehousing - Business Intelligence), Data Warehouse, Data Mining, Reporting and development of BI projects. Data extraction and transformation, Reports, OLAP cubes, ETL and Data mining. Dashboards development using Pentaho BI Suite Platform.Customers project: Credicoop Bank and Banelco.

My responsibilities consisted of providing Second Level technical support in both English and Spanish languague and direct way to other Supporters via telephone, mail or internal console in order to solve US Client and Team Managers requirements, Incident resolution, bugs and Operations, Installations and software updates , Hardware Maintenance, Datawarehousing (ETL) and QA Tester tasks (On Facebook App. and other Apps.).