Anwar Hossain, Data Engineer and BI Developer in Seattle, United States
Anwar Hossain

Data Engineer and BI Developer in Seattle, United States

Member since June 18, 2020
Anwar has 20+ years of experience in building and maintaining large-scale distributed systems, data platforms, and machine learning for a variety of industries. With a master of science degree in computer science from USC, his technical understanding is deeply rooted. Anwar has excellent communication skills and business understanding. With great interpersonal skills, it is a pleasure to work with him.
Anwar is now available for hire

Portfolio

  • Simetric, Inc
    Python 3, Analytics, Microsoft Power BI, Machine Learning, Azure Data Factory...
  • Toyota
    Microsoft Power BI, Python 3, T-SQL, Microsoft Excel, Dashboards, Reports...
  • World Health Organization
    SQL, Microsoft Power BI, Data Pipelines, APIs, Distributed Databases, Cloud...

Experience

Location

Seattle, United States

Availability

Part-time

Preferred Environment

Azure, SQL Server Management Studio, SQL, Visual Studio, Windows, Microsoft SQL Server

The most amazing...

...thing I've done was build a data platform for an $800 million business to enable decision-making for people working at the operations up to the executives.

Employment

  • Director of Analytics

    2020 - 2022
    Simetric, Inc
    • Led the strategy and end-to-end execution of Simetric’s data platform to deliver unified IoT device lifecycle management, reporting, and insights engine, business process automation (BPA), rate plan optimization, advanced, and analytics.
    • Developed a cutting-edge IoT analytics suit providing insights into the IoT device connectivity and usage behavior, anomaly, cost drivers, saving opportunities, churn prediction, segmentation, and forecasting.
    • Saved over 30% in IoT expense and improved customers' experience by implementing business process automation (BPA) that integrates multiple internal and external systems and uses custom business rules to automatically do near real-time device actions.
    • Delivered a highly scalable serverless data ingestion and processing platform for millions of IoT devices from dozens of global MNO, MVNO, and third-party applications to power up Simetric’s core engine.
    • Reduced Simetric’s cloud cost/month by 25% by optimizing Azure infrastructure usage, mitigated security issues to be compliant with ISO and Azure CIS, and improved the data quality by 15%, incorporating business rules and audits.
    • Built Simetric's Unified REST APIs to extract connectivity data and unifies them from hundreds of Telecom carriers around the globe.
    Technologies: Python 3, Analytics, Microsoft Power BI, Machine Learning, Azure Data Factory, Azure SQL, Azure IaaS, Azure Blobs, Azure Logic Apps, Azure, APIs, Azure Cosmos DB, Azure Queue, Azure DevOps, Azure IoT Hub, ETL, SQL, CI/CD Pipelines, Data Pipelines, Databases, Data Science, Snowflake, Distributed Databases, Cloud, Agile, Git, R, Agile Software Development, T-SQL, Microsoft Excel, GitHub, Google Cloud Platform (GCP), Linear Regression, Dashboards, Reports, Logistic Regression, Excel VBA, Leadership, Reporting, Data Modeling, Azure Blob Storage API, Message Queues, Relational Databases, Tableau, Visual Basic for Applications (VBA), Cluster Analysis, Time Series Analysis, Azure API Management, REST APIs, C#
  • Consultant

    2021 - 2021
    Toyota
    • Built a sentiment analysis pipeline using Python from hundreds of thousands of survey records.
    • Built a Power BI dashboard to quickly narrow down features customers like, do not like, and wish to have.
    • Analyzed the survey data to bucket them into different categories.
    Technologies: Microsoft Power BI, Python 3, T-SQL, Microsoft Excel, Dashboards, Reports, Excel VBA, Reporting, Data Modeling, Relational Databases
  • Consultant

    2020 - 2020
    World Health Organization
    • Built an end-to-end solution for Polio data mart: extracted and loaded data from various sources, including APIs, CSV, and Excel files, transformed data into the data mart, and built Power BI reporting on top to provide insights into the spread of the disease.
    • Created a visual storytelling dashboard that shows the spread of disease across borders over time.
    • Created a data pipeline using Python to pull data from APIs and load it into a central data mart.
    Technologies: SQL, Microsoft Power BI, Data Pipelines, APIs, Distributed Databases, Cloud, Python 3, Agile Software Development, T-SQL, Microsoft Excel, Dashboards, Reports, Excel VBA, Reporting, Data Modeling, Relational Databases, REST APIs
  • Data and Analytics Lead and Architect

    2016 - 2020
    A $1 Billion Company Known for Creating Licensed Pop Culture Products
    • Headed the end-to-end implementation of an enterprise data warehouse, reports, and dashboards, setting up strategy and roadmap, infrastructures, data pipeline, data modeling, and transformations, job scheduling, monitoring security model and visuals.
    • Integrated with ERP systems, sell-through data, eCommerce platforms, flat files, third-party APIs, social networks, active directory, contract management system, various cloud services, and so on, to feed into the enterprise data warehouse.
    • Developed a flexible metadata-driven ETL solution that provides auditibility, configurability, error handling, parallel execution, incremental data load, process orchestration, and monitoring, enabling no-code/low-code for the team.
    • Architected and implemented a rule-based and statistics-based data quality framework to measure and monitor the data quality in a highly flexible and scalable manner and surface the issues in a dashboard to monitor and track.
    • Established the best practice guidelines for dimensional data modeling for consistent data products, naming convention, and data dictionary for easy data discovery and code and release management for faster and quality delivery.
    • Instituted an end-to-end source to target mapping tracking data lineage, including data transformation through all stages of the analytics pipeline, thus making the process transparent to users and easy to troubleshoot for developers and analysts.
    • Built an end-to-end reporting and dashboard solution, including setting up a Tableau server, pulling data from various sources, creating metrics, designing reports and dashboards, migration, publishing, and managing security.
    Technologies: Azure Cosmos DB, Spark, Azure Logic Apps, Chatbots, Computer Vision, Azure, Microsoft Power BI, Visual Studio, Python, SSAS, SQL Server Integration Services (SSIS), SQL, Microsoft SQL Server, SQL Server Analysis Services (SSAS), Snowflake, Data Engineering, Business Intelligence (BI), Data Analytics, Data Analyst, Data Analysis, Databases, Data Migration, Distributed Databases, Cloud, Agile, Jira, Python 3, Git, R, Agile Software Development, T-SQL, Microsoft Excel, Jenkins, MySQL, Amazon Web Services (AWS), Linear Regression, Dashboards, Reports, Bitbucket, Logistic Regression, Excel VBA, Leadership, Reporting, Data Modeling, Azure Blob Storage API, ETL, Message Queues, Relational Databases, Tableau, Visual Basic for Applications (VBA), Cluster Analysis, Time Series Analysis, REST APIs
  • Analytics Consultant

    2014 - 2016
    Microsoft Corporation
    • Saved $2.47 million annually by providing a BI solution for more than 200 metrics via both self-service and managed reporting, and also improved transaction efficacies across order and agreement management.
    • Delivered a volume licensing forecasting analytics solution to predict the number of agreements and orders to be processed in various regional operations centers on a daily, weekly, and monthly basis and thus saving an estimated $280,000 annually by avoiding penalty and minimizing revenue left on the table.
    • Increased BI platform usage by 189% by enabling the business to do near-real-time deal monitoring, proactive case tracking, and improving customer and partner experience.
    • Achieved great improvement in scorecard metrics - data-driven organization (200%), adoption (189%), efficiency (30%), and ROI (20%).
    Technologies: Microsoft Power BI, Visual Studio, Python, SSAS, SQL Server Integration Services (SSIS), SQL, Microsoft SQL Server, SQL Server Analysis Services (SSAS), Data Engineering, Business Intelligence (BI), Data Analytics, Data Analyst, Data Analysis, Data Migration, Cloud, Agile, Agile Software Development, T-SQL, Microsoft Excel, Linear Regression, Dashboards, Reports, Logistic Regression, Excel VBA, Leadership, Reporting, Data Modeling, ETL, Relational Databases, Visual Basic for Applications (VBA), Time Series Analysis
  • Software Development Manager

    2008 - 2014
    Wells Fargo Bank
    • Led team of 10 developers and analysts across software development, business intelligence and analytics in delivering key technology capabilities in the areas of customer relationship management, opportunity and prospecting, referral, cross-selling, payment tracking, contact management, organizational hierarchy, quarterly certification, and compliance reporting. Managed strategic roadmap for the wholesale CRM landscape. Set data modeling/governance/retention/quality standards. Oversaw the production support, BCP, performance monitoring, hardware and software upgrades, legacy systems migration, vendor evaluation, and technology selection process in collaboration with the business partner to support the rationalization of future technology investment.
    • Successfully led the systems integration of 20+ source systems with Microsoft Dynamics CRM to bring 12+ fragmented CRM efforts in two banks under one umbrella after Wells Fargo-Wachovia merger.
    • Initiated the segmentation analytics effort to identify customers in various growth segments and monitor the trend over time which helped the sales team optimize their resource allocation.
    • Spearheaded effort for interfacing with external and internal demographic, financial, market data sources into the tool to provide a 360-degree view of customers.
    • Mapped out and executed a proactive strategy for infrastructure monitoring and reporting system that improved process transparency among stakeholders, increased data congruency by 20% and customer satisfaction by 25%.
    • Designed and developed internal applications and portals to save at least 80% of manual processing time in some areas by analyzing various interdependent partner systems, internal workflow.
    • Developed and implemented a best practices rulebook, code review process, team wiki, and improved SLA significantly for production issues.
    Technologies: Microsoft Power BI, Visual Studio, Python, SSAS, SQL Server Integration Services (SSIS), SQL, Microsoft SQL Server, Data Engineering, Business Intelligence (BI), Data Analytics, Data Analyst, Data Analysis, Data Migration, Agile Software Development, T-SQL, Microsoft Excel, Dashboards, Reports, Excel VBA, Leadership, Reporting, Data Modeling, ETL, Relational Databases, Visual Basic for Applications (VBA)

