We provide IT Staff Augmentation Services!

Qlikview Developer Resume

San Francisco, CA

PROFESSIONAL SUMMARY:

  • Over 7 years of IT experience with 5+ years of experience in Designing and Development of Business intelligence application with QlikView 9.0/10.0/11.0 as BI tool.
  • Extensive experience in Full Life Cycle Development including Analysis, Design, Implementation and Maintenance different analytical applications using QlikView suite of Products (QlikView Server, Publisher, Qlik Sense and QlikView Enterprise).
  • Expertise in Installing and Configuring QlikView Server and Publisher 10.0/11.0 with QlikView web server / IIS in both clustered and non - clustered environments.
  • Experience in using NAS storage hosting QlikView applications managed filer security permissions.
  • Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise reporting architecture.
  • Experienced in configuring Authorization on QlikView Server both NTFS & DMS.
  • Expertise in Creating Documents using QlikView 9.0/10.0/11.0 using different data sources like Oracle, SQL Server, Netezza, QVD files, text files, excel and generated dashboard as per the user requirement.
  • Experience with QlikView Sheet objects including various charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
  • Developed QlikView Macros/ Triggers in customizing applications using VBScript.
  • Strong Experience in Extract, Transform & loading data in QlikView Applications & Develop Data models using Star schema & Snow Flake schema.
  • Performance tuning QlikView Applications for faster data reloads & efficient response times.
  • Implemented data level security using Section access that hides selected areas of the dashboard & filters data dynamically depending upon user privileges.
  • Sound Skills in SQL, PL/SQL. Validating data using SQL Scripts.
  • Having knowledge on the SDLC methodologies like AGILE, Waterfall model.
  • Involved in Performance Tuning & Deployment of QlikView Applications.
  • Experienced in Training & Supporting end-user reporting needs using QlikView & Cognos products.
  • Onsite-Offshore coordination in delivering Business Intelligence Solutions.
  • Excellent knowledge in Implementation of Relational Database (OLTP), Data warehousing systems (OLAP) and Data Marts.

TECHNICAL SKILLS:

Qlik vi e w T ool s: QlikView, Qlik Sense, QlikView Server & Publisher, Enterprise Management Console, OCX Control, QV Ajax Client, QV IE Plug-In.

ET L T oo l s: Informatica8x,Data stage

Ope r a ti n g Sy ste m: Windows2008/2005/XP, UNIX

RDB MS: Oracle10g/9i/8i,Netezza,SQLServer2000/2005,DB2,Teradata,MS Access

Lan g ua g e s: SQL,PL/SQL,VB-Script, DHTML,JSP,ShellScripting,C, C++, Data Modeling: Erwin4.0,Visio

Web applications: IIS6.0/7.0, Web Logic8, Tomcat4.0x/4.1x.

Bu s i nes s I n te l l i g en ce: Cognos 8BI,CrystalReports9,QlikView 9.0/10.0/11.0, Power BI

WORK EXPERIENCE:

Confidential, San Francisco, CA

Q l i k V i e w D e v e l ope r

Responsibilities:

  • Designed Frontend objects like Line, Bar, Pie, Straight, Pivot Tables and other sheets objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
  • Managed Qlik Sense infrastructure implementations and individual application launches.
  • Kept an active participation in business requirement and design review session as well as kept a close interaction with other developers/designers.
  • Pulled data from multiple databases and build a data model by removing circular loops and synthetic tables.
  • Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using QlikView Management Console.
  • Wrote SQL Scripts with preceding Loads to extract relevant data in QlikView Applications.
  • Performed analytics as per the requirement using advanced charts and tables.
  • Designed graphs and visuals to summarize data, identify outlying data points, and perform other exploratory data analysis.
  • Used appropriate functions like Apply Map, Resident Load, Concatenate, Variables and so on.
  • Extensively worked with advanced scripting, set analysis, VBScript, as well as advanced aggregation functions.
  • Used functions Date and Time, Keep, Join, Mapping, and String & input Fields etc.
  • Created User Conditions and Filters to improve application user experience.
  • Effectively identified and troubleshot any technical issues.
  • Assisted in server related tasks like service restarts, upgrades and troubleshooting.

E n v i r on me n t: QlikView 11, Qlik Sense, SQL Scripts, VB Script.

Confidential, Santa Clara, CA

Q l i k V i e w / Qlik Sense D e v e l ope r

