Anil Kumar Devarasetti
(Overall 11 years of experience in MIS, Reporting, Analytics,
Banking, Project and Program management)
I am passionate about my profession and work.
Eager to learn new things and apply them to my work
so that I can improve myself.
Work Experience
10/2016 to till date
Account Manager (Freelance) – Opexpert Consulting, USA
Tasks:
•
•
•
•
•
-(-
linkedin.com/in/anil-kumar-devarasetti
http://msofficeguru.in
Skills & Competences
Beginner
Intermediate
Expert
MS-Excel, MS-Access, VBA, Automations
Gathering client job requirements
Screening candidates
Managing monthly billing
Scheduling Interviews
Client Management
07/2014 to 09/2016
Program Manager - Microsoft (as a vendor)
Tasks:
• Worked for Microsoft knowledge graph team to maintain accurate and updated information in
Bing search engine results.
• Delegating work to team members and auditing their quality
• Creation of process documentation and training methodologies for newbies
• Responsible for designing, implementing and managing custom quality assurance framework
including recruiting & training practices, quality validation and reporting processes, corrective
actions framework.
• Streamlining all process by creating standard framework with KPI/Metrics
• Driving 3PP (Third party partners) video development team for onboarding 27 third party
partnerships to enable content, across several geographies
• Worked with MS-India internal development team (desktop and mobile apps) for automating
dashboards, and research on features to improve the user experience and increase revenue
MIS & Reporting, Business Analyst
Power BI
Project/Program Management
C, C++, Core Java, C#, .net
Oracle, SQL server, MySQL
Corporate Training (MS-Office)
Certifications
Microsoft Office Specialist Master –
2010/2013 from Microsoft
01/2014 to 06/2014
Corporate Trainer (Freelance)
Tasks:
•
•
•
Conducted training sessions on Excel and VBA as freelance trainer for 60+ CGI, GE employees.
Conducted training sessions on Excel, Access and VBA through Renown Analytics, HYD for
300 + students.
Conducted Microsoft certifications overview session to all engineering students in Narasaraopet
Engineering College, Narasaraopet, Andhra Pradesh
Microsoft Certified Trainer
Excel TTT (Train the Trainer)
certification from Aptech and
Cognizant collaboration.
05/2010 to 12/2013
Team Lead – MIS & Reporting, Cognizant Technology Services
Tasks:
• Designed and implemented web based analytics tool for live reporting about the process/projects
• Providing Weekly Resource Utilization and Performance reports to the operations which will
helpful to review the status of Business for the senior management
• Review/Update Process Dashboards on the lines of Productivity, Quality, Resource Utilization
and Efficiency for the entire operations team.
• Providing Highlights to the Operations team on their performance, hiring, attrition and transitions
on monthly basis.
• Reviewing monthly “Two Months Variance Report” for any discrepancies and ensuring all the
variances are highlighted.
• Reconciliation of Weekly/Monthly Headcount reports with HR.
• Automation of reports in all possible areas by using Excel VBA.
• Developing New Templates for Operations to reduce the manual time of their Reports.
• Guide the Team Members on preparing new Templates and Adhoc Reports.
• Trained more than 1200+ employees on Excel, VBA.
Internal Projects:
1. CPRT (CoreLogic performance reporting tool)
2. Quality Time Tracker
3. Automated commenting system
4. Compliance report (developed for 8 processes)
02/2006 to 02/2010
Team Lead – MIS, APEX Logical Data Conversion pvt.ltd
Tasks:
•
•
•
•
•
•
Validating the Data updated by team members.
Preparing Daily, Weekly and Monthly Production reports to Manager
Preparing monthly Report of Total Employee Production, Best Performer Awards.
Preparing Revenue Report with the Complete Distributed Batches, Pending Batches details.
Developing new SQL Queries to get the data quickly from database.
Communicating with Process Managers about the business trend reports and designing templates
according to their requirements.
Internal Projects:
1. Web based production system
Achievements
Received 4 kaizens for automation
tools which assisted operations team
to improve quality and increase
productivity.
The pilot training for VBA-Excel
conducted by me in Cognizant
Academy India
Youngest Microsoft Certified
Trainer in MS-Office in India.
Education
Master of Computer Applications (MCA) from KRRIIT, Osmania University, Hyderabad
2003 to 2006
Bachelor of Science – BSc (Mathematics) –
from SKRBR College, Narasaraopet
1999 to 2002
