Roopa
Email: *****.******@*****.***
Phone # 347-***-****
Professional Summary:
Over 7 years of IT experience in Software Application Design, Development, Testing, Documentation and
implementation of data warehousing applications and experience in OLAP tools
Expertise with Cognos tools such as Cognos 8 Business Intelligence, ReportNet (Framework
Manager, Report Studio, and Query Studio ) Impromptu, Power Play; Impromptu Web Reports
(IWR), Access Manager, and Server Administration on Enterprise, Upfront and IWR Servers.
Designed and analyzed Business and Technical BI Models
Well-versed in developing reporting applications using Cognos 8 Business Intelligence components like
Framework Manager, Report Studio, Query Studio, Analysis Studio, Metrics Studio, event studio, and
Cognos Connection.
Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting
(including the bursting of reports globally) using Cognos. Created complex Dashboards with Area
charts, Pie charts, Cross tabs and Multi prompts in Report Studio.
Involved in Installation, Configuration and administration of Cognos series 8 Suite.
Developed Framework Manager models against relational model and dimensional models – (layers,
star schema, cardinality, relationships, query subjects), create and publishing packages.
Extensive experience in developing multidimensional OLAP cubes in power play transformer using
various data sources and published in Cognos connection.
Experience in Report Authoring using cascading prompts, conditional formatting, drill-through
reports, bursting and HTML Scripting.
Responsible for designing and developing Schemas using Entity Relationships, Data Modeling,
Normalization, creating Tables, Views, Indexes, Sequences and coding .
Extensive knowledge in various Internet related platforms with specialization in SQL, PL/SQL, VB, HTML,
DHTML, and XML.
Working knowledge on ETL tools like Informatics, SSIS in designing data warehousing.
Strong Inter personal communication skills, Ability to provide appropriate attention to details and effective
troubleshooting skills, and ability to work in a team.
Thrust Areas include:
• Created Business Intelligence Reports, OLAP solutions using Cognos Tools
• Provided extensive End User Training and Support
• Implemented Security using Cognos applications.
• Migrated Impromptu catalog to Report Net using Report Net Migration utility
Technical Skills:
BI Tools: Cognos 8.4 BI(Report Studio, Query Studio, Analysis Studio, Metric
Studio, Metric Designer, Go dashboard, Go office, Transformer,
Framework Manager), Cognos Series 7 VERSION 3 Impromptu
Administrator, Impromptu, Impromptu Web Reports, COGNOS Architect,
COGNOS PowerPlay Transformer, PowerPlay User, PowerPlay Web
Reports, PowerPlay Enterprise Server, Upfront Administration, Access
Manager LDAP Server, Configuration Manager, Visualizer, Metrics
Manager.
REPORTNET 1.1(MR 2): Cognos connection, Frame work Manager, Query studio, Report studio,
SDK.
ETL Tools: Informatica
Operating Systems: Windows 95/98/NT/XP/2000, UNIX, Sun Solaris, Linux.
Languages: SQL*Plus, PL/SQL, HTML, DHTML, JSP.
Databases: ORACLE 9i,10g, DB2, MS SQL Server 2000, and MS-Access.
GUI: Developer 2000, Crystal Reports, Erwin, Vision.
Software Packages: MS-Office 2003, Microsoft Word, Excel and Power Point.
Data Modeling Tool: Erwin 4.1, Visio 2000.
Database Tools: Toad, SQL Navigator.
Other Tools: Directory Tool, Server Administrator Tool, Deployment Tool, Capabilities Tool,
Schedule Management Tool.