Sandeep. G [pic]

Mobile: (***) ***

**** *** ****** *********

Email:

acpbpc@r.postjobfree.com

Professional Summary

> TOTAL 10 YEARS OF EXPERIENCE IN IMPLEMENTING BUSINESS INTELLIGENCE

SOLUTIONS USING COGNOS BI AND INFORMATICA SUITE IN DIFFERENT

ENVIRONMENTS.

> Knowledge of complete BI Life Cycle Development process.

> Having strong knowledge on Data warehousing Concepts.

> Extensive experience in gathering and documenting user requirements.

> Good understanding of Multi Dimensional Modeling using Star and

Snowflex Schema.

> Developed reports in Cognos 8/10 BI Suite using Report Studio, Query

Studio, Analysis Studio, Cognos ReportNet (Report studio, Query Studio)

and in Cognos Enterprise Series 7 using Impromptu and Power Play for

windows.

> Extensive experience in installation and configuration of Cognos 8/10

Environments

> Expertise in Bursting and Scheduling of Reports.

> Proficient in designing complex reports using Conditional Prompts,

Filters, Cross Tab, Graphs, Chart, Dynamic Reports, Dash boards, Multi

Query reports and Drill-Through Reports.

> Worked on Security access to clients using Access Manager and worked

with Data Security, Object Security, and Package Security.

> Extensively worked on Informatica tools such as Informatica Repository

Manager, Designer (Source Analyzer, Warehouse designer, Mapping

designer, Transformations & Mapplets).

> Expertise in Deployment using Cognos Connection Portal in Cognos 8/10.

> Extensive experience in Migrating to Cognos 10.2/10.1 from 8.2/8.3/8.4

versions.

> Extensive experience in Cognos BI Life Cycle Manager.

> Extensively working on Oracle 10g, 11g and DB2.

> Extensively working on Design, Installation, Configuration,

Administration, Maintenance and Upgrade of Cognos8 BI servers on DEV,

UAT and PROD Environments.

> Working on Operational support coverage to solve technical problems

7/24(365 days), Code deployments, User Administration, Non-Prod

environment support, Development support, Automation Support, Net-

backup support, all scheduled jobs to build reporting objects in the

environment maintaining system and server performance, server

administration including disk usage, memory usage, server monitoring.

> Performing monthly Disaster Recovery, upgrades and applying Cognos code

fixes, Application server fix pack as applicable.

> Experience with the design and delivery of Extraction Transformation

and Loading ETL tool and applications including decision support

application development approaches, methodologies and technologies

(OLAP, MOLAP, ROLAP, OLTP, Informatica Power Mart 7.1/8.1 Power Center

7.1/8.1 Designer, STAR Schema, SNOW-FLAKE Schema design, ETL and UNIX).

> Extensively working on daily vaulting, weekly vaulting NetBackups on

Veritas NetBackup 6.0 Enterprise Server.

> Extensive experience install configure and Maintain SQL Server

Databases.

> Built Multidimensional cubes using PowerPlay Transformer.

> Good Knowledge on Informatica & Data Stage tools as ETL Developer.

> Proficient and hands on experience with Informatica & Cognos Data

manager/ Decision Stream.

> Develop the Informatica mappings/workflows/worklets/session.

> Experience in testing the data consistency between Source System - DW

and DW-Report.

> Excellent analytical and communication skills, ability to work

independently and also a good team player.

> Good experience in training end users.

> Ability to rapidly learn new concepts together with excellent

interpersonal skills.

> Exceptional communication, analytical, presentation and problem solving

skills.

> Excellent skills in understanding business needs and converting them

into technical solution.

> Experience in handling tickets for production support.

> Good experience in analysis, design, testing, development and

implementation of client/server applications.

> Deploy the Cognos code (Transformer models, Framework Models/Packages,

reports and cube views) from Dev to UAT and from UAT to Production

environment.

> Installation of patches in Cognos or Microsoft or windows.

> Make sure to balance the load on the servers.

> Closely monitor the servers during month end.

> Managing the current activities.

> Reboot the servers on weekly basis on sequential order.

> Managing the Dispatchers and services.

> Guide the Cognos developers to follow the project standards at the time

of designing.

> Set up the security to projects.

> Creating the Data source connection for an application

> Create Users, user groups in Cognos access manager and associate them

into Cognos connection.

