SUMMARY

• 13+ years of experience in Business Intelligence (BI) projects, including Development, Analysis, Design and Administration.
• Proven experience in Qlik Sense Development/Admin, Tableau and PowerBI including Platform Security and Server Architecture.
• Solutions architecture specialist on technologies including Qlik Sense and all ancillary Qlik products.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Implemented CICD for the QlikSense application migration from DEV through PROD (Automated Deployments).
• Experienced in configured the BitBucket for Project.
• Experienced in configuring the JENKINS jobs.
• Involved in the Initial GAP analysis for CICD Of implementation for Qlik Applications, NPrinting, Mashups and Extensions.
• Defined solutions and approach in implementing the CICD.
• Demonstrated the initial pilot project for Qlik Application automated deployment in CICD.
• Experience in developing dashboards using versions from Qlik Sense 3.1 through JUNE2020.
• Actively participated in meetings for requirement gathering and worked closely with, Business Analyst, Planning team and stakeholders to know their business requirement.
• Thorough hands on design and implementation on Data Warehouse / Marts in QlikSense.
• Extensive experience with QlikSense sheet objects, scripting, and optimizing applications and building QVD’s.
• Involved in Optimization of QlikSense Dashboards with a focus on Visualization, usability, Performance, Long - term, Flexibility, Accuracy and Standardization.
• Extensive Experience with QlikSense sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export, Fast Change and other objects for Management Dashboard reporting.
• Strong Experience in working with various Charts (Straight Tables, Pie-Charts, Gauge-Charts, Line-chart, Combo-chart, Bar-chart, Scatter-chart and Third party Extensions).
• Worked on importing data from multiple data sources and delivered Reports, metadata, security, calculation, caching, and intelligent request generation services.
• Good experience in using the functionality Join, Concatenate, Keep in the preparation of Qlik data model.
• Hands on experience in various loads - Binary Load, Inline Load, Partial Load, Incremental Load.
• Strong experience in Scripting, developing and designing Dashboards using QlikSense by extracting data from multiple sources (Redshift, SAPBW, Oracle, QVD files, Flat files, Excel, Access).
• Experience in Oracle 10g/9i, MS SQL, TOAD, Redshift.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas, Fact and Dimensional Tables.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Test Cases.
• Expertise creating Test plans, test objectives, test strategies and test cases in testing phase.
• Experienced in working in projects with Scrum/Agile/KANBAN methodology.
• Expertise in SAP BO XI R3 and BO XI R2, (Designer, WebI) and Crystal Reports 2008.
• Worked extensively on WEBi, Universe Design Tool.
• Extensively involved in Demos, Presentations, Meetings and Interaction with Senior Management.
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements.

TECHNICAL SKILLS

Qlik BI Development: Qlik Sense 2.0 through JUNE2020/ QlikView 11

Qlik BI Administration: Qlik Sense Server and Maintenance / QlikView Server Publisher

SAP BI Tools: SAP BO 4.0, SAP BO XI R3, Business Object XI R2, and Crystal Reports

Other BI Tools: Tableau, Power BI

Programming Languages: SQL, PL/SQL

Other Tools: JIRA, Service Now, Remedy, SQL Server Management Studio and Toad

PROFESSIONAL EXPERIENCE

Confidential

Project Lead

Responsibilities:

