PROFESSIONAL SUMMARY

• Having 7+ years of professional experience in IT Industry with Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence Applications.
• Hands on Experience in Data Warehousing & BI environment on Cognos 10.1, 8.4, 8.x and ETL Tools like Informatica 8.0 and SSAS, SSRS, SSIS.
• Extensively worked on IBM Cognos 8 Framework Manger, creating model and implementing best practices while resolving the loops and query items, namespaces, DMR (Dimensional modeling with relational data) and packages.
• Sound skills in Developing Dashboard Reports & scorecards using Report Studio and Metric Studio.
• Strong Complex Reporting skills - complex Drill-Through, Scorecard, Dashboards, Discontinuous Cross-Tabs, Summary Reports, Burst Reports, ad-hoc reporting and advanced report authoring.
• Developed Active Reports, Bullet, Micro charts using Cognos 10.1.1.
• Developed Dashboards using Business Insight and Business Insight advance.
• Migrated Reports and packages from Cognos 8.4 to Cognos 10.1.1.
• Experience in developing new reports and customizing existing reports and change request processing.
• Strong Experience in Developing Transformer Models, cubes, views.
• Design, develop and maintain Cognos Reporting solutions and Power Play (OLAP cube reporting) both for client and web versions of software.
• Customized the Cognos Connection Portal/reports based on user requirements.
• Deploying models and reports from Staging to Production and administering users/groups/roles.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• Experienced with migration of Cognos code (reports/models/ frameworks) from one environment to another.
• Strong experience in implementing Data warehousing solutions involving Dimension modeling and Star flake schema implementation (3 NF).
• Strong understanding of relational database design concepts and in depth knowledge of OLAP and OLTP solutions. Involved in Data Modeling with Star Schema & Snow Flake Schema
• Strong experience with Client interaction, understanding business applications, business data flow and data relations.
• Worked with Different Databases like Oracle8i/9i/10g, SQL Server 2000, DB2, MS Access.
• Excellent experience in problem solving and supporting applications comes under 24/7.
• The ability to work independently and as part of a team with the ability to manage time and resources to meet assigned deadlines.

Technical Skills:

Cognos 10.1, 8.4 BI Framework Managers, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio.

ReportNet1.1 (MR1/2)

Cognos Connection, Framework Manager, Query studio, Report Studio, Cognos Configuration.

Data Modeling

ERwin 7.x/4.x, MS Visio, power design

Programming

SQL, PL/SQL, HTML/CSS, C/C++, XML

Operating Systems

Windows NT/2000/XP, Unix (Solaris, IBM AIX), Red Hat Linux 9.0

Databases

Oracle11g/10g/9i/8i/8.0, SQLServer2000/2005, Teradata, SSIS, MS access, IBM DB2, Toad, MS Office 2003

Client: Confidential, Toronto ON May 11 - Present
Role: Sr. Cognos Developer
Responsibilities:

• Involved in the Installation ofCognos 10.1.1/8.4and up gradation of Packages from Frame Work Manager, Reports from Report Studio fromCognos 10.1.1 to Cognos 8.4.1.
• Migrated reports from Cognos 8.4 to Cognos 10.1.1.
• Developed Active Reports using Cognos 10.1.1.
• Developed Dashboards using Business insight advance.
• Schedule various reports Using Schedule Management used inCognos Connection.
• Created variousIQD packagesin Framework Manager and integrated them to PowerPlay transformer to create various models and cubes.
• Created roles in Cognos connection and Access permissions were given to users.
• Coordinating with business users to understand the business rules and working with data warehousing team.
• Testing the developed reports for final deployment.
• Created complex reports in Report Studio such asconditional, dashboards and drill through reports.
• Customized data by adding the Prompts, Filters, Calculations, Summaries, Functions and Conditional formatting.
• Developed Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Report Studio.
• Involved in Installation and configuringFramework Managerand its components on Windows.
• Developed theMetadatalayer by importing the required objects into Framework Manager
• Documented self developed reports and Framework Manager (FM) Models as well as supported them.
• Organized the metadata as per the requirement in Folders and Namespaces in Framework Manager.
• Published Packages to theCognos8.4 server using Framework Manager
• Created IQDs by externalizing the Query Subjects in Framework Manager.
• Implemented the Security atdata and object levelin Framework Manager.
• Created various reports using Cognos functionalities likeSub-Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula\'s.
• Designed theDimensional Modelsfor transformer andPower Play cubesusing PowerPlay. Explored the cube data using the Report Studio and Analysis Studio.
• Scheduled the reports in Cognos Connection and distributed them via mail.
• Responsible for creating test plan documents and documented the test results.

