Kushal Chawda

SInteract with end users and craft clear technical requirements from business language.

• Involve in designing, developing, testing, maintaining and supporting Qlik Sense & QlikView applications for Finance, Automobile and Operations business areas.
• Collaborate with various teams and lead Qlik Sense development activities.
• Worked in Agile environment, actively participating in Sprint Planning and Sprint Retrospective sessions.
• Mentored team members in adopting and developing BI applications, leading the BI team by providing guidance on development tasks, fostering professional growth, and enhancing overall team capability.
• Implemented best practices while building Qlik Sense app with set analysis, advanced aggregation functions, ODAG, dynamic views and building data model.
• Designed Qlik NPrinting reports to distribute excel or PDF reports to the end users.
• Developed mock-up applications for end users in QlikView/Qlik Sense by generating synthetic data prior to the actual development phase.
• Implemented data masking strategy in Qlik Sense for sensitive & PII data using section access.
• Install and manage Qlik Sense single node deployment with custom security roles.
• Reduced Qlik Sense report load times by 20% through performance tuning.
• Led the Qlik Sense to Power BI Migration project.
• Implemented an end-to-end project in Power BI, integrating an on-premise data source using Power BI Data Gateway.
• Implemented RLS, OL in Power BI at organization level.
• Implemented DAX calculations for advanced metrics.
• Utilized DAX Studio for validating DAX performance.
• Managed Power BI Dataflows, enabling data reuse across multiple reports and teams.
• Handling the admin roles and responsibilities in QlikView, Qlik Sense and Power BI.
• Involved in designing and implementing solution architecture of AWS data pipeline.
• Conducted Unit Testing, System Integration Testing, and prepared test cases for QlikView/Qlik Sense/Power BI.
• Manage Gitlab CI/CD pipeline for Qlik Sense/Power BI applications.
• Utilized AWS services such as AWS Glue, S3 and Redshift to design and test ETL workflows for data ingestion and transformation.
• Designed and tested Azure Databricks for data processing and transformation tasks with Data Lake storage.
• Designed ETL pipeline using data integration features on Qlik Cloud to load data into Qlik Sense SaaS.
• Implemented QlikView to Qlik Sense application migration.

• Analyze data source and table structure of Lync monitoring server.
• Involved in designing, developing, testing, publishing and supporting QlikView applications in the business area of telecommunications.
• Utilized QlikView document analyzer to optimize application.
• Create ad-hoc report in QlikView for users to generate report based on selected dimensions & measures.
• Build QVD segmentation in QlikView at day level to minimize daily full load of data.
• Create User report in QlikView which user can download as PDF on button click.

• Interact with end users and craft clear technical requirements from business language.
• Involve in designing, developing, testing, publishing and supporting QlikView applications in the business area of Retail Banking and Finance.
• Create QlikView Export to Excel & Email application with loop and reduce by Branch which is used to export sales reports. Exported files are circulated to the top management people Via Email. The entire process was automated using VBA Macros.
• Develop POC for various requirements using other visualization tools like Tableau, 1Key and Board.
• Convert SAS code into QlikView script to build report in QlikView for collection scorecard.
• Monitor QlikView production server usage using system monitoring app.
• Write SQL queries to unit test reports.
• Deploy application on production and schedule/monitor jobs.

• Analyze and understand the business requirements and create technical specification document.
• Involve in designing, developing, testing, publishing and supporting QlikView applications in the business area of Retail, Telecommunications and Automobiles.
• Analyze the SQL queries and stored procedures to convert it into QlikView scripts for generating reports in QlikView.
• Apply Sheet level security & Object level security in QlikView to the developed application using Section Access as per the user rights.
• Perform QlikView application versioning using tortoise SVN.
• Undertake performance improvement of QlikView applications.
• Provide QlikView developer user training.
• Create PDF reports and distribute via email using QlikView publisher.
• Deploy application on server and schedule jobs using QlikView server/publisher.