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 - teh 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 teh data, resolved Circular Relationships, Synthetic Keys.
• Expertise in designing and creating various analytical reports and Dashboards to halp users to identify critical KPIs and facilitate strategic planning in teh organization using QlikView.
• Performance tuning by analyzing and comparing teh 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 teh 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 principals 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 teh essential data, eliminating teh data which doesn't suit teh 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 teh basic components of QlikView.
• Creating teh data model with necessary fact and dimension data.
• Created a standard template for teh 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 teh different KPIs used in teh 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 teh users to reload teh 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 teh Unit Testing and validation of data on QlikView Applications.
• Interaction with QlikView support to solve teh major 3 challenges we faced during migration.
• Documented all teh 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 teh SQL Server database wrote SQL load scripts and used joins to join teh tables.
• Developed a Star Schema Data Model that suits teh 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 teh needs of teh end users.
• Used QVD generator QVW file to create teh QVD’s. In teh QVD generator file teh data is imported from teh SQL Server.
• Used Macros and Extensions in teh dashboard developed.
• Used Document level and Field level triggers based on teh requirements.
• Good experience in using teh QlikView functions (Trim, Match, Like, String etc.)
• Implementing teh Section access to teh application developed and then deploying it to teh server.
• Involved in enhancement of existing dashboards with new functionalities.
• Involved in analyzing teh existing data model, script logics and ETL logics for teh 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 teh business needs and also adheres to teh needs of teh 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 teh 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 teh data tables and pull teh required data.
• Deploying teh Qlikview reports onto teh Qlikview servers and Publishing teh 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 teh database using Erwin.

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

Confidential, Dallas, Texas.

BI/Qlik view developer

Responsibilities:

• Analysis of teh specifications provided by teh client and understanding teh business.
• Involved in teh Requirements gathering (Gathering, analyzing, and documenting business requirements and data specifications).
• Experience using an ETL tool QlikView to handle teh various data feeds from teh 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 teh design, development of end user applications for teh 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 teh statistics in bar charts and pie charts as per teh client needs.
• Created Set Analysis for Comparison analysis eliminating additional complex coding
• Creating teh 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 teh 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 teh suggestions given by business analyst and Analyzed teh 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 teh client to make sure that their is not much change during teh migration of teh 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 teh pros and cons of migration and conveyed teh same to teh 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 teh SQL queries, which takes long time to process teh request using Explain Plan, Hints to reduce teh response time.
• Tested (manual) teh reports after migration to make sure that teh developed reports serve teh exact business purpose as that of existing Actuate reports.
• Handled errors usingException Handlingextensively for teh ease of debugging and displaying teh error messages in teh application.

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