SUMMARY:

• Over 8+years of IT experience with expertise in Analysis, Design, Development, Customization and Implementation of various Software applications and generation of reports using Various Databases
• 7+ years of professional experience involving in Databases (OLTP), Data warehouses (OLAP) and Business Intelligence on multiple environments and wide range of industries.
• Experience in IBM Cognos10 BI (Query Studio, Analysis Studio, Report Studio, Metric Studio, Event Studio,BusinessInsight,BusinessInsight Advanced) and Framework Manager
• Experience in IBM Cognos8 BI (Query Studio, Analysis Studio, Report Studio, Metric Studio, Event Studio) and Framework Manager
• Experience in Report Net with Framework Manager, Report Studio, Query Studio and Cognos Connection
• Working knowledge of designing multidimensional architecture for Extract, Transform, Load environment with Informatica(ETL)
• Experience with Transformer and power play reports.
• Experience in developing applications using Oracle 9.x/8.x/7.x, Forms, Reports, SQL * Loader, SQL, PL/SQL, SQL Server 5.x/ 6.x/ 2000,Db2, Teradata and MS Access
• Excellent Communication, Interpersonal and Organizational skills
• Good team player with excellent communication skills, analytical and learning new technologies

TECHNICAL SKILLS:

BI Tools: IBM Cognos BI(10), IBM Cognos BI(8.X), Cognos Report Net 1.0/1.1 MR2, Cognos Impromptu 7.x/6.x, Transformer, Power play 7.x/6.0, Access Manager

Databases: Oracle 8i/9i/10g/11i, IBM DB2, MS SQL Server 2000/2005/2008, TeraData

Database Tools: Toad, SQL Server Management Studio, SQL*Plus, SQL*Loader.

ETL Tools: Informatica Power Center/Power Mart 8.x/9.x.

Programming Languages: SQL, PL/SQL, C, C++ and Java

Operating System: Windows NT/XP/2000/98, MS DOS, Unix, Linux

Other Tools: Crystal Reports, Business Objects, Erwin.

PROFESSIONAL EXPERIENCE:

Confidential - Dallas, TX

Sr.Cognos Consultant

Responsibilities:

• Worked with Business users to analyze and understand business requirements
• Developed prototype solutions based on initial business requirements and partner with clients to validate functional and reporting requirements
• Developed the Model and Packages using Framework Manager
• Analyzed and defined joins to build the Framework Manager models and packages
• Developed various report like List, cross tab, drill through, chart and complex reports which involved Multiple Prompts, conditional formatting, Filters, multi - page, multi-query reports.
• Created different Standard reports using prompts, filters, query calculations, cascading prompts and conditional Formatting of measures using variables in Report Studio
• Created Drill-Through Reports, Chart Drill-Through Reports to provide users with more detailed information
• Created various Chart type reports by using Conditional palette.
• Used HTML scripts in Cognos reports for formatting and user based requirements.
• Developed Dashboard Reports using Business Insight.
• Designed Dashboards using Portal pages.
• Used the Scheduling Management option in the Cognos connection to schedule the reports.
• Involved in unit testing, maintained documentation and provided user .

Environment: IBMCognos10, Business Insight, Business Insight Advanced, Report studio, Query Studio, Analysis studio, Event Studio, Frame work manager, Teradata, Teradata

SQLAssistant.

Confidential, Dallas, TX

Responsibilities:

• Worked closely with client resources to analyze and understand business requirements
• Developed technical specifications, data identification and also recommendations on the preferred solution for development, and deploy efficient BI solutions
• Worked on Cognos tools like Framework Manager, Report Studio, Analysis Studio, Event Studio
• Worked on Standard Reports in Report Studio and Ad-hoc reports in Query Studio for query users
• Used the Scheduling Management option in the Cognos connection to schedule the reports. And scheduled to run the reports on a monthly, weekly, and daily basis.
• Created the Events by using Event studio.
• Involved in the analysis, design, develop various reports types-List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, conditional formatting, Filters, multi - page, multi-query reports.
• Developed reports using IBM Cognos 10 version.
• Involved in unit testing, and migration from the development to production

Environment: Cognos10, 8.4, 8.2, Report studio, Query Studio, Analysis studio, Event Studio, Frame work manager, Oracle, PLSQL Developer

Confidential, Dallas, TX

Cognos Consultant

Responsibilities:

