SUMMARY

• Over 6 years of IT experience in Business Intelligence with more than 4 years of experience in QlikView11.0.
• Expert in developing QlikView dashboards by QlikView Enterprise and proficient knowledge in QlikView Server, Publisher.
• Expert in Creating Dashboards using QlikView11.0 using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
• Developed Dashboard reports using various QlikView Objects like list box, multi box, table box, text objects and charts.
• Strong knowledge in QlikView Optimization methods and slowly changing dimension in the QlikView (Incremental load).
• Extensive knowledge in QlikView set analysis implementation.
• Designing Data Mart and Data Warehouse and Implementation of QlikView for BI (Business Intelligence) Reporting Solutions.
• Expertise in Data Modeling (Star Schema, Snow Flake Schema).
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modeling Issues.
• Strong Skills in Providing Custom functionality using Triggers.
• Installation & configuration Of QlikView Software.
• Experience in Incremental Loading & QlikView document Versioning.
• Sound skills in writing SQL Scripts, Pl/SQL Stored Procedures.
• GUI (Graphical User Interface) programming in Visual Basic for desktop application.
• Strong Database Development skills using SQL Server 2008 & Oracle11g.
• A team player with good interpersonal skills and work independently.
• Strong Skills in providing Training for End Users.
• Analyzed reporting requirements to usable long term dashboard and reporting solutions, develop solutions as necessary.
• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long - term, flexibility, and standardization.
• Conduct validation of existing reporting, User Acceptance testing and new solutions to ensure continuous accuracy and front end ease-of-use.
• Experienced in Training & Supporting end-user reporting needs using QlikView & Business Objects products.
• Onsite-Offshore coordination in delivering Business Intelligence Solutions.
• Excellent knowledge in Implementation of Relational Database (OLTP), Data warehousing systems (OLAP) and Data Marts

TECHNICAL SKILLS

QlikView: QlikView Development (Version 8.0/8.5/9.0/10/11 ), QlikView Server (Version 9/10/11), QlikView Publisher

ETL Tools: Data Services 3.1/3.2, Informatica

Databases / DB Tools: SQL Server 7.0/2000, Oracle 8i/9i/10g/11g, Sybase 7.x/11/12,DB2, MS Access

Programming Languages: QlikView Scripting, SQL, HTML.

Front end tools: Microsoft Project, MS Visio, HP Quality Center

MS Office Tools: MS Outlook, MS Word, MS Excel, MS Access, MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

QlikView Developer

Responsibilities:

• Worked with Business Analyst and the Business user to identify the user requirements, business reporting needs, layout, and developed the architecture of prioritized reports.
• Actively participated in the design, architecture and development of user interface objects in QlikView applications.
• Worked on data modeling and developed different complex models as per given user requirement by eliminating circular loops, Synthetic tables and ambiguous relationships.
• Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView server.
• A master calendar was used for time related dimensions and a strong source control methodology was used for tracking changes.
• Implemented security using QlikView section access that dynamically hides selected areas of the dashboard depending upon user privileges.
• QlikView best practices were used in implementation of scripting, set analysis and usage of variables.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Identify, propose and implement enhancements over the existing reports to improve user experience.
• Responsible for ensuring stability of QlikView server applications and all license and security management of all QlikView applications.
• Created weekly PDF report distribution for a set of users using Loop and Reduce functionality in QV Publisher.

Environment: QlikView 11, Set Analysis, Oracle11g, PL/SQL, SQL*Plus, SQL Developer, MS Access.

Confidential, NJ

QlikView Developer

Responsibilities:

• Interacted with users to identify problems, reporting requirements and problems in existing systems design.
• Collaborated with Business Intelligence team to learn current processes and practices.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Identified various KPI’s with businesses users and analyzing existing Business Objects Reports.
• Generated new QVD files from the EDW by writing scripts in QlikView applications. Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Extensively worked on QlikView Set Analysis.
• Created batch scripts to process the data periodically as per the business requirements.
• Applied metrics in the data via QlikView scripts and transformed QVDs to cater the business needs.
• Designed and Developed QlikView dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar & Date Island meeting the business requirements.
• Created batch scripts to process the data periodically as per the business requirements.
• Published Client application using QlikView Publisher and rolled out to Access point and administered security using Active Directory technology/Access DB integration.
• Scheduled and managed QlikView jobs using QlikView Scheduler for QlikView application dashboards.
• Monitor computer systems to minimize unscheduled downtimes and ensured availability of resources.
• Involved in performance tuning to optimize the functionality of dashboards.
• Provided production support to the existing QlikView applications.

Environment: QlikView11 SR1, Oracle11g, TOAD, Business Objects, Erwin Data modeling

Confidential, Boston, MA

QlikView Developer

Responsibilities:

• Extracted the data from various data sources such as databases, Excel documents and CSV files, transforming the data into standard format and load the data so that it is available for analysing and creating reports.
• Worked closely with Business to design, develop and enhance the Hyperion Reports.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Developed QlikView scripts to load the transformations and make enhancements to the user interface of the desktop application.
• Installed and configured QlikView9.0.
• Customized QlikView reports to interact with Hyperion IR
• Application processed tables with over 20 million records.
• Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Created batch scripts to process the data periodically as per the business requirements.
• Split the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• Experience in scripting QlikView Set Analysis and Macros.
• Altered the QlikView scripts based on any unusual latency in the response time on the UI.
• Created User Interface and prepared layouts for the system by using QlikView.
• Participated in the developing/enhancement of star schema dimensional data model.
• Used MS Access and QlikView extensively as reporting tools and to create user build specifications
• Assisted in upgrading from QlikView8.2 to version 9.0
• Wrote scripts and created batch files for automatic running of QlikView scripts.
• Worked on the UI for various applications

Environment: QlikView, Set Analysis, Hyperion IR, Oracle10g, PL/SQL, SQL*Plus, SQL Developer, MS Access.

Confidential

SQL Developer

Responsibilities:

• Developed T SQL code for the application.
• Modified the existing database by adding the tables and maintained relationships between the tables.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like billing, customer, and requests from the residential, business and large business databases.
• Created SSIS Dynamic Packages using variables and deployed the SSIS packages.
• Implemented Incremental loads using different kind of tasks using SSIS.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created, Managed and Support existing reports using SSRS.
• Involved in creating, deploying and configuring reports according to the requirements using SSRS.
• Developed different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Developed cubes using SSAS involving multidimensional data.
• Supported various sectors like Development, testing, Production, Maintenance and Application teams.
• Conducted performance tuning by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Executed Test cases manually Using Quality Center.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed requests that came from the development team.

Environment: MS SQL Server 2005, ASP.Net, Management Studio, BIDS, Visual Studio 2005, MOSS, Integration Services, SSRS, SSAS, T-SQL, DTS, ETL, XML, SQL Profiler, Windows 2003.