PROFESSIONAL SUMMARY

• Over 8 years as an IT professional and 6 years of Qlikview/Qliksense with extensive experience developing Qlikview applications, ETL design, database development, designing data modeling, data warehouse, requirements analysis and data conversions.

TECHNICAL SKILLS

Qlik Tools: QlikView, Qliksense, QlikView Publisher, Extension objects, Nprinting

Enterprise Management: Console,Management Console, QV Ajax Client, QV IE Plug - In.

Tools: QlikView, Cogons, SQL Developer, SQL Tools, Tableau.

Databases: Oracle 11g/10g, SQL Server 2005/2008, Teradata, MS Access. Microsoft DynamicsSybase, SAP HANA

Languages: SQL, PL/SQL, VB-Script

PROFESSIONAL EXPERIENCE

Sr Qliksense Developer

Confidential, NJ

Responsibilities:

• Configured different Qlik Sense roles and attributes based access control and designed the Qlik Sense Governance and development cycle.
• Created Qlik Sense data modeling, master items and maps
• Setup Qlik Sense architecture and sizing.
• Implemented Qlik Sense Extensions, workbench and embedding in websites.
• Came up with the concept of using Qlikmaps (Object Extension) to solve their geospatial questions.
• Migrated tableau reports to qikview and qliksense reports.
• Worked heavily with object extensions in QlikView this was not being done in BD to create charts that aren't their default (Bullet Chart, Org Chart, Word Cloud etc.)
• Converted Qlikview dashboard to Qlik Sense Dashboard.
• Introduced client to Qlikmaps by creating a mini-poc which the client ultimately bought.
• Dealt directly with Client suggesting them what they can or cannot do in Qlik Sense as well.
• Worked with teams to create automation tasks to handle file transfer.
• Trained all End Users on how to use Qlik and handle troubleshooting.
• Handled the whole QMC (Qlik Sense Management Console) token assignment analysis, monitoring tasks, publishing/importing apps, Stream restriction.

Environment: Qlik Sense 3.1, QlikView 11.0 SR3, Oracle 11g, MS SQL Server 2012Cigna Sept 2015 - Sep 2016

Sr. Confidential, Wilmington, DE

Responsibilities:

• Develop QlikView dashboards for multiple business functions within clinical department
• Involved in the requirements Gathering and Understanding the end- user business requirements and develop creative and visually effective user interfaces for Dashboards, Analytics and Reporting.
• Responsible for the QlikView Dashboard & Report development, which includes QlikView dashboard design /QlikView Script writing - connecting with varied sources (flat file/Oracle etc.), data cleansing, data analysis etc.
• Designed and developed a wide variety of charts and associated sheet objects to satisfycomplex business requirements.
• Creatinga relevant data model and front end to satiate the QlikViewrequirements
• Educated different user groups and peers with QlikView functionality.
• Have done the integration of project with the existing applications and used the Qlikview 11 features (Giving the users option to pick the Dimensions and Metrics).
• Implementing Security and Incremental Loading in QlikView Dashboards
• Monitoring the defects with HPQC and interacting with users to solve the issues.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Provided Production support to the existing Qlikview applications.

Environment: QlikView 11.0 SR5, Microsoft Dynamics, SQL Server 2012, MS Office.

Confidential, Salt Lake City, UT

Responsibilities:

• Developed highly customized QlikView dashboard applications.
• Designed and developed a wide variety of charts and associated sheet objects to satisfy complex business requirements.
• Created a navigational system that utilized QV hierarchy that used weights to identify values.
• Back traced data to make sure it works cohesively as well as accurately by looking for discrepancies such as duplicates, rescinded information etc.
• Was given the task to define major KPI so analyzed, brainstormed the needs of the company and created a trigger system that alerted higher ups in problems with any unit of measure they are measuring or would fall under their jurisdiction to know the status of.
• Wrote Complex set analysis statements.
• Used SQL Server Management Studio, TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Code review as well as fine tuning of applications as well as fixing data model.
• Scheduled tasks in server and Trouble-shoot application in access point as well provided maintenance.
• Dealt directly with CEO, CFO as well as all managers on day to day basis to create an effective system and that tailored to each person moreover primarily focused on CEO needs.
• Educated different user groups and peers with QlikView functionality.

