SUMMARY

• Over 8 years of IT experience with IBM Cognos Business Intelligence tools; including Report Studio, Query Studio, Analysis Studio, WorkSpace, Workspace Advanced, Framework Manager, Transformer and cube.
• Expertise in Framework Manager Modelling (Relational and Dimension), setting security, crate and publish packages.
• Having great experience of make reports and FM modelling specification ready for the new development.
• Good experience in creating complex reports using Report Studio, Query Studio, Analysis Studio, and Workspace Advanced.
• Experience in Transformer model design and power cube building.
• Hands on Experience with SQL, PL/SQL, Oracle, and DB2.
• Excellent experience in supporting Oracle EBS suite.
• Experience with IBM Cognos Business Intelligence series 7.0/8 /10.
• General Knowledge of data warehousing, data marts, Visualization, and Reporting Applications.
• Experience in interacting with endusers to gatherrequirements.
• Doing demo, provide hands on training and make documentation to available to business users.
• Great team player with great analytical, problem solving, and communication skills.

TECHNICAL SKILLS

COGNOS BI: Cognos connection, Framework Manger, Analysis Studio, Report Studio, Query Studio, Content Administration, Workspace, Workspace Advanced

OPERATING SYSTEMS: Windows OS based Environment

LANGUAGES: SQL, PL/SQL, Java Scripts

DATABASES: SQL Server 2000/2005/2008/2012 , Oracle 9i/10g/11g, DB2

TOOLS: & UTILITIES: Toad, Raid SQL, SQL, Data warehouse

PROFESSIONAL EXPERIENCE

Confidential, Woodlawn, MD

Sr.Cognos Developer

Responsibilities:

• Developed new complex reports such as List, Crosstab, Drill - through, Drill-up and down, Master-Detail, Chart, and Active reports utilizing Report Studio.
• Fixed defects andtrouble shoot issues with current existing reports.
• Per client need, gathered requirements, designed, developed, and deployed reports into the production environment for business users.
• Performed unit and performance test, test data, and provide data accuracy results of deployed reports.
• Provided documentation of the Cognos reporting architecture, test cases and associated solutions.
• Doing demo and provide overview of new developed reports. If required than provides hands on training and documentation to new users.
• Developed a data flow diagram to accurately reflect the clients reporting environment.
• Created report specifications for new report development.
• Worked in framework manager to create models using different data sources and publishing packages to Cognos connections as per reporting requirements.
• Applied object level, data level and package level security in the Framework manager.
• Managing onsite and outsource team in daily base operation and update status.

Environment: Cognos 10.2 BI (Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos Connection) DB2

Confidential, Jersey City, NJ

Cognos Developer

Responsibilities:

• Actively interacted with business analysts and developer reports based on the requirement; Created List Reports, Crosstab Reports, Master detail, Drill Down/Drill Up and Drill through Reports, Active Reports using Report Studio.
• Created calculations, filters, cascading prompts and conditional formatting in order to retrieve specific data sets.
• Performed full fledge Unit testing for all developed reports.
• Actively involved in fixing issues, and defects in the reports, and FM Models.
• Implemented appropriate joins and cardinalities to reduce data redundancy.
• Defined-Attributes mappings prior to building the Framework Manager Model; reducing development timelines.
• Developed Models, Created Packages from Framework Manager.
• Applied Data level security, Object level security prior to Publishing packages to Cognos Connection.
• Involved in Designing DMRmodels with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Designed & developed the reports using Cognos 10.2 Report Studio, Query Studio, Analysis Studioreports.
• Extensively worked on Analysis Studio to develop multi-dimensional reporting.

Environment: Cognos 10.2 BI (Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos Connection) DB2

Confidential, Jersey City, NJ

Cognos Developer

Responsibilities:

• Created List Reports, Crosstab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Gathered and analyzed business requirements from business users.
• Organized, applied security, Scheduled and Distributed reports via Cognos Connection.
• Developed reports using prompts, filters, query calculations, cascading prompts and conditional formatting using Report Studio.
• Metadata Modeling using Framework Manager; created relational and dimensional models, query subjects, filters and packages.
• Applied Data level security, Object level security prior to Publishing packages to Cognos Connection.
• Developed complex reports using drill-through and Master Detail functionalities in Report Studio.
• Actively involved in fixing issues, and defects in the reports, FM Models, or any environment related items.

Environment: Cognos 10 BI (Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos Connection) DB2

Confidential, Manhattan, NY

Cognos Developer

Responsibilities:

• Developed reports in various Formats including List, Crosstab, Charts, Drill-Thru and ext.
• Created Executive dashboards to reflect various retail KPIs based on Region, Countries, allowing management to drill down to individual retail store level.
• Actively participated in gathering requirements from Business users for Report development.
• Created Technical documentations such as report specifications, wireframes, and knowledge transaction documents.
• Applied Cognos Software Development Life Cycle methodologies by gathering requirements, designing and developing solutions, Unit Testing, Providing QA and UAT support, deploying solutions to Production, and monitoring and fine turning implemented reports and solutions in Production.
• Used Cognos Connection for organizing reports, setting security, scheduling and distribution of reports, and crated jobs.
• Developed Complex reports by various methods of applying prompts, conditional filters, and calculations, and aggregations.
• Created Packages to support adhoc reporting requirements, applied model level filters, prompts, calculations, and metrics.

