SUMMARY:

• 10 + years of experience in architecture, development, and deployment of information delivery systems with extensive focus on DataWarehouse/Business Intelligence using QlikView 11.x/10.x/9.x, Qlik Sense, Business Objects, MS BI etc.
• Domain experience includes Publishing, Pharmaceutical, Healthcare, Manufacturing, Technology and Banking.
• Hands on experience in implementing the new features of Qlik Sense like Pivot table, KPI Object, PDF Printing etc.
• 6+ years of 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 the 3 - tier architecture (Data-Extraction, Data-Modeling and Application Development) as recommended in QlikView best 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 utilizing Agile Methodology.
• Good experience in performing detailed data analysis/data profiling (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples).
• Ensured a focus on data quality by developing data standards such as a common business vocabulary, naming conventions, data standards and transformation rules.
• Strong Knowledge in designing and developing Data marts, Data Warehouse using Multi-dimensional models such as Snow Flake and Star Schema .
• Expertise in designing efficient Data-Models from multiple data sources and QlikView scripting.
• Proficient in design and development of various Dashboards using chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box, Containers and Calendar & Date Island
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Experience embedding QlikView applications into host applications using QlikView OCX Control.
• Implemented data level security using Section access that hides selected areas of the dashboard & filters data dynamically depending upon user privileges.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects to accommodate KPI’s into Dashboards.
• Expertise in customizing Dashboards/Reports using Java, JavaScript, jQuery APIs, Web Services and third party plugins.
• Good at performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
• Strong Database development experience in writing functions, packages, procedures, triggers and views in PL/SQL.
• Strong Database experience in Oracle, DB2, MS Access, Teradata, SQL Server, Netezza.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Strong Communication, Organizational and Interpersonal Competencies along with Detail-oriented and problem solving skills in the technology arena.
• Developed different apps for Qlikmap (Points and Polygon), Extension objects to let the user to explore best features in Qlik Sense and to compare with QlikView.

TECHNICAL SKILLS:

Analytics/ Reporting: QlikView 9/10/11.0/11.2, Qlik Sense, Business Objects, SSRS

DBMS/Tools: Oracle, SQL Server, DB2, Teradata, Netezaa, MS Access; Toad, DataStudio, RapidSQL

ETL Tools: SSIS, DataStage, Informatica

Languages: SQL, PL/SQL, HTML, XML, Java Script

Change Management: JIRA, SVN, Autosys, SharePoint

Operating systems: Windows7/XP/Vista, Windows 2003/2008 Server, Linux, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Montvale, NJ

Lead Qlikview/Qlik Sense Consultant

Responsibilities:

• Work directly with business users to define and prototype Qlikview/Qlik Sense Applications.
• Worked with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Leading, developing the Qlik environment and supporting the business decision process.
• Installed ad configured completeQlikview/Qlik Sense server setup, IIS web server in multi clustered environment.
• Expertise in the Qlikview/Qlik Sense architecture and sizing.
• Experienced in integratingqlik with Greenplum and Sales force.
• Building the Qlikview/Qlik sense dashboards and data modeling.
• Building expressions using set analysis and extension development
• Qlikview/Qlik Senseperformance optimization.
• Integrated sales force with Qlik Sense.
• Experience with Qlikview/Qlik Sense Extensions and workbench
• Data modeling, analysis, design, testing, development and implementation
• Automations using QMS API and fixing Complex issues using Set analysis.
• SQL scripting along with SSIS and SSRS
• Generate QVD files created by ETL logic to feed Qlik applications
• Ability to optimize existing Qlikview reports to improve business productivity.
• Implementing the Qlikview and Qlik sense 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. 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 also to analyze their sales and predict the requirements for the future.
• Implemented Security & involved in Deployment of QlikView/Qlik sense Applications.
• Importing data from Oracle Database and using SQL scripts to join the data tables and pull the required data.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.

