Profilbillede af kadianamit2609
@kadianamit2609
Flag for India Bahadur Garh, India
Medlem siden 4. oktober 2018
1 Anbefalinger

kadianamit2609

Online Offline
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.
$8 USD/hr
5 anmeldelser
2.5
  • 100%Jobs udført
  • 100%Indenfor Budget
  • 100%Til Tiden
  • N/AGenansættelsesfrekvens

Portfolio

Nylige bedømmelser

  • billede af zivm outlook vba demo $20.00 USD

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

  • billede af dsiebers Use an API to automatically retrieve and match data to an Excel list of existing data $190.00 HKD

    “Exceeded expectations”

  • billede af Amu90 Project for Amit K. $70.00 USD

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

  • billede af Pedro C. Power BI Expert €33.00 EUR

    “one of the best for sure”

  • billede af matt1572 Build excel spreadsheet $25.00 AUD

    “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.”

Erfaring

BI & Analytics Manager

Jun 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 & Analytics

Apr 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 Analyst

Sep 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 Executive

Jan 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.

Uddannelse

MCA (Masters in Computer Application)

2005 - 2008 (3 years)

B.Sc (Maths)

2002 - 2005 (3 years)

Kvalifikationer

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

Publikationer

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.

Verifikationer

  • Facebook forbundet
  • Foretrukken Freelancer
  • Betalingsverificeret
  • Telefon Verificeret
  • Identitet verificeret
  • E-mailverificeret

Mine vigtigste færdigheder

Gennemse lignende freelancere