Profile at a Glance:

A dynamic and dedicated Professional offering a career spanning over 4 years 5 Months in Design and Development of Applications using Business Intelligence Tools with Wipro as a Cognos Developer.

Multitasking, proactive & enthusiastic professional with positive attitude, quick grasping power and self confidence.

An effective communicator with excellent team management & interpersonal skills, with significant experience in interaction with corporate clients.

Career Highlights

Proficient in BI Tool – Cognos 10/8.

.

Sound Knowledge in RDBMS and Data Warehouse Architecture Concepts.

Worked on FM.

Worked extensively on reports in Report Studio.

Proficient in analyzing of raw data and understanding the functional and business aspects involved in order to design and deliver reports with the help of business intelligence tools.

Certifications

Certified IBM Metadata Models.

Certified Cognos BI OLAP Models

Certified IBM BI Author.

Educational Qualifications

Bachelors of Science – Computer Science (2011)

Christ University, Bangalore.

M.Tech – Software Engineering(2012-2015)

BITS PILANI

Technical Skill

Platform

Windows NT/2000/XP

Tools

Cognos (10,10.1), Cognos 8,Tableau,DWH Concepts, Knowledge on Informatica Power center and SAP BO, Excel Macros,,Cognos Admin.

RDBMS

Oracle SQL 10g,MY SQL, Netezza

Professional Outline

Wipro Technologies –Bangalore Software Engineer (25th July to till today)-4 years 5 Months.

Having experience in development of applications using reporting tool – Cognos 8.4/10.1.

Strong understanding of relational database design concepts and in depth knowledge of OLAP Solutions.

Created Packages using Framework Manager.

Versatile team player with the ability to communicate at all levels of software development life cycle.

Self-motivated and quick learner of new concepts and technologies. A result oriented team player capable of working in target-oriented environment.

Proficiency at grasping new concepts quickly and utilizing it in a productive manner.

An effective communicator with excellent interpersonal and relationship building skills.

Having experience in development of KPI’s using Tableau (Visualization tool).

Project Details:

The details of the various Projects that I have handled are listed here, in chronological order.

Project 1

ME-YLI-PJ-CRYSTAL-US

Period

(08/2015) – (till present)

Description

Hibu Inc. provides digital and print marketing solutions to small and medium-sized businesses in the United Kingdom, the United States, Spain, Argentina, Chile, and Peru. The company offers services in the areas of Websites, search engine marketing, display advertising, SEO service, and directory listings. Hibu Inc. was formerly known as Yellowbook Inc.

Role

Cognos Developer

Responsibilities

Work with Business Analysts to translate business requirements into technical specifications for new Application using COGNOS

Involving in development of DMR reports

Fixing issues in existing reports

Created complex Reports.

Created the Reports for Cisco and validated the data with CUIC(cisco unified intelligence center)

Worked on Performance tuning of the Reports.

Data Validation- Validating all the reports for correctness of the data

Involved in republishing of packages using IBM Cognos Framework manager.

Creating Technical Design document.

Checking functionality of the report.

End users training on BI Cognos.

Analyze the impact of new requirement in the existing model and report

Release the reports to production

Support admin activities

Project 2

CCI(Phase -2)(Jhonson & Jhonson)

Period

(11/2014) – ( 07/2015)

Description

This is a multi-year Data Migration program to extract, transform and upload the foundational, transactional and Contract data, from various legacy systems, into a single Contracting solution [ICS]. The first phase went live in Feb 2014. Phase 2 involves extracting, transforming and uploading foundational data for DePuy Companies; Since there is no conversion involved for transactional and contract process area, the scope is to just link/merge the DePuy system's already converted transactional and contracts data and upload into ICS; This phase involves migrating millions of sales lines as well as contract information to the existing contracting system. The Cognos reporting portal will be reused to provide reports for verification purposes; Phase-2 involves development, fix defects, process change requests, Unit testing[TUT-1 and TUT-2], support formal test cycles[Dry Run 1 through Dry Run 2], System test cycle[SIT], User Acceptance test cycle[UAT], Production Dress Rehearsal[PDR] and Final Cutover; The phase-2 project is expected to go live in Feb 2016 and Hyper care support to start by March 2016.

