Umamageshwaran Ramasamy

Mobile: +1-717-***-****

Email: ad0tk2@r.postjobfree.com

Objective:

Aspiring to Work in a challenging environment to enhance my knowledge and contribute myself for the development of the organization.

Snapshots:

●16 years of extensive experience in providing solutions for developing & maintaining BI-DWH Applications in technologies like Cognos, and Bigdata across global clients.

●A thorough professional with excellent communication, Leadership, Problem solving and analytical skills, along with the ability to multitask effectively under challenging conditions.

●End-to-End Project management of the engagement ensuring timely delivery as per agreed milestones.

●Have been a Successful Scrum Master with in-depth capability of successful execution of Agile Methodology.

●Around 9 years of experience in development, up gradation and support projects of Data Warehouse and Business Intelligence reporting for different global clients.

●Worked in end-to-end implementation of Data Warehouse project and possess a strong understanding of SDLC, Data Warehousing concepts, Architecture, OLTP, OLAP, ETL, Staging, FACT & Dimensions tables.

●Involved in design and analysis of requirements, Data Modelling, Report development and ETL development.

●Performance Tuning in Packages, Reports and Cubes by identifying and resolving performance bottlenecks at various stages.

●Experience in gathering Business requirements, Analysis, Design, Development, Testing and Implementation of Cognos applications and responsible for providing Demos and End-user training.

●Have expertise in Cognos DW BI Suites and IBM COGNOS Certified.

Career Profile

Dates

Organization

Role

March 2010- May 2021

Tata Consultancy Services, India

Project Manager, BI Developer, Business Analyst, Scrum Master

Jan 2007 to March 2010

IBM India Private Limited, India

Senior Systems Engineer

July 2005 to Jan 2007

Artech info Systems, India

Software Engineer

Technical Skills

Database: Oracle, SQL Server

Operating Systems: Windows and UNIX

Tools/ Utilities: Cognos Data Manager, Cognos Report Studio, Cognos Framework Manager, Cognos Analytical Apps for SAP, SSIS, Business Objects, Tableau, Hadoop Hive,Impala,

Project Details:

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

Jul - 2020 _May - 2021 Tata Consultancy Services

Title Health information exchange (HIE)

Period Jul 2020 to May 2021

Client Name CareSource

Position Delivery Project Lead

Responsibilities:

Project Planning, Estimation of Project tasks and schedule in appropriate manner, Identify and plan for the training needs of the resources, conducting status meetings and ensure effective utilization of Project resources. Compiling and delivering Project Delivery presentations like WSR, Weekly agile metrics, Monthly Status Reports to stake holders.

Project

Health information exchange (HIE) is the mobilization of health care information electronically across organizations within a region, community or hospital system. Participants in data exchange are called in the aggregate Health Information Networks (HIN). In practice the term HIE may also refer to the health information organization (HIO) that facilitates the exchange. This project handles HIE data of Ohio, Kentucky and Georgia States and loaded in to Enterprise Data Warehouse for BI Reporting.

May - 2019 _May - 2020 Tata Consultancy Services

Title Lifescan Digital

Period Jan 2020 to May 2020

Client Name Lifescan

Position Project Manager

Responsibilities:

Project Planning, Estimation of Project tasks and schedule in appropriate manner, Identify and plan for the training needs of the resources, Conducting status meetings and ensure effective utilization of Project resources. Compiling and delivering Project Delivery presentations like WSR, Weekly agile metrics, Monthly Status Reports to stake holders.

Project

Lifescan is the world leader in blood glucose monitoring and maker of the iconic OneTouch® brand. Lifescan Digital project has the scope of migrating the worldwide websites from J&J Server to Lifescan server and also maintaining websites of Lifescan organization. Lifescan has around 20 websites hosted for different regions of the world. The Websites provides consumers with the details of Lifescan products, its features and the availability. Consumers can refer the websites and order the products as per their needs. The Websites are designed using latest web technologies and the Project team is skilled enough to support and maintain those websites and also to make any design changes needed as per the Business requirements. The Project team is also responsible for maintaining the websites without any downtime.

Since Oct-2017 _to May 2019 Tata Consultancy Services

Title GLAC Roadmap - Transportation Data Lake

Period Oct 2017 to Dec 2019

Client Name JNJ

