Cognos Analyst Resume

Title
Cognos Analyst

Primary Skills
Experienced in implementing large-scale apps with leading technologies in Data warehousing and Business Intelligence.

Location
US-CA-Torrance (will consider relocating)

Posted
Jun-04-09

Over 7 years experience in software industry having worked for Fortune 500 and Multinational companies which includes DirecTV, Mattel Inc, Daimler Chrysler, General Electric (GE),. Experienced in implementing large-scale applications with leading technologies in Data warehousing and Business Intelligence. Strong knowledge in reporting tools like Cognos 8, ReportNet, Framework Manager, Cognos Connection, Impromptu, Impromptu Web reports (IWR), PowerPlay, Transformer, Access Manager, Upfront, Business Objects. Experience working with ETL tools like Informatica Power Center and Data Modeling tools like ERWIN (Star and Snowflake Schema), Power Designer 9.0. Involved in complete software development life cycle (SDLC). Excellent interpersonal and communication skills along with exceptional teamwork experience gained in multicultural organizations. Member of Project Management Institute (PMI) and an active member of the discussion group at www.ITtoolbox.com.

Education & Accreditation
* ITIL Certified
* Oracle Certified Professional (OCP)
* Microsoft Certified Systems Engineer (MCSE)
* Post Graduate Diploma in Computer Applications (DOEACC)
* Bachelor of Science in Computer Applications, Osmania University (B.S)
* Graduated in Software System Management from NIIT (GNIIT)

Technical Skills
Operating System Methodologies & Technologies Mainframe
* Windows (XP/NT/2000) * Object Oriented Programming Techniques * AS400 * TSO
* Unix (Sun Solaris / AIX) * Client Server Technology * CLICS * CICS
* Red Hat Linux * MS-DOS * Multithreading, Multitasking Data Modeling Tools
Programming Languages * PMI PMBOK * Suntone * Power Designer 9.0
* C, C++, VC++ * SQL,PL\ SQL * Rational RUP * ISO 9000
* 6 Sigma * Erwin 4.1 * Cognos Architect
* Cobol, CICS * Perl OOAD Tools ETL Tools
* Java * JSP, J2EE * Rational Rose * WSAD * Informatica PowerCenter 7.1
* Unix Shell Scripting * Front Page * Ultra Edit * Oracle Warehouse Builder
Application Servers Network * Cognos Decision Stream 6.5
* IIS * JRun * VPN(Virtual Private Network) ORDBMS / Database Tool
* IBM WebSphere 4.0 * Microsost Active Directory Server * TCP/IP * SSO * MSSQL Server * Oracle 9i
* BEA Weblogic 5.1 * iPlanet * Troubleshooting/ Configuration * Sybase
* Toad * MS Access
* Cognos Enterprise Server * Firewall Setup * DB2 UDB 6 .1 * Carisma
Web Technologies OLAP Tools Reporting Tools
* HTML * DHTML * XML Cognos PowerPlay Transformer OLAP Modeling * Transformer Unix * Impromptu Report Builder 7.0
* Java Script * ASP PowerPlay Enterprise Server Administration * Putty * Impromptu Advanced Report Building
* Visual Basic 6.0
Groupware Access Manager Administration * Humming Bird * Impromptu Administration
* Sametime * MS Project * Upfront Administration * Impromptu Web reports (IWR)
* Adobe Suites * Lotus Notes * Business Objects 6.0 * PowerPlay Data Exploration
for Client
* Visio * Outlook * Informix (ROLAP) * Crystal Reports * PowerPlay Report Building 7.0
* Cognos NoticeCast * Crystal Enterprise 8.0 * Cognos
Visualizer * Cognos
ReportNet
ITIL Tool - Service Desk Project Management - Plan View

