SUMMARY

• Over 8 years of experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence applications using Qlikview.
• Strong knowledge in designing and developing Qlikview andQlikSensedashboards by extracting data from different sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files.
• Worked installation & configuration, environment, system analysis, design, deployment, testing of projects.
• Experience in optimizing Qlikview andQlikSenseapplications to improve teh performance.
• Developed Qlikview andQlikSenseobjects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons.
• Proficient in troubleshooting and fixing teh Qlikview andQlikSensedashboard issues.
• Extensive Knowledge in creating Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating teh jobs in NPrinting Server.
• Hands on experience in customizing teh Qlikview and N Printing reports as per teh business requirements.
• Created incremental load process to load teh data into Qlikview applications from different source systems.
• In - depth knowledge and understanding of data warehousing concepts, ETL, OLAP, OLTP, Cubes and normalizations to translate business requirements into TEMPeffective business intelligence solutions
• Involved in Performance Tuning and Deployment of Qlikview andQlikSenseapplications.
• Hands on experience in Qlikview advanced features like Alternate States and Direct Discovery.
• Worked in Agile methodology environments and involved in scrum meetings.
• Experience on Qlikview Scripting, Set analysis and Section Access.
• Scheduled teh jobs and distributed to end users from QMC.
• Trained end users to develop and use Qlikview andQlikSenseapplications.
• Involved in Onsite-Offsite coordination in delivering Business Intelligence Solutions.
• Understanding of data modeling, dimensional & relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables; experience in Extract, Transform and Loading process of data.
• Created detailed design, development, testing & migration documents and performing Proof of Concepts (POC).
• Delivered all teh projects and assignments within teh specified time lines with accuracy.
• Strong ability to work within a demanding and aggressive project schedules and environments.

TECHNICAL SKILLS

Reporting Tools: Qlikview 9.0 10/11/12, QlikView Publisher, ETL QlikSense 1.10,2.0

Languages: C, C++, Java, PL/SQL, XML, JavaScript, CSS, JAVASCRIPT .NET, AngularJS, HTML/CSS, Hadoop, Ruby On Rails, Shell Scripting

Data Modeling: Dimensional Data modeling,Star join Schema modeling,snow Fake Modeling,FACT and dimensionas table,Physical and Logical Data modeling

Databases: Oracle 10g/9i/8i, SQL Server, Salesforce, SAP

Operating Systems: Windows, Unix

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

Qlikview Developer

Responsibilities:

• Designed and developed Qliksense/Qlikview applications from scratch, to support reporting and Business Intelligence initiatives.
• Collaborated with business leaders to gather requirements and developed POC based on requirements
• 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.
• Generate new QVD files created by ETL logic to feed QlikView applications.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
• Developed Variables, input boxes, extensively alerts and calendar
• Implemented Star Schema and Snowflake schema
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity).
• Written complex expressions using Set analysis and variousQlikview/Qliksense functions
• Implement Actions/Triggers in theQlikviewinterface.
• Analyzed teh existing QlikView data model and script logics for teh existing QlikView applications.
• Used master calendar for time related dimensions and a strong source control methodology for tracking changes.
• Analyzed and developed Best practices for data management and Extract, Transform, Load
• Drill Information by creating Groups/Cycles inQlikView
• Involved in Deployment of QlikView/QlikSense Applications into teh server.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version
• Mentoring Business User Groups.
• Entitlement and data level security for dashboard using SECTION ACCESS
• ImplementedQlikviewdashboards distribution to business users using Section Access to dashboards, providing CALs to documents

Environment: Qliksense3.2, QlikView12, flat files, SQL Server, Oracle, Tera Data, MS Access 2007, MS Excel 2007

Confidential, Atlanta, Ga

Qlikview Consultant

Responsibilities:

• Worked on requirements documents and design documents for teh dashboards and reports
• Worked on dashboards for Sales force activities, Account calls, performance
• Created multi - layer data load scripts inQlikview.
• Wrote teh extract layer, transformation layer and presentation layer scripts
• Had worked on conditional show for different charts and using buttons inQlikview.
• Created Master calendar for teh Time dimension. Resolved synthetic keys, resolved loops
• Developed and designed teh dashboards with different types of charts inQlikview.
• Designed visualizations like bar chart, line chart, combo chart. Created Drilldown and Cyclic groups
• Used Set analysis to perform data comparison for current vs previous years
• Involved in testing and code review.
• DeployedQlikviewdashboard on teh Server
• Managing and updating QVD files and dashboards. Interacting with business users resolved user’s queries.
• Created mockup dashboards on QlikSense to show how TEMPeffective it is in decision-making.
• Created maps using NPGeoMapQlikviewextension object and for different regions along with their sales.
• Worked on documentingQlikviewenvironment

Environment: Qlikview11.2, QlikSense,QlikviewServer/Publisher, Oracle 10g, MS-Word, MS-Excel, SEIBEL Compass system

Confidential, Deerfield, IL

Qlikview Developer

Responsibilities:

• 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.
• Qlikview11 implementation and integration.
• Involved in utilizingQlikviewsolutions 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.
• DevelopedQlikviewapplications creating expressions using set analysis.
• Created and scheduled Complex reports by leveraging teh basic components ofQlikview.
• Involved in organizing meetings to know teh needs of clients for teh Enterprise solution implementation.

Environment: Qlikview11, Qlikview Publisher/Server, Windows 2003 Server/XP, SQL Server 2008, MS Visual Studio, MS Access 2007, MS Excel 2007

Confidential, Durham, NC

Qlikview Developer

Responsibilities:

• Involved in gathering and documentation ofQlikViewapplication requirements from end users.
• Analysis teh business requirement and collect teh necessary information for Dashboard building such as Database objects from EDW team, UI design requirement from users.
• Involved in teh writing scripts for extracting of QVD's for different cuts of data.
• Expertise in writing complex Set analysis for teh KPI calculation in teh Dashboard.
• Expertise in building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Extracted information from different data sources like Oracle, Teradata and flat files, etc by using different scripts like add, concatenate, resident, qualify, unqualify, etc
• Expertise in defect solving for teh Dashboard during teh QA testing.
• Involved in publishing of teh dashboard to teh users usingQlikviewPublisher.
• Working knowledge ofQlikViewServer,QlikViewPublisher, andQlikViewEnterprise Version.
• Implemented session access to enterprise level document.

Environment: QlikView10 SR4, Teradata SQL Connector, Windows 7, Windows Server 2003.

Confidential

SQL BI/ Qlikview Developer

Responsibilities:

• Created, manipulated and supported teh SQL Server databases.
• Involved in teh Data modeling, Physical and Logical Design of Database
• Documented teh requirements and prepared various Business Requirement Documents.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Used stored procedures and triggers to implement business rules.
• Helped in integration of teh front end with teh SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Imported & Exported data from one server to other servers using tools like Data Transformation Services(DTS)
• Explored teh use of User Defined Functions to encapsulate commonly used logic in teh stored procedure and maximized teh readability of such Stored Procedures.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored teh performance of teh Server.
• Handled development and production support, document reviews, test plan, integration of teh system.

Environment: SQL server, Jupiter, Windows NT, UML, DTS, Query Analyzer, SQL Profiler

Confidential

SQL Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and views using T-SQL in Development and Production environment
• Fine-tuned teh logic in Procedures, Functions and Triggers for optimum performance
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Wrote Transact SQL utilities to generate table insert and update statements
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures
• Migrated DTS packages to SSIS Packages
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Wrote T-SQL procedures to generate DML scripts dat modified database objects dynamically based on user inputs
• Created Stored Procedures to transform teh Data and worked extensively in T-SQL for various needs of teh transformations while loading teh data

Environment: SQL Server 2008, DTS/SSIS, HTML, Java Script, VB Script