SUMMARY

• An enthusiast with over 7+ years of IT experience in Business Intelligence Tools in development, test and support phases of various reports.
• Experienced QlikView developer - the pioneered in-memory Dash boarding tool.
• Good knowledge and understanding of QlikView server, QlikView publisher and QlikView Enterprise version.
• Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.
• Hands on retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI’s.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization using QlikView.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlikview.
• Implemented Triggers using Macros to provide custom functionality in Dashboard Applications.
• Designed and implemented proof of concepts for clients in the Healthcare, Agriculture, Automobile, Pharmaceutical, Financial and Manufacturing sectors.
• Knowledge of industry best practices in both business management and technology domains.
• Adept at solving complex problems through a systematic approach that uses innovation and partnering combined with project management principles to maximize return on investment.
• Excellent analytical and teamwork skills. Team player with excellent verbal, written and interpersonal skills and capable of independent work with minimal supervision
• Outstanding problem solving, strategic thinking and data analysis skills, strong focus on teamwork and achieving team goals, result oriented, fast learner and excellent communication skills.

TECHNICAL SKILLS

Dash boarding/Analytics: QlikView, Informatics, MS SharePoint, Cognos

Languages: SQL, PL/SQL, C++, VB

Database technologies: Oracle9i/10g/11g, SQL Server, Teradata, MySQL

Platforms: Windows Server 2008, Linux (Ubuntu).

Others: MS Access, MS-Excel, MS InfoPath, Visio

Operating Systems: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, Wilsonville, OR

QlikView Developer

Responsibilities:

• Finding and Understanding the essential data, eliminating the data which doesn't suit the requirement.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
• Creating the data model with necessary fact and dimension data.
• Created a standard template for the dashboard.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs.
• Created analytical expressions for the different KPIs used in the dashboard.
• Performed analysis, documentation, for calculation for various attributes.
• Worked on Automation & scheduled QVW document refreshments using QlikView Publisher.
• Promoting dashboards to production environment, Scheduling and Distributing through QMC and manage user access.
• Involved in working with Server, Publisher and Application Deployment.
• On demand reload facility for the users to reload the data when needed to view in report.
• Performed testing of dashboards for functionality, data and worked with QlikView administrator to optimize QlikView performance.
• Involved in the Unit Testing and validation of data on QlikView Applications.
• Interaction with QlikView support to solve the major 3 challenges we faced during migration.
• Documented all the changes to migrate dashboards from QlikView 8 to 9.

Environment: QlikView 8 & 9, Excel, MS SQL Server, Oracle 11g, PL/SQL.

Confidential, Atlanta, GA

QlikView Developer

Responsibilities:

• Involved in Business requirement gathering and Participated in Joint Application Development (JAD) process with different Business Segments in designing QlikView Applications.
• Worked with business analyst to gather requirements.
• Extracted data from the SQL Server database wrote SQL load scripts and used joins to join the tables.
• Developed a Star Schema Data Model that suits the business requirements by eliminating synthetic keys and circular loops.
• Developed Dashboard using Bar Charts, Line Chart, Text Boxes and List Boxes.
• Used Alternate States and Set Analysis to get the needs of the end users.
• Used QVD generator QVW file to create the QVD’s. In the QVD generator file the data is imported from the SQL Server.
• Used Macros and Extensions in the dashboard developed.
• Used Document level and Field level triggers based on the requirements.
• Good experience in using the QlikView functions (Trim, Match, Like, String etc.)
• Implementing the Section access to the application developed and tan deploying it to the server.
• Involved in enhancement of existing dashboards with new functionalities.
• Involved in analyzing the existing data model, script logics and ETL logics for the existing dashboards.

Environment: QlikView, SQL Server, Team Foundation Server, MS Excel.

Confidential, McLean, Virginia

Sr.Qlikview/OBIEE developer

Responsibilities:

• Developed load scripts to work with multiple data sources (DB2, Flat Files, Excel).
• Developing a model that suits the business needs and also adheres to the needs of the end users.
• Developed QlikView Dashboards using Charts (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.).
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed Macros, Set Analysis to provide custom functionality in QlikView Applications.
• Implemented Security & involved in Deployment of QlikView Applications.
• Importing data from SQL Database and using SQL scripts to join the data tables and pull the required data.
• Deploying the Qlikview reports onto the Qlikview servers and Publishing the reports on Access Point.
• Used various charts and set analysis functions to generate desired outputs.
• Involved in Business requirement gathering with different Business Segments in designing Qlikview Applications.
• Developed Qlikview applications by analyzing business data as per client requirements.
• Involved in creating logical and physical model of the database using Erwin.

Environment: Qlikview 11, SQL Server, SSIS, Oracle, OBIEE, Erwin.

Confidential, Dallas, Texas

BI/Qlik view developer

Responsibilities:

• Analysis of the specifications provided by the client and understanding the business.
• Involved in the Requirements gathering (Gathering, analyzing, and documenting business requirements and data specifications).
• Experience using an ETL tool QlikView to handle the various data feeds from the different data sources using QlikView load scripts into QVDs.
• Imported data from different sources like Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Hands-on experience in the design, development of end user applications for the data presentation and analytics, including scorecards, dashboards, reports, monitors, and graphic presentation (Information Visualization &Analysis) using QlikView 11 BI platform.
• Creation of different types of reports such as master/detail and crosstab for trend analysis.
• Designed and developed extensive QlikView reports using combination of charts and tables.
• Developed Drill through Dashboards which enabled users to drill down between dimensions.
• Showed the statistics in bar charts and pie charts as per the client needs.
• Created Set Analysis for Comparison analysis eliminating additional complex coding
• Creating the reports using Scope of Analysis.
• Exporting and Printing data in QlikView.
• Developed complex SQL queries and functions to fetch data for reporting and to accomplish several computations.
• Specified the standards/best practices for universes like maintaining design consistency.
• Implemented Incremental Load in QlikView Servers.

Environment: BI solutions, BI environment, BI Applications QlikView 11, Informatics 8.1, Oracle 11g, Windows XP/7, MS Access 2010, MS Excel, Teradata.

Confidential, Trichy,TN

SQL/PLSQL 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 their is not much change during the migration of the reports.
• Coordinated physical changes to computer data bases; and codes, tested and implemented Oracle and SQL data base, applying knowledge of data base management system.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Assessed the pros and cons of migration and conveyed the same to the Business Analyst.
• Created different types of reports such as parameterized reports, matrix report, charts etc.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports and linked reports.
• Written stored procedures for those reports which use multiple data sources.
• Drill down, Slice and Dice and Filtering operations done for all OLAP applications.
• Specified user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data.
• Production Support which involves solving user problems.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Tested (manual) the reports after migration to make sure that the developed reports serve the exact business purpose as that of existing Actuate reports.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

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