Sadaf Kassim Ahmedi
New Delhi
Summary
Highly experience Data Engineer within well known Investment Bank. Overall 6+ years of experience in Advance SQL, Data Architecture, Data Extraction, Transformation & Loading, Data Marts, Dimension modelling, Snowflake, Python, Kafka, Autosys and optimizing query performance including the ability to communicate complex data to non technical audiences.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Director
Morgan Stanley
Mumbai
01.2021 - Current
- Primarily focused on building processes for data archival, data purge, data recovery, data distribution across on-premises and cloud platforms, data replication, fixing data quality for the business users to function, troubleshooting, and optimization of SQL queries to meet the firm's analytical and reporting needs.
- Guided the implementation of strategies designed to achieve planned goals.
- Performed monthly and quarterly reporting of achievements of the team, and communicated performance metrics to the higher management effectively.
- Assigned task and reviewed team members' work.
- Developed Python multiprocessing-based scripts for data archival, data purge solutions, and automated jobs using the Autosys scheduler.
- Collaborated with the team to perform data replication from on-premises to the Snowflake cloud using the third-party tool HVR and Kafka concepts.
- Worked on different databases: Sybase ASE, Greenplum, Snowflake, and MS SQL.
- Delegated daily tasks to team members to optimize group productivity.
Sr Consultant
PwC
Mumbai
01.2019 - 01.2021
- Served as an ETL developer by implementing Staging, Operational Data Store, and Integrated Data Layer as a part of DwH for a leading non-banking financial client in India.
- Dealt with huge data sizes to bring into the data warehouse from upstream and push the same to downstream based on the given logic.
- Assisted with the development of the data model(s).
- Served as a Team Leader of a team of around 15 employees in an insurance project.
- Performed end-to-end development of Regulatory Report Automation.
- Implemented a number of stored procedures using MS SQL dynamic SQL to load data from various source systems to the data warehouse.
- Built dynamic scripts to migrate data and workflows between servers.
- Worked on various data based technologies - MS SQL Server, SSIS, Stored Procedures, python
Software Engineer
LTI
Mumbai
01.2016 - 01.2018
- Served as a business analyst in Reporting by analyzing the business KPIs and generating insights using MS Power BI & MSBI for Leading Media & Entertainment Client in India
- Performed reporting and dash boarding based on requirements in MS Power BI (desktop, android & iOS)
- Built and configure BI reports/dashboards by connecting to data in import/direct mode using interactive visuals and dynamic filters
- Created Content Packs for different group of Users and Distribute reports through Content Pack
- Implemented Row Level Security in Power BI to restrict data access for given users
- Technology: MS Power BI Pro, Azure Hdinsight Cluster, Azure Datawarehouse, Scala
Education
BE with Distinction - Computer Engineering
VESIT
Mumbai01.2016
Diploma - Computer Engg
M.H. Saboo Siddik College Of Engineering
Mumbai01.2013
Skills
- SQL
- Database
- Python
- Snowflake
- Data warehouse
- ETL
- Development
- Dim Modeling
- Performance Optimization
- Autosys
- Troubleshooting
- Zapp
- Git
- Unix
- Shell
Certification
- Power BI, Intensive course offered by Microsoft.
- ORACLE 10g PL/SQL Certified, On-job training.
Languages
- English, Proficient
- Hindi, Native
Awards
Individual Innovation Award at Super Department Level, 2024
Passions
- Data Driven Decisions
- Learning New Technologies
Methodology
Agile Software Development Life Cycle
Timeline
Senior Director
Morgan Stanley
01.2021 - Current
Sr Consultant
PwC
01.2019 - 01.2021
Software Engineer
LTI
01.2016 - 01.2018
BE with Distinction - Computer Engineering
VESIT
Diploma - Computer Engg
M.H. Saboo Siddik College Of Engineering
Similar Profiles
SAPNA SHARMASAPNA SHARMA
Sourcing Manager at Morgan StanleySourcing Manager at Morgan Stanley
Michael RedigerMichael Rediger
Operations Specialist at Morgan StanleyOperations Specialist at Morgan Stanley
Meeta VermaMeeta Verma
Director at Morgan StanleyDirector at Morgan Stanley