Manager Sql Server

Gangareddy

Sr. Cognos Consultant

215-***-****

**********.******@*****.***

SUMMARY:

. 7 plus years of professional experience as IT consultant in Design and

development of relational database applications, Data Warehouse/BI

Applications.

. Experience in developing and maintaining Framework Manager Models both

Relational and Dimensionally Modeled Relational (DMR) models.

. Experience on Cognos 8 with Framework Manager, Analysis Studio,Cognos

Connection, Report Studio, Query Studio

. Experience in migrating reports from Cognos Series 7 to Cognos 8.3 and

also troubleshooting and fine tuning the migrated reports

. Experience in database modeling and designing for improved performance.

. Expert in creating and publishing packages in the Framework Manager from

various data sources in Report Net. Generated different kinds of reports

in Report Net, created templates and multilingual reports.

. Experience in installation, configuration and administration of Cognos

8.3/8.4 in a distributed environment.

. Experienced in implementing Cognos SDK and integrating Cognos with the

corporate Reporting Portals.

. Experience in migrating reports from Cognos Series 7 to Cognos 8 BI Suite

. Experience in configuration and setting up security (users/groups/roles

and access privileges).

. Experience in designing Complex Power play Transformer Models for

building the cubes including Externally Rolled up measures

. Expertise in advanced SQL Query writing and PL/SQL programming.

. Expertise in Performance tuning of the existing Cognos Reports and Cubes.

. Working knowledge on different data sources ranging from flat files,

Oracle, PL/SQL Server, DB2 databases, SQL Server and Sybase.

. Highly motivated and focused problem solver with a passion to improve

business processes by implementing innovative business solutions.

. Extensively worked in interacting with Business Users to collect User

Requirements.

. Proficient in programming languages like C, C++, Java.

. Experience in Oracle PL/SQL and database Performance Tuning by

implementing Parallel Execution, Table Partition, materialized views with

query rewriting, creating appropriate indexes, usage of hints, re-

building indexes and also used the Explain Plan and SQL Tracing.

. Experience in writing, testing and implementing SQL/T-SQL/PL/SQL, Stored

Procedures, Triggers and Functions.

. performance tuning in an Oracle environment

. Highly motivated, result oriented professional with a short learning

curve and strong communication skills.

. Web-based application development, framework object development

experience.

TECHNICAL SKILLS:

Cognos 8 BI Suite: Framework Manager 8, Metric Studio, Metric Designer,

Report Studio, Analysis Studio, Query Studio, Event Studio,

Transformer, Cognos Configuration.

Cognos 7 Series: Cognos ReportNet 1.02/1.1 (Report Studio/Query

Studio), Impromptu Administrator, Impromptu, Impromptu Web

Reports, COGNOS Architect, COGNOS Power Play Transformer,

Power Play User, Power Play Web Reports, Power Play

Enterprise server, Upfront Administration, Access Manager

LDAP Server, Configuration Manager, Visualizer and Metrics

Manager. Visualizer, Access Manager, Impromptu Web reports

(IWR), Cognos Metrics Manager 2.2.

Databases: Teradata 6.1, Oracle 10g/9i/8i/7.x, MS SQL Server

2000, DB2, MS Access.

SQL Tools SQL Assistant 6.2, SQL Plus, Toad SQL Loader, SQL Query

Analyzer

Languages/API's: T-SQL, PL/SQL, C, C++, Java, HTML.

Data Modeling: ERwin 4.1/3.5, Visio 2000.

Operating Systems: Windows XP/2000/NT/98, UNIX, LINUX, HP-UX, Sun

Solaris.

WORK EXPERIENCE:

Bank Of New York, Mellon Philadelphia, PA May08-

juy10

SrCognos developer

Previously PNC GIS, Bank of New York is leading provider of

processing, technology and business intelligence processing to asset

managers, brokers and financial advisors worldwide. The project mainly

deals with developing ad-hoc/daily reports to accountants, brokers. The

daily responsibilities include checking of daily loads from sun guard and

gathering requirements from end users(accountants/brokers), developing,

testing and deploying the reports.

Responsibilities:

. Installation and Configuration of the Cognos 8.3 multi server environment

. Worked extensively in administering servers, optimizing performance, and

set access permissions in Cognos 8.

. Administered secured function and features in Cognos 8 that has to be

available for users based on the Job title.

. Involved in gathering the user requirements from end users and worked on

designing the Metadata Models in Framework Manager and published them to

the cognos connection for the report authors.

. Installed Report Net Migration Tool and migrated Impromptu catalogs using

