SUMMARY

• Over 8 years of experience in development and implementation of Data Warehousing applications using Cognos BI tools in both small and large organizations with strong business understanding knowledge of Financial, Pharmaceutical, Insurance and Construction.
• Expertise in Cognos 8/Cognos 10 BI suite (Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, Cognos Configuration), Framework Manager, PowerPlay Transformer, PowerPlay client.
• Experience in Cognos 10 BI Suite and Upgraded reports and models from Cognos version 8.4 to Cognos 10.
• Experience in publishing PowerPlay cubes to Cognos 8 and reporting using Analysis Studio and Report Studio.
• Excellent knowledge of ReportNet (Report Studio, Query Studio, Cognos Connection, Framework Manager).
• Highly experienced using Cognos series 7 (Impromptu, Impromptu Web Reports (IWR), Cognos Scheduler, Access Manager, UpFront, Cognos Visualizer, Impromptu Administrator) and OLAP tools (Cognos Transformer and PowerPlay
• Involved in the entire BI lifecycle project development, including design, coding, testing and implementation and ongoing product support.
• Expertise in OLTP/OLAP system study, developing models and publishing packages using different schema concepts.
• Working knowledge of designing multidimensional architecture for Extract, Transform, Load environment with Informatica and Cognos tools.
• Experience in working with Data Manager.
• Experienced in Data Mart, Star Schema, Snowflake Schema, Data Requirement Analysis, Design, Development, Testing, Documenting and Implementation of Business Applications.
• Experience in dimensionally modeling relational data sources (DMR) using Cognos 8 Framework Manager.
• Expert in designing and developing complex reports in Report Studio.
• Experience in Oracle 10g/9i, PL/SQL, SQL, Stored Procedures, Functions, Triggers, SQL Server 2003/2005/2008 and MS Access.
• Self - motivated team player and enjoy working in a technically challenging environment. Have excellent communication and interpersonal skills.

TECHNICAL SKILLS

Reporting (BI) Tools: COGNOS 10/8.2/8.3/8.4 , Cognos ReportNet 1.1 (Report Studio, Query studio, Framework Manager, Cognos Connection), Data Manager, Cognos 6.x/7.x Impromptu Administrator, Power Play, PowerPlay Transformer, PowerPlay Enterprise Server (PPES), Impromptu Web Reports (IWR), Upfront, Cognos Query, Scheduler, Access Manager, Crystal Reports.

ETL Tools: Informatica (Power Mart/Power Center 5.1), SSIS, Decision Stream, Data stage.

Web Servers: Internet Information Server (IIS), Apache Web Server (AWS) ServerInternet Explorer, Netscape

Languages: HTML, JavaScript, VBScript

RDBMS: Netezza, ORACLE 8.i/9.i/10g, SQL 2000/2003/2005 , PL/SQL, DB2, Siebel, MS Access

Operating System: Windows 95/98/2000/2003 , Windows XP Professional, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Westfield Center, OH

Senior Cognos Developer/Tester

Responsibilities:

• Worked closely with Business Analysts and Business Users to understand and gather the business requirements.
• Active team player in Development and as well as in Testing.
• Worked on the performance tuning of the reports and troubleshooting.
• Developed complex reports with joins, unions, complex SQL queries, calculations, and conditional formatting, drill troughs.
• Developed prompt pages and applied conditional variables.
• Built multi-dimensional models and cubes in Transformer using IQDs
• Reduced the cube build times drastically and increased runtime performance
• Developed report studio reports on cubes using MDX functions.
• Designed hierarchies for various dimensions as part of DMR modeling and also developed star and snowflake schemas.
• Unit tested various reports and wrote test cases, developed data balancing techniques for several reports.
• Defect handling for reports and cubes.
• Performed System testing using Quality Center.
• Created Test plans and executed them in Test Lab using Quality Center.
• Defect handling for reports and cubes in Quality center.
• Upgraded reports and models from Cognos version 8.4 to Cognos 10.
• Worked on Cognos 10 Active reports.
• Created several reports using Cognos 10.

Environment: Cognos 8.4.1/10(Report Studio, Query Studio, Analysis Studio, Power Play Studio, Framework Manager), Quality Center 10, Netezza, DB2, Toad, Windows, Excel 2003/2007/2010

Confidential, WI

Senior Cognos Developer

Responsibilities:

• Generated reports and handle modeling as per user requirement.
• Developed test cases for report optimization after interacting with the end users.
• Created multiple projects and published DMR packages.
• Building relational and dimensional models in Framework Manager, based on work flow and end user analysis requirement. Developed Framework Manager Models by importing metadata from different relational databases such as SQL Server, Oracle.
• Created cubes in Cognos Transformer and used the package to create Analysis Studio reports.
• Adding new dimensions, hierarchies or dropping dimensions for changed data.
• Created filters, prompts, calculations and determinants for efficient data retrieval and analysis.
• Created parameter maps; stored procedures for importing as data source, checked for corrupted models and restored to original.
• Worked extensively at editing native and pass through SQL generated to resolve incorrect generation of stitched queries.
• Proficient in Report building using Report Studio, and Analysis Studio.
• Created List, Crosstab and Drill-Through reports using Report Studio.
• Created Ad-Hoc reports using Query Studio.
• Deployed the reports from development environment to test environment.
• Active team player in the Project.
• Tested models and reports, from time to time to remove any inconsistencies. Responsible for Unit testing and System testing of the reports based on the specification.
• Reporting testing - creating test cases, scripts and executing them. Tested the fixed reports in Cognos 8 environment as well as the Performance of the reports in Cognos 8 environment.

Environment: Cognos 8.4.1 (Transformer, Cognos Configuration, Framework Manager, Report Studio, Query Studio & Analysis Studio), Windows Server 2008, SQL Server, Oracle 10G, and MS Office (MS Excel, MS Access)

Confidential, IA

Senior Cognos Developer

Responsibilities:

• Customized the Cognos Connection home page by modifying the system.xml file.
• Managed custom views of Cognos Connection for different roles and groups of users.
• Active team player in coordinating with other developers to gather the data required for the reports.
• Participated in discussions with the senior management to better understand the business requirements
• Worked with dimensional modeling of relational data sources (DMR) using Cognos 8 Framework Manager and create cubes using Framework Manager.
• Cleansed the raw data provided and used Data Manager to transform data from different sources into a single delimited file.
• Identified data sources and created catalogs that house fact and dimension builds along with job streams using Data Manager to carry out the ETL processes
• Developed several cubes using Transformer and published them to Cognos Connection.
• Proficient in the Transformer model, and cube design with single or multiple data sources.
• Created reports with drilldowns and drillups.
• Proficient in Report building using Report Studio, and Analysis Studio.
• Created Dashboard Reports in Report Studio.
• Responsible for development of reports that in corporate prompts, complex conditional formatting, pie charts, cross tabs, bar charts, line charts, maps using Report Studio and Unit testing the same.
• Responsible for user training on Report Studio, Data Manager, Transformer.
• Responsible for documenting all the processes and provide training manuals.

Environment: Cognos 8.4 (Data Manager, Transformer, Cognos Configuration, Framework Manager, Report Studio, Query Studio & Analysis Studio), Windows Server 2008, and MS Office (MS Excel, MS Access)

Confidential, Kenilworth, NJ

Senior Cognos Developer

Responsibilities:

• Installed and Configured Cognos 8BI version 8.3 Suite in multi server environment on Windows and UNIX environments.
• Involved in Planning and implementation of entire Cognos BI Suite.
• Created Metadata Modeling by using multiple databases in Cognos 8 BI Modeling.
• Created Complex Reports in Cognos BI Report Studio.
• Created Powerplay Reports by using Analysis Studio.
• Created and Published packages from Cognos 8 BI Modeling.
• Scheduled Content Store Backup.
• Create Scheduled Jobs by scheduling multiple reports in a job.
• Published Powerplay Cubes onto Cognos Connection by using Cognos 8 BI Modeling.
• Maintained different levels of cube security.
• Upgraded Reportnet Reports, Packages and Data Source Connections into Cognos 8 BI.
• Created Metadata modeling by using Framework Manager.
• Imported metadata from various sources such as Relational Databases, Report Net models, Impromptu Catalogs into the Framework Manager.
• Created OLAP cubes by using Powerplay Transformer.
• Upgraded all cognos 8 packages, reports and folders from 8.3 to 8.4
• Used Query Studio to develop ad hoc reports
• Helped in the training of users in Cognos 8.4
• Day-to-day Cognos administration activities like monitoring Scheduling jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance.
• Creating report views with saved prompts and schedule according to the business requirement.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Personalized Cognos Connection, Specified display options, regional options and personal information.
• Involved in the Troubleshooting Process to support at different levels.
• Migrated Cognos Series 7.3 to Cognos 8 BI Suite version 8.3
• Implemented security in Framework Manager packages.
• Work closely with the users to get the specifications on the models and reports

Environment: Cognos 8 BI Suite version 8.3/8.4, Data Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager, Cognos Impromptu 7.3, Powerplay transformer, Upfront, IWR, Access Manager Windows 2000,UNIX,Teradata,Oracle 9i/10G, PL/SQL.

Confidential, NJ

Cognos 8 BI Developer

Responsibilities:

• Generated various List Reports, Grouped Reports, Cross tab Reports and Drill-Through Reports for the given requirements.
• Created complex dashboards with area charts, pie charts, crosstab and Multi prompts in Report Studio.
• Created Average, Summary and Percentage and user defined calculations, user friendly filters and prompts.
• Used Cognos Connection extensively to administer Reports. Planned and Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Created Scorecard Reports in Metric studio by using Metric designer.
• Used Cognos Connection to add Data sources to be used in modeling and for publishing packages.
• Created metadata model using framework manager, created packages and published the packages.
• Imported Stored Procedures from SQL server 2005 to Framework Manager for complex reports.
• Used different objects like Conditional Blocks, Tables, HTML item, hyperlink etc to create complex reports
• Migrating impromptu reports to Report studio.
• Deployed packages, folders and content store from a development environment to test and then to production environments.
• Scheduled Report studio reports, Analysis studio reports and PowerPlay cubes to run on a monthly, weekly and daily basis.
• Migrated ReportNet reports to Cognos 8.2 Report Studio.
• Collected user requirements to create reports in Report studio
• Creating Business specification documents.

Environment: Cognos 8.2, Report Studio, Query Studio, Analysis studio, Metric Studio, Frame Work Manager, Reportnet 1.1, Cognos PowerPlay Transformer 7.3, Migration Utility Tool, SQL server 2005.

Confidential, Atlanta, GA

Cognos Developer

Responsibilities:

• Installed and Configured Cognos 8 BI Suite Version 8.2 in windows and UNIX environments.
• Migrated from Cognos Series 7 to Cognos 8 BI Server.
• Worked on Meta data model Development using Framework Manager.
• Interacted with Management and Development teams to gather Business requirements for new models.
• Involved in Relational and Star schema database design and loading data.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Created metadata models, made appropriate Joins, organized Folders according to the Business view and published the packages using Framework Manager onto Cognos Connection.
• Maintained Security in Cognos Connection by controlling privileges for users, groups and roles.
• Involved in design and development of joins, filters, calculations and conditional variables in Packages within Framework Manager.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Created complex reports using Report Studio and Ad-hoc web based reports using Query Studio.
• Developed Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports and published them onto Cognos Connection.
• Created multi-dimensional cubes using Power Play Transformer and deployed the same along with reports using PowerPlay Enterprise Server.
• Created Calculated Measures in Transformer.
• Maintained Dimension level Security for Cubes in Power Play Transformer.
• Created Users, User Classes and Database Sign-ons in Access Manager.
• Performed Drill-down, Slice & Dice and Filtering operations done for all OLAP applications.
• Extensive experience in Exceptional highlighting, Sorting and Ranking.
• Developed dashboards for accurate on-time representation of financial data and cash flow analysis.
• Developed standard Templates for various kinds of reports.
• Involved in Scheduling reports using Cognos Scheduler.
• Trained end users on Query Studio for Ad-hoc reporting as well as involved in the Documentation.

Environment: Cognos 8 BI Suite Version 8.2, Report Studio, Query Studio, Cognos Connection, Framework Manager, Cognos Impromptu 7.3,Impromptu Web Reports, Powerplay Transformer 7.3, Cognos Scheduler, Cognos Upfront 7.3, Access Manager, Configuration Manager, Oracle 8i/9i, PL/SQL, SQL Server2000/2005,HTML,UNIX,Windows 2000.

Confidential, Herndon, VA

Cognos Developer

Responsibilities:

• Analyzed system requirements and developed detailed migration plans for the multi-dimensional reporting.
• Gathering the requirements from end-users and prepared the requirements documentation for consolidated and non-consolidated reports, the documentation for all the prompts in the consolidated reporting.
• Developed the transformer models for the consolidated cubes.
• Implemented the security in the transformer models.
• Developed the drill thru reports on transactional tables and reporter mode power play reports with filters.
• Identified the database driven and non-database driven data sources for transformer models.
• Published the cubes and IWR reports to deploy them into web.
• Testing the power play reports for functionality, filters, formatting and totals.
• Published the reports to upfront using PPES.
• Prepared the End-User testing plans and logs.
• Installed the power play client software on various users’ workstations.
• Configured the users’ workstations with the access manager configuration and created the remote connections in power play client to connect to the server cubes.
• Prepared the list of users and the user classes for the various reporting modules.
• Created the user classes in Access manager, assigned the user classes to users.
• Worked on the Administrative tasks such as load balancing the Power play Enterprise server, mirroring the power play cubes.
• Prepared the backups of data stores, report stores in the servers.
• Testing the IWR report filters, navigation and formatting.

Environment: Cognos 7.3,Upfront,Powerplay Transformer, IWR, Scheduler, Cognos ReportNet 1.1, Report Studio, Query Studio, Framework Manager, Cognos connection,, XML, Oracle 9i, MS-Access, SQL server 2000.

Confidential, Cleveland, OH

Cognos Developer/Administrator

Responsibilities:

• Involved in study of existing operational systems, data modeling and analysis.
• Migrated Impromptu Web Reports (IWR) to Cognos Report Net 1.1.
• Created SQL/Oracle database views, metadata models, made appropriate Joins, organized Folders according to the business view and published the packages using Framework Manager onto Cognos Connection.
• Created complex reports using Report Studio & Ad hoc web based reports by Query Studio.
• Created and modified Catalogs for different applications by using Impromptu Administrator.
• Installed and configured Cognos Series 7 Suite.
• Used Cognos Query to create Ad-Hoc reports in the Upfront.
• Determined the group of users in the company to create the User Classes.
• Interacted with Business Process teams to gather Business requirements for new models.
• Created reports using the business object functionality like queries, Slice and Dice, Drill down, functions and formulas.
• Created Master Detail and Cross Tab Reports.
• Created multi-dimensional cubes using PowerPlay Transformer and deployed the same along with reports using PowerPlay Enterprise Server.
• Maintained Dimension level Security for Cubes in PowerPlay Transformer.
• Created dimensional maps based on the customer requirement in Transformer.
• Implemented centralized security in Access Manager and created Database Signons in Access Manager.
• Developed standard Templates for various kinds of reports.
• Involved in scheduling reports using Cognos Scheduler.

Environment: Cognos Reportnet1.1, Report Studio, Query Studio, Cognos Connection, Framework Manager, Cognos Series 7 (Impromptu Administrator, Architect, Powerplay Enterprise Server, Impromptu Web Reports, Powerplay Transformer, Cognos Scheduler, Cognos Query, Cognos Upfront, Access Manager, Configuration Manager), Oracle 8i/9i, PL/SQL, SQL Server 2000, HTML, MS- Excel, Unix, Windows 2000.

Confidential

Cognos Developer

Responsibilities:

• Generated reports as per the requirements using Cognos Impromptu.
• Used Multidimensional analysis for Data Retrieval using PowerPlay structure
• Created PowerPlay cubes using Transformer.
• Extensively worked on prompts based on the user needs and format required
• Created User Classes who need to access the data in the catalog
• Maintained the security of the user classes
• Assigned password to user classes, assigned various kinds of accesses to table, folders.
• Used Access Manager to administer security for all the catalogs
• Defined conditions, calculations and prompts in the catalog.
• Enabled users to access the distributed HTML reports through local network intranet/internet, and via email.
• Used Impromptu’s optimizing features like table weighing, governors, bulk fetch
• Created various reports (List, Crosstab, Mailing Labels, Form Letter, Free Style) using Cognos Impromptu tool by querying the database
• Used Cognos Query is adhoc-reporting product for the web.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Created Hierarchies from providing drill down options for the end-user.
• Coordinated in training sessions and demonstration of Cognos tools to End-users.
• Assisted users in trouble shooting their reports.
• Used Business Miner to mine the trends in the system.

Environment: Cognos Impromptu 6.0, Cognos PowerPlay, Cognos PowerPlay Transformer, PowerPlay Enterprise Server, Cognos Upfront, Oracle 8.0, SQL Server 2000, HTML, MS-Access, MS-Excel, and Windows 2000.