SUMMARY:

• 8+ years of experience in Business Intelligence, Decision Support Systems, ETL Process, and Application Development. Including 6+ years of strong end - to-end experience on BI tools like QlikView/Qlik Sense, Tableau, SAP Business Objects, SAP Lumira.
• Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schemas.
• Design and create reports, dashboards, and visualizations to reliably drive business processes
• Expertise in ETL (Data Extraction, Transformation & Loading), Data modelling, Report designing and Performance Tuning using QlikView.
• Proficient in creating QV data models, QV objects, reports, graphical interactive UI and dashboard using different data sources like Oracle, SQL Server, QVD files, Access, text files, excel documents etc. as per the user requirement.
• Extensively worked on QlikView designer objects like straight/Pivot tables, Containers, line charts, bar charts and pivot tables Etc.
• Expertise knowledge in Set Analysis, Advanced aggregations, synthetic keys and circular s.
• Hands on experience on implementing incremental loading.
• Worked extensively on QlikView server/publisher to handle user security/data reduction.
• Experienced in Qlik Sense/QlikView Server and Publisher maintenance - Creating scheduled Jobs for QVD extracts and report reload.
• Developed applications specific to IPAD and implemented mobile reporting best practices in Qlik Sense.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Worked on the complex requirements of transitioning from one application to another application using Transfer State.
• Have implemented the Macros in the QlikView application.
• Involved in Optimization of QlikView Dashboards with a focus on Visualization, usability, Performance, Long-term, Flexibility, Accuracy and Standardization.
• Had experience in security restrictions in Designer and Access Restrictions in Business Objects Enterprise.
• Create Tableau dashboards to evaluate Patient and Treatment KPI's by volumes.
• Develop, maintain, and update Tableau data sources against Teradata database. Design extracts using data-shaping best practices to support Tableau design performance
• Developed daily reports to the executive board using tableau.
• 30% performance increase by tuning data extracts, using autonumber() and by removing Timestamps.
• Experience in designing and developing Universes, Dashboards, Webi Reports and Crystal Reports, Business Objects Enterprise Administration and thorough knowledge of Business Objects Enterprise Architecture.

TECHNICAL SKILLS:

Qlik Products: QlikView 11, QlikView 12, Qlik Sense, Qlik Nprinting, Qlik Maps, Qlik Geo-Analytics, Qlik Scripting

ETL Tools: Talend, Alteryx

Other Analytics tools: Tableau, Crystal Reports, Web Intelligence, Xcelsius, SAS Enterprise miner, R analytics

Database: MS SQL Server, Oracle.

SAP Products: SAP HANA, SAP BW, SAP BODS, SAP R\3, SAP Lumira, SLT Replication

Programming languages: Java, C, C++, HTML, R Programming.

WORK EXPERIENCE:

Confidential, Chicago, IL

Sr. Qlik Developer

Responsibilities:

• Worked with the end user to gather and analyze the requirements.
• Created a Lease Comparison application in Qlik Sense that enables the user to give various details of a lease, compare the factors and predict the best suitable Lease for the client based on the Net Present Value.
• Extensively worked on VizLib Extension objects in Qlik Sense to create dashboards.
• Debugged, analyzed and increased performance of more than 100 applications while migrating them to a new server.
• Expertise in ETL (Data Extraction, Transformation & Loading), Data modelling, Report designing and Performance Tuning using QlikView.
• Well versed in creating QV data models, QV objects, reports, graphical interactive UI and dashboard using different data sources like Oracle, SQL Server, QVD files, Access, text files, excel documents etc. as per the user requirement.
• Extensively used Layering techniques to create interactive dashboard.
• Implemented and managed section access and security by implementing Section Access and tested the module in production.
• Created Mashups in Qlik Sense
• Created applications that are metadata driven.
• Worked on Qlik Geo Analytics, Qlik Maps.
• Created proof of concept for Nprinting to generate daily reports.
• Extensively used Document Analyzer while debugging the application to increase the performance of the application.
• Worked on QlikView Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications. Applications were refreshed on a monthly basis and used by a group.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Created many Macros for applications.
• Documented technical and functional specifications.
• Creating Tasks for reloading of QlikView data to QVDs and QVWs through QMC.
• Extensively worked on QlikView designer objects like straight/Pivot tables, Containers, line charts, bar charts and pivot tables Etc.
• Expertise knowledge in Set Analysis, Advanced aggregations, synthetic keys and circular s.
• Hands on experience on implementing incremental loading.
• Worked extensively on QlikView server/publisher to handle user security/data reduction.

Environment: QlikView 11, QlikView 12, QlikView Server 11, QlikView Server 12, Qlik Sense, JIRA, Fresh Works, VizLib Extension Objects for Qlik Sense, Alteryx, Qlik Nprinting, Qlik Publisher, Qlik Management Console, Qlik Document Analyzer, Flat files (Excel, xml files), MS Access Database, Oracle, MS SQL Server, Windows 10,

Confidential, Rochester, MN

BI Developer/QlikView Developer

Responsibilities:

• Design and develop visualizations in Tableau
• Developed a pilot project to see the performance of QlikView while migrating the reports from Crystal Reports.
• Worked closely with Business users, ETL developers and Project Managers.
• Converted existing Excel reports to Tableau dashboards.
• Created different KPI’s using calculated key figures and parameters.
• Developed Tableau data visualizations using Cross tabs, Heat maps, Area charts, Line charts, Maps and Bar Charts.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created various interactive customized dashboards and stories.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Used Tableau Cmd for various Dashboard migrations from one environment to another
• Developed unique visualizations like Funnel charts, Calendar graphs and Waterfall charts which received a lot of appreciation from senior management.
• Developed daily summary update reports for different channels, firms and products with the monthly, quarterly and yearly options
• Developed action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed calculative fields using functions available in order to obtain different metrics as per the requirements.
• Experience in writing SQL queries and Stored procedures to get the data relevant for the Tableau reports
• Restricted data for users using Row level security and User filters.

