PROFESSIONAL SUMMARY:

• Having around 7 years of IT experience in Designing and Development of Business Intelligence application with QlikView and Qlik Sense tools.
• Strong experience in QlikView Desktop, QlikView Server, QlikView Management Console, Qlik Sense hub, Qlik Sense Management Console (QMC) etc.
• Experience in Agile methodology in developing the application.
• Developed multiple Dashboards like Forecast Accuracy, MRP Analysis, Supply Chain Analysis, Inventory, Sales Analysis, Account Payable and Account Receivable.
• Experience in full Life Cycle application development including Planning, Analysis, Design, Developing Prototypes, Data Modeling, Testing, Debugging and Implementation of Data Warehouse techniques.
• Experience in creating Mashup’s, Integrations using Qlik Sense Web services/API’s.
• Good knowledge in using Analytics Extensions, SAP & Sales Force connectors in Qlik Sense.
• Strong experience in understanding of Business Dataflow, Business Application and Data Relations.
• Implemented the 3 - tier architecture (Data-Extraction, Data-Modeling and Application Development).
• Expert in extracting the data from different data sources like Oracle, SQL Server, Salesforce, XML files, CSV files, WEB files, Flat files, Datamarts and Sales Force to generate QVD’s.
• Used Qlik Sense Scalability tools to create easy creation, execution and analysis of load/performance tests.
• Expertise in complex SQL & TSQL queries to extract the data from database and verify the output data of the reports along with creation of Tables, Sub queries, Joins, Views, Indexes, SQL Functions.
• Good knowledge on Developing, Querying and understanding the flow of data in RDMS
• Good knowledge on MS Business Intelligence suite of products like SSIS, SSAS and SSRS.
• Knowledge of Designing and Developing ETL process using SSIS & Informatica to load data from various databases.
• Good knowledge on Developing and maintaining of various SSRS Reports.
• Great knowledge on SSAS to create Online Analytical Processing cubes (OLAP) using data from different Data Marts/ Data Warehouse for deeper and faster data analysis.
• Worked on data modeling for the business objects
• Developed several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
• Developed standard and reusable mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter using Informatica.
• Experience in Migrating the Dashboards from QlikView to Qlik Sense environment.
• Involved in upgrading the software versions of Qlik Sense and NPrinting.
• Expertise in developing different complex Data Models without any Closed loops, Synthetic keys and Ambiguous relationships to create Qlik Marts.
• Extensive knowledge on Data modeling, Dimensional Modeling, Star/Snowflake Modeling, Datamarts, OLTP, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Expertise in implementing Geo-mapping and loading the location based analytics using KML files.
• Knowledge on QlikView Publisher, Data Visualization, Networks and File Shares.
• Experience in using ETL Tasks such as Data cleansing, Joins, Aggregation tables etc.
• Created reports in application using NPrinting and distributed them in formats like PDF & PowerPoint.
• Expertise in creating Dashboards using Qlik sheet objects and extensions including various Charts types, Straight and Pivot tables, Sunburst and Waterfall, Trends, KPI’s, Bookmarks etc.
• Strong knowledge on creating and using Variables, Templates, SET Analysis and functions.
• Developed and implemented Macros in Visual Basic to provide advanced functionality in Dashboards.
• Good Knowledge on QlikView Server and QlikView Publisher, scheduling Tasks, Monitoring Incremental Loads and Report reloads.
• Good experience in implementation of security by authentication and authorization at document level, Sheet and data level to the end users using QMC.
• Performance tuning of dashboard to reduce the calculation time and improving the overall performance of the dashboard by analyzing the data without any data quality issues.
• Great knowledge on developing the code in Python and R using different algorithms for Data Analytics.
• Strong skills to solve the problems to meet the complex challenges.
• Good communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• Excellent Interpersonal and Customer Relational Skills. Proven Communication, Presentation Skills and Leadership Qualities

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008/2005/2000, MS-Access, Oracle 11g/10g, Salesforce

Tools: QlikView 12.0/11.2/10/9.0, Qlik Sense 3.0 sr2, Tableau 10.2, Cognos 10, Informatica power center

Programming Languages: C#, Python, Visual Basic, JavaScript, Bootstrap

Query Languages: MS SQL, MySQL, TSQL

Web Technologies: HTML5, CSS3

Operating System: Windows 10/8/7/Vista/XP, Linux

Source Control: Team Foundation Server, Github

PROFESSIONAL EXPERIENCE:

Confidential, Englewood, CO

Sr. BI Developer/Admin (QlikView/Qlik Sense)

Responsibilities:

