SUMMARY

• IT Professional with four years of experience comprising of extensive Functional and Technical experience in Data analysis, Business Intelligence (BI)/OLAP, gathering data requirements and converting them into and reports.
• Experience in gathering Business requirements, Analysis, Design, Development, Testing and Implementation of Cognos applications and End - user training.
• Extensive experience working with Cognos BI Series 10.x, 8.4/8.3/8.2 (Framework Manager, Report Studio, Query Studio, Metric studio, Analysis Studio, and Cognos Connection).
• Delivered solution-oriented complex reports using Report Studio, ad-hoc reporting interfaces using Query Studio, multi-dimensional analysis & visualizations from OLAP cubes using Analysis Studio, created checkpoints & alerts in Event Studio, and developed scorecards & metrics in Metric Studio.
• Experience in working in all the phases of Software Development Life Cycle (SDLC). Great skills of capturing data requirements through user interviews, JAD sessions, interviews etc.
• Imported in metadata from multiple data sources to build Multi Dimensional Models and published Packages from Framework Manager to Cognos Connection portal.
• Strong data modeling skills (Normalized and Multidimensional for Data Marts, including Star Schema, Snow-Flake Modeling, Fact and Dimensional Modeling)
• Involved in entire development lifecycle process of data warehouse applications.
• Experience in working with various Relational Databases like MS-SQL Server, Oracle, MS Access, and Teradata.
• Extensive knowledge in SQL programming / Stored Procedures.
• Team player, motivated and dynamic with excellent oral and written communication skills.

TECHNICAL SKILLS

Reporting Tools: Cognos 10.2 & 8.1/2/3/4(Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio, Cognos Connection)Operating Systems Windows XP/7/8, Windows NT 4.0, UNIX, LINUX

Languages: SQL, TSQL, PL/SQL

ETL Tools: Informatica 9.5, SSIS

Databases: MS-SQL Server, Oracle, Teradata, DB2 and MS-Access

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Cognos BI Developer

Responsibilities:

• Interacting with Business Users for gathering Business Requirements to develop the report mockups.
• Designed & developed multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Developed Dash Board reports, Scorecards, Visual Layouts, Master detail Drill through reports, Drill up and Drill down reports, multiple prompt reports and cascading prompts in Report Studio.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Worked on multiple databases, and multiple data sources in Framework Manager to generate reports.
• Implemented different functionalities using report filters, sorting, multiple queries and conditional blocks.
• Created conditional variables to change the graph headers and list column headers based on the user parameter selection.
• Developed security for reports, Conditional formatting, Bursting and scheduling of the reports
• Developing technical specification documents for the reports
• Involved in development and production testing and peer reviews
• Performance tuning of the reports

Environment: Cognos 10.2 & 8.4 (Query Studio, Report Studio, Analysis Studio, Cognos Connection, Framework manager), Teradata 14, Microsoft Excel, Windows 2008 Server, LDAP.

Confidential, Herndon, VA

Cognos Developer

Responsibilities:

• Interacted with the business users to gather and refine requirements.
• Interacting with the ETL team to get the exact data model for the reports to be developed.
• Utilized Framework Manager for metadata modeling created and published packages to the Cognos connection.
• Created complex dashboards, simple list reports, Crosstab reports and various Drill-Through reports according to the requirements.
• Created various reports which have multiple prompts, pages, filters, various HTML codes and conditional variables.
• Involved in converting the existing java reports into new Cognos reports.
• Helped improve the performance of the reports by tuning the SQL queries, removing the unnecessary filters.
• Interacted with the data modelers to improve the performance of the reports.
• Involved in the deployment of packages from development to test and then to production environment.
• Executed the unit as well as system testing of the reports developed.
• Involved in the technical design documents and utilized the rational clear case for the document management.

Environment: Cognos 8.3,Cognos Connection, Report Studio, Query Studio, Framework Manager,, HTML, XML, MS SQL Server 2008

Confidential, Schaumurg, IL

Cognos Developer

Responsibilities:

• Developed List, Crosstab and Dash Board reports in Cognos 8.3
• Created metadata model using framework manger model according to the cognos best practice model(Physical Layer, Staging Layer, Logical Layer and Subject area)
• Performed daily, weekly and monthly support to the business users
• Involved in converting the functional specifications to technical documents.
• Developed the Month end reports
• Supporting the business users with their ad hoc requests and delivering them on timely basis
• Activating and deactivating filters according to the prompt selection
• Created different kinds of prompt reports, list reports and cross tab reports
• Worked on complex drill through reports.
• Involved in building the reports with conditional formatting and conditional blocking for different kinds of business requirements
• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Building models and publishing packages in Framework Manager to the Cognos 8.3 portal.
• Development of ad-hoc reporting interfaces using Cognos Query Studio.

Environment: Cognos 8.2 / Cognos 8.3 (Cognos Connection, Cognos Framework Manager, Report Studio, Query Studio, Analysis Studio), SQL Server 2008, Teradata 12.