Experience Summary

Geetha Govindaswamy has around 9 years of experience and primarily involved in design, development and implementation of applications developed in Cognos (Report Studio, Framework Manager and Query Studio). She worked as a Sr. Developer and her core responsibilities include Report Design, developing FM Packages, Configuring and implementing Cognos reports. She played a key role in Implementing Security at different levels in Framework Manager and Cognos Connection. She also has hands on experience in Cognos 11 and Tableau. She is remarkably good in interacting with Business users and understanding the requirements. She is a sincere team player who works unassisted by taking ownership and responsibility.

She has also worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support. She was involved in performance tuning of Cognos reports.

She is an Expertise in IBM Cognos 10.2 and has been certified in Cognos 10.2 Report Studio. She was actively involved in various project-related activities like mentoring team, audit activities and documentation. She has thirst for learning new technologies and keeps herself updated.

She has worked on projects for clients such as First Data, World Bank, Amex etc.

Technical Skills:

BI Tools : IBM Cognos 11, IBM Cognos 10.2, IBM Cognos 8.4, IBM Cognos 8.3 & Report net, Tableau

ETL Tools : Basics of Informatica

Operating Systems : Windows 2000, Windows XP

Databases : Oracle 11g, SQL Server, DB2

Experience:

Name of the Company

Designation

Duration

Cognizant Technology Solutions (India)

Associate

Jun 2007 - Feb 2012

Cognizant Technology Solutions (India)

Senior Associate

Sept 2012 - Mar 2018

Certificates:

No

Name of Institution

Diploma or Certificate

Year of Completion

1

IBM

IBM Cognos 8 BI Author – Series 112

2009

2

IBM

IBM Cognos 8 Metadata Model Developer – BI0-132

2010

3

IBM

IBM Certified Designer - Cognos 10 BI Reports

2015

Visa Type: L2 EAD (Till April 2020)

PROJECT PROFILE:

Project Title

Clarity Migration and Reporting

Duration

02/01/2015 –03/09/2018

Location

Chennai

Operating Systems

Windows Server 2012

BI DW Tools

Cognos 10.2, Framework Manager, Oracle 11g, Toad, Cognos 11, Tableau

PROJECT DESCRIPTION:

As a part of clarity migration from version 12 to version 13, a new reporting solution was built to track the clarity hours entered by both employee and non-employee (contractor) of First data. This also includes dashboard, reports which have graphical information of various project profits and resourcing details. There were around 80 reports to be developed which will be used by top management level.

CLIENT DESCRIPTION:

First Data Corporation is a global payment technology Solutions Company headquartered in Atlanta, Georgia, United States. The company's STAR interbank network offers PIN-secured debit acceptance at ATM and retail locations. The company handles 45% of all US credit and debit transactions, including handling prepaid gift card processing for many US brands.

ROLES AND RESPONSIBILITIES:

She was involved in requirement analysis and design of project architecture and the functionalities to be structured in to reporting solution. She was also involved in designing Cognos Reports and FM Model. She played a key role in Implementing Security at different levels in Framework Manager and Cognos Connection which involved both data level security and Object level security.

She led a team of 5. She took the responsibility in assigning the team with daily tasks and tracked them till completion. She assisted team with their report development and provided guidance. She has reviewed design documents, peer code and conducted code walkthroughs. She has developed unit test cases and coordinated and supported SIT and Implementation.

She has actively coordinated with offshore and onsite throughout in completing the project successfully. Also she actively coordinated with the client for all the CIC tickets that was raised as a part of production support.

DURATION OF THE PROJECT:

3 years

PROJECT PROFILE:

Project Title

10.2 Migration Activities and Monthly Enhancement Release.

Duration

09/26/2012 – 12/31/2013

Location

Chennai

Operating Systems

Windows Server 2012

BI DW Tools

Cognos 10.2, Framework Manager, SQL Server 2005

PROJECT DESCRIPTION:

