SANDEEP DAHIYA

Email: adnwqt@r.postjobfree.com

Mobile: 095********,740-***-**** Skype-id : sandeep.dahiya801

Professional Summary:

7.5 Years of IT experience involving various aspects of Business Intelligence. Well versed with complete Life Cycle Development process including requirement analysis, documentation, development, testing and implementation.

Working Knowledge on OLAP tools COGNOS 8.4/10.2.1,Cognos Analytics

Area of expertise in designing and developing list, crosstab, chart reports, dash boards with Relative Time concept and complex reports like Drill-Through and Master detail reports using Report studio.

Involved in Cognos Framework Manager, Cognos administration and security tasks.

Extensive Testing experience in Reports using IBM Cognos Report studio, Query studio, MS SQL Server and MS Excel.

Good knowledge on Data Warehousing methodology, Fact & Dimension tables, Star Schema and Data Marts.

Seek to use the latest technology to solve business problems and business intelligence solutions efficiently.

Diversified background with fast learning skills and creative analytical abilities with good communication and technical skills.

Worked in in cognos Analytics around 1 years.

Technical Skills:

Category Skills

Databases Microsoft SQL Server 2008

Tools Cognos 8.4, Cognos 10.2.1, Cognos Analytic (11)

Area Data warehousing, Business Intelligence Tool

Educational Qualification

M.C.A from Maharishi Dayanand University, Rohtak in 2009

Certifications:

IBM Certified Designer Cognos 10 BI Reports.

Professional Experience:

Working in WIPRO on the payroll of US Tech Solution from 12th Feb 2021.

Worked with HCL Technologies Ltd. As Senior Cognos BI developer.

Worked with Datamatics Global Software Services Pvt. Ltd. As Cognos BI developer

Worked with SRIS Data Intelligence Pvt. Ltd. From 20thAug. 2012 to Oct. 2014 in Bangalore

PROJECTS HANDLED IN EXPERIENCE:

Project name: IAF (Indian AIR Force)

Description: In this project we have Indian air force asset details to show them in reports.

Responsibility: To collect requirement from user and develop Cognos reports.

Create Framework manager model for new requirement.

Project Name: IKEA

Description: IKEA is a multinational group, headquartered in the Sweden, that designs and sells ready-to-assemble furniture, kitchen appliances and home accessories. It has been the world's largest furniture retailer since at least 2008. Founded in Sweden in 1943 by then-17-year-old Ingvar Kampar.

Key Responsibilities:

. In IKEA I have worked as senior COGNOS developer and used COGNOS

ANALYTIC around 1 years.

•Worked as a senior Cognos developer and developed various reports in Report Studio using List, Cross tab, Prompt Pages, Layout Calculations, Conditions & Filters and Variables.

•Modified the existing FM model to incorporate the current release changes.

•Worked with Business user to finalize the current release requirements.

•Modified existing reports as requested by business.

•Involved in Modification of reports, Bugs fixing, Data Validations and preparing the documentation by placing Screen shots of actual Report and test results with valid conclusions.

•Involved in testing the reports in different environments and update the test cases and status reports on daily basis.

Client

IKEA IT

Environment

Cognos 10.2.2 BI, ORACLE 12C

Role

Report Developer

Department

Transport Forecast Planning

Project Name: Bharti Taj (Financial)

Description: Bharti Infratel is a provider of tower and related infrastructure and on a consolidated basis, Its one of the largest tower infrastructure providers in India, based on the number of towers that Bharti Infratel owns and operates and the number of towers owned or operated by Indus, that are represented by Bharti Infratel's 42% equity interest in Indus. Not only did we pioneer the tower infrastructure sharing concept in India, but are also today the leaders with over 35,000+ Towers across the circles we operate in, with some of them in the remotest and tough terrains. We also pioneered the concept of environment friendly Towers or ‘Green Towers’ and energy efficient methods for maintenance of these towers.

Client

Bharti Infratel

Environment

Cognos 8.4 BI, DB2

Role

Report Developer

Department

Financial Planning Management

Roles and Responsibilities:

Involved in Creating the Crosstab Reports and Chart Reports

Used Cascading prompts and Book Mark to design user friendly reports

Prepared User documentation to train users and functionality of each report

Implementing Data Source Connection Compatibility between packages.

Report migration and Testing.

Project Name: LKQ Multiple Projects

Description: LKQ Corporation was established in 1998 to create the largest nationwide source for quality recycled auto parts. Throughout the next decade, The Company expanded into reconditioned, remanufactured, aftermarket and self-service auto parts. With the Keystone Automotive acquisition in 2007, LKQ became the nation’s largest distributor of alternative collision replacement auto parts. Since then, it has added a heavy truck division and continued to grow our remanufacturing capabilities.

Salvage Reporting:

Client

LKQ Keystone

Role

BI Consultant

Roles and Responsibilities:

Collecting and analyzing the Report requirements.

Developed various reports in Report Studio using List, Cross tab, Chart, Prompt Pages, Layout Calculations, Conditions & Filters and Variables.

Extensively used the Cognos Report studio to create various types of simple and complex reports using Drill through, master detail, calculated fields and page breaks.

Worked on Performance tuning of reports, formatting the reports that include data formatting, spacing, scrolling, header & footer and coloring.

Involved in Modification of reports, Bugs fixing, Data Validations and preparing the documentation by placing Screen shots of actual Report and test results with valid conclusions. Involved in testing the reports in different environments and update the test cases and status reports on daily basis.

Aftermarket Sales:

Client

LKQ Corporation Inc.

Role

BI Consultant

Roles and Responsibilities:

Understanding existing business model and customer requirements.

Developed various reports in Report Studio using List, Cross tab, Chart, Prompt Pages, Layout Calculations, Conditions & Filters and Variables.

Involving in Frame work manager to develop the model

Involved in Reports creation including burst reports, Dashboards, Reports with Master Detail Relationship, Page breaks using Page sets.

Well versed in Report Formatting, Drill through approaches. Involved in Documentation and Testing in various environments like Analysis Studio and Query Studio.

Keystone Finance:

Client

LKQ Keystone

Role

BI Consultant

Roles and Responsibilities:

Collecting and analyzing the Report requirements.

Developed various reports in Report Studio using List, Cross tab, Prompt Pages, Layout Calculations, Conditions & Filters and Variables.

Formatting the reports that include data formatting, spacing, scrolling, header & footer and coloring.

Worked on Performance tuning of reports with queries using concurrent query execution for better performance of report.

Involved in Modification of reports, Bugs fixing, Data Validations and preparing the documentation by placing Screen shots of actual Report and test results with valid conclusions.

Involved in testing the reports in different environments and update the test cases and status reports on daily basis.

Personal Details:

Passport : K2911811

Contact this candidate