G Pavan Kumar

To be a part of an organization that provides an atmosphere of steady career growth and benefits, where I can utilize my analytical and technical skills for the betterment of the organization and make a mark as a disti2nguished professional. Detail-oriented Business Analyst with 2 years of experience conducting analysis and research to come up with solutions to common business problems. Polished in formulating business improvement strategies and overseeing new technology and system implementation. Commercially-aware professional with in-depth knowledge of computing systems and project management techniques.

• Received 2 awards for in-time project delivery.
• Received Certificate of Appreciation for the Johnson and Johnson project for delivering project before time.

Total 7 years of Industry Experience in MIS Reporting and VBA macros and Ui-Path developer. Have done automations on PPT, Outlook, Web, MS Word, and MS Access using EXCEL VBA Macros and UI-Path. Have demonstrated strong ability to work in a team to achieve team goals. Have always achieved targets with a focus on quality and a high degree of flexibility & optimism. Connecting from Excel to Access Database, SQL database through VBA macros. Have trained 2 batches on VBA macros. Completed projects using VBA macros, Ui Path, Power-Bi, and Automation Anywhere. Completed 2 projects on DFI in Client location (Accenture).

• Title: Lead Business Analyst
• Date of Birth: 07/01/89
• Nationality: Indian

English, Telugu & Hindi

Trainer Utilization and Tracking Tool, MS Excel, Visual Basic for Applications, MS Outlook Inspector, HTML Data Objects, Internet Explorer Controls, For tracking multiple trainers and their occupancy on daily and hourly basis. Multiple trainers are working for conducting panels in various technologies. This tool helps for the Customer Success Managers to monitor their hourly occupancy and for their costing analysis. Developed a bot using Excel VBA Macros and Outlook that updates the details in a tracker and intimates specific trainers automatically. All trainer's occupancy can be seen in a web portal. Resulted in 2 FTE benefit from this automation. 

• Data Consolidation and Email Tracker in Outlook, MS Excel, File Scripting Object System, Visual Basic For Applications Program, Outlook Object Library, Automates the process of fetching data/mails from Outlook based on subject. Saves all the files to a folder from Outlook using a tracker tool, consolidates the data from various files, and performs reconciliation. Developed a bot using Excel VBA Macros that updates the tracker and publishes the report. Resulted in 2 FTE benefit from this automation.

• Training on VBA and Excel Dashboards

• Completed Master Certification in Automation Anywhere.
• Completed Advanced Certification in Ui-Path.