Manager Project

SAI NANDIGAM

Phone: 901-***-****

Email: ***.********@*****.***

Cognos Business Intelligence Analyst

PROFESSIONAL SUMMARY

• 9 years of experience in providing Business Intelligence Solutions with IBM Cognos 10.2.1 Suite,

IBM Cognos 8.4.1 Suite, Cognos ReportNet and Cognos Impromptu.

• Experience in complete Software Development Life Cycle (SDLC) of simple to complex Business

Intelligence projects.

• Specialized in working with BI Tools like IBM Cognos Framework Manager, Query Studio, Report

Studio, Cognos Connection, Event Studio, and Analysis Studio.

• Extensive knowledge on Cognos Go Office and Cognos Analysis for Excel (CAFE).

• Experience in working with Active Reports, Workspace (Business Insight), and Workspace

Advanced (Business Insight Advanced).

• Experience in creating multi-dimensional models and building OLAP Power Cubes using Cognos

PowerPlay Transformer.

• Experience in building Framework Manager models and publishing packages to Cognos

connection.

• Strong in data warehousing concepts and knowledge on ETL mappings using Informatica tool.

• Experience in building various types of reports including List, Cross-tab, Chart, Repeater,

Dashboards, Scorecards, and other irregular pattern layouts.

• Experience in Cognos Administration activities including installation, configuration, job creation,

scheduling, creating exports and imports.

• Experience in writing PL/SQL queries, performance tuning, and troubleshooting in Oracle and

DB2 systems.

• Excellent communication, interpersonal, and leadership skills.

• Prepared best practices on Cognos from the experiences learned on the various projects and

played a key role in creating proof of concepts and winning projects.

• Knowledge on QlikView Business Intelligence and Data Visualization tool.

SKILL SETS

Technical Skills

• • •

Cognos Framework Manager Cognos Report Studio Cognos Query Studio

• • •

Analysis Studio Event Studio Workspace Advanced

• • •

Cognos Go Office and CAFÉ Cognos 10 Transformer Active Reports

• • •

Oracle, DB2 SQL Server Informatica

• • •

Cognos Suite 10.2.1, 8.4.1, PL/SQL TOAD

•

ReportNet QlikView

Business Skills

• Applications: Banking, Finance, Retail, Merchant Payment Processing,

• Methodologies: Agile, Waterfall

Page 1 of 5

Phone: 901-***-****

Email: ***.********@*****.***

• Phases: All phases of Software Development Lifecycle (SDLC)

• Tools & Standards: MS-Office, Sharepoint, CTRL-M

Leadership / Management Skills

• Team Size: Lead teams of up to 10 members

• Industry Standards: ISO, Six Sigma, CMMi

EMPLOYER EXPERIENCE SUMMARY

Employer From To Position

Syntel Consulting Inc, Syntel Ltd May 2006 Present Project Lead/Senior Technical

Specialist/Analyst Programmer

EDUCATION

Bachelor of Technology, Computer Science & Information Technology

Jawaharlal Nehru Technological University, Hyderabad, Andhra Pradesh/India 2003

PROFESSIONAL DEVELOPMENT / CERTIFICATIONS / COURSES

Year Training Program Training Source

2013 IBM Certified Designer - Cognos 10 BI Reports IBM

2013 IBM Certified Developer - Cognos 10 BI Metadata IBM

Models

2010 IBM Certified Designer - Cognos 8 BI Reports IBM

2011 IBM Certified Developer - Cognos 8 BI Metadata IBM

Models

2007 Cognos ReporNet Framework Modeler Cognos

2007 Cognos ReportNet Report Author Cognos

PROJECT DETAILS

Syntel, First Data Corporation, Memphis, TN Jun 2011 – Present

Position: Project Lead/Senior Technical Specialist

First Data Corporation is a provider of electronic commerce and payment solutions. Their portfolio

includes merchant transaction processing services: credit, debit, gift cards, and other prepaid card

offerings. ClientLine is the company's propriety tool that is developed using Cognos and Motio, which

provides a flexibility to the end users to access the payment processing information anytime, anywhere all

across the globe.

Responsibilities:

• Gather requirements from business team and processing those requirements.

• Create Analyze and Design documents per the client standards.

• Distribute work to both onsite and offshore team members and conduct meetings and review

sessions.

Page 2 of 5

Phone: 901-***-****

Email: ***.********@*****.***

• Build Framework Manager models by importing tables and views from the underlying data

source.

• Create and publish packages to Cognos connection.

• Create proof of concepts on multi-dimensional modeling using Cognos Transformer and create

PowerCubes.

• Create various types of reports including List, Cross-Tab, and Repeater and various types of

chart reports including Column, Bar, Pie, Line.

• Create Dashboards and Scorecards per the business needs.

