Shashwat Roy

Project: First Abu Dhabi Bank - OneMI

• Handled Daily and Monthly Load data through ETL (through Informatica) and finally getting the data reflected in Power BI dashboard so that business could take next steps based on their reports.
• Developed good SQL skills as the PII data was stored in on-premise Oracle SQL and non-PII data used to store in Azure.
• Helped in improving SQL query performance by analyzing the SQL script
• Have also worked in developing Power-BI Paginated report. Knows
• Basics of Power-BI as Dashboard deployment, App creation, Row Level Security filters creation and testing was done by our team
• Also have worked on developing Logic apps workflows to automate task like generation of around 8000 Power BI Report exports, Updating databases etc
• Have also basic understanding on Informatica as our team has to understand how the data is flowing and fix error in production incase of data related issue.
• Proven ability to develop and implement creative solutions to complex problems.
• Gained strong leadership skills by managing projects from start to finish.
• Demonstrated a high level of initiative and creativity while tackling difficult tasks.
• Worked effectively in fast-paced environments.
• Proved successful working within tight deadlines and a fast-paced environment.
• Self-motivated, with a strong sense of personal responsibility.