حسين دهيلاوالا

Responsibilities -
• Led cross-functional teams of 30 engineers, providing mentorship, guidance, and professional development to enhance technical skills and foster a collaborative environment.
• Developed and implemented the technical roadmap in alignment with organizational goals, ensuring continuous improvement and innovation within the chapter.
• Responsible for Building (from ground) and Managing Operational Team to offload Operational work from delivery team.
• Promoted and enforced best practices in coding standards, testing, and continuous integration, leading to a 30% improvement in code quality metrics.
• Responsible for Design and Development of Data Pipeline Patterns.
• Responsible for performance optimization of the ETL jobs.
• Responsible for Strategy & Automation solution for Several Migration Initiatives (One Data Lake, Netezza -> Oracle Exadata, etc.).
• Championed a culture of innovation by encouraging the exploration of new technologies and techniques, leading to the adoption of several initiatives, which improved team efficiency by 40%.
• Managed resource planning and allocation across multiple projects, ensuring optimal utilization of skills and timely delivery of high-quality solutions.
• Acted as the primary liaison between product teams, stakeholders, and chapter members, ensuring seamless communication and alignment on project objectives.
• Facilitated Agile practices within the Squad, including sprint planning, daily stand-ups, and retrospectives, resulting in a 15% increase in team productivity.
• Conducted regular performance reviews, set clear goals, and provided constructive feedback, contributing to the professional growth and engagement of chapter members.
• Led the recruitment process for new chapter members, from interviewing candidates to onboarding, ensuring a smooth integration into the team and alignment with the chapters culture.
• Involved in the strategy discussion on cloud migration of on prem data lake to GCP and for analytical pipeline towards GCP to load into Big Query in GCP platform. Key Highlights -

• Managed processing 120+ system of records, making us the most responsible squad in the tribe of 28+ squads.
• Responsible for guidelines, delivery, and operations for all the System of Records ingesting data into Esperanto (Banking Data Warehouse model), which involves collaborating and leading 12+ squads to get around 600+ flows delivered.
• Torchbearer and front runner for start of any new implementation within tribe, be it for Information store (file to data lake) or Esperanto (integration within data lake)
• Implemented smart and intelligent scripting helping to reduce the processing times of data migration drastically from 2880 min to 20min and achieving more accurate result as compared to stacked migration.
• Increased reliability of Esperanto data by developing a framework which executes ~3000 test to ensure quality and report for bugs.
• Innovated monitoring solution to keep an eye on effective loading of 120+ System of records and 600+ Esperanto flows via email report.

Responsibilities -
• Responsible to gather and analyze requirement from business users for ETL implementation.
• Responsible to documented low level design for ETL mappings to cater business requirements.
• Responsible to develop complex, cost effective ETL mappings as per Design.
• Responsible to prepare release notes and code package to ease the deployment process.
• Responsible for support to critical production issues.

Key Highlights -
• Proud member of Agile PoC team within Base Company, which led to the agile revolution within Base Company and making us a brand ambassador of Agile methodology within the company.
• Spearheaded team of 6 amazing technologist in bi-weekly sprints, delivering 12+ DW implementation and achieving 96%+ on various metrics of Agile like Velocity and Predictability
• Achieved a Savings of 3 Man-days per data vault implementation, by implementing ingenious generalized loading mechanism.
• Design and developed innovative and out-of-Box solution to ingest huge, structured data and reducing processing time from 480 min to 8min.
• Design and developed generic file ingestion framework which helped to save 75 Man-days in setting up 25+ file ingestion to ODS.
• Brought savings of 800k Euros which was estimated for migration of 750+ OWB map to Informatica mappings by scripting the transformation in most innovative way.

Responsibilities -
• Responsible to gather and analyze requirement from business users for ETL implementation.
• Responsible to documented low level design for ETL mappings to cater business requirements.
• Responsible to develop complex, cost effective ETL mappings and Teradata Scripts as per Design
• Created Teradata utilities viz. (FLOAD, MLOAD, FEXPORT, etc.) to implement fast effective loading and improve performance wherever required.
• Expertise in performance tuning. Tuned several queries from business users which were executed frequently and helped in performance improvement.
• Responsible to prepare release notes and code package to ease the deployment process.
• Responsible for support to critical production issues
Key Highlights -

• Designed and implemented breakthrough data ingestion automation to save 730 Man-days/year and achieved 96% accuracy against 74% accuracy of manual process.
• Achieved 97%+ in KPI for timeliness and accuracy in Report delivery by developing a framework delivering automated reports.
• Reducing efforts drastically to process Police CDR Request from 6 Man-days to 0.5 Man-days to process daily 250+ Request by developing an out-of-Box framework solution.