SUMMARY

• Experience in designing & developing QlikView dashboards using various objects & ability to write complex front end scripting or expressions
• Proficient in creating QV data models, QV objects, reports, graphical interactive UI and dashboard using different data sources like Teradata, SQL Server, Web Services, Sales Force, QVD files, Access, text files, excel documents etc
• Experience with 3 Tier implementation of QlikView projects as a standard best practice methodology
• Excellent knowledge in implementation of QlikView security by authentication, authorization at document level and data level to the end users
• Expertise with QlikView sheet objects like Straight tables, Pivot tables, Containers, Line and Bar charts, scripting and building qvd’s and qvw’s
• Experience inQlikViewServer and Publisher - Creating scheduled jobs for QVD extracts and report reloads
• Extensive experience in conducting GAP analysis, Risk analysis, Cost Benefit Analysis, creating Traceability Matrix along with good knowledge of process workflow tools and techniques
• Expertise in writing requirement documents including Business Requirement Document (BRD), Functional Requirements Specifications (FRS), Non-Functional Requirements Specifications, Use Case (Business and Application) and Systems Design Specification (SDS)
• Hands on experience in working on projects involving various Software Development Life Cycle (SDLC) models such as Waterfall, AGILE (SCRUM), and industry specific hybrid models
• Expertise in ETL (Extraction, Transformation & Loading), Data modeling, Report designing and Performance Tuning using QlikView
• Strong understanding of Dimensional Modelling Technique, multi dimensional database Schemas like Star schemas and Snowflake Schemas
• 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
• Excellent analytical, organizational, planning skills with demonstrated abilities in training & mentoring the team towards achieving organizational goals

TECHNICAL SKILLS

Tools/METHODS: QlikView11/10/9, TableauSQL Server 2005/2008/2012ORACLE 8i/9i/10gMS-Access7.0/2000Teradata 13/12, Erwin, Sharepoint, Control M Scheduler,PL/SQL, SQL*Plus

Microsoft office: suite/Visio, Java, HTML, XML,Jira

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. BI/QlikView Developer

Responsibilities:

• Worked with business analysts and the business users to identify the user requirements, business reporting needs, layout, and developed the architecture of prioritized reports
• Identified various KPI’s with business users and analyzed existing reports
• Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the UI to make it more accessible to user community
• Automated and scheduled daily load of QVW documents using Qlikview Publisher and notified load status by sending emails of daily and weekly reports
• Created batch scripts to process the data periodically as per the business requirements
• Implemented security using QlikViewsection access that dynamically hides selected areas of the dashboard depending upon user privileges
• Created complex Qlikview scripts to build models and support various KPI Information
• Developed QlikView applications based on incremental load transactions using QVD files
• Wrote the scripts for transformation layers (Tier-2) to optimize the data model by removing synthetic keys or circular references.
• Wrote scripts for the necessary computations to avoid substantial expressions or calculations in the UI
• Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression
• Established a standard structure for test and working files(QVW) and version controlling to maintain parity between dev, production and test environment
• Implemented 3-Tier architecture (Data-Extract, Data-Modeling and Application Development)
• Added prompts and filters to modify existing reports to accommodate change in user requirements
• Maintained Server for smooth QlikView development, assigned task, path and triggers for QMC
• Involved in deployment process of all the reports from development to production server
• Performed detailed documentation of design, development, testing and deployment activities

Environment: QlikView 11.2 SR8, SQL SERVER 2008/2012, Windows server 2008 R2, SSIS Package,Salesforce

Confidential, Newyork, NY

Sr. QlikView Developer

Responsibilities:

