Mohammed Shamshuddin

Project: HealthStream

Environment: DBT Tool, GitHub, Snowflake Cloud, Apache Airflow, AWS.

• Migrated data from SQL Server and Redshift to Snowflake using DBT and Apache Airflow for orchestration.
• Engineered data integration workflows in Python to fetch API data, enhancing ingestion and transformation processes.
• Designed and optimized DBT models for data pipelines, ensuring precise and efficient transformations.
• Migrated legacy Python scripts from AWS Lambda to Airflow, leveraging DAGs to handle complex dependencies and error handling.
• Conducted comprehensive unit testing and validation, confirming data accuracy between source and target systems.
• Identified and resolved performance bottlenecks, optimizing queries for improved execution speed in Snowflake.
• Collaborated with cross-functional teams, adhering to Agile methodologies for timely milestone delivery.
• Automated workflows with Apache Airflow, ensuring seamless execution of data pipelines.
• Prepared detailed documentation for processes, test cases, and deployment steps for project sustainability.

Project: 24-Hour Fitness

Environment: DBT Cloud, GitHub, Snowflake Cloud.

• Enhanced extraction processes by executing diverse data pull requests on Snowflake Cloud.
• Implemented strategies for incremental loading, significantly improving retrieval performance and cutting processing time.
• Led migration projects by updating sources and targets in DBT models as well as Snowflake.
• Maintained data integrity throughout migration by resolving mapping challenges promptly.
• Conducted rigorous quality assurance to ensure reliability of data through thorough testing procedures.
• Collaborated with teams to identify and implement enhancements in data models for better analytics.
• Served as a key resource for development by maintaining comprehensive documentation of changes.
• Facilitated knowledge sharing via detailed documentation on Confluence.

Project: Future Group.

Environment: Informatica PowerCenter 10.0.x, DBT Tool, AWS Redshift, DataSync ETL Tool.

• Collaborated with internal teams to analyze existing data landscape and ETL processes.
• Engaged cross-functional teams to align business requirements with data integration goals.
• Conducted thorough data analysis, validating information and communicating findings promptly.
• Implemented data quality checks to enhance accuracy and address discrepancies proactively.
• Managed customer communication during ETL failures, resolving inquiries and escalations effectively.
• Provided regular updates to customers, ensuring transparency throughout resolution processes.
• Diagnosed software and system issues, applying troubleshooting skills for quick resolutions.
• Monitored file transfer activities via FTP and SFTP, ensuring secure and efficient data exchanges.

Project: Love's

Environment: Data Sync ETL, SSIS, AWS Redshift.

• Analyzed existing data landscape and ETL processes with internal teams.
• Validated loaded data and communicated results to relevant teams.
• Resolved customer inquiries and escalated issues during ETL failures until resolution.
• Diagnosed and resolved software, network, and system problems efficiently.
• Monitored file transfer activities via FTP and SFTP protocols.
• Raised priority tickets and coordinated with senior team for swift issue resolution.
• Configured and managed connections in DataSync and Informatica environments.
• Triggered reports and updated clients upon ETL completion.