impcat2xml command.

. Migrated Impromptu reports to Report Net using migratetocrn command and

deployed migrated reports to Report Net using deploytocrn command.

. Involved in migrating reports from Cognos Series 7 to Cognos 8.3 and

also troubleshooting and fine tuning the migrated reports

. Dimensionally modeled the metadata using star schema and allow end users

to build their own analysis.

. Worked closely with Database Administrators and Report Developers to

resolve technical issues and coordinate changes that impact user

communities.

. Authored list, crosstab and chart reports using some unique

functionalities of report studio.

. Developed some custom report templates based on user requirements.

. Designed summary and detail reports which involves the key

functionalities of the report studio like conditional blocks, conditional

layouts. Designed reports which involve drill down, drill up and drill

through functionalities in report studio.

. Developed some analysis reports using analysis studio and defined some

Drill-Through Definitions to report studio reports.

. Responsible for troubleshooting Cognos BI Server issues.

. Designing the Power play Transformer Models and publishing the cubes for

the business users to analyze data.

. Creating Analyses from the published cubes using Analysis Studio as per

the Business needs.

. Creating the scripts for the automation of cube building and publishing

. Involving in Production support for the GPA Application

. Reviewing deliverables of peer/team member and coordinating with Offshore

. Involved in the event handling process in GPA using the Event Studio.

. Mentoring the team

. Managed dispatchers and their associated services using Server

Administration Tool.

. Maintained the configuration and change control of all Cognos application

environments and associated documentation.

. Continuously review the application architecture and suggest changes for

improved performance

. Provided support for application development teams to fix issues on day

to day basis.

Environment: Cognos 8.3/8.4,Cognos SDK, SQL Server 2005, SQL developer,

Windows 2003

GeneralMotors, Detroit, MI

Jan '06 - Apr '08

Sr. Cognos Consultant

General Motors (GM) makes a wide portfolio of cars and trucks, with brands

such as Buick, Cadillac, Chevrolet, and GMC. GM also produces cars through

its GM Daewoo, Opel, Vauxhall, and Holden units. Financing and insurance

business is primarily conducted by Ally Financial (formerly known as GMAC),

of which GM owns about a 10% stake. The century-old GM is experiencing

historic financial challenges that threaten the company's longevity. The

company received billions of dollars in loans from the Canadian and US

governments as it restructured, negotiating concessions with its labor

unions and jettisoning brands.

Responsibilities:

. Installed and Configured Cognos 8 on Development, UAT and Production

servers in a distributed Environment.

. Study and analysis of the business requirements gathering and analysis,

understanding client's data warehousing requirements and system analysis

of business process and requirements

. Interacting with the users for understanding of Data Analysis and

gathering business requirements.

. Prepared all the required documents for Cognos objects like design

documents, unit test plan documents.

. Created Models and Packages in Framework Manager.

. Creating Reports using Report Studio and created adhoc queries using

Query Studio.

. Involved with testing team of seven during two phases of retract/rebill

development project. Assigned work, managed test scope, managed defect

stack.

. Testing and improving Report Performance upon report completion for

validation of Calculations & data.

. Created User Groups, Roles in Cognos Connection to implement the

Security Filters in Framework Manager Model

. Setting Data and Object security, giving access permission to objects and

Packages. Created folders, Embedded and Standalone filters, prompts and

complex calculations in Framework Manager

. Expertise in developing Standard Reports, List Reports, Cross-tab

Reports, Charts, Multiple-levels of Drill through Reports and Master

Detail Reports Using Report Studio.

. Good in creating Query Prompts, Calculations, Conditions, Filters,

Bursting Reports and Multilingual Reports Using Report Studio.

. Developed and Published Powerplay Cubes on to Upfront using the Power

Play Enterprise Server.

. Developed Analysis studio Reports and cubes using Analysis Studio

. Created Drill down / Drill Up reports and Combine Filter, User-Defined

Filters, Custom Ranking using Analysis Studio.

. Developed Top 'N' and Bottom 'N' reports in Analysis Studio

. Involved in Cube optimization and troubleshooting to run the cubes in

effective manner

. Developed and Published the Impromptu Reports on to the server using

Report Administrator

. Scheduled reports in Cognos Connection (Web Portal), Organized the

folders for user convenience

. Worked on improving Cognos server performance to optimize speed and

efficiency. Monitored Dispatchers & Services and logs.

. Completed Migrating the Development, UAT and Production Environments

from Cognos Series 7 to Cognos 8.3.

. Involved in gathering the user requirements and specifications for