Professional Experience
DIRECTV IT Principal Analyst Mar'2007 - Jan' 2009
Worked as an IT Principal Analyst for IT Operations and Governance Team.
* Responsible for development of Cognos reports for Governance and Change Management using Cognos 8, Report Studio, and Query Studio.
* Responsible for gathering report requirements, creating functional specifications and report rationalization.
* Worked as a Project Manager for Cognos Server Upgrade Project. Which involved scoping the project, resource planning, coordination with Cognos Corp, Designing AID (Application Interface Diagram) and TAD (Technical Architecture Diagram) to set up new servers for Cognos development and production environment and upgrading to Cognos 8.2 and later on to Cognos 8.3
* Managed the Data Source (CA - Service Desk) upgrade project. I was responsible to ensure smooth transition of Cognos reports, Cognos framework manager models and security objects to the new version of Service Desk (a CA tool which was the Data Source).
* Developed List and Crosstab Reports for core and non-core production activity in different time zones.
* Prepared user manual for Directv Self-service portal to access IT Ops and Analytics reporting.
* Developed Framework Manager Models and Package for service desk, scorecard reporting etc.
* Created calculated columns for Open Date, Close Date, and Resolve Date in different time zones and to display time in specific format.
* Developed report studio report to track the health of the application and impact of Releases on Operational Systems.
* Developed complex Report Studio reports to monitor the 'State Of Production' of Open, Closed and Still Open Problems, Incidents and Request.
* Created crosstab reports, line charts and graphs of Deferred Defects after a Release.
* Developed reports using Conditional Layouts and condition expression like String Variable and Boolean Variable.
* Developed reports for Service desk to identify the root cause for Incident Management and Problem Management. Created reports using Sections for each Root Cause.
* Developed Detail and Summary reports based on management hierarchy with Drill Down and Drill Through capability.
* Developed Cognos reports using Combination Chart and Gauge (To demonstrate Top 5 SLA's).
* Developed prompted reports using different prompts like Value Prompt, Date and Time prompt etc.
* Created queries in report studio using Join and Union.
* Developed Report Views to organize reports in Cognos connection and to distribute reports based on security.
* Developed reports using Master Detail Relationship.
* Wrote complex Queries and Case statements to design Report Studio reports.
* Developed Executive Dashboard for Self-service reporting using Cognos portal and Cognos Portlet (Cognos Viewer).
* Created Monthly and Weekly IT Ops Business Review Slides using Cognos Office Connection.
* Used Access Manager and Cognos Connection to setup security for domestic and international customers. Setup Groups and Roles in Cognos Connection.
* Schedule Management - Schedule daily, weekly and monthly reports in different formats and output version.
* Developed complex cross tab and list reports for Scheduled and Unscheduled Outages, Weekly Core, Non-Core Applications.
* Completed ITIL certification.

Mattel Inc Cognos Analyst Mar' 2005 - Mar' 2007
Worked as a Cognos Analyst in Enterprise Data Warehouse team. Responsibilities include development & support of enterprise wide (Fisher Price, Barbie, American Girl, Hot wheels etc.) Cognos Reporting & Administration;
* Central Point of Contact for Cognos Issues. Supporting international as well as domestic customer base.
* Developed Executive Dashboard and Sales Dashboard using CRN.
* Supported different Cognos reporting applications like Project Accounting, Accounts Receivable, Sales, Finance etc
* Business Analysis of daily, weekly and monthly forecast planning for Sales & Marketing, Inventory, Warehouse Management, Market Demand & Availability etc
* Involved in daily scrum meetings for Project management and timely deliverables.
* Designed Framework Manager Models and Packages.
* Administration activities using Cognos Connection for deployment of packages, user security, setting up user groups, schedule management etc.
* Developed user validation reports using Query Studio & Report Studio, Powerplay client, Upfront.
* Bursting reports, event handling, scheduling jobs using CRN.
* Developed Power cubes based on daily\weekly forecast requirement.
* Created Dashboards using Report Studio.
* Used Informatica Power Center to create source flat files for transformer cubes.
* Wrote UNIX shell scripts to build, copy, publish power cubes.
* Worked with Putty client program SSH, Telnet, FTP
* Used Humming Bird Network Connectivity to communicate with UNIX environment.
* Scheduling jobs using UC4
* Tracking user request using System Request Tracking.
* Setting up user class security using Access manager.
* Efficiently interacting with user community to support & development of Cognos Objects.


Daimler Chrysler Cognos Analyst Mar' 2004 - Feb' 2005
* Extensively worked on understanding the business requirements and designing applications to meet the end user requirements.
* Involved in HR Business analysis. Creating daily\weekly\monthly cubes based on Payroll analysis, Employee Absenteeism, Turnover etc
* Experience working with System Development Life Cycle (SDLC).
* Involved in design, development and maintenance of catalogs, created Impromptu reports, templates, hot files, PDF files, snapshots, drill through, IQDs using Impromptu Administrator.
* Created standard, Cross-tab reports and Free-style reports using Impromptu.
* Created different types of Prompts as per specification.
* Created different joins and views according to specification.
* Created reports using Cognos ReportNet.
* Designed Transformer model, created PowerCube's, Dimensions, Levels, Measures, Categories, User Classes using PowerPlay Transformer.
* Created Reports using PowerPlay and published to Upfront.
* Created user profiles to control user access, mapping these user classes to the user profiles in Impromptu Web Reports (IWR) Administration.
* Responsible for performance tuning
* Designed and Developed the HTML pages for a user to view data based on Multiple Selection using Impromptu Power Prompts
* Used Access manager administration to setup and maintain, in one central location, secure user access to data such as reports and queries that are created in other cognos applications.
* Worked with Configuration Manager to specify a runtime authentication source (Runtime security).
* Involved in Installation of Cognos tools, configuring access manager, creating .csa and .lae files.
* Provided Basic Signon and Operating System Signon based Authentication to users.
* Used PowerPlay Enterprise - Server Administration to Manage the OLAP environment, deploy cubes and reports for the enterprise, control drill through access, printing and publish settings. Monitor and optimize server performance.
* Worked with Cognos Server Administration to install, upgrade, manage and maintain Cognos components across the organization.
* Experience setting up domain groups and assigning access rights to userids and groups using LDAP software like iPlanet, Microsoft Active Directory, Netscape Directory Server.
* Wrote scripts in Cognos Script Editor to run as un-attended automated process or to run interactively, the scripts are used to.................
- Update the Transformer Model with UserClasses from Access Manager.
- Back-up the Transformer Model.
- Update the Target Dimension to use UserClass Custom Views equal to each UserClass.
- Back-up the PowerCubes.
- Update the PowerCube with UserClasses from the Transformer Model
- Generate the PowerCubes.
- Export Impromptu Report result sets as CSV\PDF\Excel\ASCII files.
* Worked with Cognos Scheduler to execute automated task locally and on server, on a set date and time or recurring intervals.
* Also used Transformer Unix to handle large Data Sources, for easier integration of cube builds and Data Warehouse updates, to get increased Performance, for scheduled cube creation, for faster processing and for Production support.
* Involved in documentation of SOP's (Standard Operating Procedures) and user training.


Netrion Corporation Cognos Developer Dec' 2003 - Mar' 2004
SQL * International
* At ETL stage, worked with multiple source data extraction and data transition from existing production system to test environment.
* Creation of extraction, transformation, loading model using Cognos DecisionStream 6.5
* Created Star Schema using fact and dimension Tables.
* Created dimensions, levels and hierarchies.
* Developed the job streams for scheduling the jobs.
* Created data aggregation, data extraction, and data staging using Cognos DecisionStream 6.5
* Used Data Mining to analyze the data and establish relationships and identify patterns.
* Rationalized Suppliers list for the entire system.
* Involved in design, development and maintenance of catalogs, complicated reports using different types of drilldowns and multiple prompt selections.
* Extensively used PowerPlay Transformer to move relative data mart data into power cubes and cube groups. Assessed data source and organized data into dimensional maps and transformer model by establishing joins between multiple queries.
* Installed Cognos / IWR / PPES servers.
* Designed and Developed Impromptu Web reports (IWR).
* Worked with client to configure the product and enable client access to Cognos tools. Optimized queries to perform on-line analytical processing and data mining through PowerPlay reports.
* Defined, created, maintained and published power cubes and Impromptu web reports. Automated reports and cube generation through scheduler using macros.
* Designing and Developing Cognos reports using ReportNet with the supporting database software like Oracle 9i, MS-SQL Server 7 etc.
* Used Cognos Visualizer to create multiple 2D and 3D chart types, color-coded drillable maps, animated reports etc.
* Experience working with Business Analysts or End Users to identify and document new system requirements.

General Electric Capital International Services in IT Inc. (GECIS IT Services) Data Warehouse Architect Dec' 2001 - Dec' 2003
Achievements as a DWH Architect
Data Modeling Erwin
* Involved in the data modeling, starting from gathering the user/ business requirements to designing the data mart, basically Star Schema, with the team of five and under the Data Architect expert.
* Major contribution in the data modeling is to gather information in the development server databases indexes and stored procedures helpful in the data modeling for faster query access.
* Involved in Star Schema design in Erwin 4.1 using logical and physical model type.

ETL with Informatica:
* Proficient in Informatica Power Center 6.1, Oracle 9i, PL/SQL.
* Extensively worked on Informatica Tools - Source Analyzer, Warehouse designer,
Mapping designer, Mapplet designer, Transformation developer.
* Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Also tuned for better performance.
* Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
* Developed Mapplets using corresponding Source, Targets and Transformations.
* Used transformations like Aggregators, Connected & unconnected lookups, Filters & Sequence and many more.
* Extensively involved in creating Database triggers, Stored Procedures using PL/SQL.
* Wrote monitoring scripts using UNIX shell programming.
* Worked on Data Extraction, Data Transformation, Data Loading, Data conversions and Data Analysis.
* Testing applications and Running Batches created in Informatica server manager through job scheduler (Autosys) and also from Informatica server manager.
* Schedule, Run Extraction, Load process and monitor sessions by using Informatica Server manager.

OLAP Tool Business Objects\ Cognos:
* Responsible for the Designing the universe by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
* Created the reports (Master/Detail, Crosstab, Chart templates and out line reports) in Business objects and Web Intelligence using the universes as the main data provider.
* Used Crystal Enterprise, a Web-based system for reporting, analysis and information delivery.
* Automated report distribution and scheduled reports to run regularly using Crystal Enterprise.
* Created the dimensions & cubes using PowerPlay Transformer.
* Generating various reports using Cognos Impromptu Web Reports (IWR) like Sub Reports, Drill Through Reports, Cross Tab Reports and implement time Scheduling to reports by Congos Scheduler 6.0.
* There were two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.

Source and Target Database
* Extensively used ETL and Informatica to load data from MS SQL Server, MS Access, Excel spreadsheet, ASCII files, DB2, Sybase into the target Oracle 9i database.
* Extracted and transferred Source Data from MS SQL Server into Oracle
* Supported the process steps under development, test and production environment.
* Wrote Unix shell scripts for database monitoring and maintenance.

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Torrance, CA | Resumes in California

View other Cognos Analyst resumes, Business Analyst resumes