SUMMARY

• Around 7 years of experience in IT industry with strong background in Analysis, Design and Development in the field of Database, Data Warehouse, Data Modeling and implementation of Qlikview for BI applications.
• Experience in database design & development, database programming, data modeling, business process analysis, and application development.
• Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance using Qlikview.
• Good expertise with the development and design of Qlikview applications.
• Expertise in all versions of QlikView (9, 10 and 11).
• Extensive experience administering QlikView Server, QlikView Web Server and QlikView Publisher using QMC and QEMC.
• Designed and developed the most suitable User Interface such as Dashboards, different types of Charts, Dynamic Text Objects to meet the requirements in the simplest way.
• Strong understanding of Dimensional Modeling technique, Multi - Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation and Macros interface, Section Access, Set Analysis in QlikView and DW concepts.
• Scheduling the automation of QV jobs using QlikView/Qliksense Management Console.
• Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Experience in designing and creating database objects such as Tables, Views, Indexes, stored procedures, functions, triggers in SQL Server based on logical design model and user requirements.
• Involved in Performance Tuning & Deployment of Qlikview Applications.
• Handled the end-to-end implementation of QlikView /Qliksense dashboard deployment.
• In-depth knowledge of industry best practices in both business management and technology domains.
• Worked with QlikView/Qliksense administrator to optimize QlikView /Qliksense performance.
• Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality.
• Prepared Qliksense proof of concepts as per the requirements and specifications.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Worked in close association with customers for requirement gathering and effective analysis.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS

Business Intelligence Tools: QlikViewServer & Publisher 11.0/10.0/9.0 , Qliksense

Databases: Oracle9i/10g/11g,SQL Server

Data Modeling Tools: Erwin, Visio 2000.

Programming Languages: SQL, PL/SQL, Shell Scripting.

Operating Systems: Windows 7/8/2000/XP/VISTA/NT,UNIX (Fair knowledge)

Project Management: MS Project 2007

Other Tools: MS Access, MS-Excel, MS InfoPath

PROFESSIONAL EXPERIENCE:

Confidential

QlikView Developer

Responsibilities:

• Worked with the finance teams to identify the business reporting needs and studied current reporting practices outside of Qlikview through pivot tables.
• Participated on business requirement document preparation.
• Participated in Scrum stand up meetings.
• Created SQL Stored Procedures and Views to fetch the data from database to build reports.
• Responsible for POC by building Dashboards using Qliksense and Qliksense for Cloud.
• Designed and created the financial dashboard reports for Executive board of company.
• Designed an applications for to support the lending process and dashboard style of layouts using different components of QlikView/Qliksense Enterprise like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks.
• Modified existing reports using QlikView.
• Maintenance of data in form of QlikView/Qliksense data files, pulling the data from relevant database.
• Analyzed the external financial and regulatory reporting, intercompany and internal management reporting needs of the business process.
• Installed, configured and deployed Qlikview application on top of Oracle DB.
• Created and maintained OLE DB/ODBC connections for all environments.
• Developed hierarchical business model for company codes, account numbers, line of business, treaty/plan, customers and adjustment periods.
• Designed dashboards identifying the KPIs and to support the time comparison between budgets and actual.
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across the enterprise.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView/Qliksense.

Environment: Qlikview 10.0&11.0, Qliksense 1.1.0, QlikView Server, Qlikview Publisher, SQL Server 2005, and Oracle 10 g, Teradata, SAP, Excel, CSV files.

Confidential, Costa Mesa

QlikView Developer/ Architect

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/Qlik sense 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 different complex sheets and sheet objects based on client requirements.
• Created List boxes, Statistic boxes to show the statistics of the sales held on different products in different years.
• Showed the statistics in bar charts and pie charts as per the client needs.
• Added dimensions to a bar chart and turning bar chart into a multidimensional pivot table.
• Created multi boxes, table boxes, and input boxes to fetch data based on the input given.
• Altered the QlikView/Qliksense scripts based on any unusual latency in the response time on the UI.
• Created Layout themes and applied it to several documents.
• Handled the end-to-end implementation of QlikView /Qliksense dashboard deployment.
• Used advanced scripting, set analysis, VBScript and JScript macros, advanced aggregation functions and advanced charts for applications.
• Developed Migrations of dash boards using Qliksense.
• Assisted in reporting using QlikView / Qlik Sense
• Qliksense 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.
• Worked with multiple data sources including Oracle DB, MS Access, excel, CSV’s, text files as well as previously built QVD’s.
• Enhanced and translated existing dashboards in SSRS into QlikView and worked extensively with the set analysis.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.

