Data Architecture and Business Intelligence

Data extraction, integration and data arquitecture for Guidewire deployment, modules PolicyCenter and BillingCenter in San Cristobal Seguros (SQL Server, Integration Services).
New Cloud Data Warehouse using Microsoft Cortana Intelligence on Azure (Synapse Analytics, Analysis Services, Power BI).
New development and arquitecture for new AWS Data Lake and Data Warehouse.
Start-up and project development for a Data Governance program for Grupo San Cristobal (all business units)
Architectures and data modeling definitions for information analysis.
ETL development to solve information needs in different areas.
Business requirements specifications.
Analysis and resolution of problems associated with data quality.

CorVel is a national provider of workers' compensation solutions to employers,
third party administrators, insurance companies and government agencies.

The solution include electronic invoice capture, intelligent routing of approvals and automated payments to reduce costs, improve productivity and eliminate paper from the process. AvidXchange makes it easy for companies to automate their bill payment process. As the first SaaS technology vendor to automate invoice processing, AvidXchange works with vendors to electronically send and receive invoices and has standard integration to more than 30 accounting systems.

CorVel is a national provider of workers compensation solutions to employers, third party administrators, insurance companies and government agencies.

Data extraction, integration and architecture for Guidewire deployment, modules PolicyCenter and BillingCenter (SQL Server, Integration Services).New Cloud Data Warehouse using Microsoft Cortana Intelligence on Azure (Synapse Analytics, Analysis Services, Power BI).

Project Leader of the migration of Dashboards to Business Objects platform. Migrating of Database version (Oracle 10g), development of Extraction and Transformation Process. Design and implementation of the Datawarehouse, which includes consolidated information from different transactional systems. Issuance of computer skills to support the company.

Implementing the Datawarehouse (Oracle 10g). Development of reports of the key areas of the company over Business Objects platform.

Design Extraction and Transformation Process (SQL Server 2000), parameterization of front-end for users. Implementation of Budgeting Tools (Crystal Planning). Development and implementation of Reports, Dashboards and Balanced Scorecards for company directors on the Business Objects platform.

Development of Extraction and Transformation Process (SQL Server 2000). Web-Based application development over Microsoft environment (ASP, SQL Server) of Customer Segmentation. Development and maintenance of applications to end users in Business Objects platform: Dashboards, Budgeting Tools, Customer Segmentation, Web Reporting, etc.

Functional Analysis, design of models and Datawarehouse schemes, design Extraction and Transformation Process (SQL Server 2000). Development and maintenance of applications intended for operational areas in Business Objects platform: Dashboards, OLAP Analysis and Web Reporting.

Participation in the technical and functional design of the project. Implementing the Datawarehouse (Oracle 10g). Coordination of team working from Argentina that performed the Extraction and Transformation Process of data. Development and implementation of Reports and Dashboards of key areas of the company, over Business Objects platform. Issuance of skills to end users, key users and systems developers.