AVP / Qlikview Developer
Designs QV based dashboards against disparate data sources (SAP Connectors, BW, SQL Server, data in Excel, and others database object) using Chart, list, table and other objects.
- Uses QVD and incremental loading to delete, insert and update records and highlight items changed; internal match to generate standard financial statements from trial balance queries; VB macro and actions trigger to streamline process; input fields to adjust data manually; QV publisher to schedule jobs for different users in different departments.
- Develops KPIs and set analysis application with Qlikview functions (join, concatenate, keep, applymap)
- Writes QlikView and SQL scripts to load relevant data and uses VB macro and set analysis to create customized reports for regulatory reporting, US regional and CFO infra.
- Applies security to document (section access) and QMC server level (reduction, distribution and loop).