In International Finance Corporation (IFC), mainly handles private side lending .The data regarding this funding is made to flow in the system day in and out and it is split into various applications based on the department, And reports are being generated out of system for analysis purpose. All Cognos objects had been migrated from Cognos 8.4 to Cognos 10.2. Along with migration activities, monthly enhancements were performed on an adhoc basis.

CLIENT DESCRIPTION:

IFC, a member of the World Bank Group, is the largest global development institution focused exclusively on the private sector in developing countries.

ROLES AND RESPONSIBILITIES:

She was involved in requirement analysis, design, impact analysis and execution of migration plan. She has tested around 700 reports in lower environments and migrated reports from Cognos 8.4 to Cognos 10.2. She promptly monitored Daily, Weekly and Monthly jobs and published tracker sheet which was delivered automatically as a Cognos report. She keenly Co-ordinated with the team on the daily tasks and tracked them till completion. She has mentored juniors with their report development and provided guidance.

Apart from the above, she has development complex reports and reviewed reports developed by the team members before delivering it to onsite. She has actively coordinated with offshore and onsite throughout in completing the project successfully.

DURATION OF THE PROJECT:

1 Year 3 Months

PROJECT PROFILE:

Project Title

GPD Dashboard

Duration

11/01/2011 – 02/10/2012

Location

Chennai

Operating Systems

Windows Server 2008

BI DW Tools

Cognos 8.4, Framework Manager, SQL Server 2005

PROJECT DESCRIPTION:

This project is to build a reporting solution for the clarity hours entered by both employee and non-employee (contractor) of First data. This also includes reports which have graphical information of various project profits and resourcing details. There are around 30 reports to be developed which will be used by top management level.

CLIENT DESCRIPTION:

First Data Corporation is a global payment technology Solutions Company headquartered in Atlanta, Georgia, United States. The company's STAR interbank network offers PIN-secured debit acceptance at ATM and retail locations. The company handles 45% of all US credit and debit transactions, including handling prepaid gift card processing for many US brands.

ROLES AND RESPONSIBILITIES:

She was involved in requirement analysis and design of project architecture and the functionalities to be structured in to reporting solution. She was also involved in designing Cognos Reports and FM Model.

She led a team of 5. She took the responsibility in assigning the team with daily tasks and tracked them till completion. She assisted team with their report development and provided guidance. She has reviewed design documents, peer code and conducted code walkthroughs. She has developed unit test cases and coordinated and supported SIT and Implementation.

She has actively coordinated with offshore and onsite throughout in completing the project successfully.

DURATION OF THE PROJECT:

3 Months

PROJECT PROFILE:

Project Title

RSR Scenarios Maintenance Release

Duration

07/01/2010 – 10/30/2011

Location

Chennai

Operating Systems

Windows Server 2008

BI DW Tools

Cognos 8.4, Cognos 8.3, Framework Manager, SQL Server 2005

PROJECT DESCRIPTION:

Maintenance Release project primarily involves accommodating additional business scenarios into the ETL processing logic. Also a set of miscellaneous change requests to the Cognos reports in the platform. An exceptional load is being proposed to cater to the exception business scenario handling on a fixed frequency. Also as a part of this project code changes were be made to archive older months of data for past 13 months. 9 reports (RSR Report, CSR Report, and Open Item > 90, All Open Items Report, Item Change Log Report, Transaction Delete Log Report, Match Unmatched Log Report, GLR BLR Log Report, and Master Data Audit Trail Report) had undergone code changes a part of past month archival. These reports were scheduled to archive in a file location and file into Documentum.

CLIENT DESCRIPTION:

The American Express Company, also known as Amex, is an American multinational financial services corporation headquartered in Manhattan's Three World Financial Center in New York City, United States. Founded in 1850, it is one of the 30 components of the Dow Jones Industrial Average. The company is best known for its credit card, charge card, and traveler's cheque businesses.

ROLES AND RESPONSIBILITIES:

She was involved in requirement analysis and design of Cognos Reports and FM Model. She has worked in the development of multiple reports in Cognos 8.4. She has prepared detailed unit test cases for the Change requirements. She assisted juniors with their report development and provided guidance. She has reviewed design documents, peer code and conducted code walkthroughs. She also coordinated and supported SIT and Implementation. She worked on Pre & Post Implementation activities and prepared Hand Over documents.

