M. Methu Shelah

• Education Management System is a government project which manages one complete state education system called Iowa
• This project consists of different subject areas like Staff, Physical Fitness and Discipline etc
• This contains all student information in all schools in all districts
• Assessed platform statistics to create customized, data-intensive BI analytics.
• We receive all subject areas data in the form Excel and flat files which loaded into the Database schemas
• The schemas are designed for subject areas
• All subject areas are logically related

Roles and Responsibilities:

• Extensively worked in data Transformation and Loading from staging layers to target Stored procedures
• Batch wise loading has been implemented to load large size data sets
• Developed ad-hoc reports based on the requirement of the clients using Power BI
• Exclusively worked on developing dashboards, pages using cards, bar charts and line charts as per the requirement
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Wrote and optimized SQL statements to assist business intelligence practices.

• RBS Bank System has different products like Accounts, credit cards, personal loan etc
• The data ware house maintenance the client information like customer profile, credit grade, banking location and the details about which programs the client has been enrolled
• Performing regular data loads and data validation, production support and monitoring the load activities
• Resolving the defect tickets and designing data marts for business
• So the Bank wanted a Single Window Business Intelligence Application for Bank's Operational Efficiency
• This project is to provide different reports for making intelligent decision on RBS based on data available in various branches across the worldwide connected over a period of time

Roles and Responsibilities:

• Designing database tables and structures
• Writing optimized SQL queries for integration with other applications
• Write optimized queries, views and triggers for integration with other applications
• Fix any issues related to database performance and provide corrective measures.