PROFESSIONAL SUMMARY :

• 7 years of experience in development and implementation of Data Warehousing applications using Cognos Business Intelligence.
• Expertise in Data Analysis, Data Modeling and Mappings, Data Warehousing and Business Intelligence applications with participation in entire life cycle of the projects.
• Proficient in developing reporting applications using Cognos 10.1/8.x tools Framework Manager, Report Studio, Query Studio, Powerplay Studio, Analysis Studio, Metric Studio, Event Studio and Cognos Connection .
• Experience Requirements gathering, Analysis, Functional and Technical Specification and Test case documentation.
• Expertise in Reports generation including creating complex reports using Report studio Master-detail reports, List reports, Cross-tab reports, Drill through reports, Summary reports, Burst reports, etc. .
• Involved in the entire BI lifecycle project development, including design, coding, testing and implementation and ongoing product support.
• Knowledge of Data warehouse concepts, DMR Dimensionally Modeled Relational , Star Schema and Snow Flake Schema.
• Involved in creating Security, building models and publishing packages in Framework Manager.
• Experience in Unit Testing, System Testing, Functional Testing, User Acceptance Testing and Testing Documentation.
• Involved in upgrading and migrating Cognos 8.4 to Cognos10.1
• Experience in working with Oracle and SQL Server Databases.
• Worked with onsite and offshore development model.
• Team player with excellent technical, operational, problem solving skills and quick learner.
• Excellent interpersonal and analytical skills with ability to communicate effectively, with attention to detail.

TECHNICAL SKILLS :

• Business Intelligence: Cognos10.1/8.x BI Suite Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Tranformer, Cognos Connection , ReportNet 1.0/1.1 Framework Manager, Report Studio, Query Studio, Cognos Connection , Crystal Reports.
• Databases: Oracle 10g/9i/8i, SQL Server 2005/2008, MS Access
• Web servers : Microsoft Internet Information Services IIS
• Programming skills : SQL, PL/SQL, VB, HTML, C, C
• Modeling tools : Erwin
• Microsoft Suite : MS Project, MS Excel, MS Word, MS Visio, MS PowerPoint
• Operating systems : Windows 7/XP/NT/2003/2000
• Others : TOAD, Adobe Acrobat Suite, Macromedia Flash, Photoshop, AutoCAD, ProE, ANSYS

PROFESSIONAL EXPERIENCE :

Confidential

Sr. Cognos Developer

This project is within the HR technology organization data warehouse and reporting team. Client currently uses PeopleSoft as its ERP globally and the data from each of the regional instances of PeopleSoft is transformed and stored in a HR data warehouse. Primary scope of the project is to provide sophisticated HR Analytics and reporting solutions to the HR organization using Cognos BI tool.

Responsibilities:

• Interacted with Business and Functional teams to capture Business Requirements and created technical specification document.
• Worked with technical lead to create Framework Manager Model and/or Packages as per requirements.
• Developed new reports using Report Studio which includes Cross tab, master-detail reports, drill-through, prompts, bursting reports, charts.
• Developed various reports with Calculations, Conditions Filters, Joins, Unions, Query prompts, Cascading prompts, Prompt Pages, Variables using Cognos Report studio.
• Created complex and interactive Dashboards and Active reports.
• Involved in performance enhancement of existing reports.
• Customized user interface and modified reports using SDK to as per requirements.
• Created user-friendly Ad-hoc reports using Query Studio.
• Worked with Global HR Applications Support team to provide security to users.
• Worked with Operations Team to deploy Reports Packages from Development to Testing Environment and from Testing to Production Environment.
• Created Implementation Plan IP for each release to move Cognos objects from QA to Production.
• Involved in upgradation and migration from Cognos 8.4 to Cognos 10.1.
• Involved in weekly data refresh validation.
• Created Detailed Design document and Impact Analysis document.
• Used Cognos Connection to organize reports folder structure, scheduling and distributing reports.
• Test reports using review checklists for Quality Assurance before delivering to functional team.
• Worked with Testing Center of Excellence Team TCoE to understand/identify defects and fix them.
• Conduct recurring meeting with technical, functional and testing teams to review the status and prioritize user requests.
• Troubleshoot production issues.
• Participate in functional and User Acceptance testing.

Environment: Cognos 10.1/8.4 Framework Manager, Cognos Connection, Report Studio, Query Studio , Oracle 10i, PeopleSoft 8.3/9.1, MS Office 2007, Windows 7.

Confidential

Cognos Consultant

Responsibilities:

• Involved in Requirement gathering and Assisted Developer in building Framework model and creating packages.
• Created technical specification document as per the requirements
• Converted Business Intelligence and Reporting Tools BIRT reports to Cognos reports using Report Studio which included Cross tab, master-detail reports, drill-through, prompts and charts
• Used Cognos Connection for organizing, scheduling and distributing reports.
• Involved in Functional and User Acceptance Testing along with process documentation.

Environment: Cognos 10.1/8.4 Framework Manager, Cognos Connection, Report Studio, Query Studio , Eclipse BIRT, TOAD, Oracle 9i, Windows XP.

Confidential

Cognos Consultant/ Data Analyst

Part of Data Warehousing and Business Intelligence Business Technology team DW/BI , US Operations. Worked on multiple projects initiated by business and/or business technology team due to organizational structure changes, requirement changes that added value to business. Main business objective is to deliver Operational and Data solutions using Cognos for requests from various functional units in Pfizer Animal Health like Finance, Sales Operations, Customer Service and Distribution.

Responsibilities:

• Involved in all phases of development life cycle including requirements gathering, analysis, design, development, implementation, debugging, documentation, and testing.
• Created Framework manager model and packages practicing best modeling techniques keeping long term aspects like knowledge transfer, maintainability etc. in perspective.
• Developed new reports using Report Studio which includes Cross tab, master-detail reports, drill-through, prompts, bursting reports, charts.
• Developed reports using filters, calculations, prompts, conditions using Cognos Report Studio.
• Created reports with custom prompt pages using HTML and JavaScript in Report Studio.
• Delivered high quality and value added reports to the business by understanding business requirements.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Created Complex reports with advanced formatting using Report Studio and Ad hoc web based reports using Query Studio.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection.
• Tested reports using review checklists for Quality Assurance before delivering to users.
• Designed the System testing and implementation planning activities.
• Documented business requirements, work instructions, how-to user manuals, power user manuals and best practices at various levels.
• Provided training to business users on Cognos Query Studio, Report Studio and navigation through the Cognos Portal.
• Prepared documentation on how to run the reports in different formats, how to schedule the reports etc.
• Gained sign-off from business on requirements as needed.
• Worked with Business Units to define Business strategy for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Ensured development work is maintainable, supportable and met standards consistently.
• Streamlined mechanism for both standard and ad-hoc report requests.
• Created Incident/Service request tickets in HP Service Center.
• Constantly worked with business users, onsite and/or offshore technical team to ensure deliverable quality and deadlines SLAs are met.
• Deployed packages, folders and content store from a development environment to test and then to production environments.
• Closely worked with ETL team to design data marts by understanding user requirements.
• Created KPI reports and assisted business users analyze data.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Used Tabular SQL to develop complex reports in Report Studio.
• Extensively developed complex Ad-Hoc reports by writing SQL queries to pull data from multiple data sources.
• Automated standard reports where applicable.
• Involved in fixing bugs and data errors.
• Extensively involved in testing Ad-Hoc, recurring reports, and Cognos deliverables.
• Carried out distribution of reports and transitioned development and enhancements to business and business operational users.
• Assisted business users both in technology and applications and help understand data, reports and dashboards.

Environment: Cognos8 BI Suite Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos Connection , Cognos EP Series 7.3 PowerPlay, Transformer, Impromptu, PPES, Upfront, MS Office 2003 Suite, SQL Server 2000, Oracle, Windows XP.

Confidential

Cognos Consultant

Responsibilities:

• Involved in complete software project development life cycle including requirements gathering, analysis, design, implementation, debugging, documentation, and testing.
• Gathered and Analyzed User requirements, finance data and designed hierarchy to meet the requirements
• Installed and configured ReportNet, and Framework Manager
• Created packages/metadata models by combining data from different data sources using Framework Manager
• Created ad-hoc reports using Query studio
• Created Master-detail, drill-through, Cross tab, Charts, Nested Cross tab and complex repots in Report Studio
• Documented requirements document, functional and UAT test scripts.
• Scheduled and carried out distribution and bursting of reports in Report studio.
• Liaison between business and technical team.
• Worked closely with Cognos Administrator for all security requests.
• Validated BI reports functionality as per the requirements and data in the reports by writing SQL and running reports in Query Studio.
• Involved in validating final report data against the source and improving performance of reports
• Worked with development team to fix the defects and regression tested the reports.
• Customized end-users Cognos Connection with appropriate reports and security measures
• Conducted User Acceptance Testing sessions.
• Involved in intensive end user training and production support activities.

Environment: Cognos ReportNet 1.1 Framework Manager, Cognos Connection, Report Studio, Query Studio , MS Access, TOAD, SQL Server 2000, Windows XP.