SUMMARY

• 8+ Years of experience in Business intelligence reporting, development, analysis, design, testing, implementation maintenance of Cognos Web applications, Database, Data warehouses, Data Marts and providing solutions for Finance, Banking, Insurance, Pharmaceuticals and Retail.
• Experience in COGNOS 8 (8.4/8.3/8.2/8.1 ) Suite (Framework Manger, COGNOS Connection, Report Studio, Query Studio and Analysis Studio) with expertise in Metadata Modeling - Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, Set security and publish into portal.
• Extensively worked on Framework Manger in creating models and implementing ‘best practices’ while modifying relationships, resolving the loops and Dimensionally Modeled Relational data (DMR/ROLAP).
• Complex Report Building Experience by using Tabular Objects, Tabular SQL, Filters Customized Prompts, Conditional Formatting and Complex Layouts like Cross tabs, sub reporting and Bursting.
• Proficient in Score carding, Dash boarding and Implemented Security among various COGNOS applications
• Designed and developed OLAP applications, Transformer Models and Multidimensional Power Cubes
• Expertise with COGNOS PLANNING and ANALYSIS. Involved in QA process of the reports developed.
• Experience with Complete Lifecycle implementations of ETL Processes. Demonstrating knowledge in (OLAP) Data Warehouse, Data Mart Concepts and Methodologies.
• Expertise in OLTP/OLAP system study, analysis, E-R modeling and developing Database schemas like Star Schema and Snowflake Schema.
• Involved in the full Project Life Cycle of the Data Warehouse project.
• Experienced in working with databases like Oracle, MS SQL Server 2005/2008.
• Experience in taking end-user business requirements and translate them into design specifications through COGNOS and extensively involved in user training and deliver the required reports in project time lines.
• Extensively worked with SQL Queries, Stored Procedures and have good experience in Database Tuning, Database performance techniques.
• Strong understanding of data warehousing concepts, principles and techniques. E.g. indexing strategies, schema design, data structures (facts, dimensions, star schemas etc.)
• Experience in Upgrades reports from 8.1 to 8.2, 8.2 to 8.4.
• Excellent Team Coordinating Skills with the Development Teams and Deliverable dates.
• Exceptional analytical, problem solving and communication skills.

TECHNICAL SKILLS

Cognos Suite: Cognos 8.4/8.2 (Cognos Connection, Framework manager, Report Studio, Query Studio, Analysis Studio), CognosSuite7.x/6.x

Data Modeling Tool: Erwin

Database: MS SQL Server 2000/2008, MS Access

Languages: C++, SQL, Java

Operating Systems: Windows XP/2000, Windows 7 and MS-DOS

Other Tools: Fidelity

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

Senior Cognos BI Developer

Responsibilities:

• Gathered requirements from functional teams and senior business analysts and translated them into technical design specifications.
• Communicate with the business users for reviewing the developed reports and taking feedback for any updates/improvements.
• Created models for ad-hoc querying for the users in Query Studio.
• Developed complex reports using drill through, bursting and conditional formatting in report studio.
• Created Event Studio agents to conditionally schedule the reports and change the Email subjects dynamically.
• Worked in a multi environment and promoted/deployed the reports/packages between dev, QA and production environments.
• Gave production support for the existing reports for any changes or trouble shooting.
• Documented the work using standard templates.
• Designed models in Framework Manager (Physical Layer, Logical Layer, Business Layer) from multiple data sources.
• Created segments links to work multiple developers on the same project.
• Created macros in query subjects to parse comma separated values and to display default prompts.
• Implemented data level security.
• Create different Packages for different business areas.
• Created User Roles and User Groups.
• Customized Cognos portal to display news boxes to inform of any outages or delays in data loads.
• Scheduled reports in Schedule management to run on a monthly, weekly, and daily basis
• Deployment of reports and users set up to other environments.
• Setting capabilities to various user roles.
• Design and creation of Standard and Complex Reports using List, Cross Tabs, Drill Through, Charts, HTML objects and images.
• Developed Conditional Reports and did data-driven formatting and layout.
• Developed summary and detail reports and customized page orientation and pagination for PDF reports. Created multi query and multi-page reports.
• Developed complex reports using joins and set operations in report studio.
• Created dashboard Style reports to emphasize on business metrics.
• Created burst reports on a single and master details queries to distribute the sensitive data accordingly to multiple users.
• Creation of Adhoc Reports using Query Studio.
• User training for creating ‘Adhoc’ Reports using Query studio
• Creating and Maintaining Query Studio Packages
• Help to create views to avoid complex joins between tables and wrote stored procedures for report purpose.
• Analyze the report queries using explain plan and Optimizing the SQL queries to use indexes.
• Testing reports with SQL queries.

Environment: Cognos 8.4, Framework Manager, Report Studio, Query Studio, MS SQL Server 2008, Windows 2003, Excel, MS Visio.

Confidential, Irving, TX

Senior BI Developer

Responsibilities:

• Create user groups and user roles, assigning capabilities, deploying reports and scheduling reports in Cognos Administration.
• Interact with functional team leads and senior business analysts for requirements gathering, status updates, communicating issues, delays.
• Migrated Cognos 7.x reports from legacy SQL Server data warehouse to Cognos 8.4, Oracle data warehouse and maintained the old reports.
• Work with modeling team, functional team and technical team to decide the mapping between database objects and report attributes.
• Created new FM models for different business areas and presented models to the users for ad hoc querying. Maintained naming standards across the business areas and built master model to contain common dimensions for the ease of use for the developers.
• Developed several complex reports such as Drill through reports, conditionally formatted reports, and reports using set operators.
• Understanding the existing operational data source and relationship between the objects.
• Give demos to the management and functional teams about the functionality of reports and its security.
• Helping QA team in testing of the reports and models.
• Understanding the existing Multi-Dimensional Cubes and analyzing Business Requirements and Source database to develop Multi-Dimensional Cubes.
• Modeling the cubes using multiple data sources to improve the performance.
• Added manual levels and customized relative time categories to dimensions according to the business requirement.
• Created time based partition cubes for better performance and customized cube content with views for member based security.
• Set up drill through from cubes to reports.
• Scheduled cube building daily/weekly/monthly using command line options in batch files.
• Gave training to the users on how to use the cubes in Analysis Studio.

Environment: Cognos 8.4, Framework Manager, Report Studio, Query Studio, MS Access, Windows 2003, SQL Server 2000, PL/SQL Developer, Query Analyzer, Excel.