Banner Image

Skills

  • Power BI
  • Python
  • Data Management
  • Desktop Applications
  • Email Services
  • Extract Transform and Load
  • Microsoft Excel
  • Modeling
  • Programming
  • Reports
  • Training

Services

  • Macro expert, Ms Excel expert, ETL

    $10/hr Starting at $25 Ongoing

    Dedicated Resource

    Over 3 years' experience in data cleansing, analysing and visualising. Passionate in data handling and have completed several certificates in Python,R,Alteryx and power BI. Have prepared number of complex...

    Extract Transform and LoadMicrosoft ExcelPower BIPython
  • Advanced Power BI Visuals

    $15/hr Starting at $100 Ongoing

    Dedicated Resource

    Power BI Desktop Skills: My other key skills include but not limited to: Store, retrieve and manage multidimensional data. Analyse data for trends, find patterns. Certificate in Python programming and...

    Data ManagementDesktop ApplicationsEmail ServicesModelingPower BI

About

My goal is to provide an exceptional experience for my clients and help them make the most of this platform by hiring me

I have 3 years of hands-on experience in data collection, data cleaning, analysing, ETL and visualising.

I am passionate in data handling and have completed several certifications in Python, R, Alteryx, Power BI, SQL etc.

I have prepared number of macro enabled templates to cut down the time taken in manual inputs. Some of my work using MS Excel include:
- Transforming client data into standardised format
- Extract checklist based on different country combinations inputted by the user
- Calculate number of workdays/non workdays spent in various countries and decide taxability based on the outcome
- Consolidate/Slice data based on given criteria

I am also skilled at transforming and visualising data using Alteryx designer and Power BI. Some of my work include:

- Determine the difference between the raw data used in the last year and in the current year and summarise the findings. Earlier this step was done manually using pivot tables in excel and noting down the findings
- Consolidate large number of Excel sheets with same/similar structure into one file
- Transforming client data
- Analyzing questionnaire responses from surveys and representing them into charts and tables to be published as a report with write ups
- Mail merges involving large datasets, to be published as a report

I have recently completed a certification on Python Scrapy and exploring web crawling to a larger extent.

I have received bronze badge (EY certified) in data science and I am continuing expanding my knowledge in this field.

I am open to collaborate with potential employers in upwork and benefit mutually from the projects.

Work Terms

Available 6+ hours on weekdays and weekends