Anwar Basha

• Implementing and Managing ETL solutions and automating operational processes.
• Experience in cloud computing on Google Cloud Platform with various technology like Data Fusion, Big Query, Cloud Secrets, Data Proc, CMEK Key management, Google Cloud Storage, IAM permission management and all DW related GCP tools.
• Developed and managed Cloud Data Fusion instances and Data Proc clusters, constructing CDF pipelines aligned with business needs. Utilized Dynamic wrangler for extraction and transformation, efficiently loading data into Big Query.
• Extensive experience of Agile scrum framework, Co-ordinating and facilitating Scrum ceremonies - Daily scrum, retrospective, backlog grooming, sprint reviews/sprint planning sessions.
• Good exposure to each of the phases of Software Development Life Cycle (SDLC), Agile Methodology, developing projects from stage of concept to full implementation.
• Proficient in ETL (Data Extraction, Transformation & Loading), DataStage PX, UNIX Shell Scripting, Database – Oracle, SQL, Big Query and Data Warehousing Concepts.
• Extensively worked on Data modelling concepts like Star, Snow and Data Vault models.
• Proven data modelling expert with a track record of success in implementing star, snowflake and Data Vault model's, ensuring robust and efficient data structures for enhanced business intelligence and analytics.
• Managed Code artifacts and CI/CD using tools like Git, Jenkins, Nexus, Google Secret Manager etc.
• Optimized data view for specific visualizations use cases making use of schema design partitions, indexes, down-sampling, archiving etc to manage trade-offs such as performance and flexibility.
• Led successful evergreen projects fro Unix, Oracle and IBM Datastage, overseeing the entire process from Ordering servers to configuring and conducting network testing, including roleswap.
• Played a pivotal role in ensuring seamless transitions by obtaining approval for Non-Function Requirement's (NFR's) before go live phase.
• Demonstrated expertise in managing and upgrading critical systems, showcasing comprehensive ownership of evergreen projects.

Developing and modifying Oracle PL/SQL Procedures, Functions, Cursors and Packages.

Built Dynamic SQL Loaders to read files and load into tables.

Developed Shell Scripts to automate PL SQL Scripts.

Experience of creating tables, Global Temporary Tables, views, materialized views, constraints, indexes, synonyms and sequences.

Experience in writing complex SQL queries.

Hands on experience in performance tuning and query optimization.

Capability to track the effective problems or bugs in SQL, PL/SQL and UNIX

Team mentoring, deployment, monitoring and development.

Defining best practices for project support and documentation.

Producing regular, comprehensive status reporting at appropriate levels.