PROFESSIONAL SUMMARY:

• 8 years of professional experience in Data Warehouse, ETL, Data Analytics / Business Intelligence across Financial, Transport, Technology, Pharmaceutical, HealthCare and Retail domains.
• 5+ years of experience in developing different analytical applications using QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise).
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using QlikView(Version 9.0 to 12.0), QlikSense (Version 0.95 to 3.1) and NPrinting (Version 16.0 to 17.2).
• Expertise in installing and creating Designs using QlikView 12/11/10/9 and Qlik Sense 2.0 using different data sources like Oracle, SQL Server, Teradata , QVD files, text files, excel and generated dashboard as per the business needs.
• Experience embedding QlikView Applications into host applications using QlikView OCX Control
• Hands on experience with setting up security rules in different layers for restricting access for different types of users using QlikSense and QlikView.
• Excellent knowledge on Dimensional Modeling concepts like (Star Schema, Snow Flake Schema) and Kimball/Inmon methodologies.
• Good experience in creating Use Cases, process flow chart diagrams, Unified Modeling Language (UML) using MS Visio and Rational Rose .
• Widespread understanding of SDLC Methodologies like Waterfall, Agile/Scrum.
• Solid experience in organizing Joint Application Developments (JAD) sessions, walkthrough, Interviews, Workshops sessions with end - users, clients and stake holders.
• Extensive experience in Data Analysis, including profiling, cleansing, transforming and confirming.
• Prototyped QlikView dashboards into Qlik Sense POC's- implementing QlikSense features like story-telling.
• Created mockups for Qlik Sense applications where objects from Qlik Sense can be exported and viewed on an HTML page..
• Experience in creating Complex Data Models, Performance Tuning with best practices for QlikView Applications.
• Experience in developing User Interfaces and QlikView Dashboards using Chart-Box (Drill Down, Drill up, & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars, and Date Islands.
• Good Exposure to working with QlikView Functions and Expression Scripts and streamlining reporting operations of QlikView Applications.
• Excellent Experience in Qlikview Dashboards using different types of Qlikview Objects including multiple charts types , Trends, QlikMap, Org Chart, Whisker Pie, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and utilizing Set Analysis, Google Maps API, VB Script/ Javascript macro modules etc
• Strong Experience in working with Charts (Table Box, Pivot Tables, Straight Tables, Pie-Charts, Gauge-Charts, Trellis)
• Extensively used various Qlikview Scripting and UI functions such as aggr, rank, rangesum, firstsortedvalue, applymap, match, concat, numeric and date functions , etc.
• Implemented Incremental ETL to handle high, historical and incremental volume of data, resolved Circular Loops, Synthetic Keys.
• Strong Experience in VISUAL BASIC 6, created macros .
• Co-ordinate system and user Acceptance Testing and performed Data Validation for all the reports and dashboards generated from various database sources.
• Implemented Section Access, Binary Loads and abstracting the data layer using QlikView library and QVX files .
• Implementation of security in QlikView Applications at Document and Server Level .
• Skilled in QlikView Enterprise Management Console (QlikView Publisher/Server), Managing licenses & Securities.
• Team oriented individual with a results driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management.

TECHNICAL SKILLS:

Analytical Tools: QlikView 12/11X/10X/9X, QlikView Publisher/Server, Qlik Sense 2.0, Tableau, NPrinting, SSRS

Languages: SQL, PL/SQL, VB Script, C++,C,JavaScript, Shell Scripting, HTML

ETL Tools: Informatica, SSIS, DataStage

Database Technologies: Oracle 11g/10g/9i, SQLServer 2008/2005, Teradata, MS Access

Operating Systems: Windows (10,7, XP, NT/2000), UNIX, Linux

Methodologies: Kimball/Inmon, Waterfall/Agile Software Development

Application Software: Adobe Works, MS-Office Suite

WORK EXPERIENCE:

Confidential, Jersey City, NJ

Lead QlikView Developer

Responsibilities:

• Worked on the QV application that is used by 20 Named calls 10 Document CALs Licensed users with additional session licensed users as needed.
• Experience embedding QlikView Applications into host applications using QlikView OCX Control
• Task Set up is done using QEMC and created architecture for the independent applications and execute in an order.
• Developed extensively Alerts, variables, Input boxes, calendar & Macros.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks
• Developed extensively alerts, variables, Input boxes, Calendar & Macros
• Hands on experience in scripting and creating batch files for automatic running of QlikView scripts.
• Used data from multiple sources including Oracle, SQL Server and flat files (text, excel and xml) to generate QlikView reports.
• Developed User Interactive Sheets & Reports as business needs.
• Created materialized views to reduce query run time for the end user.
• Created a Macro for sending email and creating a word document to downloading directly to the user’s desktops.
• Gathering user requirements and designing database accordingly which involves creating logical data model and physical data modeling.
• Used SQL for implementing business rules and do performance tuning procedures.
• Creating many physical objects (table, constraints, index, function) to facilitate the smooth data retrieval
• Designing, developing & fine tuning data-retrieval & data-migration scripts.
• Executed aspects of an implementation project including, but not limited to, planning, analysis and design, configuration, development, conversations, system testing, cutover and production support.
• Developed comprehensive reports, cross reference listings and statistical reports using Oracle Reports/Graphics, complex SQL queries (with all kind of joins and groupings, etc.).
• Working knowledge of QlikView  Server, QlikView  Publisher, and QlikView  Enterprise Version.

Environment: QlikView 12, QlikView Server / Publisher, QlikView Management Console, Toad, Oracle SQL Developer, SQL Server, JIRA

Confidential, Reading, PA

Sr. QlikView Developer/ Data Analyst

Responsibilities:

• Involved in Business requirements gathering and Preparation of Technical Specifications documents and Training guides.
• Created mock-ups showing the intended functionality, visual aspects of the dashboards to be developed. Design and Develop Data Model and dashboards using QlikView.
• Worked on data acquisition, integration, modeling and delivery for many Qlikview initiatives.
• Designed and maintained QlikView Applications.
• Created and maintained user guides and documentation for QlikView applications.
• Create / Perform analytics, reporting, dashboard development and data exploration
• Leverage existing enterprise data and information in company's products and services  
• Advanced scripting and Integrate data from multiple data sources into a QlikView Data Model. Optimization of a Data Model for performance Publish and distribute dashboards to users.
• Troubleshoot and fix issues, support QlikView Applications.
• Optimized 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.
• Research and troubleshoot technical problems.
• Developing SET Analysis to provide load Data in QlikView Applications.
• Creating Dashboards with different style using QlikView components like List Box, Slider, charts and Bookmarks.
• Responsible for analyzing data reports to find system bugs, data integrity issues and process issues.
• Developed different user interactive dashboards with complex source systems by extracting data from the database, storing into QVD files, writing complex ETL scripts and developing UI according to business requirements.
• Responsible for training and giving guidance to team for development and maintenance of the above system and reports.

Environment: QlikView 11.2, QlikView Server / Publisher, QMC, Qlik Sense 2.0, VB Scripting, Toad, Oracle SQL Developer, SQL Server, Windows Server 2009, JIRA.

Confidential, San Rafael, CA

Sr. QlikView Developer/ Data Analyst

Responsibilities:

• Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.
• Planned, designed, and developed QlikView BI dashboards and data integration in a highly complex global services environment, interfacing QlikView.
• Used advanced scripting, set analysis, VBScript and JScript macros, advanced aggregation functions and advanced charts for applications.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Created QVD’s & updated on timely basis as database updates.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team
• Created tasks for the auto reload/using create task wizard via QMC for couple of applications and Batch files (on servers) and used them to auto reload the QVW’s while automating the ETL process.
• Using NPrinting - distributed QV reports to right person in different formats at scheduled time with security applied.
• Successfully performed transition of knowledge from onsite to offshore team.

Environment: QlikView 11.2, QlikView Server / Publisher, QlikView Management Console, QlikSense 0.95,Nprinting, SQL Server, Oracle, Toad, Windows Server 2008.

Confidential, Chesterbrook, PA

QlikView Developer/ Data Analyst

Responsibilities:

• Co-ordinated high profile project work streams through iterative methodologies such as Agile/Scrum.
• Executed complete software development lifecycle (SDLC) solutions, including requirements gathering, test planning and execution, design, development, and deployment.
• Produced documentation, presentations, charts, tables and diagrams and conducted reviews for scope, business justification.
• Understanding source systems and Designing Data Modeling and Loading data from multiple data sources.
• Experienced in installing QlikView, maintaining Publisher settings via the control panel, setting up user accounts and maintaining CALs (Client Access Licenses), creating ZFP (Zero Footprint Application or Zero Footprint Client version) of the standalone applications.
• Successfully remediated issues with complex database joins and also refined the query logic in reports without compromising on the reporting results and functionalities.
• Developed various QlikView Data Models by extracting and using the data from various sources like QVD files, Oracle, Excel, and Flat Files.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts.
• Extensively used QlikView Publisher and performed different tasks like repeat tasks, reload tasks and distribution tasks.
• Imported data from different sources like Oracle, MS Access, XML files, QVDs and flat files using OLE DB/ODBC/ and deployed the application on QlikView server.
• Effectively Scheduled QVD reloads on server using Incremental Load and eliminated errors and failures using troubleshoots.
• Implemented Section Access to filter data based on User Privileges.
• Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications.
• Design, Build, Test, Debug the QlikView application in QV Test server environment.
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing)
• Worked on Performance testing of Dashboard and also data validations using independent queries and raw data analysis.

