Manager Sql Server

Email: *********.*****@*****.***

Katyayini Tel: 214-***-****

W ork Sponsorship: Authorized to work in US (EAD)

SUMMARY:

Around 5 years of experience in Data Warehousing and Reporting Technologies wi th primary

focus on Cognos BI suite of technologies and 7+ years of overall IT experience.

Solid experience with Cognos tools such as Framework Manager, Report Studio, Query

Studio, Analysis & Event Studio, PowerPlay Enterprise Server (PPES), Transformer &

PowerPlay cubes, Visualizer,Impromptu Administrator, Impromptu Web Reports (IWR),

Architect, PowerPrompts,Cognos Query & Script Upfront and Access Manager.

Experience in creating Catalogs and Impromptu Administrator and creating IQD’s in

Framework Manager to use in Cognos PowerPlay.

Experience with implementing broad spectrum of processes within the ETL and reporting life

cycle domain (i.e. Extraction, Transformation, Reporting, and End -User support).

Experience in data warehousing using Informatica Power Center 7.1.4/7.1.2. Worked with

complex mappings using transformations like Source Qualifiers, Expressions, Filters, Joiners,

Routers, Union, Unconnected / Connected Lookups and Aggregators .

Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database

Schemas like Star Schema and Snowflake schemas used in relational, dimensional and

multidimensional modeling. .

Analyzed and translated Business Intelligence needs of the Enterprise into effective

Performance Management solutions.

Thorough experience with delivering BI projects using the SDLC framework (i.e. Production,

QA, Development).

Experienced with relational Databases like Oracle 8i/9i/10g, MS SQL Server, MySQL,

PL/SQL, SQL, TOAD, Stored Procedures, Functions & Triggers.

Strong Analysis/Design skills using Object Oriented Programming and Java.

Effective at communicating, and working, with large and small teams (Technical and Non -

Technical) of varying capacities.

Extensive experience with SQL Queries, Stored Procedures and Unified Modeling Language

(UML) Modeling.

Knowledge about different OLAP modeling techniques like ROLAP,MOLAP,HOLAP.

Experience in creating repository.

Maintained good relation with project team members, business analysts and with everyone.

TECHNICAL SKILLS:

Business Intelligence tools IBMCognos,Cognos8 BISuite(Framework Manager,Report Studio,Query

Studio,Analysis Studio,Metric Studio,Event Studio),Cognos series 7,

Reportnet 1.1MR2/1(Framework Manager, Report Studio, Query Studio),

Impromptu 7x/6x, PowerPlay 7x/6x, PowerPlay Transformer, PowerPlay

Enterprise Server,IWR,Cognos Architect,data manager,access manager,Active Directory, Business Objects version 6,7,XI release2.

Data Warehousing Informatica Power Center 7.x (Source Analyzer, Repository Manager, Data

W arehouse Des Data Warehouse Designer, Transformations), OLAP,

OLTP, ETL, Datamarts,Business Objects,Data Stage.

Databases & Tools Oracle 10g/9i/8i, MS SQL Server 2005/2000, MySQL, TOAD, SQL* Loader,

SQL*Plus,MS-Access,DB2.

Web Developing Tool Dreamweaver4.0/Mx, HTML,VB script,JavaScript,XML, FrontPage and

Flash.

Application Servers BEA Web Logic .

Web Servers Java Web Server,IIS4.0/5.0,Apache Web Server,Tomcat4.01,Weblogic.

Dimensional Data Modeling Erwin, Visio

Operating Systems Linux, UNIX, Windows Vista/XP/2000

Programming Environment C,C++,C#,JAVA.

PROFESSIONAL EXPERIENCE:

Client: Sabre Holdings, Dallas, TX

February 2008 – Feb 09

(Epace Technologies)

Role : Cognos Developer

Sabre Holdings, is the world’s largest Global Distribution System (GDS) connecting travel agents

and travel suppliers like Airlines, Hotels etc with Travelers. The project dealt with Framework

Manger, Report studio, Query studio and crafted several OLAP cubes to generate reports based

on travel patterns of travelers to provide add on services for suppliers like reporting aiding in

better campaign management, Profitability Analysis and also enable suppliers to monitor and

better price their inventories.

Responsibilities:

Successfully gathered product requirements from the client and analysed them to resolve

problems.

Developed models using FrameWork Manager.

Created Adhoc(Simple List,Grouped List,Section Heading,Crossta b and Nested Crosstab)

Reports and represented data graphically by Charts utilizing Query Studio. Created several

different types of Professional Reports (Mailing Labels, Web Page Style, Cascading, Linked /

Drill Through, Production, Business, Ranking, etc…) with complex for matting utilizing Report

Studio and Advanced reporting models.

Created OLAP style presentation for enabling hierarchical browsing within the model .

Created complex Dashboard reports using multiple queries in Report Studio targeting

different Business units, for strategic reporting.

Distributed Reports/Metrics using a single portal interface.

Used PowerPlay Cubes as data sources for creating reports in Report Studio and Analysis

Studio.

Created Pagelets to manage content amon g different user groups.

Responsible for troubleshooting production issues involving Impromptu, PowerPlay and

ReportNet technologies.

Responsible for maintaining quality of reports, datamart and framework manager models .

Created audit reports to monitor user acceptance, top reports and user lists .