Experience

  • Highly Flexible ETL Solution

    Developed a highly scalable and flexible metadata-driven ETL solution that provides auditability, configurability, graceful error handling, parallel execution, incremental data load, process orchestration and monitoring/notification enabling the data and analytics team to onboard any new source system without writing any new code and thus saving hundreds of hours.

  • Sell-Thru Data Pipeline and Reporting

    Built a reporting solution that ingests major retailer sell-thru data coming in a wide variety of formats with automated data quality check using statistical and set business rules, transformation of the data into a common format, calculated various metrics for sell-thru rate, weeks of supply, etc, designed and developed a dashboard showing consolidate views for all retailers and also individual retailers, identifying opportunity for the business and call for actions.

  • Reporting Solution for Discount Transparency

    Built a reporting solution to have transparency around product and service discount to government entities in different countries.

  • Reporting Solution for Order Pipeline

    Data pipeline, transformation, cube, and reporting to have a clear view of the order pipeline and also warehouse performance tracking.

  • Internal Compliance Application

    Developed an application that gathers various compliant information from clients based on their financial and business profile to make sure the organization is compliant with the Office of Foreign Asset Control.

  • Complex Email/Text Notification System

    A notification system using Azure Logic App, Enterprise Service Bus, and Queue to send custom emails and text message-based on configurations for an IoT solution.

  • Retail Store Sales Dashboard

    Built the data pipeline with multiple retail POS systems and traffic tracker systems, created the data transformation process, Power BI reporting and dashboards showing core retail KPIs (AUR, UPT, AST, Traffic Conversion, Net Sales, Net Sales/SFT, etc), Sales and Traffic Trend, Drill down report, store by store comparison report, and an amazing view using Visio visual in Power BI that shows which section of a store is performing how well on a store layout diagram.

  • Chatbot

    Built a chatbot using Azure and integrated it with Facebook Messenger to answer frequently asked questions about a website.

  • Report on Crowd Emotion, Gender, Emotion, and Age

    Implemented a reporting that takes photos as input and identifies all the faces in the picture, emotion, gender, age, facial features, etc. and displays that in a dashboard.

  • Sales Representative Performance tracking Dashboard

    Designed the data model and developed a data pipeline and a BI Cube with row-level security and designed and developed reports/dashboards to measure the monthly/quarterly/annual sales goal of a company's sales representatives.

  • Sales Campaign Effectiveness Report

    Designed data model, developed data pipeline and a report to measure the effectiveness of sales campaigns displaying the metrics for any selected campaign, the drill-down capability to see details sales information associated with the campaign, and also before and after picture of a campaign to understand the impact of it.

