VBA Developer
Job Summary
VBA Programming:
Advanced VBA programming (modular scalable code)
Deep knowledge of Excel Object Model (ListObjects Worksheets Workbooks)
Basic understanding of MDX/data integration- Must have
Automated generation of multi-sheet workbooks
Report structuring across different granularity levels
Advanced Excel:
Formulas named ranges structured tables
Pivot tables & data summaries
Formatting usability and report standardization
Performance tuning (calculation control screen updating efficient loops)
Error handling and logging mechanisms
Advanced VBA programming (modular scalable code)
Deep knowledge of Excel Object Model (ListObjects Worksheets Workbooks)
Basic understanding of MDX/data integration- Must have
Automated generation of multi-sheet workbooks
Report structuring across different granularity levels
Advanced Excel:
Formulas named ranges structured tables
Pivot tables & data summaries
Formatting usability and report standardization
Performance tuning (calculation control screen updating efficient loops)
Error handling and logging mechanisms