PROFESSIONAL SUMMARY:

• 7+ years of IT experience with Cognos BI suite of tools and experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and production.
• Strong understanding of relational database design concepts and in - depth knowledge of OLAP/OLTP, 6+ years’ experience on, Cognos 8, Cognos10 (Framework Manager, Report Studio, Query Studio, Martics Studio, Analysis Studio), Cognos Impromptu, and PowerPlay Transformer.
• Experience in a fast paced, right time business intelligence environment designing, developing and supporting quality, time sensitive and accurate multi-dimensional information.
• Proficient in gathering requirements and interaction with client and clear understanding of business requirements and applications.
• Experienced in all aspects of Reporting application development like installing and configuring; developing and maintaining catalogs and Power cubes, creating reports, testing and deployment.
• Proficient in understanding, and writing SQL.
• Proficient in Cognos10.1 migration from cognos8.4
• Good understanding of Data Warehouse, with a good understanding of schemas, fact tables, and dimension tables.
• Experience in Financial/Banking/Mortgage, Healthcare, Insurance, Pharmaceutical and retail industries.
• Expertise on creating various types of Standard reports as per user requirements using Analysis Studio and Report Studio, and helping Query Studio users to develop their ad-hoc reports.
• Identification and implementation of solutions to enhance the existing BI infrastructure processes and technology.
• Worked on Cognos Security Administration to restrict user access.
• Managed applications on various platforms like Windows and UNIX.
• High degree of proficiency in writing and implementing Functions, Stored Procedures, Packages and Triggers with strong fundamentals in RDBMS concepts.
• Possess excellent analytical, logical, interpersonal, communication and organizational skills combined with the ability to work in a fast paced environment as an individual and as a team member.

TECHNICAL SKILLS:

BI Tools: Cognos 8.2/8.3/8.4/10.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio),Cognos workspace, Cognos workspace advanced, Cognos Impromptu 7.3/7.4, PowerPlay Transformer

ETL Tools: Cognos Data Manager/Decision Stream, and Informatica

Operating Systems: Windows, and UNIX.

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

Databases: Oracle, MS Access, MS SQL Server, Teradata, Excel and DB2.

Other: Toad, SQL Navigator, Clear Quest, CVS, and IIS

PROFESSIONAL EXPERIENCE:

Confidential, Denver, Colorado

Cognos Reporter Consultant, Business Intelligence Team

Responsibilities:

• Requirement Gathering, Definition and Approval of functional and technical Specifications.
• Responsible for the design, testing of Salesforce CRM applications and Cognos reporting.
• Review and approve the modification to Cognos implementations from a technology viewpoint.
• Worked with Cognos tools: Framework Manager, Report Studio, Event studio, PowerPlay Transformer (building cubes), Analysis Studio, Query Studio and Cognos workspace.
• Developed List, summary, cross tab, drill through, master-detail, chartand complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reportsagainst multiple databases.
• Achieved Drill Upand Drill Downin Report studio reports using DM Rmodeling.
• Responsible for creating various reports using Report Studio and also for tuning the existing Report Studio reports thru writing SQL queries.
• Worked on multi query reports, drill-thru, prompted, bursting, and union query in the report studio.
• Worked on various complex reports in Cognos10.2 based on user requirements and converted them to Active Reports.
• Responsible for testing CRM and Sales Cognos reports for Operations.
• Design and development of Dashboards, KPI’s and score cards.
• Involved in User Acceptance test (UAT) and coordinated with the Functional testing teamand Load performance testingteam. Attended User Acceptance sessions, and worked on the feedback from the business users.
• Maintained close interaction with the business groups and technical teams.

Environment: Cognos10.2 (Cognos Connection, Framework Manager, Report Studio, Event Studio, Query Studio, Analysis Studio, Business Insight, Business Insight Advance) andCognos8.x (Framework Manager, Report Studio, Query Studio, Analysis Studio),Cognos workspace, SQL Server 2008/2012, Toad, Windows, MS Office.

Confidential, DE

Sr. Cognos Developer/FM Modeler

Responsibilities:

• Requirement Gathering, Definition and Approval of functional and technical Specifications.
• Worked on Cognos Framework Manager Models, package design and publish Packages in the Cognos Connection Portal to develop reports using Report Studio, Analysis Studio, and Query Studio).
• Worked on PowerPlay transformer to create model with multiple data sources, and built PowerPlay cubes as per the user requirement.
• Worked on various complex reports in Cognos8.4, and Cognos10.1.
• Responsible for creating various reports using Report Studio and also for tuning the existing Report Studio reports thru writing SQL queries.
• Created drill through reports, master detail and burst reports in Report Studio.
• Worked on multi query reports, drill-thru, prompted, bursting, and union query in the report studio.
• Worked on Cognos Security Administration to restrict user access.
• Successfully migrated reports, security from Cognos 8.4 to Cognos10.1 on Windows environment.
• Responsible for team co-ordination, user, and support. Additionally has close interaction with the business clients and technical team.

Environment: Cognos8.4/10.1 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos Workspace), Cognos workspace, SQL Server 2008/2012, Oracle10/11g, Toad, Erwin, Java script, IIS, PowerPlay Transformer8.4/10.1, Windows, and MS Office.

Confidential, Phoenix, AZ

Sr. Cognos Consultant

Responsibilities:

• Worked with Business Units to define and refine Reporting strategy and perform analytical/ad-hoc reporting for business applications to provide accurate information to Decision Makers.
• Created complex Framework Manager models based on multiple data sources /different databases, Dimensional framework to assemble a model based on multiple star-schemas for generating highly complex cross-tab reports.
• Built relationships between query subjects, which represent the logical structure of the business and the user requirements.
• Built complex/summary query subjects, reusable filters and calculations based on relational and Multi-dimensional data sources Used Cognos Connection for organizing the content, enabling security, scheduling and distribution of reports.
• Developed Complex Reports in Report Studio, ad hoc reports in Query Studio as per the requirements.
• Migrated reports from Cognos Report Net 1.1MR3 to Cognos 8.3
• Designed and created Dashboard style complex reports to depict information on Key Performance Indicators (KPI) metrics.
• Designed and developed several Multi dimensional Power Cubes using PowerPlay Transformer from multiple sources such as IQDs, and CSV files.
• Used PCOPTIMIZER (power cube optimizer) to optimize cubes created in series 7 for usage in Cognos 8.
• Created simple list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations and conditions.
• Created complex dashboard reports using metric studio.
• Created reports with conditional formatting to enhance the readability of the report outputs and enabled Prompts and Cascading Prompt pages to give users the ability to derive focused reports.
• Tuned Performance of reports by reconfiguring join strategy in SQL Queries/ Framework Metadata Models and requested the DBA to create summary tables/views at the database level or enable the indexes on the columns used in the joins when appropriate
• Validated the report results with the source data and deployed the reports to production environment.
• Peer review design and code of other developers, prepared defects list and modified design documents and code as per the defects list.
• Provided technical assistance, and mentoring to Users and Business Partners.

Environment: Cognos 8.2/8.3 BI Suite (Framework manager,Cognos Connection, Report Studio, Query Studio, Cognos Workspace), Impromptu, PowerPlay, Transformer, DB2, SQL Server, Oracle 10g.

Confidential, New York

Cognos Developer

Responsibilities:

• Created Meta data model for reporting using Framework Manager.
• Crated Data source query subjects, Model query subjects and stored procedure query subjects based on the business logic.
• Created Packages and published packages to Report Net/Cognos8 server.
• Created public folders, Private Folders, My pages and custom views in Cognos connection.
• Created various reports List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill-Through Reports using Report Studio.
• Improved the query performance using Governor tab.
• Created Model Filters, Query Filters, User access filters Detail filters, Summary Filters, Prompts, Parameters and Calculations.
• Created Ranks and conditional formatting in reports and enabled multi lingual feature.
• Published PowerPlay cubes to ReportNet.
• Integrated the existing security with Report Net Security.
• Responsible for Setting up Groups/Roles to secure the Models and packages.

Environment: Cognos ReportNet1.0/Cognos8.2, Cognos Impromptu 7.3, PowerPlay Enterprise Server 7.3 I- Planet, LDAP, Transformer 7.3, Oracle 9i, Ervin 5.1 SQL, PL/SQL, SAP R/3, SAP