SUMMARY

• Over all 8+ years of Experience of Certified Professional in Business Intelligence
• Excellence with proven ability to drive and implement various methodologies that adhere to the Corporate best practices specialized in Data Warehousing and Business Intelligence.
• Implementation of best practices revolving around design and development of various projects across various industries which includes - Retail, Insurance, medical and Telecom.
• Work directly with business customers to build Business Layer, portals, reports, dashboards with the COGNOS BI authoring suite (Framework Manager, Report Studio and Transformer).
• Worked with Relational & Dimensional Database.
• Requirements gathering and documenting directly from the business users.
• Analyzing the data based on the requirements and implementing the BI best practices.
• Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, cubes.
• Report Formatting by using conditional Formatting.
• Built Segmentation and DMR Model and published thru Framework Manager for HR Team.
• Designed Dynamic cubes for Sales compensation application.
• Performance tuning on cubes.
• Recommend consolidation of reports and data queries as needed.
• Analyze business requests for BI reports and data cubes.
• Assist in development and testing when needed for quick turnaround.
• Set up Data Level and Object Level Security in Framework Manager using macros.
• Manage Cognos metadata, Folder structure and utilize Cognos 10.2 advanced features.
• Responsible for implementing best practices on Cognos Dashboards, Scorecards, Portal, report design, development and testing.
• Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.
• Created Burst Reports in 8.4 based on groups of users &Preferences for our Asian, African and European partners.
• Created Drill Through Reports & Master Detail Reports for Accounts Department.
• Created Active reports with different data decks and data cards.
• Created a custom prompt page by enabling system driven cascade options, dynamic dimension selection and conditional display of prompts.
• Created Work Space Dashboards prototypes for the user to understand the new Cognos 10.2 features and functionalities.
• Created daily, weekly & monthly jobs in Cognos scheduler.

TECHNICAL SKILLS

• Cognos Series 8.x/ 10.1.1/10.2.1
• Framework Manager
• Report Studio
• Query Studio
• Analysis Studio
• Event Studio
• Metrics Studio
• Business Insight
• Workspace
• Workspace Advanced
• Active Reports
• DMR Modelling
• DQM
• Cognos Scheduler
• Business Objects 4.1 (BOBJ)
• IDT
• Oracle
• DB2
• MS-Access
• SQL
• PL/SQL
• Cognos MDL
• Microsoft Project
• Test Director
• Microsoft Office
• Windows
• Unix

PROFESSIONAL EXPERIENCE

Confidential, Secaucus, NJ

Cognos Developer

Responsibilities:

• Gather and analyze the requirements of the users
• Analysis of data necessary to resolve issues uncovered relating to source data
• Participated in design and code walk-through with project team.
• Optimize the Report Studio reports performance.
• Defined, stored and maintained security information using Access manager.
• Develop Framework models in conjunction with the Database Architects.
• Analyze the existing Data sources to the Packages and document them.
• Create a Business view out of the query subjects for Query Studio Users.
• Establish Join relationships between the Query Subjects.
• Create Standard Reports in Report Studio.
• Create the necessary Report Net Reports and schedule them
• Establish a New Join Strategy based on the new business requirements
• Publish Framework Packages to Dev and QA servers.
• Implement Package Security.
• Generate Iqd’s out of Framework Query Subjects.
• Define the Data sources in Cognos.ini file for usage of Iqd generated thru Framework.

Environment: Oracle11g, Cognos Framework Manager, Cognos Report Studio, Cognos Query Studio, Cognos Analysis Studio, Cognos Event Studio, Cognos Metrics Studio, Cognos Transformer, Cognos Power Play, Cognos Access Manager, Cognos Series 10.2.1

Confidential, New York

Cognos Developer

Responsibilities:

• Confidential companies serve commercial, institutional, and individual customers through one of the most extensive worldwide property-casualty networks of any insurer.
• In addition, Confidential companies are leading providers of life insurance and retirement services in the United States.
• Engaged in analysis, troubleshooting, communication, planning, coordination, and documentation activities.
• Research and resolve Cognos technical support problems related to reports, data marts and Cognos server portal access. Provide workarounds and/or solution(s).
• Analyze business requests for BI reports and data cubes. Prepare technical specification documentation and involved in the development of the reports and cubes.
• Prepare BI objects for use with Cognos Go Mobile software. Deliver presentations for appropriate end users with mobile devices and provide support.
• Review existing data design for use in reporting and analysis. Recommend alternatives as needed to improve performance of Cognos reports, data cube refreshes, drill-through reports, etc.
• Develop reports and data cubes to supplement the workload of Cognos development resources and to prepare prototypes when needed to meet new and unusual requirements

Environment: Oracle10g, Cognos Framework Manager, Cognos Report Studio, Cognos Query Studio, Cognos Analysis Studio, Cognos Event Studio, Cognos Metrics Studio, Cognos Transformer, Cognos PowerPlay, Cognos Access Manager, Cognos Series 8.x & 10.x

Confidential, Raritan, NJ

Cognos Developer

Responsibilities:

• Work directly with business customers to build Business Layer, portals, reports, dashboards with the COGNOS BI authoring suite (Framework Manager, Report Studio).
• Worked with Relational & Dimensional Database.
• Requirements gathering and documenting directly from the business users.
• Analyzing the data based on the requirements and implementing the BI best practices.
• Report Formatting by using conditional Formatting.
• Recommend consolidation of reports and data queries as needed.
• Analyze business requests for BI reports and data cubes.
• Manage various projects as assigned by BI Management. Contribute to creation of project plans. Provide periodic updates on status of deliverables.
• Set up Data Level and Object Level Security in Framework Manager using macros.
• Manage Cognos metadata, Folder structure and utilize Cognos 10.1 advanced features.
• Responsible for implementing best practices on Cognos Dashboards, Scorecards, Portal, report design, development and testing.
• Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.1.
• Created Drill Through Reports & Master Detail Reports for Accounts Department.
• Created Active reports with different data decks and data cards.
• Created a custom prompt page by enabling system driven cascade options, dynamic dimension selection and conditional display of prompts.
• Created daily, weekly & monthly jobs in Cognos scheduler.
• Created additional reports on an ad-hoc basis as requested by business users.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists using Cognos connection.

Environment: Cognos 10.1,8.x,Components like DQM,Framework Manager, Report Studio, Query Studio, Analysis Studio, Oracle 10g, TOAD, PL/SQL, Access Manager, SQL .

Confidential

Sr. Reporting tool tech & Geophysicist

Responsibilities:

• Planning &Designing of3D Seismic Survey and acquisition parameter optimizations
• QC of raw navigation and seismic using windows and Linux based processing softwares.
• Processing of 2D/3D land seismic data set using landmark software.
• 2D/3D seismic data multiple attenuation, frequency analysis, pre-migration preparation, velocity model building, and post-stack/migration processing techniques.
• Hands on Experience on Seismic Data Interpretation
• Interpretation of the processed data in Geographix.
• Loading 2D and 3D Seismic Data into workstation.
• Analysis of geophysical data, using geophysical and geological principles.
• Identification of potential hydrocarbon zones, horizon picking, horizon management, identifying bright spots and prospect identification.
• Identification of faults, making fault polygons, plotting, posting and contouring of the same.