SUMMARY

• Over 7 years of experience in Business intelligence reporting, development, analysis, design, testing and implementation of Cognos applications and maintenance of Data warehouses, Database, Data Marts and providing solutions for Oil, Healthcare, Telecom, Pharmaceutical and Public Sector domains.
• Experience in working with Agile and SDLC methodology
• Experienced on Project Management coordinating with peer’s in different cycles of the project and working with them to complete the project successful
• Experienced in creating POC’s and also coordinating with Vendors like Netezza, IBM,BSP in creating POC’s and presenting them to the Higher management for optimal solutions for BI
• Good knowledge of Data warehousing Concepts like Star Schema, Snowflake schema and good knowledge of using Erwin modeling tool
• Experienced in Designing, Developing, Testing, supporting and maintaining the ETL processes using Informatica Power Center.
• Good working knowledge with Cognos Modeling tools Framework Manager, Metric Designer
• Administered several projects and completed them successfully through 'Cognos Administration' tool
• Expertise in Authoring professional reports using Business Insight, Active Reports in Cognos 10, Report Studio with advanced techniques and using Query Studio for Ad - hoc queries, Analysis Studio, Metric Studio and Event Studio
• Designing, Installing, Configuring and Administrating all IBM Cognos BI suite tools on Windows and UNIX systems over distributed environment and standalone environment,
• Migratined reports from Cognos 8.4 to 10.1.
• Experienced with Requirements Gathering, Application Design and Development.
• Extensive functional and technical experience working with dimensional data modeling, ETL Tools, Business intelligence.
• Expertse in Creating standard filters, calculations, prompts and conditions. Managed security by creating User Classes.
• Experience in Administration tasks in Cognos Suite.
• Managed security via Access Manager and LDAP
• Installed, Configured and Managed Cognos Environments
• Involved in setting up managed Domain groups and namespaces.
• Worked closely in achieving performance tuning Created Jobs and scheduled some of the complex reports periodically during the off-peak times to effectively utilize the resources using Schedule Management in Cognos Connection.
• Well versed with Unix Shell Scripting.
• Excellent in understanding business objectives, requirements and taking projects through various stages of Software Development Life Cycle
• Provided technical and functional consulting/training to corporate and divisional users for Cognos.
• Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Experience supporting in-shore and off-shore teams for incident responses and service request submissions.
• Highly motivated, result oriented professional with a short learning curve and strong communication skills.

TECHNICAL SKILLS

• Cognos 10.x BI Suite
• Cognos 8x. Suite
• Framework Manager
• Cognos Connection
• Cognos Report Studio
• Cognos Query Studio
• Cognos Impromptu Series 7.3
• Access Manager
• Impromptu Web Reports (IWR)
• PowerPlay Transformer v7.3
• Informatica PowerCenter 9.5/9.1
• ERWin
• MS SQL Server 2000/2005/2008
• Oracle 8i 9i 10g
• IBM DB2 UDB
• SQL
• Microsoft Office
• Windows XP/2000/NT 4.0.

PROFESSIONAL EXPERIENCE

Confidential, Woburn, MA

Sr Cognos Consultant

Environment: IBM Cognos 8.4/10.2.1: Framework Manager, Query Studio, Report Studio, Cognos ConnectionDB: Oracle 11g, Version Control: MS VSS, BSP MetaManager

Responsibilities:

• Involved in the entire project life cycle from requirement gathering, analysis, development, testing, production migration and end user support.
• Interacted with Business users to gather requirements, created Functional and Technical specs. This involved creating reports by understanding the current business model and working with consultants to maximize the value of reporting.
• Based on the specs, Designed, developed and delivered Cognos Framework models, packages and set of reports for Managed Sites business group adding value to Operational and Executive Users forming a strong base to deliver information as needed by business to take key decisions.
• Helped with training key users in the Cognos enabling them to create adhoc reports in Query studio.
• Developed models specifically for business users with easy to understand data structures, so that they can create reports in Query Studio.
• Hands on experience in providing Production Support. Expertise in resolving issues in reports, jobs; sticking to agreed timelines.
• Developed complex report layouts/KPI/multi-page List, Chart, Crosstab reports using features like cascading, Master - Detail, Conditional blocks, Drill Throughs, Filters in Report Studio to meet business requirements.
• Fine-tuned existing reports and created new reports using best practices for optimal performance.
• Experience in Upgrading reports from Cognos 8.4 to Cognos 10.2.1.
• Developed new reports using functionalities like Layout Component Reference to reuse prompts, Report Header and Footer and sections for List Reports.
• Learnt BSP MetaManager tool on job to document, update, change properties, taking backup etc features on Cognos Content (Reports, Models etc)
• Handled conditional formatting, conditional blocks, Cascading Prompts, Prompts, Filters, Functions, Conditional Variables etc.
• Created user defined classes in report studio to override the existing classes for formatting of the report.
• Used MS VSS to maintain versions of view code modifications and documentation.
• Used set operations like union and joins at query level in report Studio to display data as required by business.
• Created and scheduled jobs and reports in Cognos Connection according to delivery schedules set by the users.
• Developed various dashboard reports using charts and graphs for executive users on the volume of applications and unleased space on towers for each region.
• Designed test cases and test plans for QA testing. Involved in Functional/Unit Testing, providing support to users in User Acceptance Testing phase.