• Worked on Standard Reports in Report Studio and Ad-hoc reports in Query Studio for query users.
• Involved in migrating Cognos 8.4 to Cognos 10.1.
• Migrated nearly 180 reports (WAMU, EMC) from Cognos 8.4 to Cognos 10.1
• Involved in the analysis, design, develop various reports types-List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, conditional formatting, Filters, multi - page, multi-query reports.
• Worked on Cognos tools like Framework Manager, Report Studio, Analysis Studio
• Created filters, prompts, and complex business calculations in Report Studio
• Created Joins between the Query Subjects in Report Studio
• Expertise with creating page breaks, conditional formatting, drill-thru, and master/detail reports
• Used HTML and Java Script for customizing the reports.
• Used the Scheduling Management option in the Cognos connection to schedule the reports. And scheduled to run the reports on a monthly, weekly, and daily basis.
• Worked on multi dimensional Cube Reports
• Involved in unit testing, and migration from the development to production

Environment: Cognos 10, 8.4, 8.2, Report studio, Query Studio, Analysis studio, Business Insight, Frame work manager, Oracle 10g, Oracle 11i, SQL Server 2005, Toad and HP UNIX.

Confidential -Dallas, TX

Cognos Consultant

Responsibilities:

• Involved in the analysis, requirements gathering, specifications, and development
• Developed technical specifications, data identification
• Imported Metadata from various source databases to Cognos Report Net Framework Manager.
• Created and maintained Framework Manager Models, packages Cognos report net reports.
• Implemented, data level security, object level security and package level security using the Frame work manager
• Analyzed and defined joins to build the Framework Manager Models and packages with Query Subjects and Query items.
• Published packages from Report Net Framework Manager to Cognos Connection server.
• Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio
• Worked on Standard Reports in Report Studio and Ad-hoc reports in Query Studio for query users.
• Involved in the analysis, design, develop various reports types-List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, conditional formatting, Filters, multi - page, multi-query reports.
• Worked with Tabular model, Tabular Sets, Tabular SQL and creating page breaks
• Involved in unit testing, and migration from the development to production
• Developed reports with Cognos 8 using report studio.

Environment: Cognos8.x (Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos configuration), Toad, Teradata SQL Assistance and Windows.

Confidential -NYC, NY

Cognos Consultant

Responsibilities:

• Participated in discussions with the Business Management to better understand the Business Process.
• Interacted with the users for understanding and gathering business requirements
• Involved in all the phases, which include requirement-gathering, design, development
• Developed technical specifications, data identification
• Imported Metadata from various source databases to Cognos Report Net Framework Manager.
• Built the Frame Work Manager models and packages.
• Implemented, data level security, object level security and package level security using the Frame work manager
• Analyzed and defined joins to build the Framework Manager models and packages
• Published packages from Report Net Framework Manager to Cognos Connection server.
• Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio
• Involved in the analysis, design, develop various reports types-List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, conditional formatting, Filters, multi - page, multi-query reports.
• Worked with Tabular model, Tabular Sets, Tabular SQL and creating page breaks
• Created catalogs using Impromptu Administration.
• Built the Transformer model and created Power Cubes using the Power Play Transformer
• Developed Power Play reports using Power Play for Windows application.
• Involved in unit testing, and migration from the development to production

Environment: Cognos 8.x (Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos configuration), Reportnet1.1 (Framework Manager, Report Studio, Query Studio), Impromptu, Power Play Transformer, Power Play, DB2, Oracle, TOAD, Windows.

Confidential - Dallas, TX

Cognos Consultant

Responsibilities:

• Worked closely with client resources to analyze and understand business requirements
• Developed technical specifications, data identification and also recommendations on the preferred solution for development, and deploy efficient BI solutions
• Analyzed the functional requirement for model and report generation
• Developed number of prototypes for the business users. This EDW project was bases of star schema with DB2 database. Involved in multiple phases, which included requirement gathering, design, and development and unit testing
• Created and maintained Framework Manager Models, Cognos Report net Reports, and involved in creating content store, data sources and configured with web server
• Involved in creating model level, report level security, administration, and deployment (exports and imports).
• Analyzed and defined joins to build the Framework Manager models and packages with Query Subjects and Query Items
• Published packages from ReportNet Framework Manager to Cognos connection server.
• Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio.
• Involved in the analysis, design, develop various reports types
• Created reports using Cognos 8 with Report Studio
• Worked on Standard Reports in Report Studio and ad hoc reports in Query Studio for query users
• Worked on creating and analyzing the complex reports like Cross tab, drill-thru reports, Tabular model, Tabular Sets, Tabular SQL, conditional formatting, Prompts, filters, and calculations
• Expertise with creating page breaks, conditional formatting, drill-thru, and master/detail reports
• Expertise with writing SQL queries for report testing.
• Involved in unit testing, migration from development server to production server, expertise with creating multi page reports and graphical reports.