Environment: Tableau Desktop 9.1, QlikView 11 Desktop, Qlik Document Analyzer, Tableau server / Administrator, tabcmd - Tableau command prompt, Tableau drive, SQL developer, SQL Server 2012,Oracle 11g, DB2,Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007, TFS ticketing system, Crystal Reports, SAP BW, Talend.

Confidential, Austin, TX

Qlik Developer

Responsibilities:

• Used the Talend Open Studio to develop processes for extracting, cleansing, transforming, integrating, and loading data into target database.
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Developed QlikView Dashboards using different Chart, Drill through, Cyclic Groups, List, Input Field, Table Box, and Container.
• Created Dashboards style of reports using QlikView components like Slider, Buttons, Charts, and Bookmarks.
• Executed Simple and Complex SQL Queries like Joins, Select, and Update for data validation and data manipulation.
• Used SQL, PowerPoint, Excel and InfoView daily to generate various performance reports for analysis.
• Analyzed underlying data for potential discrepancies, investigate errors, and perform data cleanup.
• Designed, developed, implemented, and supported QlikView dashboards. Integrated data sources and databases with QlikView and designed and developed data models and backend queries for presenting data.
• Performed analysis, documentation, for calculation for various attributes.
• 3 Executive Dashboards depicting Sales and Inventory data were created during the stint. Dealt with a data volume ranging from 20 to 50 million records.
• Worked on QlikView Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications.
• Created PDF push reports and setup email distribution on QlikView Publisher 9.
• Reviewed QlikView error logs and provided production support.
• Created Dashboards with different style using QlikView components like List Box, Slider, Buttons, charts and Bookmarks.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved the loops issues.
• Implemented Incremental Load to improve Load Time.
• Tested Applications, ensuring the application met the requirements, Data quality for Quality Assurance before delivering to the end users.

Environment: QlikView 11, Talend for ETL, QlikView Desktop, Qlik Publisher, Oracle, MS Office, QlikView Server 11, Qlik Document Analyzer, MS Access Database, MS SQL Server, MS Excel 2007.

Confidential, Newark, CA

Junior BI Developer

Responsibilities:

• Worked closely with the Architect while integrating SAP HANA DB with QlikView.
• Used QVD and incremental loading to delete, insert and update records and highlight items changed;
• Used input fields to adjust data manually
• Developed KPIs and set analysis application with QlikView functions (join, concatenate, keep, ApplyMap)
• Implemented SAP BI proof of concept model by creating attribute views, analytical views, Calculation views.
• Loaded data from various SAP source systems to HANA using SAP BODS and SLT replication techniques.
• Visualized the data using SAP BusinessObjects 4.0(Crystal reports, web intelligence, Xcelsius) and QlikView.
• Analyzed the reporting requirements with the business users and designed the technical specs
• Created derived tables, implemented cascading prompts, checked the cardinalities, created joins, created contexts, and aliases for resolving loops, chasm traps and fan traps in the universe
• Improved performance and reduced the coding of the marketing, finance universe with the use of @functions (@aggregate aware, @select, @prompt, @where). created new and modified existing hierarchies, defined Alias and Contexts to resolve loops, exported the universe to the repository, updated and maintained existing Universes based on changing user requirements and based on changes in data source
• Created restrictions on objects and classes based on universes privileges, and generated List of Values (LOV’s) from lookup tables using Information Design Tool
• Expertise in analyzing the stored procedures and scripted calculation views
• Worked on delivery units for server Import\export (within landscape) and client import\export (exterior landscape).

Environment : QlikView 11 Desktop, QlikView 11 Server, Qlik SAP Connector, SAP Business warehouse, SAP Lumira, SAP HANA 1.0, SAP Business Objects, SAP BODS 4.1, SLT Replication, Crystal Reports, SAP ERP,SAP ECC 6.0, SAP Supply Chain Management, SAP Web Intelligence\Xcelsius

Confidential

SQL Developer

Responsibilities:

• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).
• Involved in complete Software Development Lifecycle (SDLC).
• Wrote complex SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.
• Advised optimization of queries by looking at execution plan for better tuning of Database.
• Performed Normalization & De-normalization on existing tables for faster query results.
• Wrote T-SQL Queries and procedures to generate DML Scripts that modified database objects dynamically based on inputs.
• Created SSIS package to import and export data from various CSV files, Flat files, Excel spread sheets and SQL Server.
• Designed and developed different types of reports like matrix, tabular, chart reports using SSRS.
• Maintained positive communication and working relationship with all business levels.
• Coordinating with onshore/offshore & stake holder’s team for task clarification, fixes and review.
• Reviewed, analyzed and implemented necessary changes in appropriate areas to enhance and improve existing systems.
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Knowledge on Extract, Transform, and Load Processes.
• Knowledge on software engineering and internet security.
• Strong knowledge on database management systems.
• Designed and implemented stored procedures, views and other application database code objects and stored blocks.
• Maintained SQL scripts indexes and complex queries for analysis and extraction.
• Worked with stakeholder’s developer and production teams across units to identify business needs and solution options.
• Ensured best practice application to maintain security and integrity of data.
• High record in process quality improvement and efficient data solutions management.
• Provided support for all operations focusing on integration of new products and services.

Environment: T-SQL, PL-SQL, MS SQL Server 2008 R2, Oracle, SSIS\SSRS, Aldata Shelf Planning, Confidential EYC Space Planning.