PROFESSIONAL SUMMARY:

• 8+ yearsof experience in architecture, development, and deployment of information delivery systems with extensive focus on Data Warehouse/Business IntelligenceusingQlikView, Qlik Sense, Informaticaetc.
• Extensive experience in Full Life Cycle Development including Analysis, Design, Implementation and Maintenance of different analytical applications using QlikView suite of Products(QlikView Server, Publisher and QlikView Enterprise).
• Implemented the3 - tier architecture(Data-Extraction, Data-Modelling and Application Development) as recommended in QlikViewbest practices guide.
• Performed POC on Qlik Sense to generate immediate analyses and insights for reporting from mobile platform.
• Expertise in working with diverse business users to understand the requirements and develop a robust data model that will support the current requirements and future business growth utilizingAgile Methodology.
• Strong Knowledge in designing and developing Data marts, Data Warehouse using Multi-dimensional models such asSnow FlakeandStar Schema.
• Expertise in Installing and Configuring QlikView Server and Publisher with QlikView web server in both clustered and non-clustered environments.
• Experienced in configuring Authorization on QlikView Server both NTFS & DMS.
• Strong experience in Scripting, developing and designing dashboards using QlikView by extracting data from multiple sources (SAP BW, Teradata, Oracle, SQL Server, Flat files, Excel, Access).
• Extensively used different QlikView features and scripting statements (Different Load Techniques, Keep, Join, Concatenate, Apply Map, Set Analysis, Drill Down Groups, Cyclic Groups and Actions)
• Implemented data level security usingSection accessthat hides selected areas of the dashboard & filters data dynamically depending upon user privileges.
• Developed Unified QlikView Dashboard's and worked with various sheet objects like list boxes, bar charts, combo charts, radar charts, pie charts, straight table, pivot table, container, current selection box, Search and so on.
• Extensive use of advanced QlikView features like Alternative State, Incremental Load, Interval Match, Link Table, Document Chaining and so on.
• Always worked in close association with customers and a single point of contact for many major implementation projects
• Demonstrated technical expertise in popular ETL tools like Informatica 7.1/7.3/8.1/8.6/9.1/9.5 (Power Center Designer, Workflow Manager and Workflow Monitor).
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer. Strong experience on Workflow Manager Tools - Task Developer, Workflow and Worklet Designer.
• Created ETL mappings using Informatica Power center to move data from multiple sources like Flat files, SQL Server and Oracle into a common target areas such as Data Marts and Data Warehouse.
• Hands on experience with mappings from varied transformation logics including Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy, and Re-Usable Transformations.
• Strong Knowledge in understanding Data Quality concepts.
• Experience in using databases like Teradata, Oracle, SQL Server and DB2.
• Expert level understanding of Oracle Database Capabilities and DW best practices including appropriate use of Index,Partition, Views, Materialized Views etc. in Oracle.
• Extensively involved in Production Support (24x7) and become expertise in handling all kinds of QlikView related issues raised by users.
• Experience in Onsite-Offshore coordination in delivering Business Data Visualization Intelligence Solutions.
• Excellent Analytical abilities, Technical skills, communication skills, problem solving skills andability to learnnew technologies

TECHNICAL SKILLS:

Business Intelligence Tools: QlikView 12.0/11.0

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 7, 10.

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

RDBMS: Oracle, SQL Server, Teradata, MS Access

WORK EXPERIENCE:

Confidential - Columbus, Ohio

Sr. Qlikview Developer

Responsibilities:

• Managed company-wide system of QlikView BI solutions to ensure optimization of both data models and front-end UIs.
• Gathering data sources like QVD files, Excel, Oracle, binary QVW, Inline & txt files in developing theQlikViewData Models.
• Participated in Business Processes with the Business Analyst to understand the requirement and Reviewed High Level Design Documents, Functional Specifications documents with the Technical Manager.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts.
• Developed SET ANALYSIS to provide custom functionality in QlikView Applications.
• Collaborated with Business users and cross functional teams to develop Business Requirement
• Documents. (BRD), define KPIs (Key Performance Indicators), and identify data sources.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• Created QVD file to hold data from data sources and updated the QVD files on timely basis as the source database updates. Developed various Qlikview Data Models by extracting and using the data from various sources like QVD files, MS SQL DB, Excel and Flat Files.
• 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).
• 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.
• Used QlikView Scripting and Complex SQL coding for loading, and transforming.
• Development and Implementation ofQlikView Dashboards based on complex data extraction and load architectures.
• Created QVD's & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Maintained both File and Data Level Security and implemented Data Reduction.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.
• Prepared user documentation with screenshots forUAT (User Acceptance Testing).
• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.

Environment: QlikView 12.0, Oracle 10g, Access, Qlikview Server, Qlikview Enterprise and Qlikview Publisher, SQL Server 2014.

Confidential - Phoenix, AZ

Responsibilities:

