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 to improve query performance by 70%.Creating database schemas, tables, views, stored procedures, indexes.Creating dashboards and ad hoc reports using PowerBI and Excel.

•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.•Load data from different data sources (AWS Redshift, Snowflake, Excel, Flat files etc.)•Utilize an advanced understanding of multiple data structures, sources, and tools to guide business partners in the development of self-service analytics, which include data visualization, business intelligence and data collection.•Created Multiple Power BI dashboards, ad hoc reports and on demand analyses for senior management and clients.•Understanding of Snowflake cloud data warehouse.•Experience with Snowflake cloud data warehouse for integrating data from multiple source system which include loading Parquet and Avro files into snowflake table.

•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•Design & Development of Dashboards on Excel according to the user’s requirements.•Performing ETL, data modeling, report designing, dashboard designing.

•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).