SUMMARY

• Over 8 years of experience in IT Industry with experience in Software Administration Analysis, design, testing, development, documentation and implementation of client server applications.
• Cognos 10.X Semantic Layer Design Build, Requirements Workshop Participant Performance Tuning Industry: Cognos for Financials; Cognos for Sales/POS.
• 7+ years of experience with Business Intelligence tools like Cognos 10.x, 8.x, ReportNet, Framework Manager, PowerPlay Transformer with Oracle, Teradata and SQL Server Databases.
• Experienced in developing Dashboards Reports in Cognos.
• Involved in a data migration process between different versions of Cognos.
• Expertise in version upgrades and Migrating Impromptu Catalogs, PowerPlay Cubes, and ReportNet reports into Cognos 8.
• Strong background in building Metadata models using Framework Manager and Dimensional Modeling.
• Extensively worked on developing various kinds of reports in Cognos 8 Report Studio, Analysis Studio and Query Studio.
• Strong experience in business analysis and requirement gathering.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying table level, and data level security.
• Involved in modeling the Data. Expertise in tuning up the database queries.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Involved in all phases of the project life cycle.
• Gathered and documented users' needs for cognos solutions
• Strong experience in business analysis and requirement gathering.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying table level, and data level security.
• Setting up domain groups and assigning access rights to users and groups using the Cognos Server tools linked to standard LDAP.
• Knowledge and understanding of Oracle Database Installation, Configuration, Support, Space management, User management, Backup, Recovery, Oracle Net and Performance Tuning in the development and production database environment.

Confidential Brooklyn, NY September 2009 - Present
Senior Cognos Consultant

• Understanding existing business model and customer requirements.
• Work with project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Developed standard reports and analytics to meet the needs of business analysts.
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Extensive use of master-detail reports using repeater and repeater tables
• Demonstrated the Spec Documents and obtained Sign-off from the Users.
• Involved in designing and creating various projects in Framework Manager.
• Involved in designing Models using Framework Manager.
• Moving applications from one server to other using Deployment Manager
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
• Participated in JAD Sessions provided the session Deliverables to the client for the approval.
• Created complex reports based on business user requirements.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Moved projects from development to QA and then Production servers.

Confidential Las Angeles, CA Jan 2007 - Jun 2009
Senior Cognos Consultant

• Work with back office operations teams, project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Developed complex reports and analytics to meet the needs of business analysts.
• Updated business logic on various reports based on loan officers' feedback
• Fixed numerous production bugs in report studio
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Extensive use of Drill-through reports
• Involved in designing and creating various projects in Framework Manager.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Created multiple Dashboard reports for multiple packages.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Migrated Reports from Cognos 8.2 to 8.3
• Initiated training for the users to do ad-hoc reporting using Query Studio.
• Extensive experience on Structuring Metadata in Models using Framework Manager.
• Provided support for slowly changing dimensions in data marts
• Designed and Prepared a Training Material for the Users.
• Closely Involved in Requirement gathering and Analysis with the customers.
• Created List Reports, Cross tab Reports and Control Charts
• Implemented Security for Data access, Object level access and Package access
• Used Cognos Connection extensively for organizing, scheduling and distributing reports
• Formalized the reporting process by creating the technical specification and requirement specification.

Environment: Oracle 10g, SQL Server 2005, Cognos 8.2-8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection)

Confidential MDOct 2005 - Dec 2006
Senior Cognos Consultant

• Involved in providing both business and technical expertise in the requirements gathering, report design, report development, and support of all client/server layers and components of the data warehouse.
• Designed and developed Framework model to better suit complex report development using Oracle as backend.
• Used Cognos 8 Data Manager supports high performance analysis of relational data by creating aggregate tables at multiple levels within and across hierarchies in the dimension tables
• Involved in creating an ad-hoc query model for query studio users. Created and published various packages to meet different requirements.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
  Worked on Dashboard reports.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Resolved complex problems by performing root cause analysis.
• Built reports with focus on optimization: used indexes on tables and made recommendations for summary tables where needed.
• Used OWB in Cognos 8 platform for data merging, extraction and transformation
• Experience in providing read access to all modeled data in IBM cognos 8 metadata environment
• Responsible for writing various documentations like technical specifications document, report specifications document and user manual.

Environment: Cognos 8 BI (Framework Manager, Report Studio, Query Studio, Analysis studio, Event Studio, Cognos Connection), Data stage, Teradata, Oracle 9i, Windows NT, UNIX.

Confidential, Bloomington, ILJan 2004 - Aug 2005
Cognos / ReportNet Consultant
Confidential is the US leading insurance and financial services organization. The primary concern of State Farm was data integration within the Cognos Enterprise Business Intelligence solution. The scope of this project was complete enterprise reporting coverage.

Roles and Responsibility:

• Created and maintained catalogs for group of reports in the project.
• Assigned various types of securities like table securities, row securities and column security using Governor Settings.
• Created user profiles and user privileges.
• Customized data by adding calculations and summaries by querying different database tables.
• Created standard and Ad hoc reports using Cognos Impromptu tool.
• Created List Reports, Group Reports and Cross Tab Reports with Drill Through and Drill Down functionalities.
• Created reports in HTML format for easy navigation of data from web browser.
• Created Cubes using Power Play and Transformer for multidimensional reports.
• Worked with PowerPlay time dimension analytical reports using Date Wizard.
• Created calculated fields in Transformer for the analytical data.
• Customized PowerPlay reports using drill through charts.
• Worked with Transformer creating manual levels dimensions and sub dimensions.

Environment: Cognos Power Play 7.3, Cognos Impromptu 7.3, Transformer 7.3 , Oracle 8i, SQL Server 2000.