Management Information System Manager


Last Updated: 14th June 2019 (over 3 years ago)

Address
India

Category

E-mail
Locked

Phone Number
Locked

Gender
Male

Age Range
25 to 34

Qualification Level
Degree

Languages
English

Summary

Sundaram Venk atachalam Ad d ress:
Phone: +91 9600075785 Plot No - 19, Door No - 8, Gnanaraj
swamy.fca2@gmail.com Salai, Sembakkam, Chennai - 600073
Overview
Result oriented & innovative professional close to 8 years of experience in Operations relating to Client
Management & information support relating to business process flow.
Successfully coordinated with clients worldwide to achieve strategic objectives as per Statement of Work
(SOW), Statement of Process (SOP) and Service Level Agreements (SLAs).
Ensure KPIs are reaching their benchmarks as per the client's requirement.
Skilled in MS Office, specialized in Advanced Excel.
Excel Expert with success in maintaining and organizing data, including dictionaries, metadata repositories,
and cross-reference indexes across a broad range of industries.
Skilled in VLOOKUP and INDEX MATCH formula development, Pivot Table generation, and Pivot reporting.
Demonstrated ability to use critical and strategic thinking to resolve discrepancies, fill gaps, and sustain
quality control benchmarks.
Core Com petencies
Data Management
Data Entry
Pivot Table Development and Management
Process Improvement
Reporting
W ork Ex perience
WI P R O LI M I TED:
Designation : Executive
THE BOSTON CONSULTING GROUP: From 11/08/2017 till date
R ol es & R esp on si bi l iti es:
Handling reporting for 28 offices handled by three different locations every month.
Single point of contact for all the 28 offices on the MIS part and reporting.
Generating reports from the first day of the month and send it to all the offices for their comments on the
below area:
o Accuracy of the invoices processed
o TAT took by each and every agent for all the invoices they processed.
o TAT calculation for the invoices received and action taken
o TAT calculation for the emails handled by each agent for the previous month
o Quality of the invoices processed from the client's end.
o Any other queues that the agents have worked on the provide the TAT % accordingly
Team Leadership
Quality Assurance
Time Management
MS Excel VBA
Reports on various other aspects on the invoices processed, payments made, compliance of fields for
processing the invoices, new vendors report, paper vs email invoices report, pending invoices report etc.,.
Preparation of the Monthly Business Review presentation with the reports procured from various offices and
provides them breaking it in four different regions.
Preparation of the business reviews for all the offices (28 approx.) separately and provide them every month.
Additional responsibilities in simplifying the process for the agents processing the invoices like, automation of
multiple line item invoices etc.
Quarterly business review preparation and ad-hoc reports on a daily basis from all the 28 offices.
Trained on the interactive dashboard software and reported the data to the clients and was appreciated.
Trained with TABLEAU for providing dashboards in an interactive manner.
Having a good rapport with the clients and helping them to identify the areas of improvement in their business
by providing dashboards to monitor their growth.
BLI NK R ES EAR CH & S ER VI CES :
Designation : MIS Executive
TRIKA & CHANGE CLASS: From 03/08/2016 to 05/08/2017
R ol es & R esp on si bi l iti es:
Ensure to generate daily and weekly reports on the work done by the team on various program.
Formulation of budget for a specific program and ensure to work hand in hand with the finance team and get
the actual and report the same to the management.
Coordinate with the subordinates on completion of daily reports and cascade the same to the management
without errors.
Conduct weekly meetings with all the team members and project them with all the reports for the team to
understand the budget vs actual to work better on the efficiency of the work done.
Measuring the performance of the team and providing quarterly feedbacks to the management.
AM AZ ON.COM :
Designation : Retail Associate
CMT: NA Soft lines & SWAT –From 19/08/2015 to 22/07/2016
R ol es & R esp on si bi l iti es:
Monitoring product pricing for North America location and determine a suggested price for every product in
our website.
Monitor prices for various ledgers including Apparels, Watches & Luggage.
Research the market price of each of the product through market analysis and determine suggested price for
each and every product.
Categorize different ledgers and products based on the different criteria such as Gender, Sizes and Color
pattern through which the analysis is executed.
Preparing productivity report for the entire team and circulate it on a monthly basis to all the other associates
and the management for them to evaluate the performance of each individual.
S HELL I NDI A M AR KETS P VT LTD:
Designation : Analyst
NA Domestic Crude: Trading & Settlements –From 06/07/2012 to 03/09/2014
R ol es & R esp on si bi l iti es:
Handle critical and non-critical Counterparties (Vendor/Customer) with whom we trade on a monthly basis.
Obtain proper information from the Counterparties on the trades for the month.
Create pivot tables and charts using worksheet data and counterparty information, modify pivot tables, sort
items and group data, and refresh and format pivot tables to identify net traded value.
Check with our internal system and provide our details and match them.
Handle any discrepancies that we have with the monthly trades along with the help of the Operations team in
Houston hand in hand.
Finalize the trades in our system and with proper confirmation we make arrangements to the treasury team to
settle the funds with the Counterparties.
Handle emails and calls regarding the settlement activity on a daily basis.
Prepared routine and ad hoc status reports to identify current standing of the balances.
Clearance of open balances if settled with any discrepancy on a monthly basis to avoid accruals, interest
charges and reports has to be submitted weekly.
Allocation of funds to the proper Vendor/Customer accounts every month post settling of funds.
Designed, recorded, and executed macros to automate data entry inputs.
To train a new joined colleague and take responsibility of his/her work activities for minimum of 2 months.
WI P R O BP O P VT LTD:
Designation : Officer
Johnson and Johnson & KLA-Tencor: Quality, MIS & Payment Management –From 18/05/2009 to 02/05/2012
R ol es & R esp on si bi l iti es:
Categorize received documents and obtain proper information from the documents received.
Fix proper titles and make sure to arrange the documents in the client tool in proper areas.
As a Quality check, find out errors done by the team assigned and provide proper feedback to the agents in
the team and prepare reports and submit the same to the management.
Prepare a report of all the work done by the associates and submit the same to the management for business
improvements and performance.
Handling email queries regarding invoice details, payments and other issues requested by the vendors.
Providing payment dates for the invoices and obtain information like tax rates and others.
Handling calls for the queries of the vendors regarding payments, tax issues, certificates, payment methods
and other information required.
Maintaining trackers and providing weekly reports, monthly reports to the management.
Achievem ents
Have done a project to automate certain functionalities which saved a lot of time and errors in Shell.
Have achieved 100% quality for several months and have given maximum productivity in all my jobs.
Awarded as star of the quarter for several times.
Participated in Inter College and Intra College Commerce Fest.
Have won certificates in inter college fests in “Dance”
Participated in District level tournaments for cricket.
Have won the Zone level Championship for Shuttle Badminton representing my school.
Have won the Interdepartmental Championship for Shuttle Badminton in Amazon.
Education
Personal Details
Father's name : S. Venkatachalam
Date of Birth : 20/06/1989
Marital Status : Married
Y ear Course Inst itut ion/ Scho ol/ College P ercentage
2006-09 B.Com Loyola College 61%
2005-06 XII Mat Shanthinikethan.Mat.Hr.Sec.School. Chennai-73. 80%
2003-04 X Mat Shanthinikethan.Mat.Hr.Sec.School. Chennai-73. 68%

