SUMMARY:

• Over 8+ years of experience in DataWareHousing
• Strong experience with Cognos Tools such as Cognos 10.2/10.1/8.4/8.3/8.2/8.1 MR2 Suite and Analysis Tools such as Cognos Transformer & Power Play.
• Certified Cognos reports developer (IBM Cognos 8 BI Author)
• Having strong and working knowledge on Cognos Connection, Query Studio, Report Studio and Frame work manager
• Having experience in Active reports using Cognos 10.1/10.2.
• Had knowledge and working experience on Informatica suite.
• Excellent ability to gather and understand business requirements and translate into IT solutions with the use of Cognos
• Having rich experience in creating various types of reports using Report Studio
• Experienced with complete application development life - cycle including requirements gathering, analysis and design, implementing, testing and deployment
• Having good knowledge on HTML and JavaScript and ability to implement those technologies in Cognos reports.
• Excellent Team coordinating Skills with the Development Team and Deliverable dates.
• Strong working knowledge in tools like TOAD, SQL Developer etc.,

TECHNICAL SKILLS:

Cognos: Cognos 10.2 BI, Cognos 10.1/8.4/8.3/8.2 Cognos Connection, Query Studio, Report Studio & Report Net 1.1, Frame work manager Business Intelligence Reports, OLAP solutions and designing and analyzing business and technical models. Installation, Configuration, Developing Reports and Content administration.

Programming: C and Java

Internet Development: HTML, DHTML, CSS, XML & Java Script. Microsoft IIS

Applications/Tools: Informatica power center SSRS Microsoft Office 2007, Toad, SQL *Plus and WinSqL. Text pad.

Database: Teradata, SQL Server, Oracle & MySQL.

Platforms: Windows.

PROFESSIONAL EXPERIENCE:

Confidential, Beaverton, OR

Sr.Cognos Consultant

Responsibilities:

• Collecting and analyzing information requirements from users and translate those needs into requirements documentation.
• Responsible for Designing and developing the reports for a NACS (North American Customer Service)
• Working with Data Warehouse team as needed to define new data warehouse tables needed for reporting,
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query.
• Implement the new dashboards/reports according to the approved prototypes using Cognos report studio and Cognos workspace using the dimensional authoring technique functions and styles.
• Developed Active reports which can be viewed offline by top management.
• Coordinate/assist /develop Cognos framework manager model adjustments to accommodate new and existing business requirements. end users to TEMPeffectively use the reporting tool to build and customize their BI and BIA reports.

Environment: Cognos10.2/10.1 (Cognos Connection, Framework Manger, Report Studio, Cognos Workspace, Cognos Workspace Advanced, Active Reports), Teradata, Java Scripts (HTML).

Confidential, OH

Senior Cognos BI developer

Environment: Cognos 8.4/10.1, Teradata 12.0, HPSD 4.5

Responsibilities:

• Involved with business and functional people to collect and gather requirements
• Implemented Mock report layouts before the actual report implementation.
• Creating models in frame work manager and published the packages to servers.
• Created List reports, cross tab reports, charts, sectional reports, Dash board & Drill through reports by using Report studio.
• Creating value prompts, Date & time prompts, Text box prompts, cascading prompts
• Hide and Show the objects by using conditional blocks
• Implemented java script in reports.
• Involved and performed unit testing (manual testing) for the reports dat have been developed.
• Developed multi format reports (PDF, Word, HTML & Excel).
• Raised tickets and interact with different teams for migration of code (Teradata views, packages and reports) to different environments.
• Involved in the Unit Testing of the reports and preparing the Test cases

Confidential, NJ

Senior Cognos BI developer

Environment: Cognos 8.4, Oracle 8.1.7, Windows XP

Responsibilities:

• Gatheird Business requirements for creating the Models.
• Developing Standard Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Using Scheduler Schedule the reports Daily, Monthly, Yearly.
• Created Prompts to User Defined Filters.
• Good knowledge in Unit/integration Testing
• Extensively worked on TOAD tool, testing the queries

Confidential, Philadelphia

Cognos Developer

Environment: Cognos Report Net 1.1, IIS, TOAD 7.0, Oracle 8.1.7, Windows XP.

Responsibilities:

• Gatheird Business requirements for creating the Models.
• Developing Standard Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Using Scheduler Schedule the reports Daily, Monthly, Yearly.
• Created Prompts to User Defined Filters.
• Used Cognos Scheduler to schedule the Reports
• Good knowledge in Unit/integration Testing
• Extensively worked on TOAD tool, testing the queries

Confidential

Cognos Developer

Environment: Cognos 8.1, Windows XP, SQL Server - 2005, Powerplay ransformer 7.2

Responsibilities:

• Created various reports using different lists in single and multiple pages according to filter conditions.
• Requirement gathering from business and client interaction.
• Created Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis.
• Used Conditional Variable to display different colors and for text according to format.
• Used Designing the reports and bursting the reports.
• Used Schedule Management to schedule the reports.
• Involved in migration of Cognos ReportNet to Cognos 8.

Confidential, TX

Cognos Developer

Responsibilities:

• Creation of framework manager models and packages
• Configuration of Web server and cognos configuration
• Working with different projects in Framework manager
• Creation of packages in framework manager
• Working with cognos connection to run and schedule the reports
• Creation of Reports using Report studio
• Conducted sessions on cognos8

Environment: Cognos8.3 BI Modeling, Cognos8.3 BI Server, SQL Server 2005

Confidential

ETL Developer

Environment: Informatica 8.6, Oracle 11g, UNIX,Toad.

Responsibilities:

• Analyze the ETL mappings and finding the details about source, target and Mapping logic
• Developed the ETL mappings according to technical standards
• Responsible for the creation and configuration of session tasks and workflows using Workflow Manager.
• Collect the data from the different teams like BO,PL/SQL,BODS
• Creating the tables based on the requirements.
• Involved in Unit Testing and preparing the test cases.

Confidential

Cognos Reports Developer

Environment: Cognos Report Net 1.1, SQL Server 2000 and Windows XP.

Responsibilities:

• Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
• Created Reports using Tabular SQL to reduce the load on the Framework Manager model
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entries in the report.
• Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.
• Involved in Documentation and Users on Query Studio for Ad-Hoc Reporting