> Installation and configuration of cognos software in new developer

system.

> Creating a profile and grant the access to new developers.

> Make sure to take the backup of code.

> Maintaining the source code in configuration management.

> Make sure to deliver the scheduled reports on daily/weekly/monthly.

> Certified in COGNOS BI.

Technical skills

OLAP Tools : Cognos 10.1/8/7 BI (Framework Manager, Query Studio,

Report Studio, Analysis Studio, Metric Studio and

Event Studio, Cognos Connection, Power play

Transformer, Workspace, Workspace Advanced, Business

Insight, Cognos cube Designer, Access Manger, Cognos

administration.),Cognos EP 7 (Impromptu,Web Reports

(IWR)), Upfront, BOXI3,Crystal reports 9.0. IBM Web

Sphere Application Server,OBIEE, SSRS,SSIS,SSAS,

Micro strategy, Access Manager, Hyperion Essbase,

Hyperion DRM,, Hyperion Essbase, Hyperion DRM,SAP

BPC .

ETL Tools : Informatica8/7, Data stage,

Data Manager8.4, Abinitio, SSIS.

Databases : Oracle 11g/8i//9i/, MS SQL Server, DB2,

SQL Server2008, Teradata.

Database Tools : Toad, WINSQL.

Languages : C, C++, Java, .NET, COBOL, Pascal,

FORTRAN, HTML, XML, Visual Basic 6.0,

PL/SQL

Operating Systems : Windows NT/98/2000//XP,

Unix/Linux, AIX Sun-Solaris.

Web services : Java/ Web Server, IIS 4.0/5.0, Netscape

Directory Server, Apache Web

Tomcat 4.01. IIS, Sun Salaries, Red Hot, Linux,

UNIX.

Other Tools : Adobe Photo Shop, MS Office2003, MSAccess,

MSExcel.

Education:

. Masters from Osmania University, Hyderabad.

Certifications in Cognos:

> IBM Cognos 10 BI Metadata Models Certified Professional

> IBM Cognos 10 BI Reports Certified Professional

> IBM Cognos 10 BI Administrator Certified Professional

Professional Experience

Client: BMW

Dec'

10 - Till Date

Role: BI Consultant

Project Name: - BI Support

Location: Woodcliff Lake, NJ

Key Responsibilities:

. ANALYZED THE BUSINESS PROCESSES, DATA ANALYSIS REQUIREMENTS AND

DEVELOPED SPECIFICATION DOCUMENTS FOR REPORTS AS PER CLIENT

REQUIREMENTS.

. Deploy the Cognos code (Transformer models, Framework Models/Packages,

reports and cube views) from Dev to UAT and from UAT to Production

environment.

. Installation of patches in Cognos or Microsoft or windows.

. Make sure to balance the load on the servers.

. Closely monitor the servers during month end.

. Managing the current activities.

. Reboot the servers on weekly basis on sequential order.

. Managing the Dispatchers and services.

. Guide the Cognos developers to follow the project standards at the time

of designing.

. Set up the security to projects.

. Creating the Data source connection for an application

. Create Users, User Groups in Cognos access manager and associate them

into Cognos connection.

. Installation and configuration of cognos software in new developer

system.

. Creating a profile and grant the access to new developers.

. Maintaining the source code in configuration management.

. Make sure to deliver the scheduled reports on

daily/weekly/monthlyEnsure the timely and quality deliverables of

Cognos and Informatica tasks assigned to me.

. Managing the Dispatchers and services.

. Set up the security to projects.

. Make sure to deliver the scheduled reports on daily/weekly/monthly.

. Extensive experience in Migrating to Cognos 10.2/10.1 from 8.2/8.3/8.4

versions.

. Extensive experience in planning and implementation of: Cognos server

scaling, Cognos architecture, Cognos capacity planning, Cognos load

testing,Cognos query/performance tuning, Cognos failover, Cognos load

balance, Cognos advance routing, Cognos back-up and recovery

. Extensive experience for the health of the Cognos 10 BI environment

DEV, QA and PROD.

. Extensively managed the security of the Cognos 10 BI environment.

. Extensive experience in monitoring all scheduled jobs including reports

for business users, ETL jobs

. Extensive experience in setting up standard and architecture of the

meta data layer

. Extensive experience in Staging Layer, Core Layer, Semantic Layer

