PROFESSIONAL SUMMARY:

• Certified in both Qlikview and Qlik Sense .
• Around 9 Years of real time experience in business intelligence lifecycle projects from requirement gathering, documentation, data analysis, modeling, development, testing, production, deployment and support.
• More than 7 Years of Qlikview Development Experience in Agile development environment from Qlikview version 9 to 12
• Expertise in creating the Qlikview dashboards .
• Expertise in Qlikview performance optimization .
• Expert in Qlik Sense Development and administration .
• Expertise in Advanced Set Analysis
• Expertise in implementing the Section Access .
• Implemented all levels of security at row level, field level, and sheet level.
• Expertise in Data Modelling .
• Expertise in Incremental Load .
• Extensive experience in the Multi - Tier Architecture with QVD layer, Data mart and Presentation layer.
• Expertise in ODBC and OLEDB data sources and building complex load scripts
• Strong knowledge of Dimensional Modelling technique and expert in handling the data modelling issues by using Link Table, Concatenation, Join and Automap.
• Strong SQL Queries and PL/SQL tuning experience.
• Experience in Qlikview Administration .
• Experience on Qlikview Publisher, Server and User security .
• Experience in error handling and debugging of Qlikview reports. Expert in handling production issues like report failures, missing counts in reports, resolving synthetic keys, Loops.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Working knowledge of Tableau and SAP Business Objects.
• Expert in Printing report distribution.
• Expert in Qlikview Extensions including Maps and built few extensions myself.
• Expert in implementing the best Practices in Qlik View.
• Implemented Qlikview Center of Excellence .

TECHNICAL SKILLS:

Tools & Technologies: Qlikview 12,11.0,12, QlikSense3.2,3.1,3.0,2.2,2.1, N-printing

Languages: Java Script, D3, .Net, SQL, T-SQL and PL/SQL

Database: Greenplum, SQL Server, Oracle 11g, Hadoop, Impala, Sybase, Big Data, SQL Server, Teradata, DB2, MS Access, HP Vertica

ETL Tools: Informatica

Operating systems: Windows 2008/2012 Server

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Sr. Qlik Developer

Responsibilities:

• Work with a cross-functional team of developers and business analysts to deliver on strategic data and analytics initiatives.
• Lead developer of the Qlikview and Qlik Sense environment and supporting the business decision process
• Work directly with business users to define and build Qlikview Applications.
• Worked with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Creating the Qlik Sense dashboards and charts and Qlik Sense performance optimization.
• Building the Qlik Extensions using Java script and D3.
• Handled big data in Qlik view and Qlik Sense.
• Building the Qlik Sense advanced Mashups and Themes.
• Building Set analysis.
• Performance tuning of SQL Queries.
• Creating the Qlikview dashboards and charts.
• Qlikview performance optimization.
• Data modelling, analysis, design, testing, development and implementation
• Fixing Complex issues using Advanced Set analysis.
• Advanced aggregation and SQL scripting.
• Qlikview Data Modelling.
• Qlik Sense Development.
• Generate QVD files created by ETL logic to feed QlikView applications
• Ability to optimize existing Qlikview reports to improve business productivity.
• Implementing the Qlikview dashboard security model using Section Access. Implemented all levels of security at row level, field level, and sheet level.
• Building the Self-service Model Creating dashboards by extracting data from database write and externalize the load scripts, store the data as QVD files and designing the UI based on business/user requirements.
• Integrating the version control like SVN and GIT for Qlikview and Qlik sense.
• Building the Self-service Model Creating dashboards by extracting data from database write and externalize the load scripts, store the data as QVD files and designing the UI based on business/user requirements.

Environment: QlikView 12.1, 11.2, Qlik sense 3.x,3.1x and 3.2, HP Vertica, HP Agile Manager, Qlik Web Connectors, MS Access, MySQL 5.3, Qlik SAP Connector, MS SQL Server, Horton works HIVE.

Confidential, San Diego, CA

Senior Qlik Consultant

Responsibilities:

