Photo

Kiran Kumar Gattoji Business system consultant

India
advance excelITIL certifiedVBA macros

Kiran Kumar Gattoji
Mobile: +918885637671

Email: [email protected]

Professional Summary

Overall 6 years of experience in both Operations and Technology.
Experienced in preparing and updating MIS reports with advance Excel and basics of VBA scripting.
Providing training to new and cross trained resources
Grooming of interested team members to learn various reports and making sure they are delivered with minimal errors
Experienced in transition process, preparing and updating SOPs and SLAs.
Good understanding on essential concepts of ITIL.

Areas of Expertise

Creation of Time Sheet for the team members which requires Excel & VBA scripting.

Evaluating the teams performance and creating action plans to achieve quality targets
Automation of reports to help reduce manual intervention
Successful Knowledge Transfer
Consistency in performance and maintaining quality and production metrics
Analytical skills to help increase the process scope of CVR process

Work Experience

Wells Fargo India solutions: Nov 2012 to till date

Technology Asset Operations (TAO):

DAF (Data center approval forms)

Ensuring IT operations effectiveness, IT availability/continuity and minimizing services interruptions by leveraging consistent governance, Practices, tools, methodologies, metrics and measurements.
TAO provides services and support on behalf of all LOBs and Technology teams within Wells Forgo.

Handles internal ordering, external purchase facilitations and financial allocation for hardware platforms.
Works on procuring hardware products like Infrastructure, products, and custom servers. Storage inventory items, I-series/mid range and mainframe products, , hardware upgrades and accessories, hardware and software maintenance related servers.
Work on data center approval forms and categorize production to different accounting terms.
Responsible for collecting project requirements requesting quotes from vendor and creating purchase order request to enterprise procurement.
Co-ordinate with different LOBs, Vendor, Data centers by assisting procuring the required products for Data center globally.

Vendor Management (VM):

VM works on renewing hardware and software maintenance/support for existing inventory post warranty period.
Runs inventory report from PAC2000, analyze and research the inventory works with supplier to compare Wells Forgo inventory list, supplier inventory list to get a budget quotes for further negotiations.
Coordinates with LOB Partners to get the Inventory validated when required. Conduct inventory true-ups in accordance with maintenance schedule definitions.
Works to help TOG achieve objectives through consolidation of agreements and management of inventory to minimize duplication.
Forecasts maintenance expense in line with business expectation, developing skills and processes for full accountability.
Identifies and tracks cost avoidance by working on Decommission of assets which are disposed.

Closing support:

Title Commitment:

Prepared Time sheet based on changes required by the clients.

Analysis on AIR reasons

CVR (closing validator resolution):

Analysis on new validations and added additional work for EGS

Cross trained to other process when there is a high in volume
Prepared work reports like EOD, BOD, SLA on timely bases and automated
Prepared common database with one time sheet which has reduce manual tracking of cross trained team members of over 60+
Automated major reports in CVR which helped manual work for FLMs
Suggested and implemented over 8+ ideas

Home Equity Title:

Proactively prepared time sheet for the new process including EOD snapshot which got appreciated by top management
One point of contact for home equity portfolio for MIS
Suggested 5+ ideas
Providing trainings
Managing team and SLA in the absence of Team lead.

Certifications

ITIL Foundation
MBA (Mortgage Banking Association)

Technical Skills

MS office advance excel
VBA Macros – basics

Strengths

Good at resolving in-depth queries in a systematic manner and can handle them independently
Have good team player skills.
Enjoys sharing knowledge among the team members.
Confident and Assertive approach towards challenges.
Good communication and interpersonal skills.
Experience of working in a highly regulated environment

Academic Qualification

Master in Business Administration from Anurag Group of Institutions, CVSR College, JNTU University. 2010-2012
Bachelor of Commerce from Bhavans Vivekananda College with Distinction, Sainikpuri, Affiliated to Osmania University. 2007-2010
Intermediate MEC (Mathematics, Economics, Commerce) from Railway Junior College, Hyderabad,
Achievements & Recognitions

WAC award winner – 2016 (Wells Fargo Annual Conclave)

Achieving Excellence Awards (AE) 1 and 3

Above and Beyond awards

Appreciation from Clients and from Internal management for maintaining consistency in Accuracy and Timelines

Single Point Of Contact for MIS reports

Over 10+ Idea projects and annual savings for the year 2016 is $86,000

New scope of work for my previous process (CVR)

Personal Information

Fathers Name Mothers Name Date of Birth
Marital Status Languages Known Passport No Permanent Address

: G. Gopi Acharya

: G. Umadevi

: 21st may 1988.

: Married

: English, Hindi and Telugu.

: K4177665

: H. no. 7-63/6, Harithapuri colony, near Panchamukhi temple, Nagaram – 500083

Place : Hyderabad

Date : G. Kiran Gattoji