Manager Web Developer

ANUJ KUMAR

Mobile: +91-959******* (M)

+91-994******* (M)

Email: ***************@*****.***

***********@*****.***

INTRODUCTION

Having 10 years of experience in IT industry with strong knowledge of Data Warehousing, Business Intelligence and Proficient in Cognos 8.4/10/11 (DW-BI Tool) (Report Studio, Query Studio, Event Studio, Analysis Studio and Framework Manager) and Cognos Administration. I am Cognos Analytics Author V11 Certified, IBM Certified Administrator and Tableau Desktop 9 Qualified Associate professional. I am very versatile and can switch between the technologies very fast .I worked on different visualization tools. I won spot awards by improving the performance of reports. I have good exposure of industries like Banking/Financial services and Retail.

CAREER OBJECTIVE

To associate with an organization that gives me a chance to improve my knowledge, enhance my skills and be a part of the team that excels in work towards the growth of the organization. I principally want to locate quite simply because of the excellent opportunity I feel this role within your organisation represents and matches my career objective. I am very interested in the role and believe that it warrants my relocation.

PROFESSIONAL SYNOPSIS

Developed different kinds of Standard and Complex reports including List, Cross-tab, Charts, Conditional Formatting, Cascading Prompts, and Drill through reports and Burst Reports in Report Studio. (By using Relational Package as well as Dimensional Package (DMR functions)).

Involved in migration of Cognos 8.4 to Cognos 10.2.1 and Cognos 10.2.2 to Cognos 11.0.6 (Cognos Analytics).

Configured Cognos Audit Reports.

Involved in incremental enhancements or changes in the existing reports.

Designed dashboards for higher management.

Experience in creating cubes using Power Play Transformer

Experience in creating reports by using package which is published using cubes or TM1.

Configured Cognos using NTLM & LDAP.

Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements.

Convert CQM models into DQM.

Deployment of reports.

Using Motio CI for Check in/Checkout and deployment for reports.

Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos (Good knowledge of SQL Profiler to check the query execution plan).

Resolved issues resulting from User Acceptance Testing (UAT) and PROD.

Performing Development test, UAT, preparing proof-of-concept testing and pre live and post live support.

Highly skilled in managing the complete life cycle of projects including analysis of the client requirements, translating new ideas into clients’ solutions, requirements development, delivery, support, analysis and documentation.

Consummate professional with excellent communication, planning, execution, monitoring and problem solving skills, as well as the ability to handle multiple tasks in high pressure environments and under tight deadlines.

Have good problem solving and analytical skills. Highly motivated, quick learner and extremely versatile.

Enriched 2 years of Project Delivery, Client Communication and Offshore team management experience.

Data Analysis & Reporting on Tableau Desktop and Published on server.

Created Dashboards in Cognos Analytics by using Data Module.

Experience of Agile and Waterfall methodologies and Software Development life cycle SDLC

Basic Knowledge of Power BI and Talend.

PROFESSIONAL QUALIFICATIONS

Master’s Degree in Computer Applications (MCA) from Kurukshetra University in 2004.

Bachelor of Science from Kurukshetra University in 2001.

PROFESSIONAL CERTIFICATIONS

IBM Certified Cognos 10 BI Administrator

Tableau Desktop 9 Qualified Associate

TECHNICAL SKILLS

Reporting Tools : COGNOS 8.4/10.2/11, Microsoft SQL Server Reporting

Services (SSRS), Tableau Desktop 9.0

Databases : SQL-Server 2008, Oracle

Languages : HTML, Java Script, ASP.Net, C#

Version Tool : VSS (Visual Source Safe), Motio CI

Defect Tool : HPQC 11, ServiceNow

Project Management Tool : Workfront

ORGANIZATIONAL EXPERIENCE

Company

Role/Designation

From

To

NTT Data Services, Banglore

Software Development Advisor

3rd December 2018

Till up to date

Freelancer (MarineMax, Veridian Solutions etc)

Cognos Consultant

1 May 2017

30th Nov 2018

Prospus Consulting Pvt. Ltd, Noida

Senior BI Architect

23rd December 2016

28th April 2017

Centizen Inc., Tirunelveli

Cognos BI Architect/ Manager

27th April 2015

16th Nov. 2016

Societe Generale Global Solution centre, Bangalore

Team Lead

3rd Jan 2011

24th April 2015

Saksoft Ltd., Noida

Consultant

10 Mar 2009

31st Dec. 2010

One World Technologies (P) Ltd., Ambala

Web Developer

1 Dec. 2006

7 Mar 2009

Hartron Workstation, Ambala Cantt

Software Programmer

2 Aug. 2004

30 Nov. 2006

Software Development Advisor, NTT Data Services, Bangalore 3rd Dec 2018 – Till today

BI Tools : Cognos Anaytics(11.0.6), Framework Manager

Platform : SQL Server 2018

Version Tool : Motio CI

Reporting Responsibilities:

Coordinating with the Business Analyst in the requirement Analysis and other aspects of the project.

Involved in the analysis of report specification and creation of Low Level Technical Documents.

Created various types of simple Reports and complex Reports developed using Report Studio.

Created Reports with Simple Lists, Cross tabs, Graphs, Conditional Formatting, Page set etc.

Created various kinds of prompts, cascading prompt and re-prompts in reports.

Developed Drill through reports and to display user specified reports.

Created the Burst report in report studio to distribute the report to the multiple recipients.

Created Report studio reports which resemble Dashboard.

Involved in migrating the reports from Cognos 10.2 to 11.0.6

Deployment of reports by using Motio CI

Extracting Monthly reports using Motio PI

Freelancer 1st May 2017 – 30th Nov 2018

BI Tools : COGNOS 10 BI, Cognos Anaytics(11.0.6), Framework Manager

Platform : SQL Server 2012

I am providing the BI services to my clients. Currently I am handling the development and deployment part of Cognos for my clients.

Reporting Responsibilities:

Coordinating with the Business Analyst in the requirement Analysis and other aspects of the project.

Involved in the analysis of report specification and creation of Low Level Technical Documents.

Creating, enhancing and maintaining framework manager model to support business requirements.

Provide the estimation of reports.

Created various types of complex Reports developed using Report Studio.

Use JavaScript on Prompt Page and Report Pages.

Created reports in WMS.

Deploy the report from development to production environment.

Performance tuning of report.

Installation and Configuration 10.2.2

Migration of reports from Cognos 10.2.2 to Cognos 11.0.6.

Created reports in Infor BI.

Senior BI Architect, Prospus Consulting Pvt. Ltd, Noida 23rd Dec 2016 – 28th April 2017

BI Tools : COGNOS 10 BI, Framework Manager

Platform : SQL Server 2012

Team Size : 10

Reporting Responsibilities:

Coordinating with the Business Analyst in the requirement Analysis and other aspects of the project.

Involved in the analysis of report specification and creation of Low Level Technical Documents.

Daily status call to update with the status to onshore.

Provide the estimation of reports.

Assign the report task to team members.

Creating, enhancing and maintaining framework manager model to support business requirements.

Created various types of complex Reports developed using Report Studio.

Created various kinds of prompts, cascading prompt and re-prompts in reports.

Developed Drill through reports and to display user specified reports.

Use JavaScript on Prompt Page and Report Pages.

Cognos Reporting Manager, Centizen, Tirunelveli 27th April 2015 – 16th November 2016

Phase 1

Project Name : Inventory and Margin Management

BI Tools : COGNOS 10 BI, Framework Manager

Platform : Oracle 11g

Team Size : 30

Scope :

The Inventory and Margin Management (I&MM) reports and dashboards provides insights on gross margins, general ledger detail, Profit & Loss statements and other exception reports, for reasonableness and accuracy. Dimensionally Modelled Relational Model was developed to meet the business requirement and provide the faster response to use queries

Reporting Responsibilities:

Coordinating with the Business Analyst in the requirement Analysis and other aspects of the project.

Involved in the analysis of report specification and creation of Low Level Technical Documents.

Daily status call to update with the status to onshore.

Provide the estimation of reports.

Assign the report task to team members.

Creating, enhancing and maintaining framework manager model to support business requirements.

Created various types of complex Reports developed using Report Studio.

Created various kinds of prompts, cascading prompt and re-prompts in reports.

Developed Drill through reports and to display user specified reports.

Use JavaScript on Prompt Page and Report Pages.

Peer- Review of Deliverables.

Phase 2

Project Name : Inventory and Margin Management

BI Tools : Tableau Desktop 9.0. Tableau Server

Platform : Oracle 11g

Team Size : 5

Scope :

The Inventory and Margin Management (I&MM) reports and dashboards provides insights on gross margins, general ledger detail, Profit & Loss statements and other exception reports, for reasonableness and accuracy.

Reporting Responsibilities:

Developed Interactive Reports Using various reporting components like Actions, Hierarchies, Calculated fields, Sets, Groups, Filters, Parameters, Legends etc., in Tableau Desktop

Different chart objects like Bar Chart, Line Chart and Pivot table.

Combine the visualizations into Interactive Dashboards and publish them to the Server.

Good Experience in design and develop reports with Drill Down and Drop down menu option using parameter

Integrated Javascript API on Tableau Dashboard reports.

Team Lead, Societe Generale, Bangalore March 2009 - 24th April 2015

Project Name : METRIX

BI Tools : COGNOS 10 BI, Cognos 8 BI and Framework Manager

Platform : ASP.Net using C#, SQL Server 2008

Other Tools : Stylecop, Fxcop, Visual Source Safe, NUnit

Team Size : 30

Scope :

A business performance management system for the private banking arm of the Group – Phase 1 comprises of reporting KPI (Key Performance Indicators) such as AUM, NBI, NNMA, etc. of the group’s various entities into the Data Warehouse of the Head Office in Paris developed for the project. Phase 2 deals with generation and summarization of KPI data from transactional data (from operational systems). The project also involves development of a data warehouse, Cognos reporting, creation of ETL using SSIS, and design of a .NET application.

Reporting Responsibilities:

Coordinating with the Business Analyst in the requirement Analysis and other aspects of the project.

Involved in the analysis of report specification and creation of Low Level Technical Documents.

Created various types of simple Reports and complex Reports developed using Report Studio.

Created Reports with Simple Lists, Cross tabs, Graphs, Conditional Formatting, Page set etc.

Created various kinds of prompts, cascading prompt and re-prompts in reports.

Developed Drill through reports and to display user specified reports.

Created the Burst report in report studio to distribute the report to the multiple recipients.

Created Report studio reports which resemble Dashboard.

Involved in migrating the reports from Cognos 8.4 to Cognos 10.2.1.

Created standard Ad-hoc reports using Query Studio.

Use Javascript on Prompt Page and Report Pages.

Developed the reporting models in the Cognos framework manager for reporting and published the package.

Installation and Configuration of Cognos 10 BI with SQL Server.

Created test cases for reports.

Peer- Review of Deliverables.

Deployment in different environments.

Web Developer, One World Technologies Pvt. Ltd, Ambala Cantt. Dec 2006 - March 2009

Title : Tivelon

Duration : January 2008 to till March 2009

Platform : ASP.Net using C#, SQL Server 2000

Team Size : 8

Responsibility : Designing & Coding

Scope : This is online ticket and travel booking, where user can plan a trip as well as purchase ticket from this site. It also helps user to know about the different events organized in the calendar year. User can also sign up to get news about the different events and shows organized.

Title : A-SHU(http://www.a-shu.co.uk)

Duration : December 2006 to December 2008

Platform : ASP.Net using C#, SQL Server 2000

Team Size : 5

Responsibility : Designing & Coding

Scope : An E-commerce website for everyone who is interested in purchasing shoes and accessories. In one place user can purchase shoe of any company. Orders from UK are entertained. It is totally data driven where administrator can administer almost everything from managing products to managing orders.

Software Programmer, Hartron Workstation, Ambala Cantt. Aug 2004 - Nov 2006

Title : DailyPlaza

Duration : February 2006 to November 2006

Platform : ASP.Net using C#, SQL Server 2000

Team Size : 4

Responsibility : Designing, Coding

Scope : It is an E-commerce website where user can purchase different type of products with a click. Orders from UK are entertained. It is totally data driven where administrator can administer almost everything from managing products to managing orders.

Title : Ronz Furniture

Duration : August 2005 to January 2006

Platform : ASP.Net using C#, SQL Server 2000

Team Size : 5

Responsibility : Designing, Coding

Scope : It is an E-commerce website where user can purchase different type of furniture with a click. Orders from UK are entertained. It is totally data driven where administrator can administer almost everything from managing products to managing orders.

Title : MDSportz

Duration : August 2004 to July 2005

Platform : ASP.Net using C#, SQL Server 2000

Team Size : 3

Responsibility : Designing, Coding

Scope : An E-commerce website for everyone who is interested in purchasing shoes .In one place user can purchase shoe of any company. Orders from UK are entertained. It is totally data driven where administrator can administer almost everything from managing products to managing orders.

EXTRA CURRICULAR ACTIVITES

One of the Winners of “Microsoft Heroes Happen Here “Contest.

PERSONAL DETAILS

Father’s Name : Late Sh. Satish Kumar

Marital Status : Single

Date of Birth : 17th December 1981

Hobbies : Travelling, Bike Riding, Running and Gyming

Passport Number : Z3412346

Permanent Address : 991, Sector-9, Urban Estate, Ambala City – 134003.

(Anuj Kumar)

Contact this candidate