SUMMARY

• 6 Years of progressive IT experience in Data Warehousing and Business Intelligence application development
• 5 Years of experience in QlikTech products: QlikView /QlikSense / NPrinting / Extensions
• Specialized in object - oriented design and analysis with experience in SDLC full life cycle design process including requirements definition, design, testing, migration and support.
• Proven QV Team Lead Experience of leading end to end QlikView projects and maintenance in coordination with other developers
• Expertise in handling multiple data sources through designing of data elements/objects and Data Modeling in QlikView
• Strong fundamentals of in-memory contextual data modeling techniques utilizing star and snow flake schemas
• Good Knowledge of Agile - QlikView specific software development life cycle and KPI creation
• Experienced in QlikView Server and Publisher to schedule and automate tasks and publish applications or PDF reports to appropriate users with relevant data
• Advanced knowledge of hands on Section Access, Set Analysis, SQL and QlikView Scripts development
• Experience in recognizing and understanding the various design models, including UML diagrams, detailed design entity-relationship (ER) diagrams and data flow diagrams and translating the same into efficient QlikView script
• Strong knowledge of Set Analysis, Advanced front end aggregations and resolving synthetic keys and circular references using Link Table
• Strong Expertise in Optimizing existing QlikView Dashboards with a focus on usability, performance, long-term, flexibility, and standardization.
• Strong knowledge in metadata management using QlikView monitoring applications like Governance Dashboard (QV11) and MetaScanner application (QV10)
• Strong knowledge in performance tuning of several QlikView projects and apps using lean approach and delta load strategies
• Expertise in problem-solving and trouble-shooting capabilities, creation and implementation of KPIs, deliveries as per business requirements.
• Trained business users on QlikView report functionalities for their analysis.
• Experience in monitoring, debugging and troubleshooting data issues.
• Strong Communication & Management skills with Excellent Role playing capabilities.

TECHNICAL SKILLS

BI Tools: QlikView 8.5 - 11.x, Sales force

ETL: Qv Tier 1 Scripting, OLAP Modeling

Database: Oracle, MS SQL Server

Languages: SQL, HTML/XML, C&C++, R

Operating Systems: Windows, Windows Server, Mac OS

PC Applications: MS Office Suite (including Advanced Excel), MS Access

Domain: Health, Finance, MIS

PROFESSIONAL EXPERIENCE

Qlikview designer/developer AND ADMIN

Confidential, Green Bay, WI

Responsibilities:

• Develop and deploy QlikView reporting and analytics applications to end users
• Collaborated with Business users and cross functional teams to develop Business Requirement Documents (BRD), define KPIs (Key Performance Indicators), and identify data sources.
• Worked with Business Analyst and the Business users to identify the user requirements, business reporting needs, layout, and developed the architecture of prioritized reports
• Designed and Developed executive dashboards in QlikView and delivered through the web to measure the performance of the business with analytical capabilities.
• Acted as a Team Lead on assigned QlikView projects to work with 2-3 more developers
• Imported and integrated data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files dumps using OLE DB/ODBC
• Design user friendly dashboards using the various sheet objects: Current selection, list boxes, search, Straight table, Pivot table, Bar chart, Line Chart, Pie Chart, Combo chart and so on as per the requirement.
• Design, Build, Test, Debug the QlikView application in QV Test server environment
• Worked on modeling data as per business requirements to Eliminate Synthetic keys, ambiguous relationships and closed loops
• Wrote detailed description of user needs for developing and modifying computer applications, developed application prototypes, and provide technical support to project teams, members, and associations
• Interactions with cross functional teams to ensure quality and on time delivery of applications
• Implemented Macros, SET ANALYSIS to provide custom functionality in QlikView Apps
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher
• Provided necessary maintenance support of the application
• Worked on generating and bursting PDF reports using QlikView’s native reporting functionality
• Exposure to N-Printing tool
• Build multiple layers of QVDs, created transformations, build hierarchies and so on
• Building relationships with cross functional teams
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support

Environment: s: QlikView 11.2, NPrinting, Extension Objects (implementation only), SAP, Oracle, SQL Server 2008, and limited exposure to QlikSense

Qlikview developer / DATA ANALYST

Confidential, Franklin Lakes, NJ

Responsibilities:

• Designed Frontend objects like Line, Bar, Pie, Straight, Pivot Tables and other sheets objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Kept an active participation in business requirement and design review session as well as kept a close interaction with other developers/designers
• Pulled data from multiple databases and built a data model by removing circular loops and synthetic tables.
• Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using QlikView Management Console
• Wrote SQL Scripts with preceding Loads to extract relevant data in QlikView Applications
• Performed analytics as per the requirement using advanced charts and tables
• Designed graphs and visuals to summarize data, identify outlying data points, and perform other exploratory data analysis
• Used appropriate functions like Apply Map, Resident Load, Concatenate, Variables and so on.
• Extensively worked with advanced scripting, set analysis, VBScript, as well as advanced aggregation functions
• Used functions Date and Time, Keep, Join, Mapping, and String & input Fields etc.
• Created User Conditions and Filters to improve application user experience
• Effectively identified and troubleshot any technical issues.

Environment: s: QlikView 11, Oracle 10g, MS SQL Server 2008,Flat files, MS Excel, Windows Server

Qlikview DEVELOPER / Financial BA

Confidential, New York, NY

Responsibilities:

• Designed an application using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date object.
• Developed KPI’s and set analysis applications
• Experience in QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc..)
• Migration from QlikView Enterprise v9 to QlikView v10.
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications.
• Implemented Security & involved in Deployment of QlikView Applications.
• 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.

Environment: s: QlikView 10 Enterprise, SQL Server 2008, Microsoft Visio, MS-Access

Qlikview developer

Confidential, San Jose, CA

Responsibilities:

• Worked with complex front end scripts and expressions, integration of data sources and advanced Dashboard development
• Based on analytical/reporting needs built Data model in QlikView by analyzing different data sources
• Developed QlikView scheduler dashboard which facilitates development team to view status of their data refresh
• Most of my designed data models were based star schema and sometimes snow flake schema.
• Enterprise wide QlikView Server Administration which includes QV server maintenance, QV Publisher maintenance, and License Management
• Migration of QlikView servers and publisher to newer version
• Developed QlikView dashboards which aids QlikView server admin team to monitor enterprise wide QlikView servers in a single dashboard
• Perform code review of QlikView applications developed by different business areas to adhere best practices
• Implemented section access which prohibits users from viewing other’s data
• Manage security for all QlikView applications. Assist developers with troubleshooting and offer development improvements

Environment: s: QlikView 8.5/9, MS SQL Server 2005, Oracle Exadata, Teradata, MySQL

Qlikview DESIGNER / SQL DATA ANALYST

Confidential, McLean, VA

Responsibilities:

• Developed QlikView Dashboards using Chart Box (Bar, Line, Combo, Pivot, and Straight etc.), List, Input Field, Table Box, Groups, and Container...etc.
• Deployed the Accounting application, which prepares the income statements, general ledger, tracks budget vs. forecast and produces other custom report.
• Actively participated in full life cycle of QlikView application implementation and was responsible for Design, Development and Delivery.
• Developed Dashboard application prototypes after analyzing the requirements.
• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).
• Tested applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users
• Involved in Production Support for various applications.
• Performed failure analysis using Error logs
• Conducted end user training sessions and prepared the training documentation
• Create and manage the ETL script generation using QlikView Script
• Creating complex data models without synthetic tables and circular loops
• Identified and remediate issues and risks that impact the performance and reliability of the QlikView solution

Environment: s: QlikView 8.5, Excel Reports, MS SQL Server 2003, SQL

Business/Systems Analyst

Confidential, Canonsburg, PA

Responsibilities:

• Acted as a liaison between the business, data and the technical teams throughout the project lifecycle.
• Extracted the businessrequirements from various sessions with business leads.
• Created activity diagrams, use case diagrams, sequence diagrams, collaboration diagrams and data flow diagrams in UML using Rose and MS Visio.
• Involved in User Interface (UI) analysis with the businessteam to validate accuracy.
• Involved in requirement gathering including interviews, brainstorms and meetings with stakeholders and created requirement specification artifact (SRS's and SDS's).
• Made sure every team member follows all the stages of SDLC and adheres to all Quality processes.
• Assisted in Scheduled meetings with developers, system analystsand testers to collaborate resource allocation and project completion using MS Project.
• Used M.S SharePoint to stay connected and be more productive by providing access to the team.
• Partnered with the technical team in research and resolution of system development issues and process problems.
• Conducted User Acceptance Testing (UAT) and verified performance, reliability and fault tolerance issues.

Environment: s: MS Office Suite, Oracle 8i/10g, SQL, UML, SDLC Methodologies