Charly Rosero

Responsible for defining the technological architecture that must support the data processing process. Enabling infrastructure Data science from the collection of data, the exploitation of information and its output and presentation, following a process of analysis and structuring, based on the business processes and operations of the company.

Achievements

• Define and deliver Data Strategy and develop concept, logical data models, referential data architecture diagrams including current, Interim and Target State.
• Provide technical leadership in resolving internal or external customer issues
• Define best practices for data loading and extraction and ensure architectural alignment of the designs and development.
• Design Methodology for data architecture workshop.
• Provide guidance on structure and content of productdocumentation, and review for quality
• Technical Mentor for python and Database Development Team onData and workflow Insights.

Design of the data use environment, how they are stored, how they are accessed and how they are shared and used by dierent departments, systems or applications in line with the business strategy. Design of Data Governance policies.

Achievements

• Improved performance model data ingestion from ~5 Hours to 1 Hour
• Design data governance policies, roles and mechanisms to adopt the data governance culture in the organization
• Lead a team to build a business intelligence project

Design, development and implementation of business intelligence solutions oriented to multidimensional models, construction of Datamart, ETL and OLAP cubes.

Achievements

• Develop and implement business intelligence projects
• Hands-On experience with tuning of the SQL Queries of DataWarehouse (OLAP) and On-Line Transactional Processing (OLTP)systems.
• In-depth understanding of the Kimball & Bill Inmonarchitectures of Data Warehouse.