SUMMARY

• 5+ years of IT experience in all phases of software development including analysis, design, development, testing and customer support of applications.
• Strong knowledge and experience in optimizing Qlikview extraction loads.
• Experience with Qlikview Server and Qlikview Publisher.
• Strong knowledge and experience in writing SQL and ETL tools
• Worked with Qlikview Architecture, ETL and Dimensional modeling.
• Involved in Requirement gathering & designing QlikView applications.
• Gathering data sources like QVD files, Excel, Oracle & DWs, binary QVW, Inline and txt files in developing the QlikView Data Models.
• Interacted with Customers for requirement gathering and effective analysis.
• Developed interactive dashboards for mobile professionals while disconnected from network.
• Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans.
• Creating and Managing logins, users, roles and assigning necessary permissions.
• Solving data modeling issues like synthetic keys and loops using link tables etc.

TECHNICAL SKILLS

Database: SQLSERVER2005, Oracle10g, Access, Excel & .CSVFiles

Languages: SQL, PL/SQL, C/C++BI Tools QlikView 8.5/9.0/10, BI Development, MS - Office, MS-Outlook, MS-Visio.

Data Modeling: Erwin, Microsoft Visio

Operating Systems: Windows9x/XP/NT/2000

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

QlikView Developer

Responsibilities:

• Developed dashboards to analyze Revenue and Sales using Qlikview 11.
• Managed and distributed application using Qlikview Publisher.
• Managed the QlikView Server tasks: developing tasks, assigning license
• Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.
• Involved in analysis of KPI’s & understanding requirement.
• Involved in testing of dashboards for functionality, data, performance, look and feel.
• Fine tuning application for best performance.
• Used Set Analysis for dynamic calculations.
• Used functions like Mapping load, lookup.
• Created calendars to have all date and time functions created in script.

Environment: Qlikview11, SQL, MS Access, Excel, Windows XP.

Confidential, Warren, NJ

Qlikview Developer

Responsibilities:

• Developed QlikView Dashboards using different Chart, Drill through, Cyclic Groups, List, Input Field, Table Box, Container etc...
• Implemented Security & involved in Deployment of QlikView Applications.
• Created Dashboards style of reports using QlikView components like Slider, Buttons, Charts, and Bookmarks.
• Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc...)
• Developed Linked Tables, Concatenation and solved the loops issues.
• Experience using groups, conditional display using variables, and calculation condition and error messages for various charts.
• Optimization using incremental load (Insert, update and delete) and field trimming.
• Used to solve the issues related to the end users.
• Responsible for the performance and tuning of the application, including performing maintenance/upgrades on applications programs and systems as required.
• Responsible to ensure that all assigned systems and application are defined and tested backup and recovery procedures for critical data.
• Involved in Production Support for QlikView applications & Server.
• Conducted end user training sessions and prepared the training documentation.

Environment: QlikView 10 SR2/11 SR1, QlikView Server, QlikView Publisher.

Confidential, Jersey City, NJ

QlikView Developer

Responsibilities:

• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reports using QlikView 9.
• Created Dashboards style reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Worked extensively on creating Alerts, Variables, Input boxes, calendar & Macros.
• Worked on Implementation of Star schema and snow flake schema (confirmed dimensions).
• Worked on developing Linked Tables, Concatenation and solving the loops issues
• Involved in Gathering and loading data into QlikView from various data sources (SQL SERVER 2005, CSV and excel files)
• Worked on to solve the issues related to the end users
• Installed /Configured QlikView 9.

Environment: QlikView 9, SQL Server 2005, Oracle 10g, Windows Server 2003, Windows XP, Microsoft Visio.

Confidential, Palo Alto, CA

QlikView Developer

Responsibilities:

• Working on a supply-chain management project which contains detailed data about sales, inventory, goals and targets.
• Designed a Proof-of-Concept for another supply chain management project which gives a brief overview of product sales & supply need.
• Worked with Qliktech Support team in different stages of development of project.
• Analyzed the database and provide detailed information on their operational and Forecast for future years.
• Involved in gathering requirements from the users and suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Document event trigger and field event triggers is created. Incremental reloading is implemented
• Created Document for the project planning and production Interface Documentation.
• Successfully published 4 applications based on user requirements and implementing next phase for all the applications.

Environment: QlikView 8.5, SQL Server 2005/2008, HP Quality Canter 10, Windows 7/XP/2008 server, Flat files.