SUMMARY

• Exposure in all phases of Software Development Life Cycle (SDLC) including Requirement Gathering, Development, Testing, Deployment, Documentation, Migration, Security management, Training and Production support and methodologies in Business Intelligence domain.
• Creating QlikView data models, QlikView objects, reports, graphical interactive UI using various data sources like Oracle, SQL Server, Access, text files, Excel documents etc.
• Having proven abilities in development, design, testing and production support for successful execution of projects on QlikView/QlikSense on 3 - Tire Architecture.
• Optimized existing QlikView dashboards with a focus on usability, performance, long-term, flexibility, and standardization.
• Expert in Unit testing and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Created QVD's & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Qlikview Server & Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Experience in Incremental Loading & QlikView document Versioning and Sound knowledge in writing SQL Queries, Pl/SQL Stored Procedures.
• Performance tuning of QlikView & QlikSense apps for faster data reloads and efficient response times.
• Implemented Triggers using Macros to provide custom functionality in Dashboard Applications.
• Designed Qlikview applications using Qlikview Data (QVD) files, different Databases and Created reusable variables.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• In-depth knowledge and understanding of data warehousing concepts, ETL, OLAP, OLTP, Cubes and normalizations to translate business requirements into effective business intelligence solutions.
• Hands on experience on cloud based database solutions and Qlik Sense cloud applications.
• Providing map visualizations and location-based analytics using the Qlik Geo-Analytics.
• Building a mashup (web application) using multiple sources, creating mashups by Document integration using opendoc.htm, Object integration using singleobject.htm.
• Good knowledge in programming languages like C++, and Java coding.
• Knowledge on ODAG (On Demand App Generation) conducting associative analysis on larger data sources.
• Excellent technical, analytical, and problem-solving skills. Ability to adapt, learn new technologies and get proficient in them very quickly. Identifying the root cause of the business application issues and troubleshooting them.

TECHNICAL SKILLS

BI Tools: QlikView / QlikSense

Database: Oracle, MS SQL Server

Data Model: Relational Model, Network Model, Hierarchical Model, Object-oriented Data Model.

Packages: MS-office (MS-Access, MS-Word, MS-Excel and MS-FrontPage)

Languages: SQL, PL/SQL, T-SQL, Java, Java Script, CSS

Operating Systems: Windows, Linux

PROFESSIONAL EXPERIENCE

Qlik View/Qlik Sense Developer

Confidential, Newport Beach, CA

Responsibilities:

• Worked with business requirements, provided technical expertise, and produced system specifications for enhancements & changes in the application.
• Translated the business requirements to system requirements. Traced the high-level business and user requirements to functional requirements and low-level Use Cases.
• Implemented the 3-tier architecture, loading raw data creating QVD, transform to business login and requirement of the business and data model is created, reading the 2nd tier QVD and making a single QVW.
• Performance and tuning of the application, including performing maintenance/upgrades on applications programs and systems as required.
• Converting the QlikView documents into QlikSense apps using the QlikView converter tool in the Dev Hub.
• Using the conversion tool to convert the objects-Visualizations, Dimensions, Measures, Variables from QlikView to QlikSense and manually recreating the objects which are not converted.
• Working on the QlikSense app by adding the sheets and adjusting the visualizations after the conversion.
• Developed dashboards in QlikSense to replicate existing QlikView Dashboards/reports.
• Creating and scheduling daily/weekly QlikView reports using NPrinting.
• Designing and building of Dashboards & Scorecards, KPI's based on an existing Semantic layer in QlikSense.
• Hands on experience on the third-party extension QlikMaps. Created maps based on spider analysis, custom pop up which displays bar chart, etc. both in QlikView & QlikSense.
• Good Knowledge on the processes of data quality, data cleansing and data transformation, data tuning.
• NPrinting for distribution of reports in different format to respective users, adding users, groups, adding Triggers and scheduling of reports.
• Worked on ETL Tasks such as data cleansing joins aggregation tables using QlikView.
• Using NPrinting Tool created Pixel Perfect customized reports as per the client requirements using the rich NPrinting reporting features.
• Hands on experience in Qlikview advanced features like the Alternate States and Direct Discovery.

