Syed Imad Husain Email & Phone Number

New York, NY, US

• Leading DE team of 8 to build & maintain various types of data pipelines in GCP like streaming, API, batch, flat files, relational, etc.
• Implementing & Maintaining technical designs & analytical solutions in GCP using BQ, Composer, Apache Airflow, Python & Shell
• Identifying & Executing process improvements for the entire Analytical Ecosystem to ensure high scalability & sustainability
• Collaborating with Report Developers to enhance BI architecture & improve users’ experience in Tableau, Looker & Power BI
• Building rapid prototypes & performing POCs to assess feasibility of new analytical requirements while ensuring integrability

Seattle, WA, US

• Supervised off-shore BI team of 10 catering to varied ETL & Reporting requirements in Hive, GCP, Looker & Tableau
• Designed data models & pipelines for real-time clickstream data & integrated with batch-processed data in Hive & GCP
• Implemented & Designed frameworks & standards for CICD practice and Hadoop to GCP migration (front & back end)
• Developed & deployed Data Science models to support Experimentation, Targeting, Customer Churn and other analyses

Seattle, WA, US

Seattle, WA, US

• Designing data pipelines leveraging Big Data Analytics and SQL to create and maintain the data warehouse for the client on Apache Hive
• Creating data pipelines using Python, Shell Scripting and SQL on Hortonworks Hadoop Framework serving the digital marketing team
• Integrating new data feeds like external data files and API calls with existing Data warehouse in Hadoop using Hive Query Language, JSON and Python
• Creating data models to ensure that the resulting data-warehouse is robust and has no redundancy using Dimension Modeling
• Automating execution of data pipelines, data mining programs, report generation, and migration using third party tools like Crontab, Control-M and Airflow
• Migrating in-house Hadoop cluster to Google Cloud Platform using Shell and Python

Cincinnati, Ohio, US

• Directly working with Donor Services to identify & prioritize Analytical needs
• Data Wrangling for complex relational data sources using SQL
• Performing Machine Learning, Advanced Analytics using R, Python for Blood Demand & Donor Retention Analysis
• Developing Tableau Dashboards and reusable analytical products for Donor Services

Cincinnati, Ohio, US

• Lead Data Analyst managing team of 4
• Directly worked with Operations' Decision makers to identify key areas of interests
• Created Project artifacts like Status Reports, Work Breakdown Structures, etc.
• Developed Business Analytics Framework for meeting ad-hoc requirements
• Developed Tableau Dashboards for Donor Services
• Mobilized Stakeholders to explore the avenues of Data Science

Washington DC, VA, US

• Customer Analytics – PPL Electric Utilities (Pennsylvania Power and Light)Enables Business to derive a holistic view of their Customers with Satisfaction Index being the driving KPI
• Gathered Analytical requirements while working closely with business users on 4 major subject areas
• Designed & integrated Customer Data Model, 4+ heterogeneous data feeds, 30+ new entities & ETL processes
• Designed & developed Reporting Architecture, Entities, Attributes & Metrics on Snowflake & Star Models in MicroStrategy
• Performed customer segmentation using unsupervised learning (mixed data, K-medoid) to identify high risk customers based on billing, usage, surveys, communication channels, demographics & geographyDetails -Gather.

Washington DC, VA, US

• Delivered, Organized & facilitated 50+ lectures to college graduates & laterals on SQL, Data-warehousing, ETL & Reporting
• Mentored 4+ Business Analyst Interns’ teams(sized ~6) comprised of college under-graduates
• Conducted 3+ training sessions for new Trainers and revamped Course material based on trainees’ feedback

Washington DC, VA, US

• Supply Chain Analytics – PPL Electric Utilities (Pennsylvania Power and Light)Enable Business to perform ad-hoc Analysis on Inventory related data generated by an Enterprise wide Asset Management Application
• Developed supervised learning model (ensemble technique) to predict completion time for active work orders
• Reviewed & Optimized Star-Data Model involving 70+ tables sourcing from Asset Suite (Enterprise Asset Management)
• Created 5+ managerial artifacts - Functional Specification, Work Breakdown, Trace-ability & Business Matrix, Estimations, etc.
• Managed Resource Allocation & Task distribution for a team of 6 Associates
• Designed and developed ETL processes, Data Lake (Data Federation Layer), Data governance and security modules

Washington DC, VA, US

• Operations & Assets Analytics – PPL Electric Utilities (Pennsylvania Power and Light)
• Created Functional Requirements & other artifacts like Run books while working closely with Business Analysts
• Designed, Developed, Tested & Deployed ETL Solutions & Operational Analytical reports in Microstrategy involving 50+ tables
• Monitored, Optimized, Supported, Automated Grooming & Enhanced code for 25+ legacy systems & 5+ subject areasDetails -
• Enable Business to perform Analysis on multiple subject areas within the Energy domain with primary focus around Assets and Outages. Below is a comprehensive list of subject areas worked upon Assets’ Maintenance.
• Enable the Legacy systems to run smoothly by supporting ETL code and fixing Production failure. This Project deals with various tools from multiple platforms:Monitoring and support of legacy systems Perform detailed.

Washington DC, VA, US

BI Trainee | InfoCepts BootCampSQL Essentials course and project Introduction to Data Warehousing and conceptWeb Programming Basics – HTML, CSS, Flex and JavaScript Data Quality courses and project Linux Essentials Course ETL Concepts, latest trends Data Integration project using Informatica PowerCenter 9.5.0 MicroStrategy Business Intelligence.

Master Of Science - Ms, Business Analytics

Bachelor Of Engineering - Be, Mechanical Engineering

High School/Secondary Certificate Programs