United States
Colorado Springs Utilities is energy and utilities firm which involves in Water, Electricity and gas supply. To maintain their reporting and application, they use oracle EBS procurement and SCM as their Asset maintenance application. Now the product is upgraded and re implemented and it needs Data migration and report delivery. So the entire source system with multiple interface is analyzed and integrated there by data from multiple source is taken analyzed. Data migration activities were involved in pulling the data from source to target. Informatica is used as ETL tool and Oracle is used as the DB. Responsibilities Liaise with business subject matter experts in analyzing business requirements (Productivity related – KPIs), understand the various data sources. Architect the productivity data mart. Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10g. Develop strategies for use in high volume, high performance heterogeneous environment. Developed Reports in OBIEE 11g , Dash boards, Adhoc reports, Scheduler, Data level security, Object level security. Created OBIEE variables Static, dynamic, sessions and also configured DAC. Developed reports out of Oracle EBS SCM modules like Procurement, Purchase Order, Request for quotations, Purchase requisitions, Bill of Materials, Invoice and Workflow Management . Involved in deciding Asset Life cycle management and work order management. Conceptualized the Inventory, item and planning strategy. Used PDM concepts for reporting strategy by implementing PIM data modeling. Defining the scope of Architecture and Designing the Data Architecture like the warehouse bus and the logical data architecture, data bases and the physical data architecture. Sourcing strategy, metadata Architecture.
My.statestreet.com is State Streets online client information-delivery portal. Clients around the world can access the data, tools and products they need to manage all their information. It is an integrated online delivery platform, where cli ents can view, download and extract various reports like Transactions, Holdings and Performance etc. It also allows for setting alerts, querying and comes with other information tools. State Street holds assets worth more than 2 trillion . All these asset under management for the clients mainly Investment banking, mutual funds ,private equity all maintained by a platform entreprise service platform. The data is centralized there by making master data management and served through web interface. The upto information service is given to the client. Reports are categorized based on region, country, securities etc. State Street Procure to pay reporting part was done by OBIEE. The information about Procurement and Spend Analytics stream line process were introduced. The objective is to have a subject area for the procurement and spend Analytics. Responsilibilities ( Have worked in 2 projects for State street) Liaise with business subject matter experts in analyzing business requirements and translating them into detailed conceptual data models, process models, logical models, physical models and schema development in the database. Analyzed the Oracle EBS Procurement and Spend Analyzer. Developed reports in OBIEE 11g leveraged the existing data model.
Model & Architect DW design, direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process in Informatica.