Environment: Cognos 10/Cognos 8.4 BI (Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos Connection), DB2, Teradata SQL

Confidential, New York, NY

Cognos Developer

Responsibilities:

• Gathered and documented business requirements for solution implementation.
• Developed various reports using Report Studio and Query Studio.
• Created SQL based Query Subjects, Stored Procedure based Query Subjects, and Model based Query Subjects in Cognos framework manager, and published packages.
• Designed & developed List, Cross tab, Drill through, and Master Detail reports per requirement for daily, weekly and monthly usage of reports.
• Imported Users, Created Groups and Assigned Roles by performing various administrative tasks.
• Created unions, applied master-detail functionality, drill-through functionality, prompts, calculations, Pixie perfect formatting, conditional formatting, Crosstabs, multi query reports, chart reports.
• Applied various reporting methodologies, eliminating redundant development efforts.

Environment: Cognos 10/Cognos 8.4 BI (Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos connection), DB2, Raid SQL, SQL 2008

Confidential, Newark, NJ

Cognos Developer

Responsibilities:

• Using Transformer creates and published cube.
• Gathered and documented business requirements for solution implementation.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Fixing issues and defects in the Cognos reports, Framework Models, or any environment related items.
• Imported Users, Created Groups and Assigned Roles by performing various administrative tasks.
• Created unions, applied master-detail functionality, drill-through functionality, prompts, calculations, Pixie perfect formatting, conditional formatting, Crosstabs, multi query reports, chart reports.
• Applied various reporting methodologies, eliminating redundant development efforts.
• Involve in deployment process, add and remove users and provide them access by using Active directory.

Environment: Cognos 10/Cognos 8.4 BI (Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos connection), DB2, Raid SQL, SQL 2008

Confidential, Houston, TX

Cognos Developer

Responsibilities:

• Developed List, Crosstab, Drill-through, and Master Detail reports per requirement.
• Created calculations, filters, cascading prompts and conditional formatting in order to retrieve specific data sets.
• Created reports allowing QA to successfully test integrity and quality of data sets.
• Developed models with query subjects, query items, and imported metadata including store procedure in different views to facilitate power users.
• Implemented appropriate joins and cardinalities to reduce data redundancy.
• Defined-Attributes mappings prior to building the Framework Manager Model; reducing development timelines.
• Actively worked with Business Analysts and Database Administrators to resolve various data related issues; including rapid data adjustments, database related change such as table structure changes.
• Successfully Migrated reports from Cognos 8.4 reports to Cognos 10.
• Applied three tier approach when building Cognos Framework Manager Model; allowing reusability of Packages and empowering end user to utilize Cognos Query Studio.

Environment: Cognos 10/Cognos 8.4 BI (Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos connection

Confidential, Bridgewater, NJ

Cognos Developer

Responsibilities:

• Created List Reports, Cross-tab Reports, Charts, Drill through Reports, and Master Detail Reports Using Report Studio; applied specific report formats to standardize report across organization.
• Crated Functional Specification Documents (FSD) ensuring it reflected all necessary requirements from Business Requirement Documents (BED).
• Developed Models, Created Packages from Framework Manager.
• Expanded end user delivery with new technical approaches including bursting of reports, applied JavaScript, created Cascading prompts, Macros and Parameter maps.
• Designed & developed the reports for daily, weekly and monthly usage.
• Involved in the migration of reports from Business Object to Cognos 8.4.
• Analyzed, designed, developed and deployed BI Solutions via Cognos 8.4 reporting system using best practices.

Environment: Cognos 8.4 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Access Manager, Cognos Connection) Oracle 9i/10g, MS SQL Server 2008, Windows 2000 Server

Confidential, Farmville, NC

Cognos Developer

Responsibilities:

• Actively interacted with business analysts and developed reports based on the requirement; Created List Reports, Cross Tab Reports and Drill Down/Drill Up and, Drill through Reports using ReportNet.
• Customized reports data by adding Filters Calculations, Summary level calculations and other Functionalities.
• Developed List, Cross Tab, Charts, Drill Through Reports, Master Detail Reports.
• Created catalog, standard filters, calculations, prompts, conditions.
• Performed full fledge Unit testing for all developed reports.
• Worked with Business Analysts and End Users in order to design and develop various types of report; educated the End Users on implementation of new process or change in the processes.

Environment: COGNOS 7/8, Impromptu, Powerplay, Access Manager, JavaScripts, MS Access, Microsoft Vision, MS Project, MS SQL Server 2000

Confidential, Louisville, KY

Cognos Developer

Responsibilities:

• Created filter, calculations, prompts, conditions in Catalog, and query definition filters in Impromptu Administrator.
• Created Catalog in Impromptu Administrator.
• Generated reports by using Cognos Impromptu tools.
• Created list reports and crosstab reports and drill through reports.
• Used Power Play Enterprise Server to publish the cubes.
• Updated Impromptu Catalog by adding tables and creating new joints.

Environment: COGNOS (Impromptu Administrator, Impromptu Web Reports Power Play, Transformer, Power Play Enterprise Server, Access Manager, Server Administrator, Upfront (for Web), Power Builder, Windows 2000 Server