Scrum Master Project Manager
Resume:
Umamageshwaran Ramasamy
Mobile: +1-717-***-****
Email: **.**************@*****.***
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