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
• 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, Burst Reports against database.
• Created custom prompted reports in Report Studio.
• Coordinate/assist /develop Cognos framework manager model adjustments to accommodate new and existing business requirements.
• Training end users to effectively use the reporting tool to build and customize their BI and BIA reports.
• Fine-tuned the performance of the reports using performance parameters

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 that 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:

• Gathered 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:

• Gathered 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, Florida

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 highly 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 training sessions on cognos8

Confidential

Reports 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, Missouri

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.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Involved in Documentation and Training Users on Query Studio for Ad-Hoc Reporting

Confidential, Dallas, TX

Cognos Developer

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

Responsibilities:

• Interact with the business users and documented their query, business analysis and reporting needs.
• Understood business logic underlying the requirements, based on that developed test data.
• Oraganized daily status call with the team and Monitored Reporting
• Provide the mockup reports to help the developers.
• Restructured and reorganized several tables, and created indexes for better performance.
• Designed models using Framework Manager and deployed packages to the Report Net Servers