Position Business Analyst and Scrum master

Responsibilities: Requirement Analysis, Impact analysis, Issue Triaging, Writing Stories as per Business Requirements, grooming stories with Business, and Development team, Provide High level Technical Design / Solutions for New Requirements, Design Technical Solution.

Manage sprint backlog items and tasks, lead the team efforts towards continuous improvement. Coordinate all Scrum Ceremonies including Sprint Planning, Daily Standups, Sprint retrospectives, Story Grooming, and Release Planning. Work effectively with other teams to remove any impediments and delivery team roadblocks. Coordinate team dependencies effectively.

Also involve in showing Demo with all the Stake Holders, Coordinating the information and knowledge sharing within the Team and with other Sprint teams, Coordinating Deployments with Continuous Integration team, Training New Resources and deploying them in Project.

Project

GLAC Project is designed for achieving efficient distribution and movement of finished Johnson and Johnson products across countries. The application gives a whole integrated view of key information about Sales, Trade Spend, Inventory, Shipments, Consumption, Quota, Contracts, Share and Service metrics across Master Product, Payer, Provider, Geography, Data Centers, Customer and Retailers structures. This system is widely used by the J&J Business Analysts, Financial Analysts, and Customer Logistics development team, Excellence, Strategic Customer Group, Sales Strategy Marketing Group, along with Business Users and Third party brokers. Currently there are over 100+ users using this system on a daily basis.

The Sales, Inventory and item shipment details are obtained from various Supply chain ERP systems (SAP ROTC, JDEOW) and the shipment and logistic information are derived from various external carriers like Fedex, DHL etc and other logistic systems. A data model is created by integrating the information from the ERP and logistic systems and the same is used for Business Reporting.

This will be the single standard system enabling J&J business personnel and customers to review track & analyze Sales, Shipments, Consumption, Contracts and Inventory across different DC’s along with understanding the demands. This System is getting ready for next generation analytics to enable quick analysis, visualization and sharing. This in-deed changes the business perspective towards the data, provides better view to solve problems, and implement action based insights.

Since March-2015 to Sep 2017 Tata Consultancy Services

Title DCF BI & Finance BBS Support

Period Mar 2015 to Sep 2017

Client Name JNJ

Position Onsite Coordinator

Responsibilities

●Interacting with the Client Business owners and Project Managers to understand the business and technical requirements.

●Analyzing the system requirements.

●Estimate, Plan, Schedule, Track and Deliver requests received on a weekly basis.

●Work with team to estimate time taken to work on each activity and communicate appropriately to customer/stakeholders.

●Impact Analysis of additional reports for any discrepancies, support to the users, and communicate with onsite client manager.

●Provided reports on a weekly status to the various stakeholders and sponsors to present the status of the health of the project.

●Interacting with client and coordinating with offshore team members.

●Incident, Problem, Change Management services.

Project

DCF BI:

DCF BI System is a global initiative to provide DCF a strategic, analytical and tactical reporting for all levels of Management. It extracts and receives multiple heterogeneous data sources both internal & external and integrates them to provide business with the right information at the right time. The system encompasses all kind of BI reporting in order to help business users to make strategic decisions in favor of the ongoing business process.

The applications supported are below:

Supply Chain

Sales

Order to Cash

Procurement and Inventory

Finance

Manufacturing

Planning

Audit

DCF Finance:

This project is to support the Diabetes Care SAP BPC finance application Diabetes Care NA and Diabetes Care EMEA. I mainly work on script logics, Transformation and Conversion file modifications, dimensional change, security management, server functionality checkup etc. as a part of SAP BPC 10.1 MS application support.

Operating MS Windows Server 2003

System

Tools

Cognos Data Manager

Microsoft SSIS

SAP BPC 10.1

Database

Oracle 11g

MS SQL Server 2008

Fremont, CA and Chester brook, PA

July -2012 to Mar 2015 Tata Consultancy Services

Title Consumer ASPAC BI (EDGE)

Period Jul -2012 to Mar 2015

Client Name JNJ

Position Cognos Lead

Responsibilities

●Interacting with the Client Business owners and Project Managers to understand the business and technical requirements.

●Analyzing the system requirements.

●Estimate, Plan, Schedule, Track and Deliver requests received on a weekly basis.

