Manager Project

Summary

Over * years of total IT experience in Business Intelligence & Data warehousing Technologies using Cognos, Microsoft and Oracle Products

Have experience working as Project Lead managing team of 5 to 7 members

Possess onsite experience in USA and UAE as Technical Lead and Onsite Coordinator

Have experience designing and developing Cognos Framework Manager model, both dimensional and relational

Have experience in designing and developing reports using Cognos Report Studio, Query Studio and Analysis Studio

Have experience in designing ETL packages using SSIS and OLAP cubes using SSAS

Excellent analytical and object oriented design skills

Ability to perform in a growing company and have the skill to work closely with technical and business teams to meet deadlines

Possess good analytical, interpersonal, communication, problem solving skills and also an active team player.

Well-developed interpersonal and communication skills, having dealt with Senior Management, SME’s and Client at global locations

Involved in creation of Technical Design Documents, Functional Specifications, Test Case Documents and Estimation Documents

Trained on agile methodology of software implementation using SCRUM

Valid H1B visa holder, visa valid till June 2017

IT Work Experience

Employer : Cognizant Technology Solutions August 2014 – Present

Client : JPMC (Lewisville, TX)

Role : BI Consultant

Environment : Cognos 10.2 (Cube Designer, Report Studio, Query Studio), Teradata

Responsibilities

Involved in requirement gathering phase

Responsible for effort estimation

Designing and creating dynamic cube using Cognos Cube Designer

Design and development of FM model and Report Studio reports

Gap analysis for the existing Data Model to ensure it meets the current dashboard requirement

Coordinating with offshore team

Assigning tasks to team members and assuring timely delivery of the same

Reporting project status to all the key stakeholders

Employer : Syntel Consulting Inc. February 2014 – July 2014

Client : Scripps Health (San Diego, CA)

Role : BI Consultant

Environment : Cognos 10.2 (Report Studio, Query Studio), SQL Server 2008

Responsibilities

Developing Dashboard reports using Cognos Report studio

Involved in requirement gathering phase

Responsible for effort estimation

Designing and creating dashboard mock-ups depending on the business need

Gap analysis for the existing point to point solution to ensure it meets the current dashboard requirement and the possible enhancements required

Coordinating with offshore team

Assigning tasks to team members and assuring timely delivery of the same

Documenting and tracking the progress of the project

Reporting project status to all the key stakeholders

Employer : Syntel India Ltd. October 2013 – January 2014

Client : Scripps Health (Offshore, India)

Role : BI Consultant

Environment : Cognos 10.2 (Report Studio, Query Studio), SQL Server 2008

Responsibilities

Involved in requirement gathering phase

Responsible for effort estimation

Analyzing business needs and estimating efforts for the same

Gap analysis for the existing point to point solution to ensure it meets the current dashboard requirement and the possible enhancements required

Employer : Hexaware Technologies Inc. February 2012 – September 2012

Client : AIG (NYC, NY)

Role : Cognos Lead

Environment : Cognos 10.1(Framework Manager, Report Studio, Query Studio, Analysis Studio), Oracle 11g

Responsibilities

Responsible for requirement gathering from client and transition of the same to offshore team

Responsible for BRD creation as per the business requirements

Responsible for effort estimation and creating project plans and defining timelines for the same

Designing and developing Cognos reports using Report Studio, Query Studio and Analysis Studio

Creating and providing the technical specifications to offshore team for development

Creating Functional and Technical Specification documents

Responsible for keeping tracks of ongoing projects and projects that are lined up, accordingly maintaining the resource loading plan for all the reporting requirements

Responsible for keeping track (timelines) of each and every reporting project from start to end

Coordinating with the users and the offshore team

Assigning tasks to team members and assuring timely delivery of the same

Designing and developing the Metadata model using Cognos Framework Manger

Updating project status to the client and internal Management

Employer : Hexaware Technologies Pvt. Ltd. July 2011 – March 2013

Client : AIG (Offshore, India)

Role : Cognos Lead

Environment : Cognos 8.4/10.1(Framework Manager, Report Studio, Query Studio, Analysis Studio), Oracle 11g

Responsibilities

Responsible for requirement gathering from client

Responsible for effort estimation and creating project plans and defining timelines for the same

Designing and developing Cognos reports using Report Studio, Query Studio and Analysis Studio

Designing and developing the Metadata model using Cognos Framework Manger

Creating Functional and Technical Specification documents

Responsible for keeping tracks of ongoing projects and projects that are lined up

Coordinating with the users and the team

Assigning tasks to team members and assuring timely delivery of the same

Updating project status to the client and internal Management

Employer : Hexaware Technologies Pvt. Ltd. November 2010 – June 2011

Client : International SOS (India)

Role : Cognos Lead

Environment : Cognos 8(Framework Manager, Report Studio), SSIS, SQL Server 2005

Responsibilities

Involved in requirement gathering phase

Plan proper project plans, intimate the same to business, assign tasks to concern team members and meet the deadlines

Responsible for monitoring and enforcing the processes to be followed

Analyzing and providing solutions to the various issues faced by business

Installation and configuration of Cognos environment on distributed topology

Migrating/Upgrading the entire DW setup from Cognos 8.1 to Cognos 8.3 environment

Configured Cognos Audit to track user activities, further business can analyze how Cognos application is used, reused, and delivered to its various audiences

Enhancing FM Model from SQL 2005 to meet new business requirement and enhance performance