• Involved in Gathering, Managing and Documenting business and functional requirements of the application and created mockups based on the user requirements.
• Actively participating in full Life Cycle of application Design, Developing Prototypes, Implementation, Testing, Debugging, Reports, Delivery and Support.
• Extracted the data from different data sources such as SQL server and Excel files to generate separate QVDs.
• Created Mashup and integrations in Qlik Sense using Qlik Sense Web Services/API’s.
• Good experience in working with API’s both in QlikView and Qlik Sense
• Resolved and Removed Circular loops, Synthetic keys using various techniques such as Aliasing, Joins, Concatenation, Dropping fields etc to develop Qlik Marts by applying business rules.
• Used Qlik Sense Scalability tools to create easy creation, execution and analysis of load/performance tests.
• Used Apply Maps, Right Joins and Left Joins to reduce the number of tables in Data Modeling and to increase the performance of the Dashboard.
• Developed Star Schema & Snowflake Schema dimensional model with facts and dimensional tables.
• Extensively worked on performance (Database, Data Modeling and User Interface) for fast response of the application based on the end user selection.
• Worked on Incremental loads which updates the QVD’s with new updated data.
• Developed Dashboard using Filters, Gap Analysis chart, Sunburst chart, Charts (Drill down, Cyclic Grouping), Tables, Waterfall chart, Multi boxes, List boxes, Input field, Statistics box etc.
• Good experience in using and implementing Qlik Sense features like Story Telling, Charts, Custom objects, Master items and Fields using Qlik Marts.
• Experience in using Analytical Extensions, Qlik Sense Extensions to locate the geographic locations with the help of KML files and using Qlik Sense GeoAnalytics product.
• Effectively used Variables, Triggers to enhance the functionality of the QlikView and Qlik Sense application.
• Communicated and trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Aws SDK experience with an emphasis on EC2, S3 and IAM.
• Migrated Dashboards and Reports from to QlikView to Qlik Sense.
• Updated the Dashboards and Reposts from Qlik Sense 2 to Qlik Sense 3
• Provided Support to different Dashboards in application to enhance the functionality and to assist different users.
• Created SET Analysis expression in sheets for data visualization needs.
• Worked with testing team to get all the changes using Unit Testing.
• Involved in implementing Application level, Sheet level and Object level Security with section access method.
• Performance tuning of QlikView and Qlik Sense dashboard in order to reduce the calculation time and improving the overall performance of the dashboard without any data quality issues.

Environment:: QlikView 11.20, Qlik Sense 3.0 sr2, MS SQL Server 2012, Oracle 11g, MS Office, Windows 8, TSQL, Nprinting 16/17.

Confidential, New York city, NY

BI Developer/Admin (QlikView/Qlik Sense)

Responsibilities:

• Actively participated with business users and functional team to understand and gathering the requirements and worked with Business Users and Stakeholders.
• Developed different Dashboards and Reports with a complex database system behind it, which includes extracting data from the database, storing into QVD files.
• Imported the data from different data sources like Excel files, Web files, QVD’s, CSV files and Oracle into Qlik application.
• Involved in designing and construction of the Data modeling and implemented Start Schema for better optimization of the application.
• Experience in using Qlik Sense Scalability tools to create easy creation, execution and analysis of load/performance tests.
• Involved in Performance tuning at Database level, Script level and Application level.
• Worked with different kind of loads like Incremental loads, Resident loads Partial loads etc.
• Designed effective visualization using KPI Dashboard (Gauges, Text Objects and Charts etc) that helps management to make faster and better decisions.
• Worked on QlikView and Qlik Sense sheet objects like Charts (Waterfall chart, Pivot table, Line, Combo charts etc), List Boxes, Multi Box, Input Fields, Gap Analysis chart, Statistics Box etc.
• Good experience in using and implementing Qlik Sense features like Story Telling, Charts, Custom objects, Master items and Fields.
• Worked with Variables to enhance the functionality of application.
• Effectively implemented Set analysis and Aggregate function to show the result based on the user requirement.
• Developed Qlik Sense applications using various Qlik Sense extensions.
• Experience in using and creating Qlik Sense mashups to produce enriched results based on user requirements.
• Converted enterprise level QlikView dashboards to Qlik Sense.
• Used Filters, Variables and Mapping Functions to achieve user requirements.
• Used Section Access in both QlikView and Qlik Sense applications to do data limitation based on the user group, domain etc.
• Involved in creating tasks and deployed applications in Qlik Sense Hub using Qlik Management Console (QMC).
• Scheduled the Publisher Tasks Daily/Weekly/Monthly on various Dashboards based on the Database updates.
• Conducted training sessions to users about the functionality and usage of application.
• Implemented core business model by eliminating Circular joins using ETL best practices.
• Involved in testing the application using Unit Testing for validating the outcome of the QlikView application.

