Data Warehouse Manager

The Data Warehouse (DW) Manager provides leadership of all aspects of DW activities including oversight of the design and development of the new Warehouse, management of Current/Future reporting requirements, and oversight of the Extract, Transform and Load (ETL) processes.

The perceived strength of data warehousing within an organization will be the sum of the strength of the Project Managers. Project Managers must deliver commitments and must deliver on time. They will do this by culling resources from within the data warehouse team and from consultancy as necessary and establishing partnerships with other internal support organizations required to support a data warehouse iteration. A Project Manager delivers by:

• Maintaining a highly detailed plan and obsessively caring about the progress on it.
• Applying personal skill and judgment to everything on the project. This is a real value-add of the
Project Manager. It is the Project Manager’s job to exercise relevant discretion.
• Matching team member’s skills and aspirations as closely as possible to tasks on the plan.
• Tracking all relevant metrics for each iteration:
– Project Plan milestones
– Issues list
– Adherence to change control practices
– Adherence to source code control practices
– Documentation fit for users and support personnel
– Architectural components adherence to fit for purpose and standards
– Regression testing performed and tests updated based on changes
– Team members fit for tasks and career-enhanced

Awesome Symfony2 Bundles

A list of awesome Symfony 2 bundles, utilities and resources.

User Management

* FOSUserBundle – Adds support for a database-backed user system.
* HWIOAuthBundle – OAuth client integration. Supports both OAuth1.0a and OAuth2.
* JMSSecurityExtraBundle – Enhances the Security Component with several new features.

Web Services

* FOSRestBundle – Provides various tools to rapidly develop RESTful API’s & applications.
* FOSOAuthServerBundle – A server side OAuth2 bundle.
* JMSSerializerBundle – Easily serialize, and deserialize data of any complexity.
* NelmioApiDocBundle – Generates documentation for your REST API from annotations.
* RequestLimitBundle – With this bundle you can easy limit requests to your application.
* RateLimitBundle – Add rate limits to your controllers/actions easily through annotations.
* BazingaHateoasBundle – Integration of the Hateoas library.
* KnpJsonSchemaBundle – Provide a service which allow you to generate json schema based on validation metadata.
* LexikJWTAuthenticationBundle – This bundle provides JWT (Json Web Token) authentication for your REST API using the namshi/jose library.
* ResourceBundle – Bundle that helps in developing REST APIs.
* SerializedResponseBundle – A simple bundle to provide an easy way to send out json/xml/yaml responses of serialized objects with annotations.

Template Engine

* UcoTwigExtensionsBundle – Provides some filters.
* TwigExtraBundle – Twig Extra Tools Extensions.
* twig-inflection – Apply inflection.
* KnpTimeBundle – Provides helpers for time manipulation.
* GravatarBundle – Simple wrapper to gravatar API.
* CgKintBundle – This bundle lets you use the Kint library in your Twig templates.
* TwigJackBundle – Handy additional features for Twig.


* DoctrineFixturesBundle – Integrates the Doctrine2 Data Fixtures library.
* DoctrineMigrationsBundle – Integrates the Doctrine2 Migrations library.
* RelationBundle – Bundle to manage relations between models/entities.
* PasswordStrengthBundle – Validator for ensuring strong passwords.
* StofDoctrineExtensionsBundle – This bundle provides integration for DoctrineExtensions.
* DoctrineEncryptBundle – Bundle allows you to create doctrine entities with fields that will be protected by encryption algorithms such as AES.
* WizadDoctrineDocBundle – Allows you to generate a decent documentation for your doctrine model schema.
* doctrine-routing-bundle – Dynamic database routing.
* FeedBundle – A bundle to build RSS feeds from your entities.
* FPNTagBundle – This bundle adds tagging, with the ability to associate tags with any number of different entities.
* DoctrineEnumBundle – Provides support of MySQL ENUM type for Doctrine2.
* MysqlDoctrineFunctions – MySQL Function for Doctrine : RAND(), ROUND() DATE(), DATE_FORMAT().
* VichGeographicalBundle – A bundle which provides geographical features for ORM and ODM entities and object oriented javascript maps rendering.


* dms-filter-bundle – Provides a FilterService to allow users to implement input filtering in entities using Annotations.


