Salma Shaik

Collaborated with a top-tier global music company headquartered in Germany, specializing in song recording and publishing.

• Handled ETL processes to convert raw data into usable formats.
• Enabled seamless data integration by implementing automated DAG pipelines.
• Developed SQL procedures to integrate data into Postgres and BigQuery tables.
• Conducted in-depth analysis to identify and resolve issues.

• Facilitated business operations by introducing Looker Studio dashboards for streamlined revenue inspections.
• Developed a robust system called Backup Tool ensuring secure pre- and post-data storage.
• Implemented a tool for assessing the performance metrics of current versus conventional database systems.
• Devised BigQuery procedures, streamlining sync-up processes between the source and destination databases.

• Analyzed royalty data to ensure compliance with contractual obligations.
• Conducted runtime comparisons between traditional databases and cloud databases.
• Streamlined the audit process internally to prepare for external audits on the client company.

• Underwent a comprehensive training program consisting of two months of generic education, three months of specialized stream learning, and one month dedicated to a Capstone project.
• Generic: Python, DBMS.
• Stream (DNA): Java, Hive, Hadoop, PIG, Advanced SQL, UNIX, Power BI.
• Capstone Project: Extract data from UNIX shell to Hadoop, transform it using Hive queries, and load it into Power BI to build the dashboards for the analysis of cricket metrics.