Business Intelligence Developer

• Oct 2021 - Present

Business Intelligence Developer

• Mar 2021 - Oct 2021

MVP Studio is a Software Incubator Company. During my internship, I worked on cloud-based property investment and management platform. It is a one-stop online platform for property investors, managers, owners, tenants, and service providers. • Provide complete Data Insight solution: from Data Standardization, Data Modelling, ETL, Data Warehouse to Report and Dashboard Presentation. • Connect to multiple data sources, extract, cleanse and transform data using Power BI, and SQL for Business Intelligence. • Analyze business logic and needs and use the Kimball Dimensional Modelling techniques to define dimension tables and fact tables. • Design and develop ETL solution with SSIS using Slowly Changing Dimension, Lookup, Derived Column, Merge Join, Conditional Split, Data Conversion, OLE DB Command and various others. • Generate Store Procedures and Functions in SQL Server to implement medium-to-complex business logic for reporting and analysis purposes. • Produce interactive Reports by integrating stored procedures and input parameters using Visual Studio (SSRS) or Report Builder. • Develop data visualizations and dashboards using Power BI • Create KPI's, Calculated Measures, DAX queries, and Roles. • Develop dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis. • Write calculated columns, Measures query's using DAX in Power BI to show good data analysis techniques. • Involve in scorecard and KPI Reporting. • Design Power BI dashboard which give a visual representation for the users on Customer Churn Analysis, Market Expense Cost, Customer Acquisition cost, Customers’ Location Map etc. , • Created different tabular reports using Power BI features and enhanced them based on user requirements. • Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper level management. Show less

Fulfillment Associate

• Oct 2019 - Mar 2021

▪ Identified issues and creates strategies to solve them to maintain smooth workflow operations. ▪ Serve as ambassador and warehouse building problem solver. ▪ Train and assist new employees on how to accurately keep track of product, inventory, problems and correctly perform amnesty. ▪ Fulfilled customer’s online orders, packed orders and shipped them on time for delivery, resolved issues regarding customers complain about products. ▪ Conduct audits as line leader to troubleshoot and give reports to managers. ▪ Lead a team in Problem Solve working with intricate programs to properly document and correct processing mistakes. Show less

Web Developer

• Mar 2013 - Dec 2015

▪ Effectively communicated with clients to gather function requirements for web application. ▪ Collaborate with web design and development team to create a new web application ▪ Developed interactive web applications using a dynamic scripting language (PHP) and LAMP architectuer ▪ Implemented PHP session variables and cookies. ▪ Developed CMS components ▪ Worked heavily with relationship database models, schemas and Entity-Relationship Diagrams (ERMs) and implemented database ▪ Created DDL, DML, DCL in Design and Normalization phase of database tables. ▪ Involved in writing SQL Queries, Store Procedures, User Defined Functions, CTE and Views Show less