• Implement various techniques and functionalities including: various types of Prompts and

Cascading prompts, drill-through reports, master-detail relationships, custom Joins and Set

operations, bursting of reports, Multi-Lingual Reports, Conditional Reports, Grouping, Sorting,

and Sections, Conditional Blocks and Conditional Variables.

• Participate in performance tuning of time consuming reports.

• Participate in writing manual PL/SQL queries when the situation demands.

• Participate in Unit Testing and SIT for the developed reports according to the test cases prepared.

• Participate in production support activities after post implementation.

• Conduct technical interviews to recruit new resources and knowledge sessions on the lessons

learned.

Key Achievements:

• Successfully migrated more than 100+ reports from .NET to Cognos 8 and Cognos 10.

• Created several proof of concepts on Cognos 10 and played a key role in winning new projects

for the company.

• Successfully integrated Cognos reports and dashboards with both .NET application and Motio.

• Played a key role in preparing best practices and conducting knowledge sessions on Cognos.

Skills Used: Cognos 10.2.1 Suite, Cognos 8.4.1 Suite, Motio, DB2 9, Oracle Exadata, .NET, Toad.

Syntel, American Express, Phoenix, AZ Feb 2011 – May 2011

Position: Technical Specialist

OpenPages coupled business intelligence with enterprise risk and compliance data aggregation and

analysis for unprecedented insight into risk exposure, increased agility, and improved decision making.

American Express employs OpenPages for Integrated Risk Management in order to optimize the

performance of the business.

Responsibilities:

• Gathered requirements from onsite team and was involved in analyze and design activities.

• Created reports like Simple List, Cross-Tab, and Chart.

• Wrote manual SQL queries when the Cognos built-in options failed to meet the requirements.

• Involved in Unit Testing and SIT.

• Created sample data in OpenPages application and cross validated results in Cognos.

• Published Cognos reports to OpenPages application.

• Involved in deploying reports from test region to production region.

Skills Used: Cognos 8.3 Suite, Cognos ReportNet, IBM OpenPages 5.0, Oracle 9

Syntel, American Express, Phoenix, AZ Sep 2006 – Jan 2011

Position: Technical Specialist

Page 3 of 5

Phone: 901-***-****

Email: ***.********@*****.***

American Express is world's recognizable brand providing global financial services for more than 100

years. Apart from card fees, discount fees, revolving money and other income sources, Asset Backed

Securitization is another income source to the company.

Asset Backed Securitization system is a funding vehicle in which American Express Bank Card member

receivables are linked to the global capital markets. Card member's receivables are sold to third party

trusts, which then sell certificates, backed by those receivables, to outside investors. This will improve the

company's liquidity and frees up capital. The main objective of the project is to generate reports using

Cognos to facilitate the client for strategic decision.

Responsibilities:

• Gathered requirements from the client and coordinated with offshore team to process the user

requests.

• Installed and configured Cognos application in Windows environment.

• Imported logical database tables/views from multiple sources and created Framework Manager

Models with star schema layout.

• Creating multi-dimensional models and PowerCubes using Cognos Transformer.

• Created Joins, User Defined Filters, Calculations, Prompts, and Packages

• Created different types of reports including List, Cross-Tab, Chart, Drill-Through, Dash Board,

and Scorecards.

• Implemented functionalities like Report Bursting, Conditional Formatting, Master-Detail, Table of

Contents, and Bookmarks.

• Created project supporting documents in Define, Analyze, Design, Test, and Implementation

phases.

Key Achievements:

• I automated the entire ABS Cognos reporting system, which reduced lot of manual efforts and

saved cost and time.

• Created interactive reports, which allowed business users to directly execute the reports and get

the results on demand according to their choice.

• Actively involved in finding a solution to get automated notification through IMR (ticket) in case of

Cognos Report or Job failure.

• Received “Best Performer” award for providing excellent solutions in Cognos.

Skills Used: Cognos 8.3 Suite, DB2, Control-M, Mainframes

Syntel, Chennai, India May 2006 – Aug 2006

Center of Excellence

Position: Analyst Programmer

Syntel’s Center of Excellence had a dedicated team of shared facility that provided leadership, best

practices, research, support, and training on various areas and technologies.

Skills Used: Cognos 8, SQL Server

Responsibilities:

• Installed and configured Cognos software in development servers.

• Prepared supporting documentation for the key features and functionalities of Cognos tool.

• Conducted technical trainings and brainstorming sessions.

• Conducted interviews for recruiting new resources.

• Attended training sessions on the new technologies and domains.

• Created proof of concepts for the upcoming projects.

Page 4 of 5

Phone: 901-***-****

Email: ***.********@*****.***

Page 5 of 5

Phone: 901-***-****

Email: ***.********@*****.***

Contact this candidate