Ashok Kumar Patchava

Experience

1. Principal Enginner

   Aptia Group

   Apr 2024 — Present · Pune, IN

   Understanding source systems and customer requirements.Extracted data from the database, stored into QVD files, and wrote load scripts.Implemented Multi-Tier Architecture to create QVDs, Data Models, and reports.Designed and developed the data model in Qlik Sense and customize the code based on requirements of each sprint.Extensively used (Joins, Concatenate, Keep, Apply Map etc.) in creation of Qlik Sense applications.Implemented Multi-Tier Architecture to create QVDs, Data Models, and reports.Eliminated Synthetic keys, ambiguous relationships.Applied mapping function to look up and fetch the required field.Involved in converting the existing Qlik View applications to Qlik sense.Created Dashboards style of reports using Qlik Sense components like, Bar Charts, Pie Charts, Combo Charts, Table, Pivot Table, KPI, Containers, Filter Pane, and Text & Image.Implemented Set Analysis and advanced aggregation functions while designing the visualizations.Used Variables in Set analysis to write complex logic according to requirement.Worked with Sheets and Sheet Objects in Qlik Sense.Qlik Sense App development, templates, themes, master library items and story generation.Used Qlik Sense Scripting and Complex SQL coding for loading and transforming.Create and publish the apps in Qlik Sense Enterprise.Collaborated with business users and data analysts to gather reporting requirements and translate them into actionable NPrinting solutions, ensuring the delivery of accurate and relevant reports to key stakeholders.Collaborated with business users and data analysts to gather reporting requirements and translate them into actionable NPrinting solutions, ensuring the delivery of accurate and relevant reports to key stakeholders.Create Streams and setting up the security rules to provide authorization to the usersCreate, edit and schedule the tasks in Qlik Sense Enterprise.Developed applications and manage security rules for the applications.