Rajitha Sr.Qlikview Developer

678-***-****

acuios@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 7+ Years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing /Decision Support Systems and Business Intelligence.

More than 5+Years of Experience in working with QlikView components such as QlikView Desktop, QlikView Enterprise Management Console(QEMC), QlikView Publisher and QlikView Web Server.

Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Qlikview.

Experience in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.

Team player with good interpersonal and communication skills and the ability to work in a team environment.

Extensively involved in Demos, Presentations, Meetings and Interaction with Senior Management.

Developed applications in the desktop as well as in the QlikSense Hub and shared the apps with the team through Qliksense Cloud.

Exposure to client interaction, user-requirement analysis and User support.

Experienced in working with many complex SQL queries with Joins, Date functions, Inline functions, and Sub-queries to generate reports.

Good knowledge in developing User Interfaces and QlikView Dashboards using Chart-Box( Drill Down, Drill up & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars and Data Islands.

Strong Experience in working with Charts( Table Box, Pivot Tables, Straight Tables, Pie-Charts, Gauge-Charts, Trellis)

Wrote complex expressions using Set Analysis.

Expertise in creating interactive dashboard Reports and Scorecards to view personalized reports based on user requirements.

Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, calculation, caching, metadata, security, and intelligent request generation services.

Good knowledge of Data warehouse concepts and principles

Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.

Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.

Experienced with Multiple Databases like Oracle, SQL Server and Teradata & DB2.

Managed Qlikview Reporting environment which includes Qlikview Server/Publisher and Desktop.

Exposure to client interaction, user-requirement analysis and User support.

Installed, Configured and deployed the application on QlikView server and Imported data from different sources like SQL Server, QVDs, Teradata, Oracle, and flat files using OLE DB/ODBC.

Good experience with writing SQL queries for data validation.

Experienced in Requirements Gathering, Data modeling and Qlikview Application development.

Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.

TECHNICAL EXPERTISE:

BI-Reporting Tools: QLIKVIEW (11, 10, 9.0), OBIEE, Qliksense

Databases: SQL server 2005/08/12, Oracle 11g/10g/9i/8i, MS-Access, Teradata and SAP BW

ETL Tools: Informatica Power Center 8.x/7.x

Languages: SQL, PL/SQL

Web Technologies HTML,XML

Tools: SQL Developer, SQL*Plus, TOAD, Iseries Navigator, Teradata SQL

Operating Systems: Windows XP/2003/2000/NT

PROJECT EXPERIENCE:

Client: CarePlus Health Plans Inc., Humana, Tampa, FL April 2015 – Till Date

Role: Sr. Qlikview Developer

Responsibilities:

Extensively worked to confirm and clarify requirements and business logic.

Analyzed the reporting requirements with the business users and came up with the technical specifications.

Designed, developed, implemented and tuned multiple QlikView applications for the HEDIS, Claims, HSO, QII and Finance qlikview applications.

Mainly designed and developed Qlikview software applications and complex server-based Qlikview dashboards from scratch to support reporting and Business Intelligence initiatives.

Testing dashboards and data validation.

Used advanced set analysis, advanced aggregation functions and advanced charts for applications.

Did end to end Unit Testing when migrating the applications.

Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher

Working with the management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business.

Maintained user guides and documentation for QlikView applications

Analyze customer requirements and develop proposals of technical solutions as needed.

Developed SQL s, database objects, procedures, functions and packages.

Strong understanding in creating Dashboards, scoreboards for the required KPI’s in QlikView.

Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.

Designed an applications for to support the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.

Setting access permissions and assigning CALs based on users.

Schedule QVW reloads on server and troubleshoot errors and failures.

Wrote SQL Scripts, procedures and views which are required for qlikview projects.

Used Google maps for the applications to know which branches are performing to the expectations around the globe with data visualization.

Worked on dashboards related to Sales Analysis, Production over time and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.

Involved in up-gradation of QlikView environment from QV 10.0, QV 11.0 versions.

Working with the management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business.

Provided administrative services.

Defined best practices for QlikView development, deployment and create reusable templates.

Analyze customer requirements and develop proposals of technical solutions as needed

There were 6 Dashboards and 20 million records with incremental load and daily refresh.

Managed security for all QlikView applications.

Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.

Environment: QlikView 11 (Desktop, Server/Publisher), Oracle, SQL Server, Teradata, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Cognos, Informatica, QlikView Enterprise Server.

Client: Augusta Sports Wear, Augusta, GA Jun 2013 – Mar 2015

Role: Qlikview Developer

Responsibilities:

Developed Qlikview applications by analyzing business data as per client requirements.

Involved in creating logical and physical model of the database using Erwin.

Mainly designed and developed Qlikview complex dashboards from scratch to support reporting and Business Intelligence initiatives.

Working with the management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business

Created schema objects like tables, views, indexes. Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Developed Extract Scripts for generating the QVDs & Data models for the front end presentations using Binary Load.

Evaluation of different BI Tools (As a part of COE team) viz. Qliksense, nPrinting etc.

Involved in up-gradation of QlikView environment from QV 10.0, QV 11.0 versions and Qliksense.

Written new stored procedures, functions and T-SQL queries and modifying existing ones as per new business requirements.

Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.

Used complex set Analysis, designed interactive charts like bubble, line, bar & Trellis etc.

Scheduled QVW reloads on Server/Publisher by creating tasks in the Source Documents. Used Loop and reduce concept for creating multiple apps based on the field.

Created ops monitor apps for monitoring the refresh of the apps for checking if there are any failures. And used to troubleshoot the failures.

Configured and deployed the applications in the access point using QlikView Server/Publisher.

Installed, configured and deployed the application on QlikView server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.

Performed technical leadership in dashboard application design, visualization, automation, e-mail alert and notification, data modeling and the integration with the Portal platform

Participated in design.

Successfully passed through the QA Environment and implemented on Production

Environment: QlikView 9.0/10, SQL Server 2005, Oracle 10g, Access, Windows2003 Server, SQL Loader, DW appliances, QlikView Server and Publisher, QlikView Developer.

Client: Visa Inc, Foster City, CA Jan 2012-May 2013

Role: QlikView Developer

Responsibilities:

Created triggers for the document level and sheet level to select the default selections when navigating between different tabs.

Monitored the work done by offshore team

Used incremental loading scripts for the huge volumes of data where the refresh is done daily.

Showed the statistics in bar charts and pie charts as per the client needs.

Worked on production tickets for the applications which are in production.

Testing dashboards and data validation.

Trained offshore team members and users on best practices and general “how to” procedures.

Maintained user guides and documentation for QlikView applications

Used complex set Analysis, designed interactive charts like bubble, line, bar & Trellis etc.

Involved in Maintenance and support for the project and end users.

Extensively involved in Database Performance Tuning.

Gathered, Analyzed, and transformed business requirements of the Client into logical and physical BI solutions.

Expertise in Creating Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.

Expertise in Developing User Objects (filters, prompts, metrics, Custom Groups, Consolidations) to develop Documents and reports.

Exposure to client interaction, user-requirement analysis and User support.

Participated in design and code reviews, QA/UAT testing, enhancement design and development, and deployment to support day-to-day business operations

Involved in performance tuning of dashboards to limit the response time and enhance the functionality.

Environment: QlikView 8.5(Desktop, Server/Publisher, Access Point), Report Services, Dashboards, Teradata, MS-Excel, Windows XP/7, Microsoft SQL Server, SSIS, SSRS, Oracle Database.

Client: Baronites, India May 2009-Nov 2011

Role: SQL Developer

Responsibilities:

Modified report wherever needed as per the suggestions given by business analyst and Analyzed the existing Actuate and SQR reports.

Created Cross-Tab, Sub-Report using RDL. Promoted RDLs to Reporting Service Server.

Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

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.

Involved in Performance tuning and Query Optimization.

Converted the Actuate and SQR reports to SSRS without any change in the output of the report.

Enhanced the existing reporting functionality by using the advanced features of SSRS.

Assessed the pros and cons of migration and conveyed the same to the Business Analyst.

Used SQL Developer to Load / Extract data into and from Excel files.

Written stored procedures for those reports which use multiple data sources.

Conducted impact analysis and designed structures to enhance performance.

Created different types of reports such as parameterized reports, matrix report, charts etc.,

Tested (manual) the reports after migration to make sure that the SSRS reports serve the exact business purpose as that of existing Actuate reports.

Extensively used Share Point.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL Analysis Services 2008,Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Contact this candidate