Education

Loyola College
Bachelor of Commerce

   Jun 2006
— Apr 2009

-

Experience

Wipro Ltd.
MIS Executive

   Aug 2017
— May 2019

Handling reporting for 28 offices handled by three different locations every month.
Single point of contact for all the 28 offices on the MIS part and reporting.
Generating reports from the first day of the month and send it to all the offices for their comments on the
below area:
o Accuracy of the invoices processed
o TAT took by each and every agent for all the invoices they processed.
o TAT calculation for the invoices received and action taken
o TAT calculation for the emails handled by each agent for the previous month
o Quality of the invoices processed from the client's end.
o Any other queues that the agents have worked on the provide the TAT % accordinglyReports on various other aspects on the invoices processed, payments made, compliance of fields for
processing the invoices, new vendors report, paper vs email invoices report, pending invoices report etc.,.
Preparation of the Monthly Business Review presentation with the reports procured from various offices and
provides them breaking it in four different regions.
Preparation of the business reviews for all the offices (28 approx.) separately and provide them every month.
Additional responsibilities in simplifying the process for the agents processing the invoices like, automation of
multiple line item invoices etc.
Quarterly business review preparation and ad-hoc reports on a daily basis from all the 28 offices.
Trained on the interactive dashboard software and reported the data to the clients and was appreciated.
Trained with TABLEAU for providing dashboards in an interactive manner.
Having a good rapport with the clients and helping them to identify the areas of improvement in their business
by providing dashboards to monitor their growth.

