S SHANKARA SHANDILYA
PMO - MIS manager
Bangalore
Summary
Certified Business Continuity Management Specialist, Reconciliation Statements, Advanced Excel, Forex Payments (Employees), Client Reconciliations, Internal Audit, MIS reports
System Reconciliation with above 5Lakh line items within one day
Advanced Excel for quick and complete Data analysis
Overview
26
26
years of professional experience
7
7
years of post-secondary education
1
1
Certification
6
6
Languages
Work History
PMO – MIS Manager
Juniper Networks Account
06.2019 - Current
- Monthly Metrics submission
- Agile Sprint Metrics, Code quality metrics, Maintenance metrics, Project metrics
- Data consolidation, Project updates, Weekly and Monthly – Operations report
- Data Consolidation, preparation of Quarterly Business Reports
- Automated Jira Report – Consolidation of estimation and actual time spent of the jira and project, so that we are on the right path of closing the monthly reports, and follow-up if corrections required
- Client Billing – Forecasting (Human Resource)
- End to end process of Onboarding and offboarding for the account
- H1B Process Assistance
- Project Administration
Business Operations Professional
IBM India Pvt Ltd.
01.2013 - 05.2019
- Estimation of projects WRT to FTPs while coordinating with the Development Team and completing the estimates and upload the required documents in the required places
- Consolidating the Projects as per the Gateway wise for the release as and when required
- MIS reports
- PMO Activity
- SPOC for learning and knowledge
Project Associate - PMO Activity
IBM India Pvt Ltd.
04.2011 - 05.2019
- Internal Audit for checking the Documents are uploaded in the required format required version with required information and Places
- Audit the Documents required for the Release of the Project
- PMO Activity -Tracking Previous Month Changes
- Supporting Claim related activities to the Planning and control Activities
HR Executive
IBM India Pvt Ltd.
02.2007 - 04.2011
- Forex Advance & Recoveries
- Reconciliation with the Bank for the Advance issued and recoveries
- Employee Advance Accounts Reconciliation
- Exceptional Reports – Analyzing and recover the advances if the forex was issued and not travelled
- Accounting - Payment Entries
- Monthly Allowance Payments – Analyze and make payments as per the norms and conditions
- Weekly Payment Reconciliation – Analyzing whether the bank has executed the payments as advised (Part of BRS)
- Duplicate payments Investigation – Analyzing the duplicate claims which are paid twice due to Different Claims
- Analyzing, Reporting and Recovery of Duplicate/Excess payments
- Recovering of the Excess payments made to the employees
- Checking with Employees who have claimed out of Policy – Analyzing the claims which are not supposed to be claimed under HR Policy
- Full and final recovery with respect to Employee Payables (Any advances and Claims for payments will be checked while update)
Finance Executive
Spearhead Services Pvt Ltd.
06.2006 - 02.2007
- Company Overview: Honeywell Technologies Solutions Lab Pvt Ltd
- Employee Claims Process
- Weekly Payment Reconciliation – Analyzing whether the bank has executed the payments as advised (Part of BRS)
- Employee Car Loan Policy – Ensure of Car delivery and get the documents along with the Bank agreements for the Car loan
- Reconcile the account every month for the closure and new loans created with the respective banks and provide the report to the Treasury Department
- Reports for the Asset Verification (No
- Of Laptops) for the purpose of insuring
- Honeywell Technologies Solutions Lab Pvt Ltd
Accounts Executive
Mitsun Steels Pvt Ltd.
01.2005 - 05.2006
- Automated a Consolidated report through Excel for the preparation of Consignment Statements which is used even today
- Automated a Consolidated Supplier Report, where the Supplies towards Purchase orders were recognized and Follow-up for the Payments were made easy
- Even this statement is being used even today
- Computerized Accounting (Tally 6.3 & 7.2 version)
- Handling Cash
- Bank Reconciliation Statement
- Auditing the Basic Reports for Accounts
- Consignment Statements Finalization (Monthly)
- Payable Reconciliation – Vendors Accounts
- Preparation of Reports (MIS)
- Billing for Transportation Charges(Transportation Division)
- Reconciliation Statements (Transport Division & General Trading Clients.)
- Professional Tax Computation and Remittance
Accounts Assistant
Group Four Securitas Guarding Ltd.
10.2003 - 12.2004
- Computerized Accounting (Company Generated Financial package)
- Cash Transaction & Handling Cash
- Preparation of MIS Reports, Client wise Analysis, Wage Analysis, and Client Age wise Analysis
- Random Checking of the computed wages & Competing with Statutory requirements
- Generation of Reports and submission to Higher Authorities
- Billing & invoicing by Co-ordinating with Operation Managers
- Motivating & Co-ordinating with the Collection Executives
- Preparation of Special Allowances for Guards & Supervisors
Senior Accounts/Audit Assistant
Sangram & co., Auditor & Tax Consultants
06.2001 - 01.2002
- Maintained Accounts for Epowern Technologies Pvt
- Ltd., Rajajinagar
- Maintained Accounts for Suresh Systems, Rajajinagar
- Bank Reconciliation Tally 4.5, 5, 5.4
- Audited Sridhan Internationals (P) Ltd., Basavanagudi
Accounts/Audit Assistant
Harish & Co., Chartered Accountants
02.2000 - 07.2000
- Computerized Accounting Tally 4, 4.5, 5
- Stock Register Preparation
- Filling Returns of Sales Tax for Electrolux Kelvinator, Bangalore Branch
- Filing Returns of Income Tax
Audit Assistant
Akki & Rao Chartered Accountants
06.1999 - 11.1999
- Audited Accountants of KIADB
- Audited Stock Register of KSSC
- Audited the Stock book, Cash book, Accounts of Retail outlets of KSCDC
- Computerized Accounting Tally 4.5
Education
B.Com -
Vijaya Evening College
01.1996 - 01.2001
PUC - undefined
MES College
01.1994 - 01.1996
E-Commerce
ECIL-BDPS
Skills
Certified Business Continuity Management Specialist
Reconciliation Statements
Advanced Excel
Forex Payments
Client Reconciliations
Internal Audit
MIS reports
Agile Sprint Metrics
Code quality metrics
Maintenance metrics
Project metrics
Agile methodology
Database administration
Business intelligence
Workflow coordination
DevOps principles
Enterprise resource planning
IT service management
IT operations management
Excellent communication
Self motivation
Decision-making
Multitasking Abilities
Problem-solving abilities
Time management
Alternate Number
7892306931
Personal Information
- Father's Name: Lt. N. Subbananjunda Sastry
- Date of Birth: 04/09/78
Certification
Business continuity plan
Timeline
PMO – MIS Manager
Juniper Networks Account
06.2019 - Current
Business Operations Professional
IBM India Pvt Ltd.
01.2013 - 05.2019
Project Associate - PMO Activity
IBM India Pvt Ltd.
04.2011 - 05.2019
HR Executive
IBM India Pvt Ltd.
02.2007 - 04.2011
Finance Executive
Spearhead Services Pvt Ltd.
06.2006 - 02.2007
Accounts Executive
Mitsun Steels Pvt Ltd.
01.2005 - 05.2006
Accounts Assistant
Group Four Securitas Guarding Ltd.
10.2003 - 12.2004
Senior Accounts/Audit Assistant
Sangram & co., Auditor & Tax Consultants
06.2001 - 01.2002
Accounts/Audit Assistant
Harish & Co., Chartered Accountants
02.2000 - 07.2000
Audit Assistant
Akki & Rao Chartered Accountants
06.1999 - 11.1999
B.Com -
Vijaya Evening College
01.1996 - 01.2001
PUC - undefined
MES College
01.1994 - 01.1996
E-Commerce
ECIL-BDPS