[var] => content
[type] => preview
[var] => cut_url
Chandrakanth R. Ponnathota
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
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
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,
Implemented Usage Tracking
and created Custom Dashboard pages for Real time monitoring and Usage
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
Extensive Working Experience
in creating Calculation Measures, Time Dependent Measures, Initialization
Blocks and Repository Variables.
Implemented and extensively
worked in Multi User Development MUDE.
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
Technical skills expertise:
out of |
||Siebel Analytics ., ., OBIEE ...,
Oracle BI Financial Analytics
Union Pacific Rail Road, Omaha,
Oct till Date
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
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,
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
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
Diagnosed the reasons for
slowly running reports using Usage Tracking dashboards and NQSQuery.log
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
and HTML templates for implementing additional web interface to OBIEE
OBIEE ..., Oracle, SQL, PL/SQL, Toad ., Windows
point Inc, San Francisco, CA
Siebel Analytics Consultant
Well point is the nation’s leading
health benefits company serving the needs of approximately million
Actively involved in gathering
requirements from the end users, involved in
Modifying/correcting various technical & functional Specs in the
Member of warehouse design
team, assisted in creating fact and dimension tables based on requirement
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
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
Trained Users on
Best Practices for developing effective Dashboards.
Siebel Analytics ., SQL, Oracleg, Windows NT, SunOS..
Capital Group, San Antonio,
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
Involved in defining the
Business requirement specifications and Functional specifications by
directly interacting with the endusers and proposing corresponding