SUMMARY

• Over 7 years of IT experience in all facets of Business intelligence applications with a strong background in Database development, Data Warehousing/ Decision support systems and Business Intelligence (BI).
• Professional experience in the field of Business intelligence and Analysis with QlikView 11.2/10.0/9.0 and Qlik Sense 1.0/2.0 as BI tool.
• Strong experience in Qlik product family such as QlikView Desktop Client, QlikView Management Console, QlikView Server, Qlik Sense Hub and Qlik Sense Management Console etc.
• Expertise in using complex multiple data sources such as Oracle, SQL, Flat Files, Excel and Access for designing and modeling of QlikView.
• Knowledge of QlikView Publisher and NPrinting.
• Experience in using ETL Tasks such as data cleansing, joins, aggregation tables using QlikView and Qlik Sense.
• Designing Data Mart and Data Warehouse and Implementation of QlikView and Qlik Sense for BI Reporting Solutions.
• Extensive knowledge with Dimensional data modeling, star schema, snowflake schema, Fact and Dimensional tables.
• Ability to handle complex calculations and point in time reporting using Set Analysis (Set Expressions).
• Strong experience in UI Design by using different QlikView sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change.
• Experience in working with extension objects.
• Performance tuning QlikView Applications for faster data reloads & efficient response times.
• Experience in Creating and scheduling jobs using Qlik View Publisher.
• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long - term, flexibility, and standardization
• Implemented data and object level Security in Qlik View applications with section access method.
• Was actively involved in server migration and the fresh QlikView installation process
• Created Triggers and Distributed QV applications to production using QEMC.
• Excellent working knowledge in BI Analytics, Data Warehousing Models, RDBMS concepts, SQL, PL/SQL.
• Strong data analytical and debugging skills to ensure accuracy and data integrity.
• Ability to adapt quickly to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView 12.0,11.2,10, 9.0, QlikSense

Languages: SQL, PL/SQL, C, Java

Database Technologies: SAP BW, Oracle 12c/11g/10g/9i, SQL Server 2008/2005, MS Access 2005, DB2

Operating Systems: Windows, UNIX

Scripting Languages: HTML, XML

IDE: Visual Studio, Eclipse

Domains: Healthcare, Sales, Pharmaceutical, Services, Financial

Others: MS Access 2013, MS-Excel 2013, MS Visio 2010

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

QlikSense/ QlikView Developer

Responsibilities:

• Actively Involved in Requirement Gathering from Business Users and passed on the requirements to the team.
• Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.
• Involved in designing the Data model and Construction of the Data model and implemented the Star schema for QV better optimization.
• Created QVDs by importing data from the database tables using QlikView load script.
• Load Data into Qlik Sense application from different QVDs files, Excel, Oracle, Inline & txt files.
• Developed the dashboard using chart objects such as Bar Chart, Line Chart, Pie Chart, Buttons, Straight table and Pivot table.
• Created Variables and Triggers to enhance the functionality of Qlik Sense.
• Implemented Set analysis and Aggregate functions.
• Wrote queries against Teradata SQL Assistant to fetch data into QlikView and Qlik Sense.
• Wrote complex SQL Queries using joins, sub queries and correlated sub queries.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented the Navigation among the Tabs and Sub-tabs to show only corresponding charts.
• Implemented document chaining to drive through the channel and direct dash boards.
• Created ETL scripts for optimized reload of data.
• Provided first line of support to clients.
• Created tasks and deployed applications in Qlik Sense Hub using Qlik Sense Enterprise Management Console.
• Used Macros, Filters, Variables and Mapping Functions to achieve user requirements.
• Implemented core business model by eliminating ambiguous, Circular joins using Qlik Sense best practices. Also, involved in ETL testing for validating the outcome.
• Improved the overall performance of the application and redesigned data model applying Qlik Sense performance tuning techniques.
• Developed Proof of Concept for Customers.
• Complete responsibility of deliverables as well as the production support.

Environment: Windows 2000 Server, Qlik Sense 1.0, Teradata, SQL Server 2008, MS Office.

Confidential, Jersey City, NJ

QlikView Developer/Administrator

Responsibilities:

• Deliver high quality services utilizing Qlikview enterprise-wide Business Intelligence tools.
• Perform analysis of reporting requirements and implement customization based on specific client requirements.
• Creating variables through to assign the colors to the charts.
• Provide standard and customized Business Intelligence technical training, particularly certain area client report writing.
• Developed Qlikview Dashboards using various Qlikview objects like Charts, List Box, multi box, Table Box, Button, text box and containers as per business needs.
• Stored the tables as QVDs and used Scripts to generate appropriate fields that help in modeling the data accordingly the requirements.
• Generate new QVD files created by ETL logic to feed QlikView applications.
• Receive business requirements from client via a Business Analyst and build applications, functions, and processes using programming skills/software.
• Implemented Section Access in QlikView dashboards.
• Created complex reports using Business Objects functionality like Slice and Dice, Drill Down, Drill Up and Ranking were used in reports.
• Conduct testing, including unit, business analysis, and client testing, (via a pilot site) for accuracy.
• Performance tuning of dashboards was carried out to limit the response time to well under 5 seconds on calculation and defining server sizing for optimal performance of QlikView dashboards.
• Maintain tested applications for quality assurance and production support.
• Developed Qlikview Dashboards using various Qlikview objects like Charts, List Box, multi box, Table Box, Button, text box and containers as per business needs.
• Professionally communicate with clients on assigned projects as needed.

Environment: QlikView 12.0, Windows 2008 server, HTML, Congo's, SQL Developer, SQL, MS Project, MS Office Suite (Word, Excel, PowerPoint).

Confidential, Richardson, TX

QlikView Developer

Responsibilities:

• Gathered the requirements from Business Users and passed on the requirements to the team.
• Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule ad hoc reports by leveraging the basic components of QlikView.
• Developed KPI’s and set analysis applications.
• Developed QlikView data warehouse enterprise framework.
• Developed a QlikView Adventure Works Enterprise Template.
• Developed QlikView documents and frameworks for Financial, ERP, and CMMS, point-of-sale and medical industries.
• Used QlikView components such as List Box, Slider, Buttons, Charts and Bookmarks to create Dashboards.
• Generated new QVD files created by ETL logic to feedQlikViewapplications.
• Consulted with project/program stakeholders to understand business problems and translates them into functional and non-functional requirements
• Performed ad hoc duties in accordance to business needs.
• Improved the overall performance of the application and redesigned data model applyingQlikViewperformance tuning techniques.
• Dashboards served to track inventory and sales as well as to monitor various KPIs.

Environment: Windows 2000 Server, QlikView 11.20, Oracle 10g, SQL Server 2005, MS Office.

Confidential

SQL PL/SQL Developer

Responsibilities:

• Modified report wherever needed as per the suggestions given by business analyst and Analyzed the existing Actuate and SQR reports.
• Migrated actuate code of data extract to PL/SQL equivalent and Created PL/SQL functions, packages, procedures and joins.
• Coordinated with the client to make sure that there is not much change during the migration of the reports.
• Extensively usedSQLto create Insert programs for loading data.
• Modified existing procedures according to new enhancements.
• Performed data partitioning.
• Assessed the pros and cons of migration and conveyed the same to the Business Analyst.
• Developed complex Stored Procedures, Triggers, and Functions.
• Written stored procedures for those reports, which use multiple data sources.
• Worked on Joins for many tables in SQL (Self joins, Left joins, Right joins…. etc).

Environment: Oracle 10g, TOAD, SQL Developer, UNIX, Windows 7.