PROFESSIONAL SUMMARY:

• 11 Years of Business Analysis and Design/Development/implementation experience in Business Intelligence (BI), Data Analytics, Data Modelling & Data Visualization Solutions using QlikView, Qlik Sense, Cognos.
• BI / Data Analyst and Technical Lead with Various domain exposures in Banking / Finance, Insurance, Health Care, Retail, Automobile
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Contributed as individual contributor at Client Location & worked as Onsite/Off - Shore model
• Good experience on implementation of BIDW Life-cycle Projects with Agile (Scrum), Waterfall, Iterative methodology
• Strong experience with Dimensional Data Modeling and creating Star Schema / Snowflake Schema
• Around 4 Years of experience in working with QlikView / Qlik Sense, Qlik Management Console(QMC), Qlik Sense Cloud, Customization of Qlik Sense Dashboard using Java Script, JSON, XML code
• Hands on Experience with Qlik Architecture in Design, Development, Deployment and Migration along with Qlik Server and Publisher
• Mastery of QlikView / Qlik Sense charting, Set Analysis, Variables, Templates, Incremental Load and building/deploying Section Access.
• Strong knowledge on QlikView / Qlik Sense server architecture, building QVDs and QVWs applying business rules and data validations.
• Expertise in Creating Dashboards using various QlikView / Qlik Sense Sheet objects and using different data sources like Oracle, SQL Server, QVD files and excel.
• Involved in Admin activities like User Access, Deployment & Monitoring of Dashboards
• Key Member of BI Practice with participation in various RFPs, architecture reviews, Estimation, Capacity Planning & Staffing requirement of a new project.
• Working as Business Analyst (BA) role as requirement gathering, Client-interfacing, creating Technical, Functional and Non-Functional Requirement documents, High Level and Detailed Design Documents, Master Test Plan, User Guides and involved in Change Management (CR) & UAT process.
• Extensive exposure in various Cognos platforms.
• Good knowledge on overall ETL process & Tableau Development
• Conducting Training activities on QlikView, Qlik Sense & Cognos

TECHNICAL SKILLS:

Qlik Tools: QlikView 11x (QlikView Desktop, QlikView Management Console), Qlik Sense 2x / 3x

Tableau Tools: Tableau 10x / 9x (Tableau Desktop & Tableau Server)

IBM Cognos Tools: Cognos 10x / 8x (Report Studio, Framework Manager, Dynamic Cube, Transformer)

Database: Oracle 9i / 11g, SQL Server 2008, Teradata, DB2

Others: ServiceNow, HPQC, Project & Portfolio Management (PPM), JIRA, Toad, SVN, PVCS

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

QlikView / Qlik Sense Development Lead

Environment: QlikView 11.2 SR8, Qlik Sense 3.1, Qlik Management Console, Oracle 11g, SQL Server 2008

Responsibilities:

• Responsible for requirement gathering, analysis of the functional specifications, design reports / dashboards & involved in successful deployment.
• Participate in Capacity Planning, Estimates, Staffing requirement.
• Facilitating client meetings, project review and working closely with Onsite/Offshore team to ensure successful completion of on-time project deliverables.
• Involved in Code review, Unit Testing & mentoring the team on need basis
• Maintained Version control using SVN
• Key member in set-up multiple environments like DEV, QA, UAT & PROD
• Participating & Demo to client for User Acceptance Testing (UAT)
• Estimate New Development & Change Request (CR) with Impact Analysis
• Designed & Developed 3 tier Data Architecture
• Created QVDs & updated on timely basis by using Incremental Load
• Developed Linked Tables, Concatenation (Resolving Synthetic Keys, Loops & model ambiguity).
• Used various scripting functions to improve the performance
• Developed QlikView Dashboards using various Charts with added functionality like Drill Down, Drill up & Cyclic Grouping, Pivot Table, Input Field, Table Box
• Developed Qlik Sense Dashboard using Templates, Master Library items and Story Generation
• Maintaining the Dashboard in Qlik Sense Cloud
• Customization of Qlik Sense Dashboard using Java Script, JSON, XML code
• Developed KPI’s, Set Analysis, Variables and implemented triggers/macros to provide custom functionality in Dashboards
• Involved in re-designing of Dashboards based upon User feedback
• Scheduled & Distributed QVDs and Dashboards in Server level
• Involved Admin activities like User Access & Deployment in QMC.
• Fully involved in the Release Management process & monitoring for successful deployment

Confidential, New Jersey

Qlikview / Cognos Developer

