To join a highly professional team in the field of Computer Science, Business Intelligence, Database development and Data Warehouse/Power BI development in order to enhance my knowledge and professional abilities within a dynamic and progressive environment where sincerity, dedication and the ability to manage tasks effectively are pre-requisite in driving the organization forward.
Developing SPs, Reports, Views
Resolving SQL related issues and tickets
To Support Developers in building SQL development
writing stored procedures for report generation in SQL Server
Modifying existing ETLs
Developed, monitored and deployed SSIS packages.
Developed, monitored and deployed SSIS packages.
Enhanced and deploying the SSIS Packages from development server to production server.
Maintaining and updating Data-Mart
Created SSIS packages to extract data from OLTP to OLAP system
Expertise in creating ETL packages using SSIS to extract data from heterogeneous database and then transform and load into the data mart.
Scheduled the ETL Process using Jobs.
Presenting information through reports and designing, developing and maintaining business intelligence solutions
Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data
Involved in creating new stored procedures and optimizing existing queries and stored procedures
Wrote stored procedures for report generation in SQL Server
Prepare daily, weekly, monthly management reports in Power BI
Design, build and deploy BI solutions (e.g. reporting tools)
Importing data from SQL Server DB, Excel file, Csv file
Developing SSIS Packages and SSRS reports
Developing incentive structure Stored Procedures
Processing incentive of whole Silk Bank SEs, RMs, ASMs and NSM
Generate weekly and monthly basis SSRS reports
Analyzing of different reports
Conduct unit testing and troubleshooting
Daily Analyze and generate reports on specific requirements for the business decision
Support financial reconciliation
Daily solve the quires of students
Writing different queries for collecting data and from that data generate reports for information of higher authority for making decisions
Generate Quarterly report of Hamdard University for higher authority and HEC
Generate Yearly progress report of Hamdard University for higher authority and HEC
Attend and arrange meetings, conferences and seminars regarding Improving the Quality of Education of Hamdard University and Ranking in HEC
Link Building, Backlinks, Web2.0, Forums, Social Marketing