Rohini Shivashankarappa

Cell: 727-***-**** abkuf6@r.postjobfree.com

Cognos Architect /Business Objects Developer – Administrator /Spotfire Developer

Cross Functional Experience w/ Business Intelligence Reporting Tools Expertise

Highly qualified senior level consultant offering over 8.5 years of software development experience within several business areas

including Finance, Insurance, Retail and IT. Results-focused with proven ability to design and develop quality software

applications to support reporting and Business Intelligence initiatives. Talent for communicating and solving complex problems,

leading development teams, improving data management, automating and integrating systems, and delivering projects on time.

TECHNICAL SUMMARY

BI Reporting Tool Cognos 8/8.2/8.3/8.4(Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio, Metrics

Studio, SDK), Cognos ReportNet MR1(Framework Manager, Report Studio, Query Studio, SDK), Spotfire

2.2/3.0,Business Objects XI R2/6.5/5.1.X, Web Intelligence XI/6.0/2.X, Crystal Reports 9, XI R1/R2, Actuate, Web

trends

Database Oracle 9i/8i/7.x, MS SQL Server 2005/2000, DB2 UDB, MS Access, SQL, PL/SQL, SQL * Plus, Sybase ASE 15.0.

OS Windows 2000, Windows 2003, Windows XP and Unix

Languages c, c++, Java, J2ee, ASP, JSP, VB6, MotioADF (Cognos SDK)

Authentication Tool MotioCAP, Passmark

CAREER HIGHLIGHTS

BO Administrator Mar, 2010 – May, 2010 Oct, 2006 – Aug, 2007

Northern Trust, Chicago, IL

Design, develop and implement Enterprise Data Warehouse and Business Intelligence solutions. Install and configure Business

Objects XIR2 software in a variety of environments from centralized server environments to virtual machines. Maintaining,

Supporting and upgrading BI patches used for both internal and external applications.

• Design, install, configure and implement Business Objects XIR2 solutions using the full suite of BI tools

• Upgrade legacy BI tools and reports to newer versions and/or migrate them to other vendor solutions .

• Extensively involved in User/Group creation, maintaining security, reports migration from CE 9 to BO XIR2.

• Creating different CMS clusters and server groups to improve performance. Designed and developed multiple

universes, Deski and Webi reports.

• Primary Focal point for the reporting bugs or issues to the vendors

-- Technology Used: Business Objects 5.1.X/6.5/XIR2, Crystal Report 9/XI R1/R2, Web Intelligence XI/ 6.0/2.X, Actuate, Web

trends, UNIX Server, Windows 2003

Senior Cognos Expert Dec, 2009 – Feb, 2010

Towers Watson, Chicago, IL

Designed, developed and implemented Cognos OLAP analytics and data warehouse structures which will collect the employee

opinions on important areas for the client Human’s Capital development . Developed both operational and data warehouse

models, multidimensional OLAP cubes, BI reporting and analysis to deliver information via web and traditional client-server

reporting tools. Worked closely with business clients to build the business models and deliver strategic solutions tailored to their

specific requirements. Worked as a subject matter expert in BI concepts.

-- Technologies used: Cognos 8.4, Oracle 8i

BI Architect Sep, 2007 – Oct, 2009

Nielsen Media Research, Oldsmar, FL

Design, develop and implement the Enterprise Data Warehouse and Business Intelligence Solutions. Created data models using

the Framework Manager to support online adhoc reporting, structured reporting and OLAP cubes. Manage all aspects of the

BI/DW lifecycle from assessments to gathering requirements and delivering end user solutions.

Rohini Shivashankarappa

Cell: 727-***-**** abkuf6@r.postjobfree.com

• Develop multidimensional cubes and reports from both data warehouses, data marts and source systems

• Reduce data mart load times and report/cube delivery by implementing a table driven business rules and process engine

using Stored Procedures, Views and Functions and optimizing existing cubes and reports.

• Key person in evaluating the new business intelligence tools, components, platform architecture and on boarding new

projects

• Creates overall functional Business Intelligence direction and implementation plan, Contributes to, reviews and

approves the architecture for all Business Intelligence solution components.

