.Expert level Excel skills (Conditional Formatting, Data Validation Rules, Table Manipulation, Named Ranges, Creating/Modifying connections to external data sources, Workbook/Worksheet/Cell Data Protection)

Advanced Excel Formulas such as Pivot Table, Lookups, Conditional formatting, count IF, Sum IF, INDEX / MATCH and data tables etc.

·Expert level Excel VBA skills (Ability to create complex forms/functions/subroutines, Experience using constants and visibility modifiers, Programmatic manipulation of objects/tables/data connections/formulas/loop)

·Experience creating PowerPoint slide decks and along with that experience in automating the PowerPoint slide creation using excel VBA.

·Formats extracted data based on expected report output (with batching capability and multiple data formatting requirements)

·Consolidate and combine extracted data from multiple resources using automated tools (excel, VBA macro, SQL database), and/or from different system/tools/Database in one single database using SQL queries to standardize data structure from different data source.

·Gathers and analyse report requirements from stakeholders. Identify the processing tool (Excel / SQL) and provide a robust solution which can be easily leveraged or extended to other domains.

·Building complex VBA scripts to automate Excel spreadsheet processes

Tools: VBA, SQL & SSIS, Advanced Xls, Implementing PPT Packages

REQUIRED COMPETENCIES (Mandatory)

Proficiency and minimum hands on experience of 4-6 years

Flexibility in adapting to new technologies.

Good verbal & written communication skills to interact with the relevant stakeholders Flexibility to work across time zones and diverse cultures