Manager Sql Server

AISHWARYA T

856-***-**** *********.*@*****************.***

SUMMARY

• Over 7 years of IT experience in Cognos Business Intelligence Tools.

• Extensive experience in BI Modeling/Report Authoring using Cognos 8.4.1 and

8.4,8.3,8.2 Suite, Cognos Report net 1.1 MR3, Cognos EP Series 7.1/7.2/7.3

• Hands on Experience with Framework Manager Modeling (Physical Layer, Business

Layer, Packages)

• Sound Knowledge on Reporting using Cognos 8 Report Studio/CRN 1.1, Developed

dash boards using Cognos 8 Report Studio.

• Expert in development of OLAP Models and Power Cubes using Cognos

Transformer

• Customized the Cognos Connection Portal/reports based on user requirements.

• Experienced in Designing Cognos Transformer Models, generating/building cubes

• Migration experience from Cognos Impromptu, Cognos EP series to Cognos

8.1/8.2/8.3/8.4.

• Implemented Security (Data level, Object level, Package level)using Framework

manager and Cognos Access Manager

• Deploying models and reports from Development to Production and administering

users/groups/roles.

• Extensive Experience on Production Support and Troubleshoot/Test issues with

existing reports and cubes.

• Strong experience and expertise on conversion projects from Impromptu/Crystal/Micro

strategy/Business Objects to Cognos 8 BI .

• Experienced with Multiple Databases including Oracle, MS SQL Server.

• Excellent knowledge on data warehousing concepts - Star schema and Snow-flake

Schema.

• Writing PL/SQL Stored procedures as per the reporting requirements.

• Experienced in gathering of User requirements and responsible to provide efficient

end-user training and designing report specifications.

• Experienced in Educational, Pharmaceuticals, Chemical, Banking & Finance,

Insurance domains.

• An efficient communicator combining sound coordination, interpersonal, problem solving

& interpersonal skills with analytical & decision making capabilities to enhance

organizational objectives.

TECHINCAL SKILLS

BI Tools : Cognos 8.4.1, 8.4, 8.3, 8.2 and 8.1, Cognos EP Series 7i

(Cognos Impromptu, Transformer, Power play, IWR,

Upfront, Power play Enterprise server)

Cognos Reportnet 1.1 MR3, Metric Studio, Enterprise

Planning.

Databases : Oracle 9i, SQL Server 2000 and 2005, DB2, MS Access 2000

Operating Systems : Windows XP/2000/NT/9X, UNIX

Languages : SQL, PL/SQL, C, C++, HTML, XML, Java

AISHWARYA T

856-***-**** *********.*@*****************.***

Application Server : Apache Tomcat, Web sphere application server (WAS 6.0)

Web Servers : Microsoft IIS, IBM HTTP Server (HIS)

LDAP : Sun One, Tivoli Directory Server

Migration Utilities : MigS7, Mig Deploy

PROFESSIONAL EXPERIENCE

CLIENT: MICHIGAN STATE UNIVERSITY (MSU),EAST LANSING,MI

DURATION: OCTOBER 2010-TILL DATE

ROLE: SR. COGNOS DEVELOPER

RESPONSIBILITIES:

• Facilitated the requirements gathering process and fact-finding sessions with business

users to identify report requirements/design.

• Installation & Configuring the Cognos 8.4 on windows Environment. Analyzing

requirement BDM documents and creating the Framework manger model.

• Designing the logical model that conforms to star schema concepts, different views

(import, business, external) as per Business requirement.

• Created customized ad-hoc packages in Framework Manager for Query Studio users.

• Created Data Source using Oracle 10g and Imported Tables/Views to the Framework

manager model and set the cardinality between them as per the business requirements.

• Created Business layer and Presentation Layer, defining appropriate relationship

between query subjects and Fact Table in Framework Manager.

• Setting up cardinality (minimum, maximum & optional), Determents to avoid double

counting, support loop joins, optimize data source, and identify dimensions and facts.

• Created Dash Board Reports from cube using Report Studio and adding it to the portal

page using HTML Items for critical performance metrics Operations, Sales, Human

Resources, Information Technology, and Standards using MDX functions.

• Designed National Dashboard reports on the critical performance metrics in the path

toward Best Quality, Best Service, Most Affordable and the Best Place to Work which

make up the KP Value Compass.

• Design & development of multiple reports using various templates like list reports,

cross-tab reports and chart reports.

• Involved in Deploying reports, cubes and packages from Development to Production

environment.

• Worked with Global Drill- through Definitions to drill through from analysis studio

reports to Report Studio reports.

• Involved in building up the OLAP using Informatica.

• Worked on Performance Tuning of Cognos to make sure that the Reporting System was

performing at its optimum level of Performance.

