SUMMARY

• Over 7+ years of professional experience in the field of Business Intelligence and Analysis.
• 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
• Implemented various levels of security through QlikView (Hidden Script, Section Access, Document/ Sheet level Security)
• Enhanced QlikView scripting and ETL Solutions across multiple data sources
• Good knowledge in using SET ANALYSIS, Access point to provide customized functionality in QlikView.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Good Knowledge of Data Warehousing Concepts and SQL.
• Good Knowledge in designing Dashboards and Reports in QlikView.
• Expertise in data modeling using Star/Snowflake Schema Design, Relational Data Modeling, Fact and Dimensional tables.
• Experience in design, development, data loading and data extraction from SQL Server, as well as different source files.
• Involved in collecting the business requirements, Building the Data Model, Creating dashboard/reports and scheduling the reports.
• Experienced in designing, developing, implementing and administrating QlikView Business Intelligence Applications in a fast-paced environment.
• Experience in creating user friendly and interactive Charts, Detail tables, Buttons, Calendar Objects etc.
• Extensive experience in Designing, Developing, Deploying, and Publishing QlikView dashboards.
• Strong communication skills, well organized, and able to Work with a team as well as Leading a group.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Worked closely with visual design team to select the appropriate visualizations for BI deliverables
• Performance tuning by analyzing and comparing the turnaround times between SQL andQlikView.
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts.
• Excellent ability to translate client requirements into effective solutions
• Ability and willingness to learn new technology and deliver results in a timely manner.

TECHNICAL SKILLS

QlikView Tools: QlikView Developer 11, Macros, Action, Set Analysis, QVD, Google Maps.

QlikView Administration Tools: QlikView Server 11, Publisher, QEMC.

QlikView Security: Section Access, Conditional Hide/Show, Hidden scripting, File Reductions.

Databases: Oracle, MS SQL Server, MySQL, Access, SAP Connector

Operating System: Windows NT, XP, 7, 10.

MS Office Tools: Access, Excel, Word, Power Point.

PROFESSIONAL EXPERIENCE

Confidential, Akron, OH

BI QlikView Developer

Responsibilities:

• Extracted data from SAP to make generic QVD’s then specific extraction QVD’s then Application QVW
• Worked off of a prototype
• Designed UI
• Made 2 applications with difference in color and other option for the users to test and decide which one they prefer
• Worked on QMC to schedule and reload tasks in development
• Used TFS for UAT
• Edited existing queries, replaced joins with mapping loads
• Used attributes
• Used a combination of $ sign expansion, Variables, If Statements, wild match function and Set Analysis for changing complex expression in the front end to very simple expressions and for increased performance.
• Created Buttons with various actions
• Used conditional show options for Restricting, hiding & un-hiding different charts based on user selection.
• Created Actions for defining default selections, Input fields on-open of QVW files
• Created Data Extraction charts to export specific data to excel
• Worked with Service Manager
• Was involved in requirement gathering meetings
• Worked with users to explain how the application works

Confidential, Washington, D.C.

QlikView Developer

Responsibilities:

• Created and built a Data Mart/Views in SQL to import data from clients Data warehouse which was specific to the Tables and Columns required for the QlikView front end development.
• Reviewed Clients current Single Server Environment and established modalities to upgrade to Enterprise environment.
• Lead and Managed a group of three Off-Shore developers
• Developed and embedded advanced QlikView Objects and Extensions
• Utilized Set Analysis within various chart expressions within QlikView11
• Utilized a Three Tier Architecture approach when designing and creating migration packages for QlikView 11
• Utilized various Debugging methods for QlikView
• Implemented various levels security through QlikView11 (Hidden Script, Section Access, Document/ Sheet level Security, and Active Directory)
• Resolved Clients performance issues by implementing performance tuning techniques and in the process discovered Cartesian product within the client’s model which was the culprit for inaccurate data reports.

Environment: Windows Server 2012 Enterprise Edition, Share Point 2013 Enterprise Edition, QlikView Server, QlikView Publisher, SQL Server 2008R2 / 2012, QlikView 11, SSIS

Confidential, PLANO, TEXAS

BI/QlikView Developer

Responsibilities:

• Lead and Managed a group of two developers
• Developed and embedded advanced QlikView Objects and Extensions
• Developed and implemented Set Analysis and Point in time reporting and dynamic adhoc Analysis sheets
• Utilized Set Analysis within various chart expressions within QlikView11
• Utilized a Three Tier Architecture approach when designing and creating migration packages for QlikView 11
• Utilized various Debugging methods for QlikView
• Involved in creation of various Business Intelligent/ Analytical Dashboards over various line of business
• Implemented various levels security through QlikView11 (Hidden Script, Section Access, Document/ Sheet level Security, and Active Directory)
• Backup and recovered databases both operational and developmental
• Created and designed various data models (Star and Snow Flakes).
• On call 24/7 support to databases on weekly rotation.

Environment: Windows Server 2012 Enterprise Edition, Share Point 2013 Enterprise Edition, QlikView Server, QlikView Publisher, SQL Server 2008R2 / 2012, QlikView 11, Microsoft 365, TSQL, SSIS, SSRS

Confidential

Technical Associate

Responsibilities:

• Involved in requirements gathering.
• Understand Requirement, Analyzing Systems and Source Databases.
• Identified data sources and prepared data for QlikView applications.
• Extracted data from Data Source and load data into QVDs.
• Designed and developed the application per the user’s requirements.
• Unit testing and Performance Tuning of all the report in order to reduce the execution time required for generating these reports and thereby improving the overall speed of execution and performance of the reports.
• Created Dashboards style of reports usingQlikViewcomponents like List Box, Slider, Buttons, Charts, and Bookmarks.
• Writing Complex Queries & Store Procedures.
• Designing & Development of Analysis Reports, Charts, Scorecards, Dashboards.

Environment: SQL server 2008 and windows server 2003