• Involved in implementation, including client-facing design reviews and configuration; provided architectural solution for Qlik Sense platform.
• Involved in full project life cycle implementation (requirement gathering to production) of Qlik Sense dashboards.
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, binary QVW, Inline & txt files in creating the Qlik Sense dashboards.
• Connected to different ODBC, OLE DB data sources (SQL Server) and flat files to create and schedule different complex reports as per business requirement by leveraging the components of Qlik Sense.
• Created multiple tab dashboards. Trend graphs, Bar graphs, Stacked Graphs, containers and so on.
• Extensively worked with Qlik Sense functions, objects, Set Analysis, Variables to generate different kinds of charts.
• Implemented the 3-tier architecture, Data Extract, Data Model and QVD/QVF.
• Participated in design and code reviews, QA/UAT testing, enhancement design and development, and deployment to support day-to-day business operations.
• Built GOLD and Custom apps for the Users.
• Defined Dash board best practice for APP development.
• Involved in designing the Architecture for building the Plug and Play functionality for the APP development.
• Worked on incremental load to pull data from AWESOME tool on schedule basis.
• Defined version controlling for APP promotion from Dev through Prod environments.
• Helped Users to create Story Telling Functionality in Qlik for their AVP Reviews.
• Worked on Geo Analytics functionality to enable drill down maps and other functions of Maps.
• Created SOPs, Dash board certification qualification, security, Migration and upgrade documents.
• Involved in the Production support and Maintenance of QlikSense Applications.
• Collaborated in defining Certified Dashboard Criteria as part of Platform Governance objectives.
• Addressing the user’s issues and fixing them.
• Implemented Testing new QLIK version release for Qlik Version Upgrade.
• Setting up the security model for the user groups using Customer Properties and Security rules for User access to QlikSense.
• Performed large scale of performance improvements on Qlik servers.
• Implemented the SMTP Email alert configuration for Task failures and File share server size monitor.
• Implemented PRTG Network Monitor to monitor the entire QlikSense server Activity.
• Upgrading the Qlik Sense and NPrinting servers to latest versions.

Confidential

Project Lead

Responsibilities:

• Lead overall project implementation, including client-facing design reviews and configuration; provided architectural solution for Qlik Sense platform.
• Involved in full project life cycle implementation (requirement gathering to production) of Qlik Sense dashboards.
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, binary QVW, Inline & txt files in creating the Qlik Sense dashboards.
• Connected to different data sources (SQL Server, Hyperion) and flat files to create and schedule different complex reports as per business requirement by leveraging the components of Qlik Sense.
• Created multiple tab dashboards. Created Trend graphs, Bar graphs, Stacked Graphs, KPI, and Gauge Objects and so on.
• Extensively worked with Qlik Sense functions, objects, Set Analysis, Variables to generate different kinds of charts.
• Implemented the 3-tier architecture, Data Extract, Data Model and QVD/QVF.
• Participated in design and code reviews, QA/UAT testing, enhancement design and development, and deployment to support day-to-day business operations
• Defined security model and folder structure for the entire environment to user access.
• Worked on creating AR insight dashboard which helps to get Insights of ARIKAYCE.
• Trained Users on Qlik sense Interface and Extensions.
• Client interaction, analyzing end user requirements and developing technical solutions.
• Created Streams and maintained security by creating custom properties by using Qlik Groups.
• Implemented App level Security with App level Management by creating Security Rules.
• Installation of Geo Analytics and Qlik bundle extensions to support advanced analytics.
• Created Performance vs. Budget Analysis app to get the stats.
• Worked on creating medical affairs executive dashboard which gives info related to Medical Info requests.
• Worked on ARIKAYCE Contest Tracker Dashboard which helps to analyze the Territory level Performance and goals.
• Used Qlik Scalability tool and tested for 200 Concurrent users for load testing of AR insight app.
• Worked on Procurement Spend Analytics app which will help Finance team to check Spend by different categories.
• Worked on Procurement and concur dashboard to give more insights about spending analysis and contract terms.
• Worked on Finance Sales Dashboard which gives insights about sales for ARIKAYCE.
• Installed and configured Production QlikSense environment.
• Configured Custom Security Rules for Developers, Content User, and Users across platforms.
• Prepared the Installation Qualification (IQ) documents for platform validation.
• Automated the user access to QlikSense based on the User Roles to access QlikSense.
• Implemented the SMTP Email alert configuration for Task failures.
• Implemented OKTA SAML authentication model to user access.
• Created SOPs, Dash board certification qualification, security, Migration and upgrade documents.
• Implemented iPortal power tool to impersonate user roles testing
• Collaborated in defining Certified Dashboard Criteria as part of Platform Governance objectives.
• Involved in the Production support and Maintenance of QlikSense Applications.
• Involved in troubleshooting the Qlik Server level issues and fixing with solutions.
• Setting up the QVD Generator and Data reload Tasks in QMC.