SUMMARY

• Over 7+ years of IT experience and extensive experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and maintenance.
• Expertise in Cognos 10.2.1/8.x BI Suite (framework Manager, Cognos connection, Report Studio, Metric Studio, analysis Studio and Query Studio)
• Around 4.5 years of experience in Cognos Reports development - Report Net and Framework Manager
• Expertise in data modeling for creating Models in Framework Manager and used to create packages and Published to Cognos10/8 and generated different types of reports including templates, list, Cross-tab, Chart using Query Studio & Report studio in Cognos 10/8.
• Expertise in installation and configuration of Cognos 10/8, Report Studio, Query Studio and Access Manager.
• Worked on Security access to clients using Access Manager and worked with Data Access, Object Access, and Package Access in Frame Work Manager.
• Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Extensive experience in Developing List, Cross Tab, Chart, Dynamic Reports and Drill Through Reports in Cognos BI Suite 10/8, Report Net.
• Expertise in Developing Complex Reports and high impact dashboards using Report Studio in Cognos 10/8 BI Suite.
• Excellent Knowledge in Data modeling, Logical/Physical model &ER-Diagrams.
• Excellent knowledge in data warehouse development life cycle, gathering requirements and analysis, dimensional modeling, metadata management and implementation of STAR, Snowflake schemas, Incremental loads/Change Data Capture and slowly changing dimensions
• Worked with heterogeneous data sources like Oracle, SQL Server 2005, Essbase, Sybase flat files, XML files, DB2 files
• Strong experience with client interaction, understanding business applications, business data flow and data relations
• Good communication skills with strong ability to interact with end-users, customers, and team members

TECHNICAL SKILLS

Business Intelligence Tools: Cognos10/8.x, Report Studio, Active report Studio, Cognos Work Space, Cognos Work Space Advanced, Query Studio, Framework Manager, Analysis Studio, Metric Studio, Cognos EP 7 Series i.e Impromptu, Cognos Power Play, Cognos Transformer.

RDBMS: Oracle 10g/9i/8i

Programming Languages: C, C++, SQL, PL/SQL Programming.

Web Technologies: HTML, ASP, XML, HTML 4.0, Front Page.

Data Modeling: Star Schema Modeling, Snow Flake Modeling, FACT & Dimensions, Erwin, MS Visio.

Operating Systems: Windows 2000 Server/ 2003 Server/XP and Unix.

PROFESSIONAL EXPERIENCE

Confidential, NY

Cognos Developer

Responsibilities:

• Gathered report requirements from Business Users and converted them in to technical documents.
• Designed, developed and implemented an Enterprise Wide Reporting system using cognos 10/8.x.
• Imported metadata from various sources from Data mart into Framework Manager.
• Created Imported View, Business View and Dimensional View in Framework Manager.
• Developed Framework Manager Model to meet reporting requirements.
• Created folders, filters, and complex business calculations in Framework Manager and Report Studio.
• Using Framework Manager to build models, packages and publish packages to the cognos connection.
• Created User groups, roles to implement the Cognos Security using LDAP.
• Develop and deliver complex reports that meet business user needs.
• Created Ad-hoc reports using Query Studio.
• Created Complex List, Cross tab, and Chart reports using Report Studio.
• Created dashboards using active reports and report studio.
• Expertise in maintaining Database Schemas like Star Schema and Snowflake Schema used in relationship and Dimensional modeling.
• Proficiency with SQL including Query Performance and Optimization .Developing and Understanding of data structures, Data Normalization, and query performance considerations with different testing Environments
• Created joins between Queries to create Complex Reports in Report Studio.
• Created Drill Thru reports for Report Studio Reports for much detailed information.
• Created Pages in the reports to display depends on Prompt values.
• Bursting the Reports in Cognos Environment and sending by mail.
• Developed complex reports like Drill Through hand Dash Boards and Created reusable templates for developing reports.
• Implemented Conditional formatting for highlighting rows and columns, and hiding individual rows.
• Performed comprehensive Unit testing by comparing the cognos reports against the database using sql in TOAD and documented the same.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Worked on Transformer for modeling of the data for building Multidimensional Cubes.
• Created reusable templates for developing reports.
• Experience managing DEV, TEST & PROD environments.
• Support both business users and IT users within the organization.
• Attend status meeting on weekly and daily basis.
• Deployed Reports & Packages to QA (Sandbox) and production environments.
• Tested all the reports with Generated SQL and Manual SQL data.

Environment: Cognos 10/8.x(Report Studio, Active report Studio, Cognos Work Space, Cognos Work Space Advanced, Query Studio, Framework Manager, Analysis Studio), ORACLE 10g, TOAD 9.1, IIS, Windows 2003 Server. Powerplay Transformer 7.4, SQL HTML, Cognos data manager, Informatica 8.5, Erwin 4.0 Cognos data manager, Informatica 8.5.