• The project was about Phoenix funding which includes Balance funding, Counter-party reports, Bookings, Revenue, P&L Reports, HR Reports
• Designed and Developed QlikView dashboards using Chart Box (Drill Down & Cyclic Groups), List, Input Field, Table Box and extensions meeting the business requirements
• Customized and tweaked the scripts and necessary data transformation, created simple and complex expressions using Set Analysis
• Wrote scripts for incremental load to generate qvds with updated data from the database in different scenarios like - (insert, update) and (insert, update and delete)
• Eliminated synthetic keys using QVD concatenation and/or Qualify statemenmt based on the nature of synthetic key
• Assigned row level and document level security using Section Access
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting
• Generated new QVD files from the EDW by writing scripts in QlikView applications
• Converted business requirements into technical specification and designed for reporting Database/data mart and Adhoc/standard reports using QlikView
• Worked with Relational Databases - Teradata and DB2 and involved in ETL team discussions for Data conversion
• Implemented multi-level hierarchies such as Measures Fact, Customers and Time Dimension
• Developed work estimates for assigned tasks, assessed constraints and dependencies
• Provided technical support on day-to-day basis and troubleshoot installations

Environment:QlikView 11.2, Teradata 13, DB2, Windows server 2003/2008, HTML, VB Script & Java Script, Jira

Confidential, Austin, TX

BI/QlikView Developer

Responsibilities:

• The project was related to Marketing analytics, concern about various marketing methods and accepted patterns by various customers across verticals
• Performed redesign of the existingQlikViewBI associative model to improve availability, scalability and performance by eliminating Synthetic keys and Circular Loops in the data model
• Understood the requirements and implemented various types of prototypes as per the client needs
• Created Heat map with alert mechanism, various KPI Graphs were drawn using best practices
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions
• Generated various Grouped Reports, Cross-tab Reports, Chart Reports, and Drill -Through Reports
• Created weekly PDF reports for a set of users using Loop and Reduce functionality in QV Publisher
• Extracted data from multiple hierarchies from cross table, flat files and machine data
• Created and maintained OLE DB/ODBC connections for all environments
• Worked onQlikViewServer and Publisher to automate theQlikViewjobs and define the user security
• Wrote scripts and created batch files for automatic running of Qlikview scripts
• Upgraded QlikView Server from QlikView 9.3 SR3 to QlikView 10.0 SR3

Environment: QlikView 10.0/9.3, MS Excel, Teradata,Oracle 9i/10g, PL/SQL, UNIX, salesforce

Confidential, Libertyville, IL

QlikView Developer

Responsibilities:

• Worked with Business analysts and the Business users to understand the user’s requirements, layout, and look and feel forthe application to be developed
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and Publisher
• Developed two dashboards and served to track all the way from Ship to Final acceptance phase, which include Installation, Field STR, Pre-Warranty Aging etc; Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms
• Participated in pre-sales activity working with prospective client, assisting with Technical contributions to win new business
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources
• There were 4 million records with incremental loading of 10,000/week
• Tuned SQL queries to improve the application and reports performance.

Environment: QlikView 10.x/9.3, MS Excel, SQL Server 2005, Windows 2003 Server

Confidential

Business Systems Analyst

Responsibilities:

• Participated in the creation of Functional Requirement Document (FRD) and Business Process Workflow with Stakeholders
• Worked with stakeholders on Joint Application Development (JAD) during prototyping phase of System Development Life Cycle (SDLC)
• Worked with SCRUM Project Management and Agile Methodologies for Software development Life Cycle
• Conducted GAP analysis of the different reports that are being presented to clients to accommodate their requirements for the new enhancements
• Utilized Rational Unified Process (RUP) to configure and develop processes, standards, and procedures
• Worked with QA team to develop performance test cases based on projected user load
• Involved in all stages of testing process - Development of Test scripts and Test cases for Functional Testing, Integration Testing and support for User Acceptance Testing
• Used Rational tools to document and manage requirements, enhancement requests, and other documentation issues for the application
• Worked closely with the development team to understand functionality, resolve issues and provided feedback for the UML diagrams.
• Performed tuning and optimization on SQL queries

Environment: MS Office (Word, Excel, Power Point),Java, MS Visual Studio 2008, Share Point,ERWIN, MS Visio,Microsoft Outlook