Responsible for creating and updating, ETL scripts and stored procedures feeding a Data

W arehouse.

Participated in migrating reports from older versions of Cognos and from several different

sources onto cognos version8.x.

Experience in using Metric Studio to generate reports based on measures.

Experienced in migrating date from cognos version7.x to cognos version 8.x.

Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting

Reports and Multilingual Reports Using Report Studio and Query Studio.

Customized data by adding Filters, Prompts, cascading prompts, Calculations, Summaries,

Functions, Conditional blocks and Conditional reporting. Worked on multiple report pages

and multiple prompt pages.

Submitted to security constraints using Cognos Administrator.

Helped in generating standard reports.

Assisted in end user acceptance testing.

Environment: IBMCognos,cognos 8.1,8.2,8.3,8.4/7 (Framework Manager, Query Studio, Report

Studio, Cognos Connection), Oracle 10g, web server, Informatica and Windows XP.

September 2006 – December 2007

OpenPages Inc, Waltham, MA

Role: Cognos Consultant

OpenPages Sarbanes-Oxley Express (SOX Express) is an enterprise compliance management

solution that reduces the time and resource costs associated with ongoing compliance for

Sections 302 and 404 of the Sarbanes Oxley act by combining powerful document and process

management with flexible reporting capabilities that enables CEOs, CFOs and fin ancial

management officers to enforce internal controls.

Responsibilities:

Used Framework Manager to build models, packages and publish packages to the ReportNet

Server.

Created professional reports in Report Studio and adhoc reports in Query Studio .

Installed and Configured, Cognos 8 and ReportNet in a distributed environment .

Migrated ReportNet 1.1 MR2 packages and reports to ReportNet 8.1 architecture .

Used PowerPlay Cubes as data sources for creating reports in Report Studio and Analysis

Studio.

Created complex Dashboard reports using multiple queries in Report Studio .

Responsible for troubleshooting production issues involving Impromptu, PowerPlay and

ReportNet technologies.

Created audit reports to monitor user acceptance and user lists, making these reports

generated as standard reports.

Configured ReportNet authentication to use Cognos Series 7 namespace

Integrated Upfront entries with ReportNet entries in Cognos Connection and enabled single

sign-on facility.

Migrated Catalogs from Impromptu to ReportNet using the impcat2xml utility.

Experience with taking Java code as one of the source in informatica and took the target

to generate reports.

Environment: Cognos 7.4 (Framework Manager, Query Studio, Report Studio, Cog nos

Connection), SQL Server

CRMIT, India May 2004 - August 2006

Cognos/Informatica Developer

CRMIT is a fast growing market leader in delivering OnDemand CRM Solutions. CRMIT

developed a complete Supplier management solution for European vendor . As part of this we

developed a module to do data extraction and also generated reports to provide comprehensive

information about supplier offerings, track records, transaction history etc.

Responsibilities:

Cognos:

Responsible for developing and mai ntaining the Business Intelligence applications.

Created Dashboard reports in Report Studio and ad hoc reports in Query Studio .

Used PowerPlay Cubes as data sources for creating reports in Report Studio and Analysis

Studio.

Created adhoc query packages targeted at business users.

Migrated and Imported metadata from Impromptu Catalogs.

Responsible for troubleshooting production issues involving Impromptu, PowerPlay and

ReportNet technologies.

Created audit reports to monitor user acceptance, top reports a nd user lists.

Integrated Series 7 with Cognos Connection Portal .

Maintained Impromptu Web Reports in a production environment .

Installed and configured ReportNet 1.1 MR1 in a distributed Windows environment .

Configured ReportNet authentication to use Co gnos Series 7 namespace.

Used Framework Manager to build models, packages and publish packages to the ReportNet

Server.

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

Extensively worked on PowerPlay Enterprise Server for cube deployment in Web.

Informatica:

W orked on extracting data from source systems (Oracle Tables, Flat files), transforming the

data (i.e. standardizing, cleaning, de duping, etc), and then loading and mapping the data into

the corporate data warehouse.

Developed number of Informatica Mappings to facilitate Daily, Weekly and Monthly Loading

of Data.

Created ‘Flash Report’ measures in reporting data warehouse using oracle sources.

Extensively worked with Repository Manager, Designer, Workflow Manager and W orkflow

Monitor.

Created targets in the warehouse designer by generating and executing DDL.

W orked on various transformations like Lookup, Aggregator, Expression, Router, Filter,

Update Strategy, Union and Stored Procedure.

Handled common data warehousing problems like tracking, dimension change using SCD

type2 mapping.

Compared different mappings, transformations and sources using designer compare option.

Ensured timely delivery of required ETL tasks, used workflow manager to schedule different

tasks.

Environment: Informatica Power Center 7.1.4, Cognos 7.4/6.2, Cognos Framework Manager,

Cognos Report Net 1.1, Access Manager 7.4, Cognos EP Series 7 Impromptu 7.0/7.1, Cognos

Power Play 7.0/7.1, Cognos Transformer 7.0/7.1, PL/SQL, Toad 8.5.0, SQL Server 2005/2000,

MS-Access, Oracle 9i/8i, HTML, Java, Windows NT/2000 .

Education:

Bachelors in Computer Science & Engineering from Jawaharlal Nehru Technology University,

India.

References: Available upon request.

Contact this candidate