Skillset: Qlikview12,11, Qlik Sense 3.0,2.0, Qlik server and Publisher, SSRS, SQL server report builder 10.50, SQL server 2008, JDE 9, Oracle 11g, OBIEE, Greenplum, Tableau, MS EXCEL, N-Printing, Windows server 2008 R2, 2010, Salesforce.

Confidential, NYC, NY

Sr. Qlikview/Qliksense Consultant

Responsibilities:

• Work with a cross-functional team of developers and business analysts to deliver on strategic data and analytics initiatives.
• Consolidated data into QlikView from various data sources (SQL Database, Oracle Database Text files and Excel files).
• Worked on Qlik Sense App development, templates, story generation, data modeling and Qlik Sense app performance optimization.
• Creating the Qlikview dashboards and charts.
• Qlikview performance optimization.
• Data modeling, analysis, design, testing, development and implementation
• Fixing Complex issues using Set analysis.
• SQL scripting.
• Configured different Qlik Sense roles and attributes based access control and designed the Qlik Sense Governance and development cycle.
• Experienced in Qlik Sense data modeling, master items and maps
• Expertise in the Qlik sense architecture and sizing.
• Expert in Qlik sense extensions and embedding in websites
• Leading, developing the Qlikview environment and supporting the business decision process.
• Qlikview performance optimization.
• Data modeling, analysis, design, testing, development and implementation
• Fixing Complex issues using Set analysis.
• Qlikview and 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.
• 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 Modeling.
• 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.

Skill Set: QlikView Suite (11/10/9/8.5, Server, Publisher), Qlik Sense, Oracle (11g/10/9i), Sybase, DB2, Java/J2EE, VB Scripting.

Confidential, Tampa, FL

Sr. Qlikview Developer

Responsibilities:

• 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.
• Use of Set analysis and aggregation functions for sheet objects.
• Created macros in VBScript to meet the business requirements.
• Qlikview dashboards optimization.
• Qlikview data modeling 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 QVP files in the extension.
• So that users can use the extensions effectively.
• Implemented the Various scenarios of section access.
• Qlikview administration.
• Involved in Performance Tuning using Incremental load logic which handles Insert, Update, Delete of source data and tuning underlying data in QlikView Applications.
• Experience in usingadvanced aggregation functions.
• Experience in using alternative states in Qlikview.
• Experience in dimensional modeling using star and snow flake schemas.
• Very strong knowledge on data warehouse and data base concepts.
• Knowledge in using the Loop and reduce options at QlikView Publisher.
• Knowledge over most of the relational DBs like Oracle, Sybase, DB2, etc and also participated in writing complex Sql scripts.
• Building the Informatica transformations, mappings.
• Working knowledge in SAP Business Objects (3.1, 4.0) and CMC.

Skill Set:QlikView Suite (10/9/8.5, Server, Publisher),SAP Business Objects (4/3.1), Sybase, Oracle (10/9i), Informatica Java/J2EE, VB Scripting

Confidential, Glen Allen, VA

Qlikview Developer

Responsibilities:

• Interact with senior managers for gathering requirements and presenting them with Health insurance analytical information.
• Developed dashboards for data analysis with strong programming skills.
• Creating dashboards by extracting data from database write and externalized the load scripts, store the data as QVD files.
• Use of Set analysis and aggregation functions for sheet objects.
• Qlikview data modeling by building the Star schema and resolving loops/synthetic keys.
• Developing advanced and complex PL/SQL procedures, Packages, Functions, Triggers, views, Oracle Collection.
• Implemented the Various scenarios of section access.
• UNIX Shell scripting
• SAP BO web reports development and Administration.

Skill Set: QlikView Suite (10/9/8.5, Server, Publisher), Oracle (10/9i), SAP Business Objects, Java/J2EE, VB Scripting

Confidential, San Jose CA

BI Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using TSQL in SQL Server 2005.
• Exposure to SSRS, SSIS, OBIEE and Cognos.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production.
• Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access and Created new security accounts.
• Performed Backup and restore of databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics information for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Skill Set: SQL Server 2005, T-SQL, OBIEE, SSIS, SSRS, DTS Designer, MS-Office, MS-Excel, VSS.