Role

Cognos Developer.

Responsibilities

Work with Business Analysts to translate business requirements into technical specifications for new Application using COGNOS

Involving in development of DMR reports

Fixing issues in existing reports

Created complex Reports.

Worked on Performance tuning of the Reports.

Data Validation- Validating all the reports for correctness of the data

Involved in republishing of packages using IBM Cognos Framework manager.

Creating Technical Design document.

Checking functionality of the report.

End users training on BI Cognos

Project 3

Migration of reports from Cognos to Tableau (Capital One)

Period

(6/2014) – (10/2014 )

Description

Migrating the reports from COGNOS to TABLEAU.

Role

Cognos Developer, Tableau Developer

Responsibilities

Worked on Cognos Administration for creating the Data source connection.

Created the reports in Cognos Report studio using Audit package and having knowledge on Framework

Data source connectivity of DB in Excel.

Analysis is done on Cognos reports by comparing with Cognos Metadata extraction.

Basic Knowledge on Excel Macros.

Worked on Performance tuning of the Reports.

Prepared and maintain Unit Test Cases.

Responsible in creating KPI’s and the interactivity between KPI’s in Tableau.

Project 4

CLINICAL PRISM (GSK)

Period

(8/2013) – (5/2014)

Description

The Clinical Prism reporting to provide a simplified consolidated view of Clinical studies data and it Acts as single point of reference for Clinical research data from various clinical trials. It provides a real time analytical reporting solution for the Study management team, Investigators and other stakeholders. The Clinical Prism reporting model and reports developed by the IBM Cognos BI.

Role

Cognos Developer.

Responsibilities

Prepared Technical and Functional design documents.

Worked around preparing Data validation sheets/Test Cases.

Created DMR Model in FM

Created complex Reports.

Worked on Performance tuning of the Reports

Prepared and maintain Issue Tracker, Unit Test Plan.

Worked on Cognos Administration(monitoring the scheduled reports and modifying the scheduling )

Project 5

CCI (Phase -1) (Jhonson & jhonson)

Period

(11/2011) – (7/2013 )

Description

CCI or Commercial Contract Integration is a program initiated and being executed in order to integrate the Contract, Payment and Sales related information from the different legacy systems such as MDM, INTERACT, Data Warehouse into a single Regional Data Warehouse wherein a Contract Management Tool (Model N) will connect to provide the facility to carry out advanced analysis on the available data. As part of the conversion process, the program will source the data from these legacy systems and convert it to be loaded into the Model N system. The primary objective thereby is to migrate the data from the respective Operating Companies into Model N, to facilitate Contract Life Cycle Management activities. The Conversion Process will also provide the users reporting capabilities to validate and verify the conversion process at each and every step of the flow.

Role

Cognos Developer.

Responsibilities

Involved in creating the Package and making the Changes in existing package in Framework manager.

Developed detailed and summary reports using Cognos 10.1 BI Report Studio.

Enhanced the report by highlighting the data and hiding the objects using Conditional Formatting.

Used filters, conditions, calculations, sorting, parameters, prompts, data format and various functions in the reports.

Used Render Variables, String Variables for the better user friendly dashboard creation.

Reviewing and testing the reports in Report Studio.

Involved in preparation of the Test cases for the standard reports.

Testing of reports for data accuracy.

Involved in Unit testing, Bug fixing and preparation of testing documents.

Personal Details

Name

Savitha G

Designation

Software Engineer

Birth Date

30th – Mar - 1991

Residence

Bangalore.

Nationality

Indian

Marital Status

Single

Gender

Female

Declaration:

I hereby inform that all the information mentioned above is true to the best of my knowledge.

Date:

Contact this candidate