SUMMARY

• Over 10+ years of extensive experience in IT industry which includes extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI),Qlikview Decision Support Systems (DSS) and OLAP, ETL tools, product development and Reports Generation.
• 6+ years of working experience with Business Intelligence tool Cognos 8.1/8.2/8.3/8.4 BI Suite (Framework Manager, Report studio, Query Studio, Analysis Studio), Transformer, Cognos Report Net v1.0/1.1, Cognos 7 series (Power Play Transformer), Access Manager, Scheduler.
• 2+ years of experience in developing report using Qlikview.
• Experience in fill life cycle development including planning, Analysis, Design, Implementation and Maintenance using Qlikview.
• Created Models for reporting and published packages in Cognos Connection using Framework Manager
• Developed Reports using Cognos 10.1.1, 10.2.1 Active Reports & Statistics.
• Experience in developing various reports like List reports, Crosstab reports, Charts, Dash Boards and Score cards
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Experience in Conceptual, Logical and Physical data modeling with strong knowledge of Data warehousing concepts and Dimensional modeling Star schema and Snowflake schema.
• Expert at creating Multi - dimensional Cubes for corporate data using Power Play Transformer.
• Strong programming and debugging skills in Oracle Data Warehouse, PL/SQL, SQL,Postgre SQL
• Published cubes and Power Play reports to Upfront using Power Play Enterprise Server.
• Hands on experience in administering, deploying and maintaining models, reports and cubes
• Installed and configured various components, such as the Framework Manager and Content Manager.
• Strong understanding of Dimensional Modeling (Star and Snowflake Schemas)
• Strong Experience in User acceptance test, product support, version control and change management.
• Possess Excellent Communication (both verbal and written) & Interpersonal skills technically sound, Result-Oriented with strong Problem Solving skills.
• Involved in various activities of the Software Life Cycle in Cognos suite of products
• Team Player as well able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies.
• OLAP Cognos 10.2.1, 10.1.1, 8BI 8.4/8.3/8.2/8.1 (Report Studio, Query Studio, Cognos Connection, Analysis
• Studio, Event Studio and Framework Manager), Cognos Go Office, Report net 1.1, Power play
• Transformer, Impromptu Web Reports (IWR), Upfront, Cognos Impromptu Administrator and MS-Excel
• Data Modeling Erwin 4.x/3.5.2/3.x, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake
• Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer RDBMS Oracle 11g/10g/9i/8i, Green Plum, MS SQL Server 2008/2005/7.0 , MS Access 5.0, My SQL, DB 2 9.0.

TECHNICAL SKILLS

Business Intelligence: Cognos 10.2.1 Cognos 10.1.1, Cognos 8.4 FM, Cognos 8.4 Report Studio, Cognos8.4,8.3 Event/Analysis Studio, Transformer, Cognos Report Net 1.1, Cognos Series 7 Modeling, Power play.

SAP: SAP Basis & BW

RDBMS & Tools: SQL*Plus, EXP/IMP, SQL*Loader, SQL Server 8.0

Tools: MS Project 2003, TOAD

Databases: MS SQL Server 2000, MS Access, Green Plum

Languages: C, C++, PLSQL

Web Tools: HTML, XML

Operating Systems: Microsoft 95/98/2000/XP/NT, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

Sr Cognos Developer

Responsibilities:

• Analyzed Business requirements from the analysts.
• Involved in Desiging models using Framework Manager and deployed packages to the Report Net Servers
• 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.
• Modeled metadata from SQL Server 2005 data source for use in Report studio and Query Studio using Framework Manager in ReportNet
• Creating the Teradata views as per the business and reporting requirement.
• Importing the Teradata Views to the model and creating the relation between the views.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Created custom templates and custom toolboxes for the use of reporting.
• Customized Cognos Connection with appropriate reports and security measures
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Moved projects from development to QA and then Production servers
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in the Testing of the reports and updating the Bug Tracking Tool
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members

Environment: Cognos 8.2 BI Suite, Cognos FrameworkManager8.2, Cognos Impromptu 7.3, Cognos Power Play 7.3, Cognos Transformer 7.3,SQL Server 2005, Teradata, Windows 2003 Server

Confidential, Alpharetta, GA

Sr Cognos Developer

Responsibilities:

• Interaction with business users to gather business requirements and designed functional and technical requirements documentation.
• Worked on framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages to Cognos 10 server.
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Used Framework Manager to externalize query subjects in order to generate IQD data sources for Powerplay cube creation in Powerplay Transformer.
• Built and Published the Packages to Cognos 8 and Cognos 10 Server according to user requirements
• Experienced in creating different types of security in models using framework Manager.
• Secure Cognos Connection and setup Security by assigning user to the groups and roles defined in Cognos Namespace.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio
• Worked on Multidimensional Models and created Reports in Report Studio using Cubes as a data sources.
• Proficient in developing Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
• Used Go Dashboard to generate highly complex graphical reports.
• Migrated reports created in Cognos 8 into Cognos 10.
• Involved in installation, configuration and upgrade of Cognos 8 to Cognos 10.1.
• Worked on creating Prompts and Cascading Prompts Pages.
• Worked on summary reports and detail Reports, drill-thru reports.
• Created drill through reports and associated with the summary reports to get details.
• Validated report results with the source data and sanctioned the reports to production environment.
• Worked on scheduling and publishing the report to the Cognos Connection.
• Proficient in deploying Reports and Packages from one environment to other environments.
• Used conditional formatting to achieve identical results in different formats like HTML, PDF and EXCEL.
• Created users and giving authorizations to the system users depending on their roles.
• Developed transformer models using Powerplay Transformer (OLAP) and also developed models using Cognos 8.3 / Cognos 8.4 /Cognos 10.1 Transformer.
• Modified power cubes by adding new dimensions, levels and measures etc.
• Published cubes as packages to cognos connection using framework manager.
• Published cubes directly from Cognos 8.3/cognos.8.4 / Cognos 10.1 Transformer using new publish functionality.
• Worked on cognos production tickets to meet business requirements.
• Prepared Report documents once the development is completed.
• Installed and Configured Cognos TM1 Architest and Cognos Insight 10.2 and Cognos TM1 Application in Development Environment.
• Developed some Reports using Cognos Insight and published into Cognos TM1 Application and Cognos Connection.
• Conducted Team Meetings Every week.
• Assigned tasks to Team Members and Conducted Weekly Meetings with Team Members.
• Updated the Status in weekly Meetings.
• Trained end users on Query Studio for Ad-hoc reporting as well as involved in the Documentation.
• Developed Business Requirement Specs as a Business Analyst.
• Acted as lead in troubleshooting Report performance problems.

Environment: Cognos 8.4/Cognos 10.1(Cognos Connection, Framework Manager, Report Studio, Query Studio, Business Insight, Business Insight Advanced, Metric Studio and Transformer), Oracle 9i/10g, TOAD 9.5, Query Analyzer.