[var] => cut_url
<pre>Array ( [var] => cut_url ) </pre> Resume for chandrakanth R. for IT / Technical Support / Computer Software in Omaha, Nebraska. Search More Resumes for IT / Technical Support on #VYSINWNW4

Search Resumes

Post Jobs

Job Seekers:
Post Your Resume


Resume for chandrakanth R. for IT / Technical Support / Computer Software in Omaha, Nebraska

Occupation: IT / Technical Support Industry: Computer Software
Country: United States City: Omaha
State: Nebraska ZIP: 68101

View Complete Resume   Download Resume [
    [name] => cut_url
Share Share

< Back to search results Preview: For the complete resume and contact info please download it.

    [var] => content
    [type] => preview
    [var] => cut_url


                                    Chandrakanth R. Ponnathota 



  • + Years of experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems.
  • Good Understanding of Data warehousing concepts/methodologies Involved in architectural design, Data Modeling Star Schema, Snowflake, Designed Dimension, Fact and Aggregate tables and Slowly changing dimensions.
  • Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance.  
  • Used OBIEE Best Practices for creating the Repositories and Dashboards.
  • Worked closely with ETL and DBA teams in creating Dimensional Models, ETL Processes and Performance Tuning features.
  • Have experience working in Financial Sector Domain especially in customizing General Ledger, Receivables , Payables  Dashboard Pages.
  • Interpreted Highlevel Business Requirements into Logical Business Models     Facts, Dimensions.
  • Implemented Usage Tracking and created Custom Dashboard pages for Real time monitoring and Usage History.
  • Responsibilities Included using various Performance Tuning Techniques to decrease the response time of query requests.
  • Proficient in Configuring the Physical/Logical/Presentation Layers of the OBIEE Administration Tool.
  • Extensive Working Experience in creating Calculation Measures, Time Dependent Measures, Initialization Blocks and Repository Variables.
  • Implemented and extensively worked in Multi User Development MUDE.
  • Designed/Developed complex reports in Siebel  Answers/Dashboards and trained the Business/ Power Users to create reports in OBIEE  
  • Expertise in creating Custom Java Scripts and CSS functions for implementing additional level of functionality in OBIEE reports and Dashboards.
  • Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports and updates.
  • Ability to produce welldocumented designs and code.
  • Strong analytical and problem solving skills coupled with excellent written, verbal and interpersonnel communication skills.

    Technical skills expertise:  

    Tools Skills    Rating out of
    Databases Oracle g/g/i/i

    SQL Server







    Languages SQL




    Data Modeling Tools Erwin ./..        ./.
    Database Tools TOAD




    Operating Systems Windows /XP/NT/



    RedHat Linux






    BI Tools Siebel Analytics ., ., OBIEE ..., ...

    Oracle BI Financial Analytics




    Professional Experience  

    Union Pacific Rail Road, Omaha, NE                                   Oct till Date 

    Sr. OBIEE Report Developer

    Union Pacific’s route serves customers in critical and fastgrowing markets, linking major West Coast and Gulf Coast ports and providing service to the East through major gateways in Chicago, St. Louis, Memphis and New Orleans. Union Pacific also operates key north/south corridors and is the only railroad to serve six

    gateways to Mexico.  


  • Worked with management team to draft business requirements and ensure all the proper metrics and performance requirements were in place to ensure maximum efficiency of the resulting product.
  • Used OBIEE Best Practices for creating OBIEE Repositories and Dashboards.
  • Was responsible for creating, validating and testing the repository objects before delivering it to the users.
  • Involved in customizing the packaged financial analytic applications by adding tables, columns to the existing fact and dimensional tables.
  • Customized prebuilt OBI Financial Analytics dashboards according to Users Requirement.
  • Customized General Ledger Dashboard Pages by adding additional views and drill down Capabilities.
  • Created new Executive Summary Dashboard Pages for Top Level management people by customizing the Payables and Receivable Dashboards.
  • Incorporated OBI results into External Web Applications using custom Go URL commands.
  • Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
  • Taking sign off for all functional and technical design documents and being responsible for further changes in the design.
  • Set up Conditional iBots to send custom reports when a data alert condition was triggered that threatened specified Rail Road Car numbers
  • Trained the operations and technical teams on reports and dashboards usage.

    Environment: Oracle BI Financial Analytics . ,OBIEE ..., Teradata  , Sql, Windows Server  

    Pacific Gas and Electric Company, CA                            Feb Sep  

    OBIEE Lead 

    The Customer Services Management Analytics solution will enhance decisionmaking process regarding Operation Enhancements of PG&E personals. The system will allow Customer Relation Management Team to perform data analysis and track the solutions provided to subscribers as well as to report to California Public Utilities Commission CPUC. 


  • Identified customer requirements, wrote functional designs, reviewed technical designs, developed test schedules and reviewed testing plans, documented development and results of these plans.
  • One on One meeting with SME to understand the business scenario and process flow.
  • Worked with DBA on database architecture design and data model design for Data warehouse and Data Marts.
  • Created/Modified/ Customized Metadata repository .rpd and Configured Metadata Objects using Siebel Analytics Server Admin tool.
  • Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and created customized repository variables for the users.
  • Developed Usage Tracking RPD and Dashboards.
  • Worked in Multi User Development Environment.
  • Diagnosed the reasons for slowly running reports using Usage Tracking dashboards and NQSQuery.log Files
  • Promoted the Development RPD to Production Server, renamed it so that it matches with NQSConfig.ini file and tested the consistency of the RPD and Dashboards for any issues.
  • Developed several Interactive Dashboards with drilldown capabilities, pivot tables, charts, and tabular reports using OBIEE Answers.
  • Built Prototype reports from Excel spreadsheet during the requirement phase to visualize the reports and clarify the requirements.
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.
  • Designed and developed security settings like data visibility based on position and login of the User in a StandAlone environment 
  • Created custom JavaScript and HTML templates for implementing additional web interface to OBIEE Dashboards.
  • Environment: OBIEE ..., Oracle, SQL, PL/SQL, Toad ., Windows Server 

    Well point Inc, San Francisco, CA                                       April Jan                             

    Sr. Siebel Analytics Consultant


    Well point is the nation’s leading health benefits company serving the needs of approximately million members nationwide.        




  • Actively involved in gathering requirements from the end users, involved in
  •       Modifying/correcting various technical & functional Specs in the development.

  • Member of warehouse design team, assisted in creating fact and dimension tables based on requirement documentation
  • Created connection pools, physical tables, defined joins and implemented BMM and Presentation Layers based on User Requirements.
  • Developed Time Dependent Measures, Complex Logical Column Formulas and Level Based Measures in BMM Layer.
  • Implemented Caching Strategies for effective Query response time.
  • Was involved in Production Support for various Business Models and Dashboards.
  • Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
  • Implemented several report views like Charts , Tabular, Cross Tab , Narrative ,  Column Selectors ,View Selectors as per User Preferences.
  • Implemented dynamic dashboard prompts to filter results into specific segments of the business.
  • Created proactive agents iBots and Alerts to the Marketing team about business changes
  • Created technical design documents for OBIEE RPD, Reports, and Dashboards.
  • Created Groups in the repository, added users to the groups and granted Privileges explicitly through group inheritance.
  • Trained Users on Best Practices for developing effective Dashboards.
  • Environment: Siebel Analytics ., SQL, Oracleg, Windows NT, SunOS.. 

    Capital Group, San Antonio, TX                                            June Mar

    Sr. Siebel Analytics Report Developer 
    The Capital Group Companies is one of the worlds most experienced and successful investment management organizations. Data loading was done through Informatica as back end and reports were developed in Siebel Answers


  • Involved in defining the Business requirement specifications and Functional specifications by directly interacting with the endusers and proposing corresponding Technical specifications.

  • Cancel
    Not Enough Credits
    Sorry, but you don't have enough credits to download this resume.

    Purchase more credits
    Not Available
    Sorry but this resume is not available for download. Please choose another!

    Confirm Download

    Would you like to download  for 1 credit?

    You have  credits left.

    Yes No 

    Don't ask me again
    Confirm View Complete Resume

    Would you like to view  for 1 credit?

    You have  credits left.

    Yes No 

    Don't ask me again