reporting.

. Creating new catalogs and designing Transformer models as per the

requirements.

. Creating new Impromptu Reports and Cubes and publishing them to upfront

. Involving in enhancements for the OHM and its interface applications in

Java/J2EE

. Designed Metadata Models using Framework Manager and published packages

to Cognos Connection.

. Created List, Crosstab and Chart reports which includes a header and

footer, calculations and prompts.

. Designed custom reports for the case intake users.

. Tested all the reports against UAT and Production from the test cases

provided by Database team.

. Bursted complex reports and scheduled them to improve server performance

and delivered the reports through email.

Environment: Sybase 8.x, UDB DB2, DB Artisan, Web Sphere 5.x, Java,

JMS,JSP,XML, LDAP, Siteminder, Dimensions, Cognos 8.3,Cognos Impromptu,

Cognos Transformer, Cognos Power Play, Cognos PPES Administrator, Cognos

Impromptu Web Report Administrator, Unix Shell Scripting

Verizon, ColoradoSprings, CO Feb'04-

Jan'06

Cognos Consultant

Supplier Data warehouse (SDW) project is developed to keep track of

Supplier Performance. The supplier performance is evaluated based on

parameters like delivery schedules, timeliness, critical shortages etc over

a period. ETL is taken care by jobs running on Mainframes, the DB2 tables

of Data warehouse are loaded with the transformed data using UNIX shell

scripts. Reports are generated using COGNOS tools. The Cognos OLAP cubes

are supported and maintained.

Responsibilities:

. Created Impromptu Catalog by adding tables and hotfiles, & creating new

joins.

. Created Prompts, Calculations, Conditions & Filters and creating New Jobs

using Impromptu Administrator.

. Created Models by using various data sources in Power Play Transformer.

. Created User Classes and Users in Access manager and provided the user

credentials.

. Created extremely big OLAP cubes.

. Used PowerPlay Enterprise Server to publish the cubes and Impromptu

reports to the Upfront.

. Create simple list, grouped list, cross tab, grouped cross tab reports by

using report studio

. Create simple, complex reports using Cognos Report Studio

. Create reports using report studio with multiple charts and reports

. Create relational, OLAP models in Framework Manager and publish the

packages

. Create catalogs and reports in Cognos Impromptu, design the cubes using

Power play Transformer and build & testing of power play cubes.

. Publish reports on Cognos Upfront and create users, user classes, user

groups and grant permissions using Access Manager Administration

. Develop new Unix Scripts for enhancement to existing system using

detailed design documents.

. Migrated the Impromptu catalogs from Cognos 7.3 to Cognos 8.

. As a member of the Automotive Training Team, to train people in

Automotive Business Knowledge and also prepare Warranty cube as a

prototype for Automotive Training.

. Prepare Project Plan and other Quality Documents and also give project

induction and Knowledge transition to new joinees.

. Responsible for analysis of the service requests, Problem identification

and fixing the root-causes, and for requirements gathering and Resolving

Issues.

Environment: Cognos 8.3,Cognos Impromptu, Cognos Transformer, Cognos Power

Play, Cognos PPES Administrator, Cognos Impromptu Web Report Administrator,

Unix Shell Scripting

Sony Corporation, Hyd,india Aug '03 -Jan

'04

Cognos Consultant

Sony's Dealer Data Warehouse contains sales information about Sony's

product line of business around 1200 products across 7,000 dealers with

past three years of data. The system is used to identify sales patterns and

trends based on seasonal promotions.

Role:

. Worked on Informatica Power Center tool (Source Analyzer, Warehouse

designer, Mapping & Mapplet Designer and Transformation Developer) to

transform data mainly from DB2 and Flat Files and load that data to

Oracle.

. Understanding Financial Services Accounts and sales process.

. Created Catalogs to meet the reports requirements.

. Created the calculations, conditions, and prompts, organized the folders,

set up user classes and Security.

. Interacted with end Users to identify key Dimensions and Measures and

Levels. Created Power Cubes.

. Involved in design, development and maintenance of catalogs, created

Impromptu reports and IQDs using Impromptu Administrator.

. Create simple, complex reports using Cognos Report Studio.

. Deployed the Power Cubes on Cognos PowerPlay Enterprise Server.

. Created multiple layer reports providing a comprehensive and detail

report with Drill through facility.

Environment: Cognos 8.3,Cognos Impromptu, Cognos Transformer, Cognos Power

Play, Cognos PPES Administrator, Cognos Impromptu Web Report Administrator,

Unix Shell Scripting

Contact this candidate