Blink Research and services
MIS Executive

   Aug 2016
— May 2017

TRIKA & CHANGE CLASS: From 03/08/2016 to 05/08/2017
R ol es & R esp on si bi l iti es:
Ensure to generate daily and weekly reports on the work done by the team on various program.
Formulation of budget for a specific program and ensure to work hand in hand with the finance team and get
the actual and report the same to the management.
Coordinate with the subordinates on completion of daily reports and cascade the same to the management
without errors.
Conduct weekly meetings with all the team members and project them with all the reports for the team to
understand the budget vs actual to work better on the efficiency of the work done.
Measuring the performance of the team and providing quarterly feedbacks to the management.

Amazon.com
Retail Associate

   Aug 2015
— Jul 2016

Monitoring product pricing for North America location and determine a suggested price for every product in
our website.
Monitor prices for various ledgers including Apparels, Watches & Luggage.
Research the market price of each of the product through market analysis and determine suggested price for
each and every product.
Categorize different ledgers and products based on the different criteria such as Gender, Sizes and Color
pattern through which the analysis is executed.
Preparing productivity report for the entire team and circulate it on a monthly basis to all the other associates
and the management for them to evaluate the performance of each individual.

Shell India markets pvt. limited
Analyst

   Jul 2012
— Sep 2014

Handle critical and non-critical Counterparties (Vendor/Customer) with whom we trade on a monthly basis.
Obtain proper information from the Counterparties on the trades for the month.
Create pivot tables and charts using worksheet data and counterparty information, modify pivot tables, sort
items and group data, and refresh and format pivot tables to identify net traded value.
Check with our internal system and provide our details and match them.
Handle any discrepancies that we have with the monthly trades along with the help of the Operations team in
Houston hand in hand.
Finalize the trades in our system and with proper confirmation we make arrangements to the treasury team to
settle the funds with the Counterparties.
Handle emails and calls regarding the settlement activity on a daily basis.
Prepared routine and ad hoc status reports to identify current standing of the balances.
Clearance of open balances if settled with any discrepancy on a monthly basis to avoid accruals, interest
charges and reports has to be submitted weekly.
Allocation of funds to the proper Vendor/Customer accounts every month post settling of funds.
Designed, recorded, and executed macros to automate data entry inputs.
To train a new joined colleague and take responsibility of his/her work activities for minimum of 2 months.

Wipro Ltd.
Officer

   May 2009
— May 2012

Categorize received documents and obtain proper information from the documents received.
Fix proper titles and make sure to arrange the documents in the client tool in proper areas.
As a Quality check, find out errors done by the team assigned and provide proper feedback to the agents in
the team and prepare reports and submit the same to the management.
Prepare a report of all the work done by the associates and submit the same to the management for business
improvements and performance.
Handling email queries regarding invoice details, payments and other issues requested by the vendors.
Providing payment dates for the invoices and obtain information like tax rates and others.
Handling calls for the queries of the vendors regarding payments, tax issues, certificates, payment methods
and other information required.
Maintaining trackers and providing weekly reports, monthly reports to the management.

Search Jobs by Industry

Ad
Ad
Ad