Personal Data

Surname, First name: Kamath, Jnanadeva

Date of Birth: 26th February 1982
Marital Status: Married
Email: dev.kamath26@gmail.com
Mobile: +91 8317496224

Education
Bachelor of Commerce from Bangalore University (B.COM) 1999 to 2003
SAP Fico Course & Internship 2012 to 2013

Summary of Skills

Technical Skills Functional Skills Other Attributes

• Advanced MS Excel skills • Financial Reporting. • Quick learner of any process.
• VBA • Data Mining, Analysis, • Strategic Planning &
• SQL Cleansing, Configuration. Prioritizing.
• SAP FICO • Business Analysis. • Client & People
• MS Office • Business Intelligence. management.
• Experience in Finance, • Team Building & Leadership.
Operations, Recruitment & • Problem solving & Decision
Analytical with Statistical Making.
Reporting. • Multitasking.
• Accounting • Team Skills.
• Data Modelling • Process Oriented.
• Financial Consultant

Professional Experience
NAVEEN KUMAR & CHARTERED ACCOUNTANTS — Bangalore, India 04/15 to 02/2020
Financial Data Analyst
• Development of Weekly, monthly and annual client insights and strategy reports using Advanced Excel.
• Data analyst in master data projects.
• Data gathering and mining from various datasets using Macros involving data business rules definition.
• Segregation and reporting using advanced Excel skills.
• Extract financial reports from Tally systems and undertake day-to-day bookkeeping for managers, regulators, and
shareholders.
• Working on Excel to analyse the data and presenting data to management using MS PowerPoint.

GLAXSOSMITHKLINE PHARMACEUTICALS – Brentford, United Kingdom 07/14 to 12/14

SAP MM Data Analyst
• Extracting MM data from legacy system and configuring the same in excel in order to transfer in new SAP MM system.
• Creating flowcharts on the same for extracting data for all the sub departments in MM.
 • Legacy system data mining,analysing, cleaning and configuring as per the SAP MM system to push through.
• Data validationof SAP MM data with the legacy system data once the transfer to new SAP MM system is a success.
• Analysing on all the failed jobs and correcting the flowcharts from the start and push the data again till the job is 100%
success.

ADECCO UK GROUP – London, United Kingdom 05/13 to 10/13

Financial Analyst, CFO office
• Data Retrieval and Data analysis on large/complex MI datasets using Advanced Excel and SQL skills.
• Trend Analysis on the large Datasets.
• Segregation and reporting using advanced Excel skills.
• Work with other lead analysts in the team to produce high quality data analysis.
• Data gathering/mining from various datasets within organization using SQL.
• Applying statistical methodology to complex data.
• Format, Configure and Fragmentation of the data to produce higher quality Analysis in lesser time.
• Development of Weekly, monthly and annual client insights and strategy reports using Advanced Excel.
• Streamlining of reporting processes.

WIZCORE TECHNOLOGIES – London, United Kingdom 08/12 to 04/13

Completed course and Internship – FICO
Creating company codes, assigning chart of accounts, defined retained earnings account, assigned company code to Field Status
Variant, assigned tolerance groups, defined additional local currency, did configuration for GL automatic clearing, customized FI
accounts receivables, defined account for bank charges, payment and bank determination. Customized FI Accounts Payables by
defining terms of payment, vendor master records, customer master records, created and assigned number ranges for customers,
defined accounts for exchange rate differences, rounded differences. Month end processes supported for FI module.

TALK TALK — London, United Kingdom 02/11 to 07/12

Financial Analyst
• Extract data for daily reports using SQL Queries.
• Document and organize the business data for communication between functional and technical department.
• Financial Reporting using Advanced Excel skills.
• Monthly and Annual reconciliations.
• Programmed new performance monitoring tools using VBA.
• Performing in-depth data analysis and statistical analysis for any issue identification and escalation using Advanced Excel.
• Working with Quality team to validate the data.
• To track key business metrics in real time; understand which actions to take based on timely delivery of trusted data.
• To trace the performance of external vendors (TCS & IBM) and ensure that agreed service levels agreements (SLAs) are
met, but also create a long term strategic partnership to ensure smooth workflow and assist in creating vendor proposals.
• To ensure accuracy and punctuality of reports for offshore clients, Financial & regulatory, Ad hoc reports, month end
reconciliations and Invoicing.
• Automated daily reports so that it is sent to the respective heads of the department.
• Ad hoc analysis – pulling data from source systems, analysing, following up exceptions to reduce backlog of incidents.

