Amit K. Profile

5.0

(5 건의 리뷰)

를 팔로우 했습니다.

팔로우 서비스의 지정 과정에서 문제가 발생하였습니다.

이 사용자의 경우에는 다른 사용자들의 팔로우 서비스를 허용하지 않고 있습니다.

이 사용자에 대한 팔로우 서비스를 이미 이용하고 계십니다.

고객님의 현재 멤버십 등급으로는 0 건까지만 팔로우가 가능합니다. 멤버십 서비스의 업그레이드는 여기에서 하시면 됩니다.

성공적으로 언팔로우했습니다

팔로우 서비스에 대한 지정 해제 과정에서 문제가 발생하였습니다.

님에 대한 고객님의 추천 절차가 모두 완료되었습니다.

사용자 추천 과정에서 문제가 발생하였습니다.

원인을 알 수 없는 문제가 발생하였습니다. 현재의 페이지에서 다시 읽기 버튼을 클릭하신 후에 재시도하여 주시기 바랍니다.

이메일에 대한 인증 절차가 완료되었습니다.

$8 USD / 시간

bahadur garh,

india

$8 USD / 시간

현지시간은 6:22 AM입니다

10월 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년 전

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년 전

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년 전

5.0

€33.00 EUR

Power BI Expert

one of the best for sure

Pedro C.

@pedroccamara

•

6년 전

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년 전

경력

Jones Lang Lasalle

6월 2015 - 9월 2018 (3 , 3 )

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

4월 2012 - 6월 2015 (3 , 2 )

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

9월 2010 - 4월 2012 (1 , 7 )

• 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 )

B.Sc (Maths)

Maharshi Dayanand University,

India

2002 - 2005

(3 )

자격증

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.