• Leading the Qlik view and Qlik Sense development environment.
• Creating the Qlikview and Qlik Sense dashboards and charts.
• Building the Qlik view and Qlik Sense Extensions using Java script and D3.
• Handled big data in Qlik Sense.
• Qlikview data modelling by building the Star schema and resolving loops/synthetic keys.
• Creating new extensions using the Qlikview API and using them effectively in dashboards.
• Building the user-friendly interface by modifying the QVPP files in the extension.
• So that users can use the extensions effectively.
• Implemented the Various scenarios of section access.
• Experience in Qlikview administration.
• Worked independently in building the Self-service template for users. So that it can reload the data sources per user requirement without any need of load script.
• Creating the Utilities using QMS API for bulk insert of Users and extracting the Meta information from Qlikview server.
• Worked on implementing the Qlikview deployment frame work (QVDF).
• Installing, configuring and maintaining the Qlikview infrastructure.
• Training the end users on the Qlikview Tool for using it effectively and provide Customer support.
• Installing and configuring complete Qlikview server setup, IIS web server.
• Experience in Qlikview Data Modelling. Resolving the Synthetic keys, Loops.
• Experience in using all types of data loads and functions like Automap.
• Experience in debugging the Qlikview server issues through server logs, Fiddler logs.
• Experience with Qlikview management console.
• Designed and developed user manuals, product documentation using technical skills.
• Direct interaction with business analysts and managers on daily basis.
• Experience in error handling and debugging of Qlik Sense and Qlik view reports. Expert in handling production issues like report failures, missing counts in reports, resolving synthetic keys, Loops.
• Studied the existing data model and incorporated the new fields including static and dynamic flag fields to meet with the business requirements
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Qlik BI suite.
• Working with User for requirements and part of the team developing the software.
• Publish Qlik workbooks to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Created Qlik scorecards, dashboards, Heat maps using show me functionality.
• Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Developed and created classes with Dimension, Detail & Measure objects and developed Custom hierarchies to support drill down reports
• Troubleshoot issues with existing reports in the production environment.
• Created Views, Stored Procedures and validated data for the Performance.
• Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, stored procedures, business views.
• Provided daily production support and administration of portal operations, such as problem resolution.
• Worked closely with Data Modelers in designing various data warehouse schema techniques Worked on the data provider that forms the basis of the ad-hoc analysis.
• Worked on bulk volume of data sets and different data sources like .csv files, oracle tables, Excel files, images, etc.

Environment: Qlik view, Qlik Sense, Business Objects, SVN, Curran 5.2, Oracle 10g/11g, Subversions, MS Access, Ms SQL Server, SAP BW

Confidential, Atlanta, GA

Qlikview Consultant

Responsibilities:

• Developed highly customized QlikView, Qlik Sense, dashboard applications.
• Designed and developed a wide variety of charts and associated sheet objects to satisfy complex business requirements.
• Designed Graphical User Interface with Qlikview Extension objects according to requirement.
• Qlikview Data Modelling.
• Qlikview and Qlik Sense Design, Development and Administration.
• SSRS to QlikView report development.
• Created the report datasets in SSIS and OBIEE.
• Created a navigational system that utilized QV hierarchy that used weights to identify values.
• Worked on enhancements and Performance tuning of existing Apps.
• Implemented Security & involved in Deployment of QlikView Applications.
• Back traced data to make sure it works cohesively as well as accurately by looking for discrepancies such as duplicates, rescinded information etc...
• Was given the task to define major KPI so analysed, brainstormed the needs of the company and created a trigger system that alerted higher ups in problems with any unit of measure they are measuring or would fall under their jurisdiction to know the status of.
• Wrote Complex set analysis statements.
• Used SQL Server Management Studio, TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Code review as well as fine tuning of applications as well as fixing data model.
• Scheduled tasks in server and Troubleshoot application in access point as well provided maintenance.
• Dealt directly with CEO, CFO as well as all managers on day to day basis to create an effective system and that tailored to each person moreover primarily focused on CEO needs.
• Coordinated with offshore team in India on daily basis.
• Educated different user groups and peers with QlikView functionality.

Confidential

Qlikview Consultant

Responsibilities:

• Acted as QlikView Service Centre Lead for Confidential Annual Maintenance system.
• Involved in Requirement gathering & designing QlikView applications.
• Designed and Build ‘Risk Analytics Enterprise Dashboard’ and worked with teams very closely in Design/Build/Test/UAT/Deploy/Post Production Phases
• Created QlikView scripts to extract the data from Teradata, built QVDs, data model and dashboards
• Developed dashboards using QlikView sheet objects using list boxes, multi boxes, charts, drill downs, cyclic groups, sliders (what-if-analysis) etc.
• Developed Macros, Set Analysis in provide custom functionality in QlikView Applications.
• Implemented NT Based security based on business requirements
• Involved in the Performance Tuning of the QlikView Risk Dashboards for Various Businesses with in the Confidential AMS.
• Expert in Scheduling the QlikView Dashboards and Load files
• Communicating with the Qlik Tech Team, India along with TCS Technology Excellence Group for latest features, versions/migrations
• Experienced in Financial Services, Commercial domains and Sales Domains, Project Planning & Scheduling
• Sound Knowledge in Dimensional Modelling Concepts for DWH and in ETL/Database Optimization.

Environment: QlikView 9, 10, Teradata, Windows 2003 Server 6.0 and IIS 6.0

Confidential

SAP BO Consultant

Responsibilities:

• Designed, Coded, Tested, Implemented the Stored Procedures to support the System.
• Fixed bugs in the existing in-house developed Software which is used to upload the reports for the end users to view the reports.
• Designed, Coded, Tested, Implemented Stored Procedures to get data for the reports.
• Designed the reports using Crystal reports And SSRS to create reports for the end users.
• Created ad-hoc reports, drill down, and drill through reports using Crystal Reports and SSRS.
• Scheduled meetings with the end users and business owners and gathered requirements for the system.
• Developed triggers on tables to support the system.
• Created and configured SQL mail to send mail as events occur.