Teaching Data Modelling & Visualizations for PG inBusiness Intelligence & Data Science.

-Responsible of building the analytical architecture from scratch.-Managing overall pipeline orchestration. -Building and maintaining data platform-Delivering well-defined, transformed, tested, documented and code-reviewed data sets ready for analysis.-Training business users on how to use data visualizations tools (Power BI).-Working with business users to understand data requirements.-Building critical dashboards.-Creating measures and dimensions glossary.Main Software/Services: Data Sources: AWS S3, Amazon Connect, AWS RDS, Google Ads, META Ads, Google spreadsheets, Google Analytics, among others.Data Extraction: Stitch Data, SupermetricsData Migration: AWS Data Migration Service (DMS)Data Warehouse: AWS RedshiftData Transformation: DBTData Visualization: Power BI

Leading Business Intelligence practice in Crehana.Our purpose as a team:-Achieve a regulated autonomy: Data governance without bottlenecks and Self-Service without chaos.-Be the company's Data Driven pillar, promoting best practices.-Guarantee information availability, in a way that is relevant and appropriate.How do we do this:-Vision, assembly and end-to-end maintenance of our Data Pipelines:► Integration of different data sources to our Data Lake or Data Warehouse vía Stitch Data.► ETL (using AWS Glue, Glue Studio, Glue Databrew) or ELT (SQL) assembly processes to feed our Data Warehouse.► Creation and maintenance of tabular data models (Power BI, Tabular Editor, DAX Studio, Vertipaq Analyzer)► Implementation and automation of reports + resource management (Power BI)►Glossary creation► Analysis and interpretation of information-Roadmap development and monitoring, oriented to business needs.-Constant interaction with the different teams to detect their needs and provide them with solutions.-Training of the teams in the use of the BI tool (Power BI) to guide them towards a self-service culture in terms of reporting.

-Data preparation (profile, cleanse, transform) to get it ready to model and visualize.-Ensure that models and reports meet, and perform to, acknowledged requirements and expectations.-Data modeling.-Provide effective reports that guide the readers through the content quickly and efficiently. (Power BI, Looker, Data Studio)-Find insights, identify patterns and trends, predict outcomes, and then communicate those insights.-Manage all different data components (reports, dashboards, workspaces, datasets)-Manage and prioritize a guided roadmap to pursue and achieve the requirements of all of the teams that need BI support.

Building report solutions, dashboards and management indicators with configurable parameters for the end user, allowing information analysis (Microsoft Power BI, Oracle OBI EE, Google Data Studio).Collect and understand data according to different business needsJoint work with Data Engineers, to channel the several client needs. Integrate different data sources for decision making and take them to a data model.Support to different work teams (Sales, Marketing ON, Operations).Supporting and training users in the optimal use of BI tools.Review of the integrity and quality of the information delivered to the user.

-Analysis and control of the most relevant business indicators, focused on the P&L.- Generating complex reports through data modeling in Power Pivot and Power BI, which allows executing the strategy focused on results from key indicators.- Cross-section advising on creating and mainteining automated reports.-Annual sales Planning for different channels (non Brick & Mortar)-Sales Planning for the most important events of the year (CyberMonday + Hot Sale).- Prepararing management reports and presentations for directors and shareholders.

-Planning and monitoring sales budget. KPIs: Sales, rent, margin, stock, amongothers.- Product content enrichment. - Campaign planning. Responsibility for the commercial actions of the site.- Sales and results analysis.- Order tracking to the product area.- Demand and supply analysis; e-commerce metrics, such as traffic analysis, conversion rate, sources, mediums, etc.- Recognize industry trends and put together innovation proposals.- Analysis of communication strategies- Operation monitoring associated with categories.- Reporting - Sales prices benchmark

> Organising the various professional people working on a project.> Make sure that all the aims of the project are met.> Oversee the accounting, costing and billing.> Monitoring sub-contractors to ensure guidelines are maintained.> Use IT systems to keep track of people and progress (Oracle).

> Collect new customer settlement.> Establish and monitor the pre - payment receipt.> Control travel expenses of PASS and report the news for settlement , if any.> Distribution of paychecks , according to the agreement with the customer.> Monitoring accidents and complaints.> Control unproductive PASS and their respective vouchers.> Negotiating waivers and / or closing contracts of employment.> Response summons by telegram or letter with assistance from the Legal Department .> Preparation and submission of services certification.

> Various Accounting Task> Delivery Boy

> Teaching kids from 4 to 6 years old the basics of skiing.