SUMMARY

• Around 7+ years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems and Business Intelligence.
• Senior QlikView/QlikSense BI with comprehensive experience in planning, designing and building BI Dashboard and Analytics Reporting solutions, utilizing BI tools (QlikView,Qlik sense BO, SSIS/SSRS), Databases (Oracle, DB2, Microsoft SQL,IBM Netezza), data analytics and dashboard visualization skills, supporting evidence - based business decision making.
• More than 5+ years of BI dashboard and Visualization experience.
• Strong Skills in QlikView/Qliksense 11, 10, 9.0in designing and creating dashboards and reports with various graphs and analysis.
• QlikView Expert in full development Lifecycle reloads automation and management.
• QlikView scripting language, Macro, VBScript, PDF reporting, QlikView Enterprise Server and Publisher, QlikView Developer, Section Access and Security/Entitlement model.
• Experience in database design & development, database programming, data modeling, business process analysis, and application development.
• 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.
• Experience in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• In-depth knowledge of industry best practices in both business management and technology domains.
• Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Expertise in Installing and Configuring QlikView/Qliksense Desktop, QlikView Server and QlikView Publisher.
• 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.
• Expertise in QlikSense Development and Architecture.
• Expertise in QlikView performance optimization.
• Expertise in the QlikSense SDLC and governance.
• Experience with QlikSense Extensions and workbench.
• Expertise in the QlikSense apps, stories, KPI and Story generation.
• Good experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• 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.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in performance tuning, logging, error-handling of SSIS packages and deploying from development server to production server.
• Experience in report generation using SQL server reporting services (SSRS) from relational databases as well as OLAP cubes.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Provided Training Sessions on QlikView capabilities to potential clients
• Involved in Performance Tuning & Deployment of QlikView Applications
• Part of QlikView COE (Centre Of Excellence)
• Involved in Prototyping the reports in QlikView
• A team player with good interpersonal skills and work independently.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS

Business Intelligence Tools: Qliksense, QlikView 11.0 /10.0/9.0 , SAP Business Objects 4.0, Crystal Reports

Languages: SQL, PL/SQL, C, C++, Javascript

Databases: MS Access 2000, DB2, MS SQL Server 2005, 2008, 2012, Oracle, Excel, SAP BW.CSV Files, Remedy Database

ETL Tools: Informatica Power Center, Congo’s, Sql Server Integration Services (SSIS), SSRS

Operating systems: Windows 2012, 2008, 2005, 2003, Windows xp, 7/8, UNIX

Domains: Financial, Banking, Healthcare, Services

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr.QlikSense Developer

Responsibilities:

• Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications.
• Developed applications inSenseDesktop as well as in theQlikSenseHub and shared the apps with the team throughQlikSenseCloud.
• Developed and designed the dashboards with different types of charts inQlikSenseDesigned visualizations like pie chart and bar chart.
• Application was built based on guidelines set in prototype proof of concept.
• Created charts as per the customer requirements on Quarterly, Monthly and Yearly for report analysis.
• Extensively used set analysis to calculate/aggregate the fact data as per the requirements.
• Performed Unit and Integration Testing and validates results with Business Analyst and end users.
• Documented each stage of the project and attended status meeting every week.
• Involved in converting the existing QlikView application toQlikSenseand prepared dashboards usingQlikSenseextension objects and mashups.
• Implemented security throughQlikSensescripting as well as QMC in order to restrict data as per users'/group privileges.
• Experience in On - demand apps that are generated usingQlikSensehub from navigation links that connect selection apps to template apps and managed in the QMC.
• QlikSenseApp development, templates, themes, master library items and story generation.
• Developed complex SET ANALYSIS to provide custom functionality inQlikSenseApplications.
• Sound ability to interact with end users and craft clear technical requirements from business language.
• PreparedQlikSenseproof of concepts as per the requirements and specifications.

Environment: QlikSense3.2,3.1, SQL Server, Oracle 11g, MS- Access, Excel, SharePoint, QMC, Power Designer, JavaScript, Windows Server.

Confidential, Bloomsburg, PA.

Sr. Qlikview/Qliksense Developer

Responsibilities:

• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• QlikSense App development and administration.
• Hands on experience in implementing the new features of QlikSense like Story Telling, Beta maps integrations, Pivot Table, KPI Object etc.
• QlikSense app performance optimization.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView/QlikSense.
• Developed executive dashboards in QlikView and qliksense delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Involved in Dashboard migrations from QlikView to Qlik Sense.
• Provided implementation and ongoing support related to Qlikview.
• Created Dashboards style of reports using QlikView components like Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance the performance of the business with analytical capabilities.
• Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Written macros to export data to PPT with data behind from QlikView with IE Plug - ins.
• Worked Closely with BA and Clients to understand the requirements.
• Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: Qliksense, Qlikview 11, SQL Server, Oracle 11g, N Printing, Java Script.

Confidential, San Carlos CA

Sr. Qlikview Developer/Admin

Responsibilities:

• Understanding user requirements and expectations. Providing end to end reporting solution.
• Installing, configuring, Clustering, Load balancing and Multi-node installation of Qlikview and Qlik Sense Environment.
• Expertise in Qlikview and QlikSense Security Implementation.
• Expertise in the QMC.
• Experience in implementing the governance.
• Created data connections in Qliksense like folder connection, ODBC, OLEDB and salesforce.
• Developed many Qliksense templates, themes, master library items and story generation.
• Studied the existing data model and incorporated the new fields including static and Dynamic flag fields to meet with the business requirements
• Worked on bulk volume of data sets and different data sources like .csv files, oracle Tables, excel files, images, etc.
• Created incremental load scripts for products and customers using multiple data source.
• Resolved data load issues like synthetic keys.
• Implemented section access security.
• Used QlikView Maps to show the reports and dash board for good visualization to the managers.
• Generated reports using NPrinting.
• Experience in error handling and debugging of Qlikview reports. Expert in handling production issues like report failures, missing counts in reports.

Environment: Qliksense, Qlikview 11.2 Nprinting, T-SQL, QlikView Server and PublisherAmazon Red Shift.

Confidential San Diego, CA

Qlikview Developer/Admin

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.
• Performed planning, design, and development of QlikView BI dashboards and data integration in a highly complex global services environment, interfacing QlikView, SSIS and oracle.
• 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.
• 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.
• Performed technical leadership in dashboard application design, visualization, automation, e-mail alert and notification, data modeling and the integration with the Portal platform
• Designed and developed scripts to support UI visualization, ETL processes, automation, and workflow and dashboard presentation framework.
• Created Layout themes and applied it to several documents.
• Used advanced scripting, set analysis, VBScript, advanced aggregation functions and advanced charts for applications.
• Participated in design and code reviews, QA/UAT testing, enhancement design and development, and deployment to support day-to-day business operations
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.
• Deploying the code from Development environment to test environment and provide developer support for UAT teams till the code moves to production.

Environment: Qliksense, Qlikview 11.20 Oracle, SQL Server QlikView Server and Publisher, SSIS and Congo’s.

Confidential, Duncan, SC

QlikView Developer/Admin

Responsibilities:

• Provided complex KPI’s (Penetration) using set analysis.
• Requirements gathering, Impact Analysis and solution designing to in corporate the Business requests.
• Understanding the business functionality & Analysis of business requirements.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• Design, Develop, Test, debug and implement Qlikview solutions based upon specified requirement.
• Extract, transform and load data from multiple sources into Qlikview applications.
• Created QVD’s & updated on timely basis as database updates.
• Deploy applications on production server and set up automated data reloads.
• Create PDF push reports using Qlikview report editor.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins. Using Qlikview Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
• Developed User Interactive Sheets & Reports as business needs.
• Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented Star & snowflake schema (confirmed dimensions).Writing SQL Scripts to load the relevant Data in Qlikview Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in Qlikview Applications.
• Worked on Publisher to Automate and scheduled hourly/daily/weekly/monthly/EDX data loads of QVW documents and error notifications by email to assigned users.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using theQlikView publisher. Automated and scheduled daily/weekly/monthly data loads of QVW documents usingQlikView Publisher.

Environment: Qliksense, Qlikview 11.2, Remedy, SQL Server, Excel, CSV files, QlikView Enterprise Server, QlikView Server and Publisher.