●Work with team to estimate time taken to work on each activity and communicate appropriately to customer/stakeholders.

●Impact Analysis of additional reports for any discrepancies, support to the users, and communicate with onsite client manager.

●Provided reports on a weekly status to the various stakeholders and sponsors to present the status of the health of the project.

●Service Management services.

●Incident, Problem, Change Management services.

●Design & Development of Cognos report Studio and Business Insight reports.

●Perform Unit Testing /Integration Testing

●Documentation as per SDLC process

Project

Consumer ASPAC BI (EDGE) is a comprehensive system that provides strategic, analytical and tactical reporting for all levels of J&J Management. It extracts and receives data from multiple heterogeneous data sources both internal & external and integrates them to provide business with the right information at the right time.

Consumer ASPAC BI (EDGE) system provides an analytical framework to the Business user which helps them to make certain decisions in favors of existing Business. The system is capable to provide unified view of the health of the Business. The system enables users to make trend analysis in an efficient manner

Operating MS Windows Server 2003

System

Tools

Cognos-Framework Manager

Cognos Report Studio

SSIS

Database

MS SQL Server 2008

Singapore and Bangalore, India

April -2012 to July -2012 Tata Consultancy Services

Title JJMC

Period April -2012 to July - 2012

Client Name JNJ

Position Designer

Responsibilities

●Analyzing the data and do a feasibility study on the requirement

●Understanding the business requirements from the business users and creating the technical specification.

●Change existing Framework Model as per new report requirements.

●Design & Development of Cognos Power play cubes and reports.

●Perform Unit Testing /Integration Testing

●Documentation as per SDLC process

Project

JJMC Johnson & Johnson Medical China is an enhancement and development project for China Region. There are 5 reports in JJMC that needs to be developed in cognos 8 Report Studio. They are Daily Sales Report, Company Sales Dashboard, Company Supply Chain Dashboard, GTS to NTS by distributor by Sales Area report and Finance Price Point Variance (PPT) report. Reports are comparison between FBP values come from Flat files and Actual Values from the RDW. Flat files are loaded in to RDW Datawarehouse tables using Cognos Data Manager Jobs. Existing Framework Model is changed according to the new report requirements and Package is published to the cognos Portal. Cognos Report Studio Reports are developed using the package or Power play Cubes.

Operating MS Windows Server 2003

System

Tools

Cognos-Data Manager

Cognos-Power play Transformer

Cognos-Framework Manager

Cognos Report Studio

Cognos Query Studio

Cognos Analysis Studio

Cognos Metrics Studio

TOAD 8.53

Kolkata, India

March-2012 to April 2012 Tata Consultancy Services

Title Leap Live BI - ASPAC

Period March-2012 to April – 2012

Client Name JNJ

Position Designer

Responsibilities

●Analyzing the data and do a feasibility study on the requirement

●Understanding the business requirements from the business users and creating the technical specification.

●Design & Development of Cognos Power play cubes and reports.

●Perform Unit Testing /Integration Testing

●Documentation as per SDLC process

Project

Leap Live is SAP Implementation project in the Asia Pacific region. The team is responsible for development and maintenance of Cognos 8 applications. Objective of the project is implementation of BI functionality according to agreed schedule, scope and budget, Drive Business Results Distributor Projects. It provides BI solutions to support distributor projects for China, NA and ASEAN countries.

Operating MS Windows Server 2003

System

Tools

Cognos-Data Manager

Cognos-Power play Transformer

Cognos-Framework Manager

Cognos Report Studio

Cognos Query Studio

Cognos Analysis Studio

Cognos Metrics Studio

Actuate

TOAD 8.53

Oracle Business Intelligence (OBI)

PL/SQL Developer

Kolkata, India

December-2011 to March 2012 Tata Consultancy Services

Title Chennai One Productivity

Period December-2011 to March-2012

Client Name TCS Internal

Position Module Lead

Responsibilities

●Analyzing the data and do a feasibility study on the requirement

●Understanding the business requirements from the business users and creating the technical specification.

●Design & Development of Cognos Framework Model and Report studio reports.

●Perform Unit Testing /Integration Testing

Project

