Manager Data
Resume:
Prasanthi Guduru
prashanthig**@.gmail.com
Experience in IT includes extensive
•
Functional and Technical experience in Physical and Logical data model
design, Data Warehousing, Designing Decision Support System, Business
Intelligence (BI) Reporting, ROLAP Cubes, OLAP Cubes, Database
Administration, SQL & PL/SQL programming.
Extensive experience in Business
•
Intelligence Tools using Cognos BI and IBM for executing its ETL operation.
Designed model files in Cognos
•
Transformer
Created Cognos multidimensional OLAP
•
cubes for users to be able to get business information from Cognos Power Play..
Extensive knowledge in handling
•
Offshore/Onshore model for Cognos BI..
Analyzed business needs for designing
•
cognos architecture. Extensively explored and implemented the cognos multi-
tier architecture for maximum scalability and fail over safety for business
critical systems.
Extensively used Analysis Studio, Query
•
Studio, Report Studio and Metric Studio for Report design in Cognos BI
version 10.1/10.2/8.4/8.3/8.1.2 MR1/ReportNet 1.0/1.1MR1/MR2.
Extensive experience with Cognos tools
•
such as Cognos 8, Cognos ReportNet,
FrameworkManager,Impromptu,SPowerPlayCubes,Transformer, Impromptu
Web Reports (IWR), Upfront, PowerPlay Enterprise Server (PPES), Access
Manager and Architect.
Extensively worked on each phase of Data
•
warehouse lifecycle involving Data Discovery, Data Modeling, ETL
Architecture, Implementation, Deployment, Business Intelligence Reporting,
Production enhancement & support.
Expertise on Framework Work Manager,
•
Transformer, Report studio, Query Studio, Analysis Studio, Cognos
Administration, Impromptu, Impromptu web reports, Upfront.
•Analyzing enterprise data and designing data models for optimal performance
in reporting that confirm with Teradata / Oracle / Cognos best practices.
•Worked on Extraction Transformation and Loading - ETL with Cognos Data
Manager, Informatica, PL/SQL, SQL, Mainframe, Unix, MultiLoad,
SQL*Loader and data pump scripting.
•Worked through the Entire Life Cycle of the project under various
responsibilities including Analysis, Designing, Development, Testing,
Deployment and Maintenance
Education:
Bachelor of Technology in Computer Science and Engineering, India.
Technical Skills:
BI Tools : Cognos Business Intelligence 10.x,8.x, 7.1/7.0/6.0,
Impromptu Web Reports 7.0/6.0, Upfront,PowerPlay
Transformer 7.1/7.0/6.0, Power Play Enterprise Server,
Cognos Architect, Cognos Query,,Access Manager.
Cognos Report Net 1.0.2/1.1 MR2/ 8.0. Oracle Reports,
MS Analysis Services 2005, Oracle Business Intelligence
Enterprise edition (OBIEE), Hyperion Interactive
Reporting, Brio.
DDL & DML : SQL, PL/SQL, T-SQL, MDX
Languages & Scripts : PL/SQL, UNIX scripting, HTML, XML, Java, cognos
SDK, Java Script.
Operating Systems : AIX, Sun Solaris 2.8/ HP UNIX, Windows 2003
Server/ NT/ 98/ 95.
Databases: : Oracle 8/9i/10g/11g,SQLServer6.5/7/2000/2005,
Teradata V2R6, DB2 V9, Hyperion Essbase 11,
Hyperion Interactive Reporting. Essbase studio,
Dashboard Studio
Data Modeling : Dimensional Data Modeling, Star join Schema
Modeling, Snow-Flake Modeling, FACT and Dimension
Tables, Physical and Logical Data Modeling
Database Tools : ERWIN, Teradata SQL Assistant, Teradata
Administrator, Teradata Index Wizard, Teradata Visual
Explain, Teradata PMON. Oracle SQL*Plus, Oracle
import/export, Oracle Enterprise Manager, TOAD, SQL
Navigator, DB2 command editor, DB2 command line,
DB2 control center. Essbase Client, Essbase excel add-
on.
PROFESSIONAL EXPERIENCE
General Motors Corporation, Detroit (MI)
Sep 2012 – Present
Cognos Architect
Responsibilities:
Created Metadata Modeling by using multiple databases in Cognos 10.1.1 BI
•
Modeling.
Designed and validated Cognos frameworks as assigned.
•
Created power play transformer OLAP cubes foe end users. Designed the cubes
•
to perform faster with date partition.
Automated cube refreshes after ETL jobs.
•
Responsible for requirement gathering and technical documentation.
•
Responsible for creating Content store, multi-server/ single server installations
•
and Configurations in the cognos8.
Responsible for the data analysis, technical design, implementation and
•
deliverables.
Defined or guided the definition of technical engineering.
•
Provided best practices and processes for day to day operations.
•
Coordinated with Cognos for resolution of any technical issues.
•
Served as Cognos Business Intelligence design expert.
•
Developed Complex Reports in Report Studio.
•
Created Cognos packages by using Framework Manager.
•
Used Query Studio to develop ad hoc reports.
•
Created Dimensionally Modeled relational data (DMR) in Framework Manager.
•
Created Scheduled Jobs by scheduling multiple reports in a job.
•
Gathered Reporting requirements from end users.
•
Published PowerPlay Cubes onto Cognos Connection by using BI Modeling.
•
Generated Data Marts in Star Schema by using Data Manager.
•
Developed dashboards for accurate on-time representation of data and data flow
•
analysis.
Imported metadata from various sources such as Relational Databases, Report
•
Net models, Impromptu Catalogs into the Framework Manager.
Did Unit Testing for all reports and packages.
•
Analyzed the DMR model for Facts and Dimensions.
•
Detected Determinants in the data source.
•
Resolved Ambiguous relationships in model (DMR).
•
Day-to-day administration activities like monitoring Scheduled jobs.
•
Creating report views with saved prompts and schedule according to the
•
business requirement.
Personalized Cognos Connection, Specified display options, regional options
•
and personal information.
Implemented security in Framework Manager Packages & Reports.
•
Implemented Data & Object security in Framework manager models.
•
Developed Cubes according to business requirements.
•
Environment: Cognos 10.1,Report Studio, Cognos 8.4 BI Query Studio,Cognos
8.4 BI Suite, Cognos Connection, Cognos 8.4 BI Modeling, Framework Manager,
Data Manager, Power play Enterprise Server 7.4, Power play Transformer 7.4,
Cognos Scheduler, Cognos Upfront 7.4, Access Manager, Configuration Manager,
Windows 2000, Oracle9i/10G, PL/SQL, Toad.
Frontier Communications,Raleigh,NC
May 2011 – Sep 2012
SR.Cognos Consultant
Responsibilities:
Developed and Published Packages in FrameWork Manager Connecting and
•
testing the Data Source, created database layer, physical layer and presentation
layer(DMR) model, defining appropriate relationship between query subjects
and fact tables.
Worked with sales data and validate the existing reports against SQL Server
•
Database.
Created reports for Finance users and work with Finance team on creating
•
reports for wall street.
Worked on reporting key Finance metrics like Revenue, expense, EBITDA,
•
Average revenue per customer.
Developed OLAP solutions using Cognos and published Reports using Cognos
•
Connection.
Created changes in the existing models (added few dimensions in Analysis
•
Layer) using Cognos Framework Manager and published packages for reporting
activity.
Implemented IBM Cognos Active Report for portable business intelligence
•
Created relational and multidimensional models using star schema in Frame
•
Work Manager and published packages and implemented for reporting activity
and deployed packages to the Cognos Connection Portal.
Setting up the security in framework manager for packages.
•
Responsible for creating User groups and roles to manage security in Cognos
•
Connection and
Access Rights of the Reports for the end users.
•
Developed the List reports, Chart, Graphs, Crosstab reports, Master detail and
•
Drill through reports and Multi Lingual Reports using Report Studio and
Analysis Studio.
Created complex sales crosstab reports in report studio, with calculated columns
•
and tuples to get grand totals for the sales data.
Assigned Security for (Users access setup, creating Roles, Assigning roles to
•
user, Implementing data level, object level security for Framework model)
Created multiple reports in Report Studio, which are detailed reports for
•
Summary Drill through report, Dashboard reports.
Developed Cascading Prompts which filter data, based on selection and
•
reprompt the data selected based on Conditional prompts and Filters in the
reports.
Created Portlets on cognos connection and embedded reports into portlets.
•
Created views for Summary detail reports and created jobs and scheduled them
•
in Cognos Connection.
Developed cross tab reports (DMR) with drill through, drill up, drill down and
•
complex reports which involved multiple prompts and multi-queries. Worked
with offshore team in various aspects, during development phase of project.
Worked paralley with other projects during development phase.
•
Organized status meetings with manager to give updates about reports and
•
cubes.
Environment:IBM Cognos10.1(Report Studio, Query Studio, Business Insight
Advanced Framework Manager), Cognos8.4.1 (Framework Manager, Report
Studio, Query Studio, Analysis Studio, Cognos Connection), Cognos8.3, Power
Play Transformer 7.4, Power Play Enterprise Server 7, oracle11g(SQL)
New Breed,NC
Nov 2010 – May 2011
Cognos Consultant
Responsibilities:
Extensively worked on converting OLAP
•
data from cognos and Essbase into relational data, data integration and
rationalization.
Worked on capacity planning, server tuning,
•
back up recovery plan for the entire BI contents
Created complex framework manager
•
models,Implemented best practices using Cognos Framework manager.
Reviewing data models and resolving complex problems.
Developed processes and procedures to
•
administer Cognos 8 applications, submitted solutions recommendations for
best practices and standards.
Worked on new business requirements
•
gathering, defining data flow, success criteria development, test plan
development and execution, for meeting reporting needs, managing scope and
business expectations
Expertise in handling Administration tasks
•
like bursting and scheduling the reports.
Expertise in writing java script for
•
customizing the cognos UI.
Extensive experience in Report Studio,
•
Conditional blocks, style variable, render variables, conditional styles and
HTML Items
Expertise in Customizing Cognos
•
connection and experience with Portal Layout.
Expertise in Developing Ad hoc Reports
•
using Query Studio and complex reports using Report studio and Metric studio.
Expertise in developing prompt pages and
•
cascaded input prompts using SQL and Report Studio.
Extensive interaction with Business
•
community and Team members.
Expertise in developing dashboards.
•
Environment: Cognos8.4 (Data Manager, Framework Manager, Report Studio,
Query Studio, Analysis studio, Cognos configuration, Go! Dashboard), AIX
(Cognos installation servers), DB2 9.2.5(Data warehouse), SQL, PL/SQL,
Websphere(Application Server). IBM his Server (Web server), SUN ONE LDAP,
MS Office Suite, Hyperion Essbase, Hyperion Interactive reporting, Hyperion
Btio.
CCSI
(Chrysler Financial Detroit (MI))
Jan 2009 - Nov 2010
Cognos Developer/Admin
Responsibilities:
Involved in gathering Business Requirements for the Model from the business
•
users.
Actively participated in defining the scope of reporting and report specification.
•
Created and presented prototype Models and reports to high level Business
•
users.
Worked on credit risk and dealer credit projects.
•
Created reports to identify credit risks for dealers based on dealership history.
•
Worked on Designing and developing complex reports.
•
Participated in Technical design review for BI applications to ensure
•
appropriate use of Cognos
Queried from different database tables as per the requirement.
•
Designed and developed many packages using Framework Manager and
•
published Packages using Framework Manager.
Developed Standard reports, Drill through report, Master detail reports,
•
Bursting reports using Report Studio.
Established relationships and joins between the query subjects of the Model
•
Implemented object level security for query subjects and query items to make
•
them available only for the end users who are authorized.
Worked extensively on creating the Model and publishing the package
•
on Cognos Connection for Reporting purposes.
Created complex reports which involve Query Prompts, Layout calculations,
•
Conditions & Filters
Developed Multi Page Reports with Prompt pages and Conditional
•
Variables according to the end user requirements
Support the Development Teams for the Cognos related Issues.
•
Involved in unit testing and Functional testing to finalize the Report Accuracy.
•
Wrote the SQL statement for Data validation of Report Studio Reports.
•
Environment:Cognos 8.3, Report Net 1.1 MR3 (Framework Manager, Report
Studio, Query Studio, Analysis Studio ), Cognos Impromptu, Power Play Client,
Power Play Transformer, Power Play Connect, Power Play, Transformation Server,
Power Play Enterprise Server, Upfront, Cognos IWR, Oracle 9i
CCSI Inida.
Jan 2007- Dec 2008 Cognos
Analyst/ Developer
Responsibilities:
• Analyzed Business requirements from the analysts, read functional documents,
and prepared Cognos Reports accordingly.
• Involved in Designing DMR models with Relational Data using Framework
Manager and deployed packages to the Report Servers.
• Created Database Layer, Business Layer, and Presentation Layer, defining
appropriate relationship between Query Subjects and Fact Table in Framework
Manager.
• Worked on bug fixing and enhancements to existing Cognos reports in Report
Studio & models in Framework Manger and development of any new Reports.
• Developed List, cross tab, drill through, master-detail, chart and complex
reports which involved Multiple Prompts in Report Studio.
• Created reports with Optional filters and custom prompt pages in Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports,
Trend reports to Summary reports and Summary to Detail reports.
• Developed Dash board reports to display all the information related to
environment using Summary reports.
• Involved in upgrading reports from Cognos 8.2 to 8.4.
• Deployed reports into servers in Cognos connection and applied the needed
level of security.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Trained the end users to effectively use the reporting tool to build and
customize their ad-hoc reports.
• Coordinated with functional users for User Acceptance Testing prior to
releasing system changes in production.
• Involved in migrating reports from Development to Testing and from Testing to
Production Environments.
Implemented Star Schema Grouping and Dimension Hierarchy in Framework
•
Manager Model.
Modeled metadata from Oracle data source for use in Report studio and Query
•
Studio using Framework Manager.
Exported IQDs from the Framework Manger and built OLAP Cubes in
•
Transformer according to the business needs.
Environment: Cognos 8.4, 8.2 (Report Studio, Query Studio, Cognos Connection,
Framework Manager, Analysis Studio), Access Manager, Content Manager, Oracle
10g, DB2 IDMS, SQL Server 2005, Toad, SQL, HTML, MS-Access, MS- Excel.
Contact this candidate