* CaptchaBundle – Bundle implementing a “captcha” form type.
* FilterFormBundle – Filter form bundle.
* CraueFormFlowBundle – Multi-step forms.
* InfiniteFormBundle – A collection of useful form types and extensions.
* IvoryOrderedFormBundle – Provides a form ordering support.
* FormBundle – Provides the “entity_id” type.

Service Container

* JMSDiExtraBundle – Provides Advanced Dependency Injection Features.
* PHP-DI – The dependency injection container for humans.


* TwigReflectionBundle – Displays what’s in Twig.
* WebProfilerExtraBundle – Adding routing, container, assetic & twig information in the web profiler.
* JMSDebuggingBundle – Provides advanced debugging tools.
* LiipCodeBundle – A set of Symfony2 console commands to help developers deal with the various ways of identifying classes, templates, bundles, services, etc.
* ListenersDebugCommandBundle – A console command to debug listeners.
* PUGXGeneratorBundle – An enhancement of SensioGeneratorBundle.
* XhprofBundle – XHProf bundle.

Assets Management

* FkrCssURLRewriteBundle – A small assetic filter to fix all url paths at css documents to correct urls.
* JmikolaJsAssetsHelperBundle – Exposes the AssetsHelper service from Symfony2’s templating component to JavaScript, allowing relative or absolute asset URI’s to be generated client-side.
* IgorwFileServeBundle – Bundle for serving protected files.
* KachkaevAssetsVersionBundle – Automates the process of updating assets version.
* SpritesBundle – Bundle for the Sprites library.
* ZakharovviHumansTxtBundle – Generate humans.txt file from git repository.
* SalvaJshrinkBundle – This bundle integrate jshrink library as Assetic filter and twig extension.
* AsseticMinifierBundle – An assetic minifier in pure PHP for CSS and JS files.
* assetic-extra-bundle – Asset Directory filter for Assetic.


* RabbitMqBundle – RabbitMQ bundle.
* JMSJobQueueBundle – Allows to schedule console commands as jobs.
* GearmanBundle – A bundle intended to provide an easy way to support developers who need to use job queues.
* LeezyPheanstalkBundle – Bundle for Pheanstalk, PHP client for beanstalkd queue.
* qpush-bundle – The QPush Bundle relies on the Push Queue model of Message Queues to provide asynchronous processing in your application.

Payments Management

* JMSPaymentCoreBundle – This bundle provides the foundation for various payment plugins.
* JMSPaymentPaypalBundle – Payment Bundle providing access to the PayPal API.
* CartBundle – High quality cart for developers.

Components of an Embedded System

The components of an embedded system are : Hardware, Software and time operating system.

i) Hardware

• Power Supply
• Processor
• Memory
• Timers
• Serial communication ports
• Output/Output circuits
• System application specific circuits

ii) Software:

The application software is required to perform the series of tasks.
An embedded system has software designed to keep in view of three constraints:
• Availability of System Memory
• Availability of processor speed
• The need to limit power dissipation when running the system continuously in
cycles of wait for events, run , stop and wake up.

iii) Real Time Operating System (RTOS):

It supervises the application software and provides a mechanism to let the processor run a process as per scheduling and do the switching from one process (task) to another process.

Local Area Network (LAN) Vs. Wide Area Network (WAN)

Networks are divided into two types, a LAN (Local Area Network) or a WAN (Wide Area Network). Here is the Local Area Network (LAN) Vs. Wide Area Network (WAN).

Local Area Network (LAN) Wide Area Network (WAN)
Connects hosts within a relatively small geographical area such as same building, same room, same campus. Hosts may be widely dispersed such as across campus, across cities/countries/continent.
Faster than WAN. Slower than LAN.
Cheaper : Under a control of single ownership. Expensive : Not under a control of a single person.
Typical speed : 10 Mbps to 10 Gbps. Typical speed : 64 Kbps to 8 Mbps.

5 Android Applications that You Must Install

Where are you right now? Which cell phone you use? If you are in Nepal and using android cell phone then you must have install Esewa, COA, ClassifiAd, Loadshedding, Yellow App applications from play store right now. Why? Why I’m telling you that? Please take your time to get the reasons.

Here are the 5 Android Applications that You Must Install…

1. eSewa – Mobile Wallet (Nepal)

