SUMMARY:

• Around 10+ yrs of experience in Software Development including 8+ yrs of experience in Data Warehousing.
• Good knowledge of Data warehouse concepts.
• Having hands on experience of Cognos Server and Portal administration, installation of various cognos products on windows environment and configuration tasks
• Hands on Experience on the migration of Cognos 7.4/8.1/10 cubes and reports to Cognos 8.4
• Hands on Modeling Business Layer using Framework Manager for dimensional and relational models
• Has experience in requirement analysis, design, developing and testing various types of reports for various projects ranging from simple to complex reports.
• Experience in designing and development of reports using Cognos Series 7 and Cognos 8 and 10 Suite of products
• Good knowledge in Cognos Transformer cube design, builds Analysis Studio for multi - dimensional reporting.
• Automation of cube builds process and deployments.
• Good conceptual knowledge in Data Warehousing, OLAP and report generation using
• COGNOS - (8, 8,10, ReportNet, Impromptu, Transformer 7.3,8,10, Power play, Cognos Workspace).
• Having experience in application development using Visual Basic 6.0.
• Having Knowledge in Cognos TM1,Informatica,OWB,Composite server,SSRS,Qlikview,Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Plano- Texas

Data warehouse/ Cognos Lead

Tools: and Technologies: Windows 2008 Server, Data Stage, Cognos 8.4, 10, Oracle, Daptive, Netezza

Responsibilities:

• Support the tickets raised in the HP Quality Center ticketing system
• Change and update the tickets and prioritize based on the ticket severity
• Schedule and Monitor the Cube build process, reports and jobs through batch scripts and portal administration
• Design, Build and deploy the Transformer cubes in different environments
• Export and Import of the packages/reportsto different environments
• Installation and configuration of Cognosproduct tools and fix packs.
• Content store backup on regular basis
• Development and test of various objects to Netezza db.
• Design of cognos dashboards as per requirement.
• Re-design and optimize to match/improve performance of the application
• Design of cognos mobile reports using IBM cognos apps for android and ios using Active report functionality in cognos 10.2
• Upgradation of cognos 8.4 objects to cognos 10.1 and validation and fixes any required.
• Ensure same end-user experience and usability of the tool,with no impact and accuracy of data
• Installation and configuration and updgradation tocognos 10.2.1 on windows server 2003
• Active reports for mobile version of Iphone and Anroid phones

Confidential

Data warehouse/ Cognos Lead

Tools: and Technologies: Windows 2000 Server, Oracle 8.3, Cognos 7.3 Series, Cognos8.4

Responsibilities:

• Weekly status call with client on business understandings
• Requirement Analysis of the existing system and compatibility study of the Cognos environment
• Design of the Cube models using Framework Manager model
• Installation and configuration of Cognos in distributed environments
• Generation of the iqds from the Framework manager
• Administered tasks such as Scheduling, Deployment
• Export and Import of Packages into different environments
• Creation of data sources backup of the Content store

Confidential

Data warehouse/ Cognos Lead

Tools: and Technologies: SunsolarisUNIX and Cognos 8.4

Responsibilities:

• Interaction with client for requirements and business clarifications
• Maintenance of cubes and CR’s to the existing cubes
• Development of new reports as reqd and troubleshooting to the existing reports
• Cognos 8.4 installation and configuration tasks - involved in the installation of Cognos 8.4 Fix pack 2 on Sunsolaris OS
• Content Store back on regular basis
• As Cognos core team need to help the internal report development team and troubleshoot their issues.
• Publish and deployment of packages from one environment to another environment
• Assigning of the user groups for the various packages
• Implementation of CRs and troubleshoot the various issues in Cognos applications
• Design of the report specifications and development of reports using report studio.

Confidential

Tools: and Technologies: Oracle9, Informatica, Cognos 8.3

Responsibilities:

• The following are the roles and responsibilities performed
• Regular calls with the onsite team on the status
• Client interaction on the business understanding
• Analysis and modeling business layer using Framework Manager
• Developed model and published package.
• Interacting with the client on a regular basis for business clarifications

Confidential

Cognos Sr. Developer

Tools: and Technologies: Cognos 8.3, Oracle 9i, OWB

Responsibilities:

• The following are the roles and responsibilities
• Coordinated the team on the deliverables
• Weekly status call with onsite coordinator and client
• Created Dynamic column reports based on the Prompt values selected.
• Created Cascade Prompts and various prompts as per requirement.
• Created drill through reports to link two or more reports.

Confidential

Cognos Developer

Tools: and Technologies:Crystal reports, ReportNet 1.1MR3, Cognos 8, Oracle 9i

Responsibilities:

• The following as the roles and responsibilities performed
• Created filters and prompts to reports to add interactivity for users.
• Created drill through reports to link two or more reports.
• Created reports using conditional formatting.
• Created various kinds of reports using report studio.
• Created report using Tabular set.
• Created master detail reports.

Confidential

Developer

Tools: and Technologies:Oracle 8i, Informatica 6.1, Cognos 7 Series Impromptu

Responsibilities:

• Creating catalog and connecting between impromptu and data source through ODBC.
• Creating catalog to build various kinds of Reports using prompts and other features
• Involved in reports using hot file, snapshots.
• Creating various kinds of reports using impromptu for end user.
• Creating joins to get the necessary detailed data from tables.

Confidential

Programmer Analyst

Tools: and Technologies: Oracle 8 and Visual Basic 6

Responsibilities:

• As a Team member involved in requirements gatheringAnalysis and design of the product
• Coding and testing of product