Summary:

• Over all 7 years of IT experience, in which 3 yr in Cognos and 2.5 yr in Business Objects and 1.5 Year in AbInitio
• My experience Include: Requirement Gathering, Architecture, Design, Development, Tuning and troubleshooting of Business Intelligence Application
• Successfully executed one million dollar project as ETL architect to develop operational database for catastrophe division of insurance client using AbInitio
• Proven experience in Cognos 8.4 and 8.2 Report Studio, Framework Manager, Analysis Studio, Metric Studio, Go Dashboard and Event Studio
• Implementation of wide variety of packages using Cognos Framework Manager
• Experience in impromptu 7.x, powerplay transformer
• Successful implementation of Web Analytic tool Tealeaf within insurance domain
• Experience in using Business Objects XI R2 products such as Designer, Web intelligence, Enterprise Performance Management
• Complex implementation of universes, creating dashboards using Business Objects dashboard manager, developed Performance Manager Analytics using Enterprise Performance Management
• Provided thought leadership during each engagement
• Demonstrated experience in designing, developing, implementing and managing complex BI solutions.
• In-depth knowledge of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP
• Use of consultative techniques to help customer understand how business processes can be improved and how BI technology can be employed to that end
• Using BI product expertise, build demonstrations, proof of concepts, prototypes to deliver a high-value solution
• Assessment of various activity so as to improve the quality of deliverables
• Knowledge of domains like Banking and Insurance

Technical Skills:
Primary Skill : AbInitio, Cognos, Business Objects, TeaLeaf
Business Objects XI R2 : WEBI, DESKI, Xcelcius
Cognos 8.x : Report Studio, Query Studio, Framework Manager, Go Dashboard, Event Studio and Metric Studio, Impromptu 7.x, Cognos Powerplay, Cognos Upgrade Manager
Databases & Tools : Oracle 9i,TOAD, SQL Developer, SQL Server, Tearadata, DB2, SQL Assistant
Programming Languages : C, C++, SQL, C#

Professional Experience:
Confidential, Hartford, USA Apr 2012- Current
ETL Architect

Project & Role Description
The project involves Building an Operational Database for Business Insurance Work Management application

Responsibilities:

• ETL High Level Design
• ETL Low Level Design
• Ensuring quality management, delivery of project work products

Tools and Technology: AbInitio GDE

Travelers (Cognizant Technology Solutions), St Paul, USA Feb 2012- Mar 2012
Cognos Techno Functional Analyst

Project & Role Description
The project involves Building reports for Change Management Process

Responsibilities:

• Understanding scope of the reporting
• Conduction Business Requirement gathering sessions
• Preparing detailed technical specification documents
• Test case strategy document
• Direct offshore team in report development effort

Tools and Technology: Cognos

Confidential,Hartford, USA Jan 2011- Jan 2012
ETL Architect

Project & Role Description
The project involves Building an Operational Database for Catastrophe Division

Responsibilities:

• Gathering requirements and preparing Technical Specification Document
• Design of logical data model for Operational Database
• ETL High Level Design
• Review of Low Level Design
• Producing and maintaining project plans, producing all controlling and tracking documentation
• Ensuring quality management, delivery of project work products

Tools and Technology: AbInitio GDE

Confidential,Hartford, USA Jun 2008- Dec 2010
Sr. Cognos Developer

Project & Role Description
The project involves:

• New report development in Cognos 8.x
• New package development in Cognos 8.x
• Migration of reports from Cognos 7.x to Cognos 8.2
• Migration of impromptu catalog to Cognos 8.2
• Migration of Powerplay cubes to Cognos 8.2
• Migration of reports, packages and cubes from 8.2 to 8.4
• Implementation of Dashboard using Cognos 8.x

Responsibilities:

• Architecture of Cognos Framework packages
• Report development using report studio, event studio, analysis studio
• Report and Framework package Migration from Cognos 8.2 to 8.4
• Cube development and deployment
• Mentoring offshore development team
• Managing, co-coordinating and monitoring the overall delivery of projects from definition to deployment

Tools and Technologies: Report Studio, Query Studio, Framework Manager, Go Dashboard, Event Studio and Metric Studio, Impromptu 7.x, Cognos Powerplay, Cognos Upgrade Manager

Travelers (Cognizant Technology Solutions), Hartford, USA Sep 2008- Dec 2009
TeaLeaf Consultant

Project & Role Description
The project involves implementation of TeaLeaf within Travelers Personal Insurance

Responsibilities:

• Design Tealeaf Architecture
• Implementation of Architecture
• Understand user requirements
• Implementation of user requirements through tealeaf Events, Dashboard and Scorecards
• Troubleshoot and maintain Tealeaf Application

Tools and Technologies: TeaLeaf

Confidential,Lake Forest, CA Oct 2006 -Jun2008
Oct 2006 – Dec 2006: Pune India
Jan 2007- Jun 2008: Lake Forest, CA
Business Objects Designer

Project & Role Description
The project involves the development of end end-to-end data warehousing solution for the Home Loans division of Washington Mutual (WaMu) Bank. The scope involves the creation of a data mart for different channels of WaMu such as Consumer Direct, Retail and Wholesale. The data mart resides on an Oracle database; Informatica is used to develop Extraction, Transformation and Loading (ETL) for the data mart; Business Objects is used as the reporting tool.

Roles:

• Interacting with business users to obtain requirements for Business Objects reports and create functional specification for requirements
• Responsible for architecture of the reporting solution
• Involved in estimation for items such as reports, universe development
• Involved in project planning activity
• Developing EPM based Analytics and Dashboards
• Working as an onsite coordinator for execution of the requirements with the offshore team – managed team of around 6 people
• Lead the universe development effort for the project. Developed two universes.

Tools and Technologies: Business Objects XI R2- Designer, WebI, Enterprise Performance Management, Dashboard, Oracle 9i/10g, SQL Developer

Confidential,Pune, India Dec 2005 -Oct2006
Business Object Consultant

Project & Role Description
SP-ODW System Offers sales & marketing reporting facility for Schering Plough users. System is having more than 250 reports. Scope of project involves design & development of Universe & Reports. The reports are fully parameterized. It is centralized reporting System for SP-Users

Roles:

• Gathering Business Requirements and developing report using web intelligence
• Maintenance and update of the universe
• Understanding of the data and making recommendations to change the data structure to suit the business requirements of reports

Tools and Technologies: Oracle 9i, SQL Developer, Business Objects Web Intelligence, Business Objects Designer

Confidential,Pune, India Sep 2005 -Dec2005
Consultant

Project & Role Description
Application is used to get the stock prices using Yahoo Web service.

Roles:

• Gathering Business Requirements and design of UI
• Application development using C#

Tools and Technologies: C#, MS SQL Server

Confidential,Mumbai, India Jun 2004 -Mar2005
Student

Project & Role Description
Application helps librarian in maintenance of books, members through use of Barcode. UI is designed using VB; Microsoft SQL server is used as backend.

Roles:

• Design of data model
• Implementation of database using the data model
• Design of UI interface
• Interface implementation for Barcode

Tools and Technologies: VB, Microsoft SQL Server

Education:

• Completed Bachelors in Computer (BE) from Confidential University