Proficiency and minimum hands on experience of 4-6 years

·  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