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• Performing gap analysis, analyzing distinctions, re-designing existing ETL flow and migrating Click stream data pipelines for Digital Marketing from IBM Core-metrics to Adobe Analytics with an overall aim to improve data accuracy and process efficiency• Establishing guidelines and standards for overall development and deployment using Git and Jira to implement Data Governance and CICD (Continuous integration Continuous Deployment) aimed at increasing the operational efficiency• Collaborating with Business Users to understand key delivery aspects like service level agreements around data latency and data cadence along with gathering requirements• Collaborating with Business Analysts to review Business requirement documents and convert them to functional requirement documents• Collaborating with Data Visualization experts to optimize ETL process according to front-end reporting using Tableau

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 requirements from Business Users and Analysts around Design new entities confirming to Enterprise Data Warehouse (EDW) standards Integrate entities into the existing EDW Validate Model against the Business Requirement Document (BRD) Design ETL (Extract-Transform-Load) Process Prepare Data Federation Layer Create ETL Design Specifications (Specs) Coordinate Schema/Application Object design & implementation in MicroStrategy (MSTR) Data preparation like regularization of continuous variables for Model building in RBuilding customer clusters using K-medoid algorithm on dissimilarity matrix based on Grower's distanceIdentifying Optimal number of clusters using elbow, silhouette and gap statistic methodsCalculating metrics like average electricity consumption for each cluster to gain insights in usage patterns

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• Created reports and objects in Tableau based on specific requirements Details:Gather BRD from Business AnalystConvert BRD into Functional Requirement Document (FSD)Verify Model received by Data Modeller with FSDCreate Estimates and Project planAllocate/Manage ResourcesCreate Work Breakdown Structure and maintain the sameCreate Requirement Traceability Matrix (RTM) based on BRD and FSDCreate Source-Target Mapping SpecsDesign and develop ETL ProcessDesign and develop Data Replication ProcessCreate Linux scripts for scheduling and loggingCreate Unit test-cases and validate codeFix bugs reported by Quality Assurance Team (QA)Migrate code to higher environmentsCoordinate Schema/Application Object design & implementation in MSTRData preparation in R for analytical model buildingExploratory Data Analysis to gain intuitions about dataFeature selection using Lasso Model building for predicting continuous response Time with cross validation Model Evaluation using cv-score and residual analysisModel Deployment for usage by business team

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, Outage Survey, Work Order Forecast and Outage Coordination:Gather BRD and FSD from Business Analyst/Modeler Create high level Estimates and Project plan Create Source-Target Mapping Specs Design and develop ETL Process Develop Replication Process (if applicable) Create Linux scripts for scheduling and logging Create Unit test-cases and validate code Migrate code to higher environments Create Run-books and other maintenance documents Validate Schema/Application Objects in front-end MSTR See less• 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 Impact and Dependency Analysis Performance Tuning of Existing ETL and Database code Informatica and IBM IDR upgrade and migration Support server migration and patching Informatica and IBM IDR Administration Informatica and Database Object Assessment and Purge Analyse recurring failures for permanent fixes Analyse MSTR Reporting issues to identify root cause  Create and implement processes for smooth functioning of Environment Database object design, development and maintenance for Enhancement

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 Platform 9.x

Master Of Science - Ms, Business Analytics

Bachelor Of Engineering - Be, Mechanical Engineering

High School/Secondary Certificate Programs