Confidential, NJ

Cognos Developer

Responsibilities:

• Interacting with Business Users for gathering Business Requirements to develop the report mockups.
• Imported metadata from various sources like DM Data mart and DL Data mart into Framework Manager.
• Developed Framework Manager Model to meet reporting requirements.
• Expertise in maintaining Database Schemas like Star Schema and Snowflake Schema used in relationship and Dimensional modeling.
• Proficiency with SQL including Query Performance and Optimization.
• Created folders, filters, and complex business calculations in Framework Manager and Report Studio.
• Using Framework Manager to build models, packages and publish packages to the cognos connection.
• Created User groups, roles to implement the Cognos Security using LDAP.
• Managing User ID’s and User groups like Providing Privileges to the users and User Groups in Access Manager.
• Added Package level security to the packages and Object level security to the Query Subjects.
• Created Ad-hoc reports using Query Studio.
• Created Complex List, Cross tab, and Chart reports using Report Studio.
• Developed Dash Board Reports on Cognos 8 Report Studio.
• Created Drill Thru reports for Report Studio Reports for much detailed information.
• Bursting the Reports in Cognos Environment and sending by mail.
• Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Involved in developing score card Applications using Metric Manager and Metric Studio.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Created reusable templates for developing reports
• Experience managing DEV, TEST & PROD environments.
• Support both business users and IT users within the organization.
• Deployed Reports & Packages to QA (Sandbox) and production environments.
• Tested all the reports with Generated SQL and Manual SQL data.

Environment: Cognos 10 & 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio), ORACLE 10g, TOAD 9.1, IIS, Windows 2003 Server. Powerplay Transformer 7.4, SQL HTML, Cognos Data Manager, Informatica 8.5, Erwin 4.0.

Confidential, NJ

Cognos Developer

Responsibilities:

• Worked on framework manager to import metadata from multiple data sources and to create subject matter Models, create and publish packages to ReportNet server.
• Involved in design and development of Joins, filters, calculations, prompts and conditional variables in Packages in Framework Manager.
• Involved in scheduling and Administering Cognos ReportNet reports using Schedule Management in Cognos Connection.
• Created Projects, Models (layers, relations, cardinality, Query subjects, star schema and packages) and Published Packages using Framework manager.
• Created Metadata Modeling by using multiple data sources in Cognos 8 BI Modeling.
• Created and maintained issue tracking and Change control documents.
• Used Report Studio to create standard reports and complex reports with drill through, master detail relationships, cascading prompt, complex layout, conditional formatting, and user interactions. Created Calculations, Prompts and conditions in Reports
• Peer Reviewed Design and Code of other Developers, prepared defects list and modified design docs and Code as per defects list
• Worked on summary reports and detail Reports.
• Developed standard historical reports in Report Studio for use of Call center Mangers.
• Worked on scheduling and publishing the report to the Cognos Connection.
• Secure Cognos Connection and setup ReportNet Security by assigning user to the groups and roles defined in Cognos Namespace.
• Worked on Security access to clients (using Access Manager and Report Net with LDAP also worked with Data Access, Object Access, and Package Access in Frame Work Manager).
• Created drill through reports with different parameters and associated with the summary reports to get the details.
• Sql Tuning to enhance the performance of the reports.
• Created reports using Prompts, Calculations, Conditions& Filters
• Administered ReportNet server with the primary objective of tuning server performance to optimize speedand efficiency.
• Created Models by using various data sources in PowerPlay Transformer.
• Created User Classes and Users in Access manager and provided the user credentials
• Created extremely big OLAP cubes.
• Used PowerPlay Enterprise Server to publish the cubes and Impromptu reports to the Upfront.
• Working closely with the ETL Team in the troubleshooting the data issues worked with Maintenance and Production support team in Scheduling activities
• Deployed Reports & Packages to QA (Sandbox) and production environments.

Environment: Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio), ORACLE10g, TOAD 9.1, IIS, Windows 2003 Server. Power play Transformer 7.4, SQL HTML, Cognos data manager, Informatica 8.5, Erwin 4.0.

Confidential

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 different reports using templates in Impromptu.
• Created conditional highlighting particular measures for user requirement.
• Designed and developed multi-dimensional cubes.
• Created Impromptu Web Reports and published them on the web server and later on upfront.
• Created News boxes in Upfront and customized the environment. Set Security for News Item and New boxes in Upfront. Set Privileges for user classes by defining News Index Admin.
• Created different prompts like value prompt in the reports.
• Created master detail reports using Impromptu toll.
• 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: Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio), ORACLE10g, TOAD 9.1, IIS, Windows 2003 Server. Power play Transformer 7.4, SQL HTML, Cognos data manager, Informatica 8.5, Erwin 4.0.