Business Process Analyst Resume Profile

Summary

Seeking a challenging and rewarding position in VBA/Macro development as a value added resource in a creative/diverse organization for complex to simple, multi-tier VBA development.

Synopsis

4.5 years of experience in MS Office VBA development, Business Process improvements, SLA KPI and MIS Reporting.
Currently working as corporate Business Process Analyst Sr. VBA Developer for Infosys BPO Ltd. Scope: Organization wide
Headed Business Improvement Team for Infosys client and established Automations team in State Street Syntel Services Pvt. Ltd.
ASCB certified LEAN Professional. Yellow belt certified.
AutoBank for SAP implementation and Maintenance.
End to End Process automations with MS Excel and MS Access based VBA development incl. Solution designing-To-Testing and Implementation
Worked as VBA Trainer.
Worked on variety of LEAN projects.

Snippet of VBA Tools developed:-

Sr. No.	Macro Name	Applications
1.	Advanced Recon Tool	MS Excel
2.	SLA Report Self Check Tool	MS Excel
3.	Global Trade Automated Checklist	MS Excel, MS Access
4.	GL ICA Reconciliation Tool	MS Excel
5.	ICA Difference Reporting Tool	MS Excel, MS Outlook
6.	ICA Dunning Tool	MS Excel, MS Outlook
7.	AM/PM Comparison Macro	MS Excel, MCH, Hogan
8.	GL Fixed Asset Reconciliation Tool	MS Excel
9.	F A Control Check Templates	MS Excel
11.	Variety of Tools with SAP R/3 connectivity	MS Excel , SAP /R3
12.	Variety of tools with Mainframe connectivity	MS Excel, IBM Mainframe
13.	Variety of MIS Data consolidators	MS Excel

Organizational Experience

Overview

A highly self-motivated professional VBA developer, with a verifiable record of accomplishment, spanning more than 4.5 years. Highly creative, multi-skilled, recognized as a results-oriented and solution-focused individual.

Areas of strength include:

End-To-End VBA Development
Customized MS Office development
Autobank for SAP Implementation
SLA-KPI Reporting
Data Analysis
Eye for Detail

Confidential

Business Process Analyst

Scope: Corporate Quality group of Infosys BPO. This is one of the leading team in organization working towards establishing quality values across organization and fulfilling customer delight.
Handling 8 clients in various domains like Finance Accounting, Banking, Insurance, Pharmaceuticals, etc.
Understanding the various processes and help streamlining business with Automation skills.
Yellow belt trained and certified.
End-to-end VBA development for complex processes.
Documentation of the tools developed User Guide and Technical documentation for future reference.

Confidential

Sr. Associate

Sr. VBA Developer

Working as a Sr. MIS Analyst/VBA developer for 4 processes.
Worked with Risk and Compliance Team to reduce risk factors from various processes by automating various manual processed involving risks.
ASCB UK based accreditation certified LEAN professional.
Auditing of in-house macros as per GMAS standards.
All types of MIS Reporting Includes various SLA KPI, Client specific reports
Maintenance of various client provided macros.
SOP audit and finding Non-Value Added activities for Process improvements and automation of the same.
Providing innovative ideas as Business solutions to the clients in streamlining the process.
SLA KPI consolidation reporting on daily, weekly monthly basis.

Recognition/Rewards/Accomplishments :

Recognized as Approver for all In-House macros for entire organization.
Completed Lean project : Self Check Tool. Jidoka Lean based on Poka-Yoke
Worked with Business Excellence and Risk-Compliance Team to eliminate manual risks with Automations.

Confidential

Sr. Process Executive

Headed Business Improvement Team for Accounts Receivable.
Reviewing processes to find improvement areas within AR department
Monthly/Weekly SLA KPI consolidation and reporting for AR process.
Transaction billing for AR process.
Review improvements in Macros maintenance thereof e.g. ICS 092 Unapplied Cash , Cash application timeliness tool, SLA report, Cr.-Dr. Matching macro, ECC vs. SAP, SLA-KPI Data collectors
Time and motion analysis.
Development of new VBA tools: Cash application timeliness clearings timeliness, unapplied cash comparison analysis, ICA difference reporting Tool, Daily production data consolidators, Quality check tools, Quality sampling tools.
Preparations of Various types of Objective measurement presentations which played key roles in getting sign offs from clients.
Implementation of AutoBank for SAP maintenance of already implemented Autobank organization.
Working as a bridge-function between client and Infosys for analyzing process conditions designing improvement/automation solutions thereon.

Accomplishments

Completed Lean project ICA Difference reporting tool, GL ICA Reconciliation Tool
Automated process for SLA data consolidation for monthly report and reporting.
Revised macro for Cash application timeliness.
Awarded a Ramp award for developing Production data Consolidation Tool. Excel based VBA tool
Certified in AR process
Certified in T-100 Domain Knowledge Foundation Advances diploma course in Banking Capital Markets
Recognized as BCM diploma course trainer for the engagement.
Recognized as Quality auditor Process analyst for the team.

Confidential

Process Executive

Successfully cross trained in 3 processes CIS, Cheque-fraud, Subpoena
Quality Check for 25 team members to ensure Quality work delivered to the client.
Quality Performance improvements for processors in PIP Performance Improvement Plan by 100 audit brainstorming.
Providing refresher training to ensure error free work.
Implementing Process updates for the team to have the team working as per clients expectations.
Time motion analysis for 13 sub processes.
Involved in mainframe automation for FTE reduction.
Automated SLA KPI reports to ensure 100 quality of reports.
Providing innovative ideas as Business solutions to the clients in streamlining the process.
SLA KPI reporting and consolidation.
Operation support to team members at the time of heavy workload.
Arranging Team Building activities.

Recognition/Rewards/Accomplishments :

Certified in T-100 Domain Knowledge Foundation Advances diploma course in Banking Capital Markets
Recognized as BCM diploma course trainer for the engagement.
Recognized as Quality auditor Process analyst for the team.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship