haymang ahuja

Responsible for developing Data Integration, Data Modelling and Data Warehousing, and therefore solving Reporting, Analytics and BI.

Tech Stack - AWS Glue, Python, Amazon Redshift, MySQL, PostgreSQL, Pyspark, Apache Spark, Tableau, GIT

• Develop ETL pipeline for integrating multiple data sources.
• Design conceptual data model based on the requirement. Interact with non-technical end users to understand the business logic.
• Collaborate with cross-functional teams to design data warehouse and incorporate legacy data.
• Discuss the Data model, data flow and data mapping with the application development team.
• Create push and pull BI reports and Dashboards for Business and stake holders.

Led the ETL team responsible for developing data pipeline and data warehouse for 2 market leading pharmaceutical clients. Both the projects strictly followed Agile framework with regular Scrum calls and stand-ups.

Tech Stack - Talend, Amazon Redshift, Spark SQL, SQL, JSON, GIT, JIRA, Tableau

Key Learnings - Data Warehousing, AWS Cloud Computing (Pricing, Cluster deployment, maintenance), POC on GCP (Google cloud platform), BI Reporting & Analytics, Database Performance & Query Tuning, Data Integration.

• Configured and deployed AWS EC2 Hadoop cluster for spark processing.
• Designed and implemented Data integration pipeline.
• Prepared SCD implementation logic in JSON format to be processed with spark SQL.
• Brain storming sessions with client requirement gathering and BI reports development.

Worked on Reporting, BI and Analytics. Developed reports and dashboards for major UK bank.

Tech Stack - OBIEE, Oracle 11g, Informatica Powercenter, JIRA, HP Quality Assurance, SQL

Key Learnings - Advanced Reporting & Analytics, Data Migration, Data Integration, Operational Reporting,

• Developed data integration workflows in Informatica Powercentre.
• Crafted physical, logical and presentation layers in OBIEE repository.
• Produced business reports and dashboards in Oracle Business Intelligence Enterprise Edition (OBIEE)
• Unit testing and report review and released for ST/TSIT.

78%

84%