Kenny O. Email and Phone Number

• Developing advanced dashboards on the Tableau desktop using the wireframes designed on Figma.• Developing robust ETL processes in SSIS for data extraction, transformation, loading, enhancing data accuracy and efficiency.• Implementing data ingestion pipelines, extracting, and loading data into AWS S3 buckets, and automating data refresh processes.• Understanding data uses raw data from the business domain and multiple systems of record and creating data models and structures to accurately identify key and associated data to be extracted, transformed, and loaded for effective utilization downstream.• Developing complex SQL queries for both planned and requested reports.• Monitoring technology trends and raising awareness of capabilities and innovations in selected domains of expertise and contributing towards industry-specific offerings.• Building comprehensive ERP dashboards and reports using Tableau desktop, serving cross-functional teams in an ITIL environment with best practices.• Collaborating with cross-functional teams to identify opportunities for data-driven decision-making.• Developing visual reports, dashboards, and KPI scorecards using Tableau. • Defining SLAs, managing tickets in ServiceNow, identifying the service level metrics and reporting project progress to the client leadership team. • Utilizing JIRA for project tracking, enabling efficient progress monitoring and logging data anomalies and issues, aiding in the identification, prioritization, and resolution of data quality issues.• Connecting to data sources, importing data, and transforming data for Business Intelligence.• Understanding and working with scenario planning (exit/ maintain/ grow) models.• Utilizing Tableau server to deploy reports.• Mapping ETL data working with large data sets.• Embracing internal support methodologies and maintaining sprint backlog of user stories and Kanban board for intelligent solutions using Agile standard methodologies.

• Designed, developed, conducted unit testing, and maintained complex Tableau reports for scalability, manageability, extensibility, performance, and reuse.• Collaborated with BI Architects to influence the design of data models and semantic layers to meet requirements and SLAs. • Created reports, dashboards, and visualizations to communicate insights to stakeholders.• Extracted reports and provided a high-level analysis of data for review using Enterprise Relationship Management (ERM) software. • Worked with business users to gather requirements in different forms and documented data.• Used Excel and Tableau online to create a sales dashboard for visualization.• Analyzed digital information collected from hotels to become more profitable by predicting trends and consumer behavior increasing sales by 15%.• Analyzed sales data to develop Key Performance Indicators and built dashboards to visualize important trends and goals for decision-making.• Monitored shop- style KPIs daily and dug into details to discover what drives those trends.• Collected data from various enterprise databases, including Oracle Database and Hadoop using Impala.• Created Phyton script for automation.• Utilized Tableau server to deploy reports.• Created sales dashboards and metrics for the business to understand lucrative merchandise and sizes selling fast on weekly and monthly basis.• Implemented and used data-driven decision processes having contributed to 18% of sales revenue within seven months.

• Developed and prepared financial business analysis and research related to the performance of Electronic Toll Systems.• Worked with business users to gather requirements in different forms and documented data.• Collaborated with stakeholders to drive communication and coordination of toll activities while promoting accountability. • Served as the department point of contact for data requests and ad hoc reporting.• Analyzed business objectives in relationship with information systems to identify feasible solutions.• Developed and implemented data models and databases to support business requirements.• Developed customized reports and dashboards for different user groups, stakeholders, and management entities for full activity tracking within the organization.• Used predictive modeling techniques and tools, such as linear regression, decision trees, and random forests, to develop models to help predict the likelihood of traffic conditions and identify trends.• Monitored data quality, accuracy, and completeness. • Manipulated data using VLOOKUP and Pivot Table in Excel. • Patched software and installed new versions to eliminate security problems while protecting data.• Analyzed large and complex transportation datasets, identifying trends, and drawing meaningful insights from toll data.• Good understanding of the transportation industry, particularly in the toll system.• Wrote complex SQL queries against models and databases.