design and data modeling to meet the business requirements semantic and

presentation layers.

. Extensive experience in providing performance monitoring and tune

services on BI server platforms

. Extensive experience in ensuring stability given large, uneven requests

of BI environment for reporting and adhoc analysis

. Extensive experience in setting up and manage multiple environments for

application and report development, testing, training and production

environment

. Strong experience in Setting up and manage domain groups/access rights

(Name spaces) for BI platform users

. Strong experience in follow change management process and procedures to

perform production migrations from test and other environments

. Extensive experience in documenting installation steps, environments

custom configurations, production system changes and technical

architecture platforms

. Extensive experience in assisting developers with test planning, test

conditions and obtaining test data

. Extensive experience in supporting Cognos reports, cubes migrate to

different environments

. Performing in-depth and comprehensive system, application and user-

object troubleshooting - coordinating with users, other department

personnel, vendors and service technicians

. Extensive experience in consult with business community to gather

requirements for specific BI scorecard, dashboard and reporting needs.

. Extensive experience in Cognos 10 Administration to work in a fast

paced environment.

. Extensive experience in multiple server environments in distributed

architecture, with plans to upgrade to 10.1.1/10.2.1.

. Extensive experience in work on problems of diverse scope with moderate

to high complexity

. Extensive experience in root-cause-analysis, problem identification and

resolution, optimization and performance tuning, security, backup and

data recovery.

. Extensive experience work closely with the client to design,

implements, and architects an enterprise environment that spans

multiple divisions and groups, and integrates data and processes

throughout the organization.

. Strong expertise in the following functional area such as Security

Management, Patching and applying bug fixes, Performance Tuning, Backup

and Recovery.

. Monitored System Performance (identifying the no of items in the queue)

using Metrics available in Cognos Administration.

. Strong experience in installation of products and Cognos Modules,

experiences working with Cognos support and ticket escalation

. Extensive experience in Participate in the design and development of

enterprise-wide data repositories.

. Extensive experience in Design and validate Cognos Framework Models as

assigned, working with BI analysts and DBAs to ensure appropriate

database views and/or tables are available to support the Framework

information needs and that accurate information is presented through

the framework.

. Provided guidance on and adhere to best practices in Cognos Framework

design and development as well as change management.

. Extensive experience in performance tuning/optimization of the

Framework in coordination with database layer tuning performed by the

DBA and application team.

. Make recommendation to improve the efficiency and functionality of the

database and Cognos BI environment

. Designed and developed scorecards, dashboards and multi-dimension data

cubes using Cognos

. Developed and executed a verification and security strategy to ensure

the accuracy of the data distributed in the reports

. Design the different documents like Requirement Specification and Low

Level Design Documents for Reports.

. Prepare the Test cases for Cognos reports and Informatica Mappings.

. Creation of reports based on simple, medium and complex using Cognos8

and 10.

. Do the Unit testing for accuracy of the reports.

. Fixing the issues of defects during the monitoring.

. Analysis of the ETL Mappings/Sessions/Workflows/Worklets in

Informatica.

. Monitor the ETL mappings/jobs during the Production Support.

. Extensively worked on Informatica tools such as Informatica Repository

Manager, Designer (Source Analyzer, Warehouse designer, Mapping

designer, Transformations & Mapplets),

. Responsible for Extracting, Transforming and Loading data from Oracle,

Flat file and lacing it into Data warehouse.

. Design and Development of Mappings, Mapplets using Informatica Power

Center.

. Failure analysis for Informatica loads using Error logs.

. Configuring Repository Manager, created folders and managed objects in

repository manager of Informatica.

. Creating Informatica mappings to build business rules to load data.

Most of the transformations were used like the Source qualifier,

Aggregator, update strategy, Router, Expression, lookups, Filters &

Sequence Generator.

. Managing the current activities.

. Follow up with Users for any clarifications.

. Fixing all issues which are raised in Remedy Ticket tool by Users.

. Creating the Data source connection for an application

. Design the cognos reports as per the deadline.

. Validate the reports with Users.

. Preparation of the KT plan.

. Arrange KT sessions for new support applications with planned time

table.

. Give estimations for new developing reports/TPA.

. Executed the Cognos migration project from Impromptu to Cognos8 for UK

Apps.

. Maintain good relationship with Customer/Superiors/Team members.

. Configuration of Cognos content store.