Environment: QlikView 11.2, Windows Server 2007, Oracle 11g, MS Access 2005, MS Office, .CSV Files, QlikView Server / Publisher, QlikView Enterprise Management Console.

Confidential, Rochester, MN

QlikView Developer/ Data Analyst

Responsibilities:

• Analyzed the existing QlikView data model, script logics and the ETL business logic for the existing QlikView applications.
• Imported data from multiple data sources including Web Services, MS SQL Server and MS Excel through OLEDB and ODBC connections and modeling data as per user requirements.
• Participate in enterprise DW / BI strategy/Dash boarding.
• Involved in utilizing QlikView solutions to develop complex reports and executive dashboard.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Creating complex data models without synthetic tables and circular loops.
• Create and manage ETL script generation using QlikView Script Builder Application.
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the application.
• Provided ongoing QlikView consultation to the development team.
• Provide support analyst when internal teams have enquiries and trained business users.
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.
• Extracted information from disparate data sources like excel files, QVD files, flat files, etc. by using different scripts like add, concatenate, resident, concatenate, qualify, unqualify, etc.
• Customized and tweaked the scripts for cross-tables and generic loads and created simple and complex expressions.
• Provided support analyst when internal teams have enquiries
• Research and troubleshoot technical problems Trained and users.
• Mentored and trained Business User Groups on using QlikView Tools.

