SUMMARY

• Strong experience wif Qlikview and Qliksense application design and development.
• Experianced Qlikview and Qliksense Server Administrator.
• Experience in complete Business Intelligence life cycles projects from requirement gathering, documentation, data analysis, development, testing, and production deployment.
• Experience in coordinating training sessions and training materials.
• Excellent ability to translate client requirements into effective solutions
• Sound ability to interact wif end users and craft clear technical requirements from business language
• Able to get along well wif co - workers and accept supervision. Received positive evaluations from previous supervisors.
• Proficient in qv scripting, set analysis and front end development of the Qlikview dashboard.
• Used Qlikview components extensively to improve the speed and quality of script development.
• Working noledge of ETL tools like Informatica, ODI, SSIS and Wherescape RED.

TECHNICAL SKILLS:

Reporting Tools: Qlikview 9/10/11,Qliksense 2.2.1, SSRS

Databases Oracle: 11g/10g/9i/8i, SQL Server 2012/2008R2/2008/2005/2000,IDMS

ETL Tools: Informatica,ODI,SSIS,Wherescape Red

Programming: SQL, PL/SQL, Transact SQL, ANSI SQL, Unix Shell Scripting (Korn Shell).

PROFESSIONAL EXPERIENCE

Confidential, Little Ferry, NJ

BI Specialist / Qlikview Architect /Qlikview and QlikSense Server Administrator

Responsibilities:

• Work wif end users through requirement gathering sessions to evaluate KPIs and functionality.
• Engaging stakeholders and subject matter experts.
• Designed entire templates for Qlikview dashboards.
• Migrated Qlikview qvws to Qliksense qvfs.
• Picked the most appropriate charts and Tables tailored to meet the needs of Business users.
• End to End implementation of QlikView and Qliksense projects.
• Adding enhancements and maintaining the existing Qlikview Dashboards.
• Providing production support for multiple QlikView applications wif a user base of over 120 users.
• Deploying the application on the Qlikview and QlikSense server and maintaining it.
• Used Qlikview components extensively to improve the speed and quality of script development.
• Extensively used variables for storing labels, storing expressions etc.
• Used sub routines for extraction of qvds, creating variables, master calendar and Ad Hoc reporting.
• Involved in training the business users on how to use the Qlikview Dashboards.
• As a Qlikview server administrator was involved in Server Management, Licensing and Access Control.
• Implemented best practices as a Qlikview Server administrator.
• Implemented EDX to trigger QV tasks after successful completion of DW reload.
• Creating tables, views, procedures and funtions on MS SQL server.
• Scheduled jobs on MS SQL server using sql server agent.
• Created operational reports using SSRS.

Environment: QlikView 11.20, Qliksense 2.2.1, Qlikview Server, MS SQL Server, Wherescape, SSIS, SSRS, IDMS and Oracle

Confidential, Pittsburgh, PA

Qlikview Consultant

Responsibilities:

• Developing Proof of concept using Qlikview.
• Extracted data from multiple sources like Oracle database, SAP BI,excel.MS access etc.
• Designed, developed and implemented QlikView Business Intelligence reports
• Developed dashboards pertaining to KPI monitoring using Qlikview 10.
• Worked extensively on script editor and set analysis.
• Identified and created Use Case from the gathered user requirements and prepared a comprehensive Use Case Specification Document.
• Worked on 3 dashboards and 10 million records which were updated every month, during the stint.
• Worked wif Macros, Filters, Variables, Set Analysis, Aggregate functions and Mapping Functions
• Presented QlikView applications to various levels of user
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Performance tuning the Dashboard .
• Performed issue analysis for the modules developed in Learning Management System
• Performed functional quality control testing in several modules

Environment: Qlikview 9, QlikView 10, SAP Connector, SAP Sales Module, MS SQL Server, MS Excel, MS Access and Informatica

Confidential, South Plainfield, NJ

Data Warehouse Developer Consultant

Responsibilities:

• Developed Dashboards using Qlikview .
• Worked on various ELT/ETL tools like ODI and Informatica.
• Worked on all phases of an ETL Project Life Cycle
• Designed, developed Informatica mappings, enabling the Extract, Transform and Loading of the data into target tables.
• Involved in working wif different schemas, Dimension and Fact tables .
• Worked wif the PL/SQL, SQL Loader, Toad to check for the quality of data as per the business needs
• Worked extensively wif Oracle SQL and PL/SQL Coding

Environment: ODI 10.1.3.5/11g, Qlikview 9,Oracle 9i/10g/11i, PL/SQL, SQL Loader, SQL Server 2000/2005, Toad, UNIX Shell Scripting

Confidential

Oracle Developer/DW Database Developer

Responsibilities:

• Technical Analysis: Discuss business requirements and create technical specifications
• Development: Wrote Oracle, SQL and PL/SQL code to implement the technical design
• Performance tuning: Tuned SQL and PL/SQL for enhanced performance
• Unit Testing: Created test scenarios to validate the solution developed according to technical design and business requirements
• Documentation: Assisted in creating formal documentation for the project.
• Support existing applications
• Support: Assisted to investigate and correct defects in the application
• Reports development: Created reports using SQL
• Designed, developed Informatica mappings, enabling the Extract, Transform and Loading of the data into target tables.
• Extensively used most of the transformations including but not limited to lookups, Expressions, Routers, Update Strategy, Sequence Generator, Joiner and others.
• Involved in working wif different schemas, Dimension and Fact tables.
• Extensively worked wif Workflow Manager, Workflow Monitor, Designer and Repository Manager, Source Analyzer and Warehouse Designer.
• Extensively used ODI for ETL purposes.
• Configured Oracle Data integrator (ODI) Master Repository & Work Repository on Oracle Database.
• Created ODI Interfaces under Projects to populate the target.
• Designed,developed and Implememented Qlikview Business Intelligence reports.

Environment: Oracle 10g\9i\8i, SQL, PL/SQL, UNIX, Toad, Informatica 8.1, ODI 10.1.3.5, Qlikview 9