Lance Adrian Del Rosario

Lance Adrian Del Rosario |- ;- GitHub | LinkedIn Passionate about data analytics with a degree in Engineering. Seeking opportunities where I can utilize my analytical and technical skills to solve real life data analytics problems. EDUCATION Mapua University Manila, Philippines B.S Construction Engineering and Management -) SKILLS Analytical Tools: Power BI, Tableau, Advanced Excel, Programming Languages: SQL, Excel Visualization Tools : Power Bi, Excel pivot charts. Database: MySQL, Microsoft SQL Server, Core competencies: Able to adapt quickly to new environment, Strong analytical and problem-solving skills, Ability to multi-task, prioritize and manage time effectively, Critical thinker with effective researching skills. WORK EXPERIENCE Megawide Construction Corporation October 2019 – Current Quality Control Inspector to Housing Engineer to QA/QA Engineer • Input data on our database and managed a high volume of data entry tasks, processing an average of 500 records per day. Skilled in keyboarding and 10-key data entry with a typing speed of 50 WPM. Developed and maintained data entry procedures that improved efficiency and reduced errors. (Microsoft Excel and SharePoint) • • Proficient in Microsoft Excel (Pivot Chart and Excel Formulas) for data entry and data analysis. Manage KPI using Power BI and getting data from other database(Excel, SharePoint) and use of Dax formula to compute for the KPI. PROJECT Pizza Sales https://github.com/lanceadrian15/pizza • Showcase skills in Excel, SQL, and Power BI to successfully present meaningful analysis on the data with visually appealing and interactive dashboard. • In SQL, use of Basic SQL functions such as Group by, Order By , Decimal, Limit , Count , Distinct ,CTE, Cast, Datepart to get the data needed. • In Excel, Connect the SQL database and use Pivot Table and Pivot Chart to create an interactive dashboard to present the required KPIs and problem Statement. • In Power Bi, Connect the SQL database, Perform ETL which includes data cleaning , data modeling and data processing. Use Power Query to make the data uniform and operational. Uses DAX function to calculate KPIs and present data with visuals in accordance to the requirement CourseChallenge1 Codebasics’s CourseChallenge (Domain: Hospitality Function: Revenue) AtliQ Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, AtliQ Grands are losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of AtliQ Grands wanted to incorporate “Business and Data Intelligence” to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights. • Create a dashboard according to the mock-up provided by stakeholders. • Create relevant insights that are not provided in the metric list/mock-up dashboard. • Create the metrics according to the metric list. https://github.com/lanceadrian15/CourseChallenge1