AISHWARYA T

856-***-**** *********.*@*****************.***

• Creating the Cognos Report Studio reports for EIS (ROLAP) model. Applying the

security to display data based on the user security.

• Unit testing, Integration testing and system testing of the reports in Development,

Performance and production environments.

ENVIRONMENT: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report

Studio, Query Studio, Analysis Studio, Metric), PowerPlay Transformer 8.4, Cognos Access

Manger, Oracle 10g, Windows 2003 Server.

CLIENT: ABBOTT LABORATORIES,NORTH CHICAGO,IL.

DURATION: JULY 2009 -SEPTEMBER 2010

ROLE: SR.COGNOS DEVELOPER

RESPONSIBILITIES:

• Worked closely with Clients and Business Users to analyze and understand business

requirements and Participated in requirements gathering meetings / Sessions.

• Worked on technical design specs for Framework manager, and reporting per the

requirements.

• Created model query subjects, datasource query subjects, StoredProcedure query subjects

as per the business requirements in the Framework Manager.

• Developing a logical model that conforms to star schema concepts, different views

(import, business, external) as per Business requirement.

• Design and developing star schema grouping for better understanding of the model &

facilitate multi-fact (cross-fact) reporting.

• Developing the List Reports, Charts, Drill Through Reports, Master Detail Reports

and Multilingual Reports Using Report Studio and Query Studio.

• Developing the Dashboard reports using Cognos Report Studio and Metric Studio.

• Developing the SQL scripts using teradata SQL Assistance to populate the data in

Reporting tables as per the requirements.

• Designed complex reports with union queries, and SQL queries.

• Improved long running reports performance thru writing SQL queries, resolving

complex joins in framework manager, filters, and using stored procedures.

• Setting up cardinality (minimum, maximum & optional), Determents to avoid double

counting, support loop joins, optimize data source, and identify dimensions and facts.

• Developing Dash Board reports in Report Studio using MDX Functions and creating

the Report Studio reports using the MDX functions.

• Built Multidimensional Cubes, Sub cubes for user groups using PowerPlay

Transformer.

• Creating the Cognos OLAP cube using PowerPlay transformer.

• Designed Intermediate layer and Presentation Layer, defining appropriate relationship

between query subjects and Fact Table in Framework Manager.

• Creating the Bar charts and list reports using Cognos Report Studio and Analysis

studio.

• Extensively working with Stored Procedure Query Subjects in Framework Manager.

• Created User Groups, Roles to implement the Cognos Security, using Directory Server.

• Working experience with different date functions in Report Studio.

AISHWARYA T

856-***-**** *********.*@*****************.***

• Performance tuning the by analyzing and comparing the turnaround times between SQL

and Cognos.

• Deploying the reports and package from Development to testing, Testing to Production

environments.

• Recommended to do the complex database calculations in the database to improve report

query performance.

• Provided users with several Trend Analysis Graphs to help them make balanced

decisions and linked these as Drill downs from the Dashboards. This gave users a

complete picture of how they we doing against the projected performance.

ENVIRONMENT: Cognos 8.4 Suite (Cognos Connection, Framework Manger, Report Studio,

Query Studio, Analysis Studio), Cognos 8.2 Suite, PowerPlay Transformer 8.3, DB2 8.1,

Cognos Access Manger, Windows XP, Unix shell scripting, SQL Server 2005.

CLIENT: DUPONT(SATYAM), WILMINGTON,DELAWARE.

DURATION: OCTOBER 2008-JUNE 2009

ROLE: COGNOS DEVELOPER

RESPONSIBILITIES:

• Involved in understanding existing Business Model and Customer requirements by

participating in the Design Phase and user requirement gathering.

• Extensive experience in migration of reports from Impromptu using Migration Utilities

and mapping to corresponding metadata of Cognos 8 and Resolved complex problems

like calculations, filters, prompts, conditional styles in migrated reports.

• Involved in modeling (star schema / snowflake schema) as for the user requirement

using Framework Manager also created models using different hierarchies.

• Designed Cognos Framework Manager Model with different views (Database View,

Business View, Presentation View) using Oracle 9i.

• Worked with Global Drill- through Definitions to drill through from analysis studio

reports to Report Studio reports (MOLAP – ROLAP).

• Involved in creating Metadata models using Framework Manager and publishing the

packages to Cognos Connection.

• Created Cognos Dashboard reports and refreshed dashboard page and portlist.

• Developed complex reports like Drill Down, Drill Through & Dashboards in report

studio

• Set up Security by creating Namespaces and User Classes in Access Manager and LDAP.

• Designed reports by using HTML, XML and also used JAVASCRIPT for prompt

validations

• Created reports having Filters, multiple Prompts (Select & Search prompt, value

prompt, tree prompt) and provided option of bursting of reports.

