SUMMARY

• Focused and loyal system professional with 9+ years of experience in various technologies which primarily included COGNOS 8 BI suites, SQL Server, Oracle and all other phrase of the software development life cycle.
• Exceptionally well - qualified developer with sophisticated reporting skills and a sincere passion for resolving complex problems and business challenges through technical innovation.
• Dedicated, result-driven, and energetic leader, extensive knowledge in Cognos 8 BI suites.
• 8+ years of experience in developing various data warehouse, business intelligence applications with Cognos v10/8.x (8.2/8.3/8.4) BI suites (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Cognos Framework manager, Cognos Power play transformer, Power play Studio).
• Experience in working with various databases that include Oracle, SQL Server, and DB2 and MS Access.
• Extensively worked on IBM Cognos 10.x Framework Manger for creating Relational and Dimensional models and implementing best practices while resolving the loops and query items, namespaces, and packages.
• Analyze business needs and created various List, Crosstab, Drill through Reports and Multidimensional Reports with cascading prompts, Macros, filters, calculations using Cognos. And generated different kind of reports including templates, multilingual reports using Query Studio & Report studio in Cognos BI Suite and Report Net.
• Practical knowledge of Data warehouse concepts and principles - Star Schema, Snowflake, Surrogate keys, Normalization/De normalization.
• Extensive knowledge in installation and configuration of Cognos v10.x on windows environment.
• Strong troubleshooting and production Support skills and coordination/ interaction and users.
• Strong Project Management and General Business Management skills.
• Writing PL/SQL Stored procedures as per the reporting requirements.
• Strong Experience on Installation & Configuring the Cognos 10 BI Environment.
• Expertise in creating Dashboard reports for the senior management group in the organization.
• Ability to adapt and learn new technologies and get proficient in them very quickly.
• Team player with the ability to prioritize multiple tasks while meeting deadlines.
• Strong oral and written communication skills to maintain productive work relationships with management, clients, team members and other groups.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.
• Excellent Team coordinating Skills with the Development Team and Deliverable dates.
• Excellent team player at all levels with ability to perform independently. Exceptional communication, analytical, presentation and problem solving skills

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 10/8.4.1/8.3/8.2/8.1 Reporting Suite (Report Studio, Query Studio, Analysis Studio, Metric Studio and Framework Manager). MS Office (Word, Excel, Power Point, Outlook, Project), Adobe Acrobat and more.

Web Technologies: HTML, XML.

Databases: Oracle, MS SQL Server, MS Access

Languages: SQL,PL/SQL

Operating Systems: Windows XP, Windows Vista, Windows 7.

PROFESSIONAL EXPERIENCE

Confidential

Sr.Cognos Developer

Responsibilities:

• Building reports for the management.
• Analyze functional and business requirements
• Created simple, complex reports using report studio which helped them to review and analyze their customer information periodically.
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Design, develop, configure, deploy business intelligence reports and customizing the reports to meet specific user needs and requirements.
• Involved in installation and configuration of Cognos v10.
• Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
• Used standard filters, prompts, conditional blocks and various other conditions for creation of reports.
• Coordinating with Development Team tasks & Deliverables and working on high priority issues.
• Design & development of multiple reports using various templates like list reports, cross-tab reports.
• Created drill-through and dashboard reports for quick analysis of data.
• Troubleshoot last minute crucial issues in-time.
• Performance tuningby analyzing and comparing the turnaround times betweenSQL and Cognos.
• Provided technical support to co-workers whenever required.
• Supported in data modeling forEnterprise Data Warehouse.

Environment: Cognos 10 (Framework Manager, Query Studio, Report Studio, Analysis Studio), Cognos Transformer, Oracle, Apache Webserver.

Confidential, Warren, NJ

Sr.Cognos Developer

Responsibilities:

• Perform analysis, design, and document report requirements.
• Develop Business Objects Reporting and Dashboard Universes.
• Working with users and coordinating with application developers to understand and capture data/reporting requirements.
• Creating and documenting Business Objects report specifications with detailed database mapping.
• Support universe and reporting enhancements across multiple applications.
• Detailed analysis of user requirements.
• Extensive interaction with Business community and Team members.
• Developed various kinds of report templates, reports which include list, crosstab, charts, maps using various transformations like filters, prompts, conditional blocks and conditions using report studio.
• Extensively worked with Set Analysis.
• Collaborated with Business users and cross functional teams to develop Business Requirement Documents (BRD), define KPIs (Key Performance Indicators), and identify data sources.
• Work on requirement specifications for the strategic KPI\'s that drive performance and profitability in the division. Waterfall methodologies were followed during course of the project.
• Performed analysis, documentation for calculation for various attributes
• Successfully developed various kinds of tuned reports like standard reports ad-hoc reports using report studio and query studio.

Environment: Cognos 8 BI (Framework Manager, Query Studio, Report Studio, Analysis Studio), Qilkview,SQl Server.