Responsibilities:

  • Develop and deploy QlikView reporting and analytics applications to end users.
  • Duties included requirements gathering facilitating project meetings, developing Qlik Sense dashboard objects.
  • Acted as a Team Lead on assigned QlikView projects to work with 2-3 more developers.
  • Imported and integrated data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files dumps using OLE DB/ODBC.
  • Design user-friendly dashboards using the various sheet objects: Current selection, list boxes, search Straight table, Pivot table, Bar chart, Line Chart, Pie Chart, Combo chart and so on as per the requirement.
  • Design, Build, Test, Debug the QlikView application in QV Test server environment.
  • Worked on modeling data as per business requirements to Eliminated Synthetic keys, ambiguous relationships and closed loops.
  • Write detailed description of user needs, document required steps for developing and modifying computer applications, develop application prototypes, and provide technical support to project teams, members, and associations.
  • Worked with Business Analyst and the Business users to identify the user requirements, business reporting needs, layout, and developed the architecture of prioritized reports.
  • Interactions with cross functional teams to ensure quality and on time delivery of applications.
  • Implemented Macros, SET ANALYSIS to provide custom functionality in QlikView Apps.
  • Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher
  • Provided necessary maintenance support of the application.
  • Worked on generating and bursting PDF reports using QlikView’s native reporting functionality
  • Exposure to N-Printing tool.
  • Build multiple layers of QVDs, created transformations, build hierarchies and so on.
  • Building relationships with cross functional teams.
  • Successfully passed through the QA Environment and implemented on Production and currently working as post production support.

E n v i r on me n t: QlikView 11, Qlik Sense, Oracle, SQL Scripts, VB Script, MS Access, XML files.

Confidential, NYC, NY

Q l i k V i e w / Qlik Sense D e v e l ope r

Resp on s i bi li t i e s:

  • Communicated with the business users to comprehend the requirements and Designed Functional
  • Requirement Specifications for application development.
  • Developed Qlik Sense and Qlikview Dashboards using different Chart, Drill through, Cyclic Groups, List, Table Box, Container.
  • Implemented 3-layer architecture different load scripts so that data stored as QVD’s. Many QVD files will be shared between applications build an elaborate structure.
  • Implemented Security & involved in Deployment of QlikView Applications.
  • Created Dashboards style of reports using QlikView components like Slider, Buttons, Charts, and Bookmarks.
  • Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
  • Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc...)
  • Developed Linked Tables, Concatenation and solved the loops issues.
  • Gathered & loaded data into QlikView from various data sources (Netezza, Oracle 11g and excel files).
  • Used to solve the issues related to the end users.
  • Working knowledge of QlikView Server, QlikView Publisher, Qlik Sense and QlikView Enterprise Version
  • Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression.
  • Integrated QVW within existing windows based .Net application using OCX controls. Preferences have been stored using custom code.
  • Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that business needs meet. Redesign the existing mappings for improving the performance.
  • Created and configured workflows and sessions to transport the data to target warehouse using Informatica workflow manager.
  • Responsible for the performance and tuning of the application, including performing maintenance/upgrades on applications programs and systems as required.
  • Responsible to ensure that all assigned systems and application are defined and tested backup and recovery procedures for critical data.
  • Coordinated with Team Members in development process to integrate with the Test and Production Servers and helped creating use cases.
  • Involved in Production Support for QlikView applications& Server.
  • Used TOAD, Squirrel to run SQL queries and validate the data in Data warehouse and Data Marts.
  • Conducted end user training sessions and prepared the training documentation.

E n v i r on me n t: QlikView11, Netezza, Oracle11g, Toad, Squirrel, Informatica8.6, Autosys Windows 2008 R2, XP.

Confidential, Ashburn, VA

Ql i k V i e w Dev e l ope r

Resp on s i bi li t i e s:

  • Gathering requirements from business users and developed 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, Flat Files, Excel, and MS Access).
  • Designed an applications for to support the Funding 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.
  • Developed KPI’s and set analysis applications.
  • Experience in 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 to provide custom functionality in QlikView Applications.
  • Implemented Security & involved in Deployment of QlikView Applications.
  • Created QVD’s & updated on timely basis as database updates.
  • 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.
  • Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
  • Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
  • Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
  • Developed QlikView Applications using SAP Data.
  • Involved in up-gradation of QlikView environmentfromQV8.5, QV9.0versions.

E n v i r on me n t: Windows 2005 Server, Oracle10g, MS Access 2005, MS SQL Server 2005, QlikView10, QlikView9.0, MS Office.

Confidential, Dallas, TX

B I D e v e l ope r

Resp on s i bi li t i e s:

  • Worked with Business Users for requirement gathering and passing on the information to team.
  • Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule Adhoc reports by leveraging the basic components of QlikView.
  • Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
  • Created and managed ETL script generation using QlikView Script Builder Application.
  • Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
  • Created dashboard style of layouts using different components of QlikView Enterprise like Listboxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
  • Presented QlikView applications to various levels of user.
  • Designed application for Sales & Marketing Modules that Generates GUI Report for easy access through the data.
  • Worked with QlikView administrator to optimize QlikView performance. worked on Cognos8.4 framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server
  • Customized Cognos portal and worked on some XML files to build the customized Cognos portal.
  • Created, refreshed and supported Cognos Transformer models and cubes to Support Claims operations.
  • Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model
  • Created Cubes and worked on reporting on those cubes by using Report studio and Analysis Studio
  • Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports
  • Worked with the infrastructure team to define reference architecture of the various reporting tools.
  • Designed and developed ETL processes, Data Model, data flows, and Data Marts based on business requirement specifications.

E n v i r on me n t: Windows 2000 Server, QlikView9.0, Cognos 8.4, Oracle10g, SQL Server 2005, MS Office.

Hire Now