Derian August Mariana Sulaiman

Derian August Mariana Sulaiman

Enthusiastic professional with three years in Data Analysis to utilize substantial knowledge of...
Indonesia
Chinese, English

نبذة عني

Enthusiastic professional with three years in Data Analysis to utilize substantial knowledge of visualizing data through Power BI and Tableau. Experience in building Data Analytics and Business Intelligence infrastructur…

الخبرة

Business Intelligence Analyst

Kickstarter
Dec 2020 - حتى الآن · 5 سنوات 6 أشهر

● Creating various SQL Scripts for verification of the required functionality.
● Coordinating the development activities with the team.
● Working with the business users and product managers to accurately capture all stakeholder requests.
● Monitoring and optimizing report performance, performance tuning in SQL query and Power BI.
● Cleaning and transforming data through DAX and Power Query.
● Creating function to convert Epoch date to DateTime format.
● Implementing several DAX functions for various fact calculations for efficient data visualization in Power BI
● Creating filters, quick filters, data source filters, global filters, context filters, user filters,
actions and creating Dashboards for key performance indicators.
● Present Dashboards in Power BI to key stakeholders to increase adoption and understanding of key performance indicators (KPIs) and business drivers.
● Evaluating business processes, anticipated requirements, uncovered areas for improvement, and developed and implemented solutions.
● Performing yearly analysis and business risks using different line charts.

Business Intelligence Analyst

Kickstarter
Dec 2020 - حتى الآن · 5 سنوات 7 أشهر

Creating various SQL Scripts for verification of the required functionality.
Coordinating the development activities with the team.
Working with the business users and product managers to accurately capture all stakeholder requests.
Monitoring and optimizing report performance, performance tuning in SQL query and Power BI.
Cleaning and transforming data through DAX and Power Query.
Creating function to convert Epoch date to DateTime format.
Implementing several DAX functions for various fact calculations for efficient data visualization in Power BI.
Creating filters, quick filters, data source filters, global filters, context filters, user filters, actions and creating Dashboards for key performance indicators.
Present Dashboards in Power BI to key stakeholders to increase adoption and understanding of key performance indicators (KPIs) and business drivers.
Evaluating business processes, anticipated requirements, uncovered areas for improvement, and developed and implemented solutions.
Performing yearly analysis and business risks using different line charts.

Data Analyst

Xactly Corporation
Nov 2019 - Dec 2020 · 1 سنة 1 شهر

Worked with Stakeholders and End Users to gather requirements to build Risk Modules.
Excellent understanding of business requirements and raw data for effective data analysis.
Wrote SQL queries to join tables to create a single report.
Prepared BI Interactive Dashboards using calculations, parameters in Tableau.
Experienced in creating filters, quick filters, data source filters, global filters, context filters, user filters, actions and creating Dashboards for key performance indicators.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu options and Parameters using Tableau.
Created reports in Tableau to understand successful project patterns and funding trends.
Contributed to building business dashboards to conduct trend analysis on metrics relating to driving revenue and investments.
Drafted quarterly and yearly reports on company financial metrics to assess successes and account for deficiencies.
Experienced in creating, and configuring workflows designed in SQL Server Integration Services (SSIS).
Attended the project review meetings, daily/weekly status meetings and walkthroughs with project managers and leads.

Data Analyst

Xactly Corporation
Nov 2019 - Dec 2020 · 1 سنة

● Worked with Stakeholders and End Users to gather requirements to build Risk Modules.
● Excellent understanding of business requirements and raw data for effective data analysis.
● Wrote SQL queries to join tables to create a single report.
● Prepared BI Interactive Dashboards using calculations, parameters in Tableau.
● Experienced in creating filters, quick filters, data source filters, global filters, context filters, user filters, actions and creating Dashboards for key performance indicators.
● Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu options and Parameters using Tableau.
● Created reports in Tableau to understand successful project patterns and funding trends.
● Contributed to building business dashboards to conduct trend analysis on metrics relating to driving revenue and investments.
● Drafted quarterly and yearly reports on company financial metrics to assess successes and account for deficiencies.
● Experienced in creating, and configuring workflows designed in SQL Server Integration Services (SSIS).
● Attended the project review meetings, daily/weekly status meetings and walkthroughs with project managers and leads.

المهارات

إكسل أوراكل إس كيو إل بايثون (لغة برمجة) خادم SQL باور بي آي استوديو إدارة خادم SQL تابلو SQL Data Analysis Business Intelligence Visualizing Data Coding Time Management Adaptability Analytical Thinking Problem Solving Communication Skills SQL Queries Oracle Microsoft SQL Server Management Studio Business Intelligence Tools Visualization Techniques Python Libraries Pandas NumPy Matplotlib Scikit Learn DAX Functions Data Validation Data Analytics Data Visualization Dimensional Modeling ETL Processes T-SQL DAX SQL Developer Jupyter Hub SQL Server Integration Services (SSIS) Power Query
الإبلاغ عن هذا الملف الشخصي؟