• Involved with Scheduling and Distributing Reports through Schedule Management in

Cognos Connection and Bursting reports to different user groups.

• Involved in creation of mappings to the reports depending on users, groups and roles.

AISHWARYA T

856-***-**** *********.*@*****************.***

• Played as a good mentor to the newly joining team by giving knowledge transition in

both technical and functional areas.

ENVIRONMENT: Cognos 8.2, Cognos 7 (Framework Manager, Cognos connection, Analysis

studio, Report Studio, Query Studio, Access Manager), Oracle 9i, Toad, Windows, UNIX.

CLIENT: WELLS FARGO, TEMPE, AZ.

DURATION: FEBRUARY 2007- SEPTEMBER 2008.

ROLE: COGNOS DEVELOPER.

RESPONSIBILITIES:

• Worked on Cognos8.1 framework manager to import metadata from multiple data

sources and to create subject oriented business models, create and publish packages to

Cognos 8 server.

• Creating relationships between query subjects to better represent the logical structure of

the business and the user requirements.

• Worked with Decision Stream and extracted data from different database and created own

database and used that data base in framework manager as a data source.

• Designed model for Ad-Hoc report and implemented security on the model.

• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.

• Authored Reports using Report Studio and trained end users in building Ad-hoc reports

using Query Studio.

• Created Master-Detail reports which had parameterized detail query or filtered detail

query based on the requirements in report studio.

• Extensively worked in Scheduling and Deploying (Staging to Production) Reports.

• Worked on complex reports using Tabular Objects, Static Prompt conditions.

• Involved in designing and building the PowerPlay cubes using Transformer.

• Built PowerPlay Reports based on these cubes and published to ReportNet Server.

• Created complex reports using calculation sub queries and data synchronization

techniques.

• Helped the remaining team to resolve Computation and Multivalued errors in the reports .

• Assisted client in training activities to the Business users .

• Assisted client in creating business documentation based on the universe .

• Administering the business users in the portal based on the requirements.

AISHWARYA T

856-***-**** *********.*@*****************.***

ENVIRONMENT: Cognos 8.1, Cognos ReportNet1.1 MR3 (Framework Manager, C.C, Query

Studio, Report Studio), Business Objects XI R2/R1, Oracle 9i, Toad, Tivoli LDAP, Migration

Utilities (Impcat2xml, Migratetoc8, Deploytoc8), Informatica 8.

CLIENT:STATE FARM INSURANCE,BLOOMINGTON,IL

DURATION: SEPTEMBER 2005- JANUARY 2007.

ROLE: COGNOS/ SQL PROGRAMMER.

RESPONSIBILITIES:

• Understood business requirements and report specifications.

• Used Cognos Connection to administer Reports as well as ReportNet Server to build

models, packages.

• Created professional reports in Report Studio and ad hoc reports in Query Studio.

• Modified packages to suit business needs and to improve performance of reports by

defining filters and adding calculations.

• Used Report Studio to create list reports, crosstab reports, chart reports and reports with

lot of conditional formatting.

• Used Cognos Impromptu to developed Catalogs and created reports.

• Used Impromptu Query Definition (IQD) to designed models

• Used Cognos PowerPlay to created OLAP Cubes in Cognos Transformer, and analyzed

data Creation of standard filters, prompts, calculations, and conditions in catalog.

• Created various reports such as List reports, Cross-Tab reports, and Drill through Reports

using Impromptu.

• Created and maintained multiple shared catalogs using Cognos Impromptu.

• Involved actively in training sessions and demonstrated use of Cognos tools to End-

users.

ENVIRONMENT: Cognos Reportnet 1.1, Framework Manager, Report Studio, Query Studio,

Cognos Connection, Impromptu 7.3, PowerPlay Transformer 7.3, Oracle, Windows 2003 server.

CLIENT: STATE BANK OF INDIA(SATYAM), HYDERABAD, INDIA.

DURATION: MAY 2004- JULY 2005.

ROLE: SQL DEVELOPER.

RESPONSIBILITIES:

• Gap business analysis, ER Diagrams and preparation of Software Design Description

Document

• Screen validation and coding

• Creation of Active-X Controls

• Created stored procedures for improving the performance

• Designed reports with Crystal Reporting Tool

• Preparation of test plans for Unit testing and regression testing

ENVIRONMENT: SQL Server 7.0, Crystal Reports, Visual Source Safe.

AISHWARYA T

856-***-**** *********.*@*****************.***

EDUCATIONAL QUALIFICATION:

BACHELORS OF TECHNOLOGY IN COMPUTER SCIENCE,JAWAHARLAL

TECHNOLOGICAL UNIVERSITY.

2004

Contact this candidate