Environment: QlikSense 2.0 Qlikview Server and Publisher, QlikView 11.x, Microsoft SQL Server 2008 R2, Oracle, SAP, Excel, Flat files, MS Access, NPrinting.

Qlikview Developer

Confidential

Responsibilities:

• Requirement gathering, sessions with business analysts, business stakeholders, Subject Matter Experts (SME), developers and sponsors. Involved in complete SDLC life cycle.
• Involved in designing complex packages moving data from various servers and environments using SSIS which also involved data from XML, Flat Files, CSV Files and SQL Server Databases.
• Built QVD's from Excel files and Designed UI based on the Business requirements.
• Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the UI to make it more accessible to users.
• Created the reports using charts like Pie, Bar, Line, pivot table, straight table etc.
• Extensively used Set Analysis, Dollar-Sign Expansion, and AGGR Function for advanced calculations in Sheet Objects.
• Created a Data Mart to use later on by using multiple user facing applications, and later on loading the contents of the Qlik Mart using a Binary Load.
• Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements.
• Developing trend analysis reports using complex graphs for study of data quality patterns.
• Scheduling and reloading of QlikView data model QVDs and QVWs through QlikView server and QlikView Management Console (QMC).
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Used QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields) for creating dashboards.
• Developed QlikView scripts to load the transformations and make enhancements to the user interface of the desktop application.
• Developed SQL Served stored procedures to create a dynamic load of staged HFM data that considers hierarchy changes.
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and publisher.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.

Environment: QlikView 10.x & 11.x, ETL, SQL Server 2008 R2, MS Access, MS Excel, Flat Files, Windows Server 2008, CSV Files, Oracle 10g, SQL Scripting.

Qlikview Developer

Confidential

Responsibilities:

• Installed, configured and deployed the application on QlikView server and Imported data from different sources Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Wrote SQL Scripts to load relevant data in Qlikview Applications.
• Worked with Business Analyst and the Business user to identify the user requirements, business reporting needs.
• Actively participated in the design, architecture and development of user interface objects in QlikView applications.
• Developed Variables, Input boxes, Triggers, Macros extensively.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Used data visualization techniques to build the most widely used QlikView apps from scratch, helping decision making in strategy, marketing and product departments.
• Create and optimize data models based on different types of data sources (Excel spreadsheet, .csv files, flat files, databases, CRMs, etc.).
• Worked on dashboards related to Sales Analysis, Production over time, and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.
• Implemented Data Modeling by using Star Schema and Snowflake Schema.
• Developed dashboards, reports in charts, reports in pdf's and moved into production environment.
• Worked on data modeling and developed different complex models as per given user requirement by eliminating closed loops, Synthetic tables and ambiguous relationships.
• Developed Linked Tables, Concatenation and solved the loops issues.
• Involved in understanding the functional capabilities, interfaces, and considerations and determined the optimal design strategy for implementing requirements.
• Creating Publisher Tasks in QMC for the QlikView Application to Reload and distribute the QlikView Application on to the Access Point.
• Generating reports as per the requirements using set analysis.
• Deploying QlikView Dashboards, managing daily QlikView jobs that update QVD files and Dashboards.

Environment: Qlikview 10x, Qlikview Server and publisher, Oracle 10g, PL/SQL, MS Office, QVDs, Windows 2008 R2 Server, Microsoft Visual Studio, ERWIN.

SQL Developer

Confidential

Responsibilities:

• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
• Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
• Involved in Performance tuning and Query Optimization.
• Used SQL Developer to Load / Extract data into and from Excel files.
• Conducted impact analysis and designed structures to enhance performance.
• Involved in data cleaning, merging and conversion.
• Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations.
• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Cleaned the data and created fact and dimension tables, performed calculations required for the reports using SQL Server environment and accomplished data modeling.
• Created dynamic Reports from the cube using SSRS 2005, and stored procedures.
• Troubleshoot the deployment of reports in the test and production environment using SSRS.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent using SSAS.
• Created Test Cases and Technical Design Documents.
• Collaborated with Data Warehouse in impact analysis to crystal reports.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL Analysis Services 2008, MS Excel.