Confidential, NYC

Cognos Developer

Responsibilities:

• Installation and configuration of Cognos v8.x in windows environment.
• Migrated catalogs and reports from Cognos 7.3 to Cognos 8.2 and CRN Reports to Cognos 8.2
• Creation of data sources connections using IBM Cognos Connection.
• Creation of Content Store in Content Manager using IBM Cognos Configuration.
• Developed Dimensional Model in Framework manager.
• Creating database objects like stored procedures, functions, triggers etc in SQLServer.
• Successfully developed various kinds of tuned reports like standard reports ad-hoc reports using report studio and query studio.
• Developed various kinds of report templates, reports which include list, crosstab, charts, maps using various transformations like filters, prompts, conditional blocks and conditions using report studio.
• Developed dashboard reports for business enablement.
• Creating DTS packages and importing/Exporting data from various data formats (e.g. databases, flat files, MS Access) to various data sources.
• Created and published documents on issues faced in project and solutions for the benefit of other team members.
• Provided technical support to other team members whenever required.

Environment: Cognos 8 BI, Framework Manager, Query Studio, Report Studio, Analysis Studio, SQl Server.

Confidential, Stamford, CT

Cognos Developer

Responsibilities:

• Created simple, complex reports using report studio review and analyze customer information periodically.
• Created ad-hoc reports using report studio and query studio and helped in analyzing statistical data periodically and come up with new business strategies.
• Involved in installation and configuration of Cognos v8 on windows environment.
• Used standard filters, prompts, conditional blocks and various other conditions for creation of reports.
• Created drill-through and dashboard reports for quick analysis of data.
• Developed various kinds of reports which include List, Crosstabs, Charts, and Maps etc.
• Developed stored procedures, functions, packages in oracle for data processing and enforcement of business logic.
• Successfully developed Dimensional model using framework manager.
• Provided technical support to co-workers whenever required.
• Published documents on implementation and usage of framework manager, cognos connection and publishing packages using framework manager.

Environment: Cognos Report Net 1.1, SQL Server, Oracle 9i, PL/SQL, Crystal Reports XI, OLAP, Windows XP

Confidential, Lake Land, FL

SQL/Cognos Developer

Responsibilities:

• Created Power Play cubes using Transformer (Power Play)
• Reporter Operations such as Sum and Average
• Exception Highlighting, Sorting, Ranking etc
• Changing filters, layers and measures
• Created Multi-Dimensional reports using Power Play
• Created Business Mix reports and Top ten reports
• Designed and developed multi dimensional cubes
• Customized data by adding calculations, summaries and functions
• Created List Reports, Cross Tab Reports and Drill Through reports
• Generated reports using Cognos Impromptu tools querying database
• Created Filters, Conditions and Prompts in Catalog
• Developed Impromptu Web Reports (IWR) and published them into Upfront

Environment: SQL, PL/SQL, DB2, Oracle 8.x, Cognos Impromptu 5.0, Impromptu Web reports (IWR), Power Play, Transformer, Toad, Windows 2000/ UNIX

Confidential, Pearson, NJ.

Cognos Consultant

Responsibilities:

• Created simple, complex reports using report studio review and analyze customer information periodically.
• Created ad-hoc reports using report studio and query studio and helped in analyzing statistical data periodically and come up with new business strategies.
• Involved in installation and configuration of Cognos v8 on windows environment.
• Used standard filters, prompts, conditional blocks and various other conditions for creation of reports.
• Created drill-through and dashboard reports for quick analysis of data.
• Developed various kinds of reports which include List, Crosstabs, Charts, and Maps etc.
• Developed stored procedures, functions, packages in oracle for data processing and enforcement of business logic.
• Successfully developed Dimensional model using framework manager.

Environment: Cognos Report Net 1.1, SQL Server, Oracle, PL/SQL, Crystal Reports XI, OLAP, Windows XP

Confidential

SQL Developer/Cognos

Responsibilities:

• Created simple, complex reports using report studio review and analyze customer information periodically.
• Created ad-hoc reports using report studio and query studio and helped in analyzing statistical data periodically and come up with new business strategies.
• Involved in installation and configuration of Cognos v8 on windows environment.
• Used standard filters, prompts, conditional blocks and various other conditions for creation of reports.
• Created drill-through and dashboard reports for quick analysis of data.
• Developed various kinds of reports which include List, Crosstabs, Charts, and Maps etc.
• Developed stored procedures, functions, packages in oracle for data processing and enforcement of business logic.
• Successfully developed Dimensional model using framework manager.
• Provided technical support to co-workers whenever required.
• Published documents on implementation and usage of framework manager, cognos connection and publishing packages using framework manager.

Environment: SQL, PL/SQL, DB2, Oracle 8.x, Cognos Impromptu 5.0, Impromptu Web reports (IWR), Power Play, Transformer, Toad, Windows 2000/ UNIX