Derian August Mariana Sulaiman

Derian August Mariana Sulaiman

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

About Me

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…

Experience

Business Intelligence Analyst

Kickstarter
Dec 2020 - Present · 5 years 6 months

● 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 - Present · 5 years 7 months

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 year 1 month

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 year

● 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.

Skills

Excel Oracle SQL Python SQL Server Power BI SQL Server Management Studio Tableau 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
Report this Profile?