Mohammed Ehsan
Analyst
Bengaluru
Summary
business processes, identifying opportunities for improvement, and delivering data-driven insights
to drive strategic decision-making. Proficient in data analysis, requirement gathering, and project
management. Proven track record of successfully implementing process improvements that have
resulted in cost savings and revenue growth. 7353691596
Dedicated and results-driven Analyst with 3+ years of experience (Amazon) in analyzing complex
Education
Achievements
Steller Award of Amazon in January 2024.
Successfully led the migration of existing reports from Excel to Power BI, improving data
accessibility and analysis capabilities.
Overview
3
3
years of professional experience
Work History
ANALYST
Amazon Development Centre India
Bengaluru
06.2021 - Current
- Developed and maintained interactive dashboards using Power BI, providing real-time insights for executive decision-making, incorporating key metrics and KPIs
- Poses an excellent knowledge on connecting Microsoft Power BI Desktop to various data sources
- Extracted and transformed data from various sources using SQL and Python, ensuring data accuracy and integrity
- Publishing Reports and setting up necessary connection details and scheduling
- Designed and maintained data models, utilizing DAX functions for efficient data aggregation and summarization
- Implemented calculated columns to enhance data models with additional business logic and calculations using DAX functions
- Developed SQL scripts for data integration tasks, including ETL (Extract, Transform, Load) processes, to consolidate and transform data from various sources
- Applied advanced SQL join operations to combine data from multiple tables and create comprehensive datasets for analysis
- Collaborated with business analysts and stakeholders to understand reporting requirements and translated them into effective data visualizations
- Automated routine reporting processes, reducing report generation time by 50%
- Developed and maintained detailed project documentation, including business requirements, functional specifications, and test plans
- Conducted in-depth data analysis to identify trends, patterns, and insights, resulting in improved forecasting accuracy and better-informed business decisions
- Presented findings and recommendations to stakeholders, enabling data-driven decision- making at various organizational levels.
Education
Bachelors of Computer Applications (B.C.A) - undefined
St Anne's Degree College
March 2018
Trained and Certified in Java Programing 2018-2019 from Inventateq. Trained and Certified in Hadoop Programing 2019-2020 from Inventateq - undefined
Skills
- Microsoft Excel Power BI
- AWS Quick Sight ETL - Data Central
- SQL Python
- DAX Power Query / Power Automate
- Technical Skills:
- Proficient in using Power BI Desktop and AWS Quick Sight for reports and dashboards
- Experience in writing Python and SQL queries to retrieve and manipulate data from databases
- Advanced skills in
- Microsoft Excel, including the use of pivot tables, formulas and DAX functions
- Experience in translating complex data into actionable insights using Data Analysis techniques
- And Data Visualization tools to drive business decisions
Accomplishments
- Certified in Power BI from PwC Switzerland in July 2023
- Advance SQL Certification Challenge from Hacker Rank.
Work Preference
Work Type
Full TimeWork Location
On-SiteRemoteHybridTimeline
ANALYST
Amazon Development Centre India
06.2021 - Current
Bachelors of Computer Applications (B.C.A) - undefined
St Anne's Degree College
Trained and Certified in Java Programing 2018-2019 from Inventateq. Trained and Certified in Hadoop Programing 2019-2020 from Inventateq - undefined
Similar Profiles
Neenu Susan VargheseNeenu Susan Varghese
Customer Service Manager (Search and Rescue) at Amazon Development Centre IndiaCustomer Service Manager (Search and Rescue) at Amazon Development Centre India
Amit KumarAmit Kumar
Manager - Selling Partner Support at Amazon Development Centre India Pvt LtdManager - Selling Partner Support at Amazon Development Centre India Pvt Ltd
Joshma JohnsonJoshma Johnson
Vendor Consultant at Amazon Development Centre (India) Private LimitedVendor Consultant at Amazon Development Centre (India) Private Limited
JOSEPH JONATHAN IJOSEPH JONATHAN I
Content Reviewer at Amazon Development Centre India Private LimitedContent Reviewer at Amazon Development Centre India Private Limited
Bharath Reddy KBharath Reddy K
Lead Securities Analyst at Wells FargoLead Securities Analyst at Wells Fargo