Work History

Work History
Feb 2014 - Present

Analyst

Tesco HSC

As an Analyst responsible for following activities.

  • Reports Handling :
  • Handling various Ad-hoc requests.
  • Extracting data from web application and creating Social Media report.
  • Complaint analysis by Suppliers.
  • Quality report by product category and Sub category.
  • Complaints report by product category and Sub category.
  • Sales report by UK Stores.
  • Performance Analysis by Store Executives.
  • Sales Report by product category and Sub category.
  • Weekly & monthly KPI report by UK Stores.
  • Automation :
  • Developing & Supporting Excel VBA applications across multiple business lines.
  • Identifying problems, propose solutions in agreement with the users.
  • Strong support experience across onshore and offshore models.
Mar 2011 - Feb 2014

Sr. Associate - Reporting & Analytics

VWR International

As a Senior Reporting Analyst responsible for following activities.

  • Reports Handling :
  • Reporting to Reports & Metrics Manager, Belgium for European reports and Reporting to Sr. Vice President, Vice President and General Manager, APAC Region for Asia Pacific Reports.
  • Individual Contributor on Reporting for Asia Pacific Countries.
  • Using multiple queries in QlikView and Creating reports.
  • Using multiple transactions in SAP & pulling pricing details for the products and creating pricing and savings analysis reports.
  • Handing multiple Queries using tools BEx Designer /Analyzer
  • Handling and creating reports in multiple currencies.
  • Daily, Weekly & Monthly dashboard for Singapore sales representatives.
  • Spend and Monthly KPI Reports for European & Asia Pacific Customers.
  • Handling various Ad-hoc Reports like Rebate Tracking, Savings Report, Pricing Analysis, Profitability and Loss Reports.
  • Documenting the Reports.
  • Quality Check :
  • Using different type of methodology for capturing the errors on the reports.
  • Handling multiple Quality inspection tools and helping to achieve team’s quality score.
  • Conducting technical training to the team members if team’s quality score is below the target.
  • Taking necessary actions for reducing the errors.
  • Automation :
  • Developing & Supporting Excel VBA applications across multiple business lines.
  • Identifying problems, propose solutions in agreement with the users.
  • Strong support experience across onshore and offshore models.
  • People Development :
  • Developing people as a backup for APAC reports in my absence.
  • Conducting trainings sessions for New Joiners in the Team.
  • Management Activities :
  • Reporting about Team Key Performance Indicator.
  • Taking care of the team in Team Leader’s absence.
  • Creating PPTs for Monthly Team reviews.
Oct 2009 - Feb 2011

Executive - MIS

GS Vidyud Financial Services Pvt Ltd

From Jun 2010 to Feb 2011 – Administration Department.

  • General Administration.
  • Handling day to day activities.
  • Designing automation for maintaining admin utilities like Liasioning billing Tracker, Consumable billing Tracker.
  • Developing VBA automation for maintaining Transportation Transactions.
  • Procurement of Stationery and other items and ensuring minimum fill.
  • Coordinating the travel arrangements and logistics support for the officials and arrangement of accommodation.
  • Expert in making admin related MIS reports.
  • Good experience in coordinating with vendors and handling vendor payments.
  • Exposure on essential admin functions like housekeeping, security, facility, transportation, cafeteria management, AMC, office maintenance, security etc. 
  • Capable of conducting daily routine checks and cleanliness and maintenance issues.

From Oct 2009 to May 2010 – Customer Service Department.

  • Reporting about daily activities of VF Stores such as Daily Postpaid, prepaid, handset sales, VAS upselling, Payment collection, Profitability, Tracking Customer Walk-ins etc.,
  • Coordinating & Follow ping with VF Store managers for Sales Lead activities.
  • MIS Coordination about Vodafone Stores and Relation & Retention Activities.
  • Tracking Retention & Relationship manager’s Visits on daily basis.
  • Creating VBA tools for the reports.
  • Preparing PPTs for Monthly, Quarterly & annual Reviews.
  • Preparing Incentives for Field Executives against Field Reactivation.
  • Coordinating with Tele-calling team for Increasing Postpaid Sales.
Mar 2008 - Sep 2009

Executive – MIS & Reporting

Contract Employee @ Indus Towers Limited

As a MIS Executive responsible for following activities:

  • MIS about EB & Panjayat liasioning work.
  • Allocating the Vendors for EB & Panjayat liasioning work.
  • Coordinating with Nokia team for Project work.
  • Preparing and maintaining DPR.
  • Visiting sites directly for TNEB & Panjayat issues also Landlord Issues.
  • MIS about Network problems.
  • Automating the reports with VBA coding in Excel.
Jun 2007 - Mar 2008

EDP In-charge

Fisher Pumps Private Limited

As an EDP in-charge responsible for following activities:

  • Performing the anti-virus Updates on daily basis.
  • Updating Network Installation/Maintenance.
  • Troubleshooting Think-centre (desktops) and Think-pad (Laptops) related problems.
  • Diagnosed resolve network connectivity issues throughout the organization.

Education

Education

Skills

Skills

Data analysis & Reporting

MS Excel

VBA Macro in Excel

MS Office Package

BEx Designer and Analyzer Tools

SAP BI/BW 7.1

SAP 6.40

QlikView 11

Humming Bird Business Intelligence 10

Teradata 14.0

SQL Server Management Studio 10.50.1600.1