Environment: Qlikview 10.0/11, Qliksense, Oracle, MS Access SQL Server, Informatica 8.6, Toad 9.6.1/SQL Developer, SQL Loader and Sun Solaris.

Confidential, Warren

QlikView Developer

Responsibilities:

• Designed different sets of reports and interacting with client for requirement analysis and delivery project of QlikView Applications
• Created Dashboard using different components of QlikView like list boxes, multi boxes, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table).
• Dashboard analysis portfolio by profit low to high and doing research for poor performance for revenue growth.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Implemented incremental load by creating QVDs and optimized the periodic data additions.
• Reviewed and documented existing SQL*Loader ETL scripts.
• Designed and developed dashboards with various levels of complexity including different kinds of charts and extensions
• Designed application for Sales & Marketing Modules that Generates GUI Report for easy access through the data.
• Worked with QlikView administrator to optimize QlikView performance.
• Prepared Qliksense proof of concepts as per the requirements and specifications.
• Designed an applications for to support the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher
• Scheduled QVW reloads on Server/Publisher by creating tasks in the Source Documents. Used Loop and reduce concept for creating multiple apps based on the field.
• Implemented tasks to schedule QVD generation and Dashboard refreshes at regular intervals and appropriate dependencies.
• Built complex expressions using set analysis and functions in support of the dashboards.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Process analysis and process mapping with respect to project.
• To supervise adhoc tasks sent by client.
• Contribute to high levels of professionalism and intellect necessary for continuous improvement of project.
• Created Master Library with the dimensions, Measures and Visualizations.

Environment: Windows XP, PL/SQL, UNIX, Oracle 11g, Erwin, SQL developer, MS Office, QlikView 11.

Confidential, New York City

QlikView Developer

Responsibilities:

• Gathered, Analyzed, and transformed business requirements of the Client into logical and physical BI solutions.
• Participated in project planning, documentation, budgeting, and requirement analysis.
• Applied Scrum methodology in the system development process.
• Worked with cross functional team and business user to develop Business requirement document (BRD), define key performance indicators(KPIs) and identify data sources.
• Designed and developed QlikView software applications and server-based QlikView dashboards from scratch to support BI initiatives.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
• Identified data sources and targets for data modeling and solution architecture.
• Implemented new production methodologies that resulted in optimizing employee's time to finish the tasks, thus enhancing employee efficiency.
• Created automatic schedulers to reload the data as per requirements.
• Worked closely with the development team to understand functionality, resolve issues and provided feedback for the UML diagrams.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Provided ongoing QlikView consultation to the development team.

Environment: QlikView 8.5, OBIEE 10.1.3.4.1 , Oracle Apps 11.5.3, Informatica 8.6, Oracle 10g, Windows NT & Sun Solaris

Confidential, Cleveland

SQL Server Developer/BI

Responsibilities:

• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Worked on performance monitor counters for monitoring SQL Server environment.
• Managed indexes, statistics and optimizing queries by using execution plan.
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Designed DTS Packages to transfer data between servers, load data into database, and deploy the data, scheduled the jobs to do these tasks periodically.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Extracted the data from Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2005).
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel and .net.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML, .doc and CSV using SQL Server 2005 Reporting Services (SSRS).
• Used MS Access for smaller databases to create the tables and generate the reports.
• Created score cards with advanced set of dashboards using MS Office Performance Point Server 2007 Dashboard Designer that feature executive summary measures.
• Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables.
• Resolved various performance issues by running DBCC command.
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler.

Environment: SQL Server 2005, SSIS, SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel,C#, ASP .Net, ER Studio, Performance point Server.

Confidential

Oracle Programmer

Responsibilities:

• Installed SQL Server 2000 Servers, multi instances.
• Database Programming in Visual Basic 6.0, MS SQL Server 2000.
• Planned and Scheduled the Online/Offline Backups, Maintained Backups and Restore.
• User Management creating groups and policies in Active /directory, Maintained User data and File System.
• Created and maintained mail and database accounts with client user support.
• Configured and maintained servers with Active Directory integration.
• Performed optimization of indexes and queries by using index tuning wizard to enhance the performance.
• Performed log-shipping process between servers.
• Performed extensive database activities such as data modeling, database design, data analysis, validation and consistency check.
• Used triggers and constraints to maintain the consistency of the databases.
• Used DTS packages to perform Data Transformation tasks like bulk copy and bulk transfer of data and used BCP utility to perform these tasks.
• Implemented Business logic using stored procedures.
• Designed and developed tools for business requirements using stored procedures.

Environment: SQL Server 2000 Enterprise Edition, DTS Designer, SQL Server Enterprise Manager, Windows 2000/NT, MS Office.