She has actively coordinated with offshore and onsite throughout in completing the project successfully.

DURATION OF THE PROJECT:

1 Year 3 Months

PROJECT PROFILE:

Project Title

OFI (Oracle Financials Implementation)

Duration

03/01/2010 – 06/30/2010

Location

Chennai

Operating Systems

Windows Server 2012

BI DW Tools

Cognos 8.3, Framework Manager, SQL Server 2005, Quality Center

PROJECT DESCRIPTION:

This is an enhancement project as a part of OFI migration process in the upstream systems where, the input files received from them will undergo a change in terms of precision for account code and balance pool values. Below listed Business Objectives were achieved as a part of this enhancement:

Capability to provide additional attributes of Account and Balance Pool in the reports

Capability to report on Match Utility accounts

Comply with security restriction on access to JV accounts for Amex only users and with Amex accounts for JV only users.

Increase Usability of the existing reports.

CLIENT DESCRIPTION:

The American Express Company, also known as Amex, is an American multinational financial services corporation headquartered in Manhattan's Three World Financial Center in New York City, United States. Founded in 1850, it is one of the 30 components of the Dow Jones Industrial Average. The company is best known for its credit card, charge card, and traveler's cheque businesses.

ROLES AND RESPONSIBILITIES:

She was involved in requirement analysis and design of Cognos Reports and FM Model. She has worked in the development of multiple reports in Cognos 8.4. She assisted juniors with their report development and provided guidance. She has reviewed design documents, peer code and conducted code walkthroughs. She actively coordinated with the other team members on a daily basis to make sure data is tested for all possible scenarios. She verified the test queries, test data and ensured that all the defects are logged in Quality Center. She promptly published the test status report on a daily base.

DURATION OF THE PROJECT:

4 Months

PROJECT PROFILE:

Project Title

BI Server Migration

Duration

12/01/2009 – 03/31/2010

Location

Chennai

Operating Systems

Windows Server 2008

BI DW Tools

Cognos 8.3, Framework Manager, SQL Server 2005

PROJECT DESCRIPTION:

The existing reporting solution was hosted in a shared Cognos 8.3 infrastructure along with the reporting solutions of other applications. A separate Cognos 8.3 infrastructure was to be built to host the reporting solution for AXP Global Accounting Reconciliation unit. IRIS Reports had to be migrated to the new environment and tested thoroughly.

CLIENT DESCRIPTION:

The American Express Company, also known as Amex, is an American multinational financial services corporation headquartered in Manhattan's Three World Financial Center in New York City, United States. Founded in 1850, it is one of the 30 components of the Dow Jones Industrial Average. The company is best known for its credit card, charge card, and traveler's cheque businesses.

ROLES AND RESPONSIBILITIES:

She was involved in analysis of the existing architecture of shared environment and the new environment at a high level. She also was involved in impact analysis of the BI migration. She actively coordinated with the other team on a daily basis to make sure data is tested for all possible scenarios.

She worked on the post production support and promptly addressed all the reporting issues

DURATION OF THE PROJECT:

4 Months

PROJECT PROFILE:

Project Title

AMEX DW&BI Reporting ETL

Duration

09/01/2009 – 12/31/2009

Location

Chennai

Operating Systems

Windows Server 2008

BI DW Tools

Cognos 8.3, Framework Manager, SQL Server 2005

PROJECT DESCRIPTION:

The AXP Global Accounting Reconciliation unit needs a reporting infrastructure to facilitate the pull of information from AXP’s Global Accounts International Reconciliation Information System (IRIS) and GUI for the creation and delivery of reports to end users worldwide.

American Express has selected the IntelliSuite product from SunGard to enable the implementation of the POA Reconciliations process. The IntelliSuite product has major two components. I.e. IntelliMatch and IntelliTracs. The IntelliMatch product consists of the matching engine for both automatic and manual matches. The IntelliTracs product consists of the Research and Clearance modules, Notification, Escalation and creation of automated Journal entries.

