SUMMARY:

• I’m a Senior Business Analyst with 9 years’ experience in Cognos Business Intelligence and Data Warehousing environment developer.
• I’m profound experience in Business Intelligence tool Cognos, and is proficient in designing and developing customized BI solutions.
• I’m well versed with DW/BI concepts and is Confidential Certified
• During my career, I’m collaborated with American, European and Indian clients.
• I have been involved in end to end implementation of Data warehouse projects using Informatica and Cognos.
• Experience in Requirements gathering, Analysis, Design, Development and testing phases of a Business Intelligence projects.
• Additionally, I’m also having Cognos administration experience including Installation and Configuration providing user security.
• I worked on rolling out Cognos Report Studio and Query Studio to a group of business user.
• I’m performed various levels of Testing such as Unit testing, System tests, Functional testing, and Pre - Prod testing.
• I’m having good knowledge of SQL and is well versed in writing and analyzing normal SQL queries and Good experience in Agile Development Methodology.
• To enhance my technical knowledge, I have undergone technical trainings in Microstragey,Cognos TM1, Oracle Hyperion Essbase and Informatica.

TECHNICAL SKILLS:

Industries: Banking, Finance, Insurance, Health Care, Retail, HR and Travel & Transportation

Operating Systems: Windows Family

Languages: SQL, PL/SQL

Database: Oracle, SQL Server

BI Tools: Cognos BI ( 1.1MR3, 8.2, 8.3, 8.4,10 and 11.0.3 ), Dynamic Cubes,SSAS,FM,Microstragey

Database Query Tools: Oracle SQL Developer, TOAD

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Technologies: Cognos 10.2 and Cognos 11, Autosys,Oracle,Sybase,Linux,Unix

Responsibilities:

• Develop and maintain Cognos reporting, querying and analysis solutions.
• Work closely with database and reporting technicians to build and support the information environment .
• Collect and analyze information requirements from users, translate those needs into effective solutions and clearly communicate that information to technicians .
• Provide status on issues and progress of key business projects ..
• Develop and implement reports queries to help drive business processes from CQM to DQM process .
• Fill adhoc data and reporting requests .
• To create data models based on Functional Reporting Requirements, Technical reporting requirements .
• Coordinating the Production release and other deployment activities.
• Keeping all the stakeholders updated about the daily assigned.
• Gain functional and technical expertise in the assigned application area.

Environment: Confidential Cognos BI, Unix,Microstragey,Windows 7,Oracle,Sysbase & Autosys.

Confidential

Senior Cognos Developer

Responsibilities:

• Develop and maintain Cognos 11.1 reporting, querying and analysis solutions.
• Work closely with database and reporting technicians to build and support the information environment .
• Collect and analyze information requirements from users, translate those needs into effective solutions and clearly communicate that information to technicians .
• Developed DMR Framework Manager Models and Reports .
• Provide status on issues and progress of key business projects .

Confidential

Senior Cognos Developer

Responsibilities:

• Develop and maintain Cognos reporting, querying and analysis solutions.
• Work closely with database and reporting technicians to build and support the information environment .
• Collect and analyze information requirements from users, translate those needs into effective solutions and clearly communicate that information to technicians .
• Provide status on issues and progress of key business projects .
• Responsible for preparation of High level and Low level design documents and providing estimates.
• Develop and implement reports queries to help drive business processes from CQM to DQM process .
• Fill adhoc data and reporting requests .
• To create data models based on Functional Reporting Requirements, Technical reporting requirements .
• Coordinating the Production release and other deployment activities.
• Keeping all the stakeholders updated about the daily assigned.
• Gain functional and technical expertise in the assigned application area.

Confidential, Columbus, OH

Senior Cognos Developer

Responsibilities:

• Work closely with database and reporting technicians to build and support the information environment .
• Collect and analyze information requirements from users, translate those needs into effective solutions and clearly communicate that information to technicians .
• Provide status on issues and progress of key business projects .
• Responsible for preparation of High level and Low level design documents and providing estimates.
• Develop and implement reports queries to help drive business processes .
• Fill adhoc data and reporting requests .
• To create data models based on Functional Reporting Requirements, Technical reporting requirements .
• Coordinating the Production release and other deployment activities.
• Keeping all the stakeholders updated about the daily assigned.
• Gain functional and technical expertise in the assigned application area.
• Following SDLC life cycle for new enhancements.

