Maria Jose Flores Ramos

• Ensuring data centralization and data insight generation to healthcare client by creating the first data warehouse. End users can now understand current state and make future analysis with reporting we are providing.
• Ensured data centralization to company by creating a data warehouse from multiples relational sources and API applications.
• Ensured data centralization to retail client by creating a PySpark based solutions that gather all information into one single hub in the cloud
• Ensured data availability to retail client by building a Scala based solution that moved client's data from mainframe system to Google Cloud

⦁ Ensured optimization and forecasting of resources to the operational area by generating operational metrics based on usage and expenses.
⦁ Ensured data insights generation by providing support to business and operational users while creating their own reports with operational information within data warehouse.
⦁ Ensured data quality by implementing quality steps and rollback plans for all ingestion, transformation, and push steps of data.
⦁ Tools: MicroStrategy, PowerBI, Azure Data Factory and Informatica Developer.

• Ensured up-to-date data maintenance by resolving requests from end users when discrepancies were found.
• Ensured data availability by creating on-demand database objects to store customer data.
• Created database objects for the data warehouse department.
• Maintained existing ETL processes in the data warehouse.