Skills

  • Languages

    SQL, T-SQL, Excel VBA, Visual Basic for Applications (VBA), Python, R, Python 3, Snowflake, C++, C, C#
  • Libraries/APIs

    Azure Blob Storage API, Azure API Management, REST APIs
  • Tools

    SSAS, Azure Logic Apps, Git, Bitbucket, Microsoft Power BI, Microsoft Excel, Jira, Jenkins, GitLab, GitHub, Microsoft Access, Tableau, Azure IoT Hub, Visual Studio
  • Paradigms

    Agile Software Development, Business Intelligence (BI), ETL, Agile, Data Science, Azure DevOps
  • Platforms

    Azure, Azure IaaS, Windows, Amazon Web Services (AWS), Google Cloud Platform (GCP)
  • Storage

    MySQL, SQL Server Analysis Services (SSAS), Azure SQL, Relational Databases, Microsoft SQL Server, Databases, Azure Blobs, Azure Queue, Data Pipelines, Distributed Databases, Azure Cosmos DB, PostgreSQL, SQL Server Management Studio, SQL Server Integration Services (SSIS)
  • Other

    Linear Regression, Logistic Regression, Cluster Analysis, Dashboards, Reports, Leadership, Reporting, Data Modeling, Data Analytics, Data Warehousing, APIs, Data Visualization, Data Analyst, Data Analysis, Data Migration, Data Cleansing, Data Cleaning, Azure Data Factory, Analytics, Cloud, Machine Learning, Decision Trees, Random Forests, Time Series Analysis, Data Engineering, Message Queues, CI/CD Pipelines, Computer Vision, Chatbots
  • Frameworks

    Spark

Education

  • Master's Degree in Business Administration
    2011 - 2014
    The Michael G. Foster School of Business, University of Washington - Seattle, Washington
  • Master of Science Degree in Computer Science
    2003 - 2005
    University of Southern California (USC) - Los Angeles, California
  • Bachelor of Science Degree in Computer Science and Engineering
    1995 - 2000
    Bangladesh University of Engineering & Technology (BUET) - Dhaka, Bangladesh

To view more profiles

Join Toptal
Share it with others