Environment: QlikView 11.0 SR3, Windows Server 2003, Oracle 11g, MS Access 2005, MS SQL Server 2008, MS Office.

Confidential, San Diego, CA

Responsibilities:

• Focused on Template Design UI-friendly and implemented section access using Windows NT authentication.
• Designed and implemented mapping tables to support data transformation during data load.
• Extensively utilized native QlikView functions within load scripts and charts to streamline application design.
• Designed (ETL) processes for extracting, transforming and loading vendor sales data into Oracle tables.
• Created a relevant data model and front end to satiate the requirements.
• Implemented section access to enforce row-level data security.
• Utilized alternate states to simplify application design and reduce on-going maintenance.
• Created trigger actions to provide custom functionality such as setting variable values and default filter selections.
• Written QlikView Scripts, macros, design Dashboard and Reports for different user groups
• Deployed the QlikView Application to the server and automated the jobs.
• Managed QlikView Licenses User CAL, Document CAL, Server Licenses, Publisher Licenses.
• Held weekly meetings to track progress along with to optimize efficiency.

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

Confidential, Minneapolis, MN

Responsibilities:

• Gathered requirement and functional knowledge from the business.
• Extracted data from various sources used ETL load scripts to manipulate, concatenate and clean source data.
• Designed and developed the Data mart for the QlikView dashboards in star schema/snow-flake schema. Identified various sources and designed the data transfer and transformations with in QlikView.
• Developed dashboard’s using different components of QlikView like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Created and managed ETL script generation using QlikView Script Builder Application.
• Participated in the UAT process along with business users and ensured an effective delivery of dashboard applications.
• Created tasks in Publisher for the application from making the QVD’s to the whole application reload.
• Upgraded QlikView Server from QlikView 9.0 SR3 to QlikView 10.0 SR3.
• Managed QlikView Server Licenses and User Licenses.
• Worked with QlikView administrator to optimize QlikView performance.
• Provided Production support to existing QlikView Applications.
• Trained the end users effectively to use the reporting tool.

Environment: QlikView 11, Oracle10g, Toad, Squirrel, Netezza, SQL Server 2005

Confidential, Newark, DE

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.
• Created Dashboards, scoreboards for the required KPI’s in QlikView.
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Designed applications for to support the dashboard style of layouts using different components of QlikViewlike List boxes, Multi-boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Developed load scripts to work with multiple data sources (SQL, Oracle, Excel, and Oracle).
• Implemented the Incremental Loading feature in QlikView.
• Developed SET ANALYSIS to provide custom functionality in Qlikview Applications.
• Developed Macros, Set Analysis to provide custom functionality in QlikView Applications.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.

Environment: QlikView 11, Oracle10g, Toad, Squirrel, Netezza, SQL Server 2005

Confidential, Jersey City, NJ

Responsibilities:

• Clarified the requirements by talking to the user groups and accordingly modified the functional and technical specifications.
• Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule ad hoc reports by leveraging the basic components of QlikView
• Consolidated two existing QlikView Application.
• Created POC’s, proposed and documented the requirements to the user for consolidated application.
• Did the analysis of the application regarding user experience (Front end), QlikView data model change, volume estimation, QVW size estimation, BI processing time saved after consolidation.
• Did testing in two different servers and validated the data.
• Resolved the failure issue of existing publisher job in Production server.
• Validated the data of the reduced QlikView files.
• Executed the job in Publisher.
• Implemented the changes in Production to solve the issue.
• Handled other day to day Production server issues.

Environment: QlikView 9.0/8.5, SQL Server2005, Windows 2000 Server, oracle 10g, Microsoft Visio, QlikView Publisher, QlikView Server 9.0.