Environment:: QlikView 10/11, Qlik Sense 2.0.9, Oracle 11g, MS SQL Server 2008, XML, Flat files, MS Office.

Confidential

QlikView Developer

Responsibilities:

• Involved in various stages of Project including requirement gathering, analysis, design, scripting, development, testing, debugging, documentation and production support.
• Extracted the data from different data sources like SQL server, MS access, Flat files into the application.
• Developed efficient data models by Cleaning the data to remove the unnecessary fields/values, eliminating Circular references, Synthetic keys and ambiguous relationships based on the requirement.
• Extensively worked with Cross tables from spreadsheets to deal with the time based data in the application.
• Extensively involved in development of the Qlik applications using Set Analysis, Functions, Variables and Macro.
• Worked on Set Analysis using functions like min, count, sum, conditional functions, range, colors, images etc.
• Designed executive visualization using KPI Dashboard (Gauges, Text Objects, Charts etc) that helps management to make faster and better decisions.
• Worked on SQL datawarehose to develop reports and Dashboards.
• Implemented three layered architecture in the application which involves the Extraction of data from Data Warehousing and store as QVD’s, Transformation layer to build aggregate QVD’s and finally Dashboard.
• Used the TRACE keyword to review the performance of the data loaded into the application.
• Experience in creating and distributing the Reports using PDF distribution.
• Implemented the Reload and Distribution tasks based on various trigger mechanisms.
• Implemented Security to the application for different group of users using Section Access and provided support to enhance the application based on user requirements using (QMC).
• Deployed the documents of QlikView application on server using QlikView publisher.
• Effectively worked on the Functional and Performance testing of the QlikView application.

Environment:: QlikView 10.0, Oracle 10g, SQL Server 2005, MS SQL Developer, KML, MS Office.

Confidential

BI /ETL Developer

Responsibilities:

• Worked with data modelers in understanding logical and physical data models.
• Consolidate data from various departments into the data warehouse by identify the common data and solve the discrepancy on data values and created various data marts.
• Involved in the requirement definition and analysis in support of Data Warehouse and ODS efforts.
• Developed ETL mappings, transformations using Informatica Power Center 8.1.1/8.5.1
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Maintained source definitions, transformation rules and targets definitions using Informatica repository Manager.
• Experience with cloud environment (AWS, GCP,Azure)
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, Union, Stored Procedure and sequence generator.
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions.
• Scheduled the batches using UNIX.
• Used Informatica repository manager to backup and migrate metadata in development
• Automation of job processing, establish automatic email notification to the concerned persons.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment:: Informatica Power Center 9.5.1/8.6.1, Teradata 12, Oracle 9i, DB2, ERWIN 4.0, Business Objects, Sql Assistant, Maestro(TWS), Toad 7.3, UNIX Shell Scripts, Unix, Windows.

Confidential

QlikView Developer

Responsibilities:

• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Gathering the requirements to develop the project based on clients specifications.
• Actively participated in full life cycle of QlikView application implementation and was responsible for Design, Development, Delivery and Support.
• Extensively involved in 3-tier architecture like Extracting, Transforming.
• Loading the data from different sources like SQL server, Excel Files, Flat files, XML, JSON, Web pages.
• Extensively used the QlikView tool to handle the various data feeds from the different data sources and converting it into QVDs.
• Experience in Data Cleaning, Using Joins, Concatenating and Mappings between tables as a part of Transformation layers of ETL processing in QlikView.
• Designed and implemented the Incremental Load using QVDs.
• Actively involved in writing the ETL Scripts to resolve the Synthetic Keys and Circular References.
• Designed the Data Model and implemented Star/Snowflake Schema for QlikView better optimization.
• Developed the visualization Dashboard using KPIs, Gap Analysis chart, Objects, Charts (Drill down, Cyclic dimensions), Buttons etc.
• Extensively used Set Analysis, Functions and creating Variables in different objects based on the client requirements.
• Worked on Set Analysis using functions like min, count, sum, conditional functions, range, colors, images etc.
• Experience in using QlikView Functions (Date and Time, Keep, Join, Mapping, String, & Input fields etc).
• Worked on QlikView sheet objects like Charts (Straight table, Pivot table, Line, Combo charts etc), List Boxes, Multi Box, Input Fields, Table Box, Statistics Box etc.
• Scheduled the Publisher Tasks Daily/Weekly/Monthly on various Dashboards based on the Database updates.
• Experience in creating Security to the application and distributing the Reports using PDF distribution.
• Extensively done user support, resolved and enhanced the various issues as per different user needs.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Creative, quick learner and team player.

Environment:: QlikView 10.0, MS SQL Server 2005, SQL Developer, MS Office, Windows 7.