The current project is for building a reporting solution on top of this Application which will be across the Reconciliation division to improve the standardization, automation, accuracy, timeliness, comprehensiveness, relevance, and personalization of performance, monitoring and reporting across the business.

The implementation will be across American Express and its customers. The reports to be delivered will cover all phases of the reconciliation process. The requirement and the reporting solution also includes inter region Intercompany reconciliation. The reporting requirements cover all areas of the reconciliation process.

CLIENT DESCRIPTION:

The American Express Company, also known as Amex, is an American multinational financial services corporation headquartered in Manhattan's Three World Financial Center in New York City, United States. Founded in 1850, it is one of the 30 components of the Dow Jones Industrial Average. The company is best known for its credit card, charge card, and traveler's cheque businesses.

ROLES AND RESPONSIBILITIES:

She was involved in requirement analysis and design of Cognos Reports and FM Model. She has worked in the development of multiple reports in Cognos 8.3. She has reviewed design documents, peer code and conducted code walkthroughs. She has developed test plans and was actively involved in unit testing of reports, incorporated quality procedures. She actively coordinated with the client throughout in completing the project successfully.

DURATION OF THE PROJECT:

4 Months

PROJECT PROFILE:

Project Title

ABS Managed Level Reporting

Duration

05/01/2009 – 08/30/2009

Location

Chenna

Operating Systems

Windows Server 2008

BI DW Tools

Cognos 8.3, Framework Manager, DB2

PROJECT DESCRIPTION:

Currently, ABS provides only flagged level data in POS, Cycle Track, Product Split and Credit Adjustment reports. This project will include the not flagged data in the Month End (ME) reports. However, the criteria’s of the BAU report will remain the same for not flagged data and hence, the Business will be provided with the following reports consisting of Managed level data:

POS Reports (New Charge Trust, Consumer Lending, Small Business Lending)

Cycle Track Report. (New Charge Trust, Consumer Lending, Small Business Lending),

Product Split report (New Charge Trust, Consumer Lending, Small Business Lending)

Credit Adjustment report (Consumer Lending, Small Business Lending)

In addition to the above requirement, currently for Credit Adjustment there is a single report for Consumer Lending and Small business lending. After the implementation of this project there will be a separate report each for Consumer and Small Business Lending. Also, there will be separate breakout for ALL-SOLD, ALL-NOT SOLD, ALL-NOT FLAGGED and ALL-ALL, which is currently reported in a single tab in the Credit Adjustment COGNOS report.

CLIENT DESCRIPTION:

The American Express Company, also known as Amex, is an American multinational financial services corporation headquartered in Manhattan's Three World Financial Center in New York City, United States. Founded in 1850, it is one of the 30 components of the Dow Jones Industrial Average. The company is best known for its credit card, charge card, and traveler's cheque businesses.

ROLES AND RESPONSIBILITIES:

She was involved in requirement analysis and design of Cognos Reports and FM Model. She has worked in the development of multiple reports in Cognos 8.3. She has prepared detailed technical and functional documents for all reports. She has developed test plans and was actively involved in unit testing of reports, incorporated quality procedures. She actively coordinated with the client throughout in completing the project successfully.

DURATION OF THE PROJECT:

4 Months

PROJECT PROFILE:

Project Title

Long Term Re-Aging

Duration

03/01/2009 – 04/30/2009

Location

Chennai

Operating Systems

Windows Server 2008

BI DW Tools

Cognos 8.3, Framework Manager, DB2

PROJECT DESCRIPTION:

Re-age is defined as “returning a delinquent, open-end account to current status without collecting the total amount of principal, interest and fees that are contractually due.” System re-aging is a common industry practice; however, American Express does not perform system re-aging. The only re-aging that is done today is manually for CDMP, Amex errors, or if delinquent amounts fall below a specific dollar amount. In light of the challenging economy, the opportunity exists for Amex to offer re-aging to our customers. This project will implement the capability to re-age accounts for customers who have demonstrated their “willingness and ability” to pay down their balance