Environment:Cognos 10.1, 8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio Cognos Connection, Cognos Configuration), Access Manager, IIS, Oracle 9i, Windows 2003/XP.

Client: Confidential, Markham ON Jan 10 - Apr 11
Role: Sr. Cognos Developer
Responsibilities:

• Analyzed and delivered Report Development Infrastructure setup, Data Modeling, Data Architecture, Report Design, Security and Maintenance.
• Worked on Data Mapping for the models for data transformation.
• Designed DMR data models and Published Packages using Framework Manager.
• Worked with Informatica 8.4 to extract, transform and to load data.
• Involved in full development of life cycle (SDLC) within Cognos reporting Framework from developing business requirements to QA and production environment.
• Applied three levels of security to the model (Data, Object and Package).
• Installed Cognos 8 Metric Studio, Report Studio, Query Studio and Cognos Connection
• Involved in Designing and Creating various models, and Publishing packages in Framework Manager
• Published the models in Development Environment and applied the Folder security and access capabilities for the users.
• Provided the prompts, filters, drillup/drill down in Query Studio.
• Created different types of reports like predefined Filters for the Ad hoc users, List, Cross-tab, Chart, Drill-Through, Scorecard, variance and Master-Detail Reports for production using report studio.
• Created multiple Dashboard reports for multiple packages.
• Created scorecards to calculate the actual and target sales reports in Metric studio.
• Developed Prompt Pages, Cascaded input Prompts to display only selected entries in the report and also worked on the customization of prompt parameters.
• Created multi page, multi query, Prompts, drill through Report Studio report for corporate marketing, Sales and Products.
• Created reports for forecast, budget, and variance reports using cognos enterprise planning TM1 9.4.
• Created Cubes using Power Play and Transformer for multidimensional reports.
• Created calculated fields in Transformer for the analytical data based on measures, Levels and dimensions.
• Designed and Prepared a Training Material for the Users.
• Implemented Cognos architect based business intelligence solutions, BI modeling, Report Studio, Metric StudioandAnalysis Studio.
• Involved in Migrating Reports, Cubes from Cognos series 8 to Cognos 8.4.
• Migrated the reports to Test Environment, Ensured that it works fine when migrated to Test and good to go for Production.
• Used Cognos SDK validation tool to validate the reports in the content store.
• Involved ininstallation, configuration and upgrade from Cognos 8 to 8.4, Deployment, Testing and scheduling the reports.
• Involved in fixing tickets and bugs while developing the reports.
• Implemented prompt skipping in Cognos 8 Reports.

Environment:Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis studio, SDK), TM1 9.4, Cognos 8, Power play, Transformer, ERwin 7.3, Toad, ORACLE10g/11g, PL/SQL, SQL, Teradata implementations, Informatica 8.x.

Client: Confidential, Warren NJ/ Toronto ON May 08 - Dec 09
Role: Cognos Developer
Responsibilities:

