SUMMARY

• IBM Cognos Certified Professional with 10 years of experience in Designing and Development of Relational database applications, Data Warehousing, BI Applications on multiple domains - Banking, Insurance & Manufacturing industries.
• Extensive experience in BI Modeling/Report Authoring using Cognos 8x, 10x (Report Studio, Analysis Studio, Query Studio, Metric Studio, Cognos Connection, Framework Manager, Analysis Studio), Cognos Series, OLAP Cube development using Cognos PowerPlay and Transformer, and implemented security using Cognos Access Manager.
• Experience with DMR Models, Cube data sources in Cognos Framework Manager and published packages to analyze Crosstab reports with Analysis Studio.
• Excellent knowledge on Data Mart Architecture, Data Modeling and Dimension Modeling using Star Schema, Snow-Flake Schema and worked on both OLAP and OLTP databases
• Extensive experience on Production Support and Troubleshoot/Test Issues with existing Reports and Cubes.
• Involved in Cognos upgrades & migrations - Cognos V8.3, 8.4 and 10.1
• Setup security using LDAP and AD, created users groups, roles and assigned them to Cognos in-built roles to secure Studios, objects, reports and packages.
• On-call support person for all Cognos environment issues and is the primary support contact round the clock.
• Installed client tools on developer/users machines and setting up appropriate privileges to publish packages to appropriate folders.
• Developed and Deployed Cognos reports, packages and other Cognos objects from Development to QA and then from QA to production environments.
• Set up training environments for end-user training and created a content store to be able to have a separate environment just for training.
• Used Business Insight and Advanced Business Insight for creating dynamic dashboards in Cognos 10
• Built data analysis capability for Business users using QlikView Dashboard
• Used Advanced features of Cognos 10 like Enhanced Search, Collaboration, Offline Capability for creating Active Reports, etc
• Extensively used Life Cycle Manager and Motio CI v2.1 for regression testing
• Used Motio CI v2.1 as version control tool in Cognos environment

TECHNICAL SKILLS:

BI Tools: Cognos 8x/10x Suite (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Event Studio, Metric Studio), Data Manager, Access Manager, Power Play, Transformer Business Insight, Business Insight Advanced (BIA), SDK and Go Office

Modeling Tools: Cognos Framework Manager, Transformer

Dashboard Tools: QlikView v11

Version Control Tools: Motio CI v2.1 (for Cognos), Visual Source Safe

Regression Testing Tools: Motio CI v2.1, Life Cycle Manager for Cognos

ETL Tools: Ab-initio

Databases: MS SQL Server(2008, 2005), DB2, MS Access

DB Tools: TOAD, SQL Assistant, DB2 Editor

Data Modeling: MS-Visio

Operating Systems: Windows(98,NT,2000,XP,Vista,7), UNIX(IBM AIX), DOS

Languages: Visual Basic, Excel VBA, Java Script (Cognos SDK), XML, C#, VB.Net, ASP.Net

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

Responsibilities:

• Leading an offshore team of 21 team members and onsite 5 team members
• Providing leadership and facilitation in the definition and development of the technical solution, including vision, scope, and system architecture.
• Perform business analysis and requirements gathering in collaboration with business analysts and information delivery team to understand the requirements
• Recommended and Designed Cognos framework model according to the need of the project
• Engaged in project planning, controlling, and documentation
• Involved in Cognos migrations & upgrades
• Migration of Cognos models, cubes and reports fromCognos 8.3 to Cognos 8.4
• Upgrade of Cognos models, cubes and reports fromCognos 8.4 to Cognos 10.1
• Involved in the key new development and enhancement initiatives in the Cognos Framework modeling, Reports, Cognos Cubes, SDK, Go Office, QlikView and IBM OpenPages Cognos.
• Co-ordination with IBM support team for Cognos migration & upgrade issues.
• Involved in upgrading Cognos applications in both Windows andUnix environment and setting up security at Cognos level and data level
• Used Motio CI for version control
• Used Life Cycle Manager and Motio CI for regression testing
• Involved in Project Planning and Effort estimations.
• Frequent interaction and co-ordination with other teams like DBA team, ETL team and testing team.
• Involved on some of the key enhancement initiatives in the existing Cognos Framework, Reports and Cubes.
• Mentoring/Training of new resources within and outside the team.

Business Insight and Analytics

Confidential

Responsibilities:

• Lead an offshore team of 19 team members.
• Perform business analysis and requirements gathering in collaboration with business analysts and information delivery team to understand the requirements
• Involved in Cognos reporting - both new development and enhancements.
• Involved in upgrading Cognos applications in both Windows andUnix environment and setting up security at Cognos level and data level
• Involved in Effort estimations and tasks planning.
• Frequent interaction and co-ordination with other teams like DBA team, ETL team and testing team.
• Involved on some of the key enhancement initiatives in the existing Cognos Framework, Reports and Cubes.
• Mentoring/Training of new resources within and outside the team.

Confidential

Team Member

Responsibilities:

• Involved in Effort estimations and tasks planning.
• Involved in Cognos Reports development - both new development and enhancements
• Involved in FM modeling for Cognos reports.
• Involved in designing and modifying the forms and developing the code
• Handled Authorization for users
• Mentoring/Training of new resources within and outside the team.