SUMMARY

• 8 years’ experience on Business Intelligence and in different phases of software development life cycle (SDLC) including requirement, analysis, design, development, testing, deployment and support.
• Administration: - Installation, Configuration, performance tuning across multiple environments (Development, Test, and Production) and Ensure solutions and deliverables are 100% compliant with the Client’s SDLC and meet controllership and audit standards.
• Developed and Published Packages using Framework Manager & Adaptive warehouse - Connecting and testing the data source, created database layer, business layer & presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Created models and reports in Cognos 10.1.1 and 8.4 (Adaptive warehouse, Adaptive Analytics, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, and Business Insight).
• Expertise in OLTP/OLAP System Study, Analysis and ER modeling, Developing Database Schemas (Star Schema and Snowflake Schema) used in Relational, Dimensional and Multidimensional Modeling by Erwin tool.
• Extensive experience in Oracle 11g, 10g, 9i, PL/SQL, SQL, Functions, SQL Server 2005/2008.
• Complex Report building experience in Report studio by using prompts, filters, session parameters, conditional formatting, drill-through and drill-down using Report Studio.
• Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship.
• Developed and maintained dashboards and apply data visualization best practices using Active Reports, Report Studio. Developed reports using External Data Source such as Excel, Text and CSV files.
• Have Administration experience in Cognos 11.0, 10.1.1 & 8.4 and applied data level and user level security for Framework Manager Packages, reports.
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• Extensive experience with Cognos security (LDAP, Active Directory, object level security, data security).
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• Experience interacting with Business Users and gathering the design requirements in order to develop reports.
• Have excellent problem solving, time management skills, communication skill, good organizational skill, self- motivated, hard working, ability to work independently or cooperatively in a team and eager to learn.

TECHNICAL SKILLS

OLAP Tools: Cognos 11.0,10.2.2,10.1.1, 8.4/8.3/8.2/8.1 (Adaptive warehouse, Adaptive Analytics Framework Manager, Query Studio, Business Insight, Report studio, Event studio, Metric Studio, Analysis Studio, Cognos Connection, Transformer).

R D B M S: Oracle 11g, 10g, MS SQL Server 2005/2008, Teradata, DB2.

Programming Languages: SQL, PL/SQL, C, C++.

Operating Systems: Windows XP, Windows 7, Windows Server 2003/2008, UNIX.

Methodologies: Water Fall Model, Agile Methodology.

Data Modeling: Star Schema modeling, Snow Flake Schema modeling and Erwin tool.

Scripting Languages: HTML, DHTML, JavaScript.

Other Tools: MS Office, MS Excel, MS Power Point

Testing: ETL Testing, Unit Testing.

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Senior Cognos Developer/Administrator

Responsibilities:

• Installation and configuration of Cognos 11.0,10.1.1 in both Non Prod and Prod environments.
• Analyzed the business requirements and developed models using Cognos framework manager & Adaptive warehouse and published packages for reports development. Installed client tools for developers.
• Widely used Report Studio to create various types of reports like List, Cross tab, Chart, Sectioning, Drill through, Drill up/down, Master detail etc.
• Developed Standard Reports, Charts, and Drill through Reports and Burst Reports Using Report Studio.
• Generation of reports using Conditional Styles, Conditional Blocks, Render Variables.
• Bursted and Scheduled the reports according to the user requirement.
• Migrate ETL code from Environment to Environment and validate the changes.
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• Created source to target mapping documents for both Cognos 8.4 and also for Cognos 10.1.1 applications.
• Created few Active Reports and demonstrated Active Report functionality to users.
• Trained business users in query studio and report studio, suggested business users how their information can be effectively displayed by using different graphs and charts in Dashboards. (Conveying information they need concisely).
• Responsible for upgrading reports from Cognos 8.4 to Cognos 10 in (Dev, UAT, QA) and Production environments and validated using life cycle manager.
• Maintain AW and Framework models to support for Reporting application in both Cognos 8.4 and Cognos 10.1.1.
• Troubleshooting data related issues in the reports.
• Worked on Cognos Security to restrict the users and created different Group’s / Roles and assign the user’s to specific Groups.
• Renewed cognos related cryptographic keys in both Cognos 8.4 and 10.1.1 applications.
• Renewed SSL/Webserver certificates for accessing the Cognos application.
• Involved in resolving many critical production related issues.
• Customized Cognos Connection Portal to personalize the homepage.
• Provided access to users from data perspective and add the user security to have access to the Orgs.
• Performed monthly maintenance activities like refreshing data, loading new data into tables and also used to deliver the reports to users according to the requirement.
• Unit Tested the Reports and verified the report output’s with business requirements.
• Worked on all Production issues and incidents related to the reports/data.
• Provide support to all Cognos issues and maintain knowledge on all new techniques and prepare reports for all warehouse functions.
• Handled multiple projects at time.

Environment: Cognos 11.0,10.1.1 and Cognos 8.4 (Adaptive warehouse, Adaptive Analytics, Framework Manager, Report Studio, Query Studio, Business Insight, Business Insight Advanced), Oracle 11g, Windows 2003 and windows 2008 servers.

Confidential, Rochester, NY

Senior Cognos Developer

Responsibilities:

• Interacted directly with Business users for functional specifications of the reports.
• Created various Report Specification Documents where Business Objects Reports are needed to convert into Cognos Reports.
• Imported data from different Data Sources in Framework Manager Models to create query subjects, Dimensions, Measures for developing Star Schemas.
• Used Branching and Merging to update FM models by multiple developers/Users.
• Migrated Framework Packages and Reports from One Environment to another Environment.
• Developed canned and Ad-hoc reports (List, Crosstab, Charts, Drill Up-Down, Drill Through reports) using Report Studio and Query Studio.
• Created several Dashboards using Business Insight so that the business users can make strategic decisions.
• Generation of various Pie Chart, Bar Chart, and Line Chart on Master/detail and cross tab reports.
• Scheduled the reports for publishing according to the requirements.
• Unit tested the Reports and Verified the Output of Cognos Reports Matches the Output of Business Objects Reports.

Environment: Cognos 10.1.1(Framework Manager, Report Studio, Query Studio, Business Insight, Business Insight Advanced), Business Objects 6.5, Oracle 11g, SQL Server 2005, Windows XP.

Confidential, Miami, FL

Senior Cognos Developer/Administrator

Responsibilities:

• Interacted directly with Business users for functional specifications of the reports.
• Loaded the data from Oracle (source) to SQL Server (Target) database using Stored Procedures for Testing.
• Implemented the best practices in Framework Manager Models like creating different Namespaces for imported Data Source Query Subjects i.e Physical View, Business View and Presentation View.
• Imported data from different Data Sources in Framework Manager Models to create query subjects, Dimensions, Measures for developing Star Schemas.
• Widely used Report Studio to create various types of reports like List, Cross tab, Chart, Sectioning, Drill through, Drill up/down, Master detail etc with dynamic parameter passing across the reports.
• Created reports using different types of prompts like Text Box Prompt, Value Prompt, and Prompt Button etc with different conditions.
• Developed canned and Ad-hoc reports (List, Crosstab, Charts, Drill Up-Down, Drill Through reports) using Report Studio and Query Studio.
• Used various query components of Report Studio including Join, Union and Intersection.
• Created several Dashboards using Business Insight so that the business users can make strategic decisions.
• Prepared CRD’s for Migrating reports from Development Server to Production Server.
• Unit Tested the Reports and verified all the requirements.

Environment: Cognos 10.1.1(Framework Manager, Report Studio, Query Studio, Business Insight), Cognos Connection, Oracle 11g, SQL Server 2005, Windows XP, Microsoft Office Excel 2007/2005, Windows Server 2008.

Confidential, Pittsburgh, PA

Cognos Developer/Administrator

Responsibilities:

• Gathering functional requirements, analyzing and transforming them into BI Reporting specifications.
• Migrated Framework Models, Packages and Reports from cognos 8.4.1 to cognos 10.1.1.
• Assisted in the Data Mart design for reporting and process flow of Data Warehousing. Working with Data Architect team and ETL team to get the required data for the reports.
• Implemented the best practice in Framework Manager Models like creating different Namespaces for imported Data Source Query Subjects, Business View and Dimensional Model.
• Imported data from different Data Sources in Framework Manager Models to create query subjects, Dimensions, Measures for developing Star Schemas.
• Used Branching and Merging to update FM models by multiple developers/Users.
• Used Page Breaks, Calculation, conditions, Sections, ranking, sorting, various prompts and burst options within Report Studio.
• Scheduled Reports based on the request from users.

Environment: Cognos 10.1.1, 8.4 (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight), Cognos Connection, Oracle 11g/10g, SQL Server 2008, Windows XP.

Confidential, New York, NY

Cognos Developer

Responsibilities:

• Gathering, analyzing and documenting business requirements from the business users for enhancements.
• Developed Star schema model using Framework Manager with about 10 Dimension and 3 Facts, with DB2 as data source. Developed a Relational Model and Dimensional Model of Relational (DMR) data source.
• Widely used Report Studio to create various types of reports like List, Cross tab, Chart, Sectioning, Drill through, Drill up/down, Master detail etc with dynamic parameter passing across the reports.
• Created complex reports with Multi querying, Layout calculations, Query calculations, Data Items in Query Explorer etc.
• Generation of reports using Conditional Styles, Conditional Blocks, Render Variables and conditional variables.
• Created reports using different types of prompts like Text Box Prompt, Value Prompt, Date & Time prompt, Prompt Button etc with different conditions.
• Used various query components of Report Studio including Join, Union and Intersection.
• Created filters based on slicer member for Query analysis of the data.
• Scheduled the reports for publishing according to the requirements.
• Generation of various Pie Chart, Bar Chart, and Line Chart on Master/detail and cross tab reports.
• Created Events and Tasks using Event Studio.

Environment: Cognos8.4 BI series (Framework Manager, Report Studio, Query Studio, Event Studio), Cognos Power play Transformer 7.4, IBM DB2 9.7, Informatica 7.0, Erwin Modeling tool, Microsoft Office, Windows Server 2003/2005.

Confidential, Dallas, TX

Cognos Developer

Responsibilities:

• Interacted directly with the client for functional specifications of the reports.
• Importing the metadata, verifying the metadata, customizing the metadata using Framework Manager.
• Used Page Breaks, Simple/complex calculation, conditions, Sections, sorting, and various prompts for creating BI reports.
• Generation of various Pie Chart, Bar Chart, Micro Charts and Line Chart on Master/detail and cross tab reports.
• Generation of Reports with built in Table of Contents which has a drill through facility to every section of the report.
• Created Cognos Power Cubes by using Transformer and created Reports using Cognos Power Cubes.
• Unit Tested the Reports and verified the all the requirements.

Environment: Cognos8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Power Play Transformer 7.3, Report Net 1.1(Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Server 2000, MS Word, Oracle 10g, Agile development, Windows XP.