VR

Qlikview Admin - Hewlett Packard Co

Edison, NJ - Email me on Indeed: indeed.com/r/V-R/d95e8c7f7ea4abe9

• Over 8 years of IT experience in the fields of Qlikview, Business Intelligence and Data Analysis with full
project lifecycle implementation.
• Having four years of experience as Qlikview Admin manages three components Qlikview Server, Publisher
and Web Server.
• Worked extensively on installation and configuration, environment, system analysis, design, deployment,
testing and implantation of projects.
• Experience with Cluster environment of Server, Publisher and Load Balancer IIS.
• Set up Single Sign On along with Active Directory access.
• Implemented Security across the QlikView dashboards.
• Worked with different LOBs to understand the reporting and analytics requirements.
• License management and license leasing. Setting access permissions and assigning CALs based on users.
• Built multiple dashboards and presented to different user groups to make them understand the functionality
of dashboards.
• Developed different apps for QlikMaps (Points & Polygon), Extension objects to let the user to explore best
features in Qlik Sense and to compare with Qlikview.
• Involved in managing the QlikView Licenses to the users (Named CAL, Session CAL, Document CAL)
• Managed server logs such as session logs, performance logs, audit logs, event logs. Schedule QVW reloads
on server and troubleshoot errors and failures, debugging issues.
• Worked on Qlikview management console to schedule jobs, giving user permissions.
• Implemented the 3-tier architecture (Data-Extract, Data-Modeling and Application Development) as
recommended in QlikView best practices guide.
• Creating, defining folder structure as per QDF standard - Source documents & User documents.
• Experienced in managing QlikView server and publisher, user and groups via QEMC/QMC.
• Utilize QlikView Publisher for client application rollout to QlikView Access Point and administrator security
using Active Directory technology. Set up NPrinting server, designing with Qlikview machine.
• Good Knowledge of Qlikview publisher implementing PDF Distribution and Data Reduction.
• Deploy code from development to QA, from QA to production, perform code review, extract follow the
instruction.
• Upgrade from version […] Involved in migration process. Work done applying Service Release patches
• Extensive experience in working with OLTP, OLAP and BI verticals in Analysis, Design, Testing, Development
and Implementation of Client/Server Applications.
• Open cases discussion with QlikTech, logging issues.
• An effective communicator with excellent relationship building, multitask professional and interpersonal skills
• Ability to work in Standalone as well as big size teams with minimal transition and provides effective results.
Authorized to work in the US for any employer

WORK EXPERIENCE

Qlikview Admin
Hewlett Packard Co - Berkeley Heights, NJ - April 2014 to Present
The Hewlett-Packard Company (HP) is an American global information technology company headquartered
in Palo Alto, California, United States. It develops and provides a wide variety of hardware components as well

