Imtiaz Mohamed (Mir) Qureshi

● Assist and coordinate with the professor in conducting the laboratory sessions for the course Introduction to Biostatistics.
● During the lab sessions, help and guide students with their assignments by providing support in solving problems and assisting them in understanding the approach towards the solution.

● Managed and maintained datasets using SAS, ensuring the accuracy and integrity of the data by identifying and resolving anomalies through data manipulation and visualization techniques.

● Utilized R Studio (Shiny Package) and SQL, to create reports that reflected patient enrollment and health statistics based on attendance. Additionally, I used Balsamiq to design wireframes for the reports.

● Worked as a Data Analyst in scrubbing the data from excel & importing it into the SQL database by implementing ETL logic.
● Created reports in Power BI and making sure they are available to the university by the end of every month or semester.

● As part of my role in inter-library loan, was responsible for issuing books and articles to patrons using the loan application.
● Ensure that all processes were documented properly and up-to-date, and that there were no overdue books or outstanding fees, making sure the information was easily accessible to my managers and peers.

● Responsible for scheduling and conducting back-office work, including identifying suitable candidates for job opportunities that aligned with their lecture schedules. This resulted in the successful placement of many students in appropriate jobs.
● Maintain and assess records of student work hours on a weekly basis, ensuring accurate reporting.

● As a Senior Data Analyst, my role involved utilizing various tools such as Power BI desktop for reporting, SSIS as an ETL tool, and SSAS as an analytical tool.
● I was responsible for developing data visualization and data engineering tools such as Power BI, MS BI Stack, and COSMOS to load, massage, and examine data.
● In addition, I regularly communicated with clients to understand their requirements and incorporated necessary features in reports.
● I also ensured timely deployment of these reports. To compare and test historical data loaded in the BI reporting tool, I utilized the Adobe Analytics system.
● My responsibilities included coordinating with clients daily, ensuring their requirements were met, and maintaining effective communication throughout the reporting process.

● As a Power BI Dashboard Developer, I have extensive experience in collaborating with teams to evaluate system requirements and formulate design procedures and quality standards for process blueprint development.
● My expertise includes managing high data volume BI systems and analyzing data to build Business Intelligence reports using various reporting tools like SSRS, Excel Power Pivot, and Power BI.
● Have been responsible for developing and designing BI reporting solutions, DW solutions, and data analytics solutions using Microsoft BI 2016 stack (SSIS, SSAS, SSRS, or Power BI).
● Designed data models, database architectures, and business rules based on business requirements, extracted data from multiple systems, and performed transformation using the required business rules to meet business needs.
● Responsible for optimizing queries and cube performance through indexing and implementing partitions on tables.
● I have also created cubes using the Tabular Model of MS BI, star or snowflake schema, and designed dimensions and their attributes.
● Implemented user/group level security on the data and reports based on the hierarchy of the users has also been a part of my role.
● Maintained proper documentation and version control, I have documented all processes using Business Requirement Documentation (BRD) and maintained all documentation in Team Foundation Server (TFS).
● Maintained code bases in TFS along with reports and solutions to ensure proper version control.
● Worked with offshore teams to hand over day-to-day work, review and test code, and support existing systems in production.
● Trained and imparted knowledge to new team members on Power BI or COSMOS, along with domain knowledge.

● Led the design and implementation of BI reporting, data warehousing, and data analytics solutions using Microsoft SQL Server BI stack, from initial concept to final delivery.
● Collaborated with business decision makers to gather requirements and identify pain points in the existing manual planning system, resulting in the successful transition to an automated system.
● Provided expert recommendations on the design and structure of the new reporting tool using SSRS and Power BI, leading to a 40% increase in productivity organization wide.
● Demonstrated flexibility in accommodating frequent changes in information needs from business users by building an architecture and model using Erwin and SQL server that allowed for efficient organization and storage of data.
● Played a key role in organizing audit reports for a prominent financial institute, utilizing SQL Server and SSRS to display who modified data, when, and which fields were changed.
● Shared reports on SharePoint and created web parts to display various reports generated from SSRS and Excel on a single page.
● Defined data requirements and report layouts, and created testing plans and scripts based on requirements, ensuring successful delivery of high-quality reports to the business.

● Leveraged Business Intelligence Reporting Tool to create Key Performance Indicators (KPIs) and Scorecards that improved corporate profitability measures and comparative financial analysis.
● Reconciled the organization's Fixed Assets by integrating data from two separate systems (SAP and an Azure-based environment) using MS SSIS and SQL scripts, which facilitated updating, inserting, or deleting inconsistent records from the Azure system.
● Utilized reports built in Excel with Macros for data analysis, improving data quality from 40% to 95% through the ongoing agile process of reconciliation in the Azure environment.
● Developed Analysis cubes using SSAS for data analysis, enabling faster retrieval of data at the reporting level by 20%.
● Improved cube performance by introducing additional partitions, aggregations, or removing unwanted measures or dimensions to manage the increasing volume of data.
● SQL profiler was used to identify frequently used dimensions or facts by the users and eliminate unnecessary ones.

● Collaborated with the business team to identify their data requirements and designed data models using tools like Erwin, MS SQL Server and SSAS to support data analytics and reporting needs.
● Developed and implemented automated ETL workflows using SSIS to extract data from multiple sources, transform it according to business rules, and load it into the data warehouse for reporting purposes.
● Created reports using SSRS, Excel Pivot Tables, and Excel functions to support data-driven decision making, including P&L reports for different branches of a hotel chain.
● Worked with a technical team to develop cubes using SSAS for data analysis and improve query performance.
● Optimized the performance of existing SSRS reports by analyzing query performance, optimizing queries, and identifying and eliminating unnecessary joins and selected columns.

● As a backend system manager for ICICI Lombard's ecommerce site Online Manager, I was responsible for managing and maintaining various product categories such as Health, Motor, Travel, and Home.
● Leveraged my expertise in writing SQL queries and procedures to ensure seamless functioning of the backend system.
● Managed live customers and addressed their queries in real-time, providing efficient and effective solutions to their concerns.
● Through my dedication and commitment to the role, I contributed to the smooth operation of the ecommerce site and helped ensure a positive customer experience.