Sam M.
Business Intelligence Developer at Absolute Logistics- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Absolute Logistics
-
United States
-
Transportation, Logistics, Supply Chain and Storage
-
1 - 100 Employee
-
Business Intelligence Developer
-
Feb 2021 - Present
• Gathering the requirements from business teams and coordinating with different teams to complete the End to End process of Integration. • Always actively participate in four ceremonies: Sprint planning meeting, Daily Scrum, Sprint review meeting, and Sprint retrospective meeting. • Implementing Azure Logic Apps, Azure Functions, Azure Storage, and Service Bus • Worked on all activities related to the development, implementation, administration, and support of ETL processes • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases • Created Dashboards style of reports using Power BI Desktop Visualizations like Bar Chart, Line Chart, Area Chart, and Slicer, etc. • Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis. Performed capacity planning and growth prediction for client audit data • Query tuning based on query execution plans, statistics, and profiling • Created code-based solution for application error involving composite key manipulation • Queues for large enterprise-level ERP Integration systems. • Created pivot tables and COUNTIF formulas in Excel to automate data entry processes, resulting in a reduction of 40 work hours per week. • Performed PowerPoint presentations of sales figures to the managers and executives’ teams • Supported the management team by cleaning, analysing, and visualising the sales data Show less
-
-
-
-
Business Intelligence Consultant
-
Mar 2019 - Dec 2020
· Develop Datasets, Reports and dashboards using Power BI. · Involved in creating the prototypes and requirements specifications by understanding and analyzing the requirements. · Developed Power BI dashboards for proactive SLA and queue management · Used various sources to pull data into power bi such as share point , excel, Kusto , SQL server , OData · Maintaining and supporting operational reports, dashboards, and score cards using Power BI. · Good experience on implementation of Row Level Security by defining various constraints for each defined roles. · Installed and Configured Enterprise Gateways for Power Bi Service. · Writing stored procedures and functions in sql server. · Implemented ADF pipelines for loading data Show less
-
-
-
RealSoft
-
Uzbekistan
-
IT Services and IT Consulting
-
1 - 100 Employee
-
SQL Developer
-
Feb 2018 - Mar 2019
• Extensively used joins and sub-queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production. • Implemented Functions, views, triggers, and stored procedures and enforced business rules via checks and constraints. • Dug into database details to ensure appropriate data filters are apply based on business requirements • Actively participated in interaction with users, team lead, DBA's and technical manager to fully understand the requirements of the system. • Wrote and automated 100+ tools/scripts to increase departmental efficiency and automate repeatable tasks. • Manipulated files and their associated data for rapid delivery to clients or loading onto internal databases. • Investigated data quality issues, implementing appropriate solutions that increased overall efficiency. • Tuned and Optimized SQL Queries using Execution Plan and Profiler • Trouble shoot problems with the various teams including network related issues Show less
-
-
Education
-
Westminster International University in Tashkent
Bachelor's degree, Finance