. Identify risks and communicated to Supervisor.

. Guide the Cognos developers to follow the project standards at the time

of designing.

. Developed the Best Practices method for Creating Report Template,

Report & Prompt Page, Governor Settings and Report Naming Convention in

Cognos 8.4 &10.

. Designed very informative and efficient relational models using

functionalities like Shortcut Alias only available in Cognos 8.4

Framework Manager.

. Created Executive Dashboards to represent the financial data

. Deploy the Cognos code (Transformer models, Framework Models/Packages,

reports and cube views) from Dev to UAT and from UAT to Production

environment.

. Installation of patches in Cognos or Microsoft or windows.

. Monitored System Performance (identifying the no of items in the queue)

using Metrics available in Cognos Administration.

. Scheduled and Distributed 8/10 BI reports using Schedule Management in

Cognos Connection.

. Created new Groups and Roles in Cognos 8 and associating with the new

packages.

. Setting up New Users in Access Manager and giving them the required

permissions.

. Business User Training to get them familiarized to Cognos Connection

environment and also helped them in the transition from Series 7

Upfront to Cognos Connection.

. Demonstrated the Cognos 8/10 environment, tools with their

functionality.

. Reboot the servers on weekly basis on sequential order.

Environment: Cognos10.1(Cognos Connection, Framework Manager, Report

Studio, Query Studio, Analysis Studio, Metric Studio and Event Studio,

Configuration Manager, Power play Transformer, Cognos cube Designer, Access

Manger, Workspace, Workspace Advanced, Business Insight, Cognos

Administration),Informatica,Teradata,Oracle11g,MSSQL Server.

Client: GE

Nov'08 - Dec'10

Role: Cognos Administrator/Modeler/Developer

Project Name: - Forecast Datawareshouse

Location: Albany, NY

Key Responsibilities:

. Requirement Analysis & Estimation Interaction with business

users/analysts to clarify doubts and provide technical inputs to

them." Analyze the complexity of the requirement and communicate the

effort estimate to client.

. Functional understanding of existing and new reports

. Functional understanding, documentation of tactical and strategic client

mart.

. Business requirement analysis. Conversion of business requirements into

technical understanding.

. Involved in gathering Onsite-Offshore connectivity requirements and

setting up the connectivity at offshore.

. Proficient in implementing user level and data level securities within

Cognos 8

. Strong experience in Cognos server build, Sizing, troubleshooting,

tuning,POC & disaster recovery exercises.

. Extensive experience of data warehouse modeling, architectures, OLAP,

OLTP data sets.

. Proactively monitoring threshold/s setup in Cognos 8 environment.

. Strong expertise with tuning Cognos BI OLAP components for faster access

and performance (i.. Transformer, PowerPlay Cube, PowerPlay Client and

PowerPlay Studio)

. Extensive experience install configure and Maintain SQL Server Databases

. Successfully completed Cognos v8.4 upgrade for the various reporting

suites to the defined scope, project plan and implementation plan to

specified timeline.

. Extensively working on the configuration of the Cognos environments such

single server and multiserver components, failover, load balance

mechanism including the underlying WebShere Application Server and

database components such as Audit and Cognos Content Store.

. Daily, Weekdays, Weekend, off-hour Support to developers with the

Cognos framework engineers, as needed, to assist in problem

determination of complex issues including assistance in analyzing

application performance problems.

. New Development, Enhancement, Maintenance and Migration of applications

in the Development tower.

. Experience with migration of hot files, catalogs, reports, power play

Transformer cubes from Cognos Series 7.1/7.4 to Cognos 8.2 using

Migration Utilities.

. Customize the Cognos connection portal using existing portlets and

customized tabs.

. Developed List, cross tab, drill through, master-detail, chart and

complex reports which involved Multiple Prompts, multi-query reports,

Burst Reports and Dashboard reports against database.

. Creating cross-tab reports and chart reports using multiple queries and

drill down capabilities in a single report to meet the business needs.

. Created Cubes (MOLAP/ROLAP) using IQD's which were built in Framework

manager and DMR Metadata Modeling.

. Supported Cognos Transformer models and cubes. Involved in implemented

security at transformer level by creating custom views. Created

Calculated Measures in Transformer.

. Working with Informatica Power Center client tools like Source Analyzer,

Warehouse Designer, Mapping Designer and Transformation Developer.

