Project Description: Confidential A Smart Equipment Network SEN will have the ability to connect with fountain, vending coolers equipment to provide real time information to our business and enable a direct connection with our consumers. Project Description:. The main purpose of this data warehouse implementation is to support the Marketing needs as well as the Representative needs across countries. Since all countries are doing the business in the similar fashion a need to have a global view of the same data is required and Confidential also caters to that. Job scheduling is done using Autosys. Insight Marketing Intelligence IMI is an analytics team which uses data from Confidential to analyze, infer and interpret various business scenarios and generate reports for users.
|Published (Last):||23 December 2010|
|PDF File Size:||19.80 Mb|
|ePub File Size:||20.3 Mb|
|Price:||Free* [*Free Regsitration Required]|
Project Description: Confidential A Smart Equipment Network SEN will have the ability to connect with fountain, vending coolers equipment to provide real time information to our business and enable a direct connection with our consumers.
Project Description:. The main purpose of this data warehouse implementation is to support the Marketing needs as well as the Representative needs across countries. Since all countries are doing the business in the similar fashion a need to have a global view of the same data is required and Confidential also caters to that.
Job scheduling is done using Autosys. Insight Marketing Intelligence IMI is an analytics team which uses data from Confidential to analyze, infer and interpret various business scenarios and generate reports for users.
Also apart from the adhoc reports requirement, there was a standard set of extracts that were been ftp'd to the IMI team over a campaign frequency. Project Description: The Confidential Application has been developed to maintain and enhance the functionality of the existing application, which handles products of type Customer Premises Equipment and its Items.
This includes the functionality of adapting the products supplied by different suppliers configure the products, mange different prices and exposing the product details to other consuming systems Confidential is one of the largest Telecom Company in Confidential. This projects deals with BT product inventory.
Project Description: Rationalizes the Product building process in one application, this includes moving the functionalities and features of a Traditional Remedy application to web based interface with more user friendly operations. The application includes the features of product building and rules for the products Confidential is one of the largest Confidential. This projects deals with internal website of VonageConfidential.
Hire Now. Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Expertise in doing the RCA Root Cause Analysis and resolving performance bottlenecks Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. Strong database design skills. Automation, Scheduling and monitoring of jobs with scheduler Autosys. Understanding of primary, foreign, compound and surrogate keys relationship. Management skills include Team Management, Project Planning, Monitoring, and self-starter with good communication skills and ability to work independently and as part of a team.
The SEN can be leveraged for Real-time equipment alarms and alerts can expedite service processes. Equipment product sales information can enable efficient route planning execution. Cashless payments on equipment can reduce trade loss.
Dynamic consumer marketing can be directed through equipment. Real time gifting and coupons can be offered through equipment. Responsibilities: Direct interactions with the IT and Business team of every module is required for developing the Tower Extracts with multiple customizations. Transformed the business requirements into technical specifications and source-to-target mappings.
Identified the gaps in the business requirements that would impact the execution of project and also the data quality across streams. Provided the dimensional data model to give optimal performance by changing the Primary Index of tables and applying various performance tuning techniques on Oracle 11g data warehouse environment.
Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements. Coded Unix Shell Scripts to process the data received from source system on daily basis. Involved in the continuous enhancements and fixing of production problems. Created and reviewed scripts to create new tables, views, queries for new enhancement in the application using TOAD. Created and used indexes on the tables for faster retrieval of the data to enhance database performance.
Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan. Partitioned the fact tables and materialized views to enhance the performance. Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Transformed the logical data model into physical data model on Oracle 11g data warehouse environment to give optimal performance for ETL jobs as well as BI reports. Transformed the business requirements into technical specifications and source-to-target mappings Identified the gaps in the business requirements that would impact the execution of project and also the data quality across streams.
Wrote Unix Shell Scripts to process the data received from source system on daily basis. Created indexe s on the tables for faster retrieval of the data to enhance database performance. Responsibilities: Worked independently on the critical milestone of the project interfaces by designing a completely parameterized code to be used across the interfaces and delivered them on time inspite of several hurdles like requirement changes, business rules changes, source data issues and complex business functionality.
Analyzed the source systems to detect the data patterns and designed ETL strategy to process the data. Supported the development and production support group in identifying and resolving production issues. Was instrumental in understanding the functional specifications and helped the rest of the team to understand the same.
Responsibilities: Worked independently with the business analysis team to understand the requirements. Prepared low level design document and generated the reports accordingly Developed and maintained the code for standard set of outbound extracts. Analyzed the complex requirements and developed the reports with utmost accuracy.
Developed very complex reports i. The application Thomson Innovation is running on around more than 50 servers. This application is an interface between the Client and the customers of the client and it mainly deals with Patents information. The application Confidential Pharmacy deals with Health Care and scientific information. All the customers interact with the data center Confidential maintaining by the Confidential by using this application.
Adjust your settings to allow scripts for this site and reload the site.
Design Tip #178 Tried and True Concepts for DW-BI Success
Let us begin with the most simplest questions first, we will gradually move towards more complex concepts later. A data warehouse is a electronic storage of an Organization's historical data for the purpose of Data Analytics, such as reporting, analysis and other knowledge discovery activities. Other than Data Analytics, a data warehouse can also be used for the purpose of data integration, master data management etc. According to Bill Inmon, a data warehouse should be subject-oriented, non-volatile, integrated and time-variant. Non-volatile means that the data once loaded in the warehouse will not get deleted later. Time-variant means the data will change with respect to time.
Sure enough, you have heard the term, "Big Data" many times before. There is no dearth of information in the Internet and printed medium about this. But guess what, this term still remains vaguely defined and poorly understood. This essay is our effort to describe big data in simple technical language, stripping-off all the marketing lingo and sales jargons. Shall we begin? Continue Reading Handling rapidly changing dimensions are tricky due to various performance implications.
DWBI Concepts All
While I do think Informatica should consider the English spelling for "PowerCentre" unfortunately the only spelling used today is the American one "PowerCenter". Well explained. Keep updating Cognos TM1 online training Bangalore. Great blog created by you.
A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources. Then process the data whatever the way you want apply calculation, aggregation, Ranking, etc. Data warehouse systems have their own specific characteristics and below are some major characteristics. Subject-Oriented: Data warehouses are designed to help you analyze data and Information is presented according to specific subjects or areas of interest, not simply as files.