QlikView Developer Resume Chicago, IL - Hire IT People (2024)

SUMMARY

• Over 7 Years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing /Decision Support Systems and Business Intelligence.
• Over 5 Years of experience with Data Warehousing and business intelligence tools for developing various reports using QlikView BI.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Expertise in Installing and Configuring QlikView Desktop, QlikView Server and QlikView Publisher.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Installed, Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, Netezza, XML files, QVDs and flat files using OLE DB/ODBC.
• Mainly designed and developed QlikView software applications and complex server - based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Designed QVWs to generate QVDs for faster and efficient data reloads.
• Trained QlikView developers and users on best practices and general “how to” procedures.
• Implemented security using QlikView‘s section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Mainly designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Experienced in Requirements Gathering, Data modeling and QlikView Application development.
• Managed QlikView reporting environment which includes QlikView Server, QlikView Publisher and QlikView Desktop.
• Loaded data into QlikView from Database, text file and also from excel file.
• Interacted with Customers for requirement gathering and effective analysis.
• Developed interactive dashboards for mobile professionals while disconnected from network.
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Experienced in writing UNIX shell scripts, SQL Loader, Performance & Tuning of Database.
• Strong knowledge in Oracle 11g/10g/9i/8i database programming using PL/SQL (Stored Procedures, Functions, Triggers, Cursors) and standard Built-in Oracle Packages.
• Experience in Oracle 10g/9i/8i/8.x, PL/SQL, SQL, TOAD, Stored Procedures, Functions, Triggers, SQL Server 7/2000.
• Experience in working with different operating systems like HP UNIX, Solaris, and Windows NT/2000.
• Extensively involved in Demos, Presentations, Meetings and Interaction with Senior Management
• Coordinated and acted as a liaison between the business groups and the IT department.
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements.
• Self-motivated and enjoy working in a technically challenging environment. Have excellent Communication and interpersonal skills.
• Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.

TECHNICAL SKILLS

Business Intelligence: QlikView 8.5/9.0/10.0/11/11.2 , Cognos7x/8x

ETL Tools: Informatica 7x/8x, Data stage

RDBMS: Oracle 10g/9i/8i, SQL Server 2000/2005, DB2, Teradata, MS Access

Database Tools: Erwin 3.5.2, Rapid SQL

Operating System: Windows 2000/2003/XP, UNIX, Sun Solaris 8

Web Applications: IIS 5, Web Logic 8

Languages: SQL, PL/SQL, VB-Script

Application Software: Adobe Works, MS-Office Suite

Data Modeling: Erwin 4.0, Visio

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

QlikView Developer

Responsibilities:

• Extensively worked to confirm and clarify requirements and business logic.
• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Strong understanding in creating Dashboards, scoreboards for the required KPI’s in QlikView.
• Developed load scripts to work with multiple data sources (SQL, Excel, and MS Access).
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Designed an applications for to support the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher
• Involved in up-gradation of QlikView environment from QV 10.0, QV 11.0 versions.
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT,
• Working with the management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Setting access permissions and assigning CALs based on users.
• Schedule QVW reloads on server and troubleshoot errors and failures.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Mainly designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Worked on dashboards related to Sales Analysis, Production over time,and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.
• Testing dashboards and data validation.
• Used advanced scripting, set analysis and VBScript, advanced aggregation functions and advanced charts for applications.

Environment: Windows 2000 Server, Oracle 10g, MS Access 2005, MS SQL Server 2005, QlikView 9.0/11.0, MS Office.

Confidential, GA

QlikView Developer

Responsibilities:

• Involved in Requirement gathering & designing QlikView applications.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Developed Custom DATE Calendar Object and Linked with in the Model.
• Strong Experience in Working with Charts ( Table Box, Pivot, Straight, Pie, Line Gauge, Trillies)
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc...)
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed Macros, SET ANALYSIS in provide custom functionality in QlikView Applications.
• Implemented Security & involved in Deployment of QlikView Applications.
• Created QVD’s & updated on timely basis as database updates.
• Sound skills in developing hide/Show Objects based on Condition & Triggers.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Experience with building applications using SAP BW.
• Implemented security in QlikView Applications.
• Trained End Users on Using QlikView Tools.
• Experience with QlikView Enterprise Management Console.

Environment: QlikView 10.0/9.0, SAP BW, Teradata, SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server, Sun one LDAP, SAP HRMS.

Confidential, KS

QlikView Developer

Responsibilities:

• Developed KPI’s and set analysis applications.
• Developed User Interactive Sheets & Reports as business needs.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity).
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).
• Generate new QVD files created by ETL logic to feedQlikViewapplications
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the application
• Coordinated with ETL team and performed integration testing to check data discrepancies
• AutomatedQlikViewjobs inQlikViewPublisher and rolled out toQlikViewAccessPoint and administered Security using Active Directory
• Analyzed the existingQlikViewdata model, script logics and the ETL business logic for the existingQlikViewapplications
• Generated the QVDs from the SAP database and redeveloped the QV scripts to in corporate AMA & PED restrictions
• Executed the scripts and checked the incorporated script changes in the Application
• Improved the overall performance of the application and redesigned data model applyingQlikViewperformance tuning techniques
• Published Client application usingQlikViewPublisher and rolled out to Shared Drive with security permissions using Active Directory features
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Developed SQL Scripts in validating data from different data sources.
• Mentering Business User Groups

Environment: QlikView 9.0, SQL Database, Windows Server 2003, oracle 10g, Microsoft Visio, QlikView Publisher, QlikView Server 9.0.

Confidential, New York

QlikView Developer & Server Admin

Responsibilities:

• Working with the management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Setting access permissions and assigning CALs based on users.
• Schedule QVW reloads on server and troubleshoot errors and failures.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Mainly designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Worked on dashboards related to Sales Analysis, Production over time,and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.
• Testing dashboards and data validation.
• Used advanced scripting, set analysis and VBScript, advanced aggregation functions and advanced charts for applications.
• Designed QVWs to generate QVDs for faster and efficient data reloads.
• Trained QlikView developers and users on best practices and general “how to” procedures.
• Designed Master Calendar.
• Implemented security using QlikView‘s section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Provided ongoing QlikView consultation to the development team.

Environment: QlikView 9.0, Oracle10g, Toad, Squirrel, Oracle 10g, Netezza, SQL Server2008

Confidential

SQL Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Created SSIS Packages to retrieve PII user data from the Flat files on monthly and weekly basis.
• Created datasets, data source and involved in deploying the reports in to the report server.
• Created reports using SQL Server 2005(SSRS) and integrated into the web front end.
• Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Created Cross-Tab, Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Worked on Performance tuning, and optimization of procedures and queries.
• Created ad-hoc queries from SQL Server databases for custom reporting needs. Worked on querying data and creating on-demand reports using Report Builder in SSRS.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Environment: SQL server 2000, 2005, Windows XP Professional