. Developed the Mappings/Worklets/Workflows/Sessions in Informatica.

. Fixing the issues of defects during the SIT.

. Using Developed SQL scripts for business data loads.

. Imported data from various Sources transformed and loaded into Data

Warehouse Targets using Informatica client Tools.

. Involved in Unit testing, System integration and UAT.

Environment: Cognos 8.2 (Framework Manager, Report Studio, Query Studio,

Analysis Studio, Cognos Connection,

Metric Studio and Event Studio, Configuration Manager Cognos

Administration), CognosEP7 (PowerPlay7.1/7.4,

Impromptu7.1/7.4,PowerplayTransformer),Informatica,Oracle,DB2,Windows

2000sever, Cognos Migration tools.

Client: Electrolux, NA, US

Oct'07 - Oct'08

Role: Cognos Developer

Project Name: BI - Support

Responsibilities:

. Created metadata models, made appropriate Joins, organized Folders

according to the Business view and published the packages using Framework

Manager onto Cognos Connection.

. Designed various types of reports according to end user requirements.

. Applied advanced formatting features to the reports using Query Studio

and Report Studio.

. Developed Rank reports and Section reports using Query Studio.

. Designed reports with conditional formatting.

. Designed reports using cross tab.

. Developed single select and multiple select cascading prompts.

. Scheduled reports using cognos connection Web portal.

. Created master detail relationship report.

. Extraction of data from source systems present at different physical

locations both for historical load and ongoing processes.

. Worked with Blocks in simple list reports.

. Loading the transformed data into the data warehouse.

. Testing the Cubes data for accuracy and monitoring the BI Portals.

. Running the job streams manually when required.

. Monitoring the nightly jobs using Tivoli Scheduler and fixing the issues

on daily basis.

. Created Views for Generating reports.

. Extraction of data from source systems present at different physical

locations both for historical load and ongoing processes.

. Handling the enhancement work.

. Provided administrative support for production issues.

. Involved in Creating Content store, installation and configuration of the

Cognos8

. Involved in design and development of joins, filters, calculations and

conditional variables in DMR Packages within Framework Manager.

. Created complex reports using Report Studio and Ad-hoc web based reports

using Query Studio.

. Published Impromptu Web Reports (IWR) and PowerPlay cubes & reports onto

the Upfront using Cognos IWR administration as well as PowerPlay

Enterprise Server

. Performed Pivoting, Drill-down, Slice & Dice and Filtering operations

done for all OLAP applications.

. Extensive experience in Exceptional highlighting, sorting and ranking.

. Performance tuning power-Dynamic cubes (IQD) to reduce Query time and

Partitioned Cubes.

. Involved in Scheduling reports using Cognos Scheduler.

. Trained end users on Query Studio for Ad-hoc reporting as well as

involved in the Documentation.

Environment: Cognos 8 BI(Report Studio, Query Studio, Cognos Connection,

Framework Manager, Cognos Administration), Cognos EP,Impromptu Web Reports

7.3, Power play Transformer 7.3, Cognos Data Manger, Decision Stream

designer,DB2,MS SQL Server, Windows 2K.

Client: AT & T, US

Oct'05 -

Sep'07

Role: Cognos/Informatica Developer

Project Name: - Database of Records (DBoR)

Responsibilities:

. Analysis of the specifications provided by the clients

. Responsible for gathering/refining requirements from the customer for

developing reports.

. Loaded operational data from Oracle, Flat Files into transient Tables and

cleaned the data using appropriate business rules.

. Worked on Informatica power center, Source Analyzer, Warehouse Designer,

Mapping Designer and Workflow Manager.

. Implemented Expression, Aggregator, Sorter, Lookup, Update Strategy,

Filter Transformations.

. Developed reports in report studio.

. Implemented filters, prompts, Formatting, Look and Feel and drill

through capabilities

. Designed various types of reports according to end user requirements.

. Developed simple as well as complex reports using Report Studio.

. Developed standard templates which could be used as foundation of all

reports.

. Designed reports with conditional formatting and drill through.

. Created multi page reports using conditional layouts.

. Involved in creation reports with value prompt, select and search prompt.

. Created the reports on daily, weekly and monthly basis.

. Prepared the unit test cases.

Environment: Informatica Power Center, Cognos, Windows XP and Oracle.

Contact this candidate