Nagendra Kandala

Work History

Work History


KMOS TV, Kansas City Role: Siebel Analytics/ETL developer Responsibilities: Shaped and administered the Physical Layer, BMM layer, Presentation Layer in a Siebel Analytics repository Developed physical layer connection pools with authorizations and imported necessary tables with joins Developed Reports with pivot, charts, gauge views applying local and global filters Implementation of Interactive delivers/ibots to alert business end users about changes Rpd Development using Siebel Analytics Server Administration Tool in accordance with the requirements Configured security through Siebel Intelligence Dashboards for users for subject areas Created groups in the repository, added users to the groups and granted privileges explicitly and through group Inheritance Worked on Siebel answers to create reports for the Business users Created Dashboards for OLTP systems using Siebel Intelligence Dashboards Worked on Subscribed user groups privileges for ibot alerts Creation of groups and adding users to the group in repository with inheritance features Implemented new star schemas and modified existing ones in related subject areas

Sr. Etl Developer

Phlox Design Inc
Los Angeles CA Role: Sr. ETL/OBIEE Consultant Phlox Design Inc caters to hundreds of members in the Los Angeles Fashion District, and tens of thousands of buyers worldwide, providing them with a centralized place to conduct business to business transactions. Responsibilities: Full life cycle implementation of the Data warehouse for the fashion company OLTP systems Sourced the B2B transactional data to the warehouse for analytical purposes Preparation of Technical design documents and data analysis documents for source OLTP Collaboration of complete ETL end to end design, build and deliverables for the business analytic warehouse Implementation of SCD(Type1/Type2/Type3) in the ETL build for Business analytics warehouse Extensively worked on OBIEE administration tool for customizing physical/BMM/presentation layers Customized security settings for privileged users, groups and classify based on roles in the BI administration tool Administered Web Catalog Objects(pages/folders) for the users Migrated existing legacy reports and edit into the OBIEE dashboards Configured repository and session variables to produce dynamic reports and Dashboards Used HTTP transformation and web methods to import data from the Fashion website data for records to improvise the Pictures in website Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the mapping Designer to map sources to the target Used Informatica Designer to create complex mappings using different transformations like filter, Router, Aggregator, Lookup, Sorter, Update strategy, Expression to pipeline data to Data Warehouse Debugging code, testing and validated data after processes are run in development/testing according to business rules Prepared unit test plans and maintained defect logs to resolve issues Environment: Informatica 8.1. 1, DAC 7.9. 5, Linux, OBIEE 10. 1.3. 4.1, Oracle 10g/11g(SQL, PL/SQL)


Worthington Industries NYSE
WOR) is a global company that processes steel for use in the automotive, construction, hardware, aerospace and many other industries. Responsibilities: Performed GAP analysis on existing systems and gathered requirements from business users Customized prebuilt Business Intelligence(BI) Applications using OBIEE, Informatica and DAC for the subject areas like Supply Chain Analytics, Sales Analytics Complete configuration of OC4J/web logic servers to accommodate service oriented architecture and OBIEE worked with Data models to identify key joins between tables to built complex joins in BI repository Report calculations in OBIEE admin tool by modifying repository objects(. rpd) in physical/BMM/presentation layers Created Dimensional Hierarchy, logical columns, aggregate columns, level based measures in BMM layer Built various views in front end OBIEE answers like charts, gauge views, Pivot tables Configured Reports Pivots, View Selectors, Column Selectors, and Interactive Dashboards with drill-down capabilities, Charts, tabular using global and local Filters, and Page/Dashboard Prompts. Configured repository and session variables to get dynamic reports and dashboards. Used Catalog Manager to maintain Analytics web catalog to manage Dashboards and Answers. Worked on Security settings in Oracle BI Admin Tool to set up users, groups, access privileges and query privileges. Enabled the BI scheduler for i-bot alerts for end users to track the key information on daily basis Cache implementation for Reports performance and execution of materialized views/table partitions Configuration of LDAP authentication and authorizing privileges for Multiuser Development Environment(MUDE). Development of Mappings/Mapplets using various Transformations, creating and monitoring Sessions/Workflows. Extensively used the Informatica Power Center tools-Repository Manager, Designer, Workflow Manager and Workflow Monitor. Coordinated with testing teams to resolve issues found during the DEV, QA, UAT phases. Peer evaluation of code, testing, monitoring NQSQuery and tuning reports. Environment: OBIEE 10. 1.3. 4.1, Oracle, Informatica 8.1, DAC 7.8. 5, OBI Apps 7.9. 4, UNIX, Linux, Oracle 10g/11g(SQL, PL/SQL)

