Mohammed Nadeem

• Power BI developer

· Developing interactive analysis reports and dashboards using data sources like SharePoint, SQL Server, and Teradata.

· Publishing and scheduling Power BI reports as per the business requirements.

· Created DAX Queries to generate computed columns in Power BI.

· Experience in data modelling

· Performing operational task of user access management for operational request

· Developing visual reports, dashboards, and KPI scorecards using Power BI desktop.

· Experience in Data Gateway for data refreshing.

• SQL data analyst

· Create data mappings in data warehouse and designed a site map for approval from executive management.

· Load data using ETL process dealing with different data sources MS excel, MS access and SQL server, CSV, flat files etc. Into target database by performing different kinds of transformations using SQL server agent to automate the SSIS 2012/2008r2 package execution.

· Create database objects such as table, views, stored procedures, triggers etc, for analysis,

Day to day processing external files from clients, using ETL some using legacy DTS packages for some transfer of data between servers in a SQL server 2000/2005//2008 environments.

· Performed analysis, detailed specification, SQL database analysis and disaster recovery, technical and end-user documentation host communication interface design and performed on-line and batch testing of production support.

· Ensured different internal external systems exchanged data according to the specification to transform data from enterprise data warehouse to SQL server load data to fact tables.

· Performed SQL backup and restore tasks on various SQL servers,

• IT assets management and desktop support

· Provided expert desktop support to ensure the reliability and functionality of over 5K users within the organization, this included diagnosing and resolving hardware and software issues, conducting routine maintenance, and implementing proactive solutions to enhance system performance and improve user satisfaction.

· Managed the entire lifecycle of IT assets, from procurement to retirement, ensuring optimal utilization and cost- effectiveness.

· Conducted daily audits of IT assets to track inventory, and maintain accurate records, reducing the risk of loss or theft.

· Oversaw the daily maintenance and troubleshooting of IT assets, minimizing downtime, and ensuring a seamless workflow for end- users.

· Prepared daily, weekly, and monthly reports on asset utilization, cost analysis, and compliance status, providing valuable insights to senior management.

· Implemented a comprehensive asset disposal process, including data sanitization and environmentally responsible disposal methods, in compliance with regulatory requirements.

· Managed vendor relationships for hardware and software procurement, negotiating contracts and pricing to achieve cost savings.

• FACILITIES COORDINATION IN CBRE

Client: PEPSICO

Duration: Sep’2019 to Mar’22

Project: Transport billing

Technologies/Tools: Moveinsync app, Excel, Power point, power bi.

• Responsibilities:

· Publishing and scheduling Power BI reports and share with the lead management.

· Created PPT as per the business requirements.

· Maintain the monthly MIS reports for the month wise billing.

· Planning, delivery and management of all facility services, administrative support, and other essential activities

· Service providers contract management and day to day Manpower management

· Setting Goals for the staff to achieve timely completion of all Preventive Maintenance, Break down Maintenance and Predictive Maintenance of all equipment’s.

· Required documents preparation for couriering IT asset (Declaration, Delivery challan and postal address for all Non-local employees.

· Conducting business reviews Monthly, Quarterly and Half yearly reviews with clients

• Declaration:

· I hereby declare that all the above information provided is true to the best of my knowledge and belief.

Mohammed Nadeem