MOHAMED 

(2+ Years of Experience)

PROFESSIONAL SYNOPSIS

A data analyst professional with 2+ years of experience

• Good experience in analysis and data reporting.
• Expert in analysing data using the advance features of Excel.
• Have good knowledge Identify, analyse, and interpret trends or patterns in complex datasets.
• Have basic level knowledge of programming languages like Java, Python.
• Develop graphs, reports, and presentations of business results
• Ability to automate the repetitive task performed in excel, by using VBA/Macros.
• Have good knowledge in Data Gathering, Analysis and Reporting.
• Proficient Exposure to large set of data – Operational, Retail and Logistic domain.
• Have good knowledge about database concepts and design.
• Strong communication and interpersonal skills and a committed team player.
• Self-motivated, result-oriented and desire for constant learning.
• Ability to quickly learn new tools and incorporate into reporting.
• Have expert knowledge in data management.

TECHNICAL SKILLS

Technical skills

Microsoft Excel, Advanced Excel, Data Management, Data Visualization, VBA Macros

Tools

Tableau, Power BI

Database

SQL

Programming Languages

Java (Basic), Python (Basic)

KEY PROJECTS

1. GLORIFI EXCEL RATE BUILDER

Tool: Excel, Advanced Excel, VBA Macros,Online Converter

Role: Data Analyst

Responsibilities:

• Data Conversion, Data Cleansing for the rate manuals.
• Data Management using Advanced Excel functions
• Building data models as per the client’s requirements.
• Building rate manuals for auto and property for the Insurance company.
• Developing Data reports to the clients.

Synopsis: Glorifi is a US based insurance company having requirements of building rate models for fixing insurance premium for the auto and property for various US states. Depending on the rates we build the rate models for all the states as per the requirement. We manage variable rates and provide a static solution in providing reports on specific data findings and their impact on organizational growth and success.

1. DIGITAL VENDOR MARKETING (DVM)

Tool: Excel, Advanced Excel, VBA Macros, SQL

Role: Software Developer

Responsibilities:

• Data Conversion, Data Management
• Creating reports using Advance excel functions
• Implemented automation using Excel macros (VBA)
• Modify existing macros as per business requirement
• Troubleshoot issues in existing macros
• Functional and technical documentation
• Data handling for analysis and report generation.

Synopsis: Target India Corporation is one biggest product-based company. The main role in DVM project is to gather product related data and generate various time-based reports. Simplifying the repetitive task using Excel macros (VBA). Creating weekly, monthly, and quarterly base reports.

1. DATA ANALYSIS AND REPORTING.

Tool: Excel, Advanced Excel, VBA, MS Word, Power Point

Role: Junior Data Analyst

Responsibilities:

• Data Conversion, Data Clean-up, Data Management.
• Analysing data using advance excel feature and functions
• Automating the data retrieval and analysis process using VBA/Macros
• Generating summarized report using Pivot Tables
• Develop graphs, reports, and presentations of business results.

Synopsis: This project is related to applying data analysis techniques and reporting methods to predict the sales and optimization techniques on process, raw material, and future sales. Also include generating time-based reports.

Duration: June 2013 to December 2014