The purpose of the project is to develop productivity based on IOU and employee type reports on daily, weekly and monthly basis for the Chennai one office employees. It will be implemented for all the Chennai TCS offices later. It is also used to find the defaulters (no leave applied, no swipe record Present).employee leave record are captured in Global Minerva system. Employee Swipe records are available in hourly basis from BFS.

Operating MS Windows XP

System

Tools

Cognos 10 Framework Manager

Cognos 10 Report Studio

IBM DB2

IBM Data stage

Chennai, India

February-2011 to Dec 2011 __ Tata Consultancy Services

Title GCI Release2C

Period February-2011 to Dec -2011

Client Name Chartis Inc., USA

Position Module Lead/ Designer

Responsibilities

●Ensure on time delivery of the deliverables as per the project plan

●Analyze Technical specification and develop code as per the specification.

●Perform Unit Testing /Integration Testing

●Assisting user in User Acceptance Test via email or over phone to resolve their queries

●Documentation as per SDLC process.

Project

The purpose of the Global Claims Initiative (GCI) project is to replace First Notice of Loss (FNOL) services currently provided by a third party service provider. The following Primary lines of businesses will be captured in FNI: Auto Liability; General Liability; Property/Homeowners and Workers' Compensation/Long shore, A&H, Financial Lines and Severity Lines. GCI Data Warehouse/ Business Intelligence platform is supported by the Operational Data Store / Reporting Data Warehouse (ODS/RDW) using Cognos reporting.

Carried out the following activities:

●Requirement Gathering and Analysis.

●Technical Report Specification document Preparation.

●Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.

●Created Complex transactional Summary reports involving complex calculation and report design.

●Created Detailed Reports using Drill through capabilities.

●Unit Testing/Integration Testing.

●Assist Business User in User acceptance Test.

●Develop documents like Detail Requirement Document, Unit Testing Document, UAT Document, Application Knowledge Document, Report Specification etc.

Operating MS Windows Server 2003

System

Tools

Cognos 8 BI Suite

Cognos Report Studio 8.3

Cognos Framework Manager 8.3

Chennai, India

April-2010 to January-2011 Tata Consultancy Services

Title iReContract

Period April-2010 to January -2011

Client Name Chartis Inc., USA

Position Module Lead/ Designer

Responsibilities

●Ensure on time delivery of the deliverables as per the project plan

●Analyze Technical specification and develop code as per the specification.

●Perform Unit Testing /Integration Testing

●Assisting user in User Acceptance Test via email or over phone to resolve their queries

●Documentation as per SDLC process.

Project

AIG utilizes reinsurance to transfer risk throughout its insurance operations. The governance of this risk transfer is encapsulated by the treaty contract or the facultative certificate (contracts). Currently, contracts are stored in a variety of mediums throughout the AIU and Commercial Insurance organizations. The most prolific medium is Treaty History, which provides key information about the treaties, going back more than 40+ years. The purpose of the iReContract project is to provide a central repository for all contracts and to make key information available to all operations involved in the risk transfer process (underwriting, claims, accounting, audit, regulatory and statutory reporting, global reinsurance division and executive management).

IReContract system will be sponsored for deployment by the Global Reinsurance Division and be available to all authorized business units able to access AIG’s intranet. It is compliant with AIG’s strategic architecture (which is a combination of IBM Content Manager with a Pega workflow component) as well as its technical standards for architecture, security (roles based), disaster recovery and business continuity.

Carried out the following activities:

●Requirement Gathering and Analysis.

●Technical Report Specification document Preparation

●Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.

●Created Complex transactional Summary reports involving complex calculation and report design.

●Created Detailed Reports using Drill through capabilities.

●Unit Testing/Integration Testing.

●Assist Business User in User acceptance Test.

●Develop documents like Detail Requirement Document, Unit Testing Document, UAT Document, Application Knowledge Document, Report Specification etc.

Operating MS Windows Server 2003

System

Tools

Cognos 8 BI Suite

Cognos Report Studio 8.3

Cognos Framework Manager 8.3

Chennai, India

May - 2009 to March - 2010 IBM India Private Limited

Title: Flex Global View

Period May, 2009 to March, 2010

Client Name United Parcel Service. USA

Position Tech Lead / Designer

Responsibilities

●Ensure on time closure of the Problem tickets without any deviation from SLA

●Analyze Technical specification and develop code as per the specification for the Enhancements.

●Perform Unit Testing /Integration Testing

