SUMMARY

• Around 10 Years of experience in IT includes extensive Functional and Technical experience in, Data Modeling, Business Intelligence (BI) product development and Reports Generation.
• Expert in Business Intelligence Applications using Cognos Tools such as Cognos 8BI, Report Net (Framework manager, report studio, query studio and Analysis studio)
• Expert in installation, configuration of Cognos BI version 8.4
• Worked on Framework Manager, Analysis Studio, Query Studio and Report Studio for Model and Report design in Cognos BI version 8.4
• Expertise in Insurance Claims Reporting, Property Insurance Reporting and Health insurance reporting
• Involved in gathering of business requirements Documented them technically with all phases of SDLC life cycle
• Translate business requirements into technical specifications
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad - hoc reporting and advanced report authoring
• Experience in List, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multiple queries, DMR Models
• Good understanding of Power Play Transformer and client to design models and analyze teh Power Cubes
• Experience on OLAP cubes, relational and multi-dimensional Data models
• Hands-on experience in implementing Data warehousing methodologies including STAR SCHEMAS and SNOW-FLAKE SCHEMAS for huge data warehouses
• Power Play Enterprise Server and Report Net Server
• Exposure to client interaction and user-requirement analysis
• Experienced with migration of Cognos code (reports/models/ frameworks) from one environment to another
• Good understanding of data warehousing and ETL (Extraction, Transformation and Loading) tools like Informatica, including good knowledge of dimensional modeling
• Mentored and trained users for teh successful execution of teh project
• Involved in designing of Relational and Multidimensional databases
• Good understanding of business process especially in teh Financial and Insurance areas
• Team player with good interpersonal and communication skills and teh ability to work in a team environment
• Expertise on Financial, Pharmaceutical, Telecom and Health care Domains

TECHNICAL SKILLS

BI Tools: COGNOS 8BI Framework Manager, Report Studio, Metric Studio. Event Studio, Analysis Studio REPORT NET 1.1(MR1/MR2/MR3) COGNOS connection, Framework Manager, Query studio, Report studio, Management Tools, Server Administration Tools, Configuration Manager, Scheduler. COGNOS Power Play Transformer, Power Play User, Power Play Web Reports, Power Play Enterprise server, Upfront Administration, Access Manager, LDAP Server, OLAP cubes, STAR SCHEMAS and SNOW-FLAKE SCHEMAS

Operating Systems: Windows 95/98, Windows NT 4.0, Windows 2000/XP.

Languages: SQL, PL/SQL, MDX, HTML, XML, XHTML

Databases: Oracle 10g/9i, SQL Server 7/2000/2003, DB2, and Microsoft Sql Service.

Software Packages: MS-Office 2003, Microsoft Word, Excel and Power Point.

PROFESSIONAL EXPERIENCE

Confidential, VA

Cognos Developer

Responsibilities:

• Developing rapid-prototype or proof-of-concept reporting solutions and demonstrating those solutions to customers; dis will require teh Senior Developer to be familiar with all capabilities of teh IBM Cognos product suite.
• Develop report in report studio and performed Report bursting
• Developed Active reports for IPAD
• Scheduling teh reports
• Working with IBM Cognos Mobile which support Apple’s iphones’ and iPads as well as Blackberries
• Support teh full report development life cycle, including:
• Working with internal stakeholders to gather and document business analytics requirements including: data, layout, and delivery requirements.
• Creating data modeling solutions to support business analytics requirements.
• Building dashboard-style reports combining list, cross-tabular, and chart displays to give executives an "at-a-glance" look at teh results of teh company.
• Documenting teh design of reports and tracing teh design solution to teh initial requirement.
• Building and maintaining Cognos Metrics Models and Metrics Reports
• Installing/configuring IBM Cognos products; using Cognos Configuration and Cognos Administration to set up a fully functional instance of teh Cognos BI platform
• Administering Cognos Content using Cognos Administration including applying enterprise security to Cognos Content by utilizing teh enterprise authentication provider (Active Directory)
• Troubleshoot report development issues by querying teh report source data directly using Enterprise database tools.
• Facilitate Technical exchanges between IT groups to ensure delivery of high quality work products.

