SUMMARY

• Around 7 years of experience in Business Intelligence, Data Modeling, and Data Warehousing.
• 5+ years of IT experience in working with QlikView components such as Qlik Sense, QlikView Desktop, QlikView Enterprise Management Console (QEMC), QlikView Publisher, QlikView Web Server and Ajax Clients.
• Certified QlikView 11 Developer/Designer with sound data modeling and analytical skills.
• Data Literacy and Data Analytics Certified Professional always interested in learning new technologies.
• Proficient in Set Analysis to provide customized functionality in QlikView Applications.
• Working on Qlik Sense Mash ups using iframes for the organizations Intranet SharePoint pages.
• Trained for Nprinting 17 and is involved in the creation of Nprinting apps for reporting purposes.
• Actively worked with QlikView Functions and Expression Scripts and Streamlining Reporting operations of QlikView Applications using Charts including Drill Down, Drill up, and Cyclic Grouping, List Boxes, Input Fields, Table Boxes, Calendars, Date Islands, Pivot Tables, Straight Tables, Pie - Charts, Gauge-Charts, Trellis, etc.
• Production Support, and Implementation of Security in QlikView Applications at the Document and Server Level.
• Experience in developing ETL scripts for Data Modeling (Star Schema, Snow Flake Schema) along with resolving Synthetic Key and Circular Loop issues.
• Adept in reviewing and analyzing Business Processes and Business Process Flows and implementing QlikView Solutions by identifying KPIs at various stages of the project lifecycle.

TECHNICAL SKILLS

Reporting Tools: QlikView 9.x/10.x/11.x/12.x Series, Qlik Sense 2.x/3.x/Nov 2018 Release

ETL and other tools: TOAD for Oracle 12.1, NPrinting 17, SQL Developer

Databases: Oracle 9i/10g/11g, DB2, SQL Server 2005/2008, GreenPlum, MS Access.

Programming: SQL, Objective - C, Core Java

Office Applications: Visio, MS Excel, Office 365 Suite, SharePoint Designer

Web Technologies: HTML, XML, VB Script

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

Senior QlikView/Qlik Sense Developer

Responsibilities:

• Involved in a Qlik Sense Pilot Session to design and develop dashboard drafts in Qlik Sense.
• Involved in making a decision of adopting Qlik Sense and slowly retire QlikView.
• Trained and Qualified for Qlik Sense for Business Analytics - Data Architect from Qlik Tech.
• Working on creating Qlik Sense Mash ups using different HTML iframes to embed the reports into SharePoint pages.
• Developed PMAP comparative analysis dashboards to report yearly staff performance and calculate employee performance awards per the budgeted award rates.
• Developed Federal Employee Viewpoint Survey (FEVS) Analysis Dashboard that displays the analysis of a federal agency’s employee engagement based on the results from the annual FEVS to include: Work Experience, Work Unit, Agency, Supervisor, Leadership, and Satisfaction.
• Developed Billing Dashboards to compare the transaction status changes of a charge by integrating different data sources (e.g. Billing, Collecting).
• Developed Service Area specific ServiceNow Analysis Dashboards to track the response time and performance of Service Desk Agents.
• Co-developed and tested HR Dashboard and enhanced it with important Key Performance Indicators (KPIs).
• Developed Acquisitions and Contracts Dashboard to track all Confidential professional and service contracts. Developed Alerts system that sends out emails when a specific contract is about to expire so that immediate action can be taken based on the decision to renew/terminate a contract.
• Developed a Confidential Employee Directory Details Dashboard with flexible search options to obtain current directory information of an employee.
• Create and automate tasks in the QlikView Management Console (QMC).
• Conduct performance tuning of applications to improve performance and optimize data models.
• Develop Section Access scripts using user groups from Active Directory and named users.
• Create distribution tasks in the QMC and grant application access to users on the QlikView Access Point.
• Provide QlikView Server support to the end user. Research and troubleshoot technical issues including application access or server reloads.
• Conduct training sessions with different group of users to help them analyze and explore dashboard functionalities and troubleshoot and resolve any issues.
• Prepared technical documentation and user manuals for the enterprise applications.

Confidential

Sr. QlikView Developer

Responsibilities:

• Gathered business requirements from the Incident and Client Advisory team to generate weekly and monthly reports.
• Designed and developed dashboards to automate weekly and monthly reports.
• Designed CITA Data Reporting Dashboard to report critical incidents needing immediate action and to analyze the current status of the incident.
• Designed and developed a QlikView Dashboard which analyzes the performance and response rate of each staff member based on the number of incidents assigned to them.
• Wrote complex formatting and conditional criteria VBSCRIPT macros consistent with senior management formatting requirements.
• Redesigned and/or developing an existing QlikView application using QlikSense.
• Created Microsoft Access Database to track and log incidents that needed further approvals.
• Pulled data from the Access Database to develop a Case Manager Performance Metrics Dashboard.
• Developed three dashboards that generated twelve reports each with a single button click and reduced weekly report manual work by 90%.

Confidential

Sr. QlikView Developer

Responsibilities:

• Gathered business requirements and prepared functional specifications for application development.
• Connected to Oracle using OLEDB and ODBC data connections to create and schedule ad-hoc reports by leveraging the basic components of QlikView.
• Proficient in Set Analysis to provide customized functionality in QlikView Applications.
• Developed Budget and Finance comparative analysis dashboards to provide a flexible and user-friendly analysis application.
• Developed applications for Financial Management to perform a comparative analysis and display the General Ledger for multiple fiscal years.
• Developed a customized Budget and Finance application that displays transactional level data using the concept of direct discovery.
• Performed different tasks including extracting data from the database, writing complex load scripts, and generating QVD files for faster and improved performance. Also, developed user friendly interfaces to simplify analytics for non-technical users.
• Developed an Executive Dashboard that provides a high-level summary of all business areas and their performance status for Confidential executive staff.
• Created distribution tasks in the QMC and granted application access to users on the QlikView Access Point.
• Conducted performance tuning of applications to improve performance and optimize data models.
• Experience with passing parameters through URL from Cold Fusion into QlikView.
• Developed Section Access scripts using user groups from Active Directory and named users.
• Actively supported users with any issues related to QlikView dashboards in production.
• Actively monitored the tasks in the QMC and set up email alerts to be notified of a task failure.
• Provided QlikView Server support to the end user. Researched and troubleshot technical issues including application access or server reloads.
• Prepared technical documentation and user manuals for the enterprise applications.

Confidential

QlikView Developer

Responsibilities:

• Developed User Interactive Sheets and Reports.
• Developed SQL Scripts for validating data from different data sources implementing Star schema and Snow flake schema (confirmed dimensions).
• Developed Link Tables and Concatenation (Resolving Loops and model ambiguity).
• Created Dashboards using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks. Developed KPIs and set analysis applications.
• Gathered and loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g .CSV and Excel files).
• Generated QVD files created by ETL logic.
• Coordinated with ETL team and performed integration testing to check data discrepancies.
• Automated QlikView tasks in QMC, rolled out to QlikView Access Point, and administered Security using Active Directory.
• Analyzed the existing QlikView data model, script logics, and the ETL business logic for existing QlikView applications.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.
• Published client application using QlikView Publisher and rolled out to Shared Drive.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.