• Worked on QlikView server and publisher to automate the QlikView jobs and define the user security and
data reduction. dead-lock issues -2 servers . 4 IIS.3) Setup within the Qlikview Environment.
• Responsible for deployment of new/enhanced dashboards in production environment and provide end to end
support for the same. Built up grouping of Qlikview server and
publisher. DE .
• Implemented incremental load by creating QVDs and optimized the periodic data additions.and medium-sized businesses and large enterprises. assigning license. and to generate reports using SSRS.
Responsibilities:
• Planning. enhancement to existing dashboards reports based upon the change requested
by the user.
• Clustering .
• Maintained Row. investing. installing and configuring of entire Qlikview environment. Column and Sheet level Securities for all Major Dashboards using Section Access.
Qlikview Admin / Developer
Bank of America . 16. serving individual consumers. Evaluated the new
NPrinting Beta 17.
Environment: QlikView 9/10/11.16 (8 cores) for QVS and 256GB RAM for Publishers. asset management
and other financial and risk-management products and services.
• Handled change request. backup/recovery and server hardware and software monitoring. performance logs.
• Participated in QlikView server migration from one physical server to another. load adjusting of IIS utilizing NetScaler part. Worked with QlikTech to coordinate on the upgrade
procedures and resolving any environment related issues using the Client Qlik Support Portal. The Aim of my Project is to support the Direct
Deposit and Loan application Databases running on SQL Server and to automate the migration of data to the
Corporate Treasury Data Mart using ETL tool SSIS.
• Manages user's access to the QlikView Server and QlikView Access Point. Windows 2008 Server. 2 publishers.July 2012 to March 2014
Bank of America is one of the world's largest financial institutions.
• Manages user's access to the QlikView Server and QlikView Access Point.
• Solve issues and troubleshoot in assigned areas. CSV Files.one for publisher and
another for server.
• Troubleshooting the issues and reviewed the log files to resolve the issues.
• Managed multiple tasks. Administrator security by AD group using QlikView Publisher. Reload management on clustering such as managing high source utilization documents.x for multi threading options for faster report generation.
• Implemented NPrinting Server (14. Worked with the offshore Qlikview team and handed them different responsibilities key to the
project. maintain daily reports of session
logs. scheduling.
• Monitoring CPU & RAM of publisher and server using Dynatrace monitoring tool to ensure system availability.Four Qlikview servers. SQL Server 2008. CPU. Environment consists of clustering 4 QVS
servers. creating user groups etc.Newark. health and education sectors.
• Capacity of server is 512GB RAM.
• Implemented Qlikview upgrades and software patches. maintenance and upgrades.
• Worked on Performance testing of Dashboard and also data validations using independent queries and raw
data analysis. Oracle 10G/11G.
• Resolved issues resulting from User Acceptance Testing (UAT)
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports. small and
middle market businesses and large corporations with a full range of banking. Involved in resolving Performance issues with various reports.
• Experienced in Support all aspects of daily operational activities including: account and resource
management. Out of four servers two set up in DMZ system for external
client access.
including customers in the government.x.
Responsibilities:
• Managed the QlikView Server tasks: developing tasks. audit logs and event logs.
. two Publishers and four IIS. small. giving access.as software and related services to consumers.

• Worked with the offshore Qlikview team and handed them different responsibilities key to the project
• Imported data from multiple data sources including Web files. Direct
selling & Wellness Incentives. Windows 2003
Server. Sales Incentive. Involved in resolving
Performance issues with various reports.
• Enhanced all the Qlikview dashboards for improved security while accessing the dashboards. star schema
models and table designs. Oracle 10g. transformation layer and presentation layers. MS Excel. granted application permissions to users/groups. Involved in Requirement gathering from Business
Users and Developed Technical Documentation for the Business and Team. Employee Rewards. Testing environments. Created base layer. created external tasks via QMC.
• Manages user's access to the QlikView Server and QlikView Access Point. bookmarks. text objects.
• Modifying the existing reports based upon the change requested by the user. Payroll. Set Analysis. Access. Business and
External) as per Business requirement. They
offer various programs ranging from Consumer Incentive.Lake Success.
• Involved in user training. Integration testing and System testing of the reports in Development. slider. MS SQL Server and MS Excel through OLEDB
and ODBC connections and modeling data as per user requirements. buttons.
• Created dashboard style of layouts using different sheet objects like List boxes. Filters.
Responsibilities:
• Worked with the user community and senior 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. different views (Import.
• Created multiple tier QVD architecture. Aggregate functions and Mapping Functions
• Assigned licenses to users. etc.
• Customized Qlikview Connection with appropriate reports and security measures.
• Troubleshooting the issues and reviewed the log files to resolve the issues.
• Handled the end-to-end implementation of QlikView dashboard deployment.
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing)
• Unit testing. SQL Server 2008.March 2011 to June 2012
Astoria Financial Corporation Prepaid Cards Services.
• Used various KPI's for calculation purposes. updated LEF
file. Mentoring other team members. created tasks. Column and Sheet level Securities for all Major Dashboards using Section Access.
Environment: QlikView 9/10. formerly known as E-account is one of the leading
providers of innovative corporate prepaid solutions across North America. current
selections box.
• Expertise in preparing the System Requirement specification and Design Specification documents
• Enhance existing Qlikview reports and gather the change requirement from the user and provide solution
for the same. Variables.
• Performed data modeling on requirements analysis by creating table displays. SharePoint.
• Designing the Logical model that conforms to star schema concepts.
• Maintained Row. XML Files. Mentoring other team members
. EMEA & APAC regions. Multi boxes.
• Implemented incremental load by creating QVDs and optimized the periodic data additions.
Qlikview Developer
Astoria Financial Corporation .• Involved in user training.
• Designed and developed dashboards with various levels of complexity including different kinds of charts and
extensions. charts. NY . logical data model.
• Maintained both File and Data Level Security and implemented Data Reduction.
• Worked with Macros.

• Designed and developed the Staging Database and loaded from source to staging and from staging to the
Destination tables applying different transformations.
Oracle PL/SQL Developer
Throb IT Solutions . Materialized Views.August 2009 to January 2011
Throb IT is an India IT company working on various technologies to create products for various industry
verticals. Creating a data model using ERWIN tool.
Environment: Oracle 9i. QlikView Developer Console (11). Hadoop.
• Extensive experience with Oracle database on building the Infrastructure desired for an application. Windows XP
professional
SQL Developer
Ajanta Pharma Ltd . and marketing
of quality finished dosages in domestic and international markets.
• Designed the complex views that we can use from the source to populate the warehouse with required
columns. Range Partitions. Functions and Triggers.
• Wrote UNIX Shell Scripts to automate load process. DB2.Initializing the production data to synchronize old data with new.
• Wrote complex SQL scripts using joins. SQL*Loader.
• Design and development of the Distributed Data Repository. Database tuning using explain plan to improve performance. Development. Import/Export.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the
application. Design. Windows 2008/2012 Server. SQL Server 2008/2012.
• Data validation . SQL Navigator. With a customer-oriented approach to provide affordable solutions for businesses seeking for web
and software solutions for their enterprises. Madhya Pradesh .
. Sequences.
• Created Tables. Tkprof. & Testing
of application. Netezza.
• Query tuning. The scope of the project was to create
and maintain an application for inventory management that would automatically update the records of
pharmaceutical drugs existing at a point of time. TOAD.
• Also experienced in Designing. UNIX.
• Worked on performance tuning and used Explain Plan. SQL * Plus.Indore. Oracle 11G. and SQL-Trace for tuning the queries. Constraints. Views.
• Created ad-hoc queries and stored procedures for generating reports.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables
• Designed Reports in SSRS.
Responsibilities:
• Analysis of the existing Data Warehouse system to understand existing functionality. QlikView
Access Point.
• Prepared High level and Technical (detail) design documents using the Business Requirement Documents. QlikView Management Console.
• Loading different kinds of flat files into database tables using SQL Loader. with several prompts and built ad-hoc reports in Report Manager. Scheduling batch jobs. Analysis. Indexes.
• Worked with Data mapping. Maharashtra .
• Designed and developed all Oracle PL/SQL Packages.
Responsibilities:
• Involved in complete SDLC including Requirement Specifications. High level design and Detailed design documents. sub queries and correlated sub queries. Procedures.Mumbai. manufacture.January 2008 to August 2009
Ajanta Pharma is a specialty pharmaceutical company engaged in development.Environment: QlikView 10/11.