Summary

. * years of experience in IT industry working for Infosys Technologies

with 5+ years of experience in Cognos BI tools.

. During this period I worked as a Software Developer, Team Lead from

Offshore Development Centre from Dec 2004-Jan 2007. Worked as an

Onsite Co-Ordinator, Module Lead and Business Analyst for Cognos

reports at Client location in Walnut Creek, California, US from Feb

2007 - Apr 2009 and currently working as a Technology Specialist at a

Client location in Atlanta, Georgia, US from Oct 2009.

. Responsibilities includes Cognos 8.4 Metric Studio Scorecards,

Diagrams design and development, Report design & development,

deployment & maintenance of the Cognos 8.4 reports, Project Management

for Cognos module, Onsite-Offshore Coordination, Project

planning, gathering Report Requirements and providing Production

Support.

. Worked on Cognos 7.3 to Cognos 8.2 migration and Cognos 8.2 to Cognos

8.4 migration project.

. Worked in various technologies which includes 2 years experience in

Cognos Impromptu 7.3 Reporting Tool, 2.5 years experience in Cognos 8

Reporting Tool (version 8.1/8.2/8.3/8.4) including 1.5 years

experience in Data ware house, 4 years in DB2 and 1.5 years in SQL

Server 2005 for reporting purpose, 1 month development project in

J2EE, 2 months experience in Testing Project.

. Domain experience in Finance and Mortgage Insurance.

Professional Experience

Company Location Duration & Designation

Infosys Technologies Atlanta, GA, USA Oct 2009 - Till date(Technology

www.infosys.com Mysore, India Specialist)

Walnut Creek, CA, April 2009 - Oct 2009(Program Analyst)

USA

Mangalore, India Feb 2007 - Apr 2009(Program Analyst)

Bangalore, India Dec 2004 - Jan 2007(Software Engineer)

July 2004 - Dec 2004(Software Engineer

Trainee)

Environment Familiar With

Reporting Tools Cognos 7.3, Cognos 8.1/8.2/8.3/8.4

Business & Analysis Business/System Analysis, Data Analysis, Requirement

Skills Gathering (BRD creation)

DBMS & Languages DB2, SQL Server 2005, MS Access, Data ware housing,, C,

C++, J2EE, JSP, Cobol, JCL

Operating Systems Windows XP, Vista, Unix

Tools Test Director, Mercury Quality Center, Requisite Pro,

Irwin ER Modeller, LiveMeeting, WebEx,

Source Code Control Visual Source Safe, CVS, Win CVS

Organizational Experience:

. Project Description:

NAME Business Compliance And Monitoring

DURATION Oct 2009 - till now

CLIENT Sun Trust Bank, Atlanta, GA

ROLE Business Analyst, Onsite coordinator, BI Designer

Description: This project involves consolidation of various data

sources, developing a data warehouse, developing a performance

measurement application that includes scorecards, dashboards, impact

diagrams, strategy maps and operational reports. The main objective of

this project is data consolidation and better performance management by

tracking the key performance indicators (KPI).

Responsibilities:

. Understanding the business domain of Client.

. Communicating with the SME as a business analyst to understand the

business requirements for Metric Studio Components, Reports and

Requirements for the Warehouse.

. Analysis and Documentation of the various source systems to facilitate

the Warehouse Design.

. Project Management for Cognos module including Onsite-Offshore

Coordination, weekly status update to Client about the project and

milestones, Effort Estimations and Project Planning.

. Cognos 8.4 Metric Studio components Design and Development, including

Scorecards, Impact Diagrams, Strategy Maps(Custom Diagrams), Metric

Extracts, Object Extracts, Loading Data using Files, Scorecard

Customizations etc.

. Cognos 8.4 Report Design, Development, Testing, Deployment etc.

. Integrating Metric Studio and Report Studio Components.

. Cognos model and package design and development using Cognos 8.4

Framework Manager.

. Project Description:

NAME Delta Sky Miles Debit Card Reporting

DURATION May 2009 - Sep 2009

CLIENT Sun Trust Bank, Atlanta, GA

ROLE Cognos Designer, Module Lead

Description: This project involved developing Cognos Reports to Track

the Acquisition and Usage details of the SunTrust Delta Sky Miles Debit

card. The Project comprised of an Interim Solution using Information

Integrator Classic Federator (IICF) as a data source. The main solution

included Data warehouse Development, ETL using AB Initio and Reporting

using Cognos 8.4 Report Studio. The main objective of this project was

tracking the card usage details using Cognos Reports, Data Volume being

the main challenge.

Responsibilities:

. Understanding the business domain of Client.

. Creation of the Federated Database and providing inputs to create the

Warehouse.

. Cognos 8.4 Report Design, Development, Testing, Deployment etc.

. Cognos model and package design and development using Cognos 8.4

Framework Manager.

. Requirement Analysis, Unit Test Plan, Design and Code Reviews.

. Effort Estimations and Project Planning.

. Project Description:

NAME PMI Central Cognos Report Migration

DURATION Feb 2008 - Apr 2009

CLIENT Private Mortgage Insurance, Walnut Creek, CA

ROLE Cognos Reports Designer, Onsite Coordinator, Module

Leader, SME

Description: This project involved migration of all PMI Central Cognos

7.3 Reports to Cognos 8.2. The main objective was to upgrade to Cognos

8.2 and subsequent maintenance of reports after migration. This Project

was done in collaboration with IBM Cognos Inc.

Responsibilities:

. Playing the role of an SME to elicit the Cognos 7.3 Report

Requirements so that the reports could be migrated, this involved

Reverse Engineering the Cognos 7.3 Catalog and Impromptu Reports and

documenting the requirements.

. Working with Business Users to gather requirements to enhance the

reports during migration.

. Migration Strategy Creation, Design, Development and Testing of

Migrated Reports.

. Test Plan creation, Environment set up and Deployment.

. Project Management, Onsite-Offshore Coordination, Effort Estimations

and Project Planning.

. Project Description:

NAME Claim/ Delinquency Cognos Reporting Project

DURATION Feb 2007 - Feb 2008

CLIENT Private Mortgage Insurance, Walnut Creek, CA

ROLE Cognos Reports Designer, Onsite coordinator, Module

Leader

Description: This project involved developing Cognos reports using

Cognos Impromptu reporting tool for PMI. The main objective was to

develop Cognos 7.3 reports and provide production support to existing

reports.

Responsibilities:

. Cognos 7.3 Report Design, Development, Testing, Deployment and

Production Support.

. Cognos Catalog Design and Development.

. Worked on Cognos 7.3 to Cognos 8.2 reports migration planning .

. Understanding the business domain of Client and communicating with the

Client team as a business analyst to understand the business

requirements for reports and delivering the expected deliverables.

. Project management for Cognos module including Onsite-Offshore

Coordination, Effort Estimations and Project Planning.

. Leading the team as Module Leader and Onsite Co-Ordinator.

. Project Description:

NAME Risk Share Cognos Reporting Project

DURATION Mar 2005 - Feb 2007

CLIENT Private Mortgage Insurance, Walnut Creek, CA

ROLE Cognos Report Developer, Module Leader

Description: This project involved developing complex Cognos reports

using Cognos Impromptu reporting tool for PMI. The main objective was to

develop Cognos 7.3 reports and provide production support to existing

reports.

Responsibilities:

. Cognos 7.3 Report Design, Development, Testing, Deployment and

Production Support.

. Cognos Catalog Design and Development.

. Understanding the business domain of Client and communicating with the

Client team as a business analyst to understand the business

requirements for reports and delivering the expected deliverables.

. Onsite-Offshore Coordination, Effort Estimations.

. Working as a Developer and then as Module Leader.

. Project Description:

NAME Infosys Fresher's Training

DURATION Aug 2004 - Dec 2004

ROLE Underwent a TRAINING for 4 months on computer

technologies with special focus on Mainframes

technologies namely, COBOL, JCL, DB2, CICS.

Academic Qualification / Achievements

Examination Board/University Year Aggregate

B.Tech. MIT, Manipal, India 2003 74.03

(Mechanical Engg)

12th Karnataka State Board 1999 83.33

10th Karnataka State Board 1997 86.24

. Received "Most Valuable Professional" special award in recognition of

outstanding achievement for the contribution towards the Cognos

Migration Project at the Client Location.

. Received certificate of appreciation for the "Best Project Award" for

the second quarter 2009 and the fourth quarter 2009 .

. Received "On the Spot Award" on multiple occasions for my outstanding

performance.

. Received certificate of appreciation for the "Best Project Award" for

2006.

. Received certificate of appreciation from Client (PMI) for the key

role played (Cognos Expert) in successful implementation of their

application.

. Submitted Technical articles published in KShop, Infosys online

knowledge library.

. Received Loma's step one certification in Insurance domain.

. Received IBM Cognos 8 BI Author certification.

. Received IBM Cognos 8 BI Administrator certification.

Other Experience

. Worked on PMI Central Risk Share Project as a J2EE Developer

for their Rating Agency Module for Four weeks.

. Worked as Test Engineer for two months. Used certain testing

tools such as Beyond Compare, etc.

. Worked on some Request for Proposal (RFPs) including one for

Security and Exchange Board Of India (SEBI).

Technical Articles Published

. Cognos Tips and Tricks: Some tips on usage of Cognos Impromptu

Reports.

. Cognos Impromptu Guide: Basics of Cognos Impromptu Reports.

. Cognos 8 Admin Guide: Basics of Cognos 8.4 Reports.

Contact Details

Contact Email abl693@r.postjobfree.com

Contact Phone 678-***-****(mobile)

Visa Status US H-1B Visa till Jun, 2011. Can be extended for another

2.5 years

Current Address 125 Marsh Trail Circle, Atlanta, GA - 30328

Contact this candidate