SUMMARY

• More than 9 years of experience in I.T industry and 8 years of experience in Data Warehousing environment.
• More than 1 year of experience in Cognos 10.1 and 4 years of experience in Cognos 8.x and Cognos ReportNet 1.x and 2 years of experience on all Cognos EP Series 7.x tools (Impromptu, PowerPlay, Impromptu Web Reports, Power Play Transformer, Access Manager, Cognos Architect and Cognos Upfront).
• Created and published packages using Framework Manager and generated different kind of reports including templates, multilingual reports, complex reports using Report studio in ReportNet.
• Used Cognos Connection extensively to monitor and manage dispatchers and services, set and maintain security, create and manage data sources, administer reports and deploy data from one environment to another.
• Proficient in Business Insight Advanced and Query studio reporting.
• Adept in designing Catalogs and creating List Reports, Freestyle Reports, Cross - Tab Reports, Sub Reports and Exception Reports using Cognos Impromptu.
• Experienced in using Architect for designing models, creating packages, and publishing those packages on Upfront and creating catalogs for Impromptu.
• Designed, developed, and implemented Cubes using Cognos PowerPlay Transformer for various reporting purposes.
• Developed Impromptu Reports and published into the web for end users using IWR.
• Developed PowerPlay Reports and published into the web for end users using Upfront.
• Installed and configured Impromptu, PowerPlay, PowerPlay Transformer, Upfront, and IWR.
• Generated different user classes and users using Access Manager and configured Access Manager and ticket server.
• Worked with different kinds of sources like Relational, Flat files, Xml, ERP.
• Proficient with different databases like Oracle 11G, 10G, 9i, 8i, MS-Access, MS-SQL, PL/SQL 8.0.
• Possess deep knowledge on various phases of software development cycle including analysis, design, development, testing and implementation.
• Strong management experience along with teamwork building and excellent communication skills.
• Excellent problem solving and analytical skills.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 10.1/8.3/8.4 , Cognos ReportNet 1.01/1.02/1. x, PowerPlay Transformer, Cognos PowerPlay 8.x/7.x Cognos Impromptu 7.x, iReports, Cognos Architect, Access Manager, Cognos Visualizer, Impromptu Web Reports, Cognos Upfront, PowerPlay Reports, Datastage 8.1

Databases: Oracle 8.x/ 9i/10G/11G, SQL Server 2000, DB2, MS Access

Operating Systems: UNIX, Windows 95/98/2000/NTP/XP

Web Technologies: HTML, XML, Java Script

Version Control Tools: WinCvs, SVN, Visual Source Safe

Programming Languages: SQL, C, C++, MATLAB

PROFESSIONAL EXPERIENCE:

Confidential, TX

Sr Cognos Consultant

Responsibilities:

• Understanding the business requirements and report specifications.
• Managing, leading and training the reporting team.
• Creating and managing data sources using Cognos Connection.
• Designing relational and dimensional models for reporting using Framework Manager.
• Importing data from relational data sources like Oracle, DB2. Implementing inner joins and outer joins between query subjects and creating session parameters in Framework Manager
• Creating Database views and Business views and publishing the packages in Framework Manager.
• Creating user friendly Framework models for Business Insight and Query Studio reporting for end users.
• Creating financial reports using Report Studio and iReports.
• Migrating ReportNet 1.1 reports to Cognos 8.3
• Enhancing the legacy reports using the advanced features in Cognos 8.3
• Designing and developing the Trade Dashboard reports in Cognos10.1
• Provide training and helping end users to create reports in Query studio and Business Insight.
• Tuning the reports and report sqls for performance improvements.
• Creating test cases for unit and functional testing of reports.
• Providing support for functional and quality testing of reports for SIT and UAT teams.
• Trouble shooting the reports for data issues.
• Implemented Table of Contents and Drill Down features in the report that helps the users to better navigate across different sections of the report.
• Translating the reports to Chinese, Spanish, German and French languages using the XML automator tool.
• Designing dashboard reports with prompts and drill throughs to the detailed reports.
• Build reports using different templates like list reports, crosstab reports, chart reports and repeater reports.
• Creating reports using tabular models, tabular sets, tabular SQL as tabular data elements.
• Designing drill through reports, master detail reports, and bookmark reports.
• Used HTML items, Hyperlinks, conditional layouts, conditional blocks, images, and prompts in reports.
• Build stored procedures using PL SQL developer and calling the stored procedures to populate temp tables and use the temp tables for reporting.
• Deploying packages and reports from development environment to test environment and to production environment using deployment manager.

Environment: Cognos 10.1, Cognos 8.4/8.3, Cognos ReportNet 1.1 (Frame Work Manager, Cognos Connection, Business Insight Advanced, Report Studio, Query Studio), iReports, Oracle 11G/10G/9.i, PL SQL developer, PowerPlay Transformer 8.x, WinCVS, SVN, Mercury Quality Center, XML Notepad, MS Excel, XML automator and Windows NT.