• Contributes to the design of Business Intelligence application solutions including report design and analytics

integration.

• Worked collaboratively with Infrastructure and support teams, consultants, project managers, and corporate

development to develop consulting and project methodology, techniques, tools, and solutions.

• Led a group of eight to ten developers in architecting and building the EDW for the reporting and analytics solutions.

• Worked in customizing the report using Cognos SDK(MotioADF)

• Developed standards; advised and mentored developers on best practices for Cognos Business Intelligence/Data

Warehouse development and usage.

• Developed several Dxp’s using Spotfire.

• Conducting the workshop on different technologies – Spotfire, Cognos Report Studio

• Participates in selection and hiring new BI team members

-- Technologies used: Cognos 8/8.2/8.3/8.4, MotioADF, MotioCAP, SharePoint Server 2007, Spotfire 2.2/3.0, Tortoise

SVN, Sybase ASE 15.0, SQL Server 2005, Oracle 8i

Requirement Analyst Jun, 2006 – Sep, 2006

ABN AMRO Services Company, Chicago, IL

Involved in various activities of the project like information gathering, analyzing the information gathered, documenting the

functional or business requirements. I also wrote test plans and test cases of the business process or application.

-- Technologies used: Business Objects, Passmark

BO Technical Leader Jan, 2006 – May, 2006

JP Morgan Chase, Bangalore, INDIA

Developed a Transactional Approval System (TAS) reports which will provide the customer’s day to day account information.

These reports are the key information for the credit officers to reach a decision on approval/ denial of the overdraft.

-- Technologies used: Business objects 6.5, MS VSS, Oracle 8i

- Highlights: I completed this project in shorter time span of 3 months which includes the training of BO tool.

Cognos Lead Developer Apr, 2002- Dec, 2005

MetLife, Bangalore, INDIA and Beijing, CHINA

Developed a 2 web-based OLAP reporting application (WFM and MIS) for the MetLife. WFM (Work Flow monitor) provides

the statistical information of the policy for the MetLife affiliates and MetLife International Management. WFM is a real time

data.MIS (Management Information System) provides the stored policy data in a more statistical way to Sales and operational

group. I involved in all the phases of SDLC from Requirement analysis, Preparing BRD, designing prototype, modeling schema,

design and developing the reports, test cases preparation, unit and functional testing and product implementation.

-- Technologies used: Cognos ReportNet, Cognos SDK, MS VSS, DB2 UDB, Java, Java Scripts

- Highlights: Single handedly planned and implemented in MetLife China and played instrumental role in developing

the reports for the other affiliates (MetLife Taiwan, MetLife Hong Kong, MetLife India).

Developer Jan, 2002 – Mar, 2002

Thomson Gale, Bangalore, INDIA

Rohini Shivashankarappa

Cell: 727-***-**** abkuf6@r.postjobfree.com

Developed a web-based WBIS (World Biographical Information System) using a Struts framework. This provides the online

access to biographies of people around the world and from all times period. This provides access to 2.2 million full text

biographies on approximately 1.3 million people. Replaced the entire K.G Saur‘s Biographical Archives to full text biographies.

Supports 5 different languages (English, German, French, Italian and Spanish).

-- Technologies used: Java, JSP, Java Scripts, IBM Web sphere Application Server 5.0

Developer Jul, 2001 – Dec, 2001

MetLife, Bangalore, INDIA

Developed a web-based application called eSeg, a policy administration system. Responsibilities include the designing and

customization of the report according to MLI standards using VB and ASP.

-- Technologies used: VB 6.0, MS VSS

EDUCATION AND TRAINING DETAILS:

Visveswaraiah Technological University, Belgaum, INDIA - Bachelor of Engineering in Electronics and Communication.

Technical Training: Cognos ReportNet, Oracle 8i, Informatica, Java, VB 6.0.

Certifications

Certification Date Certified

Cognos ReportNet Product User 2005

Cognos ReportNet Product Professional – Reporting Track 2006

Cognos ReportNet Product Professional – Modeling Track 2006

Cognos ReportNet Product Professional - Administration Track 2006

Contact this candidate