• Created new packages using Framework Manager for asset management systems to accommodate new business changes to ensure proper business reporting needs.
• Involved in Strategic Planning forCognos Framework Model.
• Created data models using Framework Manager and published packages to Cognos Connection to support the development of canned reports and to enable Query Studio users to perform ad-hoc querying.
• Involved in gathering business specifications and prepared technical specifications by closely working with Business Users.
• Troubleshooting the existing Framework models.
• Implemented Security at Object Level, Data Level and Package Level in Framework Manager.
• Created reports and did production support.
• Created User Groups, Roles in Cognos Connection to implement the Security Features.
• Updated Database views as for user requirements
• Generated various List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill -Through Reports.
• Developed Powerplay Models and Cubes using Powerplay Transformer.
• Developed Reports using Analysis Studio and Powerplay Studio.
• Dimensional data modeling and cube development in Set up Auditing Database and Audit reports.
• Loaded data into from relational data sources and flat files.
• Scheduled reports to run on a month to month, week to week basis and used them to publish data and use this data to generate reports.
• Documented the complete production process, Framework Designs.
• Worked with Cognos tech support team to resolve various issues.

Environment: Cognos 8.0(Report Studio, Analysis Studio, Query Studio, Cognos Connection), PowerPlay Transformer 7.x, PowerPlay Enterprise Server7.x, Cognos Access Manager, ReportNet 1.1, Framework Manager, Oracle9i, SQL Server 2000, DB2,Erwin.

Client: Confidential, Warren NJ Nov 06 - Apr 08
Role: Cognos Developer
Responsibilities:

• Customization of Cognos Connection
• Custom Portal development.
• Developed Stored Procedure to write back to database from Cognos Report.
• Developed a zone related reports with dynamic date selection using JavaScript.
• Developed JavaScript for tabbed layout of report in one portal.
• Developed Framework Manager Model.
• Developed date data item with complex iteration and daylight saving logic.
• Developed parameter map in Framework Manager for dynamic date selection in Cognos report level.
• Developed Drill through and drill down reports.
• Developed security layout for the zone related reports.
• Documented the process for security.
• Documented the process for deployment from Development to Production.
• User training for use of Cognos Report and Frame work Manager Development.
• On demand report development as per customer request.
• Created template for reports.
• Scheduling reports using event studio with trigger based schedules.
• Data validation of reports using query studio, framework manager and report studio.
• Cognos Connection and Cognos Viewer customization
• Java script usage to create tabbed interface report.
• Java script usage to do HTML reference of numerous Cognos Report view to display as single Report.
• Portal page development with HTML references to report views
• Security setup with folder structure organization and usage specify group security setup.
• Performance tuning of Cognos Reports, FM model and infrastructure with java runaway memory issue resolution.
• Saving Reports to external file system.
• Worked as Onsite lead for offshore team.

Environment: Cognos 8.0, Framework Manager, Stored Procedure in SQL 2008, Cognos Connection, Report Studio, Query Studio, Event Studio, LDAP, and PowerPlay Transformer

Client: Confidential, Toronto ON Apr 05 - Oct 06
Role: Cognos Developer
Responsibilities:

• Attended weekly meetings to understand and recommend the business solutions.
• Installation and configuration of Cognos Report Net Environment.
• Used Framework Manager to build models, packages and publish packages to the Report Net Server.
• Built models containing query subjects, query items, and namespaces from imported metadata.
• Modified packages to suit the business needs and improved the performance of the reports by defining filters and adding calculations.
• Conversion of existing Impromptu Reports to report studio reports.
• Developing Standard reports, Charts, Drill through reports, Master Detail reports Using Report Studio and ad hoc reports in Query Studio
• Created list reports, cross tab reports, chart reports using Report Studio.
• Created query prompts, calculations, conditions & filters, prompt pages, using Report Studio for several reports.
• Created Complex reports using custom prompts and Tabular Objects.
• Scheduling and distributing reports through Schedule Management in Cognos Connection.
• Developing Multi-Dimensional Analysis and building Power Cubes using Cognos Power Play and Transformer and created the drill through reports for the cubes.
• Implemented drill-through from power play web to Cognos Server.
• Associate with ETL team to build a data warehouse environment and provide constant updates about the necessary changes required.

Environment: Cognos Report Net 1.1, Cognos EP Series 7 (Impromptu, Power Play, Transformer, Access Manager, Upfront, IWR), ReportNet1.1 (Framework Manager, Report Studio, Query Studio),Oracle8i, 9i, SQL Server 2000.