Objective:

To be associated with a reputed organization, giving the best of my abilities to contribute to organizations growth, while working on improving my skills, and making a mark of identification for myself.

Experience Summary

• Having 7+ years of experience in IT industry, expertise in Analysis, design, development and implementation of Data Warehousing Applications usingCognos BI Tools and Actuate.
• Extensive experience in BI Report Authoring using Cognos v10.1,8.x, Report Studio, Query Studio, Even Studio and Analysis Studio.
• Experience in developing the models in Framework Manager and publishing the packages for Report Studio environment using various data sources like Oracle, SQL Server, DB2, Teradata
• Extensive experience in Actuate business intelligence reporting platform. Proficient in implementing eReport Designer Professional and development using Actuate Reporting System, creating and modifying Actuate Reports according to client’s requirement.
• Good knowledge of data warehousing concepts.
• Actively worked with team members to Develop, Test and Implement the client requirement into client’s delight.
• Have excellent analytical and communication skills, proactive, well organized, efficient and a great team player.
• Always enthusiastic to enhance technical knowledge and understanding of new and expanding technologies.
• Good exposure to Banking and Financial ,Telecom and healthcare domain.

Educational Qualifications

B-Tech in Computer Science & Engineering

Certifications and Trainings

• IBM Certified Designer-Cognos 10 BI Reports
• Actuate Certified Professional
• Oracle Certified Associate OCA 1Z0-007
• National Certification in Financial Markets – Beginners Module

Technical Skills

Technologies

Data Warehousing/ Business Intelligence, Cognos, Actuate , Business Objects

Tools and Utilities

Reporting Tool – Cognos 10, 8.x (Report Studio, Analysis studio,Event Studio), Cognos Framework Manager, Powerplay and Transformer.
Actuate 7/8
Rapid SQL, Toad, SQL Load, Harvest

Programming Languages

Java 1.4, XML, Unix, Unix Shell scripts

RDBMS

Oracle 9i, Sybase 12.5, PL/SQL, Teradata,DB2

Operating Systems

Windows 2000,Windows 98/XP,UNIX (HP-UX)

Programming Methodologies

HTML, Java Script

Domain

Banking and Financial, Telecom, Healthcare

Relevant Project Experience

Project Title : Confidential,
Client :Confidential,
Duration : Mar 2011 to till date
Role : SeniorApplication Developer

Responsibilities:

• Worked independently and as a team member with Medco SMEs and Medco stakeholders.
• Performed analysis on the requirements and documented reports requirements in co-ordination with the Medco SMEs.
• Designed various kinds of reports to meet business requirements. Designed other associated artifacts supporting the reports.
• Created Models, Projects and published packages as per report’s requirements
• Built data source query subjects using stored procedures to create query subjects that are used to build reports for specific users.
• Developed complex reports with master detail, report bursting, prompt, cascading prompt ,multi object reports using List, Crosstab, Charts etc.
• Created and modified cubes using Transformer for OLAP analysis of data .
• Used Report Studio and Analysis Studio to build reports based on cubes built in Power play Transformer and deploying the cube in Cognos 8 .
• Worked on performance tuning of reports by analyzing queries.
• Actively worked on migration of reports from Congos 8 to Congos 10.
• Created events in Event Studio as per business requirements.
• Tested reports thoroughly in multiple environments.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Promoted reports in Production environment.
• Trained Team members on Cognos and Teradata. Provided technical guidance and support to junior team members.

Environment : Cognos v.8.4,10.1 (Framework Manager, Report Studio, Analysis Studio,Event Studio ,Metric Studio, Power play Transformer) and Teradata

Project Title : Confidential,
Client : Confidential,
Duration : May 2010 to Mar 2011
Role : Senior Cognos Developer

Responsibilities:

• Interacted with different application teams within IBM to understand the manual processes which was being followed for the collection of the metrics and the reporting. Captured the pain points of the existing process. Understanding of the different data sources and their dependencies on each other. (Understanding of AS Is System)
• Discussion with the applications team and managers to understand the expected process improvements to define and finalize the scope and the requirements. (Define Scope and Requirements)
• Analyzed the requirements comprehensively and defined the overall solutions approach. Captured the data requirements for the solution and defined the different components to be built for the solution. ( Design the Solution )
• Captured the requirements in Requirements document and co-ordinated discussion with stake holders for a formal sign-off.
• Designed the database schema, table structures for the reports. Used the concepts of data modeling, normalization ,data validation.
• Designed Reports & related artifacts . Created SQL scripts for data loading, data validation.
• Installed Cognos8.4 with DB2.
• Created models, Projects and published packages in Framework.
• Developed various type of reports crosstab, list, charts using prompts cascading prompts,drill through etc.
• Tested the overall solution and the reports.
• Demonstrated the entire application to users(data collection,loading,generating reports)

Environment : Cognos v.8.4, 10.1 (Framework Manager, Report Studio, Analysis Studio) and
DB2

Project Title : Confidential,
Client : Confidential,
Duration : Nov 2009 to May 2010
Role : SeniorCognos Developer

Description:
IB (Information Bus) is a migration project. It has 22 Complex reports in actuate and will be transformed in the cognos environment. In addition to creating COGNOS version of the existing reports, a COGNOS framework package was created to support the IB reports.Cognos URL is created to invoke the reports.
Responsibilities:

• Analyzed specifications given by the clients.
• Analyzed technical functionalities of the reports in actuate and prepared Low level design document
• Developed package in the framework manager.
• Prepared low level and high level design document for the cognos reports
• Developed dashboard in report studio
• Developed list, crosstab and chart reports
• Applied some complex functionality like drill through, cascading prompts.
• Executed unit test on reports
• Participated in code review meeting with the clients.

Environment: Report Studio, Cognos Frame Work Manager, SQL Server