SUMMARY

• Working in Information Technology for last 7 years. Working for 5 plus Years in Business Intelligence space particularly around QlikView.
• Extensive work experience on complete life cycle of Business Intelligence solutions - from requirements analysis, design, development solutions to implementation and delivery of teh overall project.
• Involved in analysis workshops & end-user interviews
• Installation of QlikView Developer, Server (using IIS as well as QV Web Server) & Publisher along wif teh configuration of teh same.
• Strong expertise in Data Warehouse & ETL design and implementation of teh same using script editor in QlikView
• Design & Developing QlikView Dashboards using various objects & ability to write complex front End scripting and expressions.
• Working on QlikView which connects to multiple data sources (via Oracle, MS SQL Server and MS Worksheets)
• Good expertise in Incremental Load and conditional statement like loops.
• Strong expertise in working wif complex set Analysis, Apply Map, Interval match functions, section access, process chains, Interval match functions.
• Knowledge on Data Warehousing concepts like Star schema, Snowflake, Dimension and Fact Tables.
• Monitoring of data loading through process chains, job status of process chains.
• Result oriented team player wif good communication and presentation skills and has teh drive to learn and implement teh latest technologies.
• Very flexible and can work independently as well as in a team environment.
• Experience in Performance Tuning of QlikView applications.

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows Server 2003/2008, Unix; Solaris, AIX, and Linux

BI Tools: QlikView Developer, Server 11, Publisher 11 SR1,SR2

Data Sources: SAP ECC 6.0, SQL Server 2008, Oracle 10g/11g

Domains: Financial, Banking, Retail

PROFESSIONAL EXPERIENCE

Confidential, Windsor, CT

Senior QlikView Developer

Responsibilities:

• Participated in requirement gathering sessions in interview as well as workshop mode wif teh end-users.
• Installed and configured QlikView 11.1.2
• Created BRD and FRD based on end client requirement discussions.
• Participated in Target data model design & source to target mapping.
• Created mock-up of teh reports & dashboards on Power Point
• Developed ETL Scripts for loading teh data, resolving synthetic keys and loops.
• Developed User Interactive Dashboards & reports such as Profit & Loss analysis, Balance Sheet Analysis, Cash Conversion Cycle, Profitability ratios, Working Capital Analysis, Cash Flow, Contribution analysis, Top-Bottom Analysis, Profitability analysis etc using various QlikView Objects.
• Designed & developed a parallel set of dashboards for teh tablets (iPad) as teh user requirement was to view teh applications in full view mode rather than teh single object mode.
• Deployed teh dashboards to teh QlikView Server.
• Automated teh reloading process using windows Schedulers and Implementing teh Section access.
• Tested teh applications as per teh designed test cases & also as per teh agreed report layout mock-ups.
• Facilitated teh User Acceptance Testing.
• Good Experience in all QlikView functionality and noledge in QlikView sever and publisher.
• Participated in daily scrums meeting as part of teh SDLC process.
• Created documentation related to teh application design and provided system documentation for day to day maintenance of teh application.

Environment: SQL Server 2008 R2, Excel, Windows Server 2008, QlikView 11.2

Confidential, Roseland, NJ

QlikView Developer

Responsibilities:

• Analyzed of teh as-is Sales analysis process drafted requirement documents.
• Created teh gap document & teh business requirement specification
• Set up teh development, UAT & Production environment.
• Designed teh data warehouse required for reporting requirements
• Designed & developed ETL particularly keeping in mind teh rule driven data cleaning to teh extent possible
• Created sales reports & dashboards such as region-wise, product-wise sales trend, Contribution analysis,
• Deployed dashboards on teh QlikView server
• Created test scripts required for testing purposes.
• Performed Unit Testing, System testing, performance testing related to teh QlikView Reports.
• Facilitated teh user acceptance testing
• Created teh end user manual and user training guides required for end users.
• Conducted end-user training for reports developed.
• Provided 24*7 production support for production reports.

Environment: Oracle 10 g,, Excel, QlikView 10.0, Windows Server 2008 R2

Confidential, Providence, RI

QlikView Developer

Responsibilities:

• Analyzed of teh as-is Sales analysis process
• Identified teh future state
• Created teh gap document & teh business requirement specification
• Set up teh development, UAT & Production environment.
• Designed teh data warehouse which had various hierarchies and also different aggregation levels.
• Designed & developed ETL particularly keeping in mind teh rule driven data cleaning to teh extent possible
• Created reports & dashboards such as Sales trend, inventory ageing analysis, store reconciliation, warehouse utilization analysis etc.
• Deployed teh dashboards on teh server
• System Tested teh QlikView applications as per teh test scripts.
• Facilitated teh user acceptance testing
• License allocation & Server administration
• Created of teh end user manual
• Conducted end-user training

Environment: SQL Server 2008 R2, Excel, XML, CSV, QlikView 9.0, Windows Server 2008