CLIENT DESCRIPTION:

The American Express Company, also known as Amex, is an American multinational financial services corporation headquartered in Manhattan's Three World Financial Center in New York City, United States. Founded in 1850, it is one of the 30 components of the Dow Jones Industrial Average. The company is best known for its credit card, charge card, and traveler's cheque businesses.

ROLES AND RESPONSIBILITIES:

She was involved in requirement analysis and design of Cognos Reports and FM Model. She has worked in the development of multiple reports in Cognos 8.3. She has prepared detailed technical and functional documents for all reports. She has developed test plans and was actively involved in unit testing of reports, incorporated quality procedures. She actively coordinated with the client throughout in completing the project successfully.

DURATION OF THE PROJECT:

2 Months

PROJECT PROFILE:

Project Title

ABS Co-Brand Segregation – Phase II

Duration

01/01/2009 – 03/01/2009

Location

Chennai

Operating Systems

Windows Server 2008

BI DW Tools

Cognos 8.3, Framework Manager, DB2

PROJECT DESCRIPTION:

The Asset Backed Securitization (ABS) Co-Brand Segregation Phase II project provides the business with the ability to determine and monitor the financial impacts, if any, due to a termination of any of these Co-Brand relationships as required. The business will be able to obtain Co-Brand products in a separate report for each individual portfolio Consumer Lending Trust, Small Business Lending Trust and New Charge Trust. All the Co-Brand products would be reported for the Pool ALL SOLD level and Legal Entity ALL level for the current fiscal month.

This report consists of Trust and Managed breakouts, in which balances are populated for all the co-brands. Below are some of the Co-brand products that would be displayed in the reports after the implementation of this project. Whenever new products (XX, XXXX) are added, they would be displayed as a separate breakout in the report output. Costco, Hilton, Starwood, Jet Blue, New Product XX, New Product XXXX

CLIENT DESCRIPTION:

The American Express Company, also known as Amex, is an American multinational financial services corporation headquartered in Manhattan's Three World Financial Center in New York City, United States. Founded in 1850, it is one of the 30 components of the Dow Jones Industrial Average. The company is best known for its credit card, charge card, and traveler's cheque businesses.

ROLES AND RESPONSIBILITIES:

She was involved in requirement analysis and design of Cognos Reports and FM Model. She has worked in the development of multiple reports in Cognos 8.3. She has prepared detailed technical and functional documents for all reports. She has developed test plans and was actively involved in unit testing of reports, incorporated quality procedures. She actively coordinated with the client throughout in completing the project successfully.

DURATION OF THE PROJECT:

2 Months

PROJECT PROFILE:

Project Title

Prospectus Reporting

Duration

06/01/2008 – 01/01/2009

Location

Chennai

Operating Systems

Windows Server 2008

BI DW Tools

Cognos 8.3, Framework Manager, DB2

PROJECT DESCRIPTION:

Presently the ABS business uses the reports sent by ABS Technology at every Month end, places the required numbers (figures) into an excel spreadsheet adds formulas to it and forwards them to the attorneys (stockholders) etc. This excel spreadsheet is called the Prospectus Reports.

ABS Business wants to automate this process wherein ABS technology would directly generate these reports and forward it to business every month end along with the existing Month End reports. ABS Technology would generate both the Charge and Lending Prospectus Reports.

CLIENT DESCRIPTION:

The American Express Company, also known as Amex, is an American multinational financial services corporation headquartered in Manhattan's Three World Financial Center in New York City, United States. Founded in 1850, it is one of the 30 components of the Dow Jones Industrial Average. The company is best known for its credit card, charge card, and traveler's cheque businesses.

ROLES AND RESPONSIBILITIES:

She was involved in requirement analysis and design of Cognos Reports and FM Model. She has worked in the development of multiple reports in Cognos 8.3. She has prepared detailed technical and functional documents for all reports. She has developed test plans and was actively involved in unit testing of reports, incorporated quality procedures. She actively coordinated with the client throughout in completing the project successfully.

