SUMMARY:

• Over 6 years of experience in full cycle of BI, from design to building to supporting dashboards/reports and administering using Qlikview BI technology.
• Experience in IT Software Development Life cycle involving Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing and Database Business Systems.
• Extensive knowledge on QlikView Enterprise Management Console (QEMC), QlikView Publisher, QlikView Web Server.
• Experienced in Nprinting installation, deployment and development of reports using nprinting.
• Expertise in deployment of dashboards in QMC, task scheduling and triggering, CAL Management and section access; involved in bouncing the qlikview servers and maintaining stability; involved in server setup, installation of qlikview and nprinting servers.
• Experienced in migrating qlikview server from virtual to physical servers and involved in scripting for restart and backing up PGO files.
• Experienced in working closely with key business partners to gather business requirements, understand them and transform into visual - interactive dashboards.
• Experienced on database such as creation of data models, Star schema, snowflake schema, users and their security access levels.
• Designed and implemented proof of concepts for clients in the financial sectors.
• Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.
• Sound knowledge in writing SQL Queries, PL/SQL Stored Procedures.
• Good knowledge in Agile (Scrum) methodology with JIRA tool.
• Good exposure to Tableau Desktop.
• Excellent team player with good interpersonal and communication skills.
• Ability to work under pressure in a fast-paced, competitive customer sensitive environment for improved performance, greater flexibility and reduced overhead.

TECHNICAL SKILLS:

Design & Development: Analysis, Design, Development, Testing, Implementation and Documentation

Business Intelligence: Data Visualization, Data Warehousing (DWH), Data Extraction, Data Modeling, Data Analytics, Data Loading, Data Monitoring, Data Cleansing.

Business Intelligence Tools: QlikView 10/11, Qlikview Nprinting 16.3/17.4, Qlik Publisher, Qlikview Management Console(QMC),Tableau Desktop 9x, QlikSense

Software Dev Process: Agile, Scrum

Tracking tools: JIRA

Development Tools: SQL Developer, Oracle PL/SQL Developer

Languages: SQL, PL/SQL, Unix Scripting, C

Databases: Oracle 11g/10g, MS Access, Excel & .CSV Files.

Web Server: Oracle WebLogic

Operating Systems: Windows versions, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, North Brunswick, NJ

QlikView Administrator/ Qliksense

Responsibilities:

• Extensive experience in handling Internet Information Server (IIS), Creating and configuring the virtual directories, map them to physical folders and configuration of the applications for domain authentication.
• Responsible for QlikView Server and Publisher maintenance - Creating tasks, scheduled jobs for QVD extracts and report reloads.
• Involved in Installation QlikView 12.0 SR5, Nprinting 16/17 in both publisher and server.
• Involved in testing dashboards of Qlikview 11.2 version to migrate it to Qlikview 12.1.
• Implemented the migration from an old virtual server to a new physical server and end to end installation of qlikview server related activities.
• Worked with 32-core processor with 2TB RAM server, having daily refresh.
• Involved in Nprinting 16/17 for qlikview nprinting deployments. Also assisted in migrating from nprinting 16 to 17.
• Worked closing with windows team by troubleshooting the IIS Configuration and worked with the server manger logs.
• Involved in end to end to installation of qlikview server through IIS server after creating firewall rules, installing the server, applying the licenses and then setting up folder structure and other features in the QMC.
• Involved in automation scripting for restart of UAT and PROD servers every week and backing up files regarding DOC CAL and Named CAL information.
• Trained new teams to onboard with their dashboards, assigning CALs, keeping a track of them and creation of active directory groups and adding users to it.
• Additionally also involved in Java installation and patching for all qlikview servers.
• Involved actively in all release activities for production and on-boarding new dashboards.
• Worked closely with the Networks team to install firewall rules and test them.
• Opened qlikview cases and directly worked with QlikTech to get many server issues resolved. Experienced in QVPR cleanup and learning the process flow of how qlikview backs up data and CALs.
• Experienced in setting up the Qliksense server and involved in maintenance of server activities.

Environment: Qlikview 11/12.1, QlikSense 11.11.2, Nprinting 16/17, IIS Server, Oracle Database 11g, Data Warehousing (DWH), Excel and text files.

Confidential

QlikView Technical Consultant

Responsibilities:

• Worked closely with key business partners and management to understand, gather and analyze business requirements.
• Analyzed complex data, perform gap analysis, design and implement solution, and prepare technical design documents; migrating data between different environments and perform data profiling.
• Gathered data sources like QVD files, Excel, Oracle 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 functions.
• Involved in development of financial reports(Profit & Loss).
• Developed User Interface Sheets and 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 through Section Access & involved in Deployment of Qlikview Applications.
• Created QVD’s from multiple sources & updated on timely basis as database updates.
• 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.
• Involved in end to end testing to achieve zero-defect reports.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: Qlikview 10, Oracle Database 11g, SQL, PL/SQL, Data Warehousing (DWH), Excel and text files.

Confidential

PL/ SQL Developer

RESPONSIBILITIES:

• Work with internal team to gather, understand and check for the feasibility options for the requirement.
• Involved in developing 6 front end screens using internal rapid application development (RAD) tool.
• Installed and maintained the server for the RAD tool; created users and granted access to use the tool.
• Created new packages, procedures, functions, triggers, cursors using oracle pl/sql developer.
• Involved in fixing the issues raised during UAT.
• Developed and tested the deliverables to ensure zero defects.
• Prepared technical document, design document and release document.
• Involved as an active member for all the Go-Live activities.

Environment: QlikView 9, Oracle Database 11g, SQL, PL/SQL, Excel files, .CSV files.