Confidential, St Louis, MO

QlikView Developer

Responsibilities:

• Understanding user requirements and expectations. Providing end to end reporting solution.
• Assigned to create dashboards by extracting data from multiple databases, storing into QVD files, write load scripts, and develop UI per user requirements.
• 3 Executive Dashboards depicting Sales, Forecast and Inventory data were created during the stint. Dealt with a data volumes ranging from 20 to 50 million records.
• Designed dashboards using the various sheet objects Current selection, list boxes, search, Straight table, Pivot table, Bar chart, Combo chart and so on.
• Created link tables on the needed basis and as per the data.
• Created Master Calendar and worked with date fields as per the user needs.
• Applied mapping function to look up and fetch the required field.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts.
• Document event trigger, document chaining and field event triggers is created. Incremental reloading is implemented.
• Hands on experience to leverage mapping GIS providers in QlikView for multi-layer maps and data source integration and advanced GUI development in Qlikview.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Developed link tables, & incremental loading on the needed basis.
• Published dashboards on Access point. Deployed QVW's on the production server, Created Reload and Distribution tasks on QlikView Server/publisher.
• Analyzed the database and provided detailed information on their operational and Forecast for future years.
• Performance tuning of dashboards was carried out to limit the response time.
• Successfully passed through the QA Environment and implemented on Production and post production support.

Environment: Qlikview 10/11, Oracle, SAP BW, SQL Server, Tera Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, QlikView Enterprise Server, QlikView Server and Publisher.

Confidential, Reston, VA

QlikView Developer/Admin

Responsibilities:

• Worked with the team to identify the business reporting needs and studied current reporting practices outside of QlikView through pivot tables.
• Performed redesign of QlikView BI platform to improve availability, scalability and performance to accommodate high volume of data with 60+ dashboards
• Participated on business requirement document preparation.
• Rebuild dashboard applications on both frontend UI and backend, developing scripting templates, UI design and coding standards, design guidelines, migration strategy and implementation plan.
• Developed different dashboard with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI per user requirements.
• 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 the basic components of QlikView.
• Maintained and administered source documents, source documents set, and user profiles and executed resource management services like Access point resources, distribution folders and email servers. Monitor user access to manage the limited number of licenses.
• Optimizing existing data models including document changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Modified existing reports using QlikView.
• Maintained and updated the dashboard reports as required by client.
• 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.
• Maintained user guides and documentation for QlikView applications.

Environment: Qlikview10/11, Oracle,Qlik sense, SQL Server, Tera Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Congo’s, QlikView Enterprise Server, JavaScript, Java, ASP.NET.

Confidential, North Carolina

QlikView Developer

Responsibilities:

• Work directly with business users to define and prototype Qlikview Applications.
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Gathered, Analyzed, and transformed business requirements of the Client into logical and physical BI solutions.
• Participated in project planning, documentation, budgeting, and requirement analysis.
• Worked with cross functional team and business user to develop Business requirement document (BRD), define key performance indicators (KPIs) and identify data sources.
• Conducted requirements gathering and developed strategy maps and roadmaps for delivering Data Analytics and BI Reporting via QlikView in-memory technology
• 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.
• Designed and developed BI Reporting solution enabling users to effectively utilize the tools to create Analytical Reports, Dashboards, and Scorecards, helping clients align KPIs performance metrics to strategic drivers and priorities.
• 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.
• Developed predictive analytics and forecast models to help clients gain deeper insights on existing data and information, improve business performance, and shape the future of the companies.
• 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 9/10, OBIEE, Informatica, Oracle, QlikView Server and Publisher, QlikView Developer, Microsoft SQL Server, Oracle Database, SAP Business Objects, Crystal Reports, Congo’s.

Confidential

SSIS, SSRS Developer

Responsibilities:

• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data about the cable layout, to meet the company specifications.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Exposed to data conversion from different data sources to SQL Server 2005 using SSIS.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2005.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application
• Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.

Environment: MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Oracle 9i, VBScript.

Confidential

SQL Server Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access and Created new security accounts.
• Performed Backup and restore of databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics information for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS.