Inviter Freelancer til Projektet
Det lader ikke til, du har et aktivt projekt i øjeblikket. Hvorfor opretter du ikke et projekt nu? Det er gratis!Opret et projekt
- 100%Jobs udført
- 100%Indenfor Budget
- 100%Til Tiden
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
Excel Macro to get items price from a website using Rest API
outlook vba demo
“A+++ I really recommend amit, very good freelancer”zivm 4 måneder siden
Use an API to automatically retrieve and match data to an Excel list of existing data
“Exceeded expectations”dsiebers 4 måneder siden
Project for Amit K.
“He is expert in Tableau and really did great job. I would definitely re-hire him.”Amu90 4 måneder siden
Power BI Expert
“one of the best for sure”Pedro C. 4 måneder siden
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.”matt1572 4 måneder siden
BI & Analytics ManagerJun 2015 - Sep 2018 (3 years)
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.
Assistant Manager - MIS & AnalyticsApr 2012 - Jun 2015 (3 years)
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.
Data AnalystSep 2010 - Apr 2012 (1 year)
• 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.
MIS ExecutiveJan 2009 - Sep 2010 (1 year)
• Quality check and batch processing of sales data into reporting system. • Prepare daily sales MIS reports at client level and communicate with banks for missed/declined transactions. • Daily, weekly, monthly sales reports, success rate & fail category reports. • Prepare commissions files for Finance.
MCA (Masters in Computer Application)2005 - 2008 (3 years)
B.Sc (Maths)2002 - 2005 (3 years)
Advanced Excel (2011)Clifford Chance
Adavance Execl course in automation of reports/process in Excel and Access using VBA and Macros
Tableau Certification (2016)Tableau
Tableau Certified professional
Portfolio Analytics Tool
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.
- Telefon Verificeret