Environment: Cognos Report Net 1.x (Framework Manager, Cognos Connection, Cognos Configuration, Report Studio and Query Studio), Cognos 8(Query Studio, Report Studio), Power Play Transformer, Power Play, and Teradata SQl Assistant, DB2

Confidential

Cognos Developer

Responsibilities:

• Participated in discussions with the senior management to better understand the business requirements
• Analysis and requirements gathering from existing business.
• Designed, Developed and Implemented an Enterprise Wide Reporting system using Cognos Report Net
• Imported metadata from various sources such as Relational Databases, XML Sources, Report Net models, Impromptu Catalogs and Architect models into the Framework Manager
• Created different types of ad hoc reports using Query Studio
• Created different types of standard reports using Report Studio
• Optimized the report performance and the response time
• Developed drill through reports to provide attention to details and analyze the business data
• Improved the usability of the reports by using filters and calculation
• Used Cognos Connection extensively to administer Reports as well as the Report Net Server
• Extensively used Cognos Impromptu & Cognos Power Play in accessing the data from data marts
• Used Access Manager to provide security to the Cognos applications
• Created the Power cubes from the Transformer
• Published Impromptu, Power Play reports on the web using Upfront
• Time scheduled the report publishing using the scheduler

Environment: Cognos ReportNet (FrameWork Manager, Query Studio, Report Studio), CognosEP Series 7.0 (Impromptu, Power Play, Impromptu Web Reports (IWR), Upfront, Transformer, Access Manager), SQIServer and Oracle

Confidential

Cognos Consultant

Responsibilities:

• Interacted with the users for understanding and gathering business requirements
• Involved in the analysis, design, develop, testing, deployment and user of analytical &transactional reporting system
• Involved in design and development of user classes, filters, calculations, prompts and conditions in Catalog and query definition files in Impromptu Administrator
• Optimizing by assign relative Weights to the tables in the Catalog and Query Performance (in Governor's settings)
• Discussed business requirements and mapped business needs using Cognos Transformer
• Created various reports, Power Play Cubes which can be changed in many ways to ‘Slice and Dice’ and drill-through facility for further multi dimensional analysis and graphs from multiple data sources
• Involved in Data Warehousing - Star Schema Design.
• Successfully developed and implemented Metrics using Cognos Impromptu, Power Play
• Developed Visualizer Charts to make better decisions
• Created Architect models for business requirements including Joins, Prompts, and Filters.
• Used Cognos Query for ad hoc Reports and Users design Custom Queries on the Web.
• Scheduled Cubes building and other tasks using Cronacle of Redwood Tool
• Installing, Configuring and Performance Tuning Cognos EP Series as Business Intelligence
• Involved in Report Administration & Server Administration
• Involved in Model, Reports design and develop using Cognos ReportNet

Environment: COGNOS EP Series 7.x (Impromptu Administrator, Impromptu Web Reports Power Play, Transformer, Power Play Enterprise Server, Access Manager, ServerAmdministrator, Upront (for Web), Cognos ReportNet v1.x (Framework Manager, Report Studio, Query Studio), HTML, XML, Netscape Directory Server, Oracle 8i/9i, MS Access, SQL, PL SQL, Toad, and Window

Confidential

Cognos Report Writer

Responsibilities:

• Extensive interaction with Business Users and gather information and requirements
• Developed and created classes with Dimension & Measure Objects and specified the hierarchies
• Worked extensively on Oracle database. Troubleshoot for SQL issues/performance issues
• Installed and configured Cognos Power Play and Impromptu software
• Participated in the development of catalogs, multiple queries with complicated reports and query definition files using various join and filter conditions in Impromptu
• Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through and
• Detail reports, catalogs, folders filters, prompts, calculated columns and conditions for multi dimensional analysis
• Defined, and created Impromptu web reports using Distribution Shuttle Builder and
• Published on IWR Server
• Worked extensively with Power Play Enterprise Server and the Upfront in publishing the cube
• Automating tasks with Cognos Scheduler using Macros, Cognos Script Editor and Cognos Script Dialog Editor
• Created Snapshots to minimize data processing when the network traffic for the database is heavy
• Optimized Catalog by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors Settings

Environment: Cognos Impromptu 6.06, Cognos Power Play 6.6, Cognos TransformerCognos Impromptu Web Reports, Cognos Power Play Enterprise Server, Access Manager, Cognos Upfront, SQL *Loader, Oracle 9.0, Windows NT/2000