Mohammed Amir

- Expert in T-SQL development to write complex queries by joining multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions
- Maintain, enhance and support existing databases and applications.
- Worked on the Power BI reports & dashboards with SQL Server and other data sources.
- Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations etc.
- Worked on Custom Visualizations like multi slicer and Hierarchy slicer.
- Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
- Expert in Data Extraction, Transforming and Loading (ETL) using various tools.
- Good hands on Azure Data Factory
- Expertise on building pipelines to copy the data from different source to destination in Azure Data Factory
- Experience with Snowflake cloud data warehouse, building snow pipes for data migration and creating database, schemas, tables and writing stored procedures.
- Hands on experience in web applications development by using ASP.NET C#
- Hands on experience in website development by using WordPress, HTML & CSS.
- Good knowledge of System Development Life Cycle (SDLC)

# Worked on the Power BI reports & dashboards with SQL Server and other data sources.
# Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations etc.
# Worked on Custom Visualizations like multi slicer and Hierarchy slicer.
# Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
# Expert in Data Extraction, Transforming and Loading (ETL) using various tools.



Few Key Projects :

- Pidilite Sales Report

Platform: Power BI, SQL Server & Excel
Duration: 3 Month
Client:
Description: Pidilite
Created BI Dashboards and Represent primary and secondary sales data and growth, Shows schemes participation, Product Handling and product used by users, different sites handle by sales representatives.
Responsibilities:  Developed Power BI reports and dashboards from multiple data sources.
- Create and customize visualizations, hierarchies, drill-down and connecting to BI data sources and using Power BI Desktop and Power BI Service
- Use database views, SQL queries, MDX and DAX queries to achieve desired output.
- Setup Workspace and deployed reports.


- FlipKart BI Reports
- Client : Flip Kart
- Platform : Power BI, SQL Server, CSV & Excel
- Responsibilities: Developed several BI Reports using the different data sources like CSV, Excel and Sql Server etc.
- Data model design, measures, created logical columns.
- Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
- Created new Calculated Column and Measure using DAX Expression.
- Published/shared the reports by creating Content Pack/Sharing the pbix file
- Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations etc.

- Re-designing official website of UN-DESA department: Upgraded the current structure and design of the DESA website and align it with the UN website with the 6 official languages. Migrated databases of several other subdivision and merge into the DESA main website.
- Role : Developer and System Analyst
# Manages projects involving feasibility studies, systems analysis, designing, development and implementation. Participates as a member of a development team with responsibility for major components of the more complex systems.
# Implementing Agile and Scrum practices, collaboration with other divisions/Sections. Actively contribute to the continuous Improvement of project framework and to the successful organisational transition to Agile.
# Tracking the project progress by using the Sprint Burn down Chart.
# Responsible for end-to-end project management covering complete project life cycle.

- FSS (Field Support Suite) ERP System: The system has built for the United Nations Missions spread over the countries. This system has covered with 20 modules for different Sections and Units, few big modules are below explained.
# Title: E-MOP (Electronic Movement of Passengers)
# Scope: Online application to permit UN staff members (end-users) to request Movement of Personnel and the subsequent multi-level approval of that request, for different staff categories.
# Title: CMR (Cargo Movement Request)
# Scope: Application to track the staff cargo request across the Missions.
# Title: eTMS (Electronic Training Management System)
# Scope: The e-Training Management System (e-TMS) is a web application that managed training courses, the training cycle and training records in field missions and UN Headquarters.

- Client : United Nations Offshore Development Unit, Entebbe (Uganda)
- Period : Aug’09 - Jun’15
- Role : System Analyst/Team Lead.
- Worked as a bridge between a management group, stakeholders and Development/Testing team.
- Involved in analyzing the entire project, Tasks, Bugs, change requests and Strategic planning.
- IT Procedure Implementation using Application Lifecycle Management (ALM) and Agile development process to identify resources and schedule assignments, manage daily activities of project team and assign individual responsibilities, monitor and tracking the resources till the completion of the task/Projects.
- Ensured that there was proper co-ordination between testing team and development team and
Providing technical support.
- Motivated the team members during crisis and tight deadlines.
- Daily, Weekly and Monthly meetings with the Project Managers and Clients.