PROFESSIONAL SUMMARY:

• Around 8 years of extensive experience in IT with strong understanding of Business Analyst, Business Intelligence, Decision Support Systems and Software Development specifically using QlikView platform.
• Extensive experience in QlikView tools (Data modeling, designing dashboards, Report designing and Performance Tuning using QlikView)
• Extensive experience in QlikView with extensive hands - on experience in Design, Development, Analysis, Server, Publisher.
• Extensive experience in Data Analysis, including cleansing, penetration and Top sheet production and using statistical functions.
• Experience in all aspects of SDLC right from Requirement Gathering, BRD, Prototyping, Design, Development, Testing, and Deployment with effective communication.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.  
• Experience in Database structuring, database application design & development, Entity Relationship Modeling (ERM), Data export/import, SQL programming & ETL procedures.   
• Experience in implementing various levels of File/Document and Data level Security.  
• Strong knowledge of best practices in QlikView e.g. QV’s frontend backend architecture, QlikView Management Console and N-tier project architecture.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.  
• Extensive experience in QlikView Scripting using with best practices, used to create complex data cleansing, transforming functions for achieving an effective data model.
• Experience in Incremental Loading & QlikView document Versioning.
• Implemented Section Access, Binary Loads and abstracting the data layer using QlikView library and QVX files.
• Extensive experience on designing Dashboard UI and layouts, Themes and Color Palettes etc.
• Excellent analytical, organizational, planning skills with demonstrated abilities in training & mentoring the team towards achieving organizational goals.
• Extensively worked on some of the available extensions Objects such as QlikMap, Org Chart, and Whisker Pie etc.
• Scheduling the automation of QV jobs using Qlik View/Qlik sense Management Console.
• Implemented Dashboards with features such as Comparative analysis, Extensive Set Analysis, Consolidation of variables in External file etc.
• Extensively used various Qlikview Scripting and UI functions such as aggr, rank, range sum, first sorted value, apply map, match, con-cat, numeric and date functions, etc.
• Extensive use of Excel Functions to get cleaning up the data & maintain smooth recovery of the system.
• A great team player, self-starter, can work effectively within a group or as a stand-alone environment.

TECHNICAL SKILLS:

QlikView: QlikView Development (Version 9.0/10/11), QlikView Server (Version 9/10/11), QlikView Publisher, Qlik Sense 1.10, 2

Other Business Intelligence: Business Objects XIR2/3.1, Crystal Reports XI/2008

Databases/ DB Tools: SQL Server 7.0/2000, Oracle 8i/9i/10g/11g, Sybase 7.x/11/12, DB2, Teradata, MS Access.

Programming Languages: QlikView Scripting, SQL, HTML.

Front end tools: Microsoft Project, MS Visio, HP Quality Center

MS Office Tools: MS Outlook, MS Word, Ms Excel, MS Access, MS PowerPoint,

Operating Systems: Windows 98/2000/XP/Vista/7, Mac OSX

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway, NJ

Sr. QlikView Developer

Responsibilities:

• Worked as a liaison between Business and technical teams.
• Designed and developed end-to-end QlikView project from inception to release. 
• Created mock-up dashboards during the initial phase of the projects to set expectations and discuss various possibilities.
• Gained experience in creating mobile friendly applications using QlikSense.
• Employed D-A-R methodology for UI Design and agile iterative technique for incremental development of projects.
• Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule ad-hoc reports by leveraging the basics components of Qlikview script editor. 
• Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data. 
• Created and managed ETL script generation using Qlikview Load Script and SQL.  
• Performed different tasks like scheduling QlikView reload cadence and management of distribution
• Groups in QMC.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Created 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. 
• Presented Qlikview applications to various levels of user.
• Designed application for Finance and Sales & Marketing teams with various KPIs/ metrics to track. 
• Researched and troubles hooted technical problems thereby providing an ongoing Qlikview consultation to the rest of the development team.
• Acted as a support analyst when business teams had enquiries and trained end users on need basis.

Environment: Qliksense 2.0, QlikView 11.2/11, QlikView Informatica Connector, Oracle10g, DB2, MS SQL Server 2008, Toad, Informatica 9.0., Windows 2008 R2, Excel, MS Access, Flat files  

Confidential, Atlanta, GA

QlikView Consultant

Responsibilities:

