Fernando Bolanos Email & Phone Number

Estados Unidos

• DBT data modeling for different business domains (Health, Retail, and Marketing Campaigns) for analytics.
• Technical migration from PostgreSQL store procedures to DBT using incremental models.
• DBT modeling for clinical utilization measurement and its tracking using Dashboard.
• DBT macro creation for data task automation and code simplification over different projects.
• DBT snapshot creating and modeling to track product changes over time.
• Stakeholder management.

El Salvador

• Member of the leading Product Discovery team for product initiatives in a financial modernization project for Walmart US.
• Definition of Product Vision for the financial information reprocessing web application.
• Responsible for grooming sessions with stakeholders and business users, to transform business needs into functional requirements.
• Leader and liaison of the product vision between data architects, product owners, and project development team.. Leading three dev teams… Show more
• Leader and liaison of the product vision between data architects, product owners, and project development team.. Leading three dev teams toward reaching our product vision.
• Demonstration of incremental features developed for stakeholders and end users.

San Salvador, El Salvador

• ETL processes design & implementation ingesting from multiple transactional systems to feed the corporate Data Lake, using Big Data stack such as Spark, Scala & Airflow in GCS.
• MySQL database management & data consumption for Tableau reports & reprocessing web application.

El Salvador

• Leadership & follow-up of business intelligence and data strategy initiatives.
• Coordination of the ETL team for implementation and improvement of data models.
• Dimensional modeling & design of datamarts to support regional business decisions.
• Dashboard creation to provide regional business visibility using Oracle Business Intelligence Enterprise Edition.
• Ad hoc business analysis as support of business decision-making.
• Training on the company's BI tools to Caribbean &… Show more

El Salvador

• Dashboards of key performance business indicators using Power BI y Tableau.
• Adhoc analysis creation for different business units.
• Creation of automated payroll calculation process using Oracle PL/SQL for internal "Sales & Distribution" structure (Chiefs & Managers).
• ETL process creation for data initiatives using Oracle PL/SQL.
• Insight discovery Analysis over residential & mobile financial services subscriber’s base.
• Unusual behavior analysis on "mobile financial… Show more

El Salvador

• Analysis over gross sales coming from different business units.
• Visualization on excel over gross sales, payment quality, survival rate and node penetration over residential installations.
• Data cube creation for tracking of sales and installations from different business units.
• Database administration of Oracle for sales information.
• ETL pipelines to support operational business process using Oracle PL/SQL.

El Salvador

• Historical performance analysis of Mobile Financial Services (MFS) Products.
• Transactional reports creation of events and amounts for MFS Products.
• Effectiveness measurement over MFS campaigns.
• Datasets extraction for campaigns using Oracle PL/SQL.

El Salvador

• Booking of Domestic and International flights for Expedia US customers.
• Schedules changes, cancelations & upselling on flight reservations.
• Over the phone asistence for any booking related concerns.

El Salvador

• Technical support over the phone for residential Bell Canada customers on Ontario & Quebec regions.
• Remote assistance of Bell Canada's software products

Master Of Big Data & Visual Analytics, Data Science

Information Systems Engineer, Computer Science