PROFESSIONAL SUMMARY:

• Over 8 years of experience in IT industry with 4 years of experience in development of Reports using QlikView.
• Worked on different QlikView Version QV 9.0, 10.0, 11 and 11.2
• Experience with Scripting (load data into QlikView from various data sources such as Excel, Oracle or SQL Server), Debugging and tracing.
• Experience with QlikView Design Objects for e.g. (different kinds of boxes, and various kinds of charts to represent the required data).
• As a Technical Consultant / Team Leader, been involved in designing and implementing the valuable solutions for Business Users.
• Hands on experience with SQL Database. Strong skills in designing and developing of relational database management objects and database design principles using SQL database system.
• Knowledge on full Requirement gathering for Business process.
• Experienced in QlikView Server and Publisher maintenance - scheduling jobs, user management and deployments.
• Good Knowledge of Data Warehousing Concepts & SQL.
• Basic knowledge on Migration Process.
• Developed set analysis to provide custom functionality in QlikView Applications
• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys in QlikView and designing an optimized Data model.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Extensive data aggregation/integration experience.
• Strong expertise in implementing the advanced features like Direct Discovery, Document Chaining, Dynamic Update, write back functionality using Macros, On Demand extensions for NPrinting reports.
• Experience in integrating the QlikView application with Salesforce, SAP Connector etc.
• Good knowledge in using QlikView extensions (Geographical Maps, HTML Display etc.) for various business requirements.
• Developed reports in QlikView and in report templates in NPrinting for sending out auto0 emails by scheduling jobs.
• A well-organized, goal-oriented, highly motivated effectual team member.

TECHNICAL SKILLS:

Programming Language: JavaScript, PL/SQL, .Net, PHP

Web Technologies: HTML 5, CSS 3

BI Tools: QlikView 9.0, 10.0, 11, 11.x

Databases: Oracle 9i/10g/11g, SQL Server, Teradata, MySQL, DB2, Excel, MS Access, XML, JDBS

Operating Systems: Windows 7/8/10 and Windows Server 2008

ETL Tools: Informatica

Operating Methodologies: Waterfall, Agile (SCRUM)

Dash boarding/Analytics: QlikView, Business Objects, Cognos, Tableau, OBIEE

PROFESSINAL EXPERIENCES:

Confidential, San Antonio, TX

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.
• Created Dashboard reports to track all the way through ship to final acceptance phases.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• 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.
• Created dashboards with complex sheets which include List boxes, Statistic boxes, containers, different charts (bar charts, scatter charts, Heat charts, and Block charts and pie charts) to show the statistics of the sales held on different products in different years.
• Created static reports using straight tables and pivot tables with spark lines and mini charts
• Dynamically creating the WHATIF analysis reports by modifying the input data though slider object and input boxes
• Created Layout themes and applied it to several QVW’s
• Used advanced scripting, Alternate states for comparative analysis, set analysis, VBScript and JavaScript macros, advanced aggregation functions, advanced charts for applications and Document chaining
• Involved in performance tuning of dashboards to improve the response time for the users accessing the documents via access point by reducing the size of the QVW
• Good understanding in the area of monitoring the various services in QMC, Task setup, managing client licenses, mounting folders, session collaboration, enable session, performance and audit logging, type of authorization (NTFS and DMS), loop and reduce and Section access management in PAT

Environment: Qlikview 11.0/QlikSense, QEMC, SQL Server, DB2, Windows 2008 server, HTML, VB Script & Java Script, QViewer, Microsoft TFS, MS Excel.

Confidential, Atlanta, GA

QlikView Developer

Responsibilities:

• Developed OLAP applications using Qlikview and extracted data from the enterprise data warehouse to support the analytical and reporting for all Corporate Business Units.
• Expertise in Installing and Configuring Qlikview/QlikSense Desktop, Qlikview/QlikSense Server and Qlikview Publisher and also implementing QlikSense on AWS.
• Expertise in implementing QlikView Architecture. Extracting, Transforming, Consolidating and Loading data from different data sources.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Created QlikSense Applications to demo and introduced the tool to clients.
• For Promotional Effectiveness developed demos from existing applications to highlight the features with QlikSense.
• Proven expertise in analysing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Developed executive dashboards using QlikView 9/10/11/QlikSense and delivered through the web.
• Expertise in providing dashboard security using Qlik section access technology that dynamically hides selected objects / data of the dashboard depending upon user privileges.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Proficient in using best practices to support the reporting activities. Adept in using performance tuning and optimization techniques such as load balancing, table weighing and partitioning.

Environment: Qlikview 9/10/11, QVD, AWS, QlikView Architecture.

Confidential, Plano, TX

QlikView Developer

Responsibilities:

• Built QVD’s from SQL Server Database, Stored procedures and Excel files.
• Analyzed the performance of a dashboard by single user test and also evaluated the performance test result reports generated by load runner.
• Reviewed and deployed the dashboards on production server.
• Conducted review meetings with Developers for auditing the dashboards and recommended necessary tweaks to improve the performance.
• Installed and configured NPrinting server and designer on windows server and desktop.
• Generated formatted PDF and excel reports using NPrinting on-demand extension objects for enabling dynamic reporting within the QlikView Dashboards.
• Created folder structure for new applications and provided access to the users in QlikView server.
• Configured QlikView extension objects (i.e. QlikMaps, Nprinting etc.)
• Mounted the server folders on QlikView Management Console to publish dashboards to access point.
• Involved in creating dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts (Drill Down, Drill up & Cyclic Grouping), text objects, bookmarks, Containers, Calendar object, Fast Change objects etc.
• Implemented data reduction feature to remove the unwanted associated data from QlikView using Post Reload triggers to reduce performance issues.
• Developed complex SET ANALYSIS to provide custom functionality in QlikView Applications.
• Used Section access and Sheet access to make the application available to desired users.

Environment: QlikView 11.2 SR 12, Set Analysis, Panorama, Oracle, Excel, Salesforce

Confidential

SQL/ETL Developer

Responsibilities:

• Created packages to automate the ETL processes included Meta data on record count, file size and run time
• Involved in Index Analysis and Performance Tuning.
• Worked on reconciliations of balances from different systems.
• Analyzed requirements with developers, business analysts and provided my inputs.
• Wrote and executed the test cases to perform System, Functional and Regression testing.
• Designed Some Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments.
• Proficient in data to transfer data from Operating System Flat files to the MS SQL Server database.
• Extensively worked on database cursors in MS SQL Server database
• Wrote and edit SQL queries for database testing and reports verification.
• Actively ensuring the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.

Environment: Sql Server 2005, T-Sql, MS-Office, MS Access and Excel.

Confidential

PL/SQL Developer

Responsibilities:

• Worked on various back-end Procedures and Functions using PL/SQL.
• Wrote necessary PL/SQL API scripts for successful running of the programs.
• Created required technical documents, technical specifications, and Test results.
• Used triggers and constraints to maintain the consistency of the databases.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML, .doc and CSV using SQL Server 2005 Reporting Services
• Extracted the data from Flat Files, transformed (Implemented required Business Logic) and Loaded into the target Data warehouse
• Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler
• 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.
• Modified the existing database by adding the tables and maintained relationships between the tables.
• Developed different types of Tabular Reports, Matrix Reports, and Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services
• Used Exception Handling for handling errors of programs, scripts and procedures
• Enhanced the existing reporting functionality by using the advanced features of SSRS

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