320126510L12 patanmeerjamoinuddinkhan

Trainee decision scientist

MuSigma•  July 2023 - April 2024

• Orchestrated seamless automated data migration processes for a leading American retail store resulting in a 10% year-over-year revenue increase, across 1010data, Oracle DB, GCP, and Snowflake platforms, utilizing SQL, Python, XML, Shell, and Linux commands. • Engineered, tested, and scheduled ETL pipelines, facilitating data transformation and migration at predetermined intervals, thereby enhancing operational efficiency. • Diagnosed and resolved bugs in Python scripts causing production failures in systems responsible for data transfer to the Snowflake database. • Conducted comprehensive end-to-end testing to ensure seamless functionality, contributing to a 15% increase in overall data accuracy. • Analyzed and addressed data intricacies before pipeline setup, proposing solutions for complex scenarios, and establishing standard QC templates and unit test plans to ensure data quality and integrity across the team. • Created data flow diagrams and process flow diagrams to illustrate how data pipeline function, providing visual representations of the flow of data through various stages and processes. • Developed data visualization dashboards to provide actionable insights and support decision making analytics, leading to a 20% improvement in operational decision-making efficiency.