• Actively participated in requirement gathering working closely with business users and Stakeholders.  
• Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.  
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, Informatica, binary QVW, Inline & txt files in creating the QlikView dashboards.  
• Extensively worked with QlikView functions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD file by writing scripts in QlikView applications.  
• Built several Dashboards with current year statistics and trending information with ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.  
• Implemented extension objects like heat map and work cloud. 
• Worked on Publisher to Automate and scheduled daily/weekly/monthly data loads of QVW documents and error notifications by email to assigned users. 
• Closely worked with the release management team to facilitate smooth deployments of QlikView documents in addition also helped with database administration and development.
• Created mockup dashboards on QlikSense to show how effective it is in decision-making.
• Installation of IE plugins and worked with business analysts to train the end users to use the reports effectively to build and customize their ad-hoc reports.
• Trained a team of users on QlikView in terms of best developing and design practices and general “how to” procedures.
• Worked with QlikView administrator to optimize QlikView performance and setup of new QlikView infrastructure.

Environment: QlikView 11/10, QlikSense, Oracle 9i/10G/11G, SQL Server 2008, Access, CSV Files, Windows 2008 Server, SharePoint.

Confidential, New York City, NY

QlikView Developer

Responsibilities:

• Involved in User requirements and Documentation and Dashboard Prototypes.
• Created various dashboards using different kind of charts - Bar, Line, Combo, Scatter, Grid, Block, Spider, Pivot and Crossable.
• Written complex expressions using Set analysis and various QlikView functions.
• Build sales dashboard for secondary / distributor’s network.
• Including analytics for on CRM data, trend analysis, performance analysis for sales reps, after sales service dashboard, part supply chain management, JIT dashboard for logistics.
• Create a robust model by adding multiple source of data from Sales Data warehouse and CRM.
• Create a significant Analytics to find out Assortment and commissioning no. of different model parts which are laying unused in the assembly line after testing release of the cars.
• Developed data model to reflect a Start model after translating various sources into Dimension and Facts.
• Eliminated all Synthetic keys and Circular References in order to make data model efficient.
• Implemented tasks to schedule QVD generation and Dashboard refreshes at regular intervals and appropriate dependencies.
• Involved in QMC Administration, Server/Publisher installation and Configuration.
• Implemented Data security using Section access and Publisher Data Reduction.
• Create KPI’s on comparative analysis by using Alternate State functions for different car variant.
• Developed QlikView Reports for PDF Distribution via Email.
• Involved in the entire lifecycle of QlikView Dashboards.
• Involved in Testing Dashboard data using extensive SQLs, Excel Pivots and Mappings.

Environment: QlikView 9/10, Oracle 10g, Access, XML Files, MS Excel, Windows 2003 Server, Crystal Report.

Confidential, North Wales, PA

BI/QlikView Developer

Responsibilities:

• Data churning and input XLS creation for more informative data element.
• Making Proof of concept to justify the value for the Analytics.
• Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications.
• Engaged in developing Dashboard standards such as Template excel designs for end users.
• Directly worked with End Users to understand their requirements, worked on Demo of Prototypes.
• Developed elegant and professional looking excel reports and charts using different charts and techniques.
• Coordinated with Database and ETL teams for Data and Structural follow-ups and Design.
• Created complex expressions using Excel based advance function like Trend, Slope and other statistical function.
• Developed TOP sheet based on Historic data aligned to unstructured excel data and various Data systems.
• Used extensive amount of V-Lookup and H-Lookup
• Used SSAS to get more data insight by creating Cubes.

Environment: Oracle 9i/10G/11G, SQL SERVER 2005, XLS Files, Windows 2008 Server.

Confidential

BI Developer

Responsibilities:

• Worked very closely with upper management to get detailed information on what information they require in each report.
• Developed several transformations in the process of building Data warehouse database.
• Used server jobs to Extraction, Transformation, and Load.
• Analyzed and designed source code documentation for investment Data Warehouse.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse
• Created Universes, Reports, and Linked with existing Universe, Resolved Loops and Traps.
• Created Daily, Weekly, Biweekly and Monthly drill down reports using Business Objects.
• Trained business users to use Web Intelligence to create ad-hoc reports as well as view existing published reports.
• Scheduled reports using Broadcast Agent for refreshing.
• Tested the project on Business Objects 5.1 to make sure that it still functioned correctly.

Environment: Business Objects 6.5, SQL server, Windows.