• Meetings with end users to gather the functional requirements and customize Qlikview dashboards accordingly.
• Integrated data sources and databases with QlikView. Designed and developed data models and backend queries for presenting data. Designed, developed and implemented Qlikview dashboards.
• Created Dashboards with different style using QlikView components like List Box, Slider, Buttons, charts and Bookmarks. Optimizing the dashboards that are taking a lot of reload time.
• Developed SQL scripts to load business data and used VB macros and set analysis to create customized reports for regulatory reporting. Developed KPIs and set analysis application with QlikView functions (join, concatenate, keep, apply map).
• Tested Applications, ensuring the application met the requirements, Data quality for Quality Assurance before delivering to the end users.
• Used CognosBI Framework Manager in building the Models and packages and published into Cognos connection Portal and implemented securities for the packages.
• Involved in extracting the data using SSIS from OLTP and OLAP.
• Support user Acceptance testing for the dashboard functionality. Reviewed QlikView error logs for exceptions to provide production support. Interacted with the Customer Support Group for domain requirements gathering.
• Interacting with business users and business analysts to understand the functional requirements.
• Developed different dashboard with a complex database system which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Validation of Qlikview application at base level against QVD’s and Excel test files.
• Set Analysis in providing custom functionality to QlikView Applications.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String&Input Fields).
• Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using Qlikview Enterprise Management Console.
• Gathered & loaded data intoQlikViewfrom various data sources (Sql server 2012, Oracle 10g, .CSV and excel files).
• Monitoring of the QVS (Access Point), QVW's and user accounts for the usage of the applications.
• Implemented section access which allows user to see by default their Region’s data and population attached to a particular Region.
• Performance tuning of dashboards was carried out to limit the response time.
• Implemented security layer and extensively involved in the deployment activities of the Qlikview Application.
• Wrote SQL Scripts to load relevant data in QlikView Applications.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Support included creation of reports and standard relational databases for upload to SharePoint dashboard web part pages, and creation of supporting SQL queries.
• Experience in data modeling, data loading, data migration, data analysis.
• Developed production-grade Qlikview reports and dashboard to meet business requirements in timely manner.

Environment: Qlikview 11, Qlikview Server, Qlikview Enterprise and Qlikview Publisher, Excel, MS SQL Server 2012, SQL, Oracle 10g, Teradata, SharePoint.

Confidential - Minneapolis, MN

QlikView Developer

Responsibilities:

• Worked along with Business analysts for acquiring business requirements.
• Interacted with End Users and Documented the Requirements.
• Developed various internal prototypes for acceptance testing.
• Followed the agile pattern of working and work execution.
• Develop front end applications using QlikView technology.
• Connected to multiple data sources such as Oracle, DB2, Flat files, Excel Spreadsheet's and prepared close to business requirement like model. (Especially star model and snowflake).
• Established a Standard structure for Test and working files (QVW) and version controlling to maintain parity between production and Test environment.
• UsedQlikViewdirect discovery along with Document chaining to fetch on-demand report from linear database after creating View inside the database to protect performance from huge data loading during mass data accumulation due to Granular data fetching.
• Implemented 3-Layer architecture, Binary loads and Incremental Loads for optimal performance of the Dashboard reloads, rescaling and to adhere to data retention standards.
• Incorporated necessary log files and failure mailing mechanisms for smooth day to day operations.
• Worked on data model according to the user requirement and successfully created an optimized QlikViewapplication.
• White boarded closely with the business in order to map out the most valuable visualization elements on the dashboard.
• Developed dashboards and KPI's using set analysis, variable creation etc. for individual payroll details, comparison with peer and comparison with the market.
• Performed testing of dashboards for functionality, data, performance, and UI design.
• Created weekly PDF report distribution for a set of users using Loop and Reduce functionality through QV Publisher.

Environment: QlikView10, Oracle 9i, SQL Server 2008, Qlikview Server, Qlikview Enterprise and Publisher, Access, CSV Files, Windows 2008 Server, SharePoint.

Confidential - Portsmouth, NH

QlikView Consultant

Responsibilities:

• Worked with a team of marketing analysis experts to gather requirements
• Designed data models based on the client requirements and without any ambiguous or Synthetic tables.
• Stored the tables as QVDs and used Scripts to generate appropriate fields that help in modeling the data according to the requirements.
• Generate new QVD files created by ETL logic to feedQlikViewapplications
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the application
• Coordinated with ETL team and performed integration testing to check data discrepancies
• AutomatedQlikViewjobs inQlikViewPublisher and rolled out toQlikViewAccess Point and administered Security using Active Directory
• Analyzed the existingQlikViewdata model, script logics and the ETL business logic for the existingQlikViewapplications
• Used various Charts, aggregation functions, set analysis statements for designing the dashboard.
• Equipped the dashboard with an automation trigger to update the data in the dashboard whenever the database is updated.
• Designed a dashboard that is easy for the clients to use and to analyze their purchases and predict the requirements for the future.

Environment: QlikView 9.0, TOAD, SQL, Windows XP/2003 server, Oracle, PL/SQL and UNIX

Confidential

SQL Server Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements, and data Specifications about the financial systems.
• Analyzed the Infrastructure, ETL processes including staging areas, log tables, job schedule time and generated Reports.
• Developed Drill Down through Dashboard reports which enabled users to drill between Summary QlikView to detail Web reports, templates, and personalization.
• 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.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt, and Payment Reports in response to user needs.
• Creation of reports using reports and charts as per the customer requirement depends on Quarter, monthly and analyzes the report with charts provided by QlikView.
• Developed SET ANALYSIS to provide custom functionality in QlikView Applications.
• Implemented Section access and hidden scripting for the Application Security.
• Created User Conditions and Filters to improve report generation & readability and SQL tuning of report and displayed the summary of data by creating Charts by using QlikView.

Environment: QlikView, SQL Server 2008, Oracle, PL/SQL and UNIX