Confidential, Pittsburgh, PA

Sr.Cognos Developer

Environment: Cognos 10.2.2, Report Studio, Workspace, Workspace Advanced, SQL Server Management Studio

Responsibilities:

• Analyze and document data requirements from business
• Prepare sample functional specs, mock up reports or similar functional requirement specifications based on information gathered
• Performed deep down analysis of the data for auditing and data quality
• Implement Data Quality Monitoring system using Portals to display monthly reports on Quality of data
• Responsible for code review, document review, packaging and mentoring fellow team members for development of application
• Created functional and technical specifications, which acts as a source for report development, and for QA testing from the business requirement documents.
• Created an easy to use reporting layer for end user
• Developed Reports and Dashboards as requested by the Users
• Supported the users in their development and usage of Cognos Reporting tools
• Developed Complex Reports (List, Crosstab, Drill through, Master-Detail, Charts, Maps, multi-query multi-prompt reports, burst reports) and Dashboards and Active Reports using Report studio
• Used JIRA to track report requests submitted by Users
• Developed Conditional Formatting, Conditional Blocks Using String, Boolean and Language variables
• Designed and developed reports of significant size and complexity from user requirements that vary and lack clear definition, using Report Studio and/or SQL statements and adhoc custom sql reports
• Developed several custom sql reports in Cognos report studio using advanced sql such as pivoting, aggregating at different levels of granularities

Confidential, Wilmington, DE

Sr.Cognos Developer

Environment: Cognos10.2, Report Studio, Query Studio, Analysis Studio, Workspace, Workspace Advanced, Teradata SQL Assistant

Responsibilities:

• Involved in the transition of reports from Business Objects to Cognos
• Experience in creating POC’S for Active Reports and Workspace Advanced
• Experience in creating DMR Packages and accessing the package in Analysis Studio to perform drill-down and drill-up operations
• Developed Framework Manager models and based on the user needs maintained them.
• Implemented best practices on framework / Reports / Dashboard
• Standardized reports to maintain uniformity across the organization.
• Involved in performance tuning of reports using Teradata SQL Assistant
• Created Query Subjects using SQL
• Created Customized Audit reports to monitor performance and used to debug the Cognos issues
• Monitored the ETL Jobs as needed
• Tested the Data after ETL Load
• Worked with the ETL team to resolve the report performance issue
• Extensively resolved issues in Cognos Report Studio / Analysis Studio / Query Studio and Cognos Connection.
• Worked with IBM support to resolve issues
• Designed and implemented the folder structure for cognos in DEV/UAT/PROD
• Demonstrated Cognos reports to show the functionality and different flavors of the tool
• Ability to maintain and control systems, user access and other privileges
• Ensured proper scheduling and administration of Cognos connection

Confidential, Chicago, IL

Sr. Cognos Consultant

Environment: Cognos10.2, Cognos 8.4, Workspace, Workspace Advanced Framework Manager, Report Studio, Business Insight, Query Studio, Analysis Studio, Metric Studio, SQL Server 2008 R2 Oracle11g

Responsibilities:

