SUMMARY:

• 7+ years of overall IT experience in the software field in Business Intelligence Tools and the Databases.
• 4+years of experience in Qlikview Desktop, Qlikview server & publisher in aspects of development, deployment and administration.
• Involved in collecting the business requirements, Building the Data Model, Creating reports as per clients requirements and scheduling the reports.
• Ability to offer end - to-end solution starting from requirement gathering, design, development & deployment of Business Intelligence applications. Experienced with Agile Development Methodology in providing quick analysis and visualizations for business users.
• Connect Qlikview to multiple data sources including Oracle MS SQL Server, SQL and MS Excel.
• Worked to provide level of security using Section Access & Publisher.
• Involved in Optimizing existing Qlikview dashboards with a focus on usability, performance, long-term, flexibility, and standardization.
• Excellent client interaction & Good at analysing and understanding the customer preferences.
• Data Integration (ETL, Data warehousing, Data marts).
• Experience in working with Qlikview extensions such as Quick Map, Word Cloud and Word Map.
• Experience using an ETL tool Qlikview to handle the various data feeds from the different data sources using Qlikview load scripts into QVDs.
• Experience running complex and high volume ETL processes.
• Strong Skills in Qlikview 11, 10, 9.0 in designing and creating dashboards and reports with various graphs and analysis.
• Expertise in data modelling using Star and Snowflake Schema Design, Relational and Dimensional Data Modelling, Fact and Dimensional tables, Physical and logical data modelling.
• Experience in database design & development, database programming, data modeling, business process analysis, and application development.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.
• Expertise in deploying developed Qlikview applications to Qlikview Environment.
• Working knowledge in Load Balancing and Clustering.
• Performed Design and Code Walkthroughs.
• Expertise in tuning the Data Load and Qlikview applications.
• Expertise in optimizing, Debugging and testing SQL queries.
• Implemented Security & Involved in Deployment of QlikView Applications. And Created QVD’s & updated in timely basis as database updates.
• Expertise in reviewing and troubleshooting day-to-day dashboard support and maintenance issues.

TECHNICAL SKILLS:

BI Tools: Qlikview 10 x to 11 x.

Administrative Tool: Qlikview Server & Publisher.

Databases: Oracle 11g, SQL server2012.

Operating System: Windows-7/8/2000/XP.

Languages: SQL, C, HTML.

ETL Tools: SQL Server Integration Services (SSIS), SSRS, SSAS.

PROFESSIONAL EXPERIENCE:

Confidential, ECRI, PA

Qlikview Developer

Responsibilities:

• Work directly with business users to define and prototype Qlikview Applications.
• Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Design, Develop, Test, debug and implement Qlikview solutions based upon specified Requirements.
• Assigned to create dashboards by extracting data from multiple databases, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Create PDF push reports using Qlikview report editor.
• Using Qlikview Functions (Date and Time, Keep, Join, Mapping, and String and input Fields etc.)
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Implemented Star & snowflake schema. Writing SQL Scripts to load the relevant Data in Qlikview Applications.
• Hands on retrieving of external data to Qlikview Dashboard in terms of QVDs by making Connection through ODBC and OLEDB.
• Performance tuning of dashboards was carried out to limit the response time.
• Successfully passed through the QA Environment and implemented on Production and post-production support.
• Designed and developed ledger and profit designs.
• Customized different dashboards.
• Developed different dashboard pages which includes payables and profitability.
• Implemented the SET analysis for the different aggregation functions.
• Handled the different troubleshoot errors.

Environment: Qlikview 11.X Series, Oracle, SQL Server, Excel, and CSV files, QlikView Enterprise Server, QlikView Server and Publisher.

Qlikview Developer

Responsibilities:

• Involved in creating the different dashboards and end to end implementation using the space utilization dashboard.
• Extracted the data from the various databases and stored into the extract QVDS.
• Loaded the data from QVD into QVW in the data model according to the project requirement.
• Used the functions such as VLOOKUP to create different excel sheets for mapping in the databases and then later used it in the different databases.
• Involved in improving the performance of the different dashboards.
• Designed the different objects such as pie charts, Line charts, pivot table, straight table, Text objects, slider, Bookmark objects and search objects.
• Involved in designing the Templates for the Dashboards.
• Used the SET analysis for different charts.
• Sound understanding of the relational and dimensional databases.
• Designed dashboards which relates to the KPI monitoring using the Qlikview Tool.
• Managing the data collection and maintenance.
• Usage of the link tables to avoid the synthetic keys.
• Using different types of joins to link and associate the tables.
• Good at the concept of the associative modelling.
• Involved in dashboard development analysis, design and implementation.
• Retrieving the external data to the Qlikview software.
• Strong data analytical and debugging skills to ensure accuracy and data integrity.

Environment: Oracle 10g, Qlikview 11, Microsoft SQL server 2012, Windows Server 2008.

Qlikview Developer

Responsibilities:

• Worked on developing the star schema model in the Qlikview.
• Involved in designing the performance dashboard.
• Developed innovative Qlikview applications that enable business discovery and are technically sound in terms of performance and coding standards.
• Provided technical expertise, innovation and leadership in QlikView development to the internal team and external vendors.
• Involved in the creation of the sales and financial dashboards.
• Worked on loading the complex calculations into the scripts and the resident loads when necessary.
• Worked on using the Three Tier Architecture approach in the designing of the dashboards.
• Involved in resolving the client issues by tuning different techniques.
• Utilized different debugging techniques in Qlikview.
• Worked on implementation of the code changes in the Qlikview.
• Performed different analysis on the reports to make it clear to the clients and customers.

Environment: Qlikview 11.0, SQL Server 2005/2008, HTML, Excel.

Qlikview consultant

Responsibilities:

• Involved in collecting the business requirements, Building the Data Model, Creating reports as per clients requirements and scheduling the reports.
• Developed Qlikview Objects and extensions.
• Backup and recovered databases both operational and developmental.
• Good support to the client at all the times during the week.
• Worked on the schemas of various data models.
• Used different Types of joins to join data from different tables.
• Designed and developed extensive reports using combination of chart and tables.
• Used extensive set analysis.
• Involved in Dashboards development & Unit testing, requirement Analysis & Design.

Environment: QlikView, SQL, Excel, Oracle & Windows

SQL Developer

Responsibilities:

• Involved in the Creation of new database objects like Procedures, Functions, and Views using T-SQL in SQL Server 2005.
• Involved in the Promotion of the database objects from testing stage to the developing stage in the production.
• Involved in the modification of the database structures as directed by developers for different environments.
• Worked on Managing the user access for the customers.
• Involved in the Backup and restoring of databases from various servers.
• Worked on the various ETL processes which are used for the extraction of the data from the data source.
• 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 purposes.

Environment: SQL Server 2005, MS-Office, MS-Excel.