Environment: QlikView 10, SQL Server, Microsoft Access, Windows 2007, Toad, TFS.

Confidential, Bloomington, IL

SQL Developer/ QlikView Analyst

Responsibilities:

• Experience in designing the layout of the application as per the business requirements of the client.
• Analyzed all business functionality related to back end database interfaces.
• Hands on experience in scripting and creating batch files for automatic running of QlikView scripts.
• Used data from multiple sources including Oracle, SQL Server and flat files (text, excel and xml) to generate QlikView reports.
• Altered the QlikView scripts based on any unusual latency in the response time on the UI.
• Scheduled batch process for reloading the application as per the client’s need.
• Analyzed and designed tables based on small and large database transactions.
• Created materialized views to reduce query run time for the end user.
• Gathering user requirements and designing database accordingly which involves creating logical data model and physical data modeling.
• Used SQL for implementing business rules and do performance tuning procedures.
• Creating many physical objects (table, constraints, index, function) to facilitate the smooth data retrieval
• Designing, developing & fine tuning data-retrieval & data-migration scripts.
• Data conversion from flat file to intermediate tables using SQL Loader and also created control files for SQL Loader.
• Developed comprehensive reports, cross reference listings and statistical reports using Oracle Reports/Graphics, complex SQL queries (with all kind of joins and groupings, etc.).
• Trained End User’s to familiarize with discoverer plus and viewer tool.
• Developed scenarios for unit, integration testing to ensure that all the components work correctly when integrated.

Environment: SQL Server 2000 Enterprise Edition, Windows 2008, UNIX, Excel, DTS, MS Access, T-SQL, Crystal Reports, QlikView, TOAD.

Confidential, Tampa, FL

SQL Developer/ Data Analyst

Responsibilities:

• Developed complex 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.
• 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.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Tested applications, ensuring the application met the requirements, data quality for quality assurance before delivering to the end users.
• Supported multiple clients and responsible for ad-hoc queries which were raised by client users.

Environment: SQL Server 2005, Visual Studio 2005, SSIS, SSRS, SSAS, T-SQL, DTS, XML, Windows 2003.

Confidential

SQL Server Developer

Responsibilities:

• Developed T SQL code for the application.
• Modified the existing database by adding the tables and maintained relationships between the tables.
• Clarified the requirements by talking to the user groups and accordingly modified the functional and technical specifications.
• Developed / modified Oracle PL/SQL codes like stored procedures, functions, triggers etc. based on technical and functional specification documents.
• Developed / modified scripts to create tables, views and executed them using SQL Plus
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Used SQL* loader to load data into the databases.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Environment: MS SQL server 2005, SQL* LOADER, Forms 6i, Reports 6i, Discoverer 10g, XML Publisher.