Amit K. Profile

5,0

(5 відгуки(-ів))

Тепер ви підписані на

Помилка підписки на користувача.

Цей користувач не дозволяє слідувати за ним.

Ви вже слідуєте за цим користувачем.

Ваш членський план дозволяє мати не більше 0 підписок. Покращити рівень членства можна тут.

Успішно відписалися від

Помилка під час скасування підписки на користувача.

Ви успішно рекомендували

Помилка рекомендування користувача.

Щось пішло не так. Будь ласка, оновіть сторінку та повторіть спробу.

Електронну адресу успішно верифіковано.

$8 USD / год.

bahadur garh,

india

$8 USD / год.

Зараз тут 2:29 дп

На сайті з жовтня 4, 2018

1 Рекомендація

Amit K.

@kadianamit2609

5,0

(5 відгуки(-ів))

2,5

100%

$8 USD / год.

bahadur garh,

india

$8 USD / год.

100%

Завершених робіт

100%

В межах бюджету

100%

Вчасно

Дані відсутні

Рейтинг повторного найняття

Data & Analytics Expert

Excellent and dynamic BI & Analytics professional with over 9 years of experience in BI, Analytics, Reporting and Data Analysis. Seeking opportunities to set-up my self as an independent and respectable freelancer. Have worked as BI & Analytics Manager and set-up information and reporting systems for big MNCs like Amex, JLL and Clifford Chance.

Переглянути всіх Excel Experts в India

Зв'яжіться з Amit K. щодо вашої роботи

Авторизуйтесь, щоб обговорити деталі в чаті.

Портфоліо

Built this PowerBI dashboard and analysis for sales, purchase and COGS over time, items, vendors etc.

PowerBI - Sales, Purchase and COGS Analysis

Build this Excel application for an Architect company to track their project expenses, key dates, items and generate invoice and reports when required.
It helped the client reduce 80% effort on these manual activities.

Excel - Project & Expense Tracker, report/invoice generator

Tableau analysis of Alcohol consumption in Australia by years and beverage type.
Shown consumption heat maps, comparisons, statistical analysis like linear and polynomial regressions.

Tableau Analysis of Alcohol consumption in Austraila

This tool will look through excel list and send emails to customer a payment reminder on calculated date logic.
It helped client to automated and kill the efforts to send payment reminder email to hundreds of clients.

Excel VBA Macro for bulk Emailing

Created this Tableau dashboard for a strategy and breakout game on IOS and MAC
Shown user behavior, purchase page analysis, goals conversion, hot spots analysis, demographics, average revenue per impression and many more. It helped client to find the right times and users for advertising purchases.

Connected Tableau with MY SQL server that store the online data from IOS and Mac platforms.

Tableau Analysis of online game purchases and user behavior

Very sophisticated logic and code to find available spots in calendar on a specified date and create appointment/meeting for a specified duration in you calendar.
It takes user input as date of appointment and duration of meeting. And then look through all the calendar items on that --> find a suitable time spot and create an appointment/meeting.
It might help a big team to automatically create appointments without going to calendar and finding available times.

Outlook Macro - find free spot in calendar & create meeting

PowerBI - Sales, Purchase and COGS Analysis

Excel - Project & Expense Tracker, report/invoice generator

Tableau Analysis of Alcohol consumption in Austraila

Excel VBA Macro for bulk Emailing

Tableau Analysis of online game purchases and user behavior

Outlook Macro - find free spot in calendar & create meeting

Відгуки

Зміни збережені

Показано з 1 по 5 із 5 відгуків

Фільтрувати відгуки за:

5,0

$20,00 USD

outlook vba demo

A+++ I really recommend amit, very good freelancer

Visual Basic for Apps

Microsoft Outlook

Zivm Z.

@zivm

•

6 years ago

5,0

$190,00 HKD

Use an API to automatically retrieve and match data to an Excel list of existing data

Exceeded expectations

Excel

API

Daniel S.

@dsiebers

•

6 years ago

5,0

$70,00 USD

Project for Amit K.

He is expert in Tableau and really did great job. I would definitely re-hire him.

+ ще 1

Amy K.

@Amu90

•

6 years ago

5,0

€33,00 EUR

Power BI Expert

one of the best for sure

Pedro C.

@pedroccamara

•

6 years ago

5,0

$25,00 AUD

Build excel spreadsheet

Amit K is a true professional with excellent skills in communication and shows a very comprehensive knowledge of excel. He has delivered a fantastic result for me, on time and on budget. I would not hesitate in using him again and would highly recommend his services.

Data Processing

Excel

Matt C.

@matt1572

•

6 years ago

Досвід роботи

Jones Lang Lasalle

черв. 2015 - вер. 2018 (3 years, 3 months)

Leading the Analytics and BI COE (Center of Excellence) team for Integrated Portfolio Service (IPS) business in JLL Asia Pacific. Maintain & develop new BI products, dashboards/reports & processes for Consulting, Lease Admin, Facilities Mgt & Occupancy Planning teams. Maintain Tableau server that hosts more than 100 dashboards and 300 users. Initial point of contact for any new initiative around BI, Automation, Reporting or ETL/Data mining work in JLL Asia Pacific.

American Express

квіт. 2012 - черв. 2015 (3 years, 2 months)

Worked as a Individual contributor in the development team of MI Client Consulting. Developed Excel and Access Applications for clients using VBA & macros. Streamlining of reporting structure, technical support to the team. Handled and maintained the Service Reporting Process that distributes over 500 reports to clients every month. Sales performance & incentives reports, Revenue tracking and Sales Pipeline reports for Sales team. Maintain and update SAS programs for the team.

Clifford Chance LLP

вер. 2010 - квіт. 2012 (1 year, 7 months)

• Maintenance of centralized reporting database. • Weekly activities of cleaning and batch data loading into database for reporting. • Fee Time Analysis reports for lawyers. • Daily, Weekly and Monthly client data quality reports.

Освіта

MCA (Masters in Computer Application)

Maharshi Dayanand University,

India

2005 - 2008

(3 years)

B.Sc (Maths)

Maharshi Dayanand University,

India

2002 - 2005

(3 years)

Кваліфікація

Tableau

2016

Tableau Certified professional

Clifford Chance

2011

Adavance Execl course in automation of reports/process in Excel and Access using VBA and Macros

Публікації

Portfolio Analytics Tool

JLL Asia Pacific

Interactive Analytics tool build in Tableau and SQL to give insights about client's real estate portfolio. It combines client's data with JLL research data and provide useful insights like savings opportunities, expiring leases, upcoming events etc.