José Gabriel Galindo Rugel Email & Phone Number

Guayaquil, Ec

Guayaquil Ecuador

- Maintain and add more dimensions and fact tables to the bank's data marts.- Create ETL processes with SQL Server Integration Services to ingest data from transactional servers to informational servers to be able to create reports- Create stored procedures and functions with Transact - SQL to process ingested data to prepare it for reports and dashboards- Automate data ingestion and analysis services processes for automatic daily loading using Workload- Data Extraction according to requirements by control entities- Banking campaign automation projects- RFM Models- Analysis and monitoring for the placement of banking services- Creating visualizations with SQL Server Reporting Services and Microsoft Power BI for management reports.

Guayaquil Ecuador

- Maintain and add more dimensions and fact tables to the bank's data marts.- Create ETL processes with SQL Server Integration Services to ingest data from transactional servers to informational servers to be able to create reports- Create stored procedures and functions with Transact - SQL to process ingested data to prepare it for reports and dashboards- Automate data ingestion and analysis services processes for automatic daily loading using Workload- Data Extraction according to requirements by control entities- Banking campaign automation projects- RFM Models- Analysis and monitoring for the placement of banking services- Creating visualizations with SQL Server Reporting Services and Microsoft Power BI for management reports.

Guayaquil Ecuador

- ETL processes to extract data from SAP Hana and place it in informational databases in SQL Server- Creation and maintenance of Information Cubes (SSAS)- Knowledge in SAP Hana Database and Master Tables- Creation and Maintenance of Automatic Reporting (PHP Spreadsheet)- Elaboration and Maintenance of Stored Procedures to process sales information (Transact-SQL)- Geolocation projects for sales department.- Sales Department Management Indicators (KPIs)- Management of Ecommerce platforms (WordPress, Hybris)- SAP Analytics Cloud (Dashboards & Models)

Av. Joaquin Orrantia Frente Al Mall Del Sol

Apply operational processes of the Liquidation of: - Monthly Pay Personnel and Interns - Provisions - Holidays - Unemployed Personnel (Settlement Acts) - IESS Schedule Chart Implementation of Social Welfare and Security Programs Coordinate Induction Processes. Training Processes of Attraction and Selection of Human Talent Management of Platforms - IESS - SUT - Online Salaries - Autonomina - Zeus

Guayaquil Ecuador

- Oracle: PlSql Tool Management for Information Search and Processing (SQL)- IBM Netezza: Use of IBM Tool for quick information search, report generation and preparation of Stored Procedures. (SQL)- IBM DataStage: Extracting Information with DataStage to Get Them from Oracle to Netezza (ETL)- IBM Director: Automation, scheduling and monitoring of processes created in DataStage.- Stored Procedures: Elaboration and modification of processes for Netezza reports.- Linux: Elaboration of Scripts for automation and extraction of Information from different local servers.