Data and Analytics Lead + Architect
2016 - PRESENTA $1 Billion Company Known for Creating Licensed Pop Culture Products- Headed the end-to-end implementation of an enterprise data warehouse, 100+ analytics reports and dashboards, seven data applications including setting up strategy and roadmap, gathering and analyzing requirements, setting up infrastructures, data pipeline, data modeling and transformations, job scheduling, monitoring and notifications, security model, cubes, visuals, and collaboration workspaces to serve users across the USA and Europe.
- Integrated with multiple ERP systems, retailer-supplied sell-thru data, eCommerce platforms, dozens of spreadsheets and flat files, third-party APIs, Social Networks, Active Directory, Contract Management System, various cloud services and so on to feed into the Enterprise Datawarehouse.
- Developed a highly scalable and flexible metadata-driven ETL solution from scratch that provides auditability, configurability, graceful error handling, parallel execution, incremental data load, process orchestration, and monitoring/notification enabling the team to onboard any new source system without writing any new code and thus saving hundreds of hours.
- 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 improvement over time also notify users of any critical data quality issues.
- Created a hierarchical enterprise KPI blueprint including the guiding principles for implementation following KPI best practice from Gartner, SCC, PDMA, Six Sigma, APQC, and so on that focuses on leading indicators to measure the demand, supply, and support services performance of any business.
- Led and facilitated the creation of guiding principles in the domains of business, information, application, technology, integration and security; and worked with the CIO to establish an intake and review process following those principles to guide enterprise architecture decision making through an architecture review board (ARB).
- Established the best practice guidelines for dimensional data modeling for consistent data products, naming convention and data dictionary for easy data discovery, code and release management for faster and quality delivery, analytics server configurations for best performance and security, and cloud migration for scalability.
- Established 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.
Technologies: SQL, SSIS, SSAS, Python, Visual Studio, Power BI, Azure - Chatbot, Computer Vision, Logic Apps, Spark, Cosmos DBAnalytics Consultant
2014 - 2016Microsoft 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: SQL, SSIS, SSAS, Python, Visual Studio, Power BISoftware Development Manager
2008 - 2014Wells 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: SQL, SSIS, SSAS, Python, Visual Studio, Power BI
Anwar Hossain
Machine Learning Developer in Seattle, WA, United States
Member since August 27, 2019
Anwar has 19+ 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. He 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
- A $1 Billion Company Known for Creating Licensed Pop Culture ProductsSQL, SSIS, SSAS, Python, Visual Studio, Power BI, Azure - Chatbot...
- Microsoft CorporationSQL, SSIS, SSAS, Python, Visual Studio, Power BI
- Wells Fargo BankSQL, SSIS, SSAS, Python, Visual Studio, Power BI
Experience
- SQL 19 years
- Machine Learning 10 years
- Azure 10 years
- R 6 years
- Python 3 3 years
Availability
Part-time
Preferred Environment
Windows, Visual Studio, MS SQL Server, SSMS, Azure
The most amazing...
...experience was building a data platform for a $800 million business to enable decision making for people working at the operations up to the executives.
Employment
Experience
- Highly Flexible ETL Solution (Development)
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 (Development)
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 (Development)
Built a reporting solution to have transparency around product and service discount to government entities in different countries.
- Reporting Solution for Order Pipeline (Development)
Data pipeline, transformation, cube, and reporting to have a clear view of the order pipeline and also warehouse performance tracking.
- Internal Compliance Application (Development)
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 (Development)
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 (Development)
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 (Other amazing things)
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 (Other amazing things)
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 (Development)
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 (Development)
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, R, Python 3, C++, CTools
Git, Bitbucket, Microsoft Power BI, Jenkins, GitLab, GitHubParadigms
Agile Software Development, Business Intelligence (BI)Platforms
Azure, Amazon Web Services (AWS), Google Cloud Platform (GCP)Storage
SQL Server Analysis Services (SSAS), MySQL, Azure Cosmos DB, SQL Server Integration Services (SSIS)Other
Linear Regression, Dashboards, Excel, Reports, Machine Learning, Logistic Regression, Decision Trees, Random Forests, Cluster Analysis, Time Series Analysis
Education
- Master's degree in Business Administration2011 - 2014The Michael G. Foster School of Business, University of Washington - Seattle, Washington
- Master of Science degree in Computer Science2003 - 2005University of Southern California (USC) - Los Angeles, California
- Bachelor of Science degree in Computer Science and Engineering1995 - 2000Bangladesh University of Engineering & Technology (BUET) - Dhaka, Bangladesh
