Nagma Uppunoothula

Project name : Lotus Notes
Client : HSBC
Environment : Power Bi, SQL

Description:

HSBC(Hongkong and Shanghai Banking Corporation) is a financial services group and universal bank with headquarters in London, England. HSBC offers a variety of services, including Savings accounts, Wealth management, online and self-service banking & investments etc.,

Roles and Responsibilities:

• Experience in creating dashboards, reports, presentations, graphs, and different visualizations like line, bar, histograms, tree maps, scatter, etc.
• Responsible for analysis, data validation, and submission of business review reports on a weekly and monthly basis.
• Experience with DAX, Power Query, Power Pivot, Power View, and Power BI service tools.
• Understanding of ETL/ELT concepts, basic experience with Informatica and SSIS.
• Strong knowledge of SQL, query optimization, and experience with relational databases (e.g., SQL Server, MySQL).
• Developed store procedures, triggers, functions, and database tables in the SQL database.
• Developed a Canvas Application in Power Apps using Dataverse and model-driven architecture. Added views and forms, and also worked on business rules, workflows, and implemented audits for AD groups for security roles.
• Created Workflows using Power Automate for triggering emails to teams.
• I worked on the Cybersecurity SNOW request governance activity.
• Created detailed documentation on the application that I worked on, and presented a PPT to the client.