Danish Malik Email & Phone Number

London Area, United Kingdom

London Area, United Kingdom

Automating data flow tasks using python.Writing SQL scripts for transformation of data and applying the business rules in codes.Creating data models and data warehouse using Star schema.Creating and maintaining ETL data pipelines.Reduced the cloud query execution costs by 40% using performance tuning and query optimisation techniques.Created table indexes.

Noida, Uttar Pradesh, India

• Partner with stakeholders to define data and reporting requirements.
• Help our business users learn to self-serve for their analytics and reporting needs, primarily leveraging Power BI.
• Understand business requirements and convert them into detail technical specifications for Data models and ETL programs.
• Design the Logical and Physical data models.
• Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.
• Implement multiple Automation jobs through Python scripts.

Gurugram, Haryana, India

• Writing SQL scripts for transformation of data and applying the business rules in codes.
• Programming views, stored procedures, and functions.
• Creating table indexes to improve database performance.
• Develop database schemas, tables and dictionaries.
• Take regular database backup, test databases and perform bug fixes.
• Provide authentication and authorizations for Database

Delhi, India

• Provided client with dashboards, reports and engaged with client’s business team to provide results and to interact with different data providers.
• Interpreted data, analyzed results using statistical techniques and provide ongoing reports using Power BI, Excel, T-SQL.
• Statistical analyses on financial data to help client in investing money on profit-making portfolios and activities.
• Written T-SQL scripts to manipulate data for data loads and extracts.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Developed ETL package using Microsoft SSIS to move data from unstructured data sources like Csv’s, Flat files, Excel into SQL server database (History load).