●Assisting user in User Acceptance Test via email or over phone to resolve their queries

●Documentation as per SDLC process.

Project

Flex Global View (FGV) is the main visibility application for the UPS-SCS (Supply Chain Solutions). It contains the following four main modules and provides the visibility of goods under all of them:

●Customs Brokerages (CM)

●Purchase Order (PO)

●Transportation (TM)

●Warehousing (WHS)

FGV receives data/information loads in the XML format or flat files format from the following systems:

UPS-SCS Operational systems

●Trading Partner systems (Vendor - Freight status Updates, Exceptions)

●Trading Partner systems (Customers - Orders, Inventory Updates, Receipts)

●UPS Operational systems (Trade Direct Small Package, UPS Boss Customs)

FGV consolidates process and formulate these data loads and persist in its own repository to provide the visibility of different milestones/exceptions to their huge client base. It also restructures these data loads for faster generation of client specific reports. IWR is used for standard reports and Report net is used for Enhanced reports.

Carried out the following activities:

●Involved in Knowledge Transfer sessions.

●Resolved the problem tickets with in the SLA

●Involved in the estimation, design and development and testing for enhancements.

●Created list reports, cross-tab reports and chart- reports using multiple queries in a single report.

●Perform Unit testing, Integration testing and assist user in User Acceptance Testing.

●Develop Unit Test Document, Integration Test Document, UAT Document, Report Specification and Application Knowledge Document for the project.

Operating MS Windows Server 2000, UNIX

System

Languages PL/SQL, SQL, Shell Scripts

Tools

Cognos Report Net,

Cognos Impromptu 7.3

Cognos Power Play Transformer 7.3

IWR

PL/SQL Developer

Pune, India

July, 2005 to April 2009 IBM India Pvt Limited& Artech Info Systems

Title: Panasonic North America

Period July, 2005 to April, 2009

Client Name Panasonic North America

Position Developer

Responsibilities

●Ensure on time closure of the Problem tickets without any deviation from SLA

●Analyze Technical specification and develop code as per the specification for the Enhancements.

●Perform Unit Testing /Integration Testing

●Assisting user in User Acceptance Test via email or over phone to resolve their queries

●Documentation as per SDLC process.

Project

Cognos Decision stream is used with SAP to support many business processes in Panasonic, mainly in area of Finance and sales by Providing Data marts to analyze the data. There are 4 data marts developed by Panasonic namely Sales mart, Inventory mart, Account receivables and General ledger. Source for this Data warehouse are the flat files because SAP version 3.1H is not compatible with decision Stream. ABAP programs are written to extract data to flat files. Every night jobs will run at SAP end to extract data for flat files and ftp’d to the cognos server. Once the files are updated Decision stream jobs will start to update the daily data in the data warehouse. Cognos Impromptu is used for Standard Reports. Multidimensional cubes are developed using Power play Transformer.

Carried out the following activities:

●Creating Fact and Dimension tables and populate those tables both as initial load and incremental load using Decision Stream Jobs.

●Develop Unit test script and perform unit testing.

●Perform Integration testing and assist user in User Acceptance Testing.

● Develop Unit Test Document, Integration Test Document, UAT Document, Report Specification and Application Knowledge Document for the project.

Operating MS Windows Server 2000

System

Tools

Cognos Data Manager 8.2

Cognos Decision Stream 7.3

Cognos Impromptu 7.3

Cognos Power Play Transformer 7.3

Pune, India

Certification

IBM Certified Cognos 8 BI Designer

Trainings Conducted

Year

Title

Presented to

Location

Organised by

2011

Cognos 8

Team Chartis

Chennai

TCS

2007

Estimation techniques

Team Panasonic

Pune

IBM

2012

Cognos 10 Report Studio

GCI Team

Chennai

TCS

Trainings Attended

Year

Title

Location

Organised by

2012

Cognos 10 Boot Camp

Chennai

TCS

2011

Cognos 8 Boot Camp

Mumbai

TCS

2008

Cognos Decision Stream

Pune

IBM

2009

Cognos Report Studio

Pune

IBM

2009

BODI

Bangalore

IBM

Educational Qualification

Degree

Institute

Major and Specialization

Bachelor Of Technology

Bharathiyar University, Tamilnadu

Textile Technology

Contact this candidate