eSewa is your wallet in the web and in your mobile device. It is the Digital Payment Portal of Nepal enabled with hosted wallet both Internet and mobile wallet along with new and unique services like VISA Prepaid Card, Payout Agent (Cash in and Cash out) and different payment facilities. eSewa account can be recharged through various option such as Mobile Banking, Internet Banking and counter deposit through member banks, fund transfer from another eSewa user. The fund in eSewa account can be used for utility payments, buying Recharge cards, making payments when purchasing online and making payments when purchasing through offline stores by accessing eSewa account through web or mobile. eSewa also facilitates: WAllet to wallet, Wallet to bank, Bank tp wallet, Wallet to remittance transactions.

Find eSewa – Mobile Wallet (Nepal) at Google Play Store

2. COA

COA, formerly known as CashOnAd, rewards you for simply viewing the ads for 6 seconds or more on an incoming call. In addition to that, COA also allows you to earn rewards simply by viewing the lock screen ads & unlocking your mobile phones.

Find COA at Google Play Store

3. ClassifiAd – Buy and Sell

ClassifiAd (Classify Ads) is a free classified advertisement application which provides online market place where individuals as well as companies could come together, meet and trade (i.e. buy & sell) variety of new or used product online easily. As a seller, it offers to post your classified ads and get user interactions (comments, emails, contact sellers, like/favorite) against posted Ads including real-time analytics, mark Ad(s) as sold or delete. As a buyer, search Ad(s) with certain keyword/category and get a synopsis of the products displayed in the ads before making a purchase decision.

Find ClassifiAd – Buy and Sell at Google Play Store

4. Nepal Loadshedding Schedule

Loadshedding is annoying!! Be smart enough to plan your time efficiently!! Introducing a smarter way to view and track daily load-shedding schedule in Nepal for all the android smartphones and tablet users. You can now set your loadshedding GROUP, view the schedule along with Power ON/OFF status, remaining COUNTDOWN time, and the NOTIFICATION regarding the upcoming power cut. You can also place the home screen widgets for multiple groups – may be one for your HOME and another for your OFFICE or SHOP. The system also facilitates you to find out the loadshedding group by places through the location search and the custom Google-maps feature Key Features 1. View Schedule offline once downloaded 2. Power ON/OFF status with Remaining Time Countdown 3. Smart Notifications before Power OFF/ON 4. Search loadshedding GROUP by LOCATION 5. Google Maps to find group using GPS 6. Multiple Widgets – For Your Home ,Office , Shop e.t.c 7. New Widget to view ALL 7 Groups Status 8. Schedule in Nepali Language 9. View Schedule with Date/Time in B.S/A.D 10. Forward Schedule through SMS 11. Auto Update of Schedule Changes

Find Nepal Loadshedding Schedule at Google Play Store

5. Yellow App

YELLOW is the location based search service of restaurants on the go. With YELLOW app on your smart phone, you can discover the nearby restaurants with their full fledged information including phone number, pictures, direction to get there and more. Restaurant business listing being at its the core, YELLOW lets you serendipitously discover their offers/discounts and events. How does it work? With the YELLOW subscription, restaurant business owners get the YELLOW dashboard (Web back-end) where they can add/update their business information, add discount offers, events. When the data is synced with our Android application, users can access the data instantaneously.

Find Yellow App at Google Play Store

Best High Ranking PHP Frameworks for Web Developers

Today I’m going to share the most high ranking PHP frameworks for web developers to achieve the high performance. Based on research in many web sites and my experience I’m sharing this information.

1. Symfony

Symfony created in 2005 a very powerful MVC Framework, Drupal the most popular Open-Source CMS uses Symfony components.

Faster and less greedy
Unlimited flexiblity
Ease of use
Stable and sustainable
A driver of innovation

More Info

2. Zend

Zend Framework is based on simplicity, object-oriented best practices, leading provider of software and services for developing, deploying and managing business-critical applications in PHP.

Agile Design
Continuous Delivery
Cloud Scale

More Info

3. Laravel

Larvael is very fast growing PHP Framework and very easy to learn and use.

RESTful Routing
Command Your Data
Beautiful Templating
Proven Foundation

More Info

4. Cake PHP

CakePHP is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.

Build Quickly
No Configuration
Friendly License
Batteries Included
Clean MVC Conventions

More Info

5. YII

Yii is the most popular PHP framework and its last updated 1.1.14 version on 11th August 2013.


