PROFESSIONAL SUMMARY:

• Having 9.5 years of experience in Design, Development and Delivering of Business Intelligence solutions.
• Extensively worked on Qlikview, QlikSense, Tableau and Cognos BI Reporting Tools.
• Expertise in Creating Data Models from different data sources, to provide end to end solution using QlikView applications and deploying to QlikView Server.
• Good experience in developing highly informative dashboards using QlikView objects with optimization techniques.
• Very good knowledge on Qlikview Nprinting functionality like Create Reports, Tasks, Filters, Conditions and scheduling Reports etc.
• Proficient in design and development of various dashboards, reports Utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic etc.
• Experience in designing techniques like Star schema, Snowflake schemas, fact and dimension tables, logical and physical modeling.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Very good knowledge in addressing, handling, and troubleshooting of application Issues.
• Worked on POC's for getting the new Qlikview and QlikSense assignments to the organization.
• With well-versed towards Install & configuration of Qlikview and QlikSense products, design various sets of reports using different reporting tools, testing, modifications, version tracking, analysis and project coordination, team management etc.
• Strong knowledge in Agile/ Scrum methodologies.
• Good experience in working with Cognos ReportNet and Cognos 8 BI suit tools.
• Testing applications, reports using review checklists, Data quality for Quality Assurance prior to making delivery to end users.
• Expertise in creating Design Specification Documents to facilitate the development cycle.
• Excellent problem solving skills with a strong technical background and good written and communication skills.
• Proficient in coordinating and managing the activities between on-site and offshore teams

TECHNICAL SKILLS:

BI Reporting Tools: QlikView, QlikSense, Nprinting, Tableau and Cognos

Databases: Oracle 9i/10g, MS SQL Server, Oracle SQL Developer

Defect Management tools: HP ALM, Jira Service Desk and Service Now

Operating systems: Windows 98/2003/7/8 and XP.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Technical Leader

Responsibilities:

• Participated in the daily stand up SCRUM agile meetings as part of AGILE process for reporting day to day developments of the work done.
• Ensured the data model is efficient and solved synthetic keys and closed loops formed while building the data model.
• Developed dashboards using different QlikView Objects Line Chart, Bar Chart, Gauge Chart, Pi Chart, List box, Multi box, Table Box, Container etc.
• Created data visualizations with QlikSense to identify and explore possibilities in business.
• Developed multiple ad-hoc reports for simplifying the accessibility to the data sources in QlikSense environment.
• Implemented multiple Batch files and Control logic values to refresh the QVD's when the tables are gets updated in the Data base.
• Enhanced dashboards with various period selections like weekly, monthly, daily view using tableau desktop and publish them to server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Working closely with DBA's for performance problems, fix the problem and make recommendations to technical staff to improve performance
• Involved in preparing the Solution Design and Deployment documentation for PROD Release.
• Prepared presentation documents for the End users about the functionality of the QlikView Application.
• Implemented the Incremental Load strategy to improve the loading performance.
• Involved in the deployment of the dashboard from Dev to QA and then to production.

Environment: QlikView 11 & 12, QlikSense, TableauDesktop, Teradata and Windows 7 .

Confidential, NJ

Sr. QlikView Developer

Responsibilities:

• Gathering user requirements, analyzing, designing and effort estimations.
• Implemented data model in Star Schema by integrating various Qvd's and flat files.
• Ensured the data model is efficient and solved synthetic keys and closed loops formed while building the data model.
• Created Reports in various formats by using Nprinting and distributed to the Business users.
• Designed intuitive visuals utilizing; containers, sliders, charts, straight/pivot tables etc.
• Developed dashboards using various charts, Groups (Drill Down & Cyclic), List Box, Calendar Objects, Input Box, Bookmark Object etc.
• Involved in scheduling the dashboard in the QlikView Management Console (QMC) and added users and users groups to the distribution list.
• Worked on the documenting the complete project and a point of contact for the status tracking and deployment for all the tickets related to QlikView
• Executed and tested required queries and reports before publishing.

Environment: s:QlikView11, Nprinting, Tableau, SQL Server 2008R2 and Windows XP.

Confidential, NJ

Sr. Qlikview developer

Responsibilities:

• Interacted with Client on daily basis for clarifications and gathering requirements.
• Enhanced the reports based on the change request from client.
• Established the ODBC/OLEDB connection strings and extracted the data from several source systems
• Designed dashboard with Joins, Keep, concatenations, Mapping, apply map Functions...Etc
• Involved in designing of tables to get better performance in the report execution.
• Provided visual/graphic analysis based on data content.
• Implemented the variable functionality for hiding the reports as per the user conditions.
• Prepared the Solution Design and Deployment documentation for PROD Release.

Environment: Qlikview, Oracle, SQL Server2005 and Windows XP.

Confidential

Sr. BI Developer

Responsibilities:

• Interacted with the Business Users and Supervisors to gather business requirements.
• Designed new data sources for developing analytical reports from multiple data sources like Microsoft SQL Server, Excel.
• Implemented three-layered architecture, which involves Extraction from DB and store as QVD's, Transformation layer to build aggregate QVD's and finally GUI (Dashboard).
• Implemented Security & involved in Deployment of Qlikview Application.
• Developed QlikView Dashboards using Chart Box (Bar, Line, Combo, Pivot, and Straight etc.), List, Input Field, Table Box, Groups, and Container etc.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Involved in Unit testing, performance testing/tuning, debugging and troubleshooting.

Environment: Qlikview, Oracle, SQL Server 2008 and Windows XP

Confidential

Cognos Developer

Responsibilities:

• Worked with the Client on daily basis to get the business requirements.
• Developed Cognos reports with value prompts and String and Boolean variables.
• Created advanced list reports and operations with various types of cascading prompts.
• Used Query calculations and Layout calculations extensively in developing the reports.
• Designed advanced list reports with conditional blocks.
• Developed all value prompt and No data content pane reports.
• Worked on creating prompts and cascading prompts.
• Implemented render variables for hiding the reports as per the user conditions.
• Involved the Testing of the reports and preparing the test case documents.

Environment: Cognos 8.4 & 10, Oracle, MS Access, Flat Files and Windows Server 2005.