DURATION OF THE PROJECT:

7 Months

PROJECT PROFILE:

Project Title

DSM

Duration

05/01/2008 – 06/01/2008

Location

Chennai

Operating Systems

Windows XP

BI DW Tools

Cognos Report Net, Oracle

PROJECT DESCRIPTION:

Re-design all the nine existing core applications into a web based application, Ability to add new DSM programs with minimal code changes, Capability to change the existing incentive amounts of the existing DSM programs with minimal code changes and Re-design the existing reports over a common reporting framework were the main objective of the project.

CLIENT DESCRIPTION:

Florida Power & Light Company (FPL), the principal subsidiary of NextEra Energy Inc. (formerly FPL Group, Inc.), is a Juno Beach, Florida-based power utility – and the largest electric utility in the state– serving roughly 4.7 million customers and 9 million people in Florida. It generates, transmits, distributes and sells electric energy. It is one of the largest and fastest-growing electric utilities in the United States and is the nation’s leading utility in customer energy efficiency programs.

ROLES AND RESPONSIBILITIES:

She has developed couple of reports in Cognos Report Net. She has prepared detailed technical and functional documents for all reports. She has prepared test cases and was actively involved in unit testing of reports, incorporated quality procedures. She targeted to deliver defect free code.

DURATION OF THE PROJECT:

1 Month

PROJECT PROFILE:

Project Title

Cost and Performance

Duration

02/01/2008 – 05/01/2008

Location

Chennai

Operating Systems

Windows XP

BI DW Tools

Cognos Report Net, Oracle

PROJECT DESCRIPTION:

The objective of Cost and Performance project was to define, design; develop a data strategy for reporting and data analytics to better manage the dimensions of work, resources, performance and financials. Provide BI data warehouse solution to achieve the following benefits:

Financial

Work / Schedule

Resource

Performance Management

CLIENT DESCRIPTION:

Florida Power & Light Company (FPL), the principal subsidiary of NextEra Energy Inc. (formerly FPL Group, Inc.), is a Juno Beach, Florida-based power utility – and the largest electric utility in the state– serving roughly 4.7 million customers and 9 million people in Florida. It generates, transmits, distributes and sells electric energy. It is one of the largest and fastest-growing electric utilities in the United States and is the nation’s leading utility in customer energy efficiency programs.

ROLES AND RESPONSIBILITIES:

She has developed couple of reports in Cognos Report Net. She has prepared low level design document (LLD) and high level design document (HLD) for all reports. She has prepared test cases and was actively involved in unit testing of reports, incorporated quality procedures.

DURATION OF THE PROJECT:

3 Months

PROJECT PROFILE:

Project Title

Telemarketing Tracking Management System (TTMS)

Duration

08/01/2007 – 02/01/2008

Location

Chennai

Operating Systems

Windows XP

BI DW Tools

Cognos Report Net, Oracle

PROJECT DESCRIPTION:

The objectives of Telemarketing Tracking Management System (TTMS): Move the TTMS data from Sybase database to the Data Warehouse (Oracle) and store for 3 years. Create existing ad-hoc reports using Cognos with similar functions of existing reports.

Ability to export reports to excel.

Remove/cleanup Access application.

Remove/cleanup Sybase database.

CLIENT DESCRIPTION:

Florida Power & Light Company (FPL), the principal subsidiary of NextEra Energy Inc. (formerly FPL Group, Inc.), is a Juno Beach, Florida-based power utility – and the largest electric utility in the state– serving roughly 4.7 million customers and 9 million people in Florida. It generates, transmits, distributes and sells electric energy. It is one of the largest and fastest-growing electric utilities in the United States and is the nation’s leading utility in customer energy efficiency programs.

ROLES AND RESPONSIBILITIES:

She has developed couple of reports in Cognos Report Net. She has prepared low level design document (LLD) and high level design document (HLD) for all reports. She has prepared test cases and was actively involved in unit testing of reports, incorporated quality procedures.

DURATION OF THE PROJECT:

6 Months

Contact this candidate