loads the features that you need
Powerful caching support
Explicitly designed to work efficiently with AJAX


Input validation
Output filtering
SQL injection and Cross-site scripting prevention


Helps you develop clean and reusable code
Follows the MVC pattern
Ensuring a clear separation of logic and presentation

More Info

6. CodeIgniter

CodeIgniter comes 2nd in our ranking and its very powerful framework in PHP simple and elegant toolkit to create full-featured web applications.

Exceptional performance.
Nearly zero configuration.
Clear, thorough documentation.
Framework with a small footprint.
Simple solutions to complexity.

More Info

Backup Your MySQL Database Using PHP

Here is the script to backup MySql database using php. Cheers!

// Check via PhpMyAdmin to see what character database is using
mysql_query('SET NAMES utf8');
mysql_query('SET CHARACTER SET utf8');
$tables = '*';
//get all of the tables
if($tables == '*')
    $tables = array();
    $result = mysql_query('SHOW TABLES');
    while($row = mysql_fetch_row($result)) {
    $tables[] = $row[0];
    $tables = is_array($tables) ? $tables : explode(',',$tables);
//cycle through
foreach($tables as $table)
    $result = mysql_query('SELECT * FROM '.$table);
    $num_fields = mysql_num_fields($result);
    $return.= 'DROP TABLE '.$table.';';
    $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
    $return.= "\n\n".$row2[1].";\n\n";
    for ($i = 0; $i < $num_fields; $i++)
        while($row = mysql_fetch_row($result))
            $return.= 'INSERT INTO '.$table.' VALUES('; for($j=0; $j<$num_fields; $j++) { $row[$j] =             addslashes($row[$j]);
            $row[$j] = ereg_replace("\n","\\n",$row[$j]);
            if (isset($row[$j]))
                $return.= '"'.$row[$j].'"' ;
                $return.= '""';
            if ($j<($num_fields-1))
                $return.= ',';
        $return.= ");\n";
//save file
$handle = fopen('backups/db-backup-'.date('Y-m-d H:i:s').'-'.(md5(implode(',',$tables))).'.sql','w+'); fwrite($handle,$return); fclose($handle); if($handle)
    echo "database is successfully stored in backups directory.";
    echo "database backup unsuccessfuly.";

What do you mean by data warehouse? Explain the query manager.

Data Warehouse :

In computing, a data warehouse (DWDWH), or an enterprise data warehouse (EDW), is a system used for reporting and data analysis. Integrating data from one or more disparate sources creates a central repository of data, a data warehouse (DW). Data warehouses store current and historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons.

The data stored in the warehouse is uploaded from the operational systems (such as marketing, sales, etc., shown in the figure to the right). The data may pass through an operational data store for additional operations before it is used in the DW for reporting.

A data warehouse maintains a copy of information from the source transaction systems. This architectural complexity provides the opportunity to :

  • Congregate data from multiple sources into a single database so a single query engine can be used to present data.
  • Mitigate the problem of database isolation level lock contention in transaction processing systems caused by attempts to run large, long running, analysis queries in transaction processing databases.
  • Maintain data history, even if the source transaction systems do not.
  • Integrate data from multiple source systems, enabling a central view across the enterprise. This benefit is always valuable, but particularly so when the organization has grown by merger.
  • Improve data quality, by providing consistent codes and descriptions, flagging or even fixing bad data.
  • Present the organization’s information consistently.
  • Provide a single common data model for all data of interest regardless of the data’s source.
  • Restructure the data so that it makes sense to the business users.
  • Restructure the data so that it delivers excellent query performance, even for complex analytic queries, without impacting the operational systems.
  • Add value to operational business applications, notably customer relationship management (CRM) systems.
  • Making decision–support queries easier to write.

Query Manager : 

The query manager the system component that performs all the operations necessary to support the query management process. The system is typically constructed using a combination of user access tasks, data warehousing monitor tools , native database facilities and shell script.

The architecture of query manager perform following operations :

– Direct queries to the appropriate table

– Schedule the execution of the user queries

What is data mining? What are the functions of data mining? Write about association analysis with an example.

Data Mining :

Generally, data mining (sometimes called data or knowledge discovery) is the process of analyzing data from different perspectives and summarizing it into useful information – information that can be used to increase revenue, cuts costs, or both. Data mining software is one of a number of analytical tools for analyzing data. It allows users to analyze data from many different dimensions or angles, categorize it, and summarize the relationships identified. Technically, data mining is the process of finding correlations or patterns among dozens of fields in large relational databases.

Data mining is primarily used today by companies with a strong consumer focus – retail, financial, communication, and marketing organizations. It enables these companies to determine relationships among “internal” factors such as price, product positioning, or staff skills, and “external” factors such as economic indicators, competition, and customer demographics. And, it enables them to determine the impact on sales, customer satisfaction, and corporate profits. Finally, it enables them to “drill down” into summary information to view detail transactional data.

Functions of Data Mining :

1. Class Description
2. Association
3. Classification
4. Prediction
5. Clustering
6. Time-series analysis

Association Analysis :

The purpose of association analysis is to find patterns in particular in business processes and to formulate suitable rules, of the sort “If a customer buys product A, that customer also buys products B and C”.

Tip : If a customer buys mozzarella at the supermarket, that customer also buys tomatoes and basil.

Association analysis also helps you to identify cross-selling opportunities, for example. You can use the rules resulting from the analysis to place associated products together in a catalog, in the supermarket, or in the Web shop, or apply them when targeting a marketing campaign for product C at customers who have already purchased product A.
Association analysis determines these rules by using historic data to train the model. You can display and export the determined association rules.

Rakshabandhan (रक्षाबन्धन)

हिन्दुहरूको धार्मिक तथा साँस्कृतिक पर्व जनै पूर्णिमा नयाँ यज्ञोपवित धारणा तथा रक्षा-बन्धन गरी धुमधामका साथ मनाइन्छ । तागाधारी जातिले अघिल्लो दिनदेखि नै चोखोनितो गरी एक छाक खाने, आजका दिन बिहानै नदी, तलाउमा गई गाईको गोबर तथा तुलसीको माटो लगाई नुहाउने तथा जौ, तिल, कुशद्वारा ऋषितर्पणी गरी वैदिक विधिपूर्वक मन्त्रिएको नयाँ जनै (यज्ञोपवित) फेर्ने चलन रहेकाले यस पर्वलाई जनै पूर्णीमा भन्ने गरिएको हो । सत्ययुगमा दानवद्वारा लखेटिएका देवगणलाई गुरु बृहस्पतिले रक्षा विधान तयार गरी जे चिजले अत्यन्त बलशाली दानवराज बलि बाँधिए, त्यसले नै म तिमीलाई बाँध्छु, यसले तिमी सुरक्षित वन, विचलित नहोऊ भनी डोरो बाँधेर जोगाएका थिए भन्ने पौराणिक मान्यताका आधारमा चलेकोे रक्षाबन्धनको परम्परा आज पनि प्रचलित छ ।

यसैकारण रक्षाबन्धन गर्ने बेलामा गुरु पुरोहितले

“येन बद्धो बलिराजा दानवेन्द्रो महाबल तेन त्वाम् प्रतिबध्नामी रक्षेमा चलमा चल”

भनी रक्षासूत्र रक्षाबन्धन अथवा डोरो बाँध्ने वैदिक परम्परा रहिआएको छ । मानव रक्षाका लागि जप, तप र पूजा गरी मन्त्रिएको रक्षाबन्धन वैदिक परम्पराको मन्त्रोच्चारण गर्दै ब्राहृमण पुरोहितले यजमानको नाडीमा बाँधिदिने परम्परा छ ।

रक्षाबन्धन मर्यादा र आत्मा निग्रहद्वारा मृत्युमाथि विजय प्राप्त गर्ने पर्व हो । रक्षासूत्रको बन्धन र टिका यस उत्सवको प्रमुख विधान हो । सूत्र आत्माको मयादा र संयमको प्रतीक हो र टिका आत्म स्वरुप स्थितिमा स्थित हुने प्रतीक हो । सूत्र कुनैपनि वस्तुलाई अविच्छिन गर्ने वस्तु हो । सुनियोजित एवं सुव्यवस्थित वस्तु एक सूत्रमा ग्रथित मानिन्छ । रक्षाबन्धनको सही अर्थ आफू आत्म स्थितिमा अचल, अडोल भएर पवित्रताको पालन गर्नु हो किनकि पवित्रताद्वारा नै मृत्युमाथि विजय प्राप्त गर्न सकिन्छ ।