Confidential, CA

ReportNet Developer

Responsibilities:

• Analyzed the existing Impromptu reports and PowerPlay reports and involved in the process of migrating these reports to ReportNet reports.
• Designed models for reporting and created and published packages in Framework Manager.
• Created standardized reports in Report Studio and ad hoc queries in Query Studio.
• Designed and developed monthly and weekly reports for the end users.
• Created dynamic dashboard reports with cascading prompts and drill throughs to the detailed reports.
• Implemented report level security in the dashboard reports.
• Created Cubes using Cognos PowerPlay Transformer.
• Organized accessed data sources into Transformer Models, Dimensional Maps, and developed power cubes, which can be changed in many ways to ‘Slice and Dice’ and Drill-through data for further multi-dimensional analysis.
• Created list reports, crosstab reports, chart reports and reports with conditional formatting using Report Studio.
• Created reports using tabular models, tabular sets, tabular SQL as tabular data elements.
• Designed drill through reports, master detail reports, and bookmark reports.
• Used HTML items, Hyperlinks, conditional blocks, images, and prompts in reports.
• Implemented bursting of reports based on the territories so that users can see only their reports, which in a way handled security.
• Used Cognos Connection to create and manage data sources, administer Reports as well as the ReportNet Server.
• Created jobs and scheduled the jobs using Schedule Management in Cognos Connection.
• Deployed packages and reports from development environment to test environment and to production environment using deployment manager.
• Maintained the packages and reports in development, test and production environment.

Environment: Cognos ReportNet 1.1 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio) Oracle 9.i, MS Excel, Impromptu 7.1, PowerPlay7.1, Impromptu Burst Reports Application, PowerPlay Burst Reports Application, Excel Merger, Excel Stacker, Excel Formatter, Afaria, Toad 7.1.

Confidential, TX

ReportNet Developer

Responsibilities:

• Interacting with end users to understand the business requirements and report specifications.
• Converted the business requirements into project documentation.
• Involved in building models, packages using Framework Manger and published the packages to ReportNet Server.
• Involved in the process of migrating Business Objects reports to ReportNet reports.
• Used Cognos Connection to administer Reports as well as the ReportNet Server.
• Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Modified packages to suit the business needs and to improve the performance of the reports by defining filters and adding calculations.
• Designed and developed Time Based Reports like YTD, MTD and WTD financial reports for the end users.
• Created list reports, crosstab reports and chart reports using Report Studio.
• Created prompts, calculations, conditions & filters, prompt pages, variables etc. using Report Studio for several Reports.
• Created complex reports using tabular sets, child tabular models (more than one tabular model), drill through reports, master detail reports, book mark reports, conditional prompts.
• Documented all the process changes, requirement changes and code changes.
• Attended weekly meetings to understand and recommend the business solutions.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Scheduled ReportNet reports to run on a monthly, weekly, and daily basis using Cognos Scheduler.

Environment: Cognos ReportNet 1.1 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio) Oracle 9.0, Business Objects.

Confidential, Troy, Michigan

Cognos Developer

Responsibilities:

• Installed and configured Impromptu and PowerPlay Transformer.
• Attended weekly meetings to understand and recommend the business solutions.
• Created Catalogs using data from heterogeneous data sources like oracle tables, flat files.
• Optimized Catalogs using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governor Settings.
• Created Cubes using Cognos PowerPlay Transformer.
• Business intelligence reporting development to design, develop and implement operational reporting and OLAP analysis by using Cognos tools.
• Created user and user classes in Access Manager
• Standard templates were created and multilingual reports were generated using Report Studio.
• Created monthly reports in Impromptu for account processing for each customer, customer group assigned.
• Created zone-wise catalogs for the generation of reports.
• Generated incrementally upgrading cubes from IQD‘s and Power Play Transformer model files.
• Extensively developed and used macros and scheduler for periodical up gradation of cubes.

Environment: Cognos 7.1 Impromptu, Cognos PowerPlay, PowerPlay Transformer, Oracle 8i, MS-Access, Erwin, Access Manager

Confidential

Trainee Software Engineer

Responsibilities:

• Involved in database development by creating Oracle PL/SQL Functions, Stored Procedures, Triggers, and Packages.
• Created various PL/SQL Scripts involving Insert, Sequences, Constraint and Index scripts
• Involved in tuning of stored procedures using query plans and optimizing indexes.
• Used indexes for fine tuning and optimizing SQL and PL/SQL queries.
• Extensively used cursors for processing the data.
• Created views and materialized views for the faster processing of data.
• Handled various errors using exceptions.
• Used Visual Source Safe for version controlling.
• Developed test plans and perform unit tests on developed code.
• Documented business rules, functional and technical designs, test cases, and user guides.
• Deployed the Procedural codes from development to QA and Production environments.

Environment: Oracle 8i, Toad 8.5, SQL Loader, SQL Developer, MS-Access, MS Excel, Unix, Windows NT, Visual Source Safe.