EY Executive - Excel & Access Developer in India

Title: Executive - Excel & Access Developer

Location: India

Job Number: IND008QB

Job Description for Excel Access VBA Developer

Educational Qualification

Graduate - Preferably Engineering background

Experience

5 to 10 years of work experience in a Finance Function / Business Function

Skill Sets

1) Should be able to independently interact with designated SPOCS of Business Functions and collect Automation Requirements.

2) Should be able to Translate Requirements into Excel Access VBA based applications

3) Knowledge of BI Features in Excel - Power Query, Power Pivot, Power View and Power Map will be an added advantage.

Excel Skill Sets

Features -In depth understanding of

Filters (Auto Filter, Advanced Filter - Text and Formula Criteria)

Sort (Incl. Custom Sort)

Data Validation (Incl. Formula Based Validation)

Conditional Formatting (Incl. Formula Based CF)

Names and Dynamic Names (Formula Based Table Based)

Database Queries and Pivot Tables

Formulas -In depth understanding of

Absolute, Relative and Mixed References

Table Structured References

IF

SUMPRODUCT / COUNTIF(S) / SUMIF(S)

MATCH / INDEX

ROW / COLUMN

INDIRECT / OFFSET

TEXT FUNCTIONS (Mid / Left / Right / Search / Find / Substitute / Replace)

Excel VBA Skill Sets - In-depth understanding of

Data Types, Data Structures (variables, Constants, Arrays, Collections, Dictionaries

Control Structures (IF, Case…Select, For…Next. Do….Loop, While….Wend)

Error Handling

Basic I/O - MsgBox/InputBox

Advanced I/O - Userforms

Automating Common Tasks

Automating Other Application (Access, Outlook - Minimum)

Knowledge of Class Modules, Win API Functions will be an added advantage.

Access Skill Sets - In-depth understanding of

Creating Tables and Queries

SQL - Language

Macros

Access VBA (Basic understanding)

Knowledge of Relationships, Forms, Reports would be an added Advantage

Power BI - Intermediate Level understanding of

Power Query (UI M)

Power Pivot (UI DAX)

Data Visualization - Added Advantage

Using Built in Chart Types

Creating Custom Charts - Bullet, Bar with Benchmarks, Tornado, Waterfall, Gantt etc.

Qualifications:

Job Description for Excel Access VBA Developer

Educational Qualification

Graduate - Preferably Engineering background

Experience

5 to 10 years of work experience in a Finance Function / Business Function

Skill Sets

1) Should be able to independently interact with designated SPOCS of Business Functions and collect Automation Requirements.

2) Should be able to Translate Requirements into Excel Access VBA based applications

3) Knowledge of BI Features in Excel - Power Query, Power Pivot, Power View and Power Map will be an added advantage.

Excel Skill Sets

Features -In depth understanding of

Filters (Auto Filter, Advanced Filter - Text and Formula Criteria)

Sort (Incl. Custom Sort)

Data Validation (Incl. Formula Based Validation)

Conditional Formatting (Incl. Formula Based CF)

Names and Dynamic Names (Formula Based Table Based)

Database Queries and Pivot Tables

Formulas -In depth understanding of

Absolute, Relative and Mixed References

Table Structured References

IF

SUMPRODUCT / COUNTIF(S) / SUMIF(S)

MATCH / INDEX

ROW / COLUMN

INDIRECT / OFFSET

TEXT FUNCTIONS (Mid / Left / Right / Search / Find / Substitute / Replace)

Excel VBA Skill Sets - In-depth understanding of

Data Types, Data Structures (variables, Constants, Arrays, Collections, Dictionaries

Control Structures (IF, Case…Select, For…Next. Do….Loop, While….Wend)

Error Handling

Basic I/O - MsgBox/InputBox

Advanced I/O - Userforms

Automating Common Tasks

Automating Other Application (Access, Outlook - Minimum)

Knowledge of Class Modules, Win API Functions will be an added advantage.

Access Skill Sets - In-depth understanding of

Creating Tables and Queries

SQL - Language

Macros

Access VBA (Basic understanding)

Knowledge of Relationships, Forms, Reports would be an added Advantage

Power BI - Intermediate Level understanding of

Power Query (UI M)

Power Pivot (UI DAX)

Data Visualization - Added Advantage

Using Built in Chart Types

Creating Custom Charts - Bullet, Bar with Benchmarks, Tornado, Waterfall, Gantt etc.