Environment: Qlikview, Qlik Sense, Cognos, Dynamic Cube, Transformer, Oracle

Responsibilities:

• Understanding Business Requirements by interacting with the client directly and preparation of SRS.
• Developed the Project Plan, Delivery Strategy, Test Plan and Implementation Planning of project.
• Participated in design reviews of prototypes (POC) that align with our business requirement
• Implemented best practices for Data Modelling in FM and Qlikview scripting
• Review User Manual and provide support in Warranty phase
• Creating Various Objects in QlikView such as Straight Table, Pivot Table, List box, Statistics box, Multi box, Table box, Charts, Input box, Current Selection box, Button etc...
• Using Set Analysis to filter data into business logic.
• Security implementation using Section Access in QlikView.
• Reload Documents and Deploy Applications through QlikView Management Console in Development for verification.
• Created Cognos Dashboard from multiple data sources using various Charts with added functionality like Drill Down, Drill up, Prompts and List etc.
• Developed Dynamic cubes for high volume data
• Designed & Developed Transformer Models & Published Power play Cube to Cognos Connection
• Created folders, business calculations and implemented Security in Framework Manager Model
• Developed Dashboard using Cognos Workspace advance and Cognos Connection Portal page
• Implemented advanced Cognos report techniques like rendering, Conditional Block, Bookmark, Page Breaks and Conditional Styles.
• For Migration purpose, using the existing logic in Cognos & created the Dashboard from scratch in QlikView and Qlik Sense with some added functionality
• Involved in various types of Testing for migration objects

Confidential

Cognos Lead / QlikView Developer

Environment: Cognos 10.2, QlikView11.2, Oracle 9i, DB2

Responsibilities:

• Worked as a Business Systems Analyst and/or Lead Business Systems Analyst on multiple projects supporting multiple business partners
• Regular interaction with client on Weekly Status Report, production issue
• Coding new Cognos development activities using Framework Manager / Report Studio
• Implemented Cascading, Bookmark, Master-Detail relationship, Drill-Through, Scheduling
• Bug fixing & Code Review to monitor if the coding standards are followed
• Worked on QlikView script and Table viewer.
• Using on section access in row level and document
• Worked on Incremental Loading to reduce the reload time of different applications
• Monitoring the schedule of QlikView Dashboard & Cognos Reports/Cubes
• Managing Change Management process for all code changes

Confidential

Sr. Cognos Developer

Environment: Cognos 10.1, Oracle 10g

Responsibilities:

• Elicited requirements and completed Functional and Technical Specifications
• Participated in Change Management Control and Process Management activities
• Involved in metadata modelling using Framework Manager
• Created Cognos reports using Conditional Block, Page Break, and Variables.

Confidential

Sr. Cognos Developer

Environment: Cognos 10.1, Framework Manager, Oracle Report Builder

Responsibilities:

• Understanding the existing D2K functionality
• Using Java Script to handle some complex functionality
• Worked on Relational FM model design.
• Applied package level, object level and data level security in framework model.
• Creating cell level drill-through in report studio

Confidential

Cognos Consultant

Environment: Cognos 10 / 8.4, FM, Transformer, Oracle, SQL Server2008

Responsibilities:

• Analyze client requirements and design efforts estimation documents and submit for client approval.
• Preparing Technical Design document
• Involved in designing and managing of model in Framework Manager
• Extensively worked in creating DSN, presentation layers of the Model.

Confidential

Cognos Developer

Environment: Cognos 8.3, Framework Manager, Analysis Studio, Transformer, Teradata

Responsibilities:

• Month End support
• Data modeling activities
• Modeling of Relational and DMR FM models.
• Designing of OLAP Powerplay transformer cube models.
• Implemented Cube partioning based on facility.
• Developed List, Cross tab and Chart Reports

Confidential

Cognos Developer

Environment: Cognos 8.2, SQL Server2005

Responsibilities:

• Design the Logical and Physical Cognos Framework Model
• Create different type of charts like Column charts and Bar charts.
• Created master detail relationship report.
• Play a significant contributing role in End User working sessions
• Involved scheduling the report

Confidential

Cognos Developer

Environment: Impromptu, Transformer, Oracle

Responsibilities:

• System Study & Requirements Gathering
• Analysis of existing Reports, Technical Specification, Templates and Layouts
• Identifying and fixing the Performance issues at both Cognos and Database levels
• Creating Catalogues & Hot Files
• Involved in Unit Testing
• Monitoring all the interfaces