Environment: - Cognos 10 & 8BI, Cognos Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, SQL,XML and Windows XP

Confidential, Charlotte, NC

Cognos Developer 8.4

Responsibilities:

• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports
• Generated Complex reports in Cognos 8.4 report studio including Drill Down reports from DMR modeled Frame work model
• Created Dashboards to present critical company data in a single report
• Created list reports & cross tab reports using Cognos 8.4
• Upgraded reports from 8.2 to 8.4
• Used IIS(Internet information server) web server for configuration and management
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.4
• Manually modified teh SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio
• Experience in developing Framework Manager Models and analyzed those models in analysis studio
• Gathered and analyzed business requirements from users and business community
• Analyzing existing transactional database schemas and designing star schema models to support teh users reporting needs and requirements
• Created Sophisticated Reports using Report Studio
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports
• Developed Complex Crosstab reports in Analysis studio
• Extensively worked with List Reports and various formats of report generation e.g., PDF, XML etc
• Monitoring Cube updates, monitoring teh performance of teh Power Play cubes, Star Schema, Snow Flaks Schemas
• Created 3 different reports dat included report functionality such as prompt pages, cascading prompts, conditional filters, Power Play cubes etc

Environment: - Cognos 8BI,Cognos Connection,Cognos office Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, SQL,XML and Windows XP,Cubes.

Confidential, Philadelphia PA

Cognos 8.3, 8.4 BI Developer

Responsibilities:

• Generated Complex reports in Cognos 8.4 report studio including Drill through reports.
• Gathered and analyzed business requirements from users and business community.
• Developed UML Diagram following all phases of SDLC.
• Tested teh created reports by executing teh Test Scripts
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3
• Upgraded reports from 8.3 to 8.4.
• Created Cash Product Dashboard reports to present critical company data in a single report using cognos 8 metric studios.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Used IIS (Internet information server) web server for configuration and management.
• Used Conditional blocks and conditional variables for generation of reports.
• Manually modified teh SQL in Report Studio to tune and/or to write reports.
• Experience in developing Framework Manager models both Relational and Dimensional (DMR modeling)
• Analyzing existing transactional database schemas and designing star schema models to support teh users reporting needs and requirements.
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in teh already existing reports in teh Production.
• Performed BI Content Administration tasks including scheduling and content management

Environment: - Cognos 8.3BI, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, ORACLE, .net, SQL,PL SQL, weblogic,HTML and UNIX, Internet Information Service, Microsoft SQL services.

Confidential, Chicago, Illinois

Cognos 8.2 BI Developer

Responsibilities:

• Used Framework Manager to create models, packages and publish packages to teh cognos 8 Server.
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3.
• Upgrading of reports from series 7.1 to series 7.3
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in teh already existing reports in teh Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Developed SQL Driven reports.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments(development, testing and production)
• Deployed teh reports from development to testing and from q/a to prod through deployment tool.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various portals involving Cognos 8 port lets.
• Administer user access protocols and created user accounts and access privileges

Environment: - Cognos 8BI,Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, Oracle 10g, SQL, Scheduler, XML and Windows NT/4.0

Confidential, Bethlehem, PA

Cognos 8BI Developer

Responsibilities:

• Gathered and analyzed business requirements from users and business community.
• Used test director for Requirements Management, Test Plan, Test Lab, and Defects Management.
• Experience in developing Framework Manager Models using dimensions (DMR modeling) and analyzed those models in analysis studio.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Supported Business Users in generating Adhoc Reports using Query Studio.
• Created filters, prompts, sub reports, provide drill through capabilities.
• Develop and execute unit test plans
• Performed BI Content Administration tasks including scheduling and content management
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments(development, testing and production)
• Created Sophisticated Reports using Cognos 8 BI Report Studio.
• Worked on Star Schema Database Design.
• Responsible for creating users, groups and roles to manage security.

Environment: - Cognos 8BI,Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Event studio, Frame Work Manager, Oracle 10g,Oracle 9i, SQL, Scheduler, XML and Windows NT/4.0

Confidential, Milwaukee, WI

Report net Developer

Responsibilities:

• Migration of reports and catalogs from Cognos series 7.1 to Report net series 1.1 MR1.
• Development of filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio.
• Worked extensively in report studio of Report net.
• Security setting by adding users and groups in access manager and assigning roles to them.
• Setting up permissions to users on using report studio and query studio.
• Installing framework manager to Cognos 8 power users and enabling them to access packages.
• Setting up different environments (development, testing and production) in client.
• Deploying reports from one environment to other..
• Development of ad-hoc reporting interfaces using Cognos Query Studio.
• Responsible for teh delivery of solution-oriented complex reports using Cognos Report Studio.
• Distributed Reports to several Insurance Agents by Bursting.
• Migrated Reports from series 7.0 to Report net.
• Troubleshooting various existing Report Net Reports dat had several issues.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.

Environment: Reportnet,Cognos Connection, Report Studio, Query Studio, Frame Work Manager, Oracle 10g,Oracle 9i, SQL, Scheduler and Windows NT/4.0

Confidential, Warren, MI

Report net Developer

Responsibilities:

• Designed, Developed and Implemented Enterprise Wide Reporting system using Cognos Report Net
• Used Framework Manager to create models, packages and publish packages to teh Report Net Server
• Involved with administration of IWR Server, Power Play Enterprise Server and Report Net Server.
• Involved in installation, configuration and upgrade of COGNOS Report Net 1.1 MR3.
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata
• Used Cognos Connection extensively to administer Reports as well as teh Report Net Server. Planned and Created professional reports in Report Studio and ad hoc reports in Query Studio
• Migrated Impromptu/IWR reports to Report Net using migratetocrn command and deployed migrated reports to Report Net using deploytocrn command.
• Generating various List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports. Created calculations, filters, prompts and session parameters used by report authors
• Created Dashboards to present critical company data in a single report.
• Manually modified teh SQL in Report Studio to tune and/or to write complicated reports. Used subsets to write union/subtract queries in Report Studio
• Installed and configured all teh Report Net Components - Content Store, IIS, Report Net Servers dat suit teh client environment
• Installed and configured various components, such as teh Framework Manager and Content Manager
• Configured Report Net to use teh Cognos Series 7 namespace to render Series 7 entries in Cognos Connection
• Responsible for creating users, groups and roles to manage security
• Deployed packages, folders, Reports and content store from a development environment to test and then to production environments.
• Trained business users to develop/use reports using Report Studio/Query Studio.
• Developed various dimensions, measures and calculations in Cognos Transformer.
• Imported power cubes to Report Net Cognos Connection.
• Created Power Play models using Transformer by developing various dimensions, measures and calculations in Cognos Transformer.
• Scheduled Power Play cubes to run on a monthly, weekly and daily basis using Windows Scheduler.
• Tuned teh performance of teh Cognos BI 8 for quick runtime of reports
• Tuned teh performance of Cognos Servers for better response and decreased run time of reports.

Environment: Report Net 1.1 MR2, Cognos 8BI, Cognos Connection, Report Studio, Query Studio, Frame Work Manager, Cognos Impromptu 7.3, XML, Oracle 10g,Oracle 9i, MS-Access, SQL, Cognos Power Play 7.3, Upfront, IWR, Scheduler and Windows NT/4.0, PeopleSoft HRMS

Confidential, Abbott Park, IL

Responsibilities:

• Created Packages and Folders in Framework Manager1.1 and published them to Cognos Connection.
• Gathered and analyzed business requirements from users and business community.
• Analyzing existing transactional database schemas and designing star schema models to support teh users reporting needs and requirements.
• Created Sophisticated Reports using Report Studio 1.1
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Supported Business Users in generating AdHoc Reports using Query Studio1.1.
• Catalogs were Optimized by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors Settings.
• Created filters, prompts, sub reports, provide drill through capabilities
• Creating User Classes and Restricting teh user access with teh halp of User Class Privileges in teh Governor settings.
• Worked on Star Schema Database Design.

Environment: Cognos Report Net 1.1MR2, Cognos Connection, Report Studio, Framework Manager1.1 MR2, Cognos Impromptu 7.1 MR3, Cognos Access Manager, Cognos Scheduler, SQL, PL/SQL, Oracle 8i, Windows XP.