VBA (Visual Basic for Applications)
Kiran Kumar Yeruva
Senior Business Analyst/Senior Content Developer
Hyderabad
Summary
Perceptive Senior Business Analyst with 7 years driving successful business processes for various accounts in Cognizant. Delivered more than 70 projects which resulted 100+ FTE benefit. As a Content Developer (in 6 Years) delivered more than 150+ training modules and SOPs.
Overview
22
22
years of professional experience
Work History
Senior Business Analyst (Team Manager)
Cognizant Technology Solutions Pvt Ltd
04.2010 - Current
- Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies.
- Participated in automation feasibility study, prepared book of work for each year and prioritized the automations based on the benefit
- Co-ordinated with SMEs to gather requirement
- Created FDD (Functional Designing Document) for each automation and ensured each automation is followed agile methodology
- Developed VBA based automations (Web Based, Mainframes and Excel based)
- Created Automation Framework and ensured each automation fits in the framework
- Participated in stakeholder reviews (pre-production and post-production) and derived the benefits for each automation
- Used SQL to download required data from various sources
- Created interactive dashboards using excel slicers and pivot tables for mid level leadership
- Created 150+ training materials and SOPs to support trainers and operations
Instructional Designer
Magna Infotech Pvt Ltd
03.2008 - 04.2010
- Analyzed content & designed FDD (Functional Designing Document) for each module – outlining no.of topics for each module, objectives, assessments, content and appropriate instructional strategy.
- Scripted storyboard for each module
- Coordinated with graphic design teams and programming teams in production process
- Created style sheets to ensure consistent look throughout the course
- Maintained version control tracker
- Used development tools according to defined standards
- Participated in client reviews (pre-production (story board phase) and post-production)
Instructional Designer
Freelancing
09.2006 - 02.2008
- Made thorough content analysis of school subjects to identify the modules/chapters
- Identified level-2 assessments (to measure the learning outcomes) based on the objectives
- Created Functional Design Document for each chapter/module – outlining the no. of topics for each modules, objectives, assessments, content, and appropriate instructional strategy
- Scripted storyboard for each module
- Coordinated with graphic design teams and programming teams in production process
- Used development tools according to defined standards
- Participated in pre and post-production review sessions
Computer Instructor
St.Claret High School
06.2002 - 08.2006
- Set up computers and networking systems, delivering step-by-step instructions on basic use.
- Planned and implemented curriculum to teach up-to-date technology to 600 students.
- Designed appropriate and specialized lesson plans for students.
- Created level-2 assessments (to measure the learning outcomes) based on the objectives
Education
MBA (Master of Business Administration in Finance)
Sikkim Manipal University (Distance)
Hyderabad03.2008
Bachelor of Arts - B.Com (Bachelor of Commerce)
Vidya Jyothi Degree College
Warangal 04.2001 -
Associate of Arts -
Vidya Niketan Junior College
Warangal 04.2001 -
High School Diploma -
St. Alphonse High School
Karimnagar 04.2001 -
Skills
VBA Automations
Forecasting and Planning
Data Analysis
Operations Analysis
Business Process Mapping
Content Development
Software
Word, Excel, PowerPoint and Power BI
Articulate, Captivate, Camtasia, Epiplex
HTML and CSS
Timeline
Senior Business Analyst (Team Manager)
Cognizant Technology Solutions Pvt Ltd
04.2010 - Current
Instructional Designer
Magna Infotech Pvt Ltd
03.2008 - 04.2010
Instructional Designer
Freelancing
09.2006 - 02.2008
Computer Instructor
St.Claret High School
06.2002 - 08.2006
Bachelor of Arts - B.Com (Bachelor of Commerce)
Vidya Jyothi Degree College
04.2001 -
Associate of Arts -
Vidya Niketan Junior College
04.2001 -
High School Diploma -
St. Alphonse High School
04.2001 -
MBA (Master of Business Administration in Finance)
Sikkim Manipal University (Distance)