Created complete BI Architecture road map and implemented end to end BI solution for their financial reporting needs by providing them self service capabilities and enabling them to create their own reports & dashboards for their 18 companies (Industries, Engineering, Telecom and Services) using Microsoft technology stack (Azure SQL, Azure Analysis Service and POWER BI).
Microsoft technology stack
Implemented end to end cloud data warehouse by bring data from 5 different data sources (Oracle ERP, Salesforce, Go Transverse, Gemalto, Google Analytics ) and generating sales, marketing, finance and operation reports using SSRS & Power BI for their Executive and operation team.
Microsoft technology stack
Provided end to end BI solution for a US based healthcare organization having more than 20 branch by providing them self service reporting capabilities. Developed an Enterprise data warehouse which ingest data from 3 different data sources i.e. wellsky (patient management system), ultipro (Employee and time management system), Microsoft GP (accounting system) and created several reports by using Azure Analysis services and Power BI.
Microsoft technology stack
Implemented Machine learning for their existing CRM solutions to get the probability of opportunity closure, keep track of current opportunities status and help them to strategically plan their resource allocation for maximum closure probability
Microsoft technology stack
Created architecture blueprint and Implemented Business Intelligence solution using MS BI tools (SSIS, SSAS and POWER BI) to keep track of their conveyor efficiency for their three warehouses with advance descriptive and diagnostic reporting
Microsoft technology stack
Created architecture roadmap and working on POC to bring data from three different source systems, designing EDW and generate power bi and SSRS reports – Financial and CRM
Microsoft technology stack
Implemented Power bi dashboard to keep track of their product and service sales against various dimensions such as vendor, genre, location and category, to get insight of their marketing expense along with financial reporting such as P&L and Debtor’s Aging Report
Microsoft technology stack
Designed & Implemented OLTP system along with advance reporting capabilities to track their order/work status, maintain inventory, sales and marketing expenditure
Microsoft technology stack
Implemented diagnostic analytical solution to analyze hit and miss ratio, keep track of operational cost, vendor management, Freight cost analysis, to identify most cost effective mode of transport, total and volume of parcels delivered to a location (geotagging) and customer wise along with financial reporting
Microsoft technology stack
Provided business and IT consultancy to redefine their Operation, HR and Procurement process and help them in implementing a complete ERP solution
Microsoft technology stack
Created architecture document to integrate data from their various services- U manage, U-server and U- control to have cross reporting capabilities. The end product was in the form of new reporting product service line (U-report)
Microsoft technology stack
Consolidated their sales, financial and labor cost data from difference data sources (Connect wise sell, connect wise manage & sage Intacct) and created P&L report
Microsoft technology stack
Created ETL and data model to integrate Financial data from GP for reporting purpose
Microsoft technology stack
.webp "Top Mobile App Developers GoodFirms")
.webp "Clutch_Mobile_App_Developers_2020")
.webp "Mobile-App-Circular")
.webp "homelogo/extract_top_application _developer")