• Worked 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.
• Implemented Framework manager security for Data access, Object level access and Package access.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Validated report content between versions of cognos software using Lifecycle Manager (LCM)
• Conceptualized and formalized several List, Chart, Cross tab, master-detail, Drill-Down and Bursting reports using Report Studio, and made available to the users
• Deployment of Reports, Packages, Users and sometimes the complete Content Store from one environment to the other.
• Created Multi Page report based on Multiple Master queries to show the data on different pages when the Master record changes in a Report using Report Studio
• Created custom templates and custom toolboxes for the use of reporting
• Worked on the Active Reports to provide the interactive behavior outputs to the users. Created tabbed reporting with complex calculations/formatting
• Extensively used Workspace, Workspace Advanced.
• Prepared detailed user manual(s), for different package(s), explaining the business rule behind all the fields in the package and illustrate the functionalities available in Query Studio, Workspace to help users create ad-hoc reports.
• Used SQL Profiler monitor Performance of Queries and to index the Tables
• Prepared the Presentations/User Guides to the End Users as part of the training

Confidential, NY

Sr. Cognos Developer /Admin

Environment: Cognos 10.1.1, Cognos 8.4.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Cognos Transformer 8.3/8.4,Cognos TM1(9.5), TurboIntegrator, Oracle10g (SQL, PL/SQL), Oracle SQL Developer, Microsoft Visio, Linux and Windows 2003 server.

Responsibilities:

• Involved in installation, configuration and maintenance of Cognos Administration tool
• Gathered and analyzed user requirements and Participated in discussions with senior management to create the business requirement.
• Understanding the multidimensionality of the data for designing Cubes in TM1 and for Reporting needs
• Worked with the for creating the cubes and modifying the dimensions in the current structures and the old cubes using Business rules using TI process
• Worked with the team on enhancing the existing cubes by suggesting the changes to the structures and modifying the processes
• Extensively worked with Framework Manager Models from ODBC data sources and Published into server.
• Experience in creating Active reports using Cognos 10 Report Studio.
• Experience in creating dashboard reports using Cognos 10 Advanced Business InSight.
• Experience in Migrating reports from Cognos 8.4 to 10.1
• Created database layer and presentation layer and created packages using FM model and published in Cognos Connection
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Developed Drill through reports and conditional formatting by using report studio.
• Developed AD-Hoc Reports using Query Studio based on User requirement
• Tested and validated data in the reports using SQL queries.
• Designed and build multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Developed Dashboard reports in Report Studio.
• Trained power users to use Query Studio for Ad-Hoc reporting.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Extensively worked with Stored Procedure Query Subjects in FM and Reports.
• Tuned performance by analyzing and comparing the turnaround times between SQL and Cognos. Involved with Installation and configuration of COGNOS servers, implementing security, managing users, user groups and roles in the organization and provided BI Orientation.
• Customized Cognos Connection with appropriate reports and security measures.
• Created, refreshed and supported Cognos Transformer OLAP models and Power Play cubes.
• Experience in handling tickets using BMC remedy ticketing system.
• Coordinated with Development Team tasks& Deliverables and working on high priority issues.

Confidential, Augusta, ME

Cognos Developer

Environment: ReportNet 1.1 MR2, Cognos 8.x, Cognos Connection, Report Studio, Query Studio, FrameWork Manager, Access Manager, LDAP Server, Cognos Scheduler, Cognos Configuration, IBM DB2 UDB, SQL, HTML, Windows NT/2000, Unix.

Responsibilities:

• Designed, developed and implemented an Enterprise-wide Reporting system using Cognos ReportNet.
• Involved in gathering Business Requirements for New Models.
• Imported metadata from various sources such as Relational Databases and ReportNet models into the Framework Manager.
• Exported metadata from Framework Manager as Common Warehouse Models.
• Used Framework Manager to build models, packages and publish packages to the ReportNet Server. configured and managed multiple environments for application and report development, testing and training purposes.
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Planned and Created professional reports in Report Studio and Ad-hoc reports in Query Studio.
• Used Report Studio to build multi-page, multi-query reports against multiple databases.
• Created Calculations, Conditions and Filters.
• Integrated various Customized Prompt, Conditional Variables in the report and designed multi-List reports operated by choice prompts adding flexibility to the report.
• Implemented security by creating Namespaces and User Classes using Access Manager.
• Performed proof-of-concept projects in ReportNet (Framework Manager, Report Studio, Query Studio and Cognos Connection).
• Scheduled reports to run on a monthly, weekly, and daily basis using ReportNet.
• Trained users in Query Studio and provided sample.
• Demonstrated reports for understanding the Report layouts and functionality.