Senior Obia Consultant

Worthington Industries
Columbus OH Role: Senior OBIA consultant

Solution Development Senior Analyst

Ascension Health
St. Louis Role: Solution Development Senior Analyst(OBIA) Ascension Health is a non-profit company that operates a network of hospitals and related health facilities in the United States. It is the nation's largest Catholic and largest non-profit health system. Responsibilities: Full life cycle(SDLC) implementation of Business Analytics Warehouse and Dashboards designed for the Systems Across health Ministries and MIC applications customizing pre-built Oracle Business Intelligence Applications which includes Informatica, DAC and OBIEE for ETL interfaces, Dashboards and reports Worked on MIC application architecture for requirements gathering, GAP analysis, TDD's towards the planned Business Analytics data warehouse for HR, SCM and Finance, Manufacturing Analytics using Pre-built OBIA Customization of the Oracle Out of The Box ETL interfaces using Informatica for Extracting various data from OLTP systems like People Soft, Siebel, Oracle EBS Customized various Source Qualifier Queries to meet the business functionality of the OLTP incoming data Coordinated offshore and onshore teams and owned the ETL interfaces related to Supply chain and Human Resources Involved in Design and build for ETL deliverables for customizing SDE and SILOS mappings ETL enhancements for analytics like supply chain, HR from OBIEE report perspective Implemented Change data capture and incremental logics in inventory ETL Interfaces by identifying the audit columns for the data coming From People soft Purchasing and Supply chain modules Implementation of SCD type1/type2/type3 in existing ETL interfaces for capturing slowly changing dimensions Configured the Domain Value Lookup files for ETL interfaces related to HR analytics

Senior Developer

NAPA Auto parts
Atlanta GA Role: Senior Developer Founded in 1928, Genuine Parts Company(GPC)/NAPA auto parts is a service organization engaged in the distribution of automotive replacement parts, industrial replacement parts, office products and electrical/electronic materials. We are geographically located across the United States, Canada and Mexico with over 2000 operations in network Responsibilities: Full life cycle(SDLC) implementation of Business Analytics Warehouse and Dashboards designed for the subsidiaries customizing pre-built Oracle Business Intelligence Applications which Includes Informatica, DAC and OBIEE for ETL interfaces, Dashboards and reports Complete design of the Dashboards, Reports, drilldowns, formatting for the SPR subsidiary End to End RPD design of the Business Model Layer, Presentation and Physical layers for user needs Enhanced RPD with various complex calculations, Dimensional Hierarchies and new Facts Implemented Income statement report for comparing actuals, budgets for EIS subsidiary Worked on OBIEE administrative tasks like creating MUD environment, upgrading the OBIEE 11. 1.1. 5 to 11. 1.1. 7 in LINUX, Applying Patches for fixing bugs, Deployment of RPD's Implemented user impersonation for testing the user security issues Performed migration/merging of RPD's and catalog objects in sync with their security within Environments Implemented usage tracking and impact tools for data lineage Implemented data-level, object level, user level security SPR users LDAP server host configuration in weblogic administration console for syncing LDAP groups to the application roles Creation of Application roles, application policies in enterprise manager to map to the LDAP groups Created MUD(Multiple user Development) environment by utilizing projects in OBIEE. Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE. Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse. Designed Schema/Diagrams using Fact, Dimensions, and Physical, Alias and Logical tables. Created Drill down Hierarchies and implemented Business Logics for Facts. Created Custom Mappings in Informatica to Load the security data like users and roles from People soft Built DAC execution plans, subject

Senior Obia Consultant

Toshiba America Medical Systems
Tustin CA Role: Senior OBIA Consultant

Senior Obia lead

Hyundai Capital America
Irvine CA Role: Senior OBIA Lead




University of Central Missouri








data warehouses