Environment: Relational Modeling on Cognos 10.2.1, Data stage, Oracle 11g

Confidential

Sr Cognos Developer

Responsibilities:

• Worked on the development of Cognos reports (8.4) & Cognos 10 and upgraded reports and packages and FM from Cognos 8.4 to Cognos 10.
• Worked on enhancement of the Cognos reports and also resolving the incident or problem tickets raised by business analysts.
• Responsible for daily Interacting with the clients to understand and freeze the business requirements for any new work allocated.
• Created Analysis documents and Estimation plans based on the complexity of the work allocated for the resources.
• Unit test Plan and Unit test case documents are created for unit testing of Cognos reports and Review/ Design Checklist is maintained, if necessary
• To ensure all the deliverables are made on time with minimal defects and also to ensure high quality

Environment: Relational Modeling on Cognos 10, Teradata data base.

Confidential

Sr Cognos Developer

Responsibilities:

• Worked on the development of Cognos reports (8.2) & Cognos 10.
• Worked on enhancement of the Cognos reports, cubes and also resolving the incident or problem tickets raised by business analysts.
• Responsible for Interacting with the clients to understand and freeze the business requirements for any new work allocated.
• Created Analysis documents and Estimation plans based on the complexity of the work allocated for the resources.
• Unit test Plan and Unit test case documents are created for unit testing of Cognos reports and Review/ Design Checklist is maintained, if necessary.
• To ensure all the deliverables are made on time with minimal defects and also to ensure high quality.

Environment: Relational Modeling of Framework Manager on Cognos 8.4, Oracle 9i.

Confidential

Sr Cognos Developer

Responsibilities:

• Worked on the development of Cognos reports/ packages for new requirements under Confidential Global concur expanse management
• Worked on enhancement of the Cognos reports/ packages for existing applications in production and also resolving the incident or problem tickets raised by business analysts.
• Interaction with the clients to understand and freeze the business requirements for any new work allocated.
• Involved in designing the estimations that calculates work hours for a particular incident or problem ticket to complete.
• It basically decides on the complexity of Cognos Reports, which is the number of objects involved in a given Reports.

Environment: DMR Modeling and Relational on Cognos 8.3, Oracle 9i.

Software Consultant

Confidential

Responsibilities:

• Worked on the development of Cognos reports/ packages under Expense Management System services.
• Worked on enhancement of the Cognos reports/ packages for existing applications 3.
• Interaction with the clients to understand and freeze the business requirements for any new work allocated.
• Created Analysis documents and Estimation plans based on the complexity of the Cognos reports
• Unit test Plan and Unit test case documents are created for unit testing of Cognos reports.
• Worked on the development/ enhancement to the multi - dimensional reports using Cognos tools
• Proactively involved in the performance improvement of the existing Cognos reports in production by tuning from the reporting end.
• To ensure that projects have been planned effectively so that there should not be any escalations from the client end

Environment: Relational on Cognos 8.4, Informatica,Oracle 9i.

Professional Services Consultant

Confidential

Responsibilities:

• Responsible for Interacting with the clients to understand and freeze the business requirements for any new work allocated.
• Created Analysis documents and Estimation plans based on the complexity of the work.
• Involved in Understanding the business requirements.
• Created different types of reports such as List reports, Crosstab reports and Chart reports.
• Developed simple as well as complex reports using Report studio.
• Creation of Model & Package in Framework Manager.
• Creation of Dashboard Reports.
• Applying different functionalities like filters prompts to retrieve relevant data from the database.
• Involved in unit testing of the reports and improving report performance
• RND on performance Issues of the reports and prompts.
• Testing the reports with the database to compare the results.

Environment: Relational on Cognos 8.4, Datastage & Oracle 9i.

Cognos Developer

Confidential

Responsibilities:

• Responsible for Interacting with the clients to understand and freeze the business requirements for any new work extensively developed reports as per the business requirements.
• Developed simple as well as complex reports using Report studio.
• Applying different functionalities like filters prompts to retrieve relevant data from the database.
• Creation of drill - through and master-detail reports.
• Extensively developed the documents like System test cases, Unit test cases and Program Specification Documents.
• Involved in Unit Testing.

Environment: Relational on Cog nos 8.3, Datastage & Oracle 9i.