APPLIED MATERIALS — Bangalore, India 02/10 to 08/10

Data Analyst - (PMO).
• Financial and cost/benefit analysis reports using SQL queries (using complex joins) and MS excel to help the senior
management to determine the projects that could be undertaken.
• Experience in Applied Materials Financial Sector and contributed in Data Analysis and Data Management activities.
• Ad hoc analysis – pulling data from source systems, analysing, following up exceptions.
• To resolve the Data quality issues on large volumes of data.
• Developed procedures to pull data from SAP system.
• To assist in Internal and External Data audits.
• Managed reporting on staffing of more than 5000 associates withmonthly outsourced from external vendors like TCS,
IBM and SATYAM across different projects based in United States and India.
• Extract data for daily reports using SQL Queries (using complex joins) on all operational databases (MS access) to check
and monitor the workflow.
• Extract reports of past allocation of the resources based on their skillsets, qualification and prior work experience.
• Programming SQL queries for validation and analysis on RTS (Resource Tracking System).
IBM INDIA PVT. LTD. — Bangalore, India 10/07 to 07/09
Business Analyst, PMO Office - 10/07 to 12/07
Resource & Deployment Analyst - 01/08 to 03/09
Senior Reporting Analyst - 04/09 to 07/09
Promoted to senior reporting analyst to collate all the individual reports across the team and report consolidated view to senior
management to facilitate efficient decision making.
Due to flawless and efficient consolidated reports, staff turnover was reduced by 15% which was a benchmark record setting
improvement in staff retention.
Prepared individual demand sheet for around 800 employees across 4 sub departments (competencies) of ITD GD branch on a
weekly basis.
• Weekly status meetings with all the competency managers, staffing and HR team to authenticate the demand and
confirming on every demand that could be fulfilled by India and with external vendors to fulfil demand with rare skills if
not found in the market.
• Analysis of resource skills on bench / buffer and fulfilling these resources to the current open demand so that no extra
resource is hired externally.
• Consolidated reports on demand and supply sent on daily basis, cost effectiveness analysis and hiring some suitable less
skilled resources for some demands.
• Being a reporting analyst, individually handled preparation of 20 reports and 4 presentations on ITD GD, ITS & AOD (2
depts. which got merged with ITD GD from MAR 09) in a week’s time which was highly appreciated by the senior
management of all 3 departments.
• Responsibility of sending 15 reports on demand and supply on daily basis, 3 fulfilment reports three times a week and 2
reports on Demand authentication and confirmation on a weekly basis was duly and accurately fulfilled.
• Appreciated for processing more than 150 invoices on daily basis for 2 weeks continuously with 94% accuracy.

TESCO HSC. — Bangalore, India 02/06 to 09/07

Payroll Officer
• End to end salary processed for 5000 employees from 30 stores comprising of all the elements of pay (Statutory Pay &
Deductions).
• Fallouts, divergence, variant, defrayal addressed weekly.
• Mails and Calls management for the entire payroll related queries.
• Tax amendments reconciliation, settlement and forecasting.
• Ensured all payroll queries are resolved accurately and within agreed timescales.
• Escalations resolved within SLA in absence of Team Leader.
• Mentored and trained new joiners in specific areas.
• Facilitating payroll team with various basic system issues.
• Trained our counterparts in UK on payroll issues and handled BCP situations.
• Appreciated for handling a team of 8 and processed payroll for 43000 employees across 200 stores in a BCP situation.
• Individually processed payroll for 5000 employees across 30 stores and maintained 100 % accuracy continuously for 8
weeks which was highly appreciated by the senior management.

INFOSYS — Bangalore, India 12/03 to 01/06

Payroll Officer
Appreciated for closing all tax certificate related queries within timeline and processing W2C (US tax certificate – Corrected form)
much before the deadline so that we could attain 100% accuracy.
• Salary processing for 7000 employees on a fortnightly basis.
• Ensured all payroll queries channelized through calls and mails were resolved accurately and within agreed timescales.
• Accounted payroll transactions and employee’s overseas settlements.
• Preparation of daily, weekly, monthly, quarterly and yearly reports with respect to salaries, loans and advances, US tax
and claim settlements.
• Briefing & Presentation to employees on various payroll process activities & knowledge on payroll tools and applications.
• Accounted and Reconciled W2 (US tax certificate) at year end with Indian tax certificates.
• Processed W2C (US tax certificate – Corrected form) in case of discrepancy in deducting taxes and in case of exception.
• Consulted employees with basic information in filing the US tax returns.