Creating reports and Dashboards using report studio as per business need

Writing new and modifying existing Stored Procedures to extract data from source and load it into DW environment

Support and maintenance of the existing data warehouse setup

Implementing security and scheduling the reports for daily, weekly and monthly runs

Employer : Cognizant Technology Solutions October 2009 – October 2010

Client : sanofi aventis (India)

Role : Cognos Lead

Environment : Cognos 8(Framework Manager, Report Studio), SSIS, SQL Server 2008

Responsibilities

Involved in requirement gathering phase

Creation of FM Model from SQL 2008 as per the business requirement

Creating complex reports and Dashboards using report studio as per business need

Writing Stored Procedures to extract data from source and load it into DW environment

Creation of Portal Pages and implementing security on the same

Data level security implementation in FM

Conducting End user training

Documenting every module of the project

Employer : SYSTIME Computers August 2009 – September 2009

Client : Zurich Financial Services (Offshore, India)

Role : BI Consultant

Environment : Cognos 8(Framework Manager, Report Studio), SQL Server 2005

Responsibilities

Studying their existing environment and suggesting them ways to improve their existing setup

Creating Reports using Cognos as per business requirements

Documenting every module of the project

Employer : SYSTIME Computers June 2009 – July 2009

Client : Dole Food (India)

Role : BI Consultant

Environment : Cognos 8(Framework Manager, Report Studio), Cognos 8 Planning, DB2

Responsibilities

Creation of FM Model from Planning Cubes as per the business requirement

Involved in developing reports using Report-Studio

Testing of the Framework Model, Reports before deployment for onsite

Creation of Portal Pages and implementing security on the same

Documenting every module of the project

Employer : SYSTIME Computers February 2009 – April 2009

Client : Al Tayer Group (Dubai, UAE)

Role : Sr. BI Consultant

Environment : SQL Server Integration Services, Cognos Planning, SQL Server 2005

Responsibilities

Understanding Client Business requirements.

Creating ETL Scripts using SSIS as per Business Requirements.

Publishing of data from Cognos Planning

Deploying the SSIS Packages on the Production Server and successful testing of the same.

Post go live production Support and Maintaining the ETL once deployed.

Employer : SYSTIME Computers November 2008 – January 2009

Client : King Metals (India)

Role : BI Consultant

Environment : Oracle BI Publisher, MS SQL 2005

Responsibilities

Understanding Client Business needs

Creation of Reports using Oracle BI Publisher as per the Business Requirements

Automation of the entire BI process

Testing & modification of Reports as per Business requirement

Documentation

Employer : SYSTIME Computers March 2008 – September 2008

Client : Al Tayer Group (Dubai, UAE)

Role : Sr. BI Consultant

Environment : SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), ProClarity, SQL Server 2005

Responsibilities

Understanding Client Business requirements.

Creating SQL procedures as per Business Requirements.

Creating various SSIS Packages based on the requirements on the project.

Creating SSAS Cubes as per Business Requirements.

Deploying the SSIS Packages and SSAS Cubes on the Production Server in successful testing of the same.

Giving Production Support and Maintaining the ETL once deployed.

Maintaining ProClarity to provide data for business intelligence reporting in order to help user’s in extracting important information and monitoring its business activities.

Supporting the users to maintain and utilize the EIS reports.

Employer : SYSTIME Computers December 2007 – February 2008

Client : DIAGEO (India)

Role : Sr. BI Consultant

Environment : Cognos Planning, Oracle 10g

Responsibilities

Understanding Client Business needs

Creation of views in Oracle 10g as per the Business Requirements

Creation of D-links & D-lists

Testing & modification of views and D-lists as per Business requirement

Documentation

Employer : SYSTIME Computers September 2007 – November 2007

Client : SYSTIME Computers (India)

Role : Technical Consultant

Environment : Cognos 8.2(Framework Manager, Report Studio), MS SQL 2000

Responsibilities

Installation & setup of all the above-mentioned Cognos products

Creation of FM Model

Involved in developing complex reports and Graphs in Report-Studio

Testing of the Framework Model, Reports and Graphs before deployment for onsite

Creation of Portal Pages and implementing security on the same

Setup the security using NTLM for module-wise users

Documenting every module of the project

Creation of User Manual for the Project

Employer : SYSTIME Computers March 2007 – July 2007

Client : Wyeth (India)

Role : Technical Consultant

Environment : Cognos 8(Framework Manager, Report Studio), Oracle 9i

Responsibilities

Understanding Business Requirements

Coordinating with the Team Members

Creation of FM Model as per the business requirement

Designing the Logic of the Reports as per the Requirement

Developing new Reports

Enhancing existing reports with the changes requested

Testing of Newly Developed & Enhanced Reports

Troubleshooting

Educational Qualifications

Completed PG-DAC from VITA, Mumbai in 2006 with 66.00%

Completed Bachelor in Computer Engineering from University of Mumbai in 2005 with 59.00%

HSC (12th) from Maharashtra Board in 2001 with 75.00%

SSC (10th) from Maharashtra Board in 1999 with 71.60%

Skillsets

BI Tools: Cognos Series 8/10 (Framework Manager, Cube Designer, Report Studio, Query Studio, Event Studio, Analysis Studio)

ETL Tools: SSIS 2008

RDBMS/DBMS: Oracle 11/10g/9i